-- HOMD database SQL structure Dump -- http://www.homd.org -- Generation Time: Apr 29, 2010 at 09:50 AM -- Server version: 5.0.45 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `annotated_genome` -- -- -------------------------------------------------------- -- -- Table structure for table `contigs` -- CREATE TABLE IF NOT EXISTS `contigs` ( `id` int(11) NOT NULL auto_increment, `original` tinytext NOT NULL, `bps` int(11) NOT NULL default '0', `GC` float NOT NULL COMMENT 'percent GC', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `GC_count` -- CREATE TABLE IF NOT EXISTS `GC_count` ( `id` int(6) NOT NULL default '0', `contig` int(6) NOT NULL default '0', `start` int(11) NOT NULL default '0', `stop` int(11) NOT NULL default '0', `GC_percentage` float NOT NULL default '0', KEY `contig` (`contig`), KEY `start` (`start`), KEY `stop` (`stop`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `genome_seq` -- CREATE TABLE IF NOT EXISTS `genome_seq` ( `id` int(11) NOT NULL auto_increment, `contig` int(11) NOT NULL default '0', `order1` int(11) NOT NULL default '0', `seq` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2107 ; -- -------------------------------------------------------- -- -- Table structure for table `ip_topmatch` -- CREATE TABLE IF NOT EXISTS `ip_topmatch` ( `id` int(11) NOT NULL auto_increment, `ORF_id` int(11) NOT NULL default '0', `contig_id` int(11) NOT NULL default '0', `seq_name` varchar(30) NOT NULL default '', `db_name` varchar(6) NOT NULL default '', `pg_name` varchar(6) NOT NULL default '', `definition` tinytext NOT NULL, `def_name` tinytext, `sp_id` tinytext, `score` smallint(6) unsigned default NULL, `evalue` double unsigned default NULL, `all_def` text, `flag` tinyint(1) NOT NULL default '0', `mod_date` date NOT NULL default '2004-01-23', `mod_times` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `ORF_id` (`ORF_id`), KEY `seq_name` (`seq_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nr_topmatch` -- CREATE TABLE IF NOT EXISTS `nr_topmatch` ( `id` int(11) NOT NULL auto_increment, `ORF_id` int(11) NOT NULL default '0', `contig_id` int(11) NOT NULL default '0', `seq_name` varchar(30) NOT NULL default '', `top_def` tinytext NOT NULL, `top_def_name` tinytext, `top_def_score` smallint(6) unsigned NOT NULL, `top_def_evalue` double unsigned NOT NULL, `top_def_identities` float(4,2) NOT NULL, `best_def` tinytext, `best_def_name` tinytext, `best_def_score` smallint(6) unsigned default NULL, `best_def_evalue` double unsigned default NULL, `best_def_identities` float(4,2) default NULL, `top_def_org` tinytext, `top_def_org_name` tinytext, `top_def_org_score` smallint(6) unsigned default NULL, `top_def_org_evalue` double unsigned default NULL, `top_def_org_identities` float(4,2) default NULL, `all_def` text NOT NULL, `flag` tinyint(1) NOT NULL default '0', `mod_date` date NOT NULL default '2004-01-23', `mod_times` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `ORF_id` (`ORF_id`), KEY `seq_name` (`seq_name`), FULLTEXT KEY `all_def` (`all_def`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4954 ; -- -------------------------------------------------------- -- -- Table structure for table `ORF_seq` -- CREATE TABLE IF NOT EXISTS `ORF_seq` ( `id` int(11) NOT NULL auto_increment, `length` int(11) NOT NULL default '0', `gene_id` int(11) NOT NULL default '0', `name` varchar(30) NOT NULL default '', `contig_id` int(11) NOT NULL default '0', `start` int(11) NOT NULL default '0', `stop` int(11) NOT NULL default '0', `seq_na` text NOT NULL, `seq_aa` text NOT NULL, `partial1` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `name` (`name`), KEY `gene_id` (`gene_id`), KEY `contig_id` (`contig_id`), KEY `start` (`start`), KEY `stop` (`stop`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8620 ; -- -------------------------------------------------------- -- -- Table structure for table `orf_sp_dr` -- CREATE TABLE IF NOT EXISTS `orf_sp_dr` ( `orf_id` int(11) NOT NULL default '0', `sp_id` varchar(20) NOT NULL default '', `dr` varchar(20) NOT NULL default '', `dr_id` varchar(20) NOT NULL default '', KEY `dr_id` (`dr_id`), KEY `sp_id` (`sp_id`), KEY `orf_id` (`orf_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sp_topmatch` -- CREATE TABLE IF NOT EXISTS `sp_topmatch` ( `id` int(11) NOT NULL auto_increment, `ORF_id` int(11) NOT NULL default '0', `contig_id` int(11) NOT NULL default '0', `seq_name` varchar(30) NOT NULL default '', `db_name` varchar(6) NOT NULL default '', `pg_name` varchar(6) NOT NULL default '', `definition` tinytext NOT NULL, `def_name` tinytext, `sp_id` tinytext, `score` smallint(6) unsigned default NULL, `evalue` double unsigned default NULL, `all_def` text, `flag` tinyint(1) NOT NULL default '0', `mod_date` date NOT NULL default '2004-01-23', `mod_times` int(11) NOT NULL default '1', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `ORF_id` (`ORF_id`), KEY `seq_name` (`seq_name`), FULLTEXT KEY `all_def` (`all_def`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4189374 ;