Schema for ucscScop
  Database: mm10    Primary Table: ucscScop    Row Count: 212,704   Data last updated: 2019-09-20
Format description: SCOP domain
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ucscId ENSMUST00000000001.4varchar(255) values UCSC gene id
start 60int(11) range start offset of domain in sequence
end 181int(11) range end offset of domain in sequence
domainName a.66.1varchar(255) values domain name

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

Sample Rows
 
ucscIdstartenddomainName
ENSMUST00000000001.460181a.66.1
ENSMUST00000000001.414352c.37.1
ENSMUST00000000003.136171b.60.1
ENSMUST00000000010.8171247a.4.1
ENSMUST00000000010.8200247a.4.13
ENSMUST00000000028.1314104c.107.1
ENSMUST00000000028.13189226c.107.1
ENSMUST00000000033.111691g.1.1
ENSMUST00000000049.5274308b.76.2
ENSMUST00000000049.520345g.18.1

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