CREATE TABLE `context_pfam_regions` (
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned NOT NULL default '0',
  `seq_end` mediumint(8) unsigned NOT NULL default '0',
  `domain_score` double(16,2) default NULL,
  KEY `auto_pfamseq` (`auto_pfamseq`),
  KEY `auto_pfamA` (`auto_pfamA`)
) TYPE=MyISAM

CREATE TABLE `dead_families` (
  `pfamA_acc` varchar(7) NOT NULL default '',
  `pfamA_id` varchar(40) NOT NULL default '',
  `comment` mediumtext,
  `forward_to` varchar(7) default NULL,
  UNIQUE KEY `pfamA_acc` (`pfamA_acc`)
) TYPE=MyISAM

CREATE TABLE `interpro_and_go` (
  `auto_interpro` int(10) unsigned NOT NULL auto_increment,
  `interpro_id` tinytext,
  `interpro_abstract` longtext,
  `go_function` tinytext,
  `go_component` tinytext,
  `go_process` tinytext,
  PRIMARY KEY  (`auto_interpro`)
) TYPE=MyISAM

CREATE TABLE `literature_references` (
  `auto_lit` int(10) unsigned NOT NULL auto_increment,
  `medline` int(10) unsigned NOT NULL default '0',
  `title` tinytext,
  `author` tinytext,
  `journal` tinytext,
  PRIMARY KEY  (`auto_lit`),
  UNIQUE KEY `medline` (`medline`)
) TYPE=MyISAM

CREATE TABLE `nested_domains` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `nests_auto_pfamA` int(10) unsigned NOT NULL default '0',
  KEY `auto_pfamA` (`auto_pfamA`),
  KEY `nests_auto_pfamA` (`nests_auto_pfamA`)
) TYPE=MyISAM

CREATE TABLE `other_reg` (
  `region_id` int(10) unsigned NOT NULL auto_increment,
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned NOT NULL default '0',
  `seq_end` mediumint(6) unsigned NOT NULL default '0',
  `type_id` varchar(20) NOT NULL default '',
  `source_id` varchar(20) NOT NULL default '',
  `score` double(16,4) default NULL,
  `orientation` varchar(4) default NULL,
  PRIMARY KEY  (`region_id`),
  KEY `auto_pfamseq` (`auto_pfamseq`),
  KEY `type_id` (`type_id`)
) TYPE=MyISAM

CREATE TABLE `pdb` (
  `auto_pdb` int(10) unsigned NOT NULL auto_increment,
  `pdb_id` varchar(5) NOT NULL default '',
  `header` tinytext,
  `title` mediumtext,
  PRIMARY KEY  (`auto_pdb`),
  UNIQUE KEY `pdb_id` (`pdb_id`)
) TYPE=MyISAM

CREATE TABLE `pdbmap` (
  `auto_pdb` int(10) unsigned NOT NULL default '0',
  `chain` char(2) default NULL,
  `pdb_start_res` varchar(10) default NULL,
  `pdb_end_res` varchar(10) default NULL,
  `auto_pfam` int(10) unsigned NOT NULL default '0',
  `pfam_region` tinyint(4) default NULL,
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `pfam_start_res` varchar(10) default NULL,
  `pfam_end_res` varchar(10) default NULL,
  `complex` tinyint(4) default NULL,
  KEY `auto_pdb` (`auto_pdb`),
  KEY `auto_pfam` (`auto_pfam`)
) TYPE=MyISAM

CREATE TABLE `pfamA` (
  `auto_pfamA` int(10) unsigned NOT NULL auto_increment,
  `pfamA_acc` varchar(7) NOT NULL default '',
  `pfamA_id` varchar(40) NOT NULL default '',
  `description` varchar(100) default NULL,
  `model_length` mediumint(8) unsigned default NULL,
  `author` tinytext,
  `seed_source` tinytext,
  `alignment_method` tinytext,
  `type` tinytext,
  `ls_sequence_GA` double(16,4) default NULL,
  `ls_domain_GA` double(16,4) default NULL,
  `fs_sequence_GA` double(16,4) default NULL,
  `fs_domain_GA` double(16,4) default NULL,
  `ls_sequence_TC` double(16,4) default NULL,
  `ls_domain_TC` double(16,4) default NULL,
  `fs_sequence_TC` double(16,4) default NULL,
  `fs_domain_TC` double(16,4) default NULL,
  `ls_sequence_NC` double(16,4) default NULL,
  `ls_domain_NC` double(16,4) default NULL,
  `fs_sequence_NC` double(16,4) default NULL,
  `fs_domain_NC` double(16,4) default NULL,
  `ls_mu` double(16,4) default NULL,
  `ls_kappa` double(16,4) default NULL,
  `fs_mu` double(16,4) default NULL,
  `fs_kappa` double(16,4) default NULL,
  `comment` longtext,
  `previous_id` tinytext,
  `hmmbuild_ls` tinytext,
  `hmmcalibrate_ls` tinytext,
  `hmmbuild_fs` tinytext,
  `hmmcalibrate_fs` tinytext,
  `num_seed` int(10) unsigned default NULL,
  `num_full` int(10) unsigned default NULL,
  PRIMARY KEY  (`auto_pfamA`),
  UNIQUE KEY `pfamA_acc` (`pfamA_acc`),
  KEY `pfamA_id` (`pfamA_id`)
) TYPE=MyISAM

