Schema for knownGene
  Database: knownGeneV39    Primary Table: knownGene    Row Count: 266,064   Data last updated: 2022-01-17
On download server: MariaDB table dump directory
fieldexampleSQL type info
name ENST00000619216.1varchar(255) values
chrom chr1varchar(255) values
strand -char(1) values
txStart 17368int(10) unsigned range
txEnd 17436int(10) unsigned range
cdsStart 17368int(10) unsigned range
cdsEnd 17368int(10) unsigned range
exonCount 1int(10) unsigned range
exonStarts 17368,longblob  
exonEnds 17436,longblob  
proteinID  varchar(40) values
alignID uc031tla.1varchar(255) values

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownGene.name)
      hg16.dmBlastTab.query (via knownGene.name)
      hg16.drBlastTab.query (via knownGene.name)
      hg16.dupSpMrna.mrnaID (via knownGene.name)
      hg16.foldUtr3.name (via knownGene.name)
      hg16.foldUtr5.name (via knownGene.name)
      hg16.gnfAtlas2Distance.query (via knownGene.name)
      hg16.gnfAtlas2Distance.target (via knownGene.name)
      hg16.gnfU95Distance.query (via knownGene.name)
      hg16.gnfU95Distance.target (via knownGene.name)
      hg16.hg17Kg.name (via knownGene.name)
      hg16.keggPathway.kgID (via knownGene.name)
      hg16.kgAlias.kgID (via knownGene.name)
      hg16.kgProtAlias.kgID (via knownGene.name)
      hg16.kgXref.kgID (via knownGene.name)
      hg16.knownBlastTab.query (via knownGene.name)
      hg16.knownBlastTab.target (via knownGene.name)
      hg16.knownCanonical.transcript (via knownGene.name)
      hg16.knownGene.name (via knownGene.name)
      hg16.knownGeneLink.name (via knownGene.name)
      hg16.knownGeneMrna.name (via knownGene.name)
      hg16.knownGenePep.name (via knownGene.name)
      hg16.knownIsoforms.transcript (via knownGene.name)
      hg16.knownToEnsembl.name (via knownGene.name)
      hg16.knownToGnfAtlas2.name (via knownGene.name)
      hg16.knownToHInv.name (via knownGene.name)
      hg16.knownToLocusLink.name (via knownGene.name)
      hg16.knownToPfam.name (via knownGene.name)
      hg16.knownToRefSeq.name (via knownGene.name)
      hg16.knownToSuper.gene (via knownGene.name)
      hg16.knownToU133.name (via knownGene.name)
      hg16.knownToU95.name (via knownGene.name)
      hg16.scBlastTab.query (via knownGene.name)
      hg17.bioCycPathway.kgID (via knownGene.name)
      hg17.ccdsKgMap.geneId (via knownGene.name)
      hg17.ceBlastTab.query (via knownGene.name)
      hg17.dmBlastTab.query (via knownGene.name)
      hg17.drBlastTab.query (via knownGene.name)
      hg17.dupSpMrna.mrnaID (via knownGene.name)
      hg17.foldUtr3.name (via knownGene.name)
      hg17.foldUtr5.name (via knownGene.name)
      hg17.gladHumESDistance.query (via knownGene.name)
      hg17.gladHumESDistance.target (via knownGene.name)
      hg17.gnfAtlas2Distance.query (via knownGene.name)
      hg17.gnfAtlas2Distance.target (via knownGene.name)
      hg17.gnfU95Distance.query (via knownGene.name)
      hg17.gnfU95Distance.target (via knownGene.name)
      hg17.humanHprdP2P.query (via knownGene.name)
      hg17.humanHprdP2P.target (via knownGene.name)
      hg17.humanVidalP2P.query (via knownGene.name)
      hg17.humanVidalP2P.target (via knownGene.name)
      hg17.humanWankerP2P.query (via knownGene.name)
      hg17.humanWankerP2P.target (via knownGene.name)
      hg17.keggPathway.kgID (via knownGene.name)
      hg17.kgAlias.kgID (via knownGene.name)
      hg17.kgProtAlias.kgID (via knownGene.name)
      hg17.kgSpAlias.kgID (via knownGene.name)
      hg17.kgTargetAli.qName (via knownGene.name)
      hg17.kgXref.kgID (via knownGene.name)
      hg17.knownBlastTab.query (via knownGene.name)
      hg17.knownBlastTab.target (via knownGene.name)
      hg17.knownCanonical.transcript (via knownGene.name)
      hg17.knownExpDistance.query (via knownGene.name)
      hg17.knownExpDistance.target (via knownGene.name)
      hg17.knownGene.name (via knownGene.name)
      hg17.knownGeneLink.name (via knownGene.name)
      hg17.knownGeneMrna.name (via knownGene.name)
      hg17.knownGenePep.name (via knownGene.name)
      hg17.knownIsoforms.transcript (via knownGene.name)
      hg17.knownToAllenBrain.name (via knownGene.name)
      hg17.knownToEnsembl.name (via knownGene.name)
      hg17.knownToGnf1h.name (via knownGene.name)
      hg17.knownToGnfAtlas2.name (via knownGene.name)
      hg17.knownToHInv.name (via knownGene.name)
      hg17.knownToHprd.name (via knownGene.name)
      hg17.knownToKeggEntrez.name (via knownGene.name)
      hg17.knownToLocusLink.name (via knownGene.name)
      hg17.knownToPfam.name (via knownGene.name)
      hg17.knownToRefSeq.name (via knownGene.name)
      hg17.knownToSuper.gene (via knownGene.name)
      hg17.knownToU133.name (via knownGene.name)
      hg17.knownToU133Plus2.name (via knownGene.name)
      hg17.knownToU95.name (via knownGene.name)
      hg17.knownToVisiGene.name (via knownGene.name)
      hg17.mmBlastTab.query (via knownGene.name)
      hg17.rankProp.query (via knownGene.name)
      hg17.rankProp.target (via knownGene.name)
      hg17.rnBlastTab.query (via knownGene.name)
      hg17.scBlastTab.query (via knownGene.name)
      hg18.bioCycPathway.kgID (via knownGene.name)
      hg18.ccdsKgMap.geneId (via knownGene.name)
      hg18.ceBlastTab.query (via knownGene.name)
      hg18.dmBlastTab.query (via knownGene.name)
      hg18.drBlastTab.query (via knownGene.name)
      hg18.foldUtr3.name (via knownGene.name)
      hg18.foldUtr5.name (via knownGene.name)
      hg18.gnfAtlas2Distance.query (via knownGene.name)
      hg18.gnfAtlas2Distance.target (via knownGene.name)
      hg18.gnfU95Distance.query (via knownGene.name)
      hg18.gnfU95Distance.target (via knownGene.name)
      hg18.humanHprdP2P.query (via knownGene.name)
      hg18.humanHprdP2P.target (via knownGene.name)
      hg18.humanVidalP2P.query (via knownGene.name)
      hg18.humanVidalP2P.target (via knownGene.name)
      hg18.humanWankerP2P.query (via knownGene.name)
      hg18.humanWankerP2P.target (via knownGene.name)
      hg18.keggPathway.kgID (via knownGene.name)
      hg18.kgAlias.kgID (via knownGene.name)
      hg18.kgColor.kgID (via knownGene.name)
      hg18.kgProtAlias.kgID (via knownGene.name)
      hg18.kgProtMap2.qName (via knownGene.name)
      hg18.kgSpAlias.kgID (via knownGene.name)
      hg18.kgTargetAli.qName (via knownGene.name)
      hg18.kgTxInfo.name (via knownGene.name)
      hg18.kgXref.kgID (via knownGene.name)
      hg18.knownBlastTab.query (via knownGene.name)
      hg18.knownBlastTab.target (via knownGene.name)
      hg18.knownCanonToDecipher.name (via knownGene.name)
      hg18.knownCanonical.protein (via knownGene.name)
      hg18.knownCanonical.transcript (via knownGene.name)
      hg18.knownGene.name (via knownGene.name)
      hg18.knownGeneMrna.name (via knownGene.name)
      hg18.knownGenePep.name (via knownGene.name)
      hg18.knownIsoforms.transcript (via knownGene.name)
      hg18.knownToAllenBrain.name (via knownGene.name)
      hg18.knownToDecipher.name (via knownGene.name)
      hg18.knownToEnsembl.name (via knownGene.name)
      hg18.knownToGnf1h.name (via knownGene.name)
      hg18.knownToGnfAtlas2.name (via knownGene.name)
      hg18.knownToHInv.name (via knownGene.name)
      hg18.knownToHprd.name (via knownGene.name)
      hg18.knownToKeggEntrez.name (via knownGene.name)
      hg18.knownToLocusLink.name (via knownGene.name)
      hg18.knownToMupit.name (via knownGene.name)
      hg18.knownToPfam.name (via knownGene.name)
      hg18.knownToRefSeq.name (via knownGene.name)
      hg18.knownToSuper.gene (via knownGene.name)
      hg18.knownToTreefam.name (via knownGene.name)
      hg18.knownToU133.name (via knownGene.name)
      hg18.knownToU133Plus2.name (via knownGene.name)
      hg18.knownToU95.name (via knownGene.name)
      hg18.knownToVisiGene.name (via knownGene.name)
      hg18.mmBlastTab.query (via knownGene.name)
      hg18.rnBlastTab.query (via knownGene.name)
      hg18.scBlastTab.query (via knownGene.name)
      hg18.ucscScop.ucscId (via knownGene.name)
      hg19.bioCycPathway.kgID (via knownGene.name)
      hg19.ceBlastTab.query (via knownGene.name)
      hg19.dmBlastTab.query (via knownGene.name)
      hg19.drBlastTab.query (via knownGene.name)
      hg19.foldUtr3.name (via knownGene.name)
      hg19.foldUtr5.name (via knownGene.name)
      hg19.gnfAtlas2Distance.query (via knownGene.name)
      hg19.gnfAtlas2Distance.target (via knownGene.name)
      hg19.gnfU95Distance.query (via knownGene.name)
      hg19.gnfU95Distance.target (via knownGene.name)
      hg19.humanHprdP2P.query (via knownGene.name)
      hg19.humanHprdP2P.target (via knownGene.name)
      hg19.humanVidalP2P.query (via knownGene.name)
      hg19.humanVidalP2P.target (via knownGene.name)
      hg19.humanWankerP2P.query (via knownGene.name)
      hg19.humanWankerP2P.target (via knownGene.name)
      hg19.keggPathway.kgID (via knownGene.name)
      hg19.kgAlias.kgID (via knownGene.name)
      hg19.kgColor.kgID (via knownGene.name)
      hg19.kgProtAlias.kgID (via knownGene.name)
      hg19.kgProtMap2.qName (via knownGene.name)
      hg19.kgSpAlias.kgID (via knownGene.name)
      hg19.kgTargetAli.qName (via knownGene.name)
      hg19.kgTxInfo.name (via knownGene.name)
      hg19.kgXref.kgID (via knownGene.name)
      hg19.knownAttrs.kgID (via knownGene.name)
      hg19.knownBlastTab.query (via knownGene.name)
      hg19.knownBlastTab.target (via knownGene.name)
      hg19.knownCanonToDecipher.name (via knownGene.name)
      hg19.knownCanonical.transcript (via knownGene.name)
      hg19.knownCds.name (via knownGene.name)
      hg19.knownGene.name (via knownGene.name)
      hg19.knownGeneMrna.name (via knownGene.name)
      hg19.knownGenePep.name (via knownGene.name)
      hg19.knownGeneTxMrna.name (via knownGene.name)
      hg19.knownGeneTxPep.name (via knownGene.name)
      hg19.knownIsoforms.transcript (via knownGene.name)
      hg19.knownToAllenBrain.name (via knownGene.name)
      hg19.knownToDecipher.name (via knownGene.name)
      hg19.knownToEnsembl.name (via knownGene.name)
      hg19.knownToGnfAtlas2.name (via knownGene.name)
      hg19.knownToHInv.name (via knownGene.name)
      hg19.knownToHprd.name (via knownGene.name)
      hg19.knownToKeggEntrez.name (via knownGene.name)
      hg19.knownToLocusLink.name (via knownGene.name)
      hg19.knownToLynx.name (via knownGene.name)
      hg19.knownToMrna.name (via knownGene.name)
      hg19.knownToMrnaSingle.name (via knownGene.name)
      hg19.knownToMupit.name (via knownGene.name)
      hg19.knownToNextProt.name (via knownGene.name)
      hg19.knownToPfam.name (via knownGene.name)
      hg19.knownToRefSeq.name (via knownGene.name)
      hg19.knownToSuper.gene (via knownGene.name)
      hg19.knownToTag.name (via knownGene.name)
      hg19.knownToTreefam.name (via knownGene.name)
      hg19.knownToU133.name (via knownGene.name)
      hg19.knownToU133Plus2.name (via knownGene.name)
      hg19.knownToU95.name (via knownGene.name)
      hg19.knownToVisiGene.name (via knownGene.name)
      hg19.knownToWikipedia.name (via knownGene.name)
      hg19.mmBlastTab.query (via knownGene.name)
      hg19.rnBlastTab.query (via knownGene.name)
      hg19.scBlastTab.query (via knownGene.name)
      hg19.ucscScop.ucscId (via knownGene.name)
      hg38.bioCycPathway.kgID (via knownGene.name)
      hg38.ccdsKgMap.geneId (via knownGene.name)
      hg38.ceBlastTab.query (via knownGene.name)
      hg38.dmBlastTab.query (via knownGene.name)
      hg38.drBlastTab.query (via knownGene.name)
      hg38.foldUtr3.name (via knownGene.name)
      hg38.foldUtr5.name (via knownGene.name)
      hg38.gnfAtlas2Distance.query (via knownGene.name)
      hg38.gnfAtlas2Distance.target (via knownGene.name)
      hg38.gnfU95Distance.query (via knownGene.name)
      hg38.gnfU95Distance.target (via knownGene.name)
      hg38.humanHprdP2P.query (via knownGene.name)
      hg38.humanHprdP2P.target (via knownGene.name)
      hg38.humanVidalP2P.query (via knownGene.name)
      hg38.humanVidalP2P.target (via knownGene.name)
      hg38.humanWankerP2P.query (via knownGene.name)
      hg38.humanWankerP2P.target (via knownGene.name)
      hg38.keggPathway.kgID (via knownGene.name)
      hg38.kgAlias.kgID (via knownGene.name)
      hg38.kgColor.kgID (via knownGene.name)
      hg38.kgProtAlias.kgID (via knownGene.name)
      hg38.kgSpAlias.kgID (via knownGene.name)
      hg38.kgTargetAli.qName (via knownGene.name)
      hg38.kgXref.kgID (via knownGene.name)
      hg38.knownAttrs.kgID (via knownGene.name)
      hg38.knownBlastTab.query (via knownGene.name)
      hg38.knownBlastTab.target (via knownGene.name)
      hg38.knownCanonical.transcript (via knownGene.name)
      hg38.knownCds.name (via knownGene.name)
      hg38.knownGene.name (via knownGene.name)
      hg38.knownGeneMrna.name (via knownGene.name)
      hg38.knownGenePep.name (via knownGene.name)
      hg38.knownIsoforms.transcript (via knownGene.name)
      hg38.knownToEnsembl.name (via knownGene.name)
      hg38.knownToGnfAtlas2.name (via knownGene.name)
      hg38.knownToHprd.name (via knownGene.name)
      hg38.knownToKeggEntrez.name (via knownGene.name)
      hg38.knownToLocusLink.name (via knownGene.name)
      hg38.knownToLynx.name (via knownGene.name)
      hg38.knownToMrna.name (via knownGene.name)
      hg38.knownToMrnaSingle.name (via knownGene.name)
      hg38.knownToMupit.name (via knownGene.name)
      hg38.knownToNextProt.name (via knownGene.name)
      hg38.knownToPfam.name (via knownGene.name)
      hg38.knownToRefSeq.name (via knownGene.name)
      hg38.knownToSuper.gene (via knownGene.name)
      hg38.knownToTag.name (via knownGene.name)
      hg38.knownToU133.name (via knownGene.name)
      hg38.knownToU95.name (via knownGene.name)
      hg38.knownToVisiGene.name (via knownGene.name)
      hg38.knownToWikipedia.name (via knownGene.name)
      hg38.mmBlastTab.query (via knownGene.name)
      hg38.rnBlastTab.query (via knownGene.name)
      hg38.scBlastTab.query (via knownGene.name)
      hg38.ucscScop.ucscId (via knownGene.name)
      knownGeneV39.bioCycPathway.kgID (via knownGene.name)
      knownGeneV39.ceBlastTab.query (via knownGene.name)
      knownGeneV39.dmBlastTab.query (via knownGene.name)
      knownGeneV39.drBlastTab.query (via knownGene.name)
      knownGeneV39.foldUtr3.name (via knownGene.name)
      knownGeneV39.foldUtr5.name (via knownGene.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownGene.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownGene.name)
      knownGeneV39.kgAlias.kgID (via knownGene.name)
      knownGeneV39.kgColor.kgID (via knownGene.name)
      knownGeneV39.kgProtAlias.kgID (via knownGene.name)
      knownGeneV39.kgSpAlias.kgID (via knownGene.name)
      knownGeneV39.kgTargetAli.qName (via knownGene.name)
      knownGeneV39.kgXref.kgID (via knownGene.name)
      knownGeneV39.knownAttrs.kgID (via knownGene.name)
      knownGeneV39.knownBlastTab.query (via knownGene.name)
      knownGeneV39.knownBlastTab.target (via knownGene.name)
      knownGeneV39.knownCanonical.protein (via knownGene.name)
      knownGeneV39.knownCanonical.transcript (via knownGene.name)
      knownGeneV39.knownCds.name (via knownGene.name)
      knownGeneV39.knownGeneMrna.name (via knownGene.name)
      knownGeneV39.knownGenePep.name (via knownGene.name)
      knownGeneV39.knownIsoforms.transcript (via knownGene.name)
      knownGeneV39.knownToEnsembl.name (via knownGene.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownGene.name)
      knownGeneV39.knownToHprd.name (via knownGene.name)
      knownGeneV39.knownToLocusLink.name (via knownGene.name)
      knownGeneV39.knownToMrna.name (via knownGene.name)
      knownGeneV39.knownToMrnaSingle.name (via knownGene.name)
      knownGeneV39.knownToMupit.name (via knownGene.name)
      knownGeneV39.knownToPfam.name (via knownGene.name)
      knownGeneV39.knownToRefSeq.name (via knownGene.name)
      knownGeneV39.knownToSuper.gene (via knownGene.name)
      knownGeneV39.knownToTag.name (via knownGene.name)
      knownGeneV39.knownToU133.name (via knownGene.name)
      knownGeneV39.knownToU95.name (via knownGene.name)
      knownGeneV39.knownToVisiGene.name (via knownGene.name)
      knownGeneV39.knownToWikipedia.name (via knownGene.name)
      knownGeneV39.mmBlastTab.query (via knownGene.name)
      knownGeneV39.rnBlastTab.query (via knownGene.name)
      knownGeneV39.scBlastTab.query (via knownGene.name)
      knownGeneV39.ucscScop.ucscId (via knownGene.name)
      mm10.bioCycPathway.kgID (via knownGene.name)
      mm10.ccdsKgMap.geneId (via knownGene.name)
      mm10.ceBlastTab.query (via knownGene.name)
      mm10.dmBlastTab.query (via knownGene.name)
      mm10.drBlastTab.query (via knownGene.name)
      mm10.foldUtr3.name (via knownGene.name)
      mm10.foldUtr5.name (via knownGene.name)
      mm10.hgBlastTab.query (via knownGene.name)
      mm10.keggPathway.kgID (via knownGene.name)
      mm10.kgAlias.kgID (via knownGene.name)
      mm10.kgColor.kgID (via knownGene.name)
      mm10.kgProtAlias.kgID (via knownGene.name)
      mm10.kgProtMap2.qName (via knownGene.name)
      mm10.kgSpAlias.kgID (via knownGene.name)
      mm10.kgTargetAli.qName (via knownGene.name)
      mm10.kgTxInfo.name (via knownGene.name)
      mm10.kgXref.kgID (via knownGene.name)
      mm10.knownAttrs.kgID (via knownGene.name)
      mm10.knownBlastTab.query (via knownGene.name)
      mm10.knownBlastTab.target (via knownGene.name)
      mm10.knownCanonical.transcript (via knownGene.name)
      mm10.knownCds.name (via knownGene.name)
      mm10.knownGene.name (via knownGene.name)
      mm10.knownGeneMrna.name (via knownGene.name)
      mm10.knownGenePep.name (via knownGene.name)
      mm10.knownIsoforms.transcript (via knownGene.name)
      mm10.knownToEnsembl.name (via knownGene.name)
      mm10.knownToKeggEntrez.name (via knownGene.name)
      mm10.knownToLocusLink.name (via knownGene.name)
      mm10.knownToLynx.name (via knownGene.name)
      mm10.knownToMrna.name (via knownGene.name)
      mm10.knownToMrnaSingle.name (via knownGene.name)
      mm10.knownToPfam.name (via knownGene.name)
      mm10.knownToRefSeq.name (via knownGene.name)
      mm10.knownToSuper.gene (via knownGene.name)
      mm10.knownToTag.name (via knownGene.name)
      mm10.knownToVisiGene.name (via knownGene.name)
      mm10.knownToWikipedia.name (via knownGene.name)
      mm10.rnBlastTab.query (via knownGene.name)
      mm10.scBlastTab.query (via knownGene.name)
      mm10.ucscScop.ucscId (via knownGene.name)
      mm39.bioCycPathway.kgID (via knownGene.name)
      mm39.ceBlastTab.query (via knownGene.name)
      mm39.dmBlastTab.query (via knownGene.name)
      mm39.drBlastTab.query (via knownGene.name)
      mm39.foldUtr3.name (via knownGene.name)
      mm39.foldUtr5.name (via knownGene.name)
      mm39.hgBlastTab.query (via knownGene.name)
      mm39.kgAlias.kgID (via knownGene.name)
      mm39.kgColor.kgID (via knownGene.name)
      mm39.kgProtAlias.kgID (via knownGene.name)
      mm39.kgSpAlias.kgID (via knownGene.name)
      mm39.kgTargetAli.qName (via knownGene.name)
      mm39.kgXref.kgID (via knownGene.name)
      mm39.knownAttrs.kgID (via knownGene.name)
      mm39.knownBlastTab.query (via knownGene.name)
      mm39.knownBlastTab.target (via knownGene.name)
      mm39.knownCanonical.transcript (via knownGene.name)
      mm39.knownCds.name (via knownGene.name)
      mm39.knownGene.name (via knownGene.name)
      mm39.knownGeneMrna.name (via knownGene.name)
      mm39.knownIsoforms.transcript (via knownGene.name)
      mm39.knownToEnsembl.name (via knownGene.name)
      mm39.knownToLocusLink.name (via knownGene.name)
      mm39.knownToMrna.name (via knownGene.name)
      mm39.knownToMrnaSingle.name (via knownGene.name)
      mm39.knownToMupit.name (via knownGene.name)
      mm39.knownToNextProt.name (via knownGene.name)
      mm39.knownToPfam.name (via knownGene.name)
      mm39.knownToRefSeq.name (via knownGene.name)
      mm39.knownToSuper.gene (via knownGene.name)
      mm39.knownToTag.name (via knownGene.name)
      mm39.knownToVisiGene.name (via knownGene.name)
      mm39.knownToWikipedia.name (via knownGene.name)
      mm39.rnBlastTab.query (via knownGene.name)
      mm39.scBlastTab.query (via knownGene.name)
      mm39.ucscScop.ucscId (via knownGene.name)
      mm7.affyGnfU74ADistance.query (via knownGene.name)
      mm7.affyGnfU74ADistance.target (via knownGene.name)
      mm7.affyGnfU74BDistance.query (via knownGene.name)
      mm7.affyGnfU74BDistance.target (via knownGene.name)
      mm7.affyGnfU74CDistance.query (via knownGene.name)
      mm7.affyGnfU74CDistance.target (via knownGene.name)
      mm7.dmBlastTab.query (via knownGene.name)
      mm7.drBlastTab.query (via knownGene.name)
      mm7.dupSpMrna.mrnaID (via knownGene.name)
      mm7.foldUtr3.name (via knownGene.name)
      mm7.foldUtr5.name (via knownGene.name)
      mm7.gnfAtlas2Distance.query (via knownGene.name)
      mm7.gnfAtlas2Distance.target (via knownGene.name)
      mm7.hgBlastTab.query (via knownGene.name)
      mm7.keggPathway.kgID (via knownGene.name)
      mm7.kgAlias.kgID (via knownGene.name)
      mm7.kgProtAlias.kgID (via knownGene.name)
      mm7.kgSpAlias.kgID (via knownGene.name)
      mm7.kgXref.kgID (via knownGene.name)
      mm7.knownBlastTab.query (via knownGene.name)
      mm7.knownBlastTab.target (via knownGene.name)
      mm7.knownCanonical.transcript (via knownGene.name)
      mm7.knownGene.name (via knownGene.name)
      mm7.knownGeneLink.name (via knownGene.name)
      mm7.knownGeneMrna.name (via knownGene.name)
      mm7.knownGenePep.name (via knownGene.name)
      mm7.knownIsoforms.transcript (via knownGene.name)
      mm7.knownToAllenBrain.name (via knownGene.name)
      mm7.knownToEnsembl.name (via knownGene.name)
      mm7.knownToGnfAtlas2.name (via knownGene.name)
      mm7.knownToKeggEntrez.name (via knownGene.name)
      mm7.knownToLocusLink.name (via knownGene.name)
      mm7.knownToPfam.name (via knownGene.name)
      mm7.knownToRefSeq.name (via knownGene.name)
      mm7.knownToVisiGene.name (via knownGene.name)
      mm7.rnBlastTab.query (via knownGene.name)
      mm7.scBlastTab.query (via knownGene.name)
      mm8.affyGnfU74ADistance.query (via knownGene.name)
      mm8.affyGnfU74ADistance.target (via knownGene.name)
      mm8.affyGnfU74BDistance.query (via knownGene.name)
      mm8.affyGnfU74BDistance.target (via knownGene.name)
      mm8.affyGnfU74CDistance.query (via knownGene.name)
      mm8.affyGnfU74CDistance.target (via knownGene.name)
      mm8.ccdsKgMap.geneId (via knownGene.name)
      mm8.ceBlastTab.query (via knownGene.name)
      mm8.dmBlastTab.query (via knownGene.name)
      mm8.drBlastTab.query (via knownGene.name)
      mm8.dupSpMrna.mrnaID (via knownGene.name)
      mm8.foldUtr3.name (via knownGene.name)
      mm8.foldUtr5.name (via knownGene.name)
      mm8.gnfAtlas2Distance.query (via knownGene.name)
      mm8.gnfAtlas2Distance.target (via knownGene.name)
      mm8.hgBlastTab.query (via knownGene.name)
      mm8.keggPathway.kgID (via knownGene.name)
      mm8.kgAlias.kgID (via knownGene.name)
      mm8.kgProtAlias.kgID (via knownGene.name)
      mm8.kgSpAlias.kgID (via knownGene.name)
      mm8.kgTargetAli.qName (via knownGene.name)
      mm8.kgXref.kgID (via knownGene.name)
      mm8.knownBlastTab.query (via knownGene.name)
      mm8.knownBlastTab.target (via knownGene.name)
      mm8.knownCanonical.transcript (via knownGene.name)
      mm8.knownGene.name (via knownGene.name)
      mm8.knownGeneMrna.name (via knownGene.name)
      mm8.knownGenePep.name (via knownGene.name)
      mm8.knownIsoforms.transcript (via knownGene.name)
      mm8.knownToAllenBrain.name (via knownGene.name)
      mm8.knownToEnsembl.name (via knownGene.name)
      mm8.knownToGnfAtlas2.name (via knownGene.name)
      mm8.knownToKeggEntrez.name (via knownGene.name)
      mm8.knownToLocusLink.name (via knownGene.name)
      mm8.knownToPfam.name (via knownGene.name)
      mm8.knownToRefSeq.name (via knownGene.name)
      mm8.knownToSuper.gene (via knownGene.name)
      mm8.knownToVisiGene.name (via knownGene.name)
      mm8.rnBlastTab.query (via knownGene.name)
      mm8.scBlastTab.query (via knownGene.name)
      mm9.affyGnfU74ADistance.query (via knownGene.name)
      mm9.affyGnfU74ADistance.target (via knownGene.name)
      mm9.affyGnfU74BDistance.query (via knownGene.name)
      mm9.affyGnfU74BDistance.target (via knownGene.name)
      mm9.affyGnfU74CDistance.query (via knownGene.name)
      mm9.affyGnfU74CDistance.target (via knownGene.name)
      mm9.bioCycPathway.kgID (via knownGene.name)
      mm9.ccdsKgMap.geneId (via knownGene.name)
      mm9.ceBlastTab.query (via knownGene.name)
      mm9.dmBlastTab.query (via knownGene.name)
      mm9.drBlastTab.query (via knownGene.name)
      mm9.foldUtr3.name (via knownGene.name)
      mm9.foldUtr5.name (via knownGene.name)
      mm9.gnfAtlas2Distance.query (via knownGene.name)
      mm9.gnfAtlas2Distance.target (via knownGene.name)
      mm9.hgBlastTab.query (via knownGene.name)
      mm9.keggPathway.kgID (via knownGene.name)
      mm9.kgAlias.kgID (via knownGene.name)
      mm9.kgColor.kgID (via knownGene.name)
      mm9.kgProtAlias.kgID (via knownGene.name)
      mm9.kgProtMap2.qName (via knownGene.name)
      mm9.kgSpAlias.kgID (via knownGene.name)
      mm9.kgTargetAli.qName (via knownGene.name)
      mm9.kgTxInfo.name (via knownGene.name)
      mm9.kgXref.kgID (via knownGene.name)
      mm9.knownBlastTab.query (via knownGene.name)
      mm9.knownBlastTab.target (via knownGene.name)
      mm9.knownCanonical.protein (via knownGene.name)
      mm9.knownCanonical.transcript (via knownGene.name)
      mm9.knownGene.name (via knownGene.name)
      mm9.knownGeneMrna.name (via knownGene.name)
      mm9.knownGenePep.name (via knownGene.name)
      mm9.knownIsoforms.transcript (via knownGene.name)
      mm9.knownToAllenBrain.name (via knownGene.name)
      mm9.knownToEnsembl.name (via knownGene.name)
      mm9.knownToGnfAtlas2.name (via knownGene.name)
      mm9.knownToKeggEntrez.name (via knownGene.name)
      mm9.knownToLocusLink.name (via knownGene.name)
      mm9.knownToPfam.name (via knownGene.name)
      mm9.knownToRefSeq.name (via knownGene.name)
      mm9.knownToSuper.gene (via knownGene.name)
      mm9.knownToVisiGene.name (via knownGene.name)
      mm9.rnBlastTab.query (via knownGene.name)
      mm9.scBlastTab.query (via knownGene.name)
      mm9.ucscScop.ucscId (via knownGene.name)
      rn3.dmBlastTab.query (via knownGene.name)
      rn3.drBlastTab.query (via knownGene.name)
      rn3.dupSpMrna.mrnaID (via knownGene.name)
      rn3.gnfAtlas2Distance.query (via knownGene.name)
      rn3.gnfAtlas2Distance.target (via knownGene.name)
      rn3.hgBlastTab.query (via knownGene.name)
      rn3.keggPathway.kgID (via knownGene.name)
      rn3.kgAlias.kgID (via knownGene.name)
      rn3.kgProtAlias.kgID (via knownGene.name)
      rn3.kgSpAlias.kgID (via knownGene.name)
      rn3.kgXref.kgID (via knownGene.name)
      rn3.knownBlastTab.query (via knownGene.name)
      rn3.knownBlastTab.target (via knownGene.name)
      rn3.knownCanonical.transcript (via knownGene.name)
      rn3.knownGene.name (via knownGene.name)
      rn3.knownGeneLink.name (via knownGene.name)
      rn3.knownGeneMrna.name (via knownGene.name)
      rn3.knownGenePep.name (via knownGene.name)
      rn3.knownIsoforms.transcript (via knownGene.name)
      rn3.knownToEnsembl.name (via knownGene.name)
      rn3.knownToGnfAtlas2.name (via knownGene.name)
      rn3.knownToLocusLink.name (via knownGene.name)
      rn3.knownToPfam.name (via knownGene.name)
      rn3.knownToRefSeq.name (via knownGene.name)
      rn3.knownToSuper.gene (via knownGene.name)
      rn3.scBlastTab.query (via knownGene.name)

Sample Rows
 
namechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsproteinIDalignID
ENST00000619216.1chr1-17368174361736817368117368,17436,uc031tla.1
ENST00000473358.1chr1+29553310972955329553329553,30563,30975,30039,30667,31097,uc057aty.1
ENST00000469289.1chr1+30266311093026630266230266,30975,30667,31109,uc057atz.1
ENST00000607096.1chr1+30365305033036530365130365,30503,uc031tlb.1
ENST00000417324.1chr1-34553360813455334553334553,35276,35720,35174,35481,36081,uc001aak.4
ENST00000461467.1chr1-35244360733524435244235244,35720,35481,36073,uc057aua.1
ENST00000641515.2chr1+65418715856556470008365418,65519,69036,65433,65573,71585,A0A2U3U0J3uc001aal.2
ENST00000466430.5chr1-892941209328929489294489294,92090,112699,120774,91629,92240,112804,120932,uc057aub.1
ENST00000495576.1chr1-89550911058955089550289550,90286,90050,91105,uc057auc.1
ENST00000477740.5chr1-922291292179222992229492229,112699,120720,129054,92240,112804,120932,129217,uc057aud.1

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