Schema for mrnaRefseq
  Database: rn3    Primary Table: mrnaRefseq    Row Count: 247,138   Data last updated: 2004-03-23
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 AA001432varchar(40) values mRNA ID
refseq NM_000227varchar(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)
      rn3.all_mrna.qName (via mrnaRefseq.mrna)
      rn3.dupSpMrna.dupMrnaID (via mrnaRefseq.mrna)
      rn3.dupSpMrna.mrnaID (via mrnaRefseq.mrna)
      rn3.mgcFullMrna.qName (via mrnaRefseq.mrna)
      rn3.mgcGenes.name (via mrnaRefseq.mrna)
      rn3.mrnaOrientInfo.name (via mrnaRefseq.mrna)
      rn3.spMrna.mrnaID (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)
      rn3.kgXref.refseq (via mrnaRefseq.refseq)
      rn3.knownToRefSeq.value (via mrnaRefseq.refseq)
      rn3.mrnaOrientInfo.name (via mrnaRefseq.refseq)
      rn3.refFlat.name (via mrnaRefseq.refseq)
      rn3.refGene.name (via mrnaRefseq.refseq)
      rn3.refSeqAli.qName (via mrnaRefseq.refseq)

Sample Rows
 
mrnarefseq
AA001432NM_000227
AA001432NM_198129
AA002765XM_283770
AA003100XM_194592
AA003548XM_358343
AA008770XM_135190
AA009773NM_018706
AA011305NM_001814
AA011305NM_148170
AA013030NM_012446

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