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

Database: hg19 Primary Table: burgeRnaSeqGemMapperAlignTestes Row Count: 18,856,562
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`	10465	`int(10) unsigned`	Start position in chromosome
`chromEnd`	10497	`int(10) unsigned`	End position in chromosome
`name`	GSM325482_testes_hg18_11432...	`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	10465	10497	GSM325482_testes_hg18_11432295_chr1_10466_10497	1000	+	1	32,	0,
585	chr1	10467	10499	GSM325482_testes_hg18_14654617_chr1_10468_10499	1000	+	1	32,	0,
585	chr1	10494	10526	GSM325482_testes_hg18_11245106_chr1_10495_10526	1000	+	1	32,	0,
585	chr1	10496	10528	GSM325482_testes_hg18_17556438_chr1_10497_10528	1000	+	1	32,	0,
585	chr1	10501	10533	GSM325482_testes_hg18_25041372_chr1_10502_10533	1000	+	1	32,	0,
585	chr1	10528	10560	GSM325482_testes_hg18_22153251_chr1_10529_10560	1000	-	1	32,	0,
585	chr1	13959	13991	GSM325482_testes_hg18_8435913_chr1_13960_13991	1000	+	1	32,	0,
585	chr1	14914	14946	GSM325482_testes_hg18_9026429_chr1_14915_14946	1000	+	1	32,	0,
585	chr1	14924	14956	GSM325482_testes_hg18_23972631_chr1_14925_14956	1000	-	1	32,	0,
585	chr1	14931	14963	GSM325482_testes_hg18_7584352_chr1_14932_14963	1000	-	1	32,	0,

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