-- 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: `genome`
--

-- --------------------------------------------------------

--
-- 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,
  `molecule_id` int(11) NOT NULL default '0',
  `mol_order` int(11) NOT NULL default '0',
  `seq` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4341 ;

-- --------------------------------------------------------

--
-- Table structure for table `molecules`
--

CREATE TABLE IF NOT EXISTS `molecules` (
  `id` int(11) NOT NULL auto_increment,
  `accession` varchar(30) NOT NULL default '',
  `name` tinytext NOT NULL,
  `bps` int(11) NOT NULL default '0',
  `GC` float NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

--
-- Table structure for table `ORF_seq`
--

CREATE TABLE IF NOT EXISTS `ORF_seq` (
  `id` int(11) NOT NULL auto_increment,
  `mol_id` int(11) NOT NULL default '0',
  `length` int(11) NOT NULL default '0',
  `gene` varchar(20) default '0',
  `synonym` varchar(20) default NULL,
  `PID` varchar(20) default NULL,
  `code` varchar(20) default NULL,
  `COD` varchar(20) default NULL,
  `product` tinytext,
  `start` int(11) NOT NULL default '0',
  `stop` int(11) NOT NULL default '0',
  `seq_na` text,
  `seq_aa` text,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `PID` (`PID`),
  KEY `start` (`start`),
  KEY `stop` (`stop`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3859 ;

-- --------------------------------------------------------

--
-- Table structure for table `rnt`
--

CREATE TABLE IF NOT EXISTS `rnt` (
  `id` int(11) NOT NULL,
  `mod_id` tinyint(4) NOT NULL,
  `start` int(11) NOT NULL,
  `stop` int(11) NOT NULL,
  `length` int(11) NOT NULL,
  `PID` varchar(20) default NULL,
  `gene` varchar(20) default NULL,
  `synonym` varchar(20) default NULL,
  `code` varchar(20) default NULL,
  `COD` varchar(20) default NULL,
  `product` tinytext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;