Schema for mrnaRefseq
  Database: hg16    Primary Table: mrnaRefseq    Row Count: 247,913   Data last updated: 2004-03-27
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 AA000378varchar(40) values mRNA ID
refseq XM_283052varchar(40) values RefSeq ID

Connected Tables and Joining Fields
        hg16.all_mrna.qName (via mrnaRefseq.mrna)
      hg16.altGraphX.mrnaRefs (via mrnaRefseq.mrna)
      hg16.dupSpMrna.dupMrnaID (via mrnaRefseq.mrna)
      hg16.dupSpMrna.mrnaID (via mrnaRefseq.mrna)
      hg16.mgcFullMrna.qName (via mrnaRefseq.mrna)
      hg16.mgcGenes.name (via mrnaRefseq.mrna)
      hg16.mrnaOrientInfo.name (via mrnaRefseq.mrna)
      hg16.spMrna.mrnaID (via mrnaRefseq.mrna)
      hgFixed.gbCdnaInfo.acc (via mrnaRefseq.mrna)
      hgFixed.gbSeq.acc (via mrnaRefseq.mrna)
      hgFixed.imageClone.acc (via mrnaRefseq.mrna)
      hg16.altGraphX.mrnaRefs (via mrnaRefseq.refseq)
      hg16.kgXref.refseq (via mrnaRefseq.refseq)
      hg16.knownToRefSeq.value (via mrnaRefseq.refseq)
      hg16.mrnaOrientInfo.name (via mrnaRefseq.refseq)
      hg16.refFlat.name (via mrnaRefseq.refseq)
      hg16.refGene.name (via mrnaRefseq.refseq)
      hg16.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
AA000378XM_283052
AA000387XM_133606
AA000420XM_355214
AA000466XM_131829
AA001432NM_000227
AA001432NM_198129
AA002724XM_130596
AA002765XM_283770
AA002887XM_130932
AA003100XM_194592

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