R1b-L21 Haplotypes Spreadsheet & SNP Tree


Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Wed Feb 20, 2013 3:11 am
[quote="Mikewww"]I've updated the spreadsheet under the Links section at http://tech.groups.yahoo.com/group/R1b-L21-Project/

Whoopeee! We've broken 1500 111 STR haplotypes. We are now up to 1515.

You can click on the "AllHts" tab to get to the big worksheet of all haplotypes.

You can click on the "ExtHts" to get back to the worksheet of 111 STR haplotypes only.

I've also updated the L21 Descendancy Tree to include L1065 in its position.
https://dl.dropbox.com/u/17907527/R1b-L ... y_Tree.jpg

This graphic Descendency Tree is intended to reflect the Clade/SNP Index on the Clades tab/worksheet. This is the way the spreadsheet treats SNPs in terms of haplogroup label assignments and picking up relevant SNPs for the Downstream SNPs column. I'm to keep up with Geno 2.0/WTY data that David Reynolds organizes for us. Let me know of errors you see. This is the file's current contents (equivalents include synonyms):
Code: Select all
L21+  >>> R1b-P312>L21;  * = DF13-  ** = DF63-,  Equivalents: S145,M529,L459,Z245  R1b1a2a1a1b3
DF13+  >>> R1b-P312>L21>DF13;  * = L513- DF21- DF49- Z253- Z255- DF41- L1335-  ** = CTS4466- L371- L555- L96- L144-,  Equivalents: /S521  R1b1a2a1a1b3a
L513+  >>> R1b-P312>L21>DF13>L513;  * = L193- L706.2- L69-  ** = L192.1- L9- L10- L577- L908- L909- L1333-,  Equivalents: /DF1/S215,Z249,Z250  R1b1a2a1a1b3a2
L193+  >>> R1b-P312>L21>DF13>L513>L193+; Terminal,  Equivalents: /S176  R1b1a2a1a1b3a2b
L706.2+  >>> R1b-P312>L21>DF13>L513>L706.2;  * = L705.2-  ** = n/a  R1b1a2a1a1b3a2c
L705.2+  >>> R1b-P312>L21>DF13>L513>L706.2>L705.2+; Terminal  R1b1a2a1a1b3a2c1
L69.5+  >>> R1b-P312>L21>DF13>L513>L69.5;  * = P66-  ** = n/a 
P66+  >>> R1b-P312>L21>DF13>L513>L69.5>P66+; Terminal,  Equivalents: P66_1,P66_2,P66_3  R1b1a2a1a1b3a2a
DF21+  >>> R1b-P312>L21>DF13>DF21;  * = P314.2- Z246- L720-  ** = S424-,  Equivalents: /S192  R1b1a2a1a1b3a7
P314.2+  >>> R1b-P312>L21>DF13>DF21>P314.2;  * = L362-  ** = n/a,  Equivalents: /S220.2  R1b1a2a1a1b3a7a
L362+  >>> R1b-P312>L21>DF13>DF21>P314.2>L362+; Terminal  R1b1a2a1a1b3a7a1
Z246+  >>> R1b-P312>L21>DF13>DF21>Z246;  * = DF25-  ** = n/a,  Equivalents: /S280  R1b1a2a1a1b3a7b
DF25+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25;  * = DF5-  ** = n/a,  Equivalents: /S253  R1b1a2a1a1b3a7b1
DF5+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5;  * = L627- L658-  ** = n/a,  Equivalents: /S191  R1b1a2a1a1b3a7b1a
L627+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627;  * = L626-  ** = n/a  R1b1a2a1a1b3a7b1a1
L626+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626;  * = L625-  ** = n/a 
L625+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626>L625+; Terminal 
L658+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L658+; Terminal  R1b1a2a1a1b3a7b1a2
L720+  >>> R1b-P312>L21>DF13>DF21>L720+; Terminal,  Equivalents: /S299  R1b1a2a1a1b3a7c
S424+  >>> R1b-P312>L21>DF13>DF21>S424;  * = S190-  ** = n/a,  Equivalents: /S426  R1b1a2a1a1b3a7d
S190+  >>> R1b-P312>L21>DF13>DF21>S424>S190+; Terminal,  Equivalents: /S308,S309,S427  R1b1a2a1a1b3a7d1
DF49+  >>> R1b-P312>L21>DF13>DF49;  * = DF23-  ** = n/a,  Equivalents: /S523  R1b1a2a1a1b3a1
DF23+  >>> R1b-P312>L21>DF13>DF49>DF23;  * = M222-  ** = n/a  R1b1a2a1a1b3a1a
M222+  >>> R1b-P312>L21>DF13>DF49>DF23>M222; Terminal,  Equivalents: Page84,USP9Y+3636  R1b1a2a1a1b3a1a1
PF1169+  >>> R1b-P312>L21>DF13>DF49>DF23>M222>PF1169+; Terminal  T.Krahn: located in a highly repetitive region
Z253+  >>> R1b-P312>L21>DF13>Z253;  * = Z2534- L554-  ** = n/a,  Equivalents: /S218  R1b1a2a1a1b3a6
Z2534+  >>> R1b-P312>L21>DF13>Z253>Z2534;  * = L226- Z2185- L643-  ** = DF73-  R1b1a2a1a1b3a6b
L226+  >>> R1b-P312>L21>DF13>Z253>Z2534>L226+; Terminal,  Equivalents: /S168  R1b1a2a1a1b3a6b1
Z2185+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185;  * = L1066-  ** = n/a  R1b1a2a1a1b3a6b3
L1066+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066;  * = L895-  ** = n/a  R1b1a2a1a1b3a6b3a
L895+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066>L895+; Terminal,  Equivalents: L894 
L643+  >>> R1b-P312>L21>DF13>Z253>Z2534>L643+; Terminal  R1b1a2a1a1b3a6b2
DF73+  >>> R1b-P312>L21>DF13>Z253>Z2534>DF73+; Terminal 
L554+  >>> R1b-P312>L21>DF13>Z253>L554+; Terminal  R1b1a2a1a1b3a6a
Z255+  >>> R1b-P312>L21>DF13>Z255;  * = L159.2-  ** = n/a,  Equivalents: /S219  R1b1a2a1a1b3a5
L159.2+  >>> R1b-P312>L21>DF13>Z255>L159.2+; Terminal,  Equivalents: /S169.2  R1b1a2a1a1b3a5a
DF41+  >>> R1b-P312>L21>DF13>DF41;  * = L744-  ** = L563-,  Equivalents: /S534,CTS6581  R1b1a2a1a1b3a9
L744+  >>> R1b-P312>L21>DF13>DF41>L744;  * = L745-  ** = n/a,  Equivalents: /S388,L746,S310  R1b1a2a1a1b3a9a
L745+  >>> R1b-P312>L21>DF13>DF41>L744>L745+; Terminal,  Equivalents: /S463  R1b1a2a1a1b3a9a1
L563+  >>> R1b-P312>L21>DF13>DF41>L563+; Terminal  R1b1a2a1a1b3a9b
L1335+  >>> R1b-P312>L21>DF13>L1335;  * = L1065-  ** = L1334- 
L1065+  >>> R1b-P312>L21>DF13>L1335>L1065;  * = L743-  ** = n/a 
L743+  >>> R1b-P312>L21>DF13>L1335>L1065>L743+; Terminal 
CTS4466+  >>> R1b-P312>L21>DF13>CTS4466+; Terminal 
L371+  >>> R1b-P312>L21>DF13>L371+; Terminal,  Equivalents: /S300  R1b1a2a1a1b3a8
L555+  >>> R1b-P312>L21>DF13>L555+; Terminal,  Equivalents: /S393  R1b1a2a1a1b3a10
L96+  >>> R1b-P312>L21>DF13>L96+; Terminal  R1b1a2a1a1b3a3
L144.1+  >>> R1b-P312>L21>DF13>L144.1+; Terminal,  Equivalents: /S175  R1b1a2a1a1b3a4
DF63+  >>> R1b-P312>L21>DF63;  * = CTS6919-  ** = n/a,  Equivalents: /S522  R1b1a2a1a1b3b
CTS6919+  >>> R1b-P312>L21>DF63>CTS6919+; Terminal 
L459+ >>> Unpositioned under P312
Z245+ >>> Unpositioned under P312
Z260+ >>> Unpositioned under P312
Z290+ >>> Unpositioned under P312
Z2542+ >>> Unpositioned under P312
L69+ >>> Unpositioned under L21
L159.?+ >>> Unpositioned under L21
L144+ >>> Unpositioned under L21
L195+ >>> Unpositioned under L21
L319+ >>> Unpositioned under L21
L1312+ >>> Unpositioned under L21
L1314+ >>> Unpositioned under L21
L1315+ >>> Unpositioned under L21
CTS2457+ >>> Unpositioned under L21
zzM37+ >>> Unpositioned under L21
PF3434+ >>> Unpositioned under DF13
CTS11440+ >>> Unpositioned under DF13
CTS2501+ >>> Unpositioned under DF13
CTS1751+ >>> Unpositioned under DF13
CTS5714+ >>> Unpositioned under DF13
L130+ >>> Unpositioned under DF13
L152+ >>> Unpositioned under DF13
L526+ >>> Unpositioned under DF13
L557+ >>> Unpositioned under DF13
L561+ >>> Unpositioned under DF13
L564+ >>> Unpositioned under DF13
L580+ >>> Unpositioned under DF13
L583+ >>> Unpositioned under DF13
L679+ >>> Unpositioned under DF13
Z249+ >>> Unpositioned under DF13
L192.1+ >>> Unpositioned under L513
L9+ >>> Unpositioned under L513
L10+ >>> Unpositioned under L513
L577+ >>> Unpositioned under L513
L908+ >>> Unpositioned under L513
L909+ >>> Unpositioned under L513
L1333+ >>> Unpositioned under L513
L642+ >>> Unpositioned under DF21
S424+ >>> Unpositioned under DF21
S426+ >>> Unpositioned under DF21
L1336+ >>> Unpositioned under DF21
L641+ >>> Unpositioned under DF21
L876+ >>> Unpositioned under DF21
Z248+ >>> Unpositioned under DF25
CTS3655+ >>> Unpositioned under DF5
L302+ >>> Unpositioned under DF49
Z2955+ >>> Unpositioned under DF23
Z2961+ >>> Unpositioned under DF23
Z2962+ >>> Unpositioned under DF23
Z2963+ >>> Unpositioned under DF23
Z2964+ >>> Unpositioned under DF23
Z2970+ >>> Unpositioned under DF23
Z2972+ >>> Unpositioned under DF23
Z2973+ >>> Unpositioned under DF23
Z2988+ >>> Unpositioned under DF23
PF1217+ >>> Unpositioned under M222
CTS8002+ >>> Unpositioned under M222
F3952+ >>> Unpositioned under M222
PF3292+ >>> Unpositioned under M222
PF825+ >>> Unpositioned under Z253
L894+ >>> Unpositioned under Z253
L1308+ >>> Unpositioned under Z253
F4036+ >>> Unpositioned under Z253
Z2182+ >>> Unpositioned under Z253
Z2184+ >>> Unpositioned under Z253
PF1557+ >>> Unpositioned under Z253
Z2183+ >>> Unpositioned under Z2185
L746+ >>> Unpositioned under DF41
L247+ >>> Unpositioned under DF41
L1334+ >>> Unpositioned under L1335
CTS6838+ >>> Unpositioned under L1335
CTS7030+ >>> Unpositioned under L1335
L459+ >>>  equivalent to L21
Z245+ >>>  equivalent to L21
Z260+ >>>  equivalent to L21
Z290+ >>>  equivalent to L21
DF1+ >>>  equivalent to L513
Z249+ >>>  equivalent to L513
L192+ >>>  equivalent to L192.1
L705+ >>>  equivalent to L705.2
L706+ >>>  equivalent to L706.2
P314+ >>>  equivalent to P314.2
CTS2646+ >>>  equivalent to Z2182
CTS9975+ >>>  equivalent to Z2185
CTS11722+ >>>  equivalent to L1065
CTS1202+ >>>  equivalent to L1066
CTS6581+ >>>  equivalent to DF41

