Schema for REDfly Regulatory Elements - Regulatory Elements Annotated by REDfly

Database: dm6 Primary Table: REDfly_CRM Row Count: 16,181 Data last updated: 2022-10-20

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	11244	`int(10) unsigned`	range
`chromEnd`	11850	`int(10) unsigned`	range
`name`	Unspecified_VT0003	`varchar(255)`	values

Sample Rows

bin	chrom	chromStart	chromEnd	name
585	chr2L	11244	11850	Unspecified_VT0003
585	chr2L	16835	18924	Unspecified_VT0006
585	chr2L	18030	20238	Unspecified_VT0007
585	chr2L	26519	27246	Unspecified_VT0013
585	chr2L	35016	35517	Unspecified_STARR-S2-3541
585	chr2L	47310	47811	Unspecified_STARR-S2-877
585	chr2L	54046	56104	Unspecified_VT0025
585	chr2L	66697	67198	Unspecified_STARR-OSC-3356
585	chr2L	107318	107819	Unspecified_STARR-OSC-1427
585	chr2L	107812	108313	Unspecified_STARR-S2-2105

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

REDfly Regulatory Elements (REDfly) Track Description


	Description These tracks show the known Drosophila melanogaster Reporter Constructs (RCs), Cis-Regulatory Modules (CRMs), and Transcription Factor Binding Sites (TFBSs) that have been annotated by version 9.5.1 of REDfly. References Rivera J, Keränen SVE, Gallo SM, Halfon MS. REDfly: the transcriptional regulatory element database for Drosophila. Nucleic Acids Res. 2019 Jan 8;47(D1):D828-D834. doi: 10.1093/nar/gky957.

Description