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 |