Y-DNA Comparison Utility

Written by Dean McGee and modfied by Gregory A. Parker for use in current DNA Surname Project

Generate Tables Ysearch order haplotype comparison
SMGF order haplotype comparison with search links
Ybase order haplotype comparison
Yhrd order haplotype comparison
Genetic Distance

Hybrid mutation model
Infinite allele mutation model
TMRCA (infinite allele model)

Probability Units

50%
95%
Other %

Mutation Rate
Constant:
FTDNA 0.004..0.0075

McDonald (0.0005..0.01)
Generations
Years
years/generation
General Setup Show Line Numbers
Create modal haplotype
Show Legends
Show Status
Show HTML Source Show Mutation Rates
Highlight Reference
Modal Reference
Row Reference
None
Import SMGF Data
ID Column1
2
3
4
All non-Data

1^st Data Column2
3
4
5
Automatic

instructions & info

Paste haplotype rows here (without marker headers):

Debug box:

This utility is free for your use. You are welcome to use this utility and it's output as you see fit.

Instructions

Copying haplotype data
This utility is designed for copy-and-paste input of haplotype data from web pages or Excel tables. The haplotype data must be in the normal order provided by Ysearch, FTDNA, and many surname projects.

No non-numeric characters other than whitespace are allowed after the first column of allele data.

Some DNA tables have multiple lines of data in one cell. This is not supported, even when pasting from Excel. You must have only a single line of data in any cell.

Normally generated tables of data will copy correctly, but if you are copying from a manually created table where there may be extra whitespace between allele values this utility may not parse the data correctly. You can either edit the data so that no more than one blank space exists between allele values (or three blank spaces for a missing value), or you can copy the data first to an Excel spreadsheet then copy from Excel and paste into this utility. Data copied from an Excel spreadsheet is tab-delimited, and this utility should be able to parse it without problem.

Y-DNA Allele setup
The default setup of this utility should handle most cases, but where there is an extra value for DYS19b or DYS464e/f/g, you will need to check the box associated with that allele. Range checking is done on all data so it is unlikely that you inadvertantly miss enabling one of these alleles without being notified that some value is too large or small.

ID Column
By default all characters before the first data column for each haplotype will be used as identification info. You can select a particular column to use for identification.

1^st Data Column
By default this utility will try to identify the first column of allele data for each haplotype. It does this by looking for the first three consecutive numeric tokens that are within the limits for the first three alleles. Normally this works without issue, but you can construct a table of data where this technique fails, in which case you can specify the starting column of the allele data. Even this may fail in some cases, in which event, you should copy the data first to an Excel spreadsheet then paste from Excel into this utility.
Ysearch order haplotype comparison
If this table is enabled, then a listing of all the haplotype data is generated in the Ysearch/FTDNA order. If the modal haplotype is enabled then a modal haplotype will be determined and listed as the first row. If difference highlighting is enabled, then difference between the reference haplotype and every other haplotype for each allele will be determined. The background color will be set according to the following:
- 0 : none
- 1 : green
- 2 : yellow
- 3+ : pink
SMGF order haplotype comparison
If this table is enabled, then a listing of all haplotype data is generated in the order and format supported by the Sorenson Molecular Genealogy Foundation, SMGF, in their website database. Clicking on a link in the ID column will open a new window to search the SMGF database with the values from the selected haplotype.
Ybase order haplotype comparison
If this table is enabled, then a listing of all haplotype data is generated in the order and format supported by the Ybase database.
YHRD order haplotype comparision
If this table is enabled, then a listing of all haplotype data is generated in the order and format supported by the YHRD database.
Genetic Distance
If this table is enabled then a table of genetic distances between every pair of haplotypes is created. The diagonal elements of the table indicate the number of allele data existing for that haplotype. The calculations can be of two types:
1. Hybrid Mutation Model
  The target of this model is to match that used by Ysearch and FTDNA. It uses the stepwise mutation model for all alleles except DYS464 and YCA which use the infinite allele model. The stepwise model says that each mutation is allowed to change the allele value by exactly one, so a difference of two means that two mutations occurred and a difference of three means that three mutations occurred. The infinite allele model says that the entire difference between allele values, no matter how large, is the result of one mutation.
  Please notify me if you find any inconsistencies between the genetic distances calculated here and those provided by Ysearch or FTDNA.
