Schema for sfDes
  Database: hg17    Primary Table: sfDes    Row Count: 86,765   Data last updated: 2005-05-25
Format description: Superfamily Description table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 53847int(12) range ID
level dmchar(2) values level
classification c.93.1.1text values classification
name -text values name
description Metabotropic glutamate rece...text values description

Connected Tables and Joining Fields
        hg17.sfAssign.sfID (via sfDes.id)
      hgFixed.scopDes.sunid (via sfDes.id)

Sample Rows
 
idlevelclassificationnamedescription
53847dmc.93.1.1-Metabotropic glutamate receptor subtype 1
62905pxc.93.1.1d1jdna_1jdn A:
62907pxc.93.1.1d1jdpb_1jdp B:
62906pxc.93.1.1d1jdpa_1jdp A:
64190spc.93.1.1-Human (Homo sapiens)
35711pxc.93.1.1d1dp4c_1dp4 C:
35710pxc.93.1.1d1dp4a_1dp4 A:
53846spc.93.1.1-Rat (Rattus norvegicus)
53845dmc.93.1.1-Hormone binding domain of the atrial natriuretic peptide receptor
99870pxc.93.1.1d1uskd_1usk D:

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