DNAPainter: Painting “Bucketed” Family Tree DNA Maternal and Paternal Family Finder Matches in One Fell Swoop

DNAPainter has done it again, providing genealogists with a wonderful tool that facilitates separating your matches into maternal and paternal categories so that they can be painted on the proper chromosome – in one fell swoop no less.

Of course, the entire purpose of painting your chromosomes is to identify segments that descend from specific ancestors in order to push those lines back further in time genealogically. Identifying segments, confirming and breaking down brick walls is the name of the game.

DNA Painter New Import Tool

The new DNAPainter tool relies on Family Tree DNA’s Phased Family Matching which assigns your matches to maternal and paternal buckets. On your match list, at the top, you’ll see the following which indicates how many matches you have in total and how many people are assigned to each bucket.

DNAPainter FF import.png

Note that these are individual matches, not total matching segments – that number would be higher.

In order for Family Tree DNA to create bucketed matches for you, you’ll need to:

  • Either create a tree or upload a GEDCOM file
  • Attach your DNA kit to “you” in your tree
  • Attach all 4th cousins and closer with whom you match to their proper location on your tree

Yes, it appears that Family Tree DNA is now using 4th cousins, not just third cousins and closer, which provides for additional bucketed matches.

How reliable is bucketing?

Quite. Occasionally one of two issues arise which becomes evident if you actually compare the matches’ segments to the parent with whom they are bucketed:

  • One or more of your matches’ segments do match you and your parent, but additionally, one or more segments match you, but not your parent
  • The X chromosome is particularly susceptible to this issue, especially with lower cM matches
  • Occasionally, a match that is large enough to be bucketed isn’t, likely because no known, linked cousin shares that segment

Getting Started

Get started by creating or uploading your tree at Family Tree DNA.

DNAPainter mytree.png

After uploading your GEDCOM file or creating your tree at Family Tree DNA, click on the “matches” icon at the top of the tree to link yourself and your relatives to their proper places on your tree. Your matches will show in the box below the helix icon.

DNAPainter FF matches.png

I created an example “twin” for myself to use for teaching purposes by uploading a file from Ancestry, so I’m going to attach that person to my tree as my “Evil Twin.” (Under normal circumstances, I do not recommend uploading duplicate files of anyone.)

DNAPainter FF matches link.png

Just drag and drop the person on your match list on top of their place on the tree.

DNAPainter Ff sister.png

Here I am as my sister, Example Adoptee.

I’ve wished for a very, very long time that there was a way to obtain a list of segment matches sorted by maternal and paternal bucket without having to perform spreadsheet gymnastics, and now there is, at DNAPainter.

DNAPainter does the heavy-lifting so you don’t have to.

What Does DNAPainter Do with Bucketed Matches?

When you are finished uploading two files at DNAPainter, you’ll have:

  • Maternal groups of triangulated matches
  • Paternal groups of triangulated matches
  • Matches that could not be assigned based on the bucketing. Some (but not all) of these matches will be identical by chance – typically roughly 15-20% of your match list. You can read about identical by chance, here.

I’ll walk you through the painting process step by step.

First, you need to be sure your relatives are connected to your tree at Family Tree DNA so that you have matches assigned to your maternal and paternal buckets. The more relatives you connect, per the instructions in the previous section, the more matching people will be able to be placed into maternal or paternal buckets.

Painting Bucketed Matches at DNAPainter

I wrote basic articles about how to use DNAPainter here. If you’re unfamiliar with how to use DNAPainter or it’s new to you, now would be a good time to read those articles. This next section assumes that you’re using DNAPainter. If not, go ahead, register, and set up a profile. One profile is free for everyone, but multiple profiles require a subscription.

First, make a duplicate of the profile that you’re working with. This DNAPainter upload tool is in beta.

DNAPainter duplicate profile.png

Since I’m teaching and experimenting, I am using a fresh, new profile for this experiment. If it works successfully, I’ll duplicate my working profile, just in case something goes wrong or doesn’t generate the results I expect, and repeat these steps there.

