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

#
# Table structure for table 'genome_species'
#

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