I “cluster” my mom’s DNA matches by adding two columns (shown here highlighted in red). Cousins C, D, E, F, G and H are the key here. But my brother and I are not the interesting cousins in the ICW cluster. Obviously that same couple would be the great-grandparents of my brother and me. So, if Mom and cousin “B” are first cousins, their Most Recent Common Ancestor(s) (MRCA) would be their shared set of (Italian) grandparents: Guiseppe Diamantini and Maria Bolognesi. Hence, we don’t have a lot of matches.) The critical point is that C, D, E, F, and G as well as my brother and I would show up on Mom’s match list AND on B’s match list - we are the “in common” matches. (Mom’s father was a first generation American, and “B”‘s father was born in Italy - not a lot of our Italian side, many still residing in Italy, have tested their DNA on Ancestry. So, Mom’s ICW list for “B” would include me, my brother, and six other cousins: C, D, E, F, G, H. My mom’s paternal first cousin - let’s call her “B” - has also tested at Ancestry. The In-Common-With (ICW) list is basically a subset of your matches list. You can see that to some extent with Ancestry’s predicted ranges in the green highlighted columns. Shared cM (centiMorgans) = shared DNA see my previous post here for more on centiMorgans.įor purposes of clustering, though, all we really care about is that in general, the more DNA you share, the closer you are related - at least in the case of 2nd cousins or closer. The “Mtch cM” and “Mtch Cousin” columns associate to Cousin B the “icw cM” and “icw Cousin” associate to the ICW match: me, my brother, and cousins C, D, E, F, G, and H. The combined columns are highlighted in green. The result is a combined file like that below. Once I have the two files, I use the VLOOKUP tool in Excel to associate (Cousin) Range and SharedCM to the primary match, and then to the In Common With matches. The columns of interest are “Range” and “SharedCM”. This is an abbreviated sample of the default match file.
How can i sort my dna matches on ancestry download#
Using the DNAGedcom Client tool, I will download a list of all her matches, and then download a list of all her “ICW” matches into CSV format. Let’s say I’m working with my mother’s DNA matches from.
Some of Mom’s shared matches with “Cousin B”, on Ancestry I’m sharing my way of clustering my matches - or, more specifically, my mother’s matches and my father’s matches - because the “best” method is the one that makes the most sense to you, or seems the most “intuitive”. (Although it actually works quite well for more distant cousins, in my opinion, especially if you’ve been working on clustering your matches for several years!) You can find out more about Dana’s method here.ĭespite these cool clustering methods - and others - in the end, I keep returning to my trusty Excel spreadsheet and my list of “ICW” (In Common With) matches from which I download using the DNAGedCom client tool (available here via a yearly subscription).
The DNA Color Clustering method used by Dana Leeds clustering methodology is straightforward, and especially effective for those persons who have many 2nd and 3rd cousin matches on Ancestry - which I don’t. Recently I’ve been using a clustering tool created by Evert-Jan Blom at Genetic Affairs (more on that tool in an upcoming post). There are more and more good visualization tools available for clustering your DNA matches with the intent of discovering a new ancestor.
0 kommentar(er)
