d2da1341d245cf5a5d574e2f75375ef49091ad30
chmalee
  Tue Jul 16 13:18:35 2019 -0700
Rework of omim otto pipeline to accomadate new genemap schema, no refs

diff --git src/hg/lib/omimGeneMap2.sql src/hg/lib/omimGeneMap2.sql
new file mode 100644
index 0000000..f29a64e
--- /dev/null
+++ src/hg/lib/omimGeneMap2.sql
@@ -0,0 +1,16 @@
+#This table contains the same data as the genemap2.txt file downloaded from OMIM
+CREATE TABLE omimGeneMap2 (
+    location varchar(255),	# Cyto Location
+    compCtyoLoc varchar(255),	# Computed Cyto Location
+    omimId int not null,	# Mim Number
+    geneSymbol varchar(255),	# Gene Symbol(s)
+    geneName longblob,	# Gene Name
+    approvedSymbol varchar(255),	# Approved Symbol
+    entrez varchar(255),	# Entrez Gene ID
+    ensGeneId varchar(255),	# Ensembl Gene ID
+    comments longblob,	# Comments
+    phenotypes longblob,	# Phenotypes
+    mmGeneId longblob,	# Mouse Gene Symbol/ID
+              #Indices
+    KEY(omimId)
+);