Schema for cgapAlias
  Database: hg19    Primary Table: cgapAlias    Row Count: 229,305   Data last updated: 2013-06-15
Format description: CGAP alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
cgapID 100043varchar(40) values CGAP pathway ID
alias CCDC124varchar(80) values Gene symbol or mRNA

Connected Tables and Joining Fields
        hg19.kgXref.geneSymbol (via cgapAlias.alias)
      hg19.cgapBiocPathway.cgapID (via cgapAlias.cgapID)

Sample Rows
 
cgapIDalias
100043CCDC124
100043NM_001136203
100043NM_138442
100057CLIK1
100057NM_080836
100057STK35
100057STK35L1
100058CRMP3
100058DPYSL4
100058DRP-4

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