Posts: 24
Joined: Sat Nov 24, 2012 11:41 pm

YDNA:
L21+ Z253+ Z2185+
MtDNA:
J2b1a
PostPosted: Thu Feb 21, 2013 1:10 pm
Mike, the spreadsheet is phenomenal. I trust you'll have a celebratory drink (or three) when you reach 10,000 entries at <=67 markers and/or 2,000 at 111 markers :)

I thought I'd ask what the rest of us can do to assist, as I'm not sure what criteria you have at present for inclusion as a speculative entry. If we find good matches on off-modals in surname projects to a person who is already in the spreadsheet, do you want them regardless of whether they have tested for an SNP (eg all those who are predicted M269+)? What about those who have only tested to 37 markers, but match a variety which has a distinctive off-modal signature in those first 37 markers?

Such entries won't always turn out to be correct, but the spreadsheet is to some extent speculative and is very much a work in progress (hence your frequent updates). Over the last year or so I've found quite a number of pretty convincing matches to some of the Z253+ varieties who either haven't replied to emails or have declined further testing. Many of these were in Ysearch, but it's usually not that difficult for me to find the corresponding entry in a surname project, and it seems a pity to not put this data to good use.

I also would like to check with you regarding a couple of your L1066+ entries please. The draft FTDNA Y-tree stats for L1066 are currently 37 derived from 62 tests.However, there are 39 L1066+ entries in the spreadsheet. This includes two L1066+ entries which I have not seen previously - McDonald N12949 and Roberts 41991. Neither has joined the Z253 Project or L21+ Project.

