¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

Re: Data Warehouse upload

 

It may have gotten uploaded twice or they may have had a glitch on their end. But ultimately they check for duplicates and only use one.

On Mon, Dec 9, 2019 at 4:17 PM Wiredmarys <wiredmarys@...> wrote:
Thanks Chris.
I just did get 2 emails in fact from them. Says the same thing so I don't know why I got two but... I'm glad you see it.? Thanks for the reply :D
Mary
?
?
----- Original Message -----
From: Chris Noble <avalea3@...>
Reply-To: <[email protected]>
Sent: 12/9/2019 5:08:11 PM
Subject: Re: [R1b-S6881] Data Warehouse upload

You should get an email from them when it is picked up. But I see that it is there. Thanks!

image.png


On Mon, Dec 9, 2019 at 4:01 PM Wiredmarys <wiredmarys@...> wrote:
Hi Chris,
I think I got this right. I just uploaded Keith's BigY700 from Dropbox.? How do I check to be sure it went there, or is there a way?? Thanks Mary


Re: Data Warehouse upload

 

¿ªÔÆÌåÓý

Thanks Chris.
I just did get 2 emails in fact from them. Says the same thing so I don't know why I got two but... I'm glad you see it.? Thanks for the reply :D
Mary
?
?

----- Original Message -----
From: Chris Noble <avalea3@...>
Reply-To: <[email protected]>
Sent: 12/9/2019 5:08:11 PM
Subject: Re: [R1b-S6881] Data Warehouse upload

You should get an email from them when it is picked up. But I see that it is there. Thanks!

image.png


On Mon, Dec 9, 2019 at 4:01 PM Wiredmarys <wiredmarys@...> wrote:
Hi Chris,
I think I got this right. I just uploaded Keith's BigY700 from Dropbox.? How do I check to be sure it went there, or is there a way?? Thanks Mary


Re: Data Warehouse upload

 

You should get an email from them when it is picked up. But I see that it is there. Thanks!

image.png


On Mon, Dec 9, 2019 at 4:01 PM Wiredmarys <wiredmarys@...> wrote:
Hi Chris,
I think I got this right. I just uploaded Keith's BigY700 from Dropbox.? How do I check to be sure it went there, or is there a way?? Thanks Mary


Re: Data Warehouse upload

 

Hi Chris,
I think I got this right. I just uploaded Keith's BigY700 from Dropbox.? How do I check to be sure it went there, or is there a way?? Thanks Mary


Re: Data Warehouse upload

 

When you get to the part of the form where you upload your data go to your FTDNA account and then go down the screen to the Big Y section and click on "Results". When the next screen opens look on the far right and you'll see a "Download VCF" button.
image.png

