CREATE TABLE `genome_sequence` (
      `protein` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `sequence` text,
      `length` mediumint(9) unsigned NOT NULL DEFAULT '0',
      `loaded` enum('no','yes') NOT NULL DEFAULT 'no',
      PRIMARY KEY (`protein`),
      UNIQUE KEY `search` (`protein`,`length`),
      KEY `prefilter` (`sequence`(9)),
      KEY `idx_len_seq` (`length`,`sequence`(9))
) ENGINE=InnoDB AUTO_INCREMENT=114190985 DEFAULT CHARSET=latin1