The Roberts kit is in the Roberts surname project and is L21+ but does not appear to have tested for Z253 or L1066. The McDonald kit is in the Clan Donald Project but doesn't have SNPs listed below R1b.

I'm just wondering if either of these two kits is really confirmed L1066+, or meant to be predicted only.

Greg

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Thu Feb 21, 2013 5:09 pm
hoxgi wrote:... I also would like to check with you regarding a couple of your L1066+ entries please. The draft FTDNA Y-tree stats for L1066 are currently 37 derived from 62 tests.However, there are 39 L1066+ entries in the spreadsheet. This includes two L1066+ entries which I have not seen previously - McDonald N12949 and Roberts 41991. Neither has joined the Z253 Project or L21+ Project.

The Roberts kit is in the Roberts surname project and is L21+ but does not appear to have tested for Z253 or L1066. The McDonald kit is in the Clan Donald Project but doesn't have SNPs listed below R1b.

I'm just wondering if either of these two kits is really confirmed L1066+, or meant to be predicted only.


Greg, thank you for your diligence in checking. We need an advocate for every major subclade and cluster to check the data in the spreadsheet, the tree/SNP summary (from David) and promote recruiting, project involvement and intelligent testing.

I'll use this is an occasion to explain more clearly what I'm doing. I have an internal Excel workbook that has raw FTDNA report paste/input and transform capabilities. When I do a large manual copy/paste of the Y DNA SNP public project report into my internal workbook, a set of transform formulas build a string of relevant SNPs (to the particular subclade) that ends up in the AllHts Downstream SNPs column. On the Clades tab there is a Clade/SNP Index of SNPs that tell the formulas what to look for and how to assign haplogroup labels. One set of SNPs are listed with a -2 beside them for depth level as a designator they are synonyms or phylogenetic equivalents. When the formulas hit one of these SNPs they add the equivalent SNP to the string. From the Clades tab here is the current list I'm checking for.

L459+ >>> equivalent to L21
Z245+ >>> equivalent to L21
Z260+ >>> equivalent to L21
Z290+ >>> equivalent to L21
DF1+ >>> equivalent to L513
Z249+ >>> equivalent to L513
L192+ >>> equivalent to L192.1
L705+ >>> equivalent to L705.2
L706+ >>> equivalent to L706.2
P314+ >>> equivalent to P314.2
CTS2646+ >>> equivalent to Z2182
CTS9975+ >>> equivalent to Z2185
CTS11722+ >>> equivalent to L1065
CTS1202+ >>> equivalent to L1066
CTS6581+ >>> equivalent to DF41

Notice that CTS1202 is L1066. My understanding from David Reynold's SNP compendium is that these are synonyms. Since FTDNA is doing away with long haplogroup labels I'm forced into naming branches (subclades) by their lead SNPs. In this case I picked L1066 as the lead SNP so all CTS1202+ people get automatically assigned as L1066+ people.

From your Z253 project these two people have their CTS1202+ status translated to the L1066 haplogroup branch.
154690 Bunch
169985 Cummings

The 154690 McDonald fellow is one I originally found in the Dunnaich/Donald project, I think. He has since joined the L21 project.

41991 Roberts is another story, which is why I thank you for double checking the date. I think his is just a plain mistake so I'll remove the CTS1202+ L1066+ status. I'm pretty sure I started my manual copy operation from one character to the right of what I should have. In reality, the correct guy who is CTS1202+ is
241991 Clancy

I missed the "2".

I have a system for double checking this kind of errors. When ever I copy/paste in Y Classic or Y SNP project report into the workbook internal input/transform sections I compare and sort the total allele count and the old and newly calculated downstream SNP strings. Differences are flagged for updating.

You can see the manual "copy/paste" and then the manual "input/transform/flag for update/add" processes are both subject to operator (me) error and time consuming. The error checking process is only as good as how often I look at a project.

This is why I plead for everyone to join the R-L21 Plus project. I copy/paste from it once or twice a week and Rich S has both the Y Classic and Y SNP screens turned on with MDKA's showing. It's okay to be in multiple projects. This is always I've pleaded with a large number of project admins on WFN sites to turn on their FTDNA public project screens.... so I only have one format to deal with and we see the SNP results too.

As far as suspected L21 haplotypes go, they should be clearly designated on the AllHts worksheet with "zzL21suspect" in the Haplogroup column and blanks in the Downstream SNPs column. I do this so you can easily filter out anything that starts with a "zz" and have pure SNP confirmed reports and analysis. Some day, I may have to just pull them out altogether as the workbook is getting too big. I actually started inserting them because I was looking for people that matched me. I have since created a set of formulas in the input/transform section that look for certain STR patterns that are easy to spot at 67 markers. The Scots, Airghelli I, Airghelli II, Wales I, Wales II, Wales III, Little Scots, MacWho, 9919-A, Irish II, Irish III, Irish IV, NW Irish, SW Eng/Wales, 1117, etc., etc. are all picked up this way but I don't have complete coverage of STR signatures by any means. I also am fairly rigid on picking up suspects. You have to have 67 STRs, all of the signature matching and some low GDs with matching people who are confirmed L21+.

P.S. Since I was correcting the Roberts error I went the Roberts project found a good 253-11F suspect, 250031.

Posts: 24
Joined: Sat Nov 24, 2012 11:41 pm

YDNA:
L21+ Z253+ Z2185+
MtDNA:
J2b1a
PostPosted: Fri Feb 22, 2013 1:15 pm
Mike, thank you for the detailed explanation. I can only imagine how much time you must have put into your spreadsheet over the years. I now have a much better understanding of what's involved.

I'm happy to check the Z253 varieties in the spreadsheet from time to time. We're picking up new members of the Z253 Project through Geno 2.0 testing, most of whom appear to have STR testing underway. I'll contact each of them re joining the R-L21+ Project.

