CREATE TABLE `predictors_compared` (
  `protein` int(10) unsigned NOT NULL,
  `pred1` smallint(3) NOT NULL,
  `pred2` smallint(3) NOT NULL,
  `num_aminos_agree` smallint(5) unsigned NOT NULL,
  `percent_pred1_agree` float(7,4) unsigned NOT NULL,
  `percent_protein_agree` float(7,4) unsigned NOT NULL,
  `num_aminos_overlapped_pred1` smallint(5) unsigned NOT NULL,
  `percent_pred1_overlapped` float(7,4) unsigned NOT NULL,
  `percent_protein_overlapped` float(7,4) unsigned NOT NULL,
  PRIMARY KEY (`protein`,`pred1`,`pred2`),
  KEY `compared_protein` (`protein`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
