Disclaimer: I did not read Rushton’s seminal book on the topic. I was only first recently able to obtain a complete electronic copy (i.e. not abridged version). I did in fact only skim this literature. I don’t have time to work on this, but I’d like others to do so, hence I put the labor […]

We need dplyr for this: library(dplyr) First, use the anon user to log into the SQL server (user = “anon”, pass = “”, ip = “128.199.203.208”, port = 3306): sql = src_mysql(“population_freqs”, host = “128.199.203.208”, user = “anon”, port = 3306) Select the 1000 genomes phase 3 table: sql_1kg = tbl(sql, “1000genomes_phase3”) #look at the […]