Schema for ucscScop
  Database: knownGeneV39    Primary Table: ucscScop    Row Count: 337,111   Data last updated: 2022-01-17
On download server: MariaDB table dump directory
fieldexampleSQL type info
ucscId ENST00000000233.10varchar(255) values
start 5int(11) range
end 178int(11) range
domainName c.37.1varchar(255) values

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

Sample Rows
 
ucscIdstartenddomainName
ENST00000000233.105178c.37.1
ENST00000000412.829182b.64.1
ENST00000000442.11125422a.123.1
ENST00000000442.1175162g.39.1
ENST00000001008.6248390a.118.18
ENST00000001008.6274415a.118.6
ENST00000001008.6233416a.118.8
ENST00000001008.622268d.26.1
ENST00000001146.744490a.104.1
ENST00000002125.941410c.66.1

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