Skip to main content
Schema for ucscScop
  Database: mm39    Primary Table: ucscScop    Row Count: 705,961   Data last updated: 2026-07-12
Format description: SCOP domain
On download server: MariaDB table dump directory
fieldexampleSQL type description
ucscId ENSMUST00000000001.6varchar(255) UCSC gene id
start 60int(11) start offset of domain in sequence
end 181int(11) end offset of domain in sequence
domainName a.66.1varchar(255) domain name

Connected Tables and Joining Fields
        knownGeneV39.scopDesc.name (via ucscScop.domainName)
      knownGeneV39.ucscScop.domainName (via ucscScop.domainName)
      mm39.scopDesc.name (via ucscScop.domainName)
      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)
      knownGeneV39.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)

Sample Rows
 
ucscIdstartenddomainName
ENSMUST00000000001.660181a.66.1
ENSMUST00000000001.614352c.37.1
ENSMUST00000000003.146171b.60.1
ENSMUST00000000010.10171247a.4.1
ENSMUST00000000028.1514104c.107.1
ENSMUST00000000028.15189226c.107.1
ENSMUST00000000033.121691g.1.1
ENSMUST00000000049.720345g.18.1
ENSMUST00000000080.88198g.37.1
ENSMUST00000000080.8231317g.37.1

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