Second, at Family Tree DNA, Download a fresh copy of your complete matching segment file. This “Download Segments” link is found at the top right of the chromosome browser page.

DNAPainter ff download segments.png

Third, download your matches at the bottom left of the actual matches page. This file hold information about your matches, such as which ones are bucketed, but no segment information. That’s in the other file.

DNAPainter csv.png

Name both of these files something you can easily identify and that tells them apart. I called the first one “Segments” in front of the file name and the second one “Matches” in front of the file name.

Fourth, at DNAPainter, you’ll need to import your entire downloaded segment file that you just downloaded from Family Tree DNA. I exclude segments under 7cM because they are about 50% identical by chance.

DNAPainter import instructions

click to enlarge

Select the segment file you just named and click on import.

DNAPainter both.png

At this point, your chromosomes at DNAPainter will look like this, assuming you’re using a new profile with nothing else painted.

Let’s expand chromosome 1 and see what it looks like.

DNAPainter chr 1 both.png

Note that all segments are painted over both chromosomes, meaning both the maternal and paternal copies of chromosome 1, partially shown above, because at this point, DNAPainter can’t tell which people match on the maternal and which people match on the paternal sides. The second “matches” file from Family Tree DNA has not yet been imported into DNAPainter, which tells DNAPainter which matches are on the maternal and which are on the paternal chromosomes.

If you’re not working with a new profile, then you’ll also see the segments you’ve already painted. DNAPainter attempts to NOT paint segments that appear to have previously been painted.

Fifth, at DNAPainter, click on the “Import mat/pat info from ftDNA” link on the left which will provide you with a page to import the matches file information. This is the file that has maternal and paternal sides specified for bucketed matches. DNAPainter needs both the segment file, which you already imported, and the matches file.

DNAPainter import bucket

click to enlarge

After the second import, the “matches” file, my matches are magically redistributed onto their appropriate chromosomes based on the maternal and paternal bucketing information.

I love this tool!

At this point, you will have three groups of matches, assuming you have people assigned to your maternal and paternal buckets.

  • A “Shared” group for people who are related to both of your parents, or who aren’t designated as a bucketed match to either parent
  • Maternal group (pink chromosome)
  • Paternal group (blue chromosome)

It’s Soup!!!

I’m so excited. Now my matches are divided into maternal and paternal chromosome groups.

DNAPainter import complete.png

Just so you know, I changed the colors of my legend at DNAPainter using “edit group,” because all three groups were shades of pink after the import and I wanted to be able to see the difference clearly.

DNAPainter legend.png

Your Painted Chromosomes

Let’s take a look at what we have.

DNAPainter both, mat, pat.png

There’s still pink showing, meaning undetermined, which gets painted over both the maternal and paternal chromosomes, but there’s also a lot of magenta (maternal) and blue (paternal) showing now too as a result of bucketing.

Let’s look at chromosome 1.

DNAPainter chr 1 all.png

This detail, which is actually a summary, shows that the bucketed maternal (magenta) and paternal (blue) matches have actually covered most of the chromosome. There are still a few areas without coverage, but not many.

For a genealogist, this is beautiful!!!

How many matches were painted?

DNAPainter paternal total.png

DNAPainter maternal total.png

Expanding chromosome 1, and scrolling to the maternal portion, I can now see that I have several painted maternal segments, and almost the entire chromosome is covered.

Here’s the exciting part!

DNAPainter ch1 1 mat expanded.png

I starred the relatives I know, on the painting, above and on the pedigree chart, below. The green group descends through Hiram Ferverda and Eva Miller, the yellow group through Antoine Lore and Rachel Hill. The blue group is Acadian, upstream of Antoine Lore.

DNAPainter maternal pedigree.png

Those ancestors are shown by star color on my pedigree chart.

I can now focus on the genealogies of the other unstarred people to see if their genealogy can push those segments back further in time to older ancestors.

On my Dad’s side, the first part of chromosome 1 is equally as exciting.

DNAPainter chr 1 pat expanded.png

