1.  FTDNA Public pages
2.  Main results table

1.  FTDNA Public pages

For the latest available FTDNA Y-STR results of our Study see < Y-DNA Results.  This version is the most up-to-date version available and the more simple to access and read, but it cannot be edited further to include sub-groups or the much detailed data that can be associated with each participant's test results that are included in our Main Results Table. 

Note that there are some minor differences between FTDNA's Public Pages and our Study's Main Results table in how the results are grouped into genetic families and sub-groups.  The groupings/genetic families used in the "Latest Analysis Update" are those shown in our Main Results table, not those shown in the Public Pages.  Apologies for any confusion the discrepancies may cause. 

2.     Main Results Table

Click here to download an Excel spreadsheet version of these results.*  Although this table is not as up-to-date as the table on FTDNA's public pages it is much more detailed, and now also includes some SNP and Family Finder data; .  The STR data includes the basic test results, Genetic Distances, TiPs, and non-FTDNA test data.  The SNP data includes the Border Irwin L555 haplotree.  The Family Finder data is restricted to Irwin relatives.  This on-line results table is updated at least every six months when the "Latest Analysis Update" is compiled.  More up-to-date versions are available on e-mail request from the Study Administrator. 

This table is more detailed than FTDNA's table, and now includes ySTR, ySNP and autosomal test data.  The STR data includes the basic test results, Genetic Distances, TiPs, and non-FTDNA test data.  The SNP data includes data from BigY tests, SNP Pack test and single SNP tests and the Border Irwin L555 haplotree.  This on-line results table is updated at least every six months when the "Latest Analysis Update" is compiled.  More up-to-date versions are available on e-mail request from the Study Administrator.  


The Excel spreadsheet is now very large, with 160 columns and over 560 rows, so don't try to "Zoom" it to get it all on one screen!  Instead you will find scrolling left & right and up & down is straightforwardTo find the entry of a particular participant, place the cursor on the letter "D" at the top of column (3), select "Find" (or Control and F), and enter the participant's Kit No. 


Arrangement of rows:

Rows 1- 9 are headers.  Thereafter participant's results are grouped in their relevant genetic family, starting with our Borders genetic family.  The results for this large family are now divided into two sections; section B1 contains first those participants who have taken BigY tests, L555 Pack tests or equivalent, or who are related to such participants by genealogy or autosomal tests; section B2 contains those who have not yet taken L555 Pack tests, arranged by the "old" STR sub-groups.  Within each genetic family and sub-group (other than the SNP sequenced Border Irwins) individual participants’ data on each line are sequenced by their TiP Score from the Study's modal, BA.  Finally come our Singletons, with a few "False Positives" at the end.


Arrangement of columns:  For each participant:
Gentic family details

column A#    Genetic family indicator and full name

column B#    Item (sequential number) Note this numbering is liable to change are new participants join

Participant details

columns C, AA, AO, EO    Test kit number

column D      Formerly ySearch ID  (now deleted)

column E      Residence (A: Australia; C: Canada: E: England; F: France; I: Ireland; S: Scotland; U: USA; Z: New Zealand)

column F      G indicates participant has submitted a Gedcom family tree

Earliest confirmed paternal ancestor details

column G*    Surname

column H*     Forename

column I*      Residence before migration

column J*     Residence after migration

column K*     Born (c: circa, about; fl.: flourished; p: post, after)

column L*     Died (                                                                   )

Genealogical relationship to other participants

column M*    Relationship known before DNA test

column N#    Pedigree name (“*”: entry in Burkes Landed Gentry)

column O#    Relationship identified by yDNA testing

SNP test data

column P     Haplogroup (red: as predicted by FTDNA; green: as tested)

column R     SNP tests taken (italics: on order; bold: paid for or subsidized by General Fund)

column S#    basis for inclusion in haplotree if not SNP test

column T-Y most significant SNPs (8 digit numbers are locations of SNPs not yet named)

column Y#    Identified branches

column Z      Downstream SNPs

Family Finder Test data

column AB   Family Finder test taken

column AC   Suggested relationships (temporarily withdrawn for administrative reasons)

STR test data

column AD#  Genetic family (as column A)

column AE#  “Old sub-group” (e.g. "B9"; Note that these groupings have now been found to be misleading)

column AF    No. of markers tested (italics: on order)

columns AG-AK  GD (Genetic Distance) from Borders mode at 12, 25, 37, 67 & 111 markers respectively

column AL   FTDNA TiP% from Borders mode at 24 generations (former value)

column AM  FTDNA TiP% from Borders mode at 24 generations (current value)

column AN   Genetic Distance from family mode at 37 markers

column AO  FTDNA TiP% from Family mode

columns AQ-EN STR marker counts, Panels 1-5.

STR marker counts for Panel 6 that show variability from L555 mode. 

Sources of member information

Data in this table is derived from FTDNA sources, except as follows:

*: Data that has been volunteered wholly or in part by individual participant.  Consent for publishing the data in columns E and G-L is not required under GDPR, but this and all other data in this table will be updated or removed as quickly as is practicable on receipt of an e-mail request by the participant concerned

#: Data supplied by Study Administrator.  Data in lines 8-17 has also been supplied by Study Administrator, who has also extrapolated some of FTDNA's haplotree in columns R through AA  and the colour coding and other annotations in the STR marker cells as below. 


Coding in individual STR marker cells:
red         : >2 more than the modal value of BA
orange   :   2 more than the modal value of BA
yellow    :   1 more than the modal value of BA
no colour:        same as the modal value of BA
lt. blue    :   1 less  than the modal value of BA
emerald  :   2 less  than the modal value of BA
        : >2 less  than the modal value of BA

italics:         rare marker values

bold:          fast moving markers

small:           different rule for GD      

underlined:  back mutation (count has changed twice during surname era)

heavy box:  significant matches


* If you don't have Microsoft Excel, you can download a free viewer for Windows here

Rick Byers,
May 27, 2018, 6:35 PM