Schema for ggGeneName
  Database: hgFixed    Primary Table: ggGeneName    Row Count: 37,946   Data last updated: 2017-04-26
Format description: Human readable gene names for the gene interactions track
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene A1BGvarchar(255) values gene symbol
text alpha-1-B glycoproteinvarchar(30000) values short description of the gene
prevSyms  varchar(1000) values previous/alternative symbols (synonyms) according to HGNC

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

Sample Rows
 
genetextprevSyms
A1BGalpha-1-B glycoprotein
A1BG-AS1A1BG antisense RNA 1NCRNA00181,A1BGAS,A1BG-AS
A1CFAPOBEC1 complementation factor
A2Malpha-2-macroglobulin
A2M-AS1A2M antisense RNA 1
A2ML1alpha-2-macroglobulin-like 1CPAMD9
A2ML1-AS1A2ML1 antisense RNA 1
A2ML1-AS2A2ML1 antisense RNA 2
A2MP1alpha-2-macroglobulin pseudogene 1A2MP
A3GALT2alpha 1,3-galactosyltransferase 2A3GALT2P

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