DASHR database schema
Sequence table
| Field | Example | SQL type | Description |
|---|---|---|---|
| rnaID | hsa-miR-200b-5p | varchar(255) | smRNA ID |
| rnaClass | mir-5p | varchar(255) | RNA class |
| chr | chr1 | varchar(255) | Reference sequence chromosome |
| chrStart | 1102504 | int(10) | Start position |
| chrEnd | 1102525 | int(10) | End position |
| strand | + | char(1) | + or - strand |
| len | 22 | int(10) | RNA length |
| seq | CAUCUUACUGGGCAGCAUUGGA | varchar(10000) | RNA sequence |
ID Table
| Field | Example | SQL type | Description |
|---|---|---|---|
| rnaID | ACA17 | varchar(50) | smRNA ID |
| hgncSymb | SNORA17 | varchar(50) | HGNC symbol |
| refSeqID | NR_002958 | varchar(20) | RefSeq ID |
| ucscID | uc004cis.2 | varchar(20) | UCSC ID |
| hgncUcscID | uc004cis.2 | varchar(20) | USCS ID provided in HGNC |
| description | Homo sapiens small nucleolar RNA, H/ACA box 17 (SN... | varchar(1000) | Small RNA description |
| hgncID | HGNC:32607 | varchar(50) | HGNC ID |
Annotation table
| Field | Example | SQL type | Description |
|---|---|---|---|
| rnaID | hsa-miR-200a-5p | varchar(1000) | smRNA ID |
| chr | chr1 | varchar(255) | Reference sequence chromosome |
| source | miRNA | varchar(255) | Data source |
| rnaClass | mir-5p | varchar(255) | RNA class |
| chrStart | 1103258 | int(11) | Start position |
| chrEnd | 1103279 | int(11) | End position |
| score | 0 | double | Score (e.g., GFF annotation confidence score) |
| strand | + | varchar(1) | + or - strand |
| frame | 0 | int(11) | Frame (GFF frame value) |
| attr | ID=MIMAT0001620_1;accession_number=MIMAT0001620;Na... | varchar(10000) | List of attributes |
Read coverage table
| Field | Example | SQL type | Description |
|---|---|---|---|
| tissue | adipose1 | varchar(100) | Tissue name |
| chr | chr1 | varchar(50) | Reference sequence chromosome |
| chrStart | 564886 | int(11) | Start position |
| chrEnd | 564887 | int(11) | End position |
| val | 408.84 | double | Read count or RPM |