2. Infinite Allele Mutation Model
  The infinite allele model says that the entire difference between allele values, no matter how large, is the result of one mutation.
The close distances are highlighted for easier visualization of possible family relationships by the following:
- Related : green
- Probably Related : yellow
- Possibly Related : pink
TMRCA (Time to the Most Recent Common Ancestor)
If this table is enabled then a table of generations or years to the most recent common ancestor for every pair of haplotypes is created. The number listed is either the 50% or 95% probability that the MRCA was no longer than the specified number of years or generations. The algorithm taken from Bruce Walsh paper, Estimating the Time to the Most Recent Common Ancestor for the Y chromosome or Mitochondrial DNA for a Pair of Individuals. There are other utilities related to MRCA calculations and can be found on the Helpful Tools page at http://www.worldfamilies.net/ site and Ann Turner's Mutation Calculator.
The TMRCA calculations use the average mutation rate for all the markers common between the pair of haplotypes being compared.
There are three selections for how the mutation rate is determined.
By default the values determined by Doug McDonald as derived from the Sorenson database are used. Markers not included in the Sorenson database are derived by Doug through other means. Tabular values and additional information can be found on the World Families Network Marker Mutation Rate page.
The second mutation rate selection uses the FTDNA derived mutation rates. This includes a rate of 0.00399 for the first 12 markers, 0.00481 for markers 13 through 25, and 0.00748 for the markers 26 through 37. For markers outside the 37 used by FTDNA the values determined by Doug McDonald from the Sorenson database are used but scaled by 1.43 to make the basis consistent between the two sets of rates.
The first option for mutation rate calculation uses a constant mutation rate for all markers. This constant mutation rate can be changed in the box provided. The default mutation rate is 0.0024 mutations/allele/generation which represents the 60 total mutations during 24870 total allele meioses as given in Y-Chromosomal Microsatellite Mutation Rates: Differences in Mutation Rate Between and Within Loci by B.Myhre Dupuy, M.Stenerson, T.Egeland, and B.Olaisen; Human Mutation 23:117-124 (2004). Note that this rate does not include rates of some of the newer fast-mutating alleles that are currently being used.
The close distances are highlighted for easier visualization of possible family relationships by the following:
- 0-9 Generations: green
- 10-19 Generations: yellow
- 20-29 Generations: pink
- 30-39 Generations: blue
Note that if units of years are chosen, the number of generations are mulitplied by the specified rate of years per generation.
Modal Haplotype
If this item is enabled then a modal haplotype will be created that is the haplotype consisting of the allele values with the largest number of occurrences in the haplotypes provided. In the event of a tie, the larger allele value is used.
Show Legends
This item causes a color legend to be associated with each chart for haplotype, genetic distance or generations to most recent common ancestor
Show status
This item causes a status box to be displayed at the top of the output window. Large numbers of haplotypes may take some time to process and this status box gives an indication of what items this utility is currently processing.
Show HTML Source
This item causes the HTML source code for each table to be output to a text box for ease of cut-and-paste to surname web pages.
Highlight Reference
If this item is enabled then the specified haplotype will be used as a reference for the haplotype comparison table and will appear with white background and blue fontcolor in all the tables.
Clear Button
Pressing this button will clear the input data textboxes but retain all other configuration information.
Execute Button
Pressing this button will cause a new browser window to open containing the specified tables of data.
Debug box
This textbox contains the processed data and includes line numbers. It may be useful to use this to identify where the input data is incompatible with the parsing algorithm used by this utility or to identify the row number of the desired haplotype for Highlight Reference selection.

contact:
Gregory A. Parker
Please notify me if some portion of this utility is not operating correctly

Parker Surname DNA Project
Parker Surname DNA Project Results