Schema for refSeqStatus
Database: hg19    Primary Table: refSeqStatus    Row Count: 305,914
Format description: RefSeq Gene Status.
fieldexampleSQL type info description
mrnaAcc NR_026498varchar(255) values RefSeq gene accession name
status Reviewedenum('Unknown','Reviewed','Validated','Provisional','Predicted','Inferred') values Status of RefSeq
mol rRNAenum('DNA','RNA','ds-RNA','ds-mRNA','ds-rRNA','mRNA','ms-DNA','ms-RNA','rRNA','scRNA','snRNA','snoRNA','ss-DNA','ss-RNA','ss-snoRNA','tRNA','cRNA','ss-cRNA','ds-cRNA') values molecule type
Connected Tables and Joining Fields
      hg19.ccdsInfo.mrnaAcc (via refSeqStatus.mrnaAcc)
      hg19.gbCdnaInfo.acc (via refSeqStatus.mrnaAcc)
      hg19.gbSeq.acc (via refSeqStatus.mrnaAcc)
      hg19.gbStatus.acc (via refSeqStatus.mrnaAcc)
      hg19.imageClone.acc (via refSeqStatus.mrnaAcc)
      hg19.kgXref.refseq (via refSeqStatus.mrnaAcc)
      hg19.knownToRefSeq.value (via refSeqStatus.mrnaAcc)
      hg19.mrnaOrientInfo.name (via refSeqStatus.mrnaAcc)
      hg19.refFlat.name (via refSeqStatus.mrnaAcc)
      hg19.refGene.name (via refSeqStatus.mrnaAcc)
      hg19.refLink.mrnaAcc (via refSeqStatus.mrnaAcc)
      hg19.refSeqAli.qName (via refSeqStatus.mrnaAcc)
      hg19.refSeqSummary.mrnaAcc (via refSeqStatus.mrnaAcc)
      hg19.seq.acc (via refSeqStatus.mrnaAcc)
Sample Rows
mrnaAccstatusmol
NR_026498ReviewedrRNA
NR_025344ReviewedrRNA
NR_025894ReviewedrRNA
NR_025144ReviewedrRNA
NR_026430ReviewedrRNA
NR_025326ReviewedrRNA
NR_025916ReviewedrRNA
NR_025582ReviewedrRNA
NR_025173ReviewedrRNA
NR_025327ReviewedrRNA

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.