CREATE TABLE `pfamA_database_links` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `db_id` tinytext NOT NULL,
  `comment` tinytext,
  `db_link` tinytext NOT NULL,
  `other_params` tinytext,
  KEY `auto_pfamA` (`auto_pfamA`)
) TYPE=MyISAM

CREATE TABLE `pfamA_literature_references` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `auto_lit` int(10) unsigned NOT NULL default '0',
  `comment` tinytext,
  `order_added` tinyint(4) default NULL,
  KEY `auto_pfamA` (`auto_pfamA`)
) TYPE=MyISAM

CREATE TABLE `pfamA_reg_full` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned default NULL,
  `seq_end` mediumint(8) unsigned default NULL,
  `model_start` mediumint(8) unsigned default NULL,
  `model_end` mediumint(8) unsigned default NULL,
  `domain_bits_score` double(16,4) default NULL,
  `domain_evalue_score` varchar(15) default NULL,
  `sequence_bits_score` double(16,4) default NULL,
  `sequence_evalue_score` varchar(15) default NULL,
  `mode` char(2) default NULL,
  `significant` tinyint(4) default NULL,
  `in_full` tinyint(4) default NULL,
  `tree_order` mediumint(9) default NULL,
  KEY `auto_pfamA` (`auto_pfamA`),
  KEY `auto_pfamseq` (`auto_pfamseq`)
) TYPE=MyISAM

CREATE TABLE `pfamA_reg_seed` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned NOT NULL default '0',
  `seq_end` mediumint(8) unsigned default NULL,
  KEY `auto_pfamA` (`auto_pfamA`),
  KEY `auto_pfamseq` (`auto_pfamseq`)
) TYPE=MyISAM

CREATE TABLE `pfamB` (
  `auto_pfamB` int(10) unsigned NOT NULL auto_increment,
  `pfamB_acc` char(8) NOT NULL default '',
  `pfamB_id` char(12) NOT NULL default '',
  PRIMARY KEY  (`auto_pfamB`),
  KEY `pfamB_acc` (`pfamB_acc`)
) TYPE=MyISAM

CREATE TABLE `pfamB_reg` (
  `auto_pfamB` int(10) unsigned NOT NULL default '0',
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned NOT NULL default '0',
  `seq_end` mediumint(8) unsigned NOT NULL default '0',
  KEY `auto_pfamseq` (`auto_pfamseq`),
  KEY `auto_pfamB` (`auto_pfamB`)
) TYPE=MyISAM

CREATE TABLE `pfam_to_interpro` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `auto_interpro` int(10) unsigned NOT NULL default '0',
  KEY `auto_pfamA` (`auto_pfamA`),
  KEY `auto_interpro` (`auto_interpro`)
) TYPE=MyISAM

CREATE TABLE `pfamseq` (
  `auto_pfamseq` int(10) unsigned NOT NULL auto_increment,
  `pfamseq_id` varchar(12) NOT NULL default '',
  `pfamseq_acc` varchar(6) NOT NULL default '',
  `crc64` varchar(16) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `length` mediumint(8) unsigned NOT NULL default '0',
  `species` varchar(100) NOT NULL default '',
  `taxonomy` mediumtext,
  `is_fragment` tinyint(4) default NULL,
  `version` varchar(6) default NULL,
  PRIMARY KEY  (`auto_pfamseq`),
  UNIQUE KEY `pfamseq_id` (`pfamseq_id`),
  KEY `crc64` (`crc64`),
  KEY `pfamseq_acc` (`pfamseq_acc`)
) TYPE=MyISAM

CREATE TABLE `rosetta_pfam_structures` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `structure` varchar(15) default NULL,
  `model_num` tinyint(4) default NULL,
  `auto_pdb` int(10) unsigned default NULL,
  `chain` varchar(4) default NULL,
  `mammoth_Z_score` double(10,8) default NULL,
  `length_ratio` double(6,4) default NULL
) TYPE=MyISAM

CREATE TABLE `rosetta_pfam_values` (
  `auto_pfamA` int(10) unsigned NOT NULL default '0',
  `group_confidence` double(6,4) default NULL,
  `scop_confidence` double(6,4) default NULL,
  PRIMARY KEY  (`auto_pfamA`)
) TYPE=MyISAM

CREATE TABLE `smart` (
  `auto_smart` int(10) unsigned NOT NULL auto_increment,
  `smart_acc` varchar(7) NOT NULL default '',
  `smart_id` varchar(40) default NULL,
  PRIMARY KEY  (`auto_smart`)
) TYPE=MyISAM

CREATE TABLE `smart_regions` (
  `auto_smart` int(10) unsigned NOT NULL default '0',
  `auto_pfamseq` int(10) unsigned NOT NULL default '0',
  `seq_start` mediumint(8) unsigned default NULL,
  `seq_end` mediumint(8) unsigned default NULL,
  `domain_bits_score` double(16,4) default NULL,
  `domain_evalue_score` varchar(15) default NULL,
  KEY `auto_smart` (`auto_smart`),
  KEY `auto_pfamseq` (`auto_pfamseq`)
) TYPE=MyISAM

