Schema for RNA-seq Heart - Burge Lab RNA-seq 32mer Reads from Heart
Database: hg19    Primary Table: burgeRnaSeqGemMapperAlignHeart    Row Count: 10,630,949
Format description: Browser extensible data
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 16095int(10) unsigned Start position in chromosome
chromEnd 16127int(10) unsigned End position in chromosome
name GSM325478_heart_HCT170_hg18...varchar(255) Name of item
score 1000int(10) unsigned Score from 0-1000
strand +char(1) + or -
thickStart 0int(10) unsigned Start of where display should be thick (start codon)
thickEnd 0int(10) unsigned End of where display should be thick (stop codon)
reserved 0int(10) unsigned Used as itemRgb as of 2004-11-22
blockCount 1int(10) unsigned Number of blocks
blockSizes 32,longblob Comma separated list of block sizes
chromStarts 0,longblob Start positions relative to chromStart
Sample Rows
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
585chr11609516127GSM325478_heart_HCT170_hg18_980012_chr1_16096_161271000+000132,0,
586chr1136701136733GSM325478_heart_HCT170_hg18_6590929_chr1_136702_1367331000+000132,0,
586chr1137794137826GSM325478_heart_HCT170_hg18_3929904_chr1_137795_1378261000+000132,0,
589chr1532434532466GSM325478_heart_HCT170_hg18_9463490_chr1_532435_5324661000-000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_2071789_chr1_564567_5645981000+000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_2956118_chr1_564567_5645981000+000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_4613272_chr1_564567_5645981000+000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_5047477_chr1_564567_5645981000+000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_8359074_chr1_564567_5645981000+000132,0,
589chr1564566564598GSM325478_heart_HCT170_hg18_9607838_chr1_564567_5645981000-000132,0,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.