Schema for FlyBase Non-coding - FlyBase Non-protein Coding Genes |
|---|
| |
Database: dm6 Primary Table: flybase_ncRNA Row Count: 3,060 Data last updated: 2024-01-05
| field | example | SQL type | info |
|---|
| chrom | chr2L | varchar(255) | values |
| chromStart | 21951 | int(10) unsigned | range |
| chromEnd | 24237 | int(10) unsigned | range |
| name | asRNA:CR43609-RA | varchar(255) | values |
| score | 1000 | int(10) unsigned | range |
| strand | + | char(1) | values |
| thickStart | 21951 | int(10) unsigned | range |
| thickEnd | 24237 | int(10) unsigned | range |
| reserved | 0 | int(10) unsigned | range |
| blockCount | 2 | int(11) | range |
| blockSizes | 990,1240 | longblob | |
| chromStarts | 0,1046 | longblob | |
| id | FBtr0309810 | varchar(255) | values |
| description | asRNA:CR43609-RA | longblob | |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts | id | description |
|---|
| chr2L | 21951 | 24237 | asRNA:CR43609-RA | 1000 | + | 21951 | 24237 | 0 | 2 | 990,1240 | 0,1046 | FBtr0309810 | asRNA:CR43609-RA |
| chr2L | 54816 | 55767 | lncRNA:CR46254-RA | 1000 | + | 54816 | 55767 | 0 | 1 | 951 | 0 | FBtr0347585 | lncRNA:CR46254-RA |
| chr2L | 65998 | 66242 | lncRNA:CR45339-RA | 1000 | + | 65998 | 66242 | 0 | 1 | 244 | 0 | FBtr0345732 | lncRNA:CR45339-RA |
| chr2L | 66317 | 66524 | lncRNA:CR45340-RA | 1000 | + | 66317 | 66524 | 0 | 1 | 207 | 0 | FBtr0345733 | lncRNA:CR45340-RA |
| chr2L | 71038 | 73836 | asRNA:CR44987-RB | 1000 | - | 71038 | 73836 | 0 | 2 | 2604,82 | 0,2716 | FBtr0344053 | asRNA:CR44987-RB |
| chr2L | 71038 | 73836 | asRNA:CR44987-RA | 1000 | - | 71038 | 73836 | 0 | 1 | 2798 | 0 | FBtr0344052 | asRNA:CR44987-RA |
| chr2L | 122836 | 124031 | asRNA:CR44969-RA | 1000 | + | 122836 | 124031 | 0 | 3 | 236,119,707 | 0,303,488 | FBtr0344032 | asRNA:CR44969-RA |
| chr2L | 135401 | 136128 | lncRNA:CR44185-RA | 1000 | + | 135401 | 136128 | 0 | 1 | 727 | 0 | FBtr0336836 | lncRNA:CR44185-RA |
| chr2L | 136143 | 136701 | lncRNA:CR44186-RA | 1000 | + | 136143 | 136701 | 0 | 2 | 73,429 | 0,129 | FBtr0336837 | lncRNA:CR44186-RA |
| chr2L | 219650 | 220050 | lncRNA:CR44220-RA | 1000 | + | 219650 | 220050 | 0 | 1 | 400 | 0 | FBtr0336984 | lncRNA:CR44220-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.
| |
|
|
|