The yellow star only pushed this triangulated group back only to my grandparents, but the green star is from a cousin descended from my great-grandparents. The red star matches are even more exciting, because my common ancestor with Lawson is my brick wall – Marcus Younger and his wife, Susanna, surname unknown, parents of Mary Younger.

DNAPainter paternal pedigree.png

I need to really focus hard on this cluster of 12 people because THEIR common ancestors in their trees may well provide the key I need to push back another generation – through the brick wall. That is, after all, the goal of genetic genealogy.

Woohoooo!

Manual Spreadsheet Compare

Because I decided to torture myself one mid-winter day, and night, I wanted to see how much difference there is between the bucketed matches that I just painted and actual matches that I’ve identified by downloading my parents’ segment match files and mine and comparing them manually against each other. I removed any matches in my file that were not matches to my parent, in addition to me, then painted the rest.

I’ll import the resulting manual spreadsheet into the same experimental DNAPainter profile so we can view matches that were NOT painted previously. DNAPainter does not paint matches previously painted, if it can tell the difference. Since both of these files are from downloads, without the name of the matches being in any way modified, DNAPainter should be able to recognize everyone and only paint new segment matches.

Please note here that the PERSON unquestionably belongs bucketed to the parental side in question, but not all SEGMENTS necessarily match you and your parent. Some will not, and those are the segments that I removed from my spreadsheet.

DNAPainter manual spreadsheet example.png

Here’s a made-up example where I’ve combined my matches and my mother’s matches in one spreadsheet in order to facilitate this comparison. I colored my Mom’s matches green so they are easy to see when comparing to my own, then sorting by the match name.

Person 1 matches me and Mom both, at 10 cM on chromosome 1. Person 1 is assigned to my maternal side due to the matches above 9 cM, the lowest threshold at Family Tree DNA for bucketing.

In this example, we can see that Person 1 matches me and Mom (colored green), both, on the segment on chromosome 1. That match, bracketed by red, is a valid, phased, match and should be painted.

However, Person 1 also matches me, but NOT Mom on chromosome 2. Because Person 1 is bucketed to mother, this segment on chromosome 2 will also be painted to my maternal chromosome 2 using the DNAPainter import. The only way to sort this out is to do the comparison manually.

The same holds true for the X match shown. The two segments shown in red should NOT be painted, but they will be unless you are willing to compare you and your parents’ matches manually, you will just have to evaluate segments individually when you see that you’re working in a cluster where matches have been assigned through the mass import tool.

If you choose to compare the spreadsheets manually to assure that you’re not painting segments like the red ones above, DNAPainter provides instructions for you to create your own mass upload template, which is what I did after removing any segment matches of people that were not “in common” between me and mother on the same chromosomal segment, like the red ones, above.

Please note that if you delete the erroneous segments and later reimport your bucketed matches, they will appear again. I’m more inclined to leave them, making a note.

I did not do a manual comparison of my father’s side of the tree after discovering just how little difference was found on my mother’s side, and how much effort was involved in the manual comparison.

Creating a Mass Upload Template and File

DNAPainter custom mass upload.png

The instructions for creating your own mass upload file are provided by DNAPainter – please follow them exactly.

In my case, after doing the manual spreadsheet compare with my mother, only a total of 18 new segments were imported that were not previously identified by bucketing.

Three of those segments were over 15cM, but the rest were smaller. I expected there would be more. Family Tree DNA is clearly doing a great job with maternal and paternal bucketing assignments, but they can’t do it without known relatives that have also tested and are linked to your tree. The very small discrepancy is likely due to matches with cousins that I have not been able to link on my tree.

The great news is that because DNAPainter recognizes already-painted segments, I can repeat this anytime and just paint the new segments, without worrying about duplicates.

  • The information above pertains to segments that should have been painted, but weren’t.
  • The information below pertains to segments that were painted, but should not have been.

I did not keep track of how many segments I deleted that would have erroneously been painted. There were certainly more than 18, but not an overwhelming number. Enough though to let me know to be careful and confirm the segment match individually before using any of the mass uploaded matches for hypothesis or conclusions.

