-- MySQL dump 10.9
--
-- Host: localhost    Database: MIP
-- ------------------------------------------------------
-- Server version	4.1.12

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `fold_change`
--

DROP TABLE IF EXISTS `fold_change`;
CREATE TABLE `fold_change` (
  `Comparison` enum('BM','BT','MT','012w12','w10w12','w10w8','w12w8') NOT NULL default 'BM',
  `ID` varchar(15) NOT NULL default '',
  `Name` varchar(200) default NULL,
  `Tigr_ID` varchar(20) default NULL,
  `Putative_Annotation` text,
  `geneNum` int(11) default NULL,
  `Estimate` float default NULL,
  `StdErr` float default NULL,
  `T_value` float default NULL,
  `foldChange` float default NULL,
  `P_value` float default NULL,
  `Q_value` float default NULL,
  KEY `ID` (`ID`),
  KEY `Q_value` (`Q_value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;