Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for refSeqStatus
  Database: bosTau4    Primary Table: refSeqStatus    Row Count: 9,844
Format description: RefSeq Gene Status.
fieldexampleSQL type info description
mrnaAcc NM_001045897varchar(255) values RefSeq gene accession name
status Provisionalenum('Unknown','Reviewed','Validated','Provisional','Predicted','Inferred') values Status (Reviewed, Provisional, Predicted)
mol mRNAenum('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
        bosTau4.gbCdnaInfo.acc (via refSeqStatus.mrnaAcc)
      bosTau4.gbSeq.acc (via refSeqStatus.mrnaAcc)
      bosTau4.gbStatus.acc (via refSeqStatus.mrnaAcc)
      bosTau4.imageClone.acc (via refSeqStatus.mrnaAcc)
      bosTau4.mrnaOrientInfo.name (via refSeqStatus.mrnaAcc)
      bosTau4.refFlat.name (via refSeqStatus.mrnaAcc)
      bosTau4.refGene.name (via refSeqStatus.mrnaAcc)
      bosTau4.refLink.mrnaAcc (via refSeqStatus.mrnaAcc)
      bosTau4.refSeqAli.qName (via refSeqStatus.mrnaAcc)
      bosTau4.refSeqSummary.mrnaAcc (via refSeqStatus.mrnaAcc)

  Sample Rows
 
mrnaAccstatusmol
NM_001045897ProvisionalmRNA
NM_001113282ProvisionalmRNA
NM_001111103ValidatedmRNA
NM_001083531PredictedmRNA
NM_174022ProvisionalmRNA
NM_001038155ProvisionalmRNA
NM_001098154ProvisionalmRNA
NM_001014956ProvisionalmRNA
NM_001113230ProvisionalmRNA
NM_001075146ProvisionalmRNA

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