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

Database: dm6 Primary Table: flybase_tRNA Row Count: 312 Data last updated: 2024-01-05

field	example	SQL type	info
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	1938088	`int(10) unsigned`	range
`chromEnd`	1938159	`int(10) unsigned`	range
`name`	tRNA:Gly-GCC-1-1-RA	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	-	`char(1)`	values
`thickStart`	1938088	`int(10) unsigned`	range
`thickEnd`	1938159	`int(10) unsigned`	range
`reserved`	0	`int(10) unsigned`	range
`blockCount`	1	`int(11)`	range
`blockSizes`	71	`longblob`
`chromStarts`	0	`longblob`
`id`	FBtr0077872	`varchar(255)`	values
`description`	tRNA:Gly-GCC-1-1-RA	`longblob`

Sample Rows

chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	blockCount	blockSizes	chromStarts	id	description
chr2L	1938088	1938159	tRNA:Gly-GCC-1-1-RA	1000	-	1938088	1938159	1	71	0	FBtr0077872	tRNA:Gly-GCC-1-1-RA
chr2L	1965425	1965498	tRNA:Arg-TCT-2-1-RA	1000	+	1965425	1965498	1	73	0	FBtr0077812	tRNA:Arg-TCT-2-1-RA
chr2L	2009154	2009226	tRNA:Gln-CTG-2-2-RA	1000	+	2009154	2009226	1	72	0	FBtr0077818	tRNA:Gln-CTG-2-2-RA
chr2L	2009537	2009609	tRNA:Gln-CTG-2-3-RA	1000	+	2009537	2009609	1	72	0	FBtr0077819	tRNA:Gln-CTG-2-3-RA
chr2L	2010645	2010717	tRNA:Gln-CTG-2-4-RA	1000	-	2010645	2010717	1	72	0	FBtr0077862	tRNA:Gln-CTG-2-4-RA
chr2L	2010868	2010940	tRNA:Gln-CTG-3-1-RA	1000	-	2010868	2010940	1	72	0	FBtr0077861	tRNA:Gln-CTG-3-1-RA
chr2L	2013178	2013250	tRNA:Gln-CTG-2-5-RA	1000	-	2013178	2013250	1	72	0	FBtr0077860	tRNA:Gln-CTG-2-5-RA
chr2L	2031691	2031762	tRNA:Gly-GCC-1-2-RA	1000	+	2031691	2031762	1	71	0	FBtr0077821	tRNA:Gly-GCC-1-2-RA
chr2L	2187006	2187079	tRNA:Arg-TCT-3-1-RA	1000	+	2187006	2187079	1	73	0	FBtr0077834	tRNA:Arg-TCT-3-1-RA
chr2L	2459923	2460044	tRNA:Tyr-GTA-1-2-RA	1000	-	2459923	2460044	2	36,37	0,84	FBtr0089299	tRNA:Tyr-GTA-1-2-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