11

When DNA testing is done for genealogical purposes, they send back reports with all sorts of incomprehensible information.

I want to save the important information with the person in my genealogy program. I'll create custom fields.

But what I need to know is what data items do I need to create so that I'll have all the DNA info I need in my family file for future analysis?

5 Answers 5

7

Many Genealogy programs now have a specific field for this, including Ancestry.com.

The most important thing to record is the most granular Haplogroup that has been determined from your tests.

enter image description here

Also refer to this question on what format to use and field to store it in.

Y-DNA: (Y37, Y67, Y111, Big-Y, etc)

  • The most granular Haplogroup you have determined to belong to can easily be stored in a single field. Refer to the Y-Tree.
  • For Y-Str testing (Y37, Y67, Y111) testing you can (though it can be tedious at Y67 & Y111) copy and paste the full STR result set into a note in your genealogy program.
  • For Y-SNP testing from Genographic Project, Big-Y, FullGenomes, or a SNP pack; record the unique SNPs that granularly define your Haplogroup. Note on FamilyTree DNA you can download your SNP's but have to manually determine which are unique unless you have a Big-Y test and then it still is not very easy.

The following is from a YTree Y-Report.

enter image description here

mtDNA:

  • Record your Haplogroup
  • Copy the mtDNA detail markers (that I have blurred out in the screenshot) into a note. enter image description here

Autosomal: (AncestryDNA, FamilyFinder, 23andMe)

  • 23andMe provides high level YDNA and mtDNA Haplogroups in the old format R1b1a2b2a..etc vs. the format currently uses.. Convert this to the modern format. AncestryDNA and FamilyTreeDNA as of May 2016 do not provide Haplogroups from their tests.
  • Record the Ethnicity (note that it will vary slightly with each site) in a note.
  • Otherwise there is nothing you can definitely record easily in an easily interpretable / readable form.
5
  • Thanks for your answer. Four years later, I'm no longer really happy with the answer I accepted, and may change it if I find one better. But I am also not happy with not much progress in knowing what to record even four years later. The haplogroups and similar ID information alone doesn't cut it for me. That's trivial stuff. I'm now thinking more along the line of somehow putting match or triangulation info in along with common ancestors in a useful way.
    – lkessler
    Commented May 27, 2016 at 4:25
  • @lkessler Yes I wish there was some Two-Way Hash that was universal that could be stored for autosomal results, but with different testing companies all with custom chips and it being revised every so many years it would be difficult id think. Storing 700k markers is not practical for most either, matches are also kinda trivial and in a way temporary as kit and label names change.. and then at what threshold.
    – CRSouser
    Commented May 27, 2016 at 4:27
  • @lkessler The granular Haplogroup is also very very specific... it shows fairly clear direct paternal lineage
    – CRSouser
    Commented May 27, 2016 at 4:31
  • I'm not thinking about 700k markers. Rather, it would be nice to know that I have a 150 cM match with my third cousin, and that she has an mt match with my paternal grandmother.
    – lkessler
    Commented May 27, 2016 at 4:46
  • @lkessler But there are whole different tools for that and trying record that in any tree would be a mess, especially as more and more people test and are you going to link every person in between two individuals for every relationship.
    – CRSouser
    Commented May 27, 2016 at 4:51
7

For Y-DNA and mtDNA, store the raw results that you get, plus the haplogroup.

  • Y-DNA results are the marker names and their values. ex: DYS393=12

  • mtDNA results are the position where you differ from the Cambridge Reference Sequence (CRS) plus the base (letter) that you have. ex: 16519C.

For autosomal DNA, you'll need to store the complete raw data file. It's a huge file, so you can't just enter the data into a family tree program.

Some family tree programs now have fields for Y-DNA and mtDNA results, so check to see if your program has them before creating custom fields.

0
4

The growing popularity of biochemical genealogy places greater emphasis on the distinctions among data, information and evidence. (See also What is the difference between evidence and information?).

As you have noted, the test provider will return a vast array of data which may or may not be relevant to your current needs (or to your future interests in further investigation). In its raw form, this has little or no value in a genealogical sense. Note also, that the data set you receive will depend upon the choice of tests you had carried out (but more on that later).

Depending upon the test package you have purchased, some of that data will be distilled into information that the provider believes is relevant to your situation. Since most FH software gives you the facility to store {label, value} pairs, you should certainly store that information until you decide what it means to you.

