LATEST RESULTS TABLES
Contents
1. FTDNA Public pages
2. Main results table
1. Public pages for FTDNA's Irwin Clan Surname DNA Project
For the latest available FTDNA Y-STR results of the Irwin Clan Surname DNA Project see Y-DNA Results. These results are the most up-to-date version available and the most simple to access and read, but cannot be edited further to include the much detailed data and analyses that our Study's Main Results Table is now able add to each tester's results - see below.
Note: There are two versions of FTDNA's Public pages tables, one that includes all project members and one that excludes those who have not opted in to sharing their results in public. 96% of the project's members have opted in to sharing. Project members (only) can access the more comprehensive version if they first sign in to their FTDNA account at https://www.familytreedna.com/my/account-information.
2. Main Results Table for Clan Irwin Surname DNA Study
Click here to download an Excel spreadsheet version of the six-monthly update of our Study's expanded version of FTDNA's results. This spreadsheet is now very large, with over 160 columns and 600 rows, so don't try to print out a hard copy (it would run to at least 9 sheets!), or to "Zoom" to get it all on one screen. However optimising the Zoom setting and scrolling lyeft & right and up & down is straightforward and enables its full extent to be grasped . To find the entry of a particular tester, place the cursor on the letter "C" at the top of column (3), select "Find" (or Control and F), and enter the tester's Kit No.
As with FTDNA's Y-DNA Results table for the Irwin Clan project, our Study's Main Results Table has two versions: the version obtained here on this website, which is only updated on-line every six months, and which excludes details of testers who have not opted in to sharing, and a complete, up-to-date version which is available to Study members in Excel or PDF format on e-mail request from the Study Administrator.
Our Study's Main Results Table differs from FTDNA's Public Pages Results tables in several other ways:
Our Study's table has some minor presentational differences in the grouping into branches; apologies for any confusion these differences may cause.
The STR data in our Study's table now includes data above 111 markers, Genetic distances and TiP%s. STR counts for markers numbered over 111 are only included for markers for which one or more testers have counts different to the modal BA counts.
Our Study's table adds some Family Finder data, SNP data, BigY data and the L555 haplotree.
Our Study's table includes y-DNA results from other testing companies;
Note: Results of autosomal/Family Finder and mitochondrial tests of individuals who have not taken a y-DNA test do not appear in either FTDNA's public results tables or our Study's Main Results Tables.
Key.
Arrangement of rows:
Rows 1- 11 are headers.
Thereafter tester's results are grouped in their relevant branch (aka genetic family), starting with our large Borders branch. The results for this large branch are now divided into two sections; section B1 contains first those testers who have taken BigY tests, L555 Pack tests or equivalent, or who are related to such testers 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 branch and sub-group (other than the SNP sequenced Border Irwins) individual testers’ data on each line are sequenced by their TiP Score from the Study's modal, BA.
Finally come our Singletons, i.e. testers whose yDNA results do not (yet) match any other tester in the Study. A few examples of "False Positives" are appended.
Arrangement of columns: For each tester:
Genetic family details
column A# Genetic family indicator and full name
column B# Item (sequential number) Note this numbering is liable to change are new testers join
Tester details
columns C, AZ, BY, II Test kit number
column D* Residence (A: Australia; C: Canada: E: England; F: France; I: Ireland; S: Scotland; U: USA; Z: New Zealand)
Earliest confirmed paternal ancestor details
column E* Surname
column F* Forename
column G* Residence before migration
column H* Residence after migration
column I* Born (c: circa, about; fl.: flourished; p: post, after)
column J* Died ( ” )
Genealogical relationship to other testers
column K* Relationship known before DNA test
column L# Pedigree name (“*”: entry in Burkes Landed Gentry)
column M# Relationship identified by yDNA testing
SNP test data
column N Haplogroup (red: as predicted by FTDNA; green: as tested)
column P SNP tests taken (italics: on order; bold: paid for or subsidized by General Fund)
column Q# basis for inclusion in haplotree if not SNP test
column R column in Big Tree format L555 haplotree
columns S-AG most significant 8 digit numbers are locations of SNPs not yet named)
column AH# Identified branches
column AI private SNPs
Family Finder Test data
column AL Family Finder test taken
column AM Suggested relationships
STR test data
column AN# Genetic family (as column A)
column AO# “Former sub-group” (e.g. "B9"; Note that these groupings have now been found to be misleading)
column AP No. of markers tested (italics: on order)
columns AQ-AU GD (Genetic Distance) from Borders mode at 12, 25, 37, 67 & 111 markers respectively
column AV FTDNA TiP% from Borders mode at 24 generations (former value) NB FTDNA discontinued this facility c.2015.
column AW FTDNA TiP% from Borders mode at 24 generations (current value) NB FTDNA discontinued this facility in 2023.
column AX FTDNA TiP% from Branch mode from family mode at 37 markers ditto
column AY GD from Branch mode at 37 markers
columns BA-EX STR marker counts, Panels 1-5.
columns EZ-IH STR marker counts for Panels 6&7 that show variability from L555 modal counts (Borders branch only).
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
█ olive >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 since pre-surname era)
heavy box: significant matches
"not shared in public" indicates testers who have not ticked the box "Opt in to sharing": see "Manage your FTDNA Account" for details. All testers may request the Study Administrator to e-mail them a members-only version of the complete main results table at any time.
Sources of testers' data: Data in this table is derived from FTDNA sources, or other testing company as indicated, except as follows:
#: Data supplied by Study Administrator. Data in lines 8-17 has also been supplied by Study Administrator, who has also extrapolated the colour coding and other annotations in the STR marker cells as below.
*: Data that has been volunteered the individual tester, either directly or via FTDNA. Consent for publishing the data in columns E and G-L is not required under GDPR. However testers may e-mail the Study Administrator at any time to ask for any of their details to be updated, or deleted from the public version of our main results table, or to leave our Study. Details in this table will be updated or removed as quickly as is practicable on receipt of an e-mail request by the tester concerned.
* If you don't have Microsoft Excel, you can download a free viewer for Windows here.