Re the two L1066+ entries I queried, you've dealt with Roberts (I'll chase up the other Roberts you found re Z253 testing). Mc Donald appears to be a little more complicated. I've found him in the Scottish DNA Project and he is indeed Z253+ and CTS1202+. However I can't find him in either the Z253 Project or the L21+ Project by searching on his kit # (N12949). You had him in your post as 154690, but this is the kit # of Bunch, not McDonald.

In the Z253 Project the following are listed as both L1066+ and CTS1202+, presumably because they had each tested for L1066 prior to testing Geno 2.0, which would have picked up L1066 again, this time with the designation CTS1202:
Bunch 154690
Curley 176429
Cummins 169985
Clancy 241991

However, because McDonald had not tested previously for L1066, he is not listed as L1066+, only CTS1202+.

This explains the discrepancy in the FTDNA count; there are 37 people officially L1066+ according to the FTDNA draft tree and Y-map, but there are 38 in your spreadsheet, because McDonald does not have L1066 in his list of positive SNPs.

I'm pleased that we've sorted that one out. I'll contact McDonald about joining the Z253 and L21+ Projects.

Greg

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Fri Feb 22, 2013 11:27 pm
Here's the latest I have for the R1b-L21 phylogenetic tree.
https://dl.dropbox.com/u/17907527/R1b-L21_Descendency_Tree.jpg

Hopefully, the graphic chart and the below Clade table (from the R1b-L21_Haplotypes spreadsheet) mirror each other. That is my intent. Let me know of errors. I can't wait until more CTS4466 results come in to see if it really encompasses the Irish II/South folks.

