Search for content in message boards

How to see deep ethnicity (an alternative to the pie chart)

Replies: 183

How to see deep ethnicity (an alternative to the pie chart)

Posted: 1363910156000
Classification: Query
Edited: 1364000466000
Once GEDmatch is ready for the onslaught of Ancestry DNA files, it will be easy to look at several detailed analyses of your "admix," aka the ethnicity pie chart. Until then, I have a kludgy/inefficient/Windows-centric method to share for those who didn't get the gene that appreciates delayed gratification. :)

The instructions below will tell you how to see your "biogeographical analysis" using Eurogenes K35. Here's a post with some background about the test: (I know it says K36, but I only know where to get K35 files.)

First, convert your Ancestry DNA file to 23andMe format.

Edited 3/22: WAIT! Garry B. tells me we can actually skip this step. Woot! I'll leave the conversion instructions, but set them off in tildes below for easy skipping.

(Why 23andMe? Because my knowledge of how the programs below work would barely provide shelter for a gnat, so I can only go with what I know. I hope others will post better, easier, more efficient ways to do everything that follows.)

I don't have Excel, and Google Docs crawled off to die when I tried to load my Ancestry file, so I used a text editor. (I like Textpad.) You probably want to make a copy of the file you downloaded and work off of that.

1. Remove all the lines starting with hash marks (#) at the top of your raw data file. (Shouldn't really matter, but I removed them anyway.)

2. Replace (although, again, shouldn't really matter)
rsid chromosome position allele1 allele2
# rsid chromosome position genotype

3. Edited to add: You may have to delete all the lines at the bottom with "24" or "25" in the second position on the line. (I'm not sure if this is necessary, but I had to do it when I made a FTDNA file for Promethease, which I then converted to 23andMe format to try K35, so FYI.)

4. Close the gap between the two letters at the end of each line.

In Textpad, I would do this by searching for "T\tT" and replacing with "TT". (\t tells Textpad to look for a tab.) I would then do it for all possible pairs. (AG, AC, CC, etc.) In other editors/word processors that don't recoginize \t, just highlight and copy the letters and tab into the search box.

Thanks to APTurner, I can add that in a spreadsheet like Excel, you can combine two columns with this formula: =CONCATENATE(A1," ",B1).


Now you have to download a few things, and from here on out I'm drawing *heavily* on a post on 23andMe's forums by Peradam. (Those forums are closed to non-customers, plus a link here would be frowned upon. The links below are all to free tools, not to Ancestry's competitors, so we should be good.)

Download the DIYDodecad software (Click "File" then "Download" then extract to a folder):

Download the Eurogenes K35 files into the same folder:

Place your converted "23andMe-style" raw data file into that same folder.

Download and install

Everything is now in place. Time to start the party!

Open the R program and change the directory (File > Change Dir) to the folder where you placed your DIY, K37, and converted raw data files.

Enter this command:

Enter this command, changing the name of the text file to whatever you've called yours:
standardize('RENAMETHISTOYOURRAWDATAFILE.txt', company='23andMe')

(I always have a lag after this step.)

Enter this command:
system('DIYDodecadWin admix.par')

And off it goes. (For around 50 minutes, in my case, during which time you may think the program has hung up, but odds are it's all fine.) What you'll end up with is a list of populations and percentages. Ta-da!

(Okay, so it's no more useful than the pie chart, but at least it's quite different and gives you something to think about, if you like to think about deep ancestry.)

It seems there's a way to "paint" each pair of chromosomes to show which population is on which part of which chromosome. This can be useful when comparing with matches (not that we can do that yet). Alas, trying to figure out the command to do this makes my head swim, so I figure I'll just wait for GEDmatch. (If anyone knows how to do this, please holler!)
SubjectAuthorDate Posted
Shari S. 1363910156000 
carolynsgems2... 1363928173000 
Shari S. 1363930228000 
carolynsgems2... 1363930820000 
sfyri 1363932545000 
Shari S. 1363993005000 
sfyri 1363993834000 
Shari S. 1364014328000 
carolynsgems2... 1363974194000 
Shari S. 1364013640000 
per page

Find a board about a specific topic