Schema for ggGeneClass
  Database: hgFixed    Primary Table: ggGeneClass    Row Count: 15,605   Data last updated: 2017-04-26
Format description: Assignment of gene symbols to HPRD/Panther protein classes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene UBE2Q1varchar(255) values Gene symbol
text Ubiquitin proteasome system...varchar(30000) values Protein class

Connected Tables and Joining Fields
        hg16.kgXref.geneSymbol (via ggGeneClass.gene)
      hg17.kgXref.geneSymbol (via ggGeneClass.gene)
      hg18.kgXref.geneSymbol (via ggGeneClass.gene)
      hg18.omimGeneMap.geneSymbol (via ggGeneClass.gene)
      hg18.omimGeneMap2.geneSymbol (via ggGeneClass.gene)
      hg19.kgXref.geneSymbol (via ggGeneClass.gene)
      hg19.omimGeneMap.geneSymbol (via ggGeneClass.gene)
      hg19.omimGeneMap2.geneSymbol (via ggGeneClass.gene)
      hg38.kgXref.geneSymbol (via ggGeneClass.gene)
      hg38.omimGeneMap.geneSymbol (via ggGeneClass.gene)
      hg38.omimGeneMap2.geneSymbol (via ggGeneClass.gene)
      hgFixed.ggGeneName.gene (via ggGeneClass.gene)
      hgFixed.ggLink.gene1 (via ggGeneClass.gene)
      hgFixed.ggLink.gene2 (via ggGeneClass.gene)

Sample Rows
 
genetext
UBE2Q1Ubiquitin proteasome system protein, ligase
UBE2Q2Cytoskeletal associated protein, ligase
REM1Small GTPase
REM2Small GTPase
UCHL5Ubiquitin proteasome system protein, cysteine protease
ATRXTranscription regulatory protein, DNA helicase
ASS1Enzyme: Ligase
ZNF878KRAB box transcription factor
SPREnzyme: Reductase
SPNIntegral membrane protein

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