# MySQL dump 8.16
#
# Host: pfam    Database: pfam_19_0
#--------------------------------------------------------
# Server version	4.1.10-standard

#
# Table structure for table 'genome_species'
#

CREATE TABLE genome_species (
  ncbi_code int(10) unsigned NOT NULL default '0',
  species varchar(100) default NULL,
  grouping varchar(20) default NULL,
  num_distinct_regions int(10) unsigned default NULL,
  num_total_regions int(10) unsigned default NULL,
  num_proteins int(10) unsigned default NULL,
  sequence_coverage int(3) unsigned default NULL,
  residue_coverage int(3) unsigned default NULL,
  total_genome_proteins int(10) unsigned default NULL,
  total_aa_length bigint(20) default NULL,
  PRIMARY KEY  (ncbi_code),
  KEY grouping (grouping)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