Given that this experiment went well, I created a copy of my “real” profile in order to do the same import and see what discoveries are waiting!

Before and After

Before I did the imports into my “real” file (after making a copy, of course,) I had painted 82% of my DNA using 1700 segments. Of course, each one of those segments in my original profile is identified with an ancestor, even if they aren’t very far back in time.

Although I didn’t paint matches in common with my mother before this mass import, each of my matches in common with my mother are in common with one or the other of my maternal grandparents – and by using other known matches I can likely push the identity of those segments further back in time.

Status Percent Segments Painted
Before mass Phased Family Match bucketed import 82 1700
After mass Phased Family Match bucketed import 88 7123
After additional manual matches with my mother added 88 7141

While I did receive 18 additional matching segments by utilizing the manually intensive spreadsheet matching and removal process, I did not receive enough more matches to justify the hours and hours of work. I won’t be doing that anymore with Family Tree DNA files since they have so graciously provided bucketing and DNAPainter can leverage that functionality.

Those hours will be much better spent focusing on unraveling the ancestors whose stories are told in clusters of triangulated matches.

I Love The Import Tool, But It’s Not Perfect

Keep in mind that the X chromosome needs a match of approximately twice the size of a regular chromosome to be as reliable. In other words, a 14 cM threshold for the X chromosome is roughly equivalent to a 7 cM match for any other chromosome. Said another way, a 7 cM match on the X is about equal to a 3.5 cM match on any other chromosome.

X matches are not created equal.

The SNP density on the X chromosome is about half that of the other chromosomes, making it virtually impossible to use the same matching criteria. I don’t encourage using matches of less than 500 SNPs unless you know you’re in a triangulated group and WITH at least a few larger, proven matches on that segment of the X chromosome.

Having said that, X matches, due to their unique inheritance path can persist for many generations and be extremely useful. You can read about working with the X chromosome here and here.

I noticed when I was comparing segments in the manual spreadsheet that I had to remove many X matches with people who had identical matches on other chromosomes with me and my mother. In other words, just because they matched my mother and me exactly on one chromosome, that phasing did not, by default, extend to matching on other segments.

I checked my manually curated file and discovered that I had a total of seven X matches that should have been, and were, painted because they matched me and Mom both.

DNAPainter X spreadsheet example.png

However, there were many that didn’t match me and Mom both, matching only me, that were painted because that person was bucketed (assigned) to my maternal side because a different segment phased to mother correctly.

On the X chromosome, here’s what happened.

DNAPainter maternal X.png

You can see that a lot more than 7 bright red matches were painted – 26 more to be exact. That’s because if an individual is bucketed on your maternal or paternal side, it’s presumed that all of the matching segments come from the same ancestor and are legitimate, meaning identical by descent and not by chance. They aren’t. Every single segment has an inheritance path and story of its own – and just because one segment triangulates does NOT mean that other segments that match that person will triangulate as well.

The X chromosome is the worst case scenario of course, because these 7 cM segments are actually as reliable as roughly 3.5 cM segments on any other chromosome, which is to say that more than 50% of them will be incorrect. However, some will be accurate and those will match me and mother both. 21% of the X matches to people who phased and triangulated on other chromosomes were accurate – 79% were not. Thankfully, we have phasing, bucketing and tools like this to be able to tell the difference so we can utilize the 21% that are accurate. No one wants to throw the baby out with the bath water, nor do we want to chase after phantoms.

Keep in mind that Phased Family Matching, like any other tool, is just that, a tool and needs some level of critical analysis.

Every Segment Has Its Own Story

We know that every single DNA segment has an independent inheritance path and story of its own. (Yes, I’ve said that several time now because it’s critically important so that you don’t wind up barking up the wrong tree, literally, pardon the pun.)

In the graphic above of my painted X chromosome matches, only the six matches with green stars are on the hand-curated match list. One had already been painted previously. The balance of the bright red matches were a part of the mass import and need to be deleted. Additionally, one of the accurate matches did not upload for some reason, so I’ll add that one manually.

I suggest that you go ahead and paint your bucketed segments, but understand that you may have a red herring or two in your crop of painted segment matches.

