DASHR database schema

Sequence table

FieldExampleSQL typeDescription
rnaIDhsa-miR-200b-5pvarchar(255)smRNA ID
rnaClassmir-5pvarchar(255)RNA class
chrchr1varchar(255)Reference sequence chromosome
chrStart1102504int(10)Start position
chrEnd1102525int(10)End position
strand+char(1)+ or - strand
len22int(10)RNA length
seqCAUCUUACUGGGCAGCAUUGGAvarchar(10000)RNA sequence

ID Table

FieldExampleSQL typeDescription
rnaIDACA17varchar(50)smRNA ID
hgncSymbSNORA17varchar(50)HGNC symbol
refSeqIDNR_002958varchar(20)RefSeq ID
ucscIDuc004cis.2varchar(20)UCSC ID
hgncUcscIDuc004cis.2varchar(20)USCS ID provided in HGNC
descriptionHomo sapiens small nucleolar RNA, H/ACA box 17 (SN...varchar(1000)Small RNA description
hgncIDHGNC:32607varchar(50)HGNC ID

Annotation table

FieldExampleSQL typeDescription
rnaIDhsa-miR-200a-5pvarchar(1000)smRNA ID
chrchr1varchar(255)Reference sequence chromosome
sourcemiRNAvarchar(255)Data source
rnaClassmir-5pvarchar(255)RNA class
chrStart1103258int(11)Start position
chrEnd1103279int(11)End position
score0doubleScore (e.g., GFF annotation confidence score)
strand+varchar(1)+ or - strand
frame0int(11)Frame (GFF frame value)
attrID=MIMAT0001620_1;accession_number=MIMAT0001620;Na...varchar(10000)List of attributes

Read coverage table

FieldExampleSQL typeDescription
tissueadipose1varchar(100)Tissue name
chrchr1varchar(50)Reference sequence chromosome
chrStart564886int(11)Start position
chrEnd564887int(11)End position
val408.84doubleRead count or RPM