+-------------------+
| TABLE_NAME        |
+-------------------+
| 16S_rRNA_sequence | 
+-------------------+
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| Oral_taxon_id     | int(5)       | NO   | MUL | NULL    |       | 
| order             | int(2)       | NO   |     | NULL    |       | 
| 16S_rRNA_sequence | varchar(100) | NO   |     | NULL    |       | 
+-------------------+--------------+------+-----+---------+-------+
+---------------+
| TABLE_NAME    |
+---------------+
| ClassifyTitle | 
+---------------+
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| item_id    | int(5)       | NO   | MUL | NULL    |       | 
| item_title | varchar(150) | NO   | MUL | NULL    |       | 
| level      | varchar(2)   | NO   |     | NULL    |       | 
+------------+--------------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| HOT_count  | 
+------------+
+---------------+------------+------+-----+---------+-------+
| Field         | Type       | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| Oral_taxon_id | int(11)    | NO   | PRI | NULL    |       | 
| HOT_count     | int(11)    | NO   |     | NULL    |       | 
| Rank          | int(11)    | NO   |     | NULL    |       | 
| Tied          | tinyint(4) | NO   |     | NULL    |       | 
+---------------+------------+------+-----+---------+-------+
+---------------+
| TABLE_NAME    |
+---------------+
| ItemLink_Item | 
+---------------+
+-----------------+---------+------+-----+---------+-------+
| Field           | Type    | Null | Key | Default | Extra |
+-----------------+---------+------+-----+---------+-------+
| item1_id        | int(11) | NO   | MUL | NULL    |       | 
| item2_id        | int(11) | NO   | MUL | NULL    |       | 
| taxonid_count   | int(8)  | NO   |     | 0       |       | 
| seq_id_count    | int(5)  | YES  |     | 0       |       | 
| sequenced_count | int(5)  | YES  |     | 0       |       | 
| clone_count     | int(11) | YES  |     | 0       |       | 
+-----------------+---------+------+-----+---------+-------+
+----------------------+
| TABLE_NAME           |
+----------------------+
| ItemLink_OralTaxonId | 
+----------------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| item_id       | int(5) | NO   | MUL | NULL    |       | 
| oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+----------------+
| TABLE_NAME     |
+----------------+
| classify_level | 
+----------------+
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| level    | int(1)      | NO   | MUL | NULL    |       | 
| classify | varchar(50) | NO   |     | NULL    |       | 
+----------+-------------+------+-----+---------+-------+
+--------------------+
| TABLE_NAME         |
+--------------------+
| community_comments | 
+--------------------+
+---------------+---------+------+-----+---------+----------------+
| Field         | Type    | Null | Key | Default | Extra          |
+---------------+---------+------+-----+---------+----------------+
| id            | int(12) | NO   | PRI | NULL    | auto_increment | 
| Oral_taxon_id | int(5)  | NO   | MUL | NULL    |                | 
| comments      | text    | NO   |     | NULL    |                | 
| comments_by   | int(5)  | NO   |     | NULL    |                | 
| date          | date    | NO   |     | NULL    |                | 
| prove         | int(1)  | NO   |     | NULL    |                | 
| prove_date    | date    | NO   |     | NULL    |                | 
| proved_by     | int(5)  | NO   |     | NULL    |                | 
+---------------+---------+------+-----+---------+----------------+
+---------------+
| TABLE_NAME    |
+---------------+
| cultivability | 
+---------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| description   | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+----------------------+
| TABLE_NAME           |
+----------------------+
| disease_associations | 
+----------------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| description   | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| general    | 
+------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| description   | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+----------------------------+
| TABLE_NAME                 |
+----------------------------+
| phenotypic_characteristics | 
+----------------------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| description   | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| phylogeny  | 
+------------+
+---------------+------------+------+-----+---------+-------+
| Field         | Type       | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| Oral_taxon_id | int(11)    | NO   | PRI | NULL    |       | 
| tree_id       | tinyint(4) | NO   |     | NULL    |       | 
+---------------+------------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| prevalence | 
+------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| description   | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+------------------+
| TABLE_NAME       |
+------------------+
| reference_strain | 
+------------------+
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| Oral_taxon_id    | int(5)       | NO   | MUL | NULL    |       | 
| order            | int(2)       | NO   |     | NULL    |       | 
| reference_strain | varchar(100) | NO   |     | NULL    |       | 
+------------------+--------------+------+-----+---------+-------+
+--------------+
| TABLE_NAME   |
+--------------+
| `references` | 
+--------------+
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| Oral_taxon_id | int(5)       | NO   | MUL | NULL    |                | 
| pubmed_id     | int(15)      | YES  |     | NULL    |                | 
| journal       | varchar(150) | NO   |     | NULL    |                | 
| authors       | varchar(200) | NO   |     | NULL    |                | 
| title         | varchar(200) | NO   |     | NULL    |                | 
| auto_id       | int(8)       | NO   | PRI | NULL    | auto_increment | 
+---------------+--------------+------+-----+---------+----------------+
+------------+
| TABLE_NAME |
+------------+
| status     | 
+------------+
+---------------+---------+------+-----+---------+-------+
| Field         | Type    | Null | Key | Default | Extra |
+---------------+---------+------+-----+---------+-------+
| Oral_taxon_id | int(11) | NO   | PRI | NULL    |       | 
| group         | text    | NO   |     | NULL    |       | 
+---------------+---------+------+-----+---------+-------+
+------------------+
| TABLE_NAME       |
+------------------+
| synonyms_correct | 
+------------------+
+---------------+--------+------+-----+---------+-------+
| Field         | Type   | Null | Key | Default | Extra |
+---------------+--------+------+-----+---------+-------+
| Oral_taxon_id | int(5) | NO   | MUL | NULL    |       | 
| order         | int(2) | NO   |     | NULL    |       | 
| synonyms      | text   | NO   |     | NULL    |       | 
+---------------+--------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| taxon_list | 
+------------+
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| Oral_taxon_id | int(5)       | NO   | PRI | NULL    |       | 
| Genus         | varchar(150) | NO   | MUL | NULL    |       | 
| Species       | varchar(150) | NO   |     | NULL    |       | 
+---------------+--------------+------+-----+---------+-------+
+-------------+
| TABLE_NAME  |
+-------------+
| type_strain | 
+-------------+
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| Oral_taxon_id | int(5)       | NO   | MUL | NULL    |       | 
| order         | int(2)       | NO   |     | NULL    |       | 
| type_strain   | varchar(100) | NO   |     | NULL    |       | 
+---------------+--------------+------+-----+---------+-------+
+------------+
| TABLE_NAME |
+------------+
| warning    | 
+------------+
+---------------+------------+------+-----+---------+-------+
| Field         | Type       | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| Oral_taxon_id | int(11)    | NO   | PRI | NULL    |       | 
| warning       | tinyint(1) | NO   |     | 0       |       | 
+---------------+------------+------+-----+---------+-------+