Code: Select all
L21+  >>> R1b-P312>L21;  * = DF13-  ** = DF63-,  Equivalents: S145,M529,L459,Z245  R1b1a2a1a1b3
DF13+  >>> R1b-P312>L21>DF13;  * = L513- DF21- DF49- Z253- Z255- DF41- L1335-  ** = CTS4466- L371- L555- L96- L144-,  Equivalents: /S521  R1b1a2a1a1b3a
L513+  >>> R1b-P312>L21>DF13>L513;  * = L193- L706.2- L69-  ** = L192.1- L9- L10- L577- L908- L909- L1333-,  Equivalents: /DF1/S215,Z249,Z250  R1b1a2a1a1b3a2
L193+  >>> R1b-P312>L21>DF13>L513>L193+; Terminal,  Equivalents: /S176  R1b1a2a1a1b3a2b
L706.2+  >>> R1b-P312>L21>DF13>L513>L706.2;  * = L705.2-  ** = n/a  R1b1a2a1a1b3a2c
L705.2+  >>> R1b-P312>L21>DF13>L513>L706.2>L705.2+; Terminal  R1b1a2a1a1b3a2c1
L69.5+  >>> R1b-P312>L21>DF13>L513>L69.5;  * = P66-  ** = n/a 
P66+  >>> R1b-P312>L21>DF13>L513>L69.5>P66+; Terminal,  Equivalents: P66_1,P66_2,P66_3  R1b1a2a1a1b3a2a
DF21+  >>> R1b-P312>L21>DF13>DF21;  * = P314.2- Z246- L720-  ** = S424-,  Equivalents: /S192  R1b1a2a1a1b3a7
P314.2+  >>> R1b-P312>L21>DF13>DF21>P314.2;  * = L362-  ** = n/a,  Equivalents: /S220.2  R1b1a2a1a1b3a7a
L362+  >>> R1b-P312>L21>DF13>DF21>P314.2>L362+; Terminal  R1b1a2a1a1b3a7a1
Z246+  >>> R1b-P312>L21>DF13>DF21>Z246;  * = DF25-  ** = n/a,  Equivalents: /S280  R1b1a2a1a1b3a7b
DF25+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25;  * = DF5-  ** = n/a,  Equivalents: /S253  R1b1a2a1a1b3a7b1
DF5+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5;  * = L627- L658-  ** = n/a,  Equivalents: /S191  R1b1a2a1a1b3a7b1a
L627+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627;  * = L626-  ** = n/a  R1b1a2a1a1b3a7b1a1
L626+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626;  * = L625-  ** = n/a 
L625+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626>L625+; Terminal 
L658+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L658+; Terminal  R1b1a2a1a1b3a7b1a2
L720+  >>> R1b-P312>L21>DF13>DF21>L720+; Terminal,  Equivalents: /S299  R1b1a2a1a1b3a7c
S424+  >>> R1b-P312>L21>DF13>DF21>S424;  * = S190-  ** = n/a,  Equivalents: /S426  R1b1a2a1a1b3a7d
S190+  >>> R1b-P312>L21>DF13>DF21>S424>S190+; Terminal,  Equivalents: /S308,S309,S427  R1b1a2a1a1b3a7d1
DF49+  >>> R1b-P312>L21>DF13>DF49;  * = DF23-  ** = n/a,  Equivalents: /S523  R1b1a2a1a1b3a1
DF23+  >>> R1b-P312>L21>DF13>DF49>DF23;  * = M222-  ** = n/a  R1b1a2a1a1b3a1a
M222+  >>> R1b-P312>L21>DF13>DF49>DF23>M222; Terminal,  Equivalents: Page84,USP9Y+3636  R1b1a2a1a1b3a1a1
PF1169+  >>> R1b-P312>L21>DF13>DF49>DF23>M222>PF1169+; Terminal  T.Krahn: located in a highly repetitive region
Z253+  >>> R1b-P312>L21>DF13>Z253;  * = Z2534- L554-  ** = n/a,  Equivalents: /S218  R1b1a2a1a1b3a6
Z2534+  >>> R1b-P312>L21>DF13>Z253>Z2534;  * = L226- Z2185- L643-  ** = DF73-  R1b1a2a1a1b3a6b
L226+  >>> R1b-P312>L21>DF13>Z253>Z2534>L226+; Terminal,  Equivalents: /S168  R1b1a2a1a1b3a6b1
Z2185+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185;  * = L1066-  ** = n/a,  Equivalents: /CTS9975  R1b1a2a1a1b3a6b3
L1066+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066;  * = L895-  ** = n/a,  Equivalents: /CTS1202  R1b1a2a1a1b3a6b3a
L895+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066>L895+; Terminal,  Equivalents: L894 
L643+  >>> R1b-P312>L21>DF13>Z253>Z2534>L643+; Terminal  R1b1a2a1a1b3a6b2
DF73+  >>> R1b-P312>L21>DF13>Z253>Z2534>DF73+; Terminal 
L554+  >>> R1b-P312>L21>DF13>Z253>L554+; Terminal  R1b1a2a1a1b3a6a
Z255+  >>> R1b-P312>L21>DF13>Z255;  * = L159.2-  ** = n/a,  Equivalents: /S219  R1b1a2a1a1b3a5
L159.2+  >>> R1b-P312>L21>DF13>Z255>L159.2+; Terminal,  Equivalents: /S169.2  R1b1a2a1a1b3a5a
DF41+  >>> R1b-P312>L21>DF13>DF41;  * = L744-  ** = L563-,  Equivalents: /S534,CTS6581  R1b1a2a1a1b3a9
L744+  >>> R1b-P312>L21>DF13>DF41>L744;  * = L745-  ** = n/a,  Equivalents: /S388,L746,S310  R1b1a2a1a1b3a9a
L745+  >>> R1b-P312>L21>DF13>DF41>L744>L745+; Terminal,  Equivalents: /S463  R1b1a2a1a1b3a9a1
L563+  >>> R1b-P312>L21>DF13>DF41>L563+; Terminal  R1b1a2a1a1b3a9b
L1335+  >>> R1b-P312>L21>DF13>L1335;  * = L1065-  ** = L1334- 
L1065+  >>> R1b-P312>L21>DF13>L1335>L1065;  * = L743-  ** = n/a 
L743+  >>> R1b-P312>L21>DF13>L1335>L1065>L743+; Terminal 
CTS4466+  >>> R1b-P312>L21>DF13>CTS4466+; Terminal 
L371+  >>> R1b-P312>L21>DF13>L371+; Terminal,  Equivalents: /S300  R1b1a2a1a1b3a8
L555+  >>> R1b-P312>L21>DF13>L555+; Terminal,  Equivalents: /S393  R1b1a2a1a1b3a10
L96+  >>> R1b-P312>L21>DF13>L96+; Terminal  R1b1a2a1a1b3a3
L144.1+  >>> R1b-P312>L21>DF13>L144.1+; Terminal,  Equivalents: /S175  R1b1a2a1a1b3a4
DF63+  >>> R1b-P312>L21>DF63;  * = CTS6919-  ** = n/a,  Equivalents: /S522  R1b1a2a1a1b3b
CTS6919+  >>> R1b-P312>L21>DF63>CTS6919+; Terminal 
L459+ >>> Unpositioned under P312
Z245+ >>> Unpositioned under P312
Z260+ >>> Unpositioned under P312
Z290+ >>> Unpositioned under P312
Z2542+ >>> Unpositioned under P312
L69+ >>> Unpositioned under L21
L159.?+ >>> Unpositioned under L21
L144+ >>> Unpositioned under L21
L195+ >>> Unpositioned under L21
L319+ >>> Unpositioned under L21
L1312+ >>> Unpositioned under L21
L1314+ >>> Unpositioned under L21
L1315+ >>> Unpositioned under L21
CTS2457+ >>> Unpositioned under L21
zzM37+ >>> Unpositioned under L21
PF3434+ >>> Unpositioned under DF13
CTS11440+ >>> Unpositioned under DF13
CTS2501+ >>> Unpositioned under DF13
CTS1751+ >>> Unpositioned under DF13
CTS5714+ >>> Unpositioned under DF13
L130+ >>> Unpositioned under DF13
L152+ >>> Unpositioned under DF13
L526+ >>> Unpositioned under DF13
L557+ >>> Unpositioned under DF13
L561+ >>> Unpositioned under DF13
L564+ >>> Unpositioned under DF13
L580+ >>> Unpositioned under DF13
L583+ >>> Unpositioned under DF13
L679+ >>> Unpositioned under DF13
Z249+ >>> Unpositioned under DF13
Z251+ >>> Unpositioned under DF13
L192.1+ >>> Unpositioned under L513
L9+ >>> Unpositioned under L513
L10+ >>> Unpositioned under L513
L577+ >>> Unpositioned under L513
L908+ >>> Unpositioned under L513
L909+ >>> Unpositioned under L513
L1333+ >>> Unpositioned under L513
L642+ >>> Unpositioned under DF21
S424+ >>> Unpositioned under DF21
S426+ >>> Unpositioned under DF21
L1336+ >>> Unpositioned under DF21
L641+ >>> Unpositioned under DF21
L876+ >>> Unpositioned under DF21
Z248+ >>> Unpositioned under DF25
CTS3655+ >>> Unpositioned under DF5
L302+ >>> Unpositioned under DF49
Z2955+ >>> Unpositioned under DF23
Z2961+ >>> Unpositioned under DF23
Z2962+ >>> Unpositioned under DF23
Z2963+ >>> Unpositioned under DF23
Z2964+ >>> Unpositioned under DF23
Z2970+ >>> Unpositioned under DF23
Z2972+ >>> Unpositioned under DF23
Z2973+ >>> Unpositioned under DF23
Z2988+ >>> Unpositioned under DF23
PF1217+ >>> Unpositioned under M222
CTS8002+ >>> Unpositioned under M222
F3952+ >>> Unpositioned under M222
PF3292+ >>> Unpositioned under M222
PF825+ >>> Unpositioned under Z253
L894+ >>> Unpositioned under Z253
L1308+ >>> Unpositioned under Z253
F4036+ >>> Unpositioned under Z253
Z2182+ >>> Unpositioned under Z253
Z2184+ >>> Unpositioned under Z253
PF1557+ >>> Unpositioned under Z253
Z2183+ >>> Unpositioned under Z2185
L746+ >>> Unpositioned under DF41
L247+ >>> Unpositioned under DF41
L1334+ >>> Unpositioned under L1335
CTS6838+ >>> Unpositioned under L1335
CTS7030+ >>> Unpositioned under L1335
L459+ >>>  equivalent to L21
Z245+ >>>  equivalent to L21
Z260+ >>>  equivalent to L21
Z290+ >>>  equivalent to L21
DF1+ >>>  equivalent to L513
Z249+ >>>  equivalent to L513
L192+ >>>  equivalent to L192.1
L705+ >>>  equivalent to L705.2
L706+ >>>  equivalent to L706.2
P314+ >>>  equivalent to P314.2
CTS2646+ >>>  equivalent to Z2182
CTS9975+ >>>  equivalent to Z2185
CTS11722+ >>>  equivalent to L1065
CTS1202+ >>>  equivalent to L1066
CTS6581+ >>>  equivalent to DF41
Last edited by Mikewww on Thu Apr 04, 2013 8:33 pm, edited 2 times in total.

