Schema for pfamDesc
  Database: knownGeneV39    Primary Table: pfamDesc    Row Count: 19,179   Data last updated: 2022-01-17
On download server: MariaDB table dump directory
fieldexampleSQL type info
pfamAC PF00001varchar(40) values
pfamID 7tm_1varchar(40) values
description 7 transmembrane receptor (r...varchar(255) values

Connected Tables and Joining Fields
        hg16.knownToPfam.value (via pfamDesc.pfamAC)
      hg17.knownToPfam.value (via pfamDesc.pfamAC)
      hg18.knownToPfam.value (via pfamDesc.pfamAC)
      hg18.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      hg19.knownToPfam.value (via pfamDesc.pfamAC)
      hg19.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      hg38.knownToPfam.value (via pfamDesc.pfamAC)
      hg38.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      knownGeneV39.knownToPfam.value (via pfamDesc.pfamAC)
      mm10.knownToPfam.value (via pfamDesc.pfamAC)
      mm10.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      mm39.knownToPfam.value (via pfamDesc.pfamAC)
      mm39.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      mm7.knownToPfam.value (via pfamDesc.pfamAC)
      mm8.knownToPfam.value (via pfamDesc.pfamAC)
      mm9.knownToPfam.value (via pfamDesc.pfamAC)
      mm9.pfamDesc.pfamAC (via pfamDesc.pfamAC)
      rn3.knownToPfam.value (via pfamDesc.pfamAC)

Sample Rows
 
pfamACpfamIDdescription
PF000017tm_17 transmembrane receptor (rhodopsin family)
PF000027tm_27 transmembrane receptor (Secretin family)
PF000037tm_37 transmembrane sweet-taste receptor of 3 GCPR
PF00004AAAATPase family associated with various cellular activities (AAA)
PF00005ABC_tranABC transporter
PF00006ATP-synt_abATP synthase alpha/beta family, nucleotide-binding domain
PF00007Cys_knotCystine-knot domain
PF00008EGFEGF-like domain
PF00009GTP_EFTUElongation factor Tu GTP binding domain
PF00010HLHHelix-loop-helix DNA-binding domain

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