Schema for cgapAlias

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for cgapAlias

Database: hg17 Primary Table: cgapAlias Row Count: 124,040 Data last updated: 2005-10-06
Format description: CGAP alias
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`cgapID`	2	`varchar(40)`	values	CGAP pathway ID
`alias`	AAC2	`varchar(80)`	values	Gene symbol or mRNA

Connected Tables and Joining Fields


	hg17.knownGene.name (via cgapAlias.alias) hg17.cgapBiocPathway.cgapID (via cgapAlias.cgapID)

Sample Rows

cgapID	alias
2	AAC2
2	NAT2
2	NM_000015
4	ADH1B
4	ADH2
4	NM_000668
11	CD66D
11	CEA
11	CEACAM3
11	CGM1

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