4a9a9e093641bb5a2ebcaf3211f0434aaf1c1a96 fanhsu Thu Jan 27 13:57:00 2011 -0800 Added omimAvRepl.sql table for OMIM tracks. diff --git src/hg/lib/omimAvRepl.sql src/hg/lib/omimAvRepl.sql new file mode 100644 index 0000000..d3f41ad --- /dev/null +++ src/hg/lib/omimAvRepl.sql @@ -0,0 +1,13 @@ +CREATE TABLE omimAvRepl ( + avId varchar(40) not null, # MIM AV Number + omimId int not null, # MIM ID + + firstAa char(1), # first AA + position int, # position in the protein sequence + secondAa char(1), # 2nd AA + dbSnpId varchar(255), # dbSNP ID if available + #Indices + replStr varchar(255), # AA replacement string + KEY(avId), + KEY(omimId) +);