Schema for Non-coding RNAs - FlyBase Non-coding RNAs |
|---|
| |
Database: DmojImproved Primary Table: flybase_snRNA Row Count: 30
| field | example | SQL type | info |
|---|
| bin | 592 | smallint(5) unsigned | range |
| chrom | improved_6680 | varchar(255) | values |
| chromStart | 1002099 | int(10) unsigned | range |
| chromEnd | 1002221 | int(10) unsigned | range |
| name | FBtr0293535 | varchar(255) | values |
| score | 1000 | int(10) unsigned | range |
| strand | - | char(1) | values |
| thickStart | 1002099 | int(10) unsigned | range |
| thickEnd | 1002221 | int(10) unsigned | range |
| reserved | 0 | int(10) unsigned | range |
| blockCount | 1 | int(10) unsigned | range |
| blockSizes | 122, | longblob | |
| chromStarts | 0, | longblob | |
|
| |
|
|
|
Sample Rows
|
|---|
| |
| bin | chrom | chromStart | chromEnd | name | score | strand | thickStart | thickEnd | reserved | blockCount | blockSizes | chromStarts |
|---|
| 592 | improved_6680 | 1002099 | 1002221 | FBtr0293535 | 1000 | - | 1002099 | 1002221 | 0 | 1 | 122, | 0, |
| 592 | improved_6680 | 1002486 | 1002678 | FBtr0293525 | 1000 | + | 1002486 | 1002678 | 0 | 1 | 192, | 0, |
| 604 | improved_6680 | 2526812 | 2527076 | FBtr0293516 | 1000 | + | 2526812 | 2527076 | 0 | 1 | 264, | 0, |
| 653 | scaffold_6500 | 9043846 | 9043944 | FBtr0293539 | 1000 | + | 9043846 | 9043944 | 0 | 1 | 98, | 0, |
| 690 | scaffold_6500 | 13850662 | 13850805 | FBtr0293526 | 1000 | + | 13850662 | 13850805 | 0 | 1 | 143, | 0, |
| 690 | scaffold_6500 | 13880638 | 13880781 | FBtr0293527 | 1000 | - | 13880638 | 13880781 | 0 | 1 | 143, | 0, |
| 701 | scaffold_6500 | 15233920 | 15234111 | FBtr0293519 | 1000 | + | 15233920 | 15234111 | 0 | 1 | 191, | 0, |
| 701 | scaffold_6500 | 15239571 | 15239762 | FBtr0293520 | 1000 | - | 15239571 | 15239762 | 0 | 1 | 191, | 0, |
| 701 | scaffold_6500 | 15239977 | 15240103 | FBtr0293530 | 1000 | + | 15239977 | 15240103 | 0 | 1 | 126, | 0, |
| 701 | scaffold_6500 | 15268563 | 15268691 | FBtr0293531 | 1000 | + | 15268563 | 15268691 | 0 | 1 | 128, | 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
| |
|
|
|