Schema for cgapAlias
  Database: hg18    Primary Table: cgapAlias    Row Count: 223,344   Data last updated: 2009-03-06
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
        hg18.kgXref.geneSymbol (via cgapAlias.alias)
      hg18.cgapBiocPathway.cgapID (via cgapAlias.cgapID)

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

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