field | example | SQL type | description |
id | 1 | int unsigned | Unique numerical id for cDNA |
acc | AB004856 | char(12) | Genbank/EMBL accession (without .version) |
version | 1 | smallint unsigned | Version number in Genbank |
moddate | 2008-11-23 | date | Date last modified, in SQL DATE format/ascii YYYY-MM-DD |
type | mRNA | enum('EST','mRNA') | Either EST or mRNA. In SQL an ENUM |
direction | 0 | enum('5','3','0') | Enum 5, 3 for read direction 5'/3', or 0 unknown. |
source | 1 | int unsigned | Link to id in source table saying where cDNA came from |
organism | 1 | int unsigned | Link to id in organism table. |
library | 0 | int unsigned | Link to id in library table. |
mrnaClone | 0 | int unsigned | Link to id in mrnaClone table. |
sex | 0 | int unsigned | Link to id in sex table |
tissue | 0 | int unsigned | Link to id in tissue table |
development | 0 | int unsigned | Link to id in development table |
cell | 0 | int unsigned | Link to id in cell table |
cds | 1 | int unsigned | Link to id in cds table |
keyword | 6 | int unsigned | Link to id in keyword table |
description | 0 | int unsigned | Link to id in description table |
geneName | 1 | int unsigned | Link to id in geneName table |
productName | 1 | int unsigned | Link to id in productName table |
author | 1 | int unsigned | Link to id in author table |
gi | 3036932 | int unsigned | Genbank identifier |
mol | mRNA | 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') | molecule type |