I notice a new BigY match today with Mike Hartley. I'm not as good as Jared
as figuring out what the matches mean. For example, there are 5 SNPs which
Charles Thomas and I have that others don't have. I don't see any SNPs I
share with Mike Hartley that I don't share with others.

Joel

Hi Jared and everyone,

I have a new 34/37 match. Surname is Dean who may be related to my previous
match of that name. I invited him to check out the L513 project.

Charles Thomas

Thanks, Jared,

That should be a great resource. I'll send some of my SNPs your way once I
sort them out. YFull has them as:

Best Quality (5)
Acceptable (6)
Ambiguous (20)

I'm guessing you just want the 1st 2 categories?

Joel



On 2/20/2017 6:44 PM, Jared Smith wrote:

I have uploaded a new spreadsheet to


This likely has limited utility for anyone other than me, but I
thought I'd share it. This file is used for analyzing Y-DNA mutation
variants (SNPs, insertions/deletions, etc.) that us Z16357 people
have. It's a very large spreadsheet with complex calculations - minor
changes like sorting can take a long time to calculate.

The Variants tab includes all 68,355 unique variants that we have.
These were collected from Big-Y VCF files.

You can use the Lookup tab to query specific DNA position numbers to
see the values each of us have at that position.

The Shared Variants tab shows all known variants ***AT OR BELOW
Z16357*** that at least 2 of us have. This allows easy analysis of the
consistency of SNPs and determination of their position on our
branches. A "+" indicates a positive test for that variant. A "***"
indicates the variant was identified, but the test quality is
questionable. A blank box indicates EITHER a negative result OR no
test coverage (be careful - you can't assume too much from a blank box
without analyzing the BED file for read coverage).

The Unique Variants tab lists most of the variants that are unique to
only one of us. I'd be happy to add any new ones from YFull, if any of
you who have tested there would like to e-mail them to me. Note that
some Insertions/Deletions (these are kinda like hiccups in your DNA)
show "Count" as 0 because Big Tree calculates the position info for
INDELs a bit differently than the VCF file. These are retained for
reference.

The primary function of this spreadsheet is to easily add VCF data to
Variants for new Big-Y testers, then immediately determine which
existing SNPs from our branch they have, and which Unique Variants are
then no longer unique and need to be moved to Shared Variants.

Jared

I have uploaded a new spreadsheet to


This likely has limited utility for anyone other than me, but I
thought I'd share it. This file is used for analyzing Y-DNA mutation
variants (SNPs, insertions/deletions, etc.) that us Z16357 people
have. It's a very large spreadsheet with complex calculations - minor
changes like sorting can take a long time to calculate.

The Variants tab includes all 68,355 unique variants that we have.
These were collected from Big-Y VCF files.

You can use the Lookup tab to query specific DNA position numbers to
see the values each of us have at that position.

The Shared Variants tab shows all known variants ***AT OR BELOW
Z16357*** that at least 2 of us have. This allows easy analysis of the
consistency of SNPs and determination of their position on our
branches. A "+" indicates a positive test for that variant. A "***"
indicates the variant was identified, but the test quality is
questionable. A blank box indicates EITHER a negative result OR no
test coverage (be careful - you can't assume too much from a blank box
without analyzing the BED file for read coverage).

The Unique Variants tab lists most of the variants that are unique to
only one of us. I'd be happy to add any new ones from YFull, if any of
you who have tested there would like to e-mail them to me. Note that
some Insertions/Deletions (these are kinda like hiccups in your DNA)
show "Count" as 0 because Big Tree calculates the position info for
INDELs a bit differently than the VCF file. These are retained for
reference.

The primary function of this spreadsheet is to easily add VCF data to
Variants for new Big-Y testers, then immediately determine which
existing SNPs from our branch they have, and which Unique Variants are
then no longer unique and need to be moved to Shared Variants.

Jared

I have uploaded a new spreadsheet to


This likely has limited utility for anyone other than me, but I
thought I'd share it. This file is used for analyzing Y-DNA mutation
variants (SNPs, insertions/deletions, etc.) that us Z16357 people
have. It's a very large spreadsheet with complex calculations - minor
changes like sorting can take a long time to calculate.

The Variants tab includes all 68,355 unique variants that we have.
These were collected from Big-Y VCF files.

You can use the Lookup tab to query specific DNA position numbers to
see the values each of us have at that position.

The Shared Variants tab shows all known variants ***AT OR BELOW
Z16357*** that at least 2 of us have. This allows easy analysis of the
consistency of SNPs and determination of their position on our
branches. A "+" indicates a positive test for that variant. A "***"
indicates the variant was identified, but the test quality is
questionable. A blank box indicates EITHER a negative result OR no
test coverage (be careful - you can't assume too much from a blank box
without analyzing the BED file for read coverage).

