Schema for Pfam in UCSC Gene - Pfam Domains in UCSC Genes
  Database: hg19    Primary Table: ucscGenePfam    Row Count: 64,111   Data last updated: 2017-04-08
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 69168int(10) unsigned range Start position in chromosome
chromEnd 69972int(10) unsigned range End position in chromosome
name 7tm_4varchar(255) values Name of item
score 0int(10) unsigned range Optional score, nominal range 0-1000
strand +char(1) values + or -
thickStart 0int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 0int(10) unsigned range End of where display should be thick (stop codon)
reserved 0int(10) unsigned range Used as itemRgb as of 2004-11-22
blockCount 1int(10) unsigned range Number of blocks
blockSizes 804,longblob   Comma separated list of block sizes
chromStarts 0,longblob   Start positions relative to chromStart

Sample Rows

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

Pfam in UCSC Gene (ucscGenePfam) Track Description


Most proteins are composed of one or more conserved functional regions called domains. This track shows the high-quality, manually-curated Pfam-A domains found in transcripts located in the UCSC Genes track by the software HMMER3.

Display Conventions and Configuration

This track follows the display conventions for gene tracks.


The sequences from the knownGenePep table (see UCSC Genes description page) are submitted to the set of Pfam-A HMMs which annotate regions within the predicted peptide that are recognizable as Pfam protein domains. These regions are then mapped to the transcripts themselves using the pslMap utility. A complete shell script log for every version of UCSC genes can be found in our GitHub repository under hg/makeDb/doc/ucscGenes, e.g. mm10.knownGenes17.csh is for the database mm10 and version 17 of UCSC known genes.

Of the several options for filtering out false positives, the "Trusted cutoff (TC)" threshold method is used in this track to determine significance. For more information regarding thresholds and scores, see the HMMER documentation and results interpretation pages.

Note: There is currently an undocumented but known HMMER problem which results in lessened sensitivity and possible missed searches for some zinc finger domains. Until a fix is released for HMMER /PFAM thresholds, please also consult the "UniProt Domains" subtrack of the UniProt track for more comprehensive zinc finger annotations.


pslMap was written by Mark Diekhans at UCSC.


Finn RD, Mistry J, Tate J, Coggill P, Heger A, Pollington JE, Gavin OL, Gunasekaran P, Ceric G, Forslund K et al. The Pfam protein families database. Nucleic Acids Res. 2010 Jan;38(Database issue):D211-22. PMID: 19920124; PMC: PMC2808889