Skip to main content
Schema for ucscScop
  Database: hg38    Primary Table: ucscScop    Row Count: 815,853   Data last updated: 2025-09-26
Format description: SCOP domain
On download server: MariaDB table dump directory
fieldexampleSQL type description
ucscId ENST00000000233.10varchar(255) UCSC gene id
start 5int(11) start offset of domain in sequence
end 178int(11) end offset of domain in sequence
domainName c.37.1varchar(255) domain name

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

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.