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

Database: dm6 Primary Table: flybase_miRNA Row Count: 747 Data last updated: 2024-01-05

field	example	SQL type	info
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	243034	`int(10) unsigned`	range
`chromEnd`	243141	`int(10) unsigned`	range
`name`	mir-965-RM	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	-	`char(1)`	values
`thickStart`	243034	`int(10) unsigned`	range
`thickEnd`	243141	`int(10) unsigned`	range
`reserved`	0	`int(10) unsigned`	range
`blockCount`	1	`int(11)`	range
`blockSizes`	107	`longblob`
`chromStarts`	0	`longblob`
`id`	FBtr0304343	`varchar(255)`	values
`description`	mir-965-RM	`longblob`

Sample Rows

chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	blockCount	blockSizes	id	description
chr2L	243034	243141	mir-965-RM	1000	-	243034	243141	1	107	FBtr0304343	mir-965-RM
chr2L	243054	243076	mir-965-RA	1000	-	243054	243076	1	22	FBtr0304344	mir-965-RA
chr2L	243095	243118	mir-965-RB	1000	-	243095	243118	1	23	FBtr0472777	mir-965-RB
chr2L	857541	857632	mir-375-RM	1000	+	857541	857632	1	91	FBtr0304182	mir-375-RM
chr2L	857555	857579	mir-375-RB	1000	+	857555	857579	1	24	FBtr0472769	mir-375-RB
chr2L	857595	857617	mir-375-RA	1000	+	857595	857617	1	22	FBtr0304183	mir-375-RA
chr2L	1831684	1831799	mir-2280-RM	1000	-	1831684	1831799	1	115	FBtr0304391	mir-2280-RM
chr2L	1831709	1831731	mir-2280-RB	1000	-	1831709	1831731	1	22	FBtr0304393	mir-2280-RB
chr2L	1831748	1831770	mir-2280-RA	1000	-	1831748	1831770	1	22	FBtr0304392	mir-2280-RA
chr2L	2737567	2737661	mir-4914-RM	1000	+	2737567	2737661	1	94	FBtr0309709	mir-4914-RM

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