     contact varchar(255) NULL DEFAULT NULL,
     supplementary_file varchar(255) NULL,
     exp_id varchar(200) NULL DEFAULT '',
-    experiment_datasetX_exp_i int(11) NOT NULL,
+    experiment_datasetX_exp_i int(16) NOT NULL,
     CONSTRAINT sample_datasetX_pk PRIMARY KEY (sample_i)
 ) ENGINE MyISAM CHARACTER SET latin1;
 


-- Table: gene_go
CREATE TABLE gene_go (
    go_i int(11) NOT NULL,
    gene_i int(11) NOT NULL,
    gene_info_gene_i int(11) NOT NULL,
    go_info_go_i int(11) NOT NULL,
    CONSTRAINT gene_go_pk PRIMARY KEY (go_i,gene_i)
) ENGINE MyISAM CHARACTER SET latin1;

CREATE INDEX gene_i ON gene_go (gene_i);

-- Table: gene_info
CREATE TABLE gene_info (
    gene_i int(11) NOT NULL,
    gene_id varchar(60) CHARACTER SET utf8 NULL DEFAULT '',
    description varchar(255) NOT NULL DEFAULT '""',
    synonyms varchar(255) NOT NULL DEFAULT '',
    has_exp tinyint(1) NOT NULL DEFAULT '0',
    cluster varchar(1) NOT NULL DEFAULT '',
    at_desc varchar(255) NULL DEFAULT '',
    at_ortholog varchar(15) NULL DEFAULT '',
    at_syn varchar(255) NULL DEFAULT '',
    degree smallint(5) NULL DEFAULT '0',
    btw_rank smallint(5) NULL DEFAULT '0',
    close_rank smallint(5) NULL DEFAULT '0',
    avg_neigh_deg float NULL DEFAULT '0',
    CONSTRAINT gene_info_pk PRIMARY KEY (gene_i)
) ENGINE MyISAM CHARACTER SET latin1;

CREATE INDEX gene_id ON gene_info (gene_id);

-- Table: go_info
CREATE TABLE go_info (
    go_i int(11) NOT NULL AUTO_INCREMENT,
    go_id varchar(255) NULL DEFAULT NULL,
    name_space varchar(255) NULL DEFAULT 'unknown',
    description varchar(255) NULL DEFAULT NULL,
    CONSTRAINT go_info_pk PRIMARY KEY (go_i)

CREATE INDEX atg_id ON transcript_atg (atg_id);

-- Table: transcript_info
CREATE TABLE `transcript_info` (
  `transcript_i` mediumint(16) unsigned NOT NULL AUTO_INCREMENT,
  `transcript_id` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `pac_id` int(16) DEFAULT NULL,
  `transcript_start` int(16) unsigned DEFAULT NULL,
  `transcript_end` int(16) unsigned DEFAULT NULL,
  `gene_id` varchar(16) DEFAULT NULL,
  `chromosome_name` varchar(20) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `gene_i` mediumint(16) unsigned DEFAULT NULL,
  PRIMARY KEY (`transcript_i`),
  KEY `transcript_id` (`transcript_id`)
);

-- foreign keys
-- Reference: correlation_datasetX_clr_gene_info (table: correlation_datasetX_clr)