Posts: 24
Joined: Sat Nov 24, 2012 11:41 pm

YDNA:
L21+ Z253+ Z2185+
MtDNA:
J2b1a
PostPosted: Sun Feb 24, 2013 11:54 am
There's some unexpected results coming through in Geno 2.0.

First, there's a CTS1202+ (ie, L1066+) result for Wheaton 233653 in the Wheaton surname project. He is L2+ but L1066 is downstream from Z253; perhaps we now have L1066.2 ?

Also, there are 76 positive results for L552 in the L21 Project. In the Z253 Project there are nine L552+ results, including three in L1066+ persons, and there are another five Geno2.0 results in Z253+ persons which do not list an L552 result; two of these are also in L1066+ persons.

The FTDNA draft Y-tree has L552 as approximately equivalent to L2. In view of these results, I wonder if it might be further upstream to include L21, but I don't understand the negative results, unless there's a high proportion of no-calls for some reason.

GregH

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Fri Mar 15, 2013 7:26 pm
The updated the R1b-L21_Haplotypes spreadsheet can be found under the Links section of this yahoo group.

Here are the counts of haplotypes by confirmed SNP status.

4439 - L21
2500 - DF13 (the Big Kahuna) - many of the L21 above have not tested for DF13

12 - L21**
36 - DF13*, but only 4 are true DF13** and have tested CTS4466-
43 - DF63

The Big/Old Eight:
1052 - DF49, 998 of which are M222 (probably should call it the Behomoth)
278 - Z253
231 - L513
205 - DF21
172 - Z255
74 - L1335
69 - DF41
14 - CTS4466

Others reporting into DF13:
20 - L371
16 - L555
46 - L144.1

There are now 1632 111 STR haplotypes under the ExtHts tab.

DF21+ came up positive in a new variety, so I created a variety 21-1412.

I added quite a number of DF41 suspects. They are mostly of the 41-1426 variety.

Graphic of the SNP relationships as I understand them:
https://dl.dropbox.com/u/17907527/R1b-L21_Descendency_Tree.jpg

Mike W
Last edited by Mikewww on Thu Apr 04, 2013 8:33 pm, edited 1 time in total.

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Wed Mar 20, 2013 11:50 pm
I updated the spreadsheet again.

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Thu Apr 04, 2013 8:38 pm
Here's the latest I have for the R1b-L21 phylogenetic tree. ISOGG has changed its long haplogroups to reflect consolidation and positioning of L150.1 and L150.2.
https://dl.dropbox.com/u/17907527/R1b-L ... y_Tree.jpg

I'm trying to implement the graphic above in the R1b-L21_Haplotypes spreadsheet so that equivalent SNPs are translated to the correct haplogroup. Here is the actual table in the Clades tab/worksheet of the spreadsheet. This controls translations and haplogroup labeling. I use an expandable/contractible SNP based labeling system.

The DF13* status requires DF13+ L513- DF21- DF49- Z253- Z255- DF41- L1335- CTS4466-
Code: Select all
L21+  >>> R1b-P312>L21;  * = DF13-  ** = DF63-,  Equivalents: S145,M529,L459,Z245  R1b1a2a1a2c

DF13+  >>> R1b-P312>L21>DF13;  * = L513- DF21- DF49- Z253- Z255- DF41- L1335- CTS4466-  ** = L371- L555- L96- L144-,  Equivalents: /S521  R1b1a2a1a2c1

L513+  >>> R1b-P312>L21>DF13>L513;  * = L193- L706.2- L69-  ** = L192.1- L9- L10- L577- L908- L909- L1333-,  Equivalents: /DF1/S215,Z249,Z250  R1b1a2a1a2c1b
L193+  >>> R1b-P312>L21>DF13>L513>L193.1+; Terminal,  Equivalents: /S176  R1b1a2a1a2c1b2
L706.2+  >>> R1b-P312>L21>DF13>L513>L706.2;  * = L705.2-  ** = n/a  R1b1a2a1a2c1b3
L705.2+  >>> R1b-P312>L21>DF13>L513>L706.2>L705.2+; Terminal  R1b1a2a1a2c1b3a
L69.5+  >>> R1b-P312>L21>DF13>L513>L69.5;  * = P66-  ** = n/a 
P66+  >>> R1b-P312>L21>DF13>L513>L69.5>P66+; Terminal,  Equivalents: P66_1,P66_2,P66_3  R1b1a2a1a2c1b1

DF21+  >>> R1b-P312>L21>DF13>DF21;  * = P314.2- Z246- L720-  ** = S424-,  Equivalents: /S192  R1b1a2a1a2c1g
P314.2+  >>> R1b-P312>L21>DF13>DF21>P314.2;  * = L362-  ** = n/a,  Equivalents: /S220.2  R1b1a2a1a2c1g1
L362+  >>> R1b-P312>L21>DF13>DF21>P314.2>L362+; Terminal  R1b1a2a1a2c1g1a
Z246+  >>> R1b-P312>L21>DF13>DF21>Z246;  * = DF25-  ** = n/a,  Equivalents: /S280  R1b1a2a1a2c1g2
DF25+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25;  * = DF5-  ** = n/a,  Equivalents: /S253  R1b1a2a1a2c1g2a
DF5+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5;  * = L627- L658-  ** = n/a,  Equivalents: /S191  R1b1a2a1a2c1g2a1
L627+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627;  * = L626-  ** = n/a  R1b1a2a1a2c1g2a1a
L626+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626;  * = L625-  ** = n/a 
L625+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L627>L626>L625+; Terminal 
L658+  >>> R1b-P312>L21>DF13>DF21>Z246>DF25>DF5>L658+; Terminal  R1b1a2a1a2c1g2a1b
L720+  >>> R1b-P312>L21>DF13>DF21>L720+; Terminal,  Equivalents: /S299  R1b1a2a1a2c1g3
S424+  >>> R1b-P312>L21>DF13>DF21>S424;  * = S190-  ** = n/a,  Equivalents: S426  R1b1a2a1a2c1g4
S190+  >>> R1b-P312>L21>DF13>DF21>S424>S190+; Terminal,  Equivalents: S308,S309,S427  R1b1a2a1a2c1g4a

