-- 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 ;