Schema for ucscScop
  Database: hg19    Primary Table: ucscScop    Row Count: 92,052   Data last updated: 2013-06-16
Format description: SCOP domain
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ucscId uc001aal.1varchar(255) values UCSC gene id
start 0int(11) range start offset of domain in sequence
end 297int(11) range end offset of domain in sequence
domainName f.13.1varchar(255) values domain name

Connected Tables and Joining Fields
        hg19.scopDesc.name (via ucscScop.domainName)
      knownGeneV39.scopDesc.name (via ucscScop.domainName)
      knownGeneV39.ucscScop.domainName (via ucscScop.domainName)
      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)
      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
uc001aal.10297f.13.1
uc010nxu.20304f.13.1
uc010nxv.20304f.13.1
uc001abw.1513619a.60.1
uc031pjl.1498604a.60.1
uc031pjm.1514614a.60.1
uc031pjp.1404510a.60.1
uc031pjq.1312418a.60.1
uc031pjr.1174280a.60.1
uc031pjt.1451557a.60.1

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