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) +);