Schema for REDfly Regulatory Elements - Regulatory Elements Annotated by REDfly

Database: dm6 Primary Table: REDfly_TFBS Row Count: 2,065 Data last updated: 2022-10-20

field	example	SQL type	info
`bin`	588	`smallint(5) unsigned`	range
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	523293	`int(10) unsigned`	range
`chromEnd`	523382	`int(10) unsigned`	range
`name`	ush_srp_ush:TF001823	`varchar(255)`	values

Sample Rows

bin	chrom	chromStart	chromEnd	name
588	chr2L	523293	523382	ush_srp_ush:TF001823
588	chr2L	523400	523407	ush_lz_ush:TF001822
603	chr2L	2445671	2446678	dpp_E(spl)_dpp:TF002034
603	chr2L	2445671	2446678	dpp_E2f_dpp:TF002035
603	chr2L	2445671	2446678	dpp_Eip78C_dpp:TF002036
603	chr2L	2445671	2446678	dpp_ey_dpp:TF002038
603	chr2L	2445671	2446678	dpp_toy_dpp:TF002039
603	chr2L	2445671	2446678	dpp_ubx_dpp:TF002037
603	chr2L	2445776	2445800	dpp_bin_dpp:TF000109
603	chr2L	2445846	2445869	dpp_bin_dpp:TF000108

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