Schema for gwasCatalog
  Database: hg18    Primary Table: gwasCatalog    Row Count: 588,585   Data last updated: 2025-04-30
Format description: NHGRI's collection of Genome-Wide Association Studies SNPs
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 587smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 318130int(10) unsigned Start position in chromosome
chromEnd 318131int(10) unsigned End position in chromosome
name rs9662999varchar(255) ID of SNP associated with trait
pubMedID 34594039int(10) unsigned PubMed ID of publication of the study
author Sakaue Svarchar(255) First author of publication
pubDate 2021-09-30varchar(255) Date of publication
journal Nat Genetvarchar(255) Journal of publication
title A cross-population atlas of...varchar(1024) Title of publication
trait Weightvarchar(255) Disease or trait assessed in study
initSample 360,116 European ancestry i...longblob Initial sample size
replSample NAlongblob Replication sample size
region 1q42.13varchar(255) Chromosome band / region of SNP
genes  longblob Reported Gene(s)
riskAllele rs9662999-Glongblob Strongest SNP-Risk Allele
riskAlFreq NRvarchar(255) Risk Allele Frequency
pValue 4E-8varchar(255) p-Value
pValueDesc  varchar(255) p-Value Description
orOrBeta 0.012varchar(255) Odds ratio or beta
ci95 [0.0077-0.0163] unit decreasevarchar(255) 95 Confidence Interval
platform Affymetrix, Illumina [20539...varchar(255) Platform and [SNPs passing QC]
cnv Nenum('Y', 'N') Y if Copy Number Variant

Connected Tables and Joining Fields
        hg18.snp130.name (via gwasCatalog.name)
      hg18.snp130CodingDbSnp.name (via gwasCatalog.name)
      hg18.snp130Exceptions.name (via gwasCatalog.name)
      hg18.snp130OrthoPt2Pa2Rm2.name (via gwasCatalog.name)
      hg18.snp130Seq.acc (via gwasCatalog.name)
      hg18.snpArrayIlluminaHuman660W_Quad.name (via gwasCatalog.name)
      hg18.snpArrayIlluminaHumanCytoSNP_12.name (via gwasCatalog.name)
      hg18.snpArrayIlluminaHumanOmni1_Quad.name (via gwasCatalog.name)

Sample Rows
 
binchromchromStartchromEndnamepubMedIDauthorpubDatejournaltitletraitinitSamplereplSampleregiongenesriskAlleleriskAlFreqpValuepValueDescorOrBetaci95platformcnv
587chr1318130318131rs966299934594039Sakaue S2021-09-30Nat GenetA cross-population atlas of genetic associations for 220 human phenotypes.Weight360,116 European ancestry individuals, 165,419 East Asian ancestry individualsNA1q42.13rs9662999-GNR4E-80.012[0.0077-0.0163] unit decreaseAffymetrix, Illumina [20539548] (imputed)N
587chr1345767345768rs280834435228297Joseph CB2022-03-01J Am Soc NephrolMeta-GWAS Reveals Novel Genetic Variants Associated with Urinary Excretion of Uromodulin.Urinary uromodulin levels (raw)29,315 European ancestry individualsNA6q27rs2808344-A0.0159E-70.7581[0.46-1.06] increaseAffymetrix, Illumina [NR] (imputed)N
588chr1430023430024rs1295229739528825Western D2024-11-11Nat GenetProteogenomic analysis of human cerebrospinal fluid identifies neurologically relevant regulation and implicates causal proteins ...Meteorin-like protein levels2,549 European ancestry individualsNA17q25.3rs12952297-T0.3537851E-110.1846[0.13-0.24] unit increaseAffymetrix, Illumina [7327959] (imputed)N
589chr1623650623651rs280834435228297Joseph CB2022-03-01J Am Soc NephrolMeta-GWAS Reveals Novel Genetic Variants Associated with Urinary Excretion of Uromodulin.Urinary uromodulin levels (raw)29,315 European ancestry individualsNA6q27rs2808344-A0.0159E-70.7581[0.46-1.06] increaseAffymetrix, Illumina [NR] (imputed)N
589chr1651314651315rs966299934594039Sakaue S2021-09-30Nat GenetA cross-population atlas of genetic associations for 220 human phenotypes.Weight360,116 European ancestry individuals, 165,419 East Asian ancestry individualsNA1q42.13rs9662999-GNR4E-80.012[0.0077-0.0163] unit decreaseAffymetrix, Illumina [20539548] (imputed)N
590chr1758115758116rs297760839192095Burren OS2024-08-27Nat GenetGenetic architecture of telomere length in 462,666 UK Biobank whole-genome sequences.Telomere length (principal component 1)438,351 Non-Finnish European ancestry individualsNA1p36.33rs2977608-A0.2374537E-90.0135857[0.009-0.0182] unit decreaseAffymetrix [15022702] (imputed)N
590chr1758115758116rs297760835023831Chong M2022-01-13ElifeGWAS and ExWAS of blood Mitochondrial DNA copy number identifies 71 loci and highlights a potential causal role in dementia.Mitochondrial DNA copy number395,718 British, Irish, Other White, South Asian, African ancestry individualsNA1p36.33NRrs2977608-C0.4894173E-210.0236[0.019-0.029] unit increaseAffymetrix [23037915] (imputed)N
590chr1758115758116rs297760831969693Coleman JRI2020-01-23Mol PsychiatryGenome-wide gene-environment analyses of major depressive disorder and reported lifetime traumatic experiences in UK Biobank.Major depressive disorder29,475 European ancestry cases, 63,482 European ancestry controlsNA1p36.33NRrs2977608-A0.2590298E-61.0729614[1.04-1.1]Affymetrix [7791636] (imputed)N
591chr1871895871896rs227275630895295Jonnalagadda M2019-03-21Genome Biol EvolA genome-wide association study of skin and iris pigmentation among individuals of South Asian ancestry.Skin reflectance (Melanin index)720 South Asian ancestry individuals1p36.33NRrs2272756-ANR3E-60.324533[0.19-0.46] unit increaseAffymetrix, Illumina [at least 398118] (imputed)N
591chr1880921880922rs1330306533462484Sinnott-Armstrong N2021-01-18Nat GenetGenetics of 35 blood and urine biomarkers in the UK Biobank.Serum alkaline phosphatase levels342,535 European ancestry individuals, 6,019 African ancestry individuals, 7,337 South Asian ancestry individualsNA1p36.33NRrs13303065-TNR9E-100.0154[0.011-0.02] unit increaseAffymetrix [9000000] (imputed)N

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