As you begin to work with these clusters of matches, check your matching segments with your parents (or other family members who were used in bucketing) and make sure that all the segments that have been painted by bulk upload actually match on all of the same segments.

If you have a parent that tested, there is no need to see if you and your match match other relatives on that same side. If your match does not match you and your parent on some significant overlapping portion of that same segment, the match is invalid. DNA does not “skip generations.”

If you don’t have a parent that has tested, your known relatives are your salvation, and the key to bucketed matches.

The great news is that you can easily see that a bulk match was painted from the coloring of the batch import. As you discover the relevant genealogy and confirm that all segments actually match your parent (or another family member, if you don’t have parents to test,) move the matching person to the appropriately colored ancestral group.

I further recommend that you hand curate the X chromosome using a spreadsheet. The nature of the X makes depending on phased matching too risky, especially with a tool like DNAPainter that can’t differentiate between a legitimate and non-legitimate match. The X chromosome matches are extraordinarily valuable because they can be useful in ways that other chromosomes can’t be due to the X’s unique inheritance path.

What About You?

If you don’t have your DNA at Family Tree DNA and you have tested elsewhere, you can transfer your DNA file for free, allowing you to see your matches and use many of the Family Tree DNA tools. However, to access the chromosome browser, which you’ll need for DNA painting, you’ll need to purchase the unlock for $19, but that’s still a lot less than retesting.

Here are transfer instructions for transferring your DNA file from 23andMe, Ancestry or MyHeritage.

If you have not purchased a Family Finder test at Family Tree DNA and don’t have a DNA file to transfer, you can order a test here.

_____________________________________________________________

Disclosure

I receive a small contribution when you click on some of the links to vendors in my articles. This does NOT increase the price you pay but helps me to keep the lights on and this informational blog free for everyone. Please click on the links in the articles or to the vendors below if you are purchasing products or DNA testing.

Thank you so much.

DNA Purchases and Free Transfers

Genealogy Products and Services

Genealogy Research

Fun DNA Stuff

  • Celebrate DNA – customized DNA themed t-shirts, bags and other items

