Schema for scopDes
  Database: hgFixed    Primary Table: scopDes    Row Count: 67,166   Data last updated: 2003-11-08
Format description: Structural Classification of Proteins Description. See Lo Conte, Brenner et al. NAR 2002
On download server: MariaDB table dump directory
fieldexampleSQL type info description
sunid 46456int(11) range Unique integer
type clchar(2) values Type. sf=superfamily, fa = family, etc.
sccs avarchar(255) values Dense hierarchy info.
sid -varchar(255) values Older ID.
description All alpha proteinslongblob   Descriptive text.

Connected Tables and Joining Fields
        hg16.sfAssign.sfID (via scopDes.sunid)
      hg16.sfDes.id (via scopDes.sunid)
      hg17.sfAssign.sfID (via scopDes.sunid)
      hg17.sfDes.id (via scopDes.sunid)
      hg18.sfAssign.sfID (via scopDes.sunid)
      hg18.sfDes.id (via scopDes.sunid)
      mm8.sfAssign.sfID (via scopDes.sunid)
      mm8.sfDes.id (via scopDes.sunid)
      rn3.sfAssign.sfID (via scopDes.sunid)
      rn3.sfDes.id (via scopDes.sunid)
      rn4.sfAssign.sfID (via scopDes.sunid)
      rn4.sfDes.id (via scopDes.sunid)

Sample Rows
 
sunidtypesccssiddescription
46456cla-All alpha proteins
46457cfa.1-Globin-like
46458sfa.1.1-Globin-like
46459faa.1.1.1-Truncated hemoglobin
46460dma.1.1.1-Truncated hemoglobin
46461spa.1.1.1-Ciliate (Paramecium caudatum)
14982pxa.1.1.1d1dlwa_1dlw A:
46462spa.1.1.1-Green alga (Chlamydomonas eugametos)
14983pxa.1.1.1d1dlya_1dly A:
81667spa.1.1.1-Cyanobacteria (Synechocystis sp.), pcc 6803

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