DF49+  >>> R1b-P312>L21>DF13>DF49;  * = DF23-  ** = n/a,  Equivalents: /S474  R1b1a2a1a2c1a
DF23+  >>> R1b-P312>L21>DF13>DF49>DF23;  * = Z2961-  ** = n/a  R1b1a2a1a2c1a1
Z2961+  >>> R1b-P312>L21>DF13>DF49>DF23>Z2961;  * = M222-  ** = n/a 
M222+  >>> R1b-P312>L21>DF13>DF49>DF23>Z2961>M222;  * = n/a  ** = n/a,  Equivalents: /Page84/USP9Y+3636  R1b1a2a1a2c1a1a
PF1169+  >>> R1b-P312>L21>DF13>DF49>DF23>Z2961>M222>PF1169+; Terminal

Z253+  >>> R1b-P312>L21>DF13>Z253;  * = Z2534- L554-  ** = F4036-,  Equivalents: /S218  R1b1a2a1a2c1f
Z2534+  >>> R1b-P312>L21>DF13>Z253>Z2534;  * = L226- Z2185- L643-  ** = DF73-  R1b1a2a1a2c1f2
L226+  >>> R1b-P312>L21>DF13>Z253>Z2534>L226+; Terminal,  Equivalents: /S168  R1b1a2a1a2c1f2a
Z2185+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185;  * = L1066-  ** = n/a,  Equivalents: /CTS9975  R1b1a2a1a2c1f2c
L1066+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066.1;  * = L895-  ** = n/a,  Equivalents: /CTS1202  R1b1a2a1a2c1f2c1
L895+  >>> R1b-P312>L21>DF13>Z253>Z2534>Z2185>L1066.1>L895+; Terminal,  Equivalents: L894 
L643+  >>> R1b-P312>L21>DF13>Z253>Z2534>L643+; Terminal  R1b1a2a1a2c1f2b
DF73+  >>> R1b-P312>L21>DF13>Z253>Z2534>DF73+; Terminal 
L554+  >>> R1b-P312>L21>DF13>Z253>L554+; Terminal  R1b1a2a1a2c1f1
F4036+  >>> R1b-P312>L21>DF13>Z253>F4036+; Terminal,  Equivalents: /F4036.2 

Z255+  >>> R1b-P312>L21>DF13>Z255;  * = L159.2-  ** = n/a,  Equivalents: /S219  R1b1a2a1a2c1e
L159.2+  >>> R1b-P312>L21>DF13>Z255>L159.2+; Terminal,  Equivalents: /S169.2  R1b1a2a1a2c1e1

DF41+  >>> R1b-P312>L21>DF13>DF41;  * = L744-  ** = L563-,  Equivalents: /S534,CTS6581  R1b1a2a1a2c1i
L744+  >>> R1b-P312>L21>DF13>DF41>L744;  * = L745-  ** = n/a,  Equivalents: /S388,L746,S310  R1b1a2a1a2c1i1
L745+  >>> R1b-P312>L21>DF13>DF41>L744>L745+; Terminal,  Equivalents: /S463  R1b1a2a1a2c1i1a
L563+  >>> R1b-P312>L21>DF13>DF41>L563+; Terminal  R1b1a2a1a2c1i2
L1335+  >>> R1b-P312>L21>DF13>L1335;  * = L1065-  ** = L1334-  R1b1a2a1a2c1k
L1065+  >>> R1b-P312>L21>DF13>L1335>L1065;  * = L743-  ** = n/a,  Equivalents: /CTS1172  R1b1a2a1a2c1k1
L743+  >>> R1b-P312>L21>DF13>L1335>L1065>L743+; Terminal 

CTS4466+  >>> R1b-P312>L21>DF13>CTS4466+; Terminal 

L371+  >>> R1b-P312>L21>DF13>L371+; Terminal,  Equivalents: /S300  R1b1a2a1a2c1h

L555+  >>> R1b-P312>L21>DF13>L555+; Terminal,  Equivalents: /S393  R1b1a2a1a2c1j

L96+  >>> R1b-P312>L21>DF13>L96+; Terminal  R1b1a2a1a2c1c

L144.1+  >>> R1b-P312>L21>DF13>L144.1+; Terminal,  Equivalents: /S175  R1b1a2a1a2c1d

DF63+  >>> R1b-P312>L21>DF63;  * = CTS6919-  ** = F3901-,  Equivalents: /S522  R1b1a2a1a2c2
CTS6919+  >>> R1b-P312>L21>DF63>CTS6919+; Terminal  R1b1a2a1a2c2a
F3901+  >>> R1b-P312>L21>DF63>F3901.2+; Terminal 

L459+ >>> Unpositioned under P312
Z245+ >>> Unpositioned under P312
Z260+ >>> Unpositioned under P312
Z290+ >>> Unpositioned under P312
Z2542+ >>> Unpositioned under P312
L69+ >>> Unpositioned under L21
L159.?+ >>> Unpositioned under L21
L144+ >>> Unpositioned under L21
L195+ >>> Unpositioned under L21
L319+ >>> Unpositioned under L21
L1314+ >>> Unpositioned under L21
L1315+ >>> Unpositioned under L21
L1406+ >>> Unpositioned under L21
CTS2457+ >>> Unpositioned under L21
PF3434+ >>> Unpositioned under DF13
CTS11440+ >>> Unpositioned under DF13
CTS1751+ >>> Unpositioned under DF13
CTS5714+ >>> Unpositioned under DF13
CTS3974+ >>> Unpositioned under DF13
CTS8358+ >>> Unpositioned under DF13
L130+ >>> Unpositioned under DF13
L152+ >>> Unpositioned under DF13
L526+ >>> Unpositioned under DF13
L557+ >>> Unpositioned under DF13
L561+ >>> Unpositioned under DF13
L564+ >>> Unpositioned under DF13
L580+ >>> Unpositioned under DF13
L583+ >>> Unpositioned under DF13
L679+ >>> Unpositioned under DF13
Z249+ >>> Unpositioned under DF13
Z251+ >>> Unpositioned under DF13
L192.1+ >>> Unpositioned under L513
L9+ >>> Unpositioned under L513
L10+ >>> Unpositioned under L513
L577+ >>> Unpositioned under L513
L908+ >>> Unpositioned under L513
L909+ >>> Unpositioned under L513
L1333+ >>> Unpositioned under L513
L641+ >>> Unpositioned under DF21
L642+ >>> Unpositioned under DF21
L876+ >>> Unpositioned under DF21
L1336+ >>> Unpositioned under DF21
Z248+ >>> Unpositioned under DF25
CTS3655+ >>> Unpositioned under DF5
L302+ >>> Unpositioned under DF49
Z2955+ >>> Unpositioned under DF23
Z2962+ >>> Unpositioned under DF23
Z2963+ >>> Unpositioned under DF23
Z2964+ >>> Unpositioned under DF23
Z2970+ >>> Unpositioned under DF23
Z2972+ >>> Unpositioned under DF23
Z2973+ >>> Unpositioned under DF23
Z2988+ >>> Unpositioned under DF23
PF1217+ >>> Unpositioned under M222
CTS8002+ >>> Unpositioned under M222
F3952+ >>> Unpositioned under M222
PF3292+ >>> Unpositioned under M222
PF825+ >>> Unpositioned under Z253
L894+ >>> Unpositioned under Z253
L1308+ >>> Unpositioned under Z253
Z2182+ >>> Unpositioned under Z253
Z2184+ >>> Unpositioned under Z253
PF1557+ >>> Unpositioned under Z253
Z2183+ >>> Unpositioned under Z2185
L746+ >>> Unpositioned under DF41
L247+ >>> Unpositioned under DF41
L1334+ >>> Unpositioned under L1335
CTS6838+ >>> Unpositioned under L1335
CTS7030+ >>> Unpositioned under L1335
L1312+ >>> Unpositioned under CTS4466

