Schema for spMrna
  Database: hg18    Primary Table: spMrna    Row Count: 45,482   Data last updated: 2009-03-06
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID OR4F5_HUMANvarchar(255) values SWISS-PROT display ID
mrnaID uc001aal.1varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via spMrna.spID)
      hg18.kgXref.spDisplayID (via spMrna.spID)
      knownGeneV39.kgProtAlias.displayID (via spMrna.spID)
      knownGeneV39.kgSpAlias.alias (via spMrna.spID)
      knownGeneV39.kgXref.spDisplayID (via spMrna.spID)
      knownGeneV39.knownCanonical.protein (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
OR4F5_HUMANuc001aal.1
Q52R92_HUMANuc009vjh.1
OR4F3_HUMANuc001aaw.1
SAM11_HUMANuc001abw.1
Q96NU1-1uc001abx.1
Q5SV95_HUMANuc001abv.1
KLH17_HUMANuc001aca.1
Q86XA8_HUMANuc001acb.1
Q494U1-2uc001acd.1
PKHN1_HUMANuc001ace.1

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