If you have been corresponding with a possible (male) cousin about your (presumed) great grandfather, then two pieces of information about Y-chromosome markers (yours and his) can constitute evidence for the link between your family trees. When you combine the trees, you will cite the DNA test as justification (or, at least, support) for your decision.

At the present time, few family historians understand the type of generic information that is required as evidence for particular problems we face. DNA test providers have tended to concentrate on delivering as much information as possible rather than ensuring they understand what clients actually need.

Would you walk into a vital records registry and ask to purchase certificates for all the Smith births in the nineteenth century? For some of us, getting a DNA test is rather like that. We need to become more sophisticated clients and learn to frame our information requests to match our needs rather than the providers stock.

Begin with the genealogical question that interests you ("Is it true that we have spanish ancestry?") only then can you find out what type of genetic information can provide evidence relevant to that question. Then look within the mass of data provided for information (in this case, on haplogroups) to be recorded as evidence for or against the family legend.

As with most family history searches, the ideal is to understand the question before you start to gather information; although we all have boxes of documents that may or may not be useful. If your aim is to identify a candidate father of an ancestor, then using a mitochonrial DNA test will be a waste of time and money (for that particular question) because the information it will provide cannot constitute evidence. Think of it as being like obtaining a birth certificate in order to identify the cause of death -- all the information is true and concerns the right person, but is useless for the intended purpose.

Every new data type requires us to learn when and how to interrogate it in order to obtain value for our purposes. Biochemical tools are opening up new opportunities, but they will demand study.

2

A couple of good articles were written by Michele Lewis in the Legacy Family Tree News.

How I use Hashtags to track my DNA matches, Ms. Lewis says if she knows how a DNA tester matches her, she adds their direct line back to their most recent common ancestor into her tree with a special Master Source called "DNA Match - Lineage not confirmed", which will be updated once confirmed genealogically. She then adds a hashtag (a Legacy feature) to the tester and the tester's direct line that says MRCA with the testers who share the MRCA. She does something similar for Y-DNA matches which she describes in the article.

Recording DNA Matches (Intermediate) says to add your "cousin matches" to your genealogy program as unlinked individuals. You can record the company they tested with as an event along with other information, such as kit number and tests done. Ms. Lewis says she only includes the 3rd cousin level people to keep the number of them manageable. She marks them as "invisible" (i.e. research only), so that she never exports that data until she finally links someone up.

2

What data items do I need to create so that I'll have all the DNA info I need in my family file for future analysis?

There are a couple of basic issues involved when recording data that need to be addressed here.

  • Preserving data for the future so we can analyze it again.
  • Creating a pointer to it so we have ease of access. We can't analyze it again if we can't find it.

It isn't always apparent, but most lineage-linked software is designed to record information that we have reached a conclusion about. It isn't the most robust answer when we are recording the "multiple maybes".

It might be more efficient to store your complete DNA results in a separate unstructured journal, and create a note in your lineage-linked software pointing to where the information is in your DNA journal. Your DNA journal could hold

  • the full DNA test results for a person
  • multiple ethnicity estimates and match lists
  • notes on your current progress for analyzing the data

In your family tree software, you could include:

  • flags to indicate the person has DNA test data
  • your most recent summary of evidence analysis (e.g. from Evidentia's Cousin Tracker, or your own proof summary)

The problem with entering data into genealogy software, in general, is that it encourages us to cherry-pick the information that we think is important at the time we are doing data entry. By nature, we pull this data out of the surrounding context. Even if we make a full transcription of a person's entry in a document like a census enumeration, we generally don't store all the data related to other people in the neighborhood. Because of this, I think relying only on what's in our genealogy program is a mistake. It discourages us from reviewing our original documents as a group and seeing new connections as we find new information.

DNA test results are further complicated because the information we're given in reports is in flux, so rather than storing a single transcription of a document in notes attach to our person, we may need to store a series of snapshots, depending on the analysis of the moment.

So my answer would be:

  1. Record the information that you might need to access quickly (e.g. a report from Evidentia's Cousin Tracker)
  2. Record the information that you need as pointers to your larger DNA files, that you might need to discover via a query in your software. At the very least that would mean, all people in your database who have test data. It might include tags or flags for the testing companies, the haplogroup, the type of test, and whether the person is a member of a DNA project.

I would avoid entering information which is volatile. If you want to keep track of how someone's ethnicity estimates have changed over time, that might be better in a separate journal.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.