+------------+
| TABLE_NAME |
+------------+
| GC_count   | 
+------------+
+---------------+---------+------+-----+---------+-------+
| Field         | Type    | Null | Key | Default | Extra |
+---------------+---------+------+-----+---------+-------+
| id            | int(6)  | NO   |     | 0       |       | 
| contig        | int(6)  | NO   | MUL | 0       |       | 
| start         | int(11) | NO   | MUL | 0       |       | 
| stop          | int(11) | NO   | MUL | 0       |       | 
| GC_percentage | float   | NO   |     | 0       |       | 
+---------------+---------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| ORF_seq    | 
+------------+
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| id        | int(11)     | NO   | PRI | NULL    | auto_increment | 
| length    | int(11)     | NO   |     | 0       |                | 
| gene_id   | int(11)     | NO   | MUL | 0       |                | 
| name      | varchar(30) | NO   | MUL | NULL    |                | 
| contig_id | int(11)     | NO   | MUL | 0       |                | 
| start     | int(11)     | NO   | MUL | 0       |                | 
| stop      | int(11)     | NO   | MUL | 0       |                | 
| seq_na    | text        | NO   |     | NULL    |                | 
| seq_aa    | text        | NO   |     | NULL    |                | 
| partial1  | tinyint(1)  | NO   |     | 0       |                | 
+-----------+-------------+------+-----+---------+----------------+
+------------+
| TABLE_NAME |
+------------+
| contigs    | 
+------------+
+----------+----------+------+-----+---------+----------------+
| Field    | Type     | Null | Key | Default | Extra          |
+----------+----------+------+-----+---------+----------------+
| id       | int(11)  | NO   | PRI | NULL    | auto_increment | 
| original | tinytext | NO   |     | NULL    |                | 
| bps      | int(11)  | NO   |     | 0       |                | 
| GC       | float    | NO   |     | NULL    |                | 
+----------+----------+------+-----+---------+----------------+
+------------+
| TABLE_NAME |
+------------+
| genome_seq | 
+------------+
+--------+---------+------+-----+---------+----------------+
| Field  | Type    | Null | Key | Default | Extra          |
+--------+---------+------+-----+---------+----------------+
| id     | int(11) | NO   | PRI | NULL    | auto_increment | 
| contig | int(11) | NO   |     | 0       |                | 
| order1 | int(11) | NO   |     | 0       |                | 
| seq    | text    | NO   |     | NULL    |                | 
+--------+---------+------+-----+---------+----------------+
+-------------+
| TABLE_NAME  |
+-------------+
| ip_topmatch | 
+-------------+
+------------+----------------------+------+-----+------------+----------------+
| Field      | Type                 | Null | Key | Default    | Extra          |
+------------+----------------------+------+-----+------------+----------------+
| id         | int(11)              | NO   | PRI | NULL       | auto_increment | 
| ORF_id     | int(11)              | NO   | MUL | 0          |                | 
| contig_id  | int(11)              | NO   |     | 0          |                | 
| seq_name   | varchar(30)          | NO   | MUL | NULL       |                | 
| db_name    | varchar(6)           | NO   |     | NULL       |                | 
| pg_name    | varchar(6)           | NO   |     | NULL       |                | 
| definition | tinytext             | NO   |     | NULL       |                | 
| def_name   | tinytext             | YES  |     | NULL       |                | 
| sp_id      | tinytext             | YES  |     | NULL       |                | 
| score      | smallint(6) unsigned | YES  |     | NULL       |                | 
| evalue     | double unsigned      | YES  |     | NULL       |                | 
| all_def    | text                 | YES  |     | NULL       |                | 
| flag       | tinyint(1)           | NO   |     | 0          |                | 
| mod_date   | date                 | NO   |     | 2004-01-23 |                | 
| mod_times  | int(11)              | NO   |     | 1          |                | 
+------------+----------------------+------+-----+------------+----------------+
+-------------+
| TABLE_NAME  |
+-------------+
| nr_topmatch | 
+-------------+
+------------------------+----------------------+------+-----+------------+----------------+
| Field                  | Type                 | Null | Key | Default    | Extra          |
+------------------------+----------------------+------+-----+------------+----------------+
| id                     | int(11)              | NO   | PRI | NULL       | auto_increment | 
| ORF_id                 | int(11)              | NO   | MUL | 0          |                | 
| contig_id              | int(11)              | NO   |     | 0          |                | 
| seq_name               | varchar(30)          | NO   | MUL | NULL       |                | 
| top_def                | tinytext             | NO   |     | NULL       |                | 
| top_def_name           | tinytext             | YES  |     | NULL       |                | 
| top_def_score          | smallint(6) unsigned | NO   |     | NULL       |                | 
| top_def_evalue         | double unsigned      | NO   |     | NULL       |                | 
| top_def_identities     | float(4,2)           | NO   |     | NULL       |                | 
| best_def               | tinytext             | YES  |     | NULL       |                | 
| best_def_name          | tinytext             | YES  |     | NULL       |                | 
| best_def_score         | smallint(6) unsigned | YES  |     | NULL       |                | 
| best_def_evalue        | double unsigned      | YES  |     | NULL       |                | 
| best_def_identities    | float(4,2)           | YES  |     | NULL       |                | 
| top_def_org            | tinytext             | YES  |     | NULL       |                | 
| top_def_org_name       | tinytext             | YES  |     | NULL       |                | 
| top_def_org_score      | smallint(6) unsigned | YES  |     | NULL       |                | 
| top_def_org_evalue     | double unsigned      | YES  |     | NULL       |                | 
| top_def_org_identities | float(4,2)           | YES  |     | NULL       |                | 
| all_def                | text                 | NO   | MUL | NULL       |                | 
| flag                   | tinyint(1)           | NO   |     | 0          |                | 
| mod_date               | date                 | NO   |     | 2004-01-23 |                | 
| mod_times              | int(11)              | NO   |     | 1          |                | 
+------------------------+----------------------+------+-----+------------+----------------+
+------------+
| TABLE_NAME |
+------------+
| orf_sp_dr  | 
+------------+
+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| orf_id | int(11)     | NO   | MUL | 0       |       | 
| sp_id  | varchar(20) | NO   | MUL | NULL    |       | 
| dr     | varchar(20) | NO   |     | NULL    |       | 
| dr_id  | varchar(20) | NO   | MUL | NULL    |       | 
+--------+-------------+------+-----+---------+-------+
+-------------+
| TABLE_NAME  |
+-------------+
| sp_topmatch | 
+-------------+
+------------+----------------------+------+-----+------------+----------------+
| Field      | Type                 | Null | Key | Default    | Extra          |
+------------+----------------------+------+-----+------------+----------------+
| id         | int(11)              | NO   | PRI | NULL       | auto_increment | 
| ORF_id     | int(11)              | NO   | MUL | 0          |                | 
| contig_id  | int(11)              | NO   |     | 0          |                | 
| seq_name   | varchar(30)          | NO   | MUL | NULL       |                | 
| db_name    | varchar(6)           | NO   |     | NULL       |                | 
| pg_name    | varchar(6)           | NO   |     | NULL       |                | 
| definition | tinytext             | NO   |     | NULL       |                | 
| def_name   | tinytext             | YES  |     | NULL       |                | 
| sp_id      | tinytext             | YES  |     | NULL       |                | 
| score      | smallint(6) unsigned | YES  |     | NULL       |                | 
| evalue     | double unsigned      | YES  |     | NULL       |                | 
| all_def    | text                 | YES  | MUL | NULL       |                | 
| flag       | tinyint(1)           | NO   |     | 0          |                | 
| mod_date   | date                 | NO   |     | 2004-01-23 |                | 
| mod_times  | int(11)              | NO   |     | 1          |                | 
+------------+----------------------+------+-----+------------+----------------+