30 thoughts on “DNAPainter: Painting “Bucketed” Family Tree DNA Maternal and Paternal Family Finder Matches in One Fell Swoop

  1. That seems like a nice tool, assuming the website was responsive. I generally get the spinning (wait a long while) icon when trying to add someone, rendering the website practically useless.

  2. Please clarify “Attach all 4th cousins and closer with whom you match to their proper location on your tree”. Does this mean if I know which matches Family Tree DNA has placed in my maternal bucket I attach those to the maternal side of my family tree and by process of elimination attach the remaining matches that are not bucketed to my paternal side? Also, am I correct in assuming that the 4th Cousin catergory includes 4th Cousin Remote?

    • No, I mean your actual 4th cousins or closer need to be tested and placed on your tree. I think you have this backwards. You’re attaching cousins you know how they are related in order to get other bucketed matches, not placing people on your tree by a predicted relationship level. If your mother has tested, those not placed would either be your father or those identical by chance. Usually 15-20% of your matches are identical by chance.

  3. Hi, I went and tried out DNA Painter after reading this article. Unfortunately my tree was garbled at FTDNA after their update so I need to do some work to get it useful again. I decided to look at my brother’s X-matches to see which ones are also in my match list. Since I know those people must be related to my mother, I downloaded the segments I have in common with them and assigned them to a group that paints on the female chromosomes. A few are already overlapping. Tedious but I have gotten through about 1/4 or so in a couple hours. Are these reasonable assumptions to make?

  4. No luck navigating the DNA Painter to select and upload the csv file the was exported from FTDNA. Under the screen shot of the section i see’ FTDNA Buc’ and an arrow to an import function. You mention it being a beta function.

    What I see is choices of
    Click a button below to find out how to generate clusters with each provider:

    Genetic Affairs MyHeritage Gedmatch DNAGedcom

    You can generate cluster files at geneticaffairs.com. Genetic Affairs works by logging into the testing companies (23andMe, AncestryDNA and FamilyTreeDNA) on your behalf, downloading your shared match information, and organizing this into clusters.

    Obviously, I must be in the wrong place.

    • Hi Roland. Open the profile you want to import the file into. Click on the gear. You’ll see the title “Import Tools” on the left side. The first option underneath is “Import segment data.” That’s what you want. then follow the instructions in the article.

  5. Howcome there are different numbers of maternal matches (913) and paternal matches (1036) between FTDNA match data header, and painted matches DNAPainter report, which says 1003 and 894 in your screen shots?

  6. Hi Roberta, I followed your directions and the import from FTDNA bucketed worked perfectlyl I have them sorted and colored according to maternal, paternal, don’t know and labeled on each chromosome. Now I see triangulation groups that I would like to paint a different color because I know the most recent common ancestor and want to identify it, but I can’t figure out how to isolate these groups and paint them separately, and label them. Also researched the site and haven’t found the answer. Can I capture these by drawing a rectangle around them, name them and paint them a different color? Thanks, Karlyn Shedlowski

    • You can’t just draw around a specific group, but you can edit any match and you can make a group and name it something specific – if you recognize how that group is related, for example. Then you edit each match in that group to add them to the same group you created. There’s a DNAPainter Facebook page to where lots of help is offered.

  7. Would this also work for an adoptee if you don’t know who is maternal and paternal? Would you be able to have side A and side B just to differentiate the two parental lines?

  8. Hi everyone,

    I meant to reply to this earlier but have been busy…waiting for cousins to upload/transfer their dna from ancestry to ftdna and gedmatch. What happened was a …. happy accident. I’ve been very slow at marking cousins on ftdna. In fact, i’ve only focused on marking cousins on my Dad’s side at FTDNA. Dad passed away in 1995. But I got my mom to dna test. And my brother tested. So that got me phasing at gedmatch and the potential of phasing a FTDNA. And I tracked down some 4th cousins – but no 3rd cousins – on my dads paternal side. You see, I don’t have 3rd cousins, because my 2nd great grandfather had no siblings. Then FTDNA incorporated 4th cousins for showing the paternal phase.

    And presto! I suddenly see a bunch (94) cousins on my dads side – all somehow connected to my 3rd great grandparents. Then two more cousins transferred their DNA, and they trace to two of my other 3x Great Aunts. And even more exciting, I triangulated a new dna segment that is …huge 32 and 36cM respectively, covering a total of 44 cM. Which I discovered overlaps with another cousin from the same branch of my father’s paternal line.

    So I got this idea – what if I had two profiles at FTDNA. One with all my cousins mapped out. And another (with my dna of course) only mapped to the cousins on the branch I’m trying to make discoveries.

    Somehow, I feel like you suggested something like that…and I haven’t even loaded the new cousins into DNA painter or any of your new suggestions….

  9. Pingback: Concepts: Chromosome Browser – What Is It, How Do I Use It, and Why Do I Care? | DNAeXplained – Genetic Genealogy

  10. Hey Roberta,
    Thanks for all you do. I have an interesting match on FTDNA. It turns out my match and I have two common ancestors. My question is do I link both of those to be “bucketed” on my pedigree chart. It just seems a little strange to have the same person to be bucketed twice. But I am very sure through records and such that we do indeed connect two different ways.
    Thanks so much for the help!
    Jeff

    • You link the relative that you match to their proper place in your tree. The software behind the scenes takes care assigning your matches to maternal and paternal buckets.

  11. A follow up question.

    My dad’s parents were 2nd cousins from Perry County, Kentucky. So my dad’s parents would share a set of great grandparents. I have found several matches to them which means if I link these matches I would have the same match in his paternal and maternal buckets. So would it be a good idea to link them or would that add confusion to the research process?
    Thanks,
    Jeff

    • Yes, link them. The problem now with the FTDNA tree is that you have enter common ancestors separately. So if your match descends from that couple or above, it will be confusing. That said, I would still link them. You’ll just need to know that it could really be both.

Leave a Reply to Roberta EstesCancel reply