Schema for RNA-seq Liver - Burge Lab RNA-seq 32mer Reads from Liver

Database: hg19 Primary Table: burgeRnaSeqGemMapperAlignLiver Row Count: 11,571,688
Format description: Browser extensible data

field	example	SQL type	description
`bin`	585	`smallint(5) unsigned`	Indexing field to speed chromosome range queries.
`chrom`	chr1	`varchar(255)`	Reference sequence chromosome or scaffold
`chromStart`	16071	`int(10) unsigned`	Start position in chromosome
`chromEnd`	16103	`int(10) unsigned`	End position in chromosome
`name`	GSM325477_liver_HCT169_hg18...	`varchar(255)`	Name of item
`score`	1000	`int(10) unsigned`	Score from 0-1000
`strand`	-	`char(1)`	+ or -
`thickStart`	0	`int(10) unsigned`	Start of where display should be thick (start codon)
`thickEnd`	0	`int(10) unsigned`	End of where display should be thick (stop codon)
`reserved`	0	`int(10) unsigned`	Used as itemRgb as of 2004-11-22
`blockCount`	1	`int(10) unsigned`	Number of blocks
`blockSizes`	32,	`longblob`	Comma separated list of block sizes
`chromStarts`	0,	`longblob`	Start positions relative to chromStart

bin	chrom	chromStart	chromEnd	name	score	strand	blockCount	blockSizes	chromStarts
585	chr1	16071	16103	GSM325477_liver_HCT169_hg18_12958145_chr1_16072_16103	1000	-	1	32,	0,
585	chr1	16074	16106	GSM325477_liver_HCT169_hg18_2509968_chr1_16075_16106	1000	-	1	32,	0,
585	chr1	16080	16112	GSM325477_liver_HCT169_hg18_402936_chr1_16081_16112	1000	+	1	32,	0,
585	chr1	24857	29541	GSM325477_liver_HCT169_hg18_17458116_chr1_24891_29534_ENST00000488147_spliced	1000	+	2	34,8,	0,4676,
585	chr1	87666	87698	GSM325477_liver_HCT169_hg18_603965_chr1_87667_87698	1000	+	1	32,	0,
586	chr1	134989	135021	GSM325477_liver_HCT169_hg18_737152_chr1_134990_135021	1000	-	1	32,	0,
586	chr1	135160	135192	GSM325477_liver_HCT169_hg18_3873649_chr1_135161_135192	1000	+	1	32,	0,
586	chr1	137806	137838	GSM325477_liver_HCT169_hg18_1513717_chr1_137807_137838	1000	+	1	32,	0,
586	chr1	139302	139334	GSM325477_liver_HCT169_hg18_4740591_chr1_139303_139334	1000	+	1	32,	0,
586	chr1	139307	139339	GSM325477_liver_HCT169_hg18_3299871_chr1_139308_139339	1000	+	1	32,	0,

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