mysql> use LEA ;
mysql> describe proteins ;

+-------------------+--------------+------+-----+------------+-------+
| Field             | Type         | Null | Key | Default    | Extra |
+-------------------+--------------+------+-----+------------+-------+
| accession         | varchar(30)  | NO   | PRI |            |       |
| name              | varchar(200) | NO   |     |            |       |
| length            | int(5)       | NO   |     | 0          |       |
| reign             | varchar(50)  | NO   |     |            |       |
| uniprot           | text         | NO   |     | NULL       |       |
| authors           | text         | NO   |     | NULL       |       |
| title             | text         | NO   |     | NULL       |       |
| journal           | text         | NO   |     | NULL       |       |
| function          | varchar(200) | NO   |     |            |       |
| tissue_type       | varchar(50)  | NO   |     |            |       |
| dev_stage         | varchar(30)  | NO   |     |            |       |
| product           | text         | NO   |     | NULL       |       |
| protein_name      | text         | NO   |     | NULL       |       |
| gene              | text         | NO   |     | NULL       |       |
| region_name       | text         | NO   |     | NULL       |       |
| region_note       | text         | NO   |     | NULL       |       |
| putative_function | text         | NO   |     | NULL       |       |
| pfam              | varchar(30)  | NO   |     |            |       |
| cdd               | text         | NO   |     | NULL       |       |
| date              | int(5)       | NO   |     | 0          |       |
| GO_comp_id        | varchar(7)   | YES  |     | N/A        |       |
| GO_comp           | varchar(70)  | YES  |     | N/A        |       |
| GO_func_id        | varchar(7)   | YES  |     | N/A        |       |
| GO_func           | varchar(70)  | YES  |     | N/A        |       |
| GO_proc_id        | varchar(7)   | YES  |     | N/A        |       |
| GO_proc           | varchar(70)  | YES  |     | N/A        |       |
| organism_id       | varchar(7)   | YES  |     | N/A        |       |
| organism          | varchar(70)  | YES  |     | N/A        |       |
| foldindex         | float(10,7)  | YES  |     | -9.0000000 |       |
| pi                | float(10,7)  | YES  |     | -9.0000000 |       |
| mw                | float(12,4)  | YES  |     | -9.0000    |       |
| gravy             | float(10,7)  | YES  |     | -9.0000000 |       |
| gi                | varchar(20)  | YES  |     | N/A        |       |
| interpro          | varchar(20)  | YES  |     | N/A        |       |
| prodom            | varchar(20)  | YES  |     | N/A        |       |
| unient            | varchar(20)  | YES  |     | N/A        |       |
| netcharge         | float(10,7)  | YES  |     | -9.0000000 |       |
| hydrophi          | float(10,7)  | YES  |     | -9.0000000 |       |
| hydropho          | float(10,7)  | YES  |     | -9.0000000 |       |
| motif             | int(2)       | YES  |     | 99         |       |
| flexibility       | float(10,7)  | YES  |     | -9.0000000 |       |
| bulkiness         | float(10,7)  | YES  |     | -9.0000000 |       |
| buried            | float(10,7)  | YES  |     | -9.0000000 |       |
| transmembr        | float(10,7)  | YES  |     | -9.0000000 |       |
| accres            | float(10,7)  | YES  |     | -9.0000000 |       |
| maj               | int(3)       | NO   |     | -1         |       |
+-------------------+--------------+------+-----+------------+-------+

46 rows in set (0.00 sec)