CREATE TABLE `genome_info` (
  `genome` char(3) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `num_sequences` int(11) unsigned NOT NULL,
  `num_aminos` int(11) unsigned NOT NULL,
  `min_seq_length` int(11) unsigned NOT NULL,
  `avg_seq_length` float(10,4) unsigned NOT NULL,
  `max_seq_length` int(11) unsigned NOT NULL,
  `stddev_seq_length` float(10,4) unsigned NOT NULL,
  `var_seq_length` float(10,4) unsigned NOT NULL,
  PRIMARY KEY (`genome`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
