TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT NULL DurandLab2 ygob_species BASE TABLE InnoDB 10 Compact 7 2340 16384 0 0 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 prot_seq_source_ver BASE TABLE InnoDB 10 Compact 8 2048 16384 0 32768 0 13 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB; (`source_id`) REFER `DurandLab2`.`prot_seq_source`(`source_id NULL DurandLab2 nc_run BASE TABLE InnoDB 10 Compact 10 1638 16384 0 32768 0 718 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB; (`br_id`) REFER `DurandLab2`.`blast_run`(`br_id`) NULL DurandLab2 prot_seq_set BASE TABLE InnoDB 10 Compact 13 1260 16384 0 32768 0 87 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 ygob_locus_class BASE TABLE InnoDB 10 Compact 14 1170 16384 0 16384 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 blast_run BASE TABLE InnoDB 10 Compact 19 862 16384 0 32768 0 84 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB; (`set_id`) REFER `DurandLab2`.`prot_seq_set`(`set_id`) NULL DurandLab2 family BASE TABLE InnoDB 10 Compact 20 819 16384 0 49152 0 21 2007-05-25 15:34:21 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 sp_feature_key_str BASE TABLE InnoDB 10 Compact 38 431 16384 0 32768 0 39 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 prot_seq_source BASE TABLE InnoDB 10 Compact 77 212 16384 0 32768 0 78 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 sp_keyword_str BASE TABLE InnoDB 10 Compact 879 93 81920 0 65536 0 882 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 family_member BASE TABLE InnoDB 10 Compact 1893 43 81920 0 49152 0 NULL 2007-06-29 11:37:18 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`family_ NULL DurandLab2 kog BASE TABLE InnoDB 10 Compact 5132 86 442368 0 196608 0 5315 2007-06-06 15:50:20 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB NULL DurandLab2 kog_member_20070606 BASE TABLE InnoDB 10 Compact 5965 63 376832 0 147456 0 NULL 2007-06-06 15:50:21 NULL NULL latin1_swedish_ci NULL InnoDB free: 0 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`kog_id` NULL DurandLab2 blast_lock BASE TABLE InnoDB 10 Compact 6558 237 1556480 0 147456 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB; (`br_id`) REFER `DurandLab2`.`blast_run`(`br_id`); (`set_i NULL DurandLab2 hgnc_20070521 BASE TABLE InnoDB 10 Compact 25719 367 9453568 0 0 0 NULL 2007-05-23 14:46:40 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB NULL DurandLab2 ygob_gene BASE TABLE InnoDB 10 Compact 34895 75 2637824 0 7438336 0 117557 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB; (`locus_class`) REFER `DurandLab2`.`ygob_locus_class`(`loc NULL DurandLab2 ygob_pillar BASE TABLE InnoDB 10 Compact 150815 45 6832128 0 5783552 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB; (`source_gidx`) REFER `DurandLab2`.`ygob_gene`(`ygob_gidx` NULL DurandLab2 prot_seq_set_member BASE TABLE InnoDB 10 Compact 347852 31 11026432 0 6782976 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB; (`set_id`) REFER `DurandLab2`.`prot_seq_set`(`set_id`); (` NULL DurandLab2 #sql-3c41_2 BASE TABLE InnoDB 10 Compact 3030294 61 185303040 0 265273344 0 3030001 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB NULL DurandLab2 prot_seq_str BASE TABLE InnoDB 10 Compact 3471354 415 1441792000 0 198770688 0 3216365 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB NULL DurandLab2 #sql-3c93_2 BASE TABLE InnoDB 10 Compact 6620368 61 404701184 0 566771712 0 6620001 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 7168 kB NULL DurandLab2 sp_feature BASE TABLE InnoDB 10 Compact 6825764 58 402538496 0 226852864 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 5120 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`feat NULL DurandLab2 prot_seq BASE TABLE InnoDB 10 Compact 7097764 45 321765376 0 268861440 0 10585157 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 7168 kB; (`seq_str_id`) REFER `DurandLab2`.`prot_seq_str`(`seq_str_ NULL DurandLab2 sp_xtra BASE TABLE InnoDB 10 Compact 7204329 103 747634688 0 0 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 7168 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`) NULL DurandLab2 sp_gb_tax_id BASE TABLE InnoDB 10 Compact 7301289 28 209453056 0 0 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 7168 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`) NULL DurandLab2 prot_seq_accession BASE TABLE InnoDB 10 Compact 7741209 48 378535936 0 417054720 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 5120 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`sour NULL DurandLab2 prot_seq_version BASE TABLE InnoDB 10 Compact 12886120 52 682622976 0 758071296 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 4096 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`sour NULL DurandLab2 sp_keyword BASE TABLE InnoDB 10 Compact 13053337 51 665845760 0 227393536 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`keyw NULL DurandLab2 blast_hit_nc BASE TABLE InnoDB 10 Compact 15101449 55 839778304 0 1446494208 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 681984 kB; (`nc_id`) REFER `DurandLab2`.`nc_run`(`nc_id`); (`seq_id NULL DurandLab2 sp_cross_ref BASE TABLE InnoDB 10 Compact 28254112 59 1668284416 0 3016753152 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 7168 kB; (`seq_id`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`sour NULL DurandLab2 blast_hit_symmetric BASE TABLE InnoDB 10 Compact 37426794 50 1877999616 0 3582984192 0 NULL 2007-07-02 17:55:06 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB; (`seq_id_0`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`se NULL DurandLab2 blast_hit_xtra BASE TABLE InnoDB 10 Compact 48277356 183 8875147264 0 0 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB; (`br_id` `hit_rank` `seq_id_0` `seq_id_1`) REFER `DurandLa NULL DurandLab2 blast_hit BASE TABLE InnoDB 10 Compact 119890555 133 15994978304 0 15847014400 0 NULL 2007-03-05 10:33:23 NULL NULL latin1_swedish_ci NULL InnoDB free: 6144 kB; (`seq_id_0`) REFER `DurandLab2`.`prot_seq`(`seq_id`); (`se NULL DurandLab2 blast_hit_nc_tmp BASE TABLE MyISAM 10 Fixed 534858129 30 16045743870 8444249301319679 1024 0 NULL 2006-10-26 21:55:00 2006-10-27 00:19:45 NULL latin1_swedish_ci NULL