I am researcher with this file
Want to know function …
"GO"
1. Upload to SQLShare
not perfect but will do …
actually failed so removed " and titles
SELECT * FROM [sr320@washington.edu].[DMR2] dmr2
left join [sr320@washington.edu].[SPID and GO Numbers] ass
on dmr2.Column4 = ass.SPID
left join [sr320@washington.edu].[GO_to_GOslim] slim
on ass."GOID" = slim.GO_id
NEW DATAset
summarize
SELECT GOslim_bin,count(GOslim_bin) FROM [sr320@washington.edu].[dmr with GO slim]
Where aspect ='P'
GROUP BY GOslim_bin
Next step would be to compare to distribution of GOslim across genome….