GPDR Compliance Statement – PhyloGeographer does not use cookies or store the STRs or personal information you may enter on this page in any fashion, individually or aggregated. The STRs and all information entered stays within your browser and is not stored or transmitted anywhere. Refreshing the browser clears the data.
This tool is solely intended to assist you in finding matches.
The same privacy obligations of the source apply to the personal or DNA information processed and displayed here.

This script allows you to find STR matches within public FTDNA projects.

Developed by Hunter Provyn with input and support from YSEQ / Thomas Krahn.

1. Load Project Samples

Load multiple FTDNA projects, multiple YSEQ projects and multiple YFULL samples
Loading an FTDNA project deletes previously loaded YSEQ projects

FTDNA

Instructions

Haplogroup Administrators
1. Download Classic Results
2. Google Drive Spreadsheet -> Import -> Upload (check NO for autoformat numbers and dates)
3. Copy paste entire sheet into field below – (ctrl a), and copy paste (ctrl c), (ctrl v)

Non-Administrators
1. Open Classic Results of a Public Y-DNA Project in your browser (Firefox or Chrome)
2. Copy paste this into Google Drive Spreadsheet
3. Copy paste entire sheet into field below – (ctrl a), and copy paste (ctrl c), (ctrl v)

Tip: For projects displayed over multiple pages, increase the page size to 1000 or 5000 or whatever is necessary to load them all at once.
Note: For multiple project import, it will be necessary to change the header rows to be in the same order (easy through Google Sheets). A standard set of headers (before the STRs) are “Kit Number”, “Name”, “Paternal Ancestor Name”,”Country”, “Haplogroup”

YSEQ

YFull

2. Query

The following formats are supported

  • Kit Number (prepend YSEQ samples with “YSEQ”)
  • STR label-value pairs (separated by space): DYS385 12-13 DYS393 15
  • STR values (separated by tab): 12 13 14-14 (useful for copying STR values from a row of an FTDNA project table)
  • YFull semicolon separated STR format: DYS578;8;DYF395.1;15;DYF395.2





Matches are ranked according to the log sum of their deviating mutations, weighted by each STR’s mutation rate (thanks David Vance for mutation rates).
For matching alleles, a color code shows the in-project rarity for the shared value.