| field | example | SQL type | description |
|---|
| id | 1 | int(10) unsigned | Unique numerical id for cDNA |
| acc | AB000106 | char(12) | Genbank/EMBL accession (without .version) |
| version | 1 | smallint(5) unsigned | Version number in Genbank |
| moddate | 1999-01-05 | date | Date last modified, in SQL DATE format/ascii YYYY-MM-DD |
| type | mRNA | enum('EST', 'mRNA') | Either EST or mRNA. |
| direction | 0 | enum('5', '3', '0') | 5, 3 for read direction 5'/3', or 0 unknown. |
| source | 1 | int(10) unsigned | Link to id in source table saying where cDNA came from |
| organism | 1 | int(10) unsigned | Link to id in organism table. |
| library | 0 | int(10) unsigned | Link to id in library table. |
| mrnaClone | 0 | int(10) unsigned | Link to id in mrnaClone table. |
| sex | 0 | int(10) unsigned | Link to id in sex table |
| tissue | 0 | int(10) unsigned | Link to id in tissue table |
| development | 0 | int(10) unsigned | Link to id in development table |
| cell | 0 | int(10) unsigned | Link to id in cell table |
| cds | 0 | int(10) unsigned | Link to id in cds table |
| keyword | 1 | int(10) unsigned | Link to id in keyword table |
| description | 1 | int(10) unsigned | Link to id in description table |
| geneName | 0 | int(10) unsigned | Link to id in geneName table |
| productName | 0 | int(10) unsigned | Link to id in productName table |
| author | 1 | int(10) unsigned | Link to id in author table |
| gi | 0 | int(10) unsigned | Genbank identifier |
| mol | rRNA | enum('DNA', 'RNA', 'ds-RNA', 'ds-mRNA', 'ds-rRNA', 'mRNA', 'ms-DNA', 'ms-RNA', 'rRNA', 'scRNA', 'snRNA', 'snoRNA', 'ss-DNA', 'ss-RNA', 'ss-snoRNA', 'tRNA', 'cRNA', 'ss-cRNA', 'ds-cRNA', 'ms-rRNA') | molecule type |