Click on that button and a screen will open. Click on the green "Download VCF" button and pick Save File (don't open it). It will save to your computer and you can upload it to the Data Warehouse by clicking the "Direct" tab under "Raw Data Upload". Don't open the file as you need to upload it as the zip file you saved. Let me know if you have any problems. Thanks.

Chris


On Mon, Dec 9, 2019 at 10:29 AM Cynthia Sexton <cynthia8910@...> wrote:
I filled out the form... then met my challenge of the download.

Might this be a link ??? If not then I¡¯ll need your help

416674_SNPs_20191209.csv

I hate being so lame with this...?

On Dec 9, 2019, at 1:14 PM, Chris Noble <avalea3@...> wrote:

?
If you have problems I can do it for you with access to your account. But it isn't really hard except that FTDNA is no longer giving a link to share the data as they used to and you have to actually save the zipped file on your computer and then upload that file which the warehouse doesn't like as well as a link. If you are computer proficient and use something like dropbox you can share the link from there to the warehouse but I'm going to assume most of our members aren't doing things that way. Thanks.

Chris

On Mon, Dec 9, 2019 at 9:56 AM Cynthia Sexton <cynthia8910@...> wrote:
Gosh I still haven¡¯t done that for Grady or Roy.?

I¡¯ll try tonight. Wish me luck!

On Dec 9, 2019, at 12:50 PM, Chris Noble <avalea3@...> wrote:

?Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Data Warehouse upload

 

Thanks, Michael! Both your Y500 and Y700 results are in the Big Tree.

So for everyone else, if you upload your data to the Data Warehouse you get added to the Big Tree that Alex Williamson runs. It is super helpful for someone like me who tries to keep track of the whole group but can only see the people that my kit matches to. Once the Y700 data started coming out there were more SNPs identified and it is causing there to be more than 30 SNP differences between kits that previously matched before. I lost sight of about half of our members so I've been using the Big Tree to try to keep track. But not everyone uploads their data so that isn't a foolproof solution.

For anyone that wants to see how the U106 tree looks based on the data of the people who have uploaded you can find it here:


If you've uploaded your data you should be able to find yourself.

Thanks to all of you for your willingness to share your data so we can grow the tree.

Chris

On Mon, Dec 9, 2019 at 9:58 AM Michael Brooks via Groups.Io <michaelbrooks=[email protected]> wrote:

Hi Chris,

?

Michael Dyer Brooks, FTDNA Kit 100257, VCF zip file has been uploaded to ydna warehouse.

?

I don¡¯t read all of the emails going on here but felt it important that I provide my info.

?

Thank you for all of your efforts!

?

Michael Brooks

Descended from Henry Brooks of Concord & Woburn 1592-1683

?

From: [email protected] <[email protected]> On Behalf Of Chris Noble via Groups.Io
Sent: Monday, December 9, 2019 9:50 AM
To: [email protected]
Subject: [R1b-S6881] Data Warehouse upload

?

Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Data Warehouse upload

 

¿ªÔÆÌåÓý

I filled out the form... then met my challenge of the download.

Might this be a link ??? If not then I¡¯ll need your help

416674_SNPs_20191209.csv

I hate being so lame with this...?

On Dec 9, 2019, at 1:14 PM, Chris Noble <avalea3@...> wrote:

?
If you have problems I can do it for you with access to your account. But it isn't really hard except that FTDNA is no longer giving a link to share the data as they used to and you have to actually save the zipped file on your computer and then upload that file which the warehouse doesn't like as well as a link. If you are computer proficient and use something like dropbox you can share the link from there to the warehouse but I'm going to assume most of our members aren't doing things that way. Thanks.

Chris

On Mon, Dec 9, 2019 at 9:56 AM Cynthia Sexton <cynthia8910@...> wrote:
Gosh I still haven¡¯t done that for Grady or Roy.?

I¡¯ll try tonight. Wish me luck!

On Dec 9, 2019, at 12:50 PM, Chris Noble <avalea3@...> wrote:

?Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Data Warehouse upload

 

If you have problems I can do it for you with access to your account. But it isn't really hard except that FTDNA is no longer giving a link to share the data as they used to and you have to actually save the zipped file on your computer and then upload that file which the warehouse doesn't like as well as a link. If you are computer proficient and use something like dropbox you can share the link from there to the warehouse but I'm going to assume most of our members aren't doing things that way. Thanks.

Chris


On Mon, Dec 9, 2019 at 9:56 AM Cynthia Sexton <cynthia8910@...> wrote:
Gosh I still haven¡¯t done that for Grady or Roy.?

I¡¯ll try tonight. Wish me luck!

On Dec 9, 2019, at 12:50 PM, Chris Noble <avalea3@...> wrote:

?Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Data Warehouse upload

 

¿ªÔÆÌåÓý

Hi Chris,

?

Michael Dyer Brooks, FTDNA Kit 100257, VCF zip file has been uploaded to ydna warehouse.

?

I don¡¯t read all of the emails going on here but felt it important that I provide my info.

?

Thank you for all of your efforts!

?

Michael Brooks

Descended from Henry Brooks of Concord & Woburn 1592-1683

?

From: [email protected] <[email protected]> On Behalf Of Chris Noble via Groups.Io
Sent: Monday, December 9, 2019 9:50 AM
To: [email protected]
Subject: [R1b-S6881] Data Warehouse upload

?

Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Data Warehouse upload

 

¿ªÔÆÌåÓý

Gosh I still haven¡¯t done that for Grady or Roy.?

I¡¯ll try tonight. Wish me luck!

On Dec 9, 2019, at 12:50 PM, Chris Noble <avalea3@...> wrote:

?Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Data Warehouse upload

 

Please remember as you get your Y700 results to upload your data to the Data Warehouse if you wish to share your results with the U106 admins and some others. If you never uploaded your Y500 data you can do that too. The instructions from the U106 project are below. If you have any issues or questions let me know. Thanks.

Scroll down on your FTDNA page to Big Y Results. Click on that, then look to the far right, and click on the blue Download Raw Data button. Then, in the pop-up window, towards the left, click on the green Download VCF button. Then upload the zipped file, as it is, to the ¡°Y-DNA Data Warehouse¡±:
Joining this effort will help us research your particular clade, identifying new relationships closer to the present day. We work with other haplogroup projects, Family Tree DNA and external organizations to make your new clades known worldwide. Over 1000 of you have already participated.


Re: Probable new member

 

For Keith and John the MRCA is Josiah Graves b. 1778.
6 generations for Keith and 5 for John Joseph.? Keith descends from Josiah's son James Alexander born 1807
and John descends from Josiah's son William Lewis born 1811.
I'm curious too about the dating and if it will change.


Re: Probable new member

 

Oh? thank you so much for this note and setting me straight on the GD meaning.? That helps me understand that particular column a lot!!? Don't know where I got to thinking it meant generations, but I know I've thought that from the start. duh? Thanks so much :D


Re: Probable new member

 

¿ªÔÆÌåÓý

Oops ! Note to Cynthia¡ªread the most recent entry first.?

On Dec 8, 2019, at 10:48 AM, Chris Noble <avalea3@...> wrote:

?
Okay, I have one caveat to issue before answering. SNPs appear totally randomly. You could have one SNP appear in one generation and then not get another one in your line for hundreds of years. Other people could have them more often. Sometimes one generation could have two or more SNPs appear so it is hard to guess these things. But they do have an average calculated for all the people taking the Y700 test. Be aware your sample size is small (just the three of you). But based on the average of about 83 years per SNP I would say anywhere from around 1-3 generations separate your MCRA from Keith and John's. Iain had the block last dated to about 1814 AD but I don't know what he'd date it now that it is broken and there is one more of you in the data. Take any dates with a grain of salt but see how well they might fit with any known paper genealogy you have for the three of you.

Chris

On Sun, Dec 8, 2019 at 5:47 AM rwdrive <rwdrive@...> wrote:
Hello Chris,
For me, that explanation was amazing.? It really makes and i have much better understanding.
I do have one question, with that data, what is your best guess on how many generations are there between Keith and Johns MCRA and the MCRA for the 3 of us?
Thank you!?
Jeff

On Sat, Dec 7, 2019, 11:38 PM Chris Noble <avalea3@...> wrote:
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

<image.png>



On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

Your answer will be pretty much the same as the one I gave to Jeff. Three columns below starting at the old SNP S6881 going to the youngest last shared SNPs. The columns go in the order of William, Grady, Roy. You can see lots of blocks of SNPs in the columns below (sharing the same colors). We still need lots of testers to break up these blocks. The three of you last share an ancestor at the BY11971 block. Then William and Grady broke off from the rest of the group of Roy, Garrison, and Lathrem. Again, probably 1-3 generations separate the last shared ancestor of William and Grady and the last ancestor of the group they split from. Iain last aged the BY11971 block at 1528 AD so at least another 83 years or so, on average, to the ancestor of William and Grady. And Iain might feel differently about the ages now with more data. His data is kind of old now. Though I notice that YFull dates it even further back in time. You might want to look there though they have so little of the U106, and specifically, S6881 data that I think their dates are off.


S6881 S6881 S6881
S6886 S6886 S6886
FGC50431 FGC50431 FGC50431
FGC42045 FGC42045 FGC42045
FGC42046 FGC42046 FGC42046
FGC50423 FGC50423 FGC50423
FGC50429 FGC50429 FGC50429
FT5123 FT5123 FT5123
FT5124 FT5124 FT5124
FT7701 FT7701 FT7701
ACT739 ACT739 ACT739
BY11970/FGC42048 BY11970/FGC42048 BY11970/FGC42048
A11377 A11377 A11377
A11379 A11379 A11379
BY11973/FGC51240 BY11973/FGC51240 BY11973/FGC51240
A8050 A8050 A8050
FT15940 FT15940 FT15940
FT16384 FT16384 FT16384
FT16965 FT16965 FT16965
BY11974/FGC51242 BY11974/FGC51242 BY11974/FGC51242
BY11971/FGC51238 BY11971/FGC51238 BY11971/FGC51238
BY11972/A11375/FGC51239 BY11972/A11375/FGC51239 BY11972/A11375/FGC51239
BY11975/FGC51243 BY11975/FGC51243 BY11975/FGC51243
BY11976/FGC51244 (i) BY11976/FGC51244 (i) BY11976/FGC51244 (i)
FGC82851 FGC82851 FGC82851
FT90790 FT90790 FT90790
FT90791 FT90791 FT90791
Y63413 Y63413

On Sun, Dec 8, 2019 at 8:07 AM Cynthia Sexton <cynthia8910@...> wrote:
Chis,?

If you have an answer to Jeff¡¯s question even just a hint I¡¯d love to know that about Roy, Grady and Wm.?

I know how busy you are and you are seeing how enthusiastic we are BUT no pressure.

Get back to us when things quiet down for you. That matters most.?

Warmly?
Cynthia?

On Dec 8, 2019, at 8:47 AM, rwdrive <rwdrive@...> wrote:

?
Hello Chris,
For me, that explanation was amazing.? It really makes and i have much better understanding.
I do have one question, with that data, what is your best guess on how many generations are there between Keith and Johns MCRA and the MCRA for the 3 of us?
Thank you!?
Jeff

On Sat, Dec 7, 2019, 11:38 PM Chris Noble <avalea3@...> wrote:
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

<image.png>



On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

¿ªÔÆÌåÓý

Chis,?

If you have an answer to Jeff¡¯s question even just a hint I¡¯d love to know that about Roy, Grady and Wm.?

I know how busy you are and you are seeing how enthusiastic we are BUT no pressure.

Get back to us when things quiet down for you. That matters most.?

Warmly?
Cynthia?

On Dec 8, 2019, at 8:47 AM, rwdrive <rwdrive@...> wrote:

?
Hello Chris,
For me, that explanation was amazing.? It really makes and i have much better understanding.
I do have one question, with that data, what is your best guess on how many generations are there between Keith and Johns MCRA and the MCRA for the 3 of us?
Thank you!?
Jeff

On Sat, Dec 7, 2019, 11:38 PM Chris Noble <avalea3@...> wrote:
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

<image.png>



On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

¿ªÔÆÌåÓý

Gosh you bet I¡¯m aligned with Mary on how incredibly knowledgeable you are and super skilled at breaking this down explaining this to us so well.

Chris, Thank you!!!



On Dec 7, 2019, at 11:38 PM, Chris Noble <avalea3@...> wrote:

?
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

<image.png>



On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

Okay, I have one caveat to issue before answering. SNPs appear totally randomly. You could have one SNP appear in one generation and then not get another one in your line for hundreds of years. Other people could have them more often. Sometimes one generation could have two or more SNPs appear so it is hard to guess these things. But they do have an average calculated for all the people taking the Y700 test. Be aware your sample size is small (just the three of you). But based on the average of about 83 years per SNP I would say anywhere from around 1-3 generations separate your MCRA from Keith and John's. Iain had the block last dated to about 1814 AD but I don't know what he'd date it now that it is broken and there is one more of you in the data. Take any dates with a grain of salt but see how well they might fit with any known paper genealogy you have for the three of you.

Chris


On Sun, Dec 8, 2019 at 5:47 AM rwdrive <rwdrive@...> wrote:
Hello Chris,
For me, that explanation was amazing.? It really makes and i have much better understanding.
I do have one question, with that data, what is your best guess on how many generations are there between Keith and Johns MCRA and the MCRA for the 3 of us?
Thank you!?
Jeff

On Sat, Dec 7, 2019, 11:38 PM Chris Noble <avalea3@...> wrote:
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

image.png


On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

Hello Chris,
For me, that explanation was amazing.? It really makes and i have much better understanding.
I do have one question, with that data, what is your best guess on how many generations are there between Keith and Johns MCRA and the MCRA for the 3 of us?
Thank you!?
Jeff

On Sat, Dec 7, 2019, 11:38 PM Chris Noble <avalea3@...> wrote:
Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

image.png


On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary


Re: Probable new member

 

Okay, let's see if this makes more sense. There is the old spreadsheet in the files section but below is a piece of the new one I'm working on. The columns go in the order of Keith, John, and then Jeff. The SNPs are in order from oldest in time to youngest shared SNPs. Starting with the block of SNPs at S6881, you'll see how they all match each other by testing positive for all the same SNPs until they come to what used to be a block of 3 SNPs. Now it is just a block of two because Keith and John tested positive for BY12294 and Jeff tested negative for it. So I'm going to explain a couple of things here. A block of SNPs (I use dark lines around them when they are a block) is an equivalent group because everyone who has tested who has those SNPs has tested positive for all of the ones in the block. Because of this, they can't tell which one came first or second or third or however many SNPs are in that block. It takes someone to come along and test positive for some and not for others for the block to be broken and them being able to say what order the SNPs come in. So for the previous block of SNPs BY16322, BY16323, and BY122994, it was a block of three because the only ones who had tested positive for them were Keith and John. There was no way to tell what order the SNPs fell in. Now that Jeff came along and tested positive for SNPs BY16322 and BY16323 and negative for BY122994 they know that BY122994 came later in the tree since all three men shared the first two in the block but only two share the last one. So besides helping to show what order that SNP came in it also shows that Jeff broke away from Keith and John's lines at this SNP and went his own way with his own SNPs. Keith and John continued to share that one more SNP, BY122994, before they too broke away from each other and went on with their own SNPs. So Keith and John last shared an ancestor at BY122994 and Jeff last shares an ancestor with them at the block of BY16322 and BY16323. We have no way to tell which order those two SNPs go until someone comes along that will test positive for one of them and negative for the other. If Jeff were to find someone more closely related to himself than Keith and John are some of his private SNPs would probably match that closer match and his haplogroup would change and those new SNPs would show up on the tree. As long as only one person has tested positive for an SNP it won't be on the tree. It takes two people for it to show up. Let me know if this is making sense or if I need to explain it differently.

image.png


On Sat, Dec 7, 2019 at 8:04 PM Wiredmarys <wiredmarys@...> wrote:
Wow Chris,? You helped me a bit with this note to Jeff. Yes and no...because I don't quite understand either.? What do you mean that this is "where you broke off from their two lines"?? When you explain things to Jeff please include me too, I'll bet Cynthia would like to be included as well for John Joseph.? So glad to have you back.
Mary