Schema for TAIR Gene - TAIR10 gene annotations |
|---|
| |
Database: TAIR10 Primary Table: gene_structure Row Count: 41,392 Data last updated: 2017-06-18
| field | example | SQL type | info |
|---|
| bin | 585 | smallint(5) unsigned | range |
| name | AT1G01010.1 | varchar(255) | values |
| chrom | chr1 | varchar(255) | values |
| strand | + | char(1) | values |
| txStart | 3630 | int(10) unsigned | range |
| txEnd | 5899 | int(10) unsigned | range |
| cdsStart | 3759 | int(10) unsigned | range |
| cdsEnd | 5630 | int(10) unsigned | range |
| exonCount | 8 | int(10) unsigned | range |
| exonStarts | 3630,3759,3995,4485,4705,51... | longblob | |
| exonEnds | 3759,3913,4276,4605,5095,53... | longblob | |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| bin | name | chrom | strand | txStart | txEnd | cdsStart | cdsEnd | exonCount | exonStarts | exonEnds |
|---|
| 585 | AT1G01010.1 | chr1 | + | 3630 | 5899 | 3759 | 5630 | 8 | 3630,3759,3995,4485,4705,5173,5438,5630, | 3759,3913,4276,4605,5095,5326,5630,5899, |
| 585 | AT1G01020.1 | chr1 | - | 5927 | 8737 | 6914 | 8666 | 11 | 5927,6914,7156,7383,7563,7761,7941,8235,8416,8570,8666, | 6914,7069,7232,7450,7649,7835,7987,8325,8464,8666,8737, |
| 585 | AT1G01020.2 | chr1 | - | 6789 | 8737 | 7314 | 8666 | 9 | 6789,7314,7563,7761,7941,8235,8416,8570,8666, | 7314,7450,7649,7835,7987,8325,8464,8666,8737, |
| 585 | AT1G01030.1 | chr1 | - | 11648 | 13714 | 11863 | 12940 | 3 | 11648,11863,12940, | 11863,12940,13714, |
| 585 | AT1G01040.1 | chr1 | + | 23145 | 31227 | 23518 | 31079 | 22 | 23145,23518,24541,24751,25040,25523,25824,26080,26291,26542,26861,27098,27371,27617,27802,28707,28889,29159,30146,30409,30901,31 ... | 23518,24451,24655,24962,25435,25743,25997,26203,26452,26776,27012,27281,27533,27713,28431,28805,29080,30065,30311,30816,31079,31 ... |
| 585 | AT1G01040.2 | chr1 | + | 23415 | 31120 | 23518 | 31079 | 22 | 23415,23518,24541,24751,25040,25523,25824,26080,26291,26542,26861,27098,27371,27617,27802,28707,28889,29159,30146,30409,30901,31 ... | 23518,24451,24655,24962,25435,25743,25997,26203,26452,26776,27012,27281,27536,27713,28431,28805,29080,30065,30311,30816,31079,31 ... |
| 585 | AT1G01046.1 | chr1 | + | 28499 | 28706 | 28499 | 28706 | 1 | 28499, | 28706, |
| 585 | AT1G01050.1 | chr1 | - | 31169 | 33153 | 31381 | 32670 | 10 | 31169,31381,31520,31692,31932,32087,32281,32430,32546,32670, | 31381,31424,31602,31813,31998,32195,32347,32459,32670,33153, |
| 585 | AT1G01060.3 | chr1 | - | 33378 | 37757 | 33991 | 37061 | 9 | 33378,33991,34400,35566,35729,36623,36809,37022,37061, | 33991,34327,35474,35647,35963,36685,36921,37061,37757, |
| 585 | AT1G01060.4 | chr1 | - | 33665 | 37780 | 33991 | 37061 | 9 | 33665,33991,34400,35566,35729,36623,36809,37022,37061, | 33991,34327,35471,35647,35963,36685,36921,37061,37780, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|