LATEST RESULTS TABLES

1.  FTDNA Public pages
2.  Main results table


1.  FTDNA Public pages for 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 participant's test 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 these 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 scrolling left & right and up & down is straightforward and enables its full extent to be grasped To find the entry of a particular participant, place the cursor on the letter "C" at the top of column (3), select "Find" (or Control and F), and enter the participant'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 normally only updated every six months, and which excludes details of participants who have not opted in to sharing, and a complete, up-to-date version which is available to Study members on e-mail request from the Study Administrator. 

Our Study's Main Results Table differ from FTDNA's Public Pages Results tables in several other ways:
- Our Study's table has some minor presentational differences in the grouping into genetic families; apologies for any confusion these differences may cause.
- The STR data in our Study' table now includes data above 111 markers, Genetic distances and TiP%s.
- 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 the Study's Main Results Tables.   
 
Key.
Arrangement of rows:
Rows 1- 11 are headers. 
Thereafter participant's results are grouped in their relevant genetic family, starting with our large 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, i.e. participants whose yDNA results do not (yet) match any other participant in the Study. A few examples of "False Positives" are appended.

Arrangement of columns:  For each participant:
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 participants join

Participant details

columns C, AA, AP, EO, GV  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 participants

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-X  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 

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           FTDNA TiP% from Family mode  from family mode at 37 markers

column AO          GD from Family mode at 37 markers

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

columns EP-FS   STR marker counts for Panel 6 that show variability from L555 modal counts.

columns FT-GU   STR marker counts for Panel 7 that show variability from L555 modal counts. 



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 participants who have not ticked the box "Opt in to sharing": see "Manage your FTDNA Account" for details.  All participants may request the Study Administrator to e-mail them a members-only version of the complete main results table at any time. 


Sources of participants' 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 participant, either directly or via FTDNA.  Consent for publishing the data in columns E and G-L is not required under GDPR. However participants 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 participant concerned






 






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


Ĉ
Rick Byers,
Sep 18, 2021, 1:16 PM
Comments