Schema for FlyBase 6.06 Non-coding - FlyBase 6.06 Non-protein Coding Genes
|
|
Database: dm6 Primary Table: flybase606_ncRNA Row Count: 2,910
field | example | SQL type | info |
chrom | chr2L | varchar(255) | values |
chromStart | 21951 | int(10) unsigned | range |
chromEnd | 24237 | int(10) unsigned | range |
name | 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 | CR43609-RA | longblob | |
|
| |
|
|
Sample Rows
|
|
chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts | id | description |
---|
chr2L | 21951 | 24237 | CR43609-RA | 1000 | + | 21951 | 24237 | 0 | 2 | 990,1240 | 0,1046 | FBtr0309810 | CR43609-RA |
chr2L | 54816 | 55767 | CR46254-RA | 1000 | + | 54816 | 55767 | 0 | 1 | 951 | 0 | FBtr0347585 | CR46254-RA |
chr2L | 65998 | 66242 | CR45339-RA | 1000 | + | 65998 | 66242 | 0 | 1 | 244 | 0 | FBtr0345732 | CR45339-RA |
chr2L | 66317 | 66524 | CR45340-RA | 1000 | + | 66317 | 66524 | 0 | 1 | 207 | 0 | FBtr0345733 | CR45340-RA |
chr2L | 71038 | 73836 | CR44987-RA | 1000 | - | 71038 | 73836 | 0 | 1 | 2798 | 0 | FBtr0344052 | CR44987-RA |
chr2L | 71038 | 73836 | CR44987-RB | 1000 | - | 71038 | 73836 | 0 | 2 | 2604,82 | 0,2716 | FBtr0344053 | CR44987-RB |
chr2L | 122836 | 124031 | CR44969-RA | 1000 | + | 122836 | 124031 | 0 | 3 | 236,119,707 | 0,303,488 | FBtr0344032 | CR44969-RA |
chr2L | 135401 | 136128 | CR44185-RA | 1000 | + | 135401 | 136128 | 0 | 1 | 727 | 0 | FBtr0336836 | CR44185-RA |
chr2L | 136143 | 136701 | CR44186-RA | 1000 | + | 136143 | 136701 | 0 | 2 | 73,429 | 0,129 | FBtr0336837 | CR44186-RA |
chr2L | 219650 | 220050 | CR44220-RA | 1000 | + | 219650 | 220050 | 0 | 1 | 400 | 0 | FBtr0336984 | CR44220-RA |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
FlyBase 6.06 Non-coding (fb606ncgenes) Track Description
|
|
|