Schema for RNA-seq MCF7 - Burge Lab RNA-seq 32mer Reads from MCF-7 Breast Adenocarcinoma Cell Line

Database: hg19 Primary Table: burgeRnaSeqGemMapperAlignMCF7 Row Count: 10,164,944
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`	14907	`int(10) unsigned`	Start position in chromosome
`chromEnd`	14939	`int(10) unsigned`	End position in chromosome
`name`	GSM325487_HCT203_s2468_1193...	`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	14907	14939	GSM325487_HCT203_s2468_11931921_chr1_14908_14939	1000	+	1	32,	0,
585	chr1	14907	14939	GSM325487_HCT203_s2468_12334592_chr1_14908_14939	1000	+	1	32,	0,
585	chr1	14925	14957	GSM325487_HCT203_s2468_12181854_chr1_14926_14957	1000	-	1	32,	0,
585	chr1	14929	14961	GSM325487_HCT203_s2468_7030540_chr1_14930_14961	1000	+	1	32,	0,
585	chr1	14935	14967	GSM325487_HCT203_s2468_259028_chr1_14936_14967	1000	+	1	32,	0,
585	chr1	16071	16103	GSM325487_HCT203_s2468_6404838_chr1_16072_16103	1000	+	1	32,	0,
585	chr1	16080	16112	GSM325487_HCT203_s2468_1905093_chr1_16081_16112	1000	+	1	32,	0,
585	chr1	16080	16112	GSM325487_HCT203_s2468_3935891_chr1_16081_16112	1000	+	1	32,	0,
585	chr1	16080	16112	GSM325487_HCT203_s2468_13575302_chr1_16081_16112	1000	+	1	32,	0,
585	chr1	16082	16114	GSM325487_HCT203_s2468_1323182_chr1_16083_16114	1000	+	1	32,	0,

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