Schema for pfamDesc
  Database: hg18    Primary Table: pfamDesc    Row Count: 8,957   Data last updated: 2008-08-06
Format description: Pfam description table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
pfamAC PF00244varchar(40) values Pfam accession number
pfamID 14-3-3varchar(40) values Pfam ID
description 14-3-3 proteinvarchar(255) values description

Connected Tables and Joining Fields
        hg18.knownToPfam.value (via pfamDesc.pfamAC)
      knownGeneV39.knownToPfam.value (via pfamDesc.pfamAC)
      knownGeneV39.pfamDesc.pfamAC (via pfamDesc.pfamAC)

Sample Rows
 
pfamACpfamIDdescription
PF0024414-3-314-3-3 protein
PF003892-Hacid_dhD-isomer specific 2-hydroxyacid dehydrogenase, catalytic domain
PF028262-Hacid_dh_CD-isomer specific 2-hydroxyacid dehydrogenase, NAD binding domain
PF001982-oxoacid_dh2-oxoacid dehydrogenases acyltransferase (catalytic domain)
PF040292-ph_phosp2-phosphosulpholactate phosphatase
PF028342_5_RNA_ligase2',5' RNA ligase family
PF087932C_adapt2-cysteine adaptor domain
PF085212CSK_NTwo-component sensor kinase N-terminal
PF031712OG-FeII_Oxy2OG-Fe(II) oxygenase superfamily
PF034753-alpha3-alpha domain

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