ee413d5fbaa279f619706ccc75c0a82770a2be8d
braney
  Fri Mar 8 10:32:18 2024 -0800
fix the gwasCatalog otto build.

diff --git src/hg/lib/gwasCatalog.sql src/hg/lib/gwasCatalog.sql
index f3a6005..16a742d 100644
--- src/hg/lib/gwasCatalog.sql
+++ src/hg/lib/gwasCatalog.sql
@@ -1,34 +1,28 @@
-# gwasCatalog.sql was originally generated by the autoSql program, which also 
-# generated gwasCatalog.c and gwasCatalog.h.  This creates the database representation of
-# an object which can be loaded and saved from RAM in a fairly 
-# automatic way.
-
-#NHGRI's collection of Genome-Wide Association Studies SNPs
 CREATE TABLE gwasCatalog (
     bin           smallint(5) unsigned not null,
     chrom varchar(255) not null,	# Reference sequence chromosome or scaffold
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# ID of SNP associated with trait
     pubMedID int unsigned not null,	# PubMed ID of publication of the study
     author varchar(255) not null,	# First author of publication
     pubDate varchar(255) not null,	# Date of publication
     journal varchar(255) not null,	# Journal of publication
     title varchar(1024) not null,	# Title of publication
     trait varchar(255) not null,	# Disease or trait assessed in study
     initSample longblob not null,	# Initial sample size
     replSample longblob not null,	# Replication sample size
     region varchar(255) not null,	# Chromosome band / region of SNP
     genes longblob not null,	        # Reported Gene(s)
     riskAllele longblob not null,	# Strongest SNP-Risk Allele
     riskAlFreq varchar(255) not null,	# Risk Allele Frequency
     pValue varchar(255) not null,	# p-Value
     pValueDesc varchar(255) not null,	# p-Value Description
     orOrBeta varchar(255) not null,	# Odds ratio or beta
-    ci95 varchar(255) not null,	# 95% Confidence Interval
+    ci95 varchar(255) not null,	# 95 Confidence Interval
     platform varchar(255) not null,	# Platform and [SNPs passing QC]
     cnv enum("Y", "N")  not null,	# Y if Copy Number Variant
               #Indices
     INDEX(chrom,bin),
     INDEX(name)
 );