Schema for knownToMrna

Database: hg19 Primary Table: knownToMrna Row Count: 10,196,332 Data last updated: 2025-09-29
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory

field	example	SQL type	description
`name`	ENST00000387314.1	`varchar(255)`	primary ID
`value`	LP895143	`varchar(255)`	associated ID, label, quantity etc.

Connected Tables and Joining Fields


	hg19.bioCycPathway.kgID (via knownToMrna.name) hg19.ceBlastTab.query (via knownToMrna.name) hg19.dmBlastTab.query (via knownToMrna.name) hg19.drBlastTab.query (via knownToMrna.name) hg19.foldUtr3.name (via knownToMrna.name) hg19.foldUtr5.name (via knownToMrna.name) hg19.gnfAtlas2Distance.query (via knownToMrna.name) hg19.gnfAtlas2Distance.target (via knownToMrna.name) hg19.gnfU95Distance.query (via knownToMrna.name) hg19.gnfU95Distance.target (via knownToMrna.name) hg19.humanHprdP2P.query (via knownToMrna.name) hg19.humanHprdP2P.target (via knownToMrna.name) hg19.humanVidalP2P.query (via knownToMrna.name) hg19.humanVidalP2P.target (via knownToMrna.name) hg19.humanWankerP2P.query (via knownToMrna.name) hg19.humanWankerP2P.target (via knownToMrna.name) hg19.keggPathway.kgID (via knownToMrna.name) hg19.kgAlias.kgID (via knownToMrna.name) hg19.kgColor.kgID (via knownToMrna.name) hg19.kgProtAlias.kgID (via knownToMrna.name) hg19.kgProtMap2.qName (via knownToMrna.name) hg19.kgSpAlias.kgID (via knownToMrna.name) hg19.kgTargetAli.qName (via knownToMrna.name) hg19.kgTxInfo.name (via knownToMrna.name) hg19.kgXref.kgID (via knownToMrna.name) hg19.knownAttrs.kgID (via knownToMrna.name) hg19.knownBlastTab.query (via knownToMrna.name) hg19.knownBlastTab.target (via knownToMrna.name) hg19.knownCanonical.transcript (via knownToMrna.name) hg19.knownCds.name (via knownToMrna.name) hg19.knownGene.name (via knownToMrna.name) hg19.knownGeneMrna.name (via knownToMrna.name) hg19.knownGenePep.name (via knownToMrna.name) hg19.knownGeneTxMrna.name (via knownToMrna.name) hg19.knownGeneTxPep.name (via knownToMrna.name) hg19.knownIsoforms.transcript (via knownToMrna.name) hg19.knownToAllenBrain.name (via knownToMrna.name) hg19.knownToEnsembl.name (via knownToMrna.name) hg19.knownToGnfAtlas2.name (via knownToMrna.name) hg19.knownToHInv.name (via knownToMrna.name) hg19.knownToHprd.name (via knownToMrna.name) hg19.knownToKeggEntrez.name (via knownToMrna.name) hg19.knownToLocusLink.name (via knownToMrna.name) hg19.knownToLynx.name (via knownToMrna.name) hg19.knownToMrnaSingle.name (via knownToMrna.name) hg19.knownToMupit.name (via knownToMrna.name) hg19.knownToNextProt.name (via knownToMrna.name) hg19.knownToPfam.name (via knownToMrna.name) hg19.knownToRefSeq.name (via knownToMrna.name) hg19.knownToSuper.gene (via knownToMrna.name) hg19.knownToTag.name (via knownToMrna.name) hg19.knownToTreefam.name (via knownToMrna.name) hg19.knownToU133.name (via knownToMrna.name) hg19.knownToU133Plus2.name (via knownToMrna.name) hg19.knownToU95.name (via knownToMrna.name) hg19.knownToVisiGene.name (via knownToMrna.name) hg19.knownToWikipedia.name (via knownToMrna.name) hg19.mmBlastTab.query (via knownToMrna.name) hg19.rnBlastTab.query (via knownToMrna.name) hg19.scBlastTab.query (via knownToMrna.name) hg19.ucscScop.ucscId (via knownToMrna.name) knownGeneV39.bioCycPathway.kgID (via knownToMrna.name) knownGeneV39.ceBlastTab.query (via knownToMrna.name) knownGeneV39.dmBlastTab.query (via knownToMrna.name) knownGeneV39.drBlastTab.query (via knownToMrna.name) knownGeneV39.foldUtr3.name (via knownToMrna.name) knownGeneV39.foldUtr5.name (via knownToMrna.name) knownGeneV39.gnfAtlas2Distance.query (via knownToMrna.name) knownGeneV39.gnfAtlas2Distance.target (via knownToMrna.name) knownGeneV39.kgAlias.kgID (via knownToMrna.name) knownGeneV39.kgColor.kgID (via knownToMrna.name) knownGeneV39.kgProtAlias.kgID (via knownToMrna.name) knownGeneV39.kgSpAlias.kgID (via knownToMrna.name) knownGeneV39.kgTargetAli.qName (via knownToMrna.name) knownGeneV39.kgXref.kgID (via knownToMrna.name) knownGeneV39.knownAttrs.kgID (via knownToMrna.name) knownGeneV39.knownBlastTab.query (via knownToMrna.name) knownGeneV39.knownBlastTab.target (via knownToMrna.name) knownGeneV39.knownCanonical.protein (via knownToMrna.name) knownGeneV39.knownCanonical.transcript (via knownToMrna.name) knownGeneV39.knownCds.name (via knownToMrna.name) knownGeneV39.knownGene.name (via knownToMrna.name) knownGeneV39.knownGeneMrna.name (via knownToMrna.name) knownGeneV39.knownGenePep.name (via knownToMrna.name) knownGeneV39.knownIsoforms.transcript (via knownToMrna.name) knownGeneV39.knownToEnsembl.name (via knownToMrna.name) knownGeneV39.knownToGnfAtlas2.name (via knownToMrna.name) knownGeneV39.knownToHprd.name (via knownToMrna.name) knownGeneV39.knownToLocusLink.name (via knownToMrna.name) knownGeneV39.knownToMrna.name (via knownToMrna.name) knownGeneV39.knownToMrnaSingle.name (via knownToMrna.name) knownGeneV39.knownToMupit.name (via knownToMrna.name) knownGeneV39.knownToPfam.name (via knownToMrna.name) knownGeneV39.knownToRefSeq.name (via knownToMrna.name) knownGeneV39.knownToSuper.gene (via knownToMrna.name) knownGeneV39.knownToTag.name (via knownToMrna.name) knownGeneV39.knownToU133.name (via knownToMrna.name) knownGeneV39.knownToU95.name (via knownToMrna.name) knownGeneV39.knownToVisiGene.name (via knownToMrna.name) knownGeneV39.knownToWikipedia.name (via knownToMrna.name) knownGeneV39.mmBlastTab.query (via knownToMrna.name) knownGeneV39.rnBlastTab.query (via knownToMrna.name) knownGeneV39.scBlastTab.query (via knownToMrna.name) knownGeneV39.ucscScop.ucscId (via knownToMrna.name)

Sample Rows

name	value
ENST00000387314.1	LP895143
ENST00000387314.1	DQ598675
ENST00000387314.1	JB137817
ENST00000387314.1	MK671731
ENST00000389680.2	LP895143
ENST00000389680.2	JB137817
ENST00000389680.2	DQ571525
ENST00000389680.2	DQ571526
ENST00000389680.2	HI965324
ENST00000389680.2	HV555498

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