CREATE TABLE `pairsdb_90x90` ( `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=(pairsdb_90x90_1M,pairsdb_90x90_2M,pairsdb_90x90_3M,pairsdb_90x90_4M,pairsdb_90x90_5M,pairsdb_90x90_6M,pairsdb_90x90_7M,pairsdb_90x90_8M,pairsdb_90x90_9M,pairsdb_90x90_10M,pairsdb_90x90_11M) INSERT_METHOD=LAST; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000; # CREATE TABLE `pairsdb_90x90_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 AUTO_INCREMENT=4088816 AVG_ROW_LENGTH=2000;