|
|
Database: bosTau4 Primary Table: gbStatus Row Count: 3,135,297
field | example | SQL type |
acc | NM_001001133 | char(12) |
version | 1 | smallint unsigned |
modDate | 2007-05-14 | date |
type | mRNA | enum('EST','mRNA') |
srcDb | RefSeq | enum('GenBank','RefSeq') |
orgCat | native | enum('native','xeno') |
gbSeq | 2787313 | int unsigned |
numAligns | 1 | int unsigned |
seqRelease | 27 | char(8) |
seqUpdate | full | char(10) |
metaRelease | 27 | char(8) |
metaUpdate | full | char(10) |
extRelease | 27 | char(8) |
extUpdate | full | char(10) |
time | 2008-03-12 05:22:17 | timestamp |
|
| |
|
|
Connected Tables and Joining Fields |
|
|
|
|
acc | version | modDate | type | srcDb | orgCat | gbSeq | numAligns | seqRelease | seqUpdate | metaRelease | metaUpdate | extRelease | extUpdate | time |
---|
NM_001001133 | 1 | 2007-05-14 | mRNA | RefSeq | native | 2787313 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001134 | 1 | 2007-05-14 | mRNA | RefSeq | native | 2787847 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001135 | 2 | 2009-04-14 | mRNA | RefSeq | native | 2784745 | 1 | 27 | full | 35 | full | 35 | full | 2009-05-16 13:07:16 |
NM_001001136 | 2 | 2008-01-24 | mRNA | RefSeq | native | 2796833 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001137 | 1 | 2007-12-24 | mRNA | RefSeq | native | 2791011 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001138 | 1 | 2007-08-25 | mRNA | RefSeq | native | 2788659 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001139 | 1 | 2008-12-04 | mRNA | RefSeq | native | 2791245 | 1 | 27 | full | 33 | full | 33 | full | 2009-01-25 07:25:18 |
NM_001001141 | 1 | 2007-12-24 | mRNA | RefSeq | native | 2791013 | 1 | 27 | full | 27 | full | 27 | full | 2008-03-12 05:22:17 |
NM_001001142 | 1 | 2008-09-22 | mRNA | RefSeq | native | 2784131 | 1 | 27 | full | 31 | full | 31 | full | 2008-10-24 13:02:25 |
NM_001001143 | 2 | 2008-10-02 | mRNA | RefSeq | native | 2779551 | 1 | 27 | full | 32 | full | 32 | full | 2008-11-23 00:33:11 |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|