Schema for Non-coding RNAs - FlyBase Non-coding RNAs |
|---|
| |
Database: DmojImproved Primary Table: flybase_pre_miRNA Row Count: 71
| field | example | SQL type | info |
|---|
| bin | 599 | smallint(5) unsigned | range |
| chrom | improved_6680 | varchar(255) | values |
| chromStart | 1963297 | int(10) unsigned | range |
| chromEnd | 1963388 | int(10) unsigned | range |
| name | FBtr0293078 | varchar(255) | values |
| score | 1000 | int(10) unsigned | range |
| strand | - | char(1) | values |
| thickStart | 1963297 | int(10) unsigned | range |
| thickEnd | 1963388 | int(10) unsigned | range |
| reserved | 0 | int(10) unsigned | range |
| blockCount | 1 | int(10) unsigned | range |
| blockSizes | 91, | longblob | |
| chromStarts | 0, | longblob | |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| bin | chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts |
|---|
| 599 | improved_6680 | 1963297 | 1963388 | FBtr0293078 | 1000 | - | 1963297 | 1963388 | 0 | 1 | 91, | 0, |
| 616 | improved_6680 | 4143310 | 4143392 | FBtr0293080 | 1000 | + | 4143310 | 4143392 | 0 | 1 | 82, | 0, |
| 617 | improved_6680 | 4316908 | 4317006 | FBtr0293082 | 1000 | - | 4316908 | 4317006 | 0 | 1 | 98, | 0, |
| 693 | improved_6680 | 14226515 | 14226590 | FBtr0293084 | 1000 | - | 14226515 | 14226590 | 0 | 1 | 75, | 0, |
| 703 | improved_6680 | 15475397 | 15475497 | FBtr0293086 | 1000 | + | 15475397 | 15475497 | 0 | 1 | 100, | 0, |
| 718 | improved_6680 | 17552838 | 17552931 | FBtr0293088 | 1000 | - | 17552838 | 17552931 | 0 | 1 | 93, | 0, |
| 726 | improved_6680 | 18485493 | 18485580 | FBtr0293090 | 1000 | + | 18485493 | 18485580 | 0 | 1 | 87, | 0, |
| 727 | improved_6680 | 18619771 | 18619866 | FBtr0293092 | 1000 | + | 18619771 | 18619866 | 0 | 1 | 95, | 0, |
| 729 | improved_6680 | 18891208 | 18891295 | FBtr0293094 | 1000 | + | 18891208 | 18891295 | 0 | 1 | 87, | 0, |
| 742 | improved_6680 | 20621838 | 20621927 | FBtr0293096 | 1000 | - | 20621838 | 20621927 | 0 | 1 | 89, | 0, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|
Non-coding RNAs (flybase_ncRNA) Track Description
|
|---|
| |
Description
This track shows the non-coding RNA annotations for D. mojavensis that were
generated by the Drosophila 12 Genomes Consortium. The annotations are available
for download at FlyBase.
References
| |
|
|
|