Schema for mrnaRefseq
  Database: hg18    Primary Table: mrnaRefseq    Row Count: 245,006   Data last updated: 2007-03-30
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_001032367varchar(40) values RefSeq ID

Connected Tables and Joining Fields
        hg18.all_mrna.qName (via mrnaRefseq.mrna)
      hg18.mgcFullMrna.qName (via mrnaRefseq.mrna)
      hg18.mgcGenes.name (via mrnaRefseq.mrna)
      hg18.mrnaOrientInfo.name (via mrnaRefseq.mrna)
      hg18.orfeomeGenes.name (via mrnaRefseq.mrna)
      hg18.orfeomeMrna.qName (via mrnaRefseq.mrna)
      hgFixed.gbCdnaInfo.acc (via mrnaRefseq.mrna)
      hgFixed.gbSeq.acc (via mrnaRefseq.mrna)
      hgFixed.imageClone.acc (via mrnaRefseq.mrna)
      hg18.ccdsInfo.mrnaAcc (via mrnaRefseq.refseq)
      hg18.kgXref.refseq (via mrnaRefseq.refseq)
      hg18.knownToRefSeq.value (via mrnaRefseq.refseq)
      hg18.mrnaOrientInfo.name (via mrnaRefseq.refseq)
      hg18.refFlat.name (via mrnaRefseq.refseq)
      hg18.refGene.name (via mrnaRefseq.refseq)
      hg18.refSeqAli.qName (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_001032367
AB000095NM_003710
AB000095NM_181642
AB000099NM_005867
AB000114NM_005014
AB000115NM_006820
AB000220NM_006379
AB000221NM_002988
AB000263NM_001302
AB000275NM_004745

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