Schema for sfDes
  Database: hg18    Primary Table: sfDes    Row Count: 94,441   Data last updated: 2006-06-20
Format description: Superfamily Description table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 87870int(12) range ID
level pxchar(2) values level
classification i.1.1.1text values classification
name d1p85a_text values name
description 1p85 A:text values description

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

Sample Rows
 
idlevelclassificationnamedescription
87870pxi.1.1.1d1p85a_1p85 A:
87866pxi.1.1.1d1p850_1p85 0:
87869pxi.1.1.1d1p859_1p85 9:
79279pxi.1.1.1d1ml5x_1ml5 X:
79278pxi.1.1.1d1ml5w_1ml5 W:
79277pxi.1.1.1d1ml5v_1ml5 V:
79276pxi.1.1.1d1ml5u_1ml5 U:
79275pxi.1.1.1d1ml5t_1ml5 T:
79274pxi.1.1.1d1ml5s_1ml5 S:
79273pxi.1.1.1d1ml5r_1ml5 R:

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