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;