The Unique Variants tab lists most of the variants that are unique to
only one of us. I'd be happy to add any new ones from YFull, if any of
you who have tested there would like to e-mail them to me. Note that
some Insertions/Deletions (these are kinda like hiccups in your DNA)
show "Count" as 0 because Big Tree calculates the position info for
INDELs a bit differently than the VCF file. These are retained for
reference.

The primary function of this spreadsheet is to easily add VCF data to
Variants for new Big-Y testers, then immediately determine which
existing SNPs from our branch they have, and which Unique Variants are
then no longer unique and need to be moved to Shared Variants.

Jared

Thanks Jared,

I was wondering what happened to that test. Also I'm wondering why I can't
see Phillips on my match list? Hopefully, it should show up soon.

Joel


On 2/18/2017 2:45 PM, Jared Smith wrote:

The Big-Y results for Brent Phillips are in. He is confirmed R-Y29969
with Bennett and Thomas. This is phylogenetically equivalent to
BY11573. You'll notice FTDNA has changed the terminal SNP for Bennett
and Thomas to Y29969 - it's a more reliable SNP to check.

Beyond this, there's also a new tentative Bennett/Phillips branch.
They both share the following markers (and perhaps some others that
are yet to be discovered):
7488239-G-A
22486193-A-T
25311291-T-C

These are in rather poor read areas for the Y-DNA test, but I believe
at least the first one should hold up under further analysis to create
this new branch.

I had thought that Bennett and Phillips would share more good SNPs
(i.e., they had a more recent common ancestor), but this proves that
their lines split after Y29969. But both of them have around 10 good
unique SNPs that would provide distinct Bennett and Phillips branches
with additional cousin testers.

Another good discover with the Phillips and my Smith Big-Y is
validation of 5 or 6 other SNP markers that those of us on the Z17911
block share. This means that Z17911 is a bigger/longer block than we
had previously thought, thus moving our more recent ancestor in that
block closer to modern day.

My own VERY rough estimate based on what we know now is that our most
recent Z17911 lived probably around 1200 years ago, with the
Bennett/Phillips/Thomas/Merrick/Goff Y29969/BY11573 ancestor living
around 800 years ago.

Brent's results add some very useful information to our project!

Jared

The Big-Y results for Brent Phillips are in. He is confirmed R-Y29969
with Bennett and Thomas. This is phylogenetically equivalent to
BY11573. You'll notice FTDNA has changed the terminal SNP for Bennett
and Thomas to Y29969 - it's a more reliable SNP to check.

Beyond this, there's also a new tentative Bennett/Phillips branch.
They both share the following markers (and perhaps some others that
are yet to be discovered):
7488239-G-A
22486193-A-T
25311291-T-C

These are in rather poor read areas for the Y-DNA test, but I believe
at least the first one should hold up under further analysis to create
this new branch.

I had thought that Bennett and Phillips would share more good SNPs
(i.e., they had a more recent common ancestor), but this proves that
their lines split after Y29969. But both of them have around 10 good
unique SNPs that would provide distinct Bennett and Phillips branches
with additional cousin testers.

Another good discover with the Phillips and my Smith Big-Y is
validation of 5 or 6 other SNP markers that those of us on the Z17911
block share. This means that Z17911 is a bigger/longer block than we
had previously thought, thus moving our more recent ancestor in that
block closer to modern day.

My own VERY rough estimate based on what we know now is that our most
recent Z17911 lived probably around 1200 years ago, with the
Bennett/Phillips/Thomas/Merrick/Goff Y29969/BY11573 ancestor living
around 800 years ago.

Brent's results add some very useful information to our project!

Jared

The Big-Y results for Brent Phillips are in. He is confirmed R-Y29969
with Bennett and Thomas. This is phylogenetically equivalent to
BY11573. You'll notice FTDNA has changed the terminal SNP for Bennett
and Thomas to Y29969 - it's a more reliable SNP to check.

Beyond this, there's also a new tentative Bennett/Phillips branch.
They both share the following markers (and perhaps some others that
are yet to be discovered):
7488239-G-A
22486193-A-T
25311291-T-C

These are in rather poor read areas for the Y-DNA test, but I believe
at least the first one should hold up under further analysis to create
this new branch.

I had thought that Bennett and Phillips would share more good SNPs
(i.e., they had a more recent common ancestor), but this proves that
their lines split after Y29969. But both of them have around 10 good
unique SNPs that would provide distinct Bennett and Phillips branches
with additional cousin testers.

Another good discover with the Phillips and my Smith Big-Y is
validation of 5 or 6 other SNP markers that those of us on the Z17911
block share. This means that Z17911 is a bigger/longer block than we
had previously thought, thus moving our more recent ancestor in that
block closer to modern day.

My own VERY rough estimate based on what we know now is that our most
recent Z17911 lived probably around 1200 years ago, with the
Bennett/Phillips/Thomas/Merrick/Goff Y29969/BY11573 ancestor living
around 800 years ago.

Brent's results add some very useful information to our project!

Jared