Schema for cgapAlias
  Database: mm9    Primary Table: cgapAlias    Row Count: 208,793   Data last updated: 2011-05-03
Format description: CGAP alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
cgapID 1varchar(40) values CGAP pathway ID
alias 42Cvarchar(80) values Gene symbol or mRNA

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

Sample Rows
 
cgapIDalias
142C
1AA409961
1AL024248
1CAL12
1CAL1L
1CLP11
1NM_009112
1P10
1P11
1S100A10

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