Schema for Chromatin state expanded - Chromatin state expanded
|
|
Database: TAIR10 Primary Table: chromstates Row Count: 186   Data last updated: 2017-06-18
field | example | SQL type | info |
chrom | chr1 | varchar(255) | values |
chromStart | 0 | int(10) unsigned | range |
chromEnd | 30427600 | int(10) unsigned | range |
name | 1 | varchar(255) | values |
score | 0 | int(10) unsigned | range |
strand | . | char(1) | values |
thickStart | 5600 | int(10) unsigned | range |
thickEnd | 30427600 | int(10) unsigned | range |
itemRgb | 15394580 | int(10) unsigned | range |
blockCount | 2811 | int(10) unsigned | range |
blockSizes | 0,800,400,400,400,400,400,2... | longblob | |
chromStarts | 0,5600,6800,22200,31000,452... | longblob | |
|
| |
|
|
Sample Rows
|
|
chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | itemRgb | blockCount | blockSizes | chromStarts |
---|
chr1 | 0 | 30427600 | 1 | 0 | . | 5600 | 30427600 | 234,231,20 | 2811 | 0,800,400,400,400,400,400,200,200,200,200,400,400,400,200,200,200,200,400,800,200,200,200,200,200,600,200,400,800,400,400,400,40 ... | 0,5600,6800,22200,31000,45200,47400,61800,62600,65000,101600,111200,115400,119000,119600,121200,137800,143000,150000,166000,1718 ... |
chr1 | 0 | 30427600 | 2 | 0 | . | 6400 | 30427600 | 234,166,20 | 1562 | 0,400,200,400,200,200,200,800,200,600,400,200,200,200,200,200,200,400,200,200,400,200,200,200,200,400,600,400,200,400,200,200,40 ... | 0,6400,30800,47000,50200,53000,62000,64200,65200,73600,76800,83200,95400,111600,113000,115800,119400,121400,148200,149000,160000 ... |
chr1 | 0 | 30427600 | 3 | 0 | . | 5400 | 30427600 | 238,223,52 | 1764 | 0,200,200,400,1400,200,600,400,200,200,200,400,200,600,400,600,600,200,400,1400,200,400,200,400,400,200,200,200,200,400,200,600, ... | 0,5400,29400,30400,34000,48200,53800,65400,73400,90200,95200,96800,101200,110600,115000,121800,122800,126200,127000,160400,18640 ... |
chr1 | 0 | 30427600 | 4 | 0 | . | 29600 | 30427600 | 202,188,38 | 2514 | 0,400,400,200,400,800,200,400,1600,1000,600,200,400,200,800,200,200,400,200,400,200,200,800,400,400,200,400,800,800,1200,200,120 ... | 0,29600,31400,35400,47800,94400,98800,122400,123400,125200,126400,127400,137400,165800,189000,233400,267200,272200,276000,281800 ... |
chr1 | 0 | 30427600 | 5 | 0 | . | 4800 | 30427600 | 241,243,32 | 2347 | 0,200,200,2400,600,200,800,800,400,200,400,800,800,800,400,600,400,200,200,400,200,400,400,400,600,200,400,200,200,600,400,400,6 ... | 0,4800,24200,25000,27800,29200,92400,93400,132800,134600,137000,164000,165000,188200,234200,235800,251000,260200,264200,272600,2 ... |
chr1 | 0 | 30427600 | 6 | 0 | . | 5000 | 30427600 | 249,224,55 | 3004 | 0,400,400,600,400,600,600,200,400,200,200,600,200,200,200,200,1200,400,800,400,1200,200,800,800,200,200,1600,200,400,800,400,400 ... | 0,5000,7600,24400,27400,28400,31800,35600,89800,93200,94200,98200,125000,127600,136800,164800,234600,236400,250200,263800,264400 ... |
chr1 | 0 | 30427600 | 7 | 0 | . | 24000 | 30427600 | 215,217,6 | 2448 | 0,200,800,400,600,400,200,200,400,200,400,200,200,200,200,200,200,200,400,200,400,200,200,200,400,200,400,400,200,200,200,200,20 ... | 0,24000,35800,45600,65800,73000,89600,96600,100800,101400,110200,127800,136600,161800,163800,186200,197000,197600,202800,236800, ... |
chr1 | 0 | 30427600 | 8 | 0 | . | 4200 | 30427600 | 201,178,25 | 1492 | 0,400,400,200,200,800,200,200,600,600,200,400,600,400,200,600,200,600,400,800,200,600,800,200,400,200,800,600,800,400,600,200,20 ... | 0,4200,53400,62200,70000,71200,87800,132600,144200,147200,151200,151800,168600,170800,178000,191200,203200,203600,214200,216400, ... |
chr1 | 0 | 30427600 | 9 | 0 | . | 4600 | 30427600 | 172,150,5 | 1714 | 0,200,400,200,400,200,1400,400,600,200,200,600,1600,1600,1000,1000,200,200,200,200,200,1000,400,200,200,200,200,200,1400,200,100 ... | 0,4600,7200,29000,30000,71000,133200,134800,144800,151000,170200,233600,240800,243200,251400,253000,260400,275800,276200,283200, ... |
chr1 | 0 | 30427600 | 10 | 0 | . | 38400 | 30427600 | 193,222,33 | 1921 | 0,400,200,200,400,200,200,200,600,200,400,200,200,1000,400,200,400,400,400,200,800,1000,400,1200,200,400,200,400,200,200,400,400 ... | 0,38400,53200,54400,69600,70200,91000,113800,131800,139600,141000,145400,166800,169200,170400,171200,191800,211600,212200,214600 ... |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|