Schema for FlyBase Non-coding - FlyBase Non-protein Coding Genes

Database: dm6 Primary Table: flybase_miscRNA Row Count: 417 Data last updated: 2024-01-05

field	example	SQL type	info
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	232165	`int(10) unsigned`	range
`chromEnd`	232253	`int(10) unsigned`	range
`name`	snoRNA:kis-a-RA	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	-	`char(1)`	values
`thickStart`	232165	`int(10) unsigned`	range
`thickEnd`	232253	`int(10) unsigned`	range
`reserved`	0	`int(10) unsigned`	range
`blockCount`	1	`int(11)`	range
`blockSizes`	88	`longblob`
`chromStarts`	0	`longblob`
`id`	FBtr0309764	`varchar(255)`	values
`description`	snoRNA:kis-a-RA	`longblob`

Sample Rows

chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	blockCount	blockSizes	id	description
chr2L	232165	232253	snoRNA:kis-a-RA	1000	-	232165	232253	1	88	FBtr0309764	snoRNA:kis-a-RA
chr2L	901490	901654	snRNA:U1:21D-RA	1000	-	901490	901654	1	164	FBtr0078028	snRNA:U1:21D-RA
chr2L	901975	902082	scaRNA:MeU1:95C-A24-RA	1000	-	901975	902082	1	107	FBtr0474086	scaRNA:MeU1:95C-A24-RA
chr2L	2014448	2014575	snoRNA:Or-CD14-RA	1000	-	2014448	2014575	1	127	FBtr0474088	snoRNA:Or-CD14-RA
chr2L	3046764	3046880	snRNA:LU-RD	1000	+	3046764	3046880	1	116	FBtr0452214	snRNA:LU-RD
chr2L	3048700	3048831	snRNA:U5:23D-RA	1000	+	3048700	3048831	1	131	FBtr0077658	snRNA:U5:23D-RA
chr2L	4457602	4457674	snoRNA:Me18S-C1831-RA	1000	-	4457602	4457674	1	72	FBtr0091653	snoRNA:Me18S-C1831-RA
chr2L	5202382	5202522	snoRNA:Psi18S-525k-RA	1000	+	5202382	5202522	1	140	FBtr0113538	snoRNA:Psi18S-525k-RA
chr2L	5437633	5437749	snoRNA:Me28S-A2486-RA	1000	-	5437633	5437749	1	116	FBtr0114309	snoRNA:Me28S-A2486-RA
chr2L	5565618	5565766	snRNA:U4:25F-RA	1000	+	5565618	5565766	1	148	FBtr0079108	snRNA:U4:25F-RA

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

FlyBase Non-coding (fbncgenes) Track Description


	Description This track shows the non-protein coding genes that have been annotated by FlyBase. These annotations correspond to D. melanogaster release 6.55. Credits Thanks to FlyBase for providing these annotations. References Gramates LS, Agapite J, Attrill H, Calvi BR, Crosby MA, Dos Santos G, Goodman JL, Goutte-Gattat D, Jenkins VK, Kaufman T, Larkin A, Matthews BB, Millburn G, Strelets VB; the FlyBase Consortium. FlyBase: a guided tour of highlighted features. Genetics. 2022 Apr 4;220(4):iyac035.

Description