Schema for spMrna
  Database: hg16    Primary Table: spMrna    Row Count: 47,500   Data last updated: 2004-03-27
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID 143B_HUMANvarchar(255) values SWISS-PROT display ID
mrnaID BC001359varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        hg16.all_mrna.qName (via spMrna.mrnaID)
      hg16.altGraphX.mrnaRefs (via spMrna.mrnaID)
      hg16.dupSpMrna.dupMrnaID (via spMrna.mrnaID)
      hg16.dupSpMrna.mrnaID (via spMrna.mrnaID)
      hg16.mgcFullMrna.qName (via spMrna.mrnaID)
      hg16.mgcGenes.name (via spMrna.mrnaID)
      hg16.mrnaOrientInfo.name (via spMrna.mrnaID)
      hg16.mrnaRefseq.mrna (via spMrna.mrnaID)
      hgFixed.gbCdnaInfo.acc (via spMrna.mrnaID)
      hgFixed.gbSeq.acc (via spMrna.mrnaID)
      hgFixed.imageClone.acc (via spMrna.mrnaID)
      go.goaPart.dbObjectSymbol (via spMrna.spID)
      hg16.dupSpMrna.dupProteinID (via spMrna.spID)
      hg16.dupSpMrna.proteinID (via spMrna.spID)
      hg16.kgProtAlias.displayID (via spMrna.spID)
      hg16.kgXref.spDisplayID (via spMrna.spID)
      hg16.knownCanonical.protein (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
143B_HUMANBC001359
143E_HUMANBC001440
143F_HUMANBC003047
143G_HUMANBC020963
143S_HUMANBC023552
143T_HUMANBC056867
143Z_HUMANM86400
14P_HUMANBC005968
15E1_HUMANBC002638
1A01_HUMANBC003069

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