Schema for ucscScop
  Database: hg38    Primary Table: ucscScop    Row Count: 346,150   Data last updated: 2022-05-15
Format description: SCOP domain
fieldexampleSQL type info description
ucscId ENST00000000233.10varchar(255) values UCSC gene id
start 5int(11) range start offset of domain in sequence
end 178int(11) range end offset of domain in sequence
domainName c.37.1varchar(255) values domain name

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

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.