Schema for Chromatin state expanded - Chromatin state expanded
  Database: TAIR10    Primary Table: chromstates    Row Count: 186   Data last updated: 2017-06-18
fieldexampleSQL type info
chrom chr1varchar(255) values
chromStart 0int(10) unsigned range
chromEnd 30427600int(10) unsigned range
name 1varchar(255) values
score 0int(10) unsigned range
strand .char(1) values
thickStart 5600int(10) unsigned range
thickEnd 30427600int(10) unsigned range
itemRgb 15394580int(10) unsigned range
blockCount 2811int(10) unsigned range
blockSizes 0,800,400,400,400,400,400,2...longblob  
chromStarts 0,5600,6800,22200,31000,452...longblob  

Sample Rows
 
chromchromStartchromEndnamescorestrandthickStartthickEnditemRgbblockCountblockSizeschromStarts
chr103042760010.560030427600234,231,2028110,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 ...
chr103042760020.640030427600234,166,2015620,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 ...
chr103042760030.540030427600238,223,5217640,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 ...
chr103042760040.2960030427600202,188,3825140,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 ...
chr103042760050.480030427600241,243,3223470,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 ...
chr103042760060.500030427600249,224,5530040,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 ...
chr103042760070.2400030427600215,217,624480,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, ...
chr103042760080.420030427600201,178,2514920,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, ...
chr103042760090.460030427600172,150,517140,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, ...
chr1030427600100.3840030427600193,222,3319210,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.