Schema for mrnaRefseq
  Database: rn4    Primary Table: mrnaRefseq    Row Count: 448,214   Data last updated: 2006-03-02
Format description: Cross reference table between refseq and mRNA IDs based on LocusLink
On download server: MariaDB table dump directory
fieldexampleSQL type info description
mrna A00127varchar(40) values mRNA ID
refseq NM_005929varchar(40) values RefSeq ID

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.acc (via mrnaRefseq.mrna)
      hgFixed.gbSeq.acc (via mrnaRefseq.mrna)
      hgFixed.imageClone.acc (via mrnaRefseq.mrna)
      rn4.all_mrna.qName (via mrnaRefseq.mrna)
      rn4.mgcFullMrna.qName (via mrnaRefseq.mrna)
      rn4.mgcGenes.name (via mrnaRefseq.mrna)
      rn4.mrnaOrientInfo.name (via mrnaRefseq.mrna)
      hgFixed.gbCdnaInfo.acc (via mrnaRefseq.refseq)
      hgFixed.gbSeq.acc (via mrnaRefseq.refseq)
      hgFixed.imageClone.acc (via mrnaRefseq.refseq)
      hgFixed.refLink.mrnaAcc (via mrnaRefseq.refseq)
      hgFixed.refSeqStatus.mrnaAcc (via mrnaRefseq.refseq)
      hgFixed.refSeqSummary.mrnaAcc (via mrnaRefseq.refseq)
      knownGeneV39.kgXref.refseq (via mrnaRefseq.refseq)
      knownGeneV39.knownToRefSeq.value (via mrnaRefseq.refseq)
      rn4.mrnaOrientInfo.name (via mrnaRefseq.refseq)
      rn4.refFlat.name (via mrnaRefseq.refseq)
      rn4.refGene.name (via mrnaRefseq.refseq)
      rn4.refSeqAli.qName (via mrnaRefseq.refseq)
      rn4.rgdGene2ToRefSeq.value (via mrnaRefseq.refseq)

Sample Rows
 
mrnarefseq
A00127NM_005929
A00127NM_033316
A00145NM_001017411
A00147NM_174085
A00209NM_002462
A00469NM_000515
A00469NM_022559
A00469NM_022560
A00469NM_022561
A00469NM_022562

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