Schema for cgapAlias
  Database: hg16    Primary Table: cgapAlias    Row Count: 161,431   Data last updated: 2005-10-06
Format description: CGAP alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
cgapID 2varchar(40) values CGAP pathway ID
alias AAC2varchar(80) values Gene symbol or mRNA

Connected Tables and Joining Fields
        hg16.knownGene.name (via cgapAlias.alias)
      hg16.cgapBiocPathway.cgapID (via cgapAlias.cgapID)

Sample Rows
 
cgapIDalias
2AAC2
2NAT2
2NM_000015
4ADH1B
4ADH2
4NM_000668
11CD66D
11CEACAM3
11CGM1
11NM_001815

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