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) Note: genome-wide queries are not available for this table.
      hg18.omimGeneMap2.geneSymbol (via ggGeneName.gene) Note: genome-wide queries are not available for this table.
      hg19.kgXref.geneSymbol (via ggGeneName.gene)
      hg19.omimGeneMap.geneSymbol (via ggGeneName.gene) Note: genome-wide queries are not available for this table.
      hg19.omimGeneMap2.geneSymbol (via ggGeneName.gene) Note: genome-wide queries are not available for this table.
      hg38.kgXref.geneSymbol (via ggGeneName.gene)
      hg38.omimGeneMap.geneSymbol (via ggGeneName.gene) Note: genome-wide queries are not available for this table.
      hg38.omimGeneMap2.geneSymbol (via ggGeneName.gene) Note: genome-wide queries are not available for this table.
      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.