Schema for Natural TE - Transposable Elements Annotated by FlyBase

Database: dm6 Primary Table: transposon_LTR Row Count: 1,395

field	example	SQL type	info
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	9725	`int(10) unsigned`	range
`chromEnd`	9859	`int(10) unsigned`	range
`name`	Idefix{}2519	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	+	`char(1)`	values
`id`	FBti0060580	`varchar(255)`	values
`description`	Idefix{}2519	`longblob`

Sample Rows

chrom	chromStart	chromEnd	name	score	strand	id	description
chr2L	9725	9859	Idefix{}2519	1000	+	FBti0060580	Idefix{}2519
chr2L	123546	123635	McClintock{}2501	1000	-	FBti0060562	McClintock{}2501
chr2L	347940	355383	blood{}280	1000	-	FBti0019096	blood{}280
chr2L	686973	695955	roo{}281	1000	-	FBti0019098	roo{}281
chr2L	976934	984512	roo{}283	1000	+	FBti0019100	roo{}283
chr2L	996779	1005816	roo{}284	1000	-	FBti0019101	roo{}284
chr2L	1220183	1227592	blood{}285	1000	+	FBti0019102	blood{}285
chr2L	1301806	1302288	gypsy{}286	1000	-	FBti0019103	gypsy{}286
chr2L	1679031	1686439	blood{}289	1000	+	FBti0019106	blood{}289
chr2L	1711410	1711678	mdg3{}290	1000	-	FBti0019107	mdg3{}290

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

Natural TE (transposable_elements) Track Description

Description

This track shows the locations of the natural transposable elements that have been annotated by FlyBase in release 6.01. The color of each element corresponds to its repeat class:

Repeat Class	Description	Color
TIR	Terminal Inverted Repeats (DNA Transposons)
LINE	Long Interspersed Nuclear Elements (Retrotransposons)
LTR	Long Terminal Repeats (Retrotransposons)
DINE	Drosophila Interspersed Nuclear Elements
Foldback	Foldback Elements
Unclassified	Unclassified Elements

Credits

Transposable elements annotations were extracted from the GFF annotation files provided by FlyBase.