Schema for spMrna
  Database: hg17    Primary Table: spMrna    Row Count: 38,468   Data last updated: 2005-06-07
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID 1433B_HUMANvarchar(255) values SWISS-PROT display ID
mrnaID NM_003404varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        hg17.all_mrna.qName (via spMrna.mrnaID)
      hg17.altGraphX.mrnaRefs (via spMrna.mrnaID)
      hg17.ccdsInfo.mrnaAcc (via spMrna.mrnaID)
      hg17.dupSpMrna.dupMrnaID (via spMrna.mrnaID)
      hg17.dupSpMrna.mrnaID (via spMrna.mrnaID)
      hg17.kgXref.refseq (via spMrna.mrnaID)
      hg17.knownToRefSeq.value (via spMrna.mrnaID)
      hg17.mgcFullMrna.qName (via spMrna.mrnaID)
      hg17.mgcGenes.name (via spMrna.mrnaID)
      hg17.mrnaOrientInfo.name (via spMrna.mrnaID)
      hg17.mrnaRefseq.mrna (via spMrna.mrnaID)
      hg17.mrnaRefseq.refseq (via spMrna.mrnaID)
      hg17.orfeomeGenes.name (via spMrna.mrnaID)
      hg17.orfeomeMrna.qName (via spMrna.mrnaID)
      hg17.refFlat.name (via spMrna.mrnaID)
      hg17.refGene.name (via spMrna.mrnaID)
      hg17.refSeqAli.qName (via spMrna.mrnaID)
      hgFixed.gbCdnaInfo.acc (via spMrna.mrnaID)
      hgFixed.gbSeq.acc (via spMrna.mrnaID)
      hgFixed.imageClone.acc (via spMrna.mrnaID)
      hgFixed.refLink.mrnaAcc (via spMrna.mrnaID)
      hgFixed.refSeqStatus.mrnaAcc (via spMrna.mrnaID)
      hgFixed.refSeqSummary.mrnaAcc (via spMrna.mrnaID)
      knownGeneV39.kgXref.refseq (via spMrna.mrnaID)
      knownGeneV39.knownToRefSeq.value (via spMrna.mrnaID)
      go.goaPart.dbObjectSymbol (via spMrna.spID)
      hg17.dupSpMrna.dupProteinID (via spMrna.spID)
      hg17.dupSpMrna.proteinID (via spMrna.spID)
      hg17.kgProtAlias.displayID (via spMrna.spID)
      hg17.kgSpAlias.alias (via spMrna.spID)
      hg17.kgXref.spDisplayID (via spMrna.spID)
      hg17.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
1433B_HUMANNM_003404
1433E_HUMANNM_006761
1433F_HUMANNM_003405
1433G_HUMANNM_012479
1433S_HUMANNM_006142
1433T_HUMANNM_006826
1433Z_HUMANBC083508
1433Z_HUMANNM_145690
15E1_HUMANNM_016399
15E2_HUMANNM_176818

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