L459+ >>>  equivalent to L21
Z245+ >>>  equivalent to L21
Z260+ >>>  equivalent to L21
Z290+ >>>  equivalent to L21
DF1+ >>>  equivalent to L513
Z249+ >>>  equivalent to L513
L192+ >>>  equivalent to L192.1
L705+ >>>  equivalent to L705.2
L706+ >>>  equivalent to L706.2
P314+ >>>  equivalent to P314.2
L1337+ >>>  equivalent to L1336
CTS2646+ >>>  equivalent to Z2182
CTS9975+ >>>  equivalent to Z2185
CTS11722+ >>>  equivalent to L1065
CTS1202+ >>>  equivalent to L1066
CTS2501+ >>>  equivalent to DF41


CTS4466 as clearly established itself as a major subclade of DF13. The next possibility of a big one under DF13 is probably Z251, at least that is citizen-scientist Andy Grierson's perspective.
Last edited by Mikewww on Fri Apr 12, 2013 8:55 pm, edited 1 time in total.

Posts: 953
Joined: Wed Mar 14, 2012 3:37 pm

YDNA:
R1b-L21>L705.2
PostPosted: Fri Apr 05, 2013 9:11 pm
I've restructured some of the columns on the spreadsheet in this latest update, which can be found at http://tech.groups.yahoo.com/group/R1b-L21-Project/links

I realized that my "Downstream SNPs / Relevant SNPs" column wasn't in a useful location and may be too often have been overlooked, but it is important for its inclusion of unpositioned and negative SNPs.

I moved the the "Speculative Variety" and "Old World Country columns one to the right and moved the "Relevant SNPs" column right next to the "Hg" (Haplogroup label) column.

I moved the "Region" coded column all the way over to where the "Relevant SNPs" column was. This way I didn't disturb any of the STR or off-modal columns and touch any of the genetic distance calculations. Since I used modified infinite allele methods on muli-copy STRs those formulas get pretty complex... plus I have a "indirect" referencing system so you can select any haplotype in the spreadsheet to be the "GD Target" for GD calculations for every other haplotype. Anyway, I hate to disturb the STR column sequences and use the old FTDNA format where every multi-copy marker is broken into individual columns.

By "Relevant SNPs", I mean the youngest level of SNP tested positive for plus any negative SNP results immediately (and only immediately) downstream of it. I make one exception. For people in any "49-" Variety I show M222- results even if DF23 has not been tested for yet.

It is this "Relevant SNPs" column were I get the information to decide whether someone is asterisk or double asterisk.

The Clades SNP table/index in the post immediately below describes how I handle SNPs to create haplogroup labels and the "Relevant SNPs" column. An attempted graphical representation of the Clades SNP index is this descendancy tree which also in the post below. https://dl.dropbox.com/u/17907527/R1b-L21_Descendency_Tree.jpg

I use the ISOGG Y DNA tree and David Reynold's WTY/Geno2 Summaries as input to build the Clades SNP Index and associated Descendency Tree. I usually lag behind David's work.
http://isogg.org/tree/ISOGG_HapgrpR.html
http://daver.info/geno/results/R-L21.pdf
http://daver.info/geno/results/R-L513.pdf
http://daver.info/geno/results/R-DF21.pdf
http://daver.info/geno/results/R-DF49.pdf
http://daver.info/geno/results/R-L1335.pdf
http://daver.info/geno/results/R-Z253.pdf

I collect Y DNA SNP reports from the FTDNA R-L21 project screens at least once a week and copy them into my internal version of the spreadsheet. I also manually (ugh!) update WTY and Geno2 relevant negative and unpositioned SNP results into my spreadsheet.

My internal spreadsheet has a series of columns to create the "Relevant SNPs" for each SNP/haplotype row copied from the Y DNA SNP project screen. One set of columns runs through all of the raw (and manual) SNP data looking for unpositioned SNPs and SNPs that are phylogenetically equivalent to positioned "lead" haplogroup defining SNPs. For example I check for Z245, Z290 and L459 and automatically add a presumed L21+ to the eligible "Relevant SNPs" if one of those equivalents is positive even if L21, the "lead" SNP, is never tested.

A second set of columns checks the raw SNP data and then phylogenetically computed lead equivalents from youngest to oldest SNP to identify the youngest positive positioned SNP for each haplotype. I often call it the haplogroup defining SNP although you could also call it the current terminal SNP. This "lead" terminal SNP becomes the first SNP result in the "Relevant SNPs" column.

A third set of columns checks the SNP raw data for the next level (only) of SNPs younger than the terminal SNP looking for negatives as well as for all results of any unpositioned SNP that falls under the "umbrella" of the "lead" positive SNP. The negatives have to show up in the right order so I can check for exact string matches to add asterisks and double asterisks.

Well, that's probably more than you wanted to know, but I just want to explain that it is important for me to get the Clades tab/worksheet SNP Index correct so the "Relevant SNPs" string I build that is then used to generate a "Hg" haplogroup label is also correct. In the SNP Index every eligible SNP is numbered by layer/level of the tree and top down (oldest first such that M343 is #1) sequence as well. This is probably not much different than what family tree charting programs do where they draw a tree from a database.
Last edited by Mikewww on Wed Apr 10, 2013 12:23 am, edited 1 time in total.
PreviousNext

Return to R1b-L21/S145

Who is online

Users browsing this forum: No registered users and 2 guests