Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
gene_id |
int unsigned |
10 |
|
√ |
|
|
|
biotype |
varchar |
40 |
|
|
|
|
|
analysis_id |
smallint unsigned |
5 |
|
|
|
|
analysis.analysis_id
|
Implied Constraint R |
|
seq_region_id |
int unsigned |
10 |
|
|
|
|
dna.seq_region_id
|
Implied Constraint R |
|
seq_region_start |
int unsigned |
10 |
|
|
|
|
|
seq_region_end |
int unsigned |
10 |
|
|
|
|
|
seq_region_strand |
tinyint |
3 |
|
|
|
|
|
display_xref_id |
int unsigned |
10 |
√ |
|
null |
|
|
source |
varchar |
40 |
|
|
|
|
|
description |
text |
65535 |
√ |
|
null |
|
|
is_current |
bit |
0 |
|
|
1 |
|
|
canonical_transcript_id |
int unsigned |
10 |
|
|
|
|
|
stable_id |
varchar |
128 |
√ |
|
null |
|
|
version |
smallint unsigned |
5 |
√ |
|
null |
|
|
created_date |
datetime |
19 |
√ |
|
null |
|
|
modified_date |
datetime |
19 |
√ |
|
null |
|
|
Table contained 67,946 rows at Wed Nov 27 11:43 CET 2019
|