![[MDB navigation]](/images/mdb-menu.png)
![[MDB - TSRI]](/images/mdb_logo.gif){kind=logo}
MDB Table Structure
| SQL Query Form | MDB Schema | Table descriptions | SQL Query Examples | SQL Help |
The structure of the tables in the metallodb database can be seen below.
For a detailed description of the tables click here.
Database = metallodb
Table = protein
+-----------------+----------+--------+----------+--------------+
| Field | Type | Length | Not Null | Unique Index |
+-----------------+----------+--------+----------+--------------+
| source | char | 20 | N | N/A |
| source_id | char | 20 | N | N/A |
| dep_date | date | 4 | N | N/A |
| rev_date | date | 4 | N | N/A |
| expdata | char | 60 | N | N/A |
| r_value | real | 8 | N | N/A |
| resolution | real | 8 | N | N/A |
| description | char | 200 | N | N/A |
+-----------------+----------+--------+----------+--------------+
Database = metallodb
Table = site
+-----------------+----------+--------+----------+--------------+
| Field | Type | Length | Not Null | Unique Index |
+-----------------+----------+--------+----------+--------------+
| source_id | char | 20 | N | N/A |
| site_id | char | 20 | N | N/A |
| metal | char | 2 | N | N/A |
| metal_chain | char | 1 | N | N/A |
| geometry | char | 20 | N | N/A |
| num_ligands | int | 4 | N | N/A |
| nlig_protein | int | 4 | N | N/A |
| nlig_nucleic | int | 4 | N | N/A |
| nlig_metal | int | 4 | N | N/A |
| nlig_water | int | 4 | N | N/A |
| nlig_anion | int | 4 | N | N/A |
| nlig_hetero | int | 4 | N | N/A |
+-----------------+----------+--------+----------+--------------+
Database = metallodb
Table = ligand
+-----------------+----------+--------+----------+--------------+
| Field | Type | Length | Not Null | Unique Index |
+-----------------+----------+--------+----------+--------------+
| source_id | char | 20 | N | N/A |
| site_id | char | 20 | N | N/A |
| metal | char | 2 | N | N/A |
| lig_type | char | 1 | N | N/A |
| lig_chain | char | 1 | N | N/A |
| lig_symbol | char | 4 | N | N/A |
| lig_seq | char | 4 | N | N/A |
| lig_atom | char | 4 | N | N/A |
| metal_lig_dist | real | 8 | N | N/A |
+-----------------+----------+--------+----------+--------------+
Number of entries per table
55060 ligand
3960 protein
11341 site
Use the interactive interface to search the MDB Database
MDB Site: About the MDB | Searching the MDB | MDB's FAQ | News and Release History | Future Plans
Advanced Queries | SQL Query | Remote Viewer and How to use it | MDB downloads | Feedback
Metalloprotein Structure and Design Site:
TSRI Main Page | MetalloProtein Program Main Page | Metalloprotein Database & Browser
About the Program | Employment & Research Opportunities
Group Picture | For More Information | Feedback & Inquiries | Other Web Resources
