Schema for PALS | PILER-DF | MUSCLE Repeats - RepeatMasker using PALS | PILER-DF

Schema for PALS | PILER-DF | MUSCLE Repeats - RepeatMasker using PALS | PILER-DF | MUSCLE Repeat Library

Database: dm3 Primary Table: pals_piler_muscle Row Count: 70,097

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	0	`int(10) unsigned`	range
`chromEnd`	5673	`int(10) unsigned`	range
`name`	dm3_PILER_69.623	`varchar(255)`	values
`score`	6844	`int(10) unsigned`	range
`strand`	+	`char(1)`	values
`thickStart`	0	`int(10) unsigned`	range
`thickEnd`	5673	`int(10) unsigned`	range
`itemRgb`	64	`int(10) unsigned`	range
`blockCount`	1	`int(10) unsigned`	range
`blockSizes`	5673	`longblob`
`chromStarts`	0	`longblob`

Sample Rows

bin	chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	itemRgb	blockCount	blockSizes
585	chr2L	0	5673	dm3_PILER_69.623	6844	+	0	5673	0,0,64	1	5673
585	chr2L	5232	5926	dm3_PILER_68.627	2486	+	5232	5926	128,0,0	1	694
585	chr2L	5926	6023	dm3_PILER_68.255	2234	+	5926	6023	99,99,99	1	97
585	chr2L	6561	6680	dm3_PILER_68.627	284	+	6561	6680	128,0,0	1	119
585	chr2L	6627	6836	dm3_PILER_69.623	328	+	6627	6836	0,0,64	1	209
585	chr2L	9725	9859	dm3_PILER_10.41	275	+	9725	9859	0,0,200	1	134
585	chr2L	47518	52564	dm3_PILER_5.4	44281	+	47518	52564	0,0,128	1	5046
585	chr2L	60493	60621	dm3_PILER_105.452	361	-	60493	60621	230,85,13	1	128
585	chr2L	64315	64939	dm3_PILER_100.45	4367	+	64315	64939	0,0,128	1	624
585	chr2L	116883	116989	dm3_PILER_105.452	629	-	116883	116989	230,85,13	1	106

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

PALS | PILER-DF | MUSCLE Repeats (pals_piler_muscle) Track Description


	Description This track shows the transposon fragments identified by RepeatMasker using the PALS+PILER+MUSCLE library. See the supplemental methods section of the manuscript for details. References Smit AFA, Hubley R, Green P. RepeatMasker Open-3.0. http://www.repeatmasker.org. 1996-2010.

Description