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

Database: dm6 Primary Table: flybase_miRNA Row Count: 747 Data last updated: 2024-08-23

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.58. Credits Thanks to FlyBase for providing these annotations. References Öztürk-Çolak A, Marygold SJ, Antonazzo G, Attrill H, Goutte-Gattat D, Jenkins VK, Matthews BB, Millburn G, Dos Santos G, Tabone CJ; FlyBase Consortium. FlyBase: updates to the Drosophila genes and genomes database. Genetics. 2024 May 7;227(1):iyad211. doi: 10.1093/genetics/iyad211. PMID: 38301657; PMCID: PMC11075543.

Description