• 23andme
  • May9

    22 Comments

    UPDATE (11 July 2013): It has been more than a year since I created this tool and process, and the 23andme site has gone through some extensive changes. I have not had time to test if the process in this post nor the spreadsheet is still working properly with any possible data format changes.

    Feel free to give it all a shot, but I recommend that you may first want to take a look at the DNAGedcom.com site, which has automated things in a much more user-friendly way!

    Ancestry Finder Drop DownIf you are a 23andme customer, you may have noticed that they updated their Ancestry Finder (AF) tool to make it possible to see the matches of the people with whom you share genomes. You can also download this data in comma-separated-variable (.csv) format.

    That. is. great. stuff.

    I’m sure that people will soon come up with interesting new ways to triangulate their genetic matches and learn more about their ancestry. But, there is one problem: If you are sharing your results with a few hundred people and want to get all of their AF data files, it takes a drop-down selection, wait a few seconds for AF to reload, then a button click and a Save File As click FOR EACH PERSON IN YOUR LIST.

    Holy carpal tunnel.

    I suppose 23andme might make it possible within their system to get them all at once which will make this all moot. But, I thought there must be a better way to get all of these data files and I found a slightly clunky, yet completely workable method.

    There may be more elegant ways to do this, but for now I created an Excel spreadsheet that will help you get you all the data with only a bit copying and pasting – along with some help from a Firefox add-on.

    Read More | Comments

  • Sep26

    2 Comments

    23andme Research Snippet Capture

    Genetic testing company 23andme uses “Research Snippet” questions to compare people’s answers to their DNA results.

    Typically they are simple questions and often have obvious usefulness – such as “Have you ever undergone LASIK eye surgery?” I would think a comparison of certain locations of the response group individuals’ DNA could one day predict a the likelihood of a certain affliction.

    But, I am quite amused by the 2nd question in this research snippet screen capture:
    Does the sound of other people chewing fill you with rage?
    YES. YES IT DOES. (Actually, not really.)

    But I am left thinking about those who might answer “I’m not sure.”

    “Hmm, well, it is not RAGE exactly, but mandibular gyrations DO cause me to be overcome with a certain combination of ENNUI and MUDEROUS INTENTION.”

    For more information on 23andme’s research see their blog – this post in particular:
    23andMe Research Team Presents Findings at International Human Genetics Meeting

  • Mar25

    2 Comments

    Last year when 23andme had a $99 sale for DNA Day I jumped on the deal (a $400 savings!) and ordered a test kit. Since my results came in I’ve found that while they eventually may present some clear answers, for now the results have mainly provided a path to follow. And the path takes a LOT of reading.

    With the help of others in the 23andme community and some user-run projects I’ve learned quite a bit, but I’ve only scratched the surface when it comes to understanding all of the science and history.

    As of now I’ve got about 350 genetic matches on their Relative Finder, (mostly 5th cousins and higher) and am sharing genomes with several dozen. But it is not always obvious which side of my tree those cousins are from – I’m half Czech and half Irish and I have matches in quite a few countries, with some small clusters toward Germany, Ukraine, Russia and Scandinavia.

    I’m guessing these matches are from further back in the tree my Czech side, but that’s all they are for now – guesses. (It is possible the Scandinavian goes back through my Irish side with all of the Vikings that came down for a visit.)

    So, as any good techno-geek would do, I’ve tried to put crunch the data in various ways to look for patterns that might offer further clues. My first run at this was a simple chart of the Haplogroups of my matches in 23andme’s Relative Finder. My own maternal haplogroup is U5b1 and my paternal haplogroup is R1b1b2a1a2f.

    Interestingly, in my maternal haplogroup matches I do not have any matches in my own U5b1 haplogroup and only 3 out of 195 in nearby U subclades.

    Read More | Comments