CREATE TABLE `psiblast_40x40` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0',
  KEY `query_index` (`query_nid`)
) ENGINE=MERGE 
UNION=(psiblast_40x40_1M,psiblast_40x40_2M,psiblast_40x40_3M,psiblast_40x40_4M,psiblast_40x40_5M,psiblast_40x40_6M,psiblast_40x40_7M,psiblast_40x40_8M,psiblast_40x40_9M, psiblast_40x40_10M, psiblast_40x40_11M) 
INSERT_METHOD=LAST;
# 
CREATE TABLE `psiblast_40x40_1M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_2M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_3M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_4M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_5M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_6M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_7M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_8M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
# 
CREATE TABLE `psiblast_40x40_9M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
#
CREATE TABLE `psiblast_40x40_10M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
CREATE TABLE `psiblast_40x40_11M` (
  `query_nid` int(10) unsigned NOT NULL default '0',
  `sbjct_nid` int(10) unsigned NOT NULL default '0',
  `evalue` float(13,10) NOT NULL default '0.0000000000',
  `query_from` smallint(5) unsigned NOT NULL default '0',
  `query_to` smallint(5) unsigned NOT NULL default '0',
  `query_ali` blob NOT NULL,
  `sbjct_from` smallint(5) unsigned NOT NULL default '0',
  `sbjct_to` smallint(5) unsigned NOT NULL default '0',
  `sbjct_ali` blob NOT NULL,
  `score` smallint(5) NOT NULL default '0',
  `percent_identity` tinyint(3) NOT NULL default '0'
  KEY `query_index` (`query_nid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

