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.
toggle quoted message
Show quoted text
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@...>
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!
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
?
?
toggle quoted message
Show quoted text
----- Original Message -----
From: Chris Noble <avalea3@...>
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!
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!
toggle quoted message
Show quoted text
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.
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
toggle quoted message
Show quoted text
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
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
toggle quoted message
Show quoted text
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...?
toggle quoted message
Show quoted text
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
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
toggle quoted message
Show quoted text
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
?
toggle quoted message
Show quoted text
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!
toggle quoted message
Show quoted text
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.
|
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.
|
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.
|
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
|
Oops ! Note to Cynthia¡ªread the most recent entry first.?
toggle quoted message
Show quoted text
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.
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
|
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 |
|
toggle quoted message
Show quoted text
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.
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
|
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?
toggle quoted message
Show quoted text
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.
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
|
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!!!
toggle quoted message
Show quoted text
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.
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
|
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
toggle quoted message
Show quoted text
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.
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
|
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
toggle quoted message
Show quoted text
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.
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
|
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.
toggle quoted message
Show quoted text
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
|