|
|
Database: calJac4 Primary Table: xenoRefFlat Row Count: 256,337   Data last updated: 2020-09-21
Format description: A gene prediction with additional geneName field. On download server: MariaDB table dump directory
field | example | SQL type | info | description |
geneName | LINC00375 | varchar(255) | values | Name of gene as it appears in genome browser. |
name | NR_126383 | varchar(255) | values | Name of gene |
chrom | chr1 | varchar(255) | values | Reference sequence chromosome or scaffold |
strand | - | char(1) | values | + or - for strand |
txStart | 305304 | int(10) unsigned | range | Transcription start position (or end position for minus strand item) |
txEnd | 308245 | int(10) unsigned | range | Transcription end position (or start position for minus strand item) |
cdsStart | 308245 | int(10) unsigned | range | Coding region start (or end position for minus strand item) |
cdsEnd | 308245 | int(10) unsigned | range | Coding region end (or start position for minus strand item) |
exonCount | 2 | int(10) unsigned | range | Number of exons |
exonStarts | 305304,308212, | longblob | | Exon start positions (or end positions for minus strand item) |
exonEnds | 305434,308245, | longblob | | Exon end positions (or start positions for minus strand item) |
|
| |
|
|
Connected Tables and Joining Fields
|
|
Sample Rows
|
|
geneName | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds |
---|
LINC00375 | NR_126383 | chr1 | - | 305304 | 308245 | 308245 | 308245 | 2 | 305304,308212, | 305434,308245, |
LOC100383421 | NM_001176073 | chr1 | - | 382354 | 383283 | 382354 | 383283 | 3 | 382354,382621,382884, | 382399,382747,383283, |
LINC00351 | NR_046989 | chr1 | + | 868811 | 885358 | 885358 | 885358 | 3 | 868811,882389,885259, | 868939,882477,885358, |
hnrnpa1a | NR_155546 | chr1 | + | 870826 | 871684 | 871684 | 871684 | 4 | 870826,871558,871635,871666, | 871366,871621,871656,871684, |
SLITRK6 | NM_032229 | chr1 | - | 1147788 | 1154501 | 1148947 | 1151470 | 4 | 1147788,1148826,1149709,1154003, | 1148802,1149709,1151501,1154501, |
Slitrk6 | NM_175499 | chr1 | - | 1147788 | 1154503 | 1148947 | 1151470 | 9 | 1147788,1148075,1148208,1148437,1148549,1148635,1148865,1149705,1154204, | 1148044,1148175,1148221,1148448,1148593,1148783,1149697,1151505,1154503, |
Slitrk6 | NM_001106057 | chr1 | - | 1147788 | 1154504 | 1148947 | 1151470 | 13 | 1147788,1147991,1148238,1148333,1148437,1148549,1148634,1148826,1149704,1150621,1154077,1154207,1154369, | 1147956,1148164,1148256,1148345,1148536,1148561,1148783,1149694,1150618,1151500,1154170,1154346,1154504, |
SLITRK6 | NM_001257070 | chr1 | - | 1148947 | 1151470 | 1148947 | 1151470 | 1 | 1148947, | 1151470, |
slitrk6 | NM_001305553 | chr1 | - | 1148950 | 1151386 | 1148950 | 1151386 | 6 | 1148950,1149121,1149457,1149877,1150666,1151320, | 1149094,1149223,1149661,1150234,1151206,1151386, |
LINC00430 | NR_132371 | chr1 | + | 2143672 | 2172318 | 2172318 | 2172318 | 2 | 2143672,2172167, | 2143724,2172318, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|