Schema for mrnaRefseq
  Database: hg17    Primary Table: mrnaRefseq    Row Count: 169,150   Data last updated: 2005-06-22
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 AB000095varchar(40) values mRNA ID
refseq NM_003710varchar(40) values RefSeq ID

Connected Tables and Joining Fields
        hg17.all_mrna.qName (via mrnaRefseq.mrna)
      hg17.altGraphX.mrnaRefs (via mrnaRefseq.mrna)
      hg17.dupSpMrna.dupMrnaID (via mrnaRefseq.mrna)
      hg17.dupSpMrna.mrnaID (via mrnaRefseq.mrna)
      hg17.mgcFullMrna.qName (via mrnaRefseq.mrna)
      hg17.mgcGenes.name (via mrnaRefseq.mrna)
      hg17.mrnaOrientInfo.name (via mrnaRefseq.mrna)
      hg17.orfeomeGenes.name (via mrnaRefseq.mrna)
      hg17.orfeomeMrna.qName (via mrnaRefseq.mrna)
      hg17.spMrna.mrnaID (via mrnaRefseq.mrna)
      hgFixed.gbCdnaInfo.acc (via mrnaRefseq.mrna)
      hgFixed.gbSeq.acc (via mrnaRefseq.mrna)
      hgFixed.imageClone.acc (via mrnaRefseq.mrna)
      hg17.altGraphX.mrnaRefs (via mrnaRefseq.refseq)
      hg17.ccdsInfo.mrnaAcc (via mrnaRefseq.refseq)
      hg17.dupSpMrna.dupMrnaID (via mrnaRefseq.refseq)
      hg17.dupSpMrna.mrnaID (via mrnaRefseq.refseq)
      hg17.kgXref.refseq (via mrnaRefseq.refseq)
      hg17.knownToRefSeq.value (via mrnaRefseq.refseq)
      hg17.mrnaOrientInfo.name (via mrnaRefseq.refseq)
      hg17.refFlat.name (via mrnaRefseq.refseq)
      hg17.refGene.name (via mrnaRefseq.refseq)
      hg17.refSeqAli.qName (via mrnaRefseq.refseq)
      hg17.spMrna.mrnaID (via mrnaRefseq.refseq)
      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)

Sample Rows
 
mrnarefseq
AB000095NM_003710
AB000095NM_181642
AB000099NM_005867
AB000114NM_005014
AB000115NM_006820
AB000220NM_006379
AB000221NM_002988
AB000263NM_001302
AB000275NM_004745
AB000276NM_001003809

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