I wrote my usual review of the genetic genealogy used in the FYR series. http://www.yourgeneticgenealogist.com/2012/04/finding-your-roots-with-henry-louis_30.html CeCe www.yourgeneticgenealogist.com www.studiointv.com

As usual, I have reviewed the DNA portion of "Finding Your Roots with Henry Louis Gates, Jr." on my blog: http://www.yourgeneticgenealogist.com/2012/04/finding-your-roots-with-henry-louis_23.html Thanks, CeCe www.yourgeneticgenealogist.com www.studiointv.com

...and here are a few of my other recent posts: I have been writing a review of the DNA portion of Henry Louis Gates Jr's genealogy series every week: Week 1 - Episode 1 and Episode 2 = http://www.yourgeneticgenealogist.com/2012/03/finding-your-roots-with-henry-louis.html Week 2 - Episode 3 = http://www.yourgeneticgenealogist.com/2012/04/finding-your-roots-with-henry-louis.html Week 3 - Episode 4 = http://www.yourgeneticgenealogist.com/2012/04/finding-your-roots-with-henry-louis_09.html Week 4 - Episode 5 = http://www.yourgeneticgenealogist.com/2012/04/finding-your-roots-with-henry-louis_16.html AncestryDNA's new test - a review: http://www.yourgeneticgenealogist.com/2012/03/new-information-on-ancestrycoms.html I apologize for the cross-posting to anyone who belongs to the other lists. I am posting these here by request. CeCe www.yourgeneticgenealogist.com www.studiointv.com

Hi, Someone pointed out to me that I haven't been posting my blogs on this list. I wasn't because I figured you all subscribed to either DNA Genealogy or DNA Newbie, but I have been informed that this isn't true. So, here is my latest post about the FTDNA sale that started this evening and goes through Saturday: http://www.yourgeneticgenealogist.com/2012/04/well-if-you-havent-heard-its-again-dna.html CeCe www.yourgeneticgenealogist.com www.studiointv.com

I have to agree with Tim. I have a fairly robust Colonial Virginia ancestry, and am now at 62 confirmed atMatches with Common Ancestors - some with more than one Common Ancestor. As I look at the 1,000 plus atMatches in a spreadsheet arranged by Chr and Start Location of the largest Segments, I note some overlapping segments going back to different ancestors. This is OK for one on Dad's side and one on Mom's side, but impossible for both to be on the same side. Each large segment on a Chr can only go back to one ancestor on, say, Dad's side. This will be an excellent opportunity to sort out some of the Tree claims on Ancestry. I'm afraid that unless they let us see the segment locations, they will just perpetuate, in fact make worse, the junk Trees that are out there. Ancestry's powerful software will match us with all kinds of junk (there's plenty of it there), and now folks will claim their lines are proved by matching DNA - impossible to refute unless it's tied to segment mapping. With segment mapping we may finally get some of Trees right. It's OK to have multiple Common Ancestors with atMatches (it's very much expected with Colonial roots), but each atDNA segment can only go back to one ancestral line. It will become very important to map these segments with the flood of info we'll get from Ancestry hint leaves. Jim - Sent from my iPhone - FaceTime! On Apr 10, 2012, at 10:48 AM, Sam Eaton <[email protected]> wrote: > Dear Tim, > > "Ancestry.com may well be helping us by reporting shared surnames and > shared geography, but all of the "technical stuff" (specifically chromosome > mapping) is just as important as it ever was." > > Mostly and for people with our level of technological expertise, I agree with you. For normal people, I think that atDNA just got useable and, sort of, understandable. For people with scientific and technical expertise, I think that a large part of our "druge" work just went away. > > Ancestry.com's atDNA program is still in beta and chromosome mapping, in fact any access to Raw Data is not yet possible. For normal people, I don't see this as an issue. For us, I completely agree with you. Should lack of access to Raw Data not become available by or shortly after public release, Ancestry.com's atDNA will be nothing more than a another, and limited, tool. > > Sam > > > > From: "Tim Janzen" <[email protected]> > Subject: Re: [AUTOSOMAL-DNA] Ancestry atDNA > > > Dear Sam, > Ancestry.com may well be helping us by reporting shared surnames and > shared geography, but all of the "technical stuff" (specifically chromosome > mapping) is just as important as it ever was. The only way you can be > certain that you truly have a true genealogical relationship with a genetic > match who may be a 6th to 10th cousin to you based on Ancestry.com's > discovery of shared surnames or geography is to accurately map as much of > your genome as possible with results from as many 1st, 2nd, 3rd, and 4th > cousins as possible. You can be more comfortable with linking a specific > segment to a specific ancestor 6 to 8 generations back in time if you have > already linked that specific segment to a specific ancestor 3 to 5 > generations back in time. This is particularly important for endogamous > populations. The genetic genealogical community needs to continue to > strongly push Ancestry.com to release the matching segment data and to allow > downloads of the raw data files. > Sincerely, > Tim Janzen > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html >

Dear Tim, "Ancestry.com may well be helping us by reporting shared surnames and shared geography, but all of the "technical stuff" (specifically chromosome mapping) is just as important as it ever was." Mostly and for people with our level of technological expertise, I agree with you. For normal people, I think that atDNA just got useable and, sort of, understandable. For people with scientific and technical expertise, I think that a large part of our "druge" work just went away. Ancestry.com's atDNA program is still in beta and chromosome mapping, in fact any access to Raw Data is not yet possible. For normal people, I don't see this as an issue. For us, I completely agree with you. Should lack of access to Raw Data not become available by or shortly after public release, Ancestry.com's atDNA will be nothing more than a another, and limited, tool. Sam From: "Tim Janzen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] Ancestry atDNA Dear Sam, Ancestry.com may well be helping us by reporting shared surnames and shared geography, but all of the "technical stuff" (specifically chromosome mapping) is just as important as it ever was. The only way you can be certain that you truly have a true genealogical relationship with a genetic match who may be a 6th to 10th cousin to you based on Ancestry.com's discovery of shared surnames or geography is to accurately map as much of your genome as possible with results from as many 1st, 2nd, 3rd, and 4th cousins as possible. You can be more comfortable with linking a specific segment to a specific ancestor 6 to 8 generations back in time if you have already linked that specific segment to a specific ancestor 3 to 5 generations back in time. This is particularly important for endogamous populations. The genetic genealogical community needs to continue to strongly push Ancestry.com to release the matching segment data and to allow downloads of the raw data files. Sincerely, Tim Janzen

Dear Sam, Ancestry.com may well be helping us by reporting shared surnames and shared geography, but all of the "technical stuff" (specifically chromosome mapping) is just as important as it ever was. The only way you can be certain that you truly have a true genealogical relationship with a genetic match who may be a 6th to 10th cousin to you based on Ancestry.com's discovery of shared surnames or geography is to accurately map as much of your genome as possible with results from as many 1st, 2nd, 3rd, and 4th cousins as possible. You can be more comfortable with linking a specific segment to a specific ancestor 6 to 8 generations back in time if you have already linked that specific segment to a specific ancestor 3 to 5 generations back in time. This is particularly important for endogamous populations. The genetic genealogical community needs to continue to strongly push Ancestry.com to release the matching segment data and to allow downloads of the raw data files. Sincerely, Tim Janzen -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sam Eaton Sent: Monday, April 09, 2012 1:57 PM To: [email protected] Subject: [AUTOSOMAL-DNA] Ancestry atDNA Just got my first look at my cousin's results. I have a kit waiting for me in the US. I don't know how I'm going to arrange to do the test from here in Asia. I just missed the test arrival by a couple of days. Impressions, The technical stuff that we love is gone and the sample size reminds me of 23and me in 2009. That said, the technical stuff that we spend weeks and months trying to fit together and educate others about, just became a lot less important. Ancestry.com searches through the trees of those who match and repors both shared surnames names and shared geography in a very clickable form. What I have spent weeks and even months working on for a single match now requires a few simple mouse clicks for 80-90% of the work.

Just got my first look at my cousin's results. I have a kit waiting for me in the US. I don't know how I'm going to arrange to do the test from here in Asia. I just missed the test arrival by a couple of days. Impressions, The technical stuff that we love is gone and the sample size reminds me of 23and me in 2009. That said, the technical stuff that we spend weeks and months trying to fit together and educate others about, just became a lot less important. Ancestry.com searches through the trees of those who match and repors both shared surnames names and shared geography in a very clickable form. What I have spent weeks and even months working on for a single match now requires a few simple mouse clicks for 80-90% of the work.

Thanks again to Ann and Jim I was able to get my 23andme data into Excel, sort in ascending order and easily find the snp I was looking for in a list of over 800 lines. According to the folks on thr Hg I list, this tells me I am L840+ and do not need another FTDNA test to find out. Thanks again Ron ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Thursday, April 5, 2012 3:00:02 AM Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 56 Today's Topics:   1. Re: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 (Jim Bartlett)   2. Re: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 (Ann Turner) ---------------------------------------------------------------------- Message: 1 Date: Wed, 04 Apr 2012 17:47:59 -0500 From: Jim Bartlett <[email protected]> Subject: Re: [AUTOSOMAL-DNA] AUTOSOMAL-DNA Digest, Vol 2, Issue 54 To: RON SINCLAIR <[email protected]>,     "[email protected]" <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Ron Copy the list; position your cursor on an Excel cell and paste. Jim - Sent from my iPhone - FaceTime! On Apr 4, 2012, at 4:57 PM, RON SINCLAIR <[email protected]> wrote: > Does anyone know how to get the raw data in the text file form into a spread sheet so that it can be sorted sequentially in order to find a specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron > > > ________________________________ > From: "[email protected]" <[email protected]> > To: [email protected] > Sent: Wednesday, April 4, 2012 2:16:35 PM > Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 > > > > Today's Topics: > >    1. extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    2. Re: extracting Y-DNA SNPs from 23andMe ([email protected]) >    3. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) >    4. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    5. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    6. Re: extracting Y-DNA SNPs from 23andMe (Larry Vick) >    7. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) >    8. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    9. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 4 Apr 2012 08:58:14 -0400 > From: "Diana Gale Matthiesen" <[email protected]> > Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > To: <[email protected]> > Message-ID: <[email protected]> ------------------------------ Message: 2 Date: Wed, 4 Apr 2012 16:05:55 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] AUTOSOMAL-DNA Digest, Vol 2, Issue 54 To: RON SINCLAIR <[email protected]>, [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 Open Excel first, then use the File | Open dialog and locate the file. Double click on the file name to open. It is a tab-delimited file, which Excel knows how to handle.  You must have Excel 2007 or higher because of the large file size. Ann Turner On Wed, Apr 4, 2012 at 2:57 PM, RON SINCLAIR <[email protected]>wrote: > Does anyone know how to get the raw data in the text file form into a > spread sheet so that it can be sorted sequentially in order to find a > specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron > ------------------------------ End of AUTOSOMAL-DNA Digest, Vol 2, Issue 56 ********************************************

Ron Copy the list; position your cursor on an Excel cell and paste. Jim - Sent from my iPhone - FaceTime! On Apr 4, 2012, at 4:57 PM, RON SINCLAIR <[email protected]> wrote: > Does anyone know how to get the raw data in the text file form into a spread sheet so that it can be sorted sequentially in order to find a specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron > > > ________________________________ > From: "[email protected]" <[email protected]> > To: [email protected] > Sent: Wednesday, April 4, 2012 2:16:35 PM > Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 > > > > Today's Topics: > > 1. extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > 2. Re: extracting Y-DNA SNPs from 23andMe ([email protected]) > 3. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) > 4. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > 5. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > 6. Re: extracting Y-DNA SNPs from 23andMe (Larry Vick) > 7. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) > 8. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > 9. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 4 Apr 2012 08:58:14 -0400 > From: "Diana Gale Matthiesen" <[email protected]> > Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > To: <[email protected]> > Message-ID: <[email protected]>

Open Excel first, then use the File | Open dialog and locate the file. Double click on the file name to open. It is a tab-delimited file, which Excel knows how to handle. You must have Excel 2007 or higher because of the large file size. Ann Turner On Wed, Apr 4, 2012 at 2:57 PM, RON SINCLAIR <[email protected]>wrote: > Does anyone know how to get the raw data in the text file form into a > spread sheet so that it can be sorted sequentially in order to find a > specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron >

Does anyone know how to get the raw data in the text file form into a spread sheet so that it can be sorted sequentially in order to find a specific SNP? Can it be brought into Excel? The data is my own data. Appreciate instructions as to how to do it. Thanks, Ron ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 2:16:35 PM Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 Today's Topics:   1. extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   2. Re: extracting Y-DNA SNPs from 23andMe ([email protected])   3. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner)   4. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   5. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   6. Re: extracting Y-DNA SNPs from 23andMe (Larry Vick)   7. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner)   8. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen)   9. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) ---------------------------------------------------------------------- Message: 1 Date: Wed, 4 Apr 2012 08:58:14 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" I've been tested at 23andMe, and I must admit that, so far, I've only made use of the medical information.  I would like to learn how to extract data that would be relevant to the SNPs used to determine someone's Y-DNA haplogroup.  (Obviously not out of my own results, but those of particular males.)  Specifically, I'm trying to supplement results that are available at FTDNA, such as at the Haplogroup I1 project: http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp How would I go about finding SNP results in Hg I1 males at 23andMe?  Diana ------------------------------ Message: 2 Date: Wed, 4 Apr 2012 13:09:53 +0000 (UTC) From: [email protected] Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]a.mail.comcast.net>     Content-Type: text/plain; charset=utf-8 You might wish to look at Adriano Squecco's project where he has them all in nicely annotated Excel spreadsheets. http://www.snpedia.com/index.php/Squecco_List ----- Original Message ----- From: "Diana Gale Matthiesen" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 7:58:14 AM Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe I've been tested at 23andMe, and I must admit that, so far, I've only made use of the medical information. ?I would like to learn how to extract data that would be relevant to the SNPs used to determine someone's Y-DNA haplogroup. ?(Obviously not out of my own results, but those of particular males.) ?Specifically, I'm trying to supplement results that are available at FTDNA, such as at the Haplogroup I1 project: http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp How would I go about finding SNP results in Hg I1 males at 23andMe? ? Diana ______________________________ For answers to Frequently Asked Questions about mailing lists, please see: http://dgmweb.net/MailingListFAQs.html ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message ------------------------------ Message: 3 Date: Wed, 4 Apr 2012 06:21:45 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 You're speaking of cases where you don't have access to the raw data, but you know the haplogroup? You can use the Haplogroup Tree Mutation Mapper (under Ancestry Labs) and enter any subclade into the query box. The subclade label may very well be different than the one assigned by FTDNA, depending on nomenclature and how deeply the FTDNA customer has been tested. Take a note of the most derived SNP (the one at the top of the results list) and look it up in http://isogg.org/tree under the major haplogroup label. Ann Turner On Wed, Apr 4, 2012 at 5:58 AM, Diana Gale Matthiesen <[email protected]>wrote: > I've been tested at 23andMe, and I must admit that, so far, I've only > made use of the medical information.  I would like to learn how to > extract data that would be relevant to the SNPs used to determine > someone's Y-DNA haplogroup.  (Obviously not out of my own results, but > those of particular males.)  Specifically, I'm trying to supplement > results that are available at FTDNA, such as at the Haplogroup I1 > project: > http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp > > How would I go about finding SNP results in Hg I1 males at 23andMe? > > Diana > > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html > > > ------------------------------- > To unsubscribe from the list, please send an email to > [email protected] with the word 'unsubscribe' without > the quotes in the subject and the body of the message > ------------------------------ Message: 4 Date: Wed, 4 Apr 2012 10:38:42 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="UTF-8" Thanks, Tim.  Wow, my hat's off to the person compiling this.  What a lot of work. Diana > From: [email protected] > Sent: Wednesday, April 04, 2012 9:10 AM > > You might wish to look at Adriano Squecco's project > where he has them all in nicely annotated Excel > spreadsheets. > > http://www.snpedia.com/index.php/Squecco_List ------------------------------ Message: 5 Date: Wed, 4 Apr 2012 11:00:12 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm familiar with the SNPs.  When I ask for a "List of Mutations" for I1, it gives them to me, but when I click on one, it only gives me my result (nc of course).  What I'm trying to find out, ideally, is the haplogroup-relevant SNP status of all the I1 men in the database.  Is there a way to do that?  What does it mean to have access to the raw data?  I think that must be what I need because some people are talking about some "obscure" I1 SNPs being readable/available there, ones that are not on the List. I really mean it when I say all I've ever done at 23andMe is look at my medical data.  I suppose there's a tutorial I should walk through, as in, "If all else fails, read the instructions." Diana > From: Ann Turner > Sent: Wednesday, April 04, 2012 9:22 AM > > You're speaking of cases where you don't have access > to the raw data, but you know the haplogroup? You can > use the Haplogroup Tree Mutation Mapper (under Ancestry > Labs) and enter any subclade into the query box. The > subclade label may very well be different than the one > assigned by FTDNA, depending on nomenclature and how > deeply the FTDNA customer has been tested. Take a note > of the most derived SNP (the one at the top of the > results list) and look it up in http://isogg.org/tree > under the major haplogroup label. ------------------------------ Message: 6 Date: Wed, 4 Apr 2012 08:35:19 -0700 (PDT) From: Larry Vick <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: "[email protected]" <[email protected]> Message-ID:     <[email protected]> Content-Type: text/plain; charset=iso-8859-1 Diana, If you are asking how to download the raw data go to "Account" at the top of any screen on 23andMe, then select "Browse Raw Data." ?Next, click on the "Download Raw Data" link at the top left (it has a green down arrow icon). ?Then select "Y Chromosome" for the data set. ?You will have to enter the password and answer the security question. Regards, Larry ________________________________ From: Diana Gale Matthiesen <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 11:00 AM Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm familiar with the SNPs.? When I ask for a "List of Mutations" for I1, it gives them to me, but when I click on one, it only gives me my result (nc of course).? What I'm trying to find out, ideally, is the haplogroup-relevant SNP status of all the I1 men in the database.? Is there a way to do that?? What does it mean to have access to the raw data?? I think that must be what I need because some people are talking about some "obscure" I1 SNPs being readable/available there, ones that are not on the List. I really mean it when I say all I've ever done at 23andMe is look at my medical data.? I suppose there's a tutorial I should walk through, as in, "If all else fails, read the instructions." Diana ------------------------------ Message: 7 Date: Wed, 4 Apr 2012 09:06:53 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 No, you wouldn't be able to look at the SNP status of all I1 men in the 23andMe database. If you don't have any access to a male's account, you can add the demo "Mendel" family  at Account | Settings | Example Profiles. Then you can Browse Raw Data for the SNP and see Greg Mendel's results.  He's currently classified as I1*. If you're talking about an "obscure" SNP that's not currently used by 23andMe or ISOGG to define a subclade, you can start a Community Thread on the topic and ask what people are finding. In fact, I have a vague recollection about just such a thread, so Search the website for the SNP and see if it's under discussion. Ann On Wed, Apr 4, 2012 at 8:00 AM, Diana Gale Matthiesen <[email protected]>wrote: > Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm > familiar with the SNPs.  When I ask for a "List of Mutations" for I1, > it gives them to me, but when I click on one, it only gives me my > result (nc of course).  What I'm trying to find out, ideally, is the > haplogroup-relevant SNP status of all the I1 men in the database.  Is > there a way to do that?  What does it mean to have access to the raw > data?  I think that must be what I need because some people are > talking about some "obscure" I1 SNPs being readable/available there, > ones that are not on the List. > > I really mean it when I say all I've ever done at 23andMe is look at > my medical data.  I suppose there's a tutorial I should walk through, > as in, "If all else fails, read the instructions." > > Diana > ------------------------------ Message: 8 Date: Wed, 4 Apr 2012 13:51:43 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="iso-8859-1" Thanks, Larry.  I'm not asking how to download my own data, but I see Ann has answered my question... Diana > From: Larry Vick > Sent: Wednesday, April 04, 2012 11:35 AM > > Diana, > > If you are asking how to download the raw data go to "Account" at > the top of any screen on 23andMe, then select "Browse Raw > Data." ?Next, click on the "Download Raw Data" link at the top left > (it has a green down arrow icon). ?Then select "Y Chromosome" for > the data set. ?You will have to enter the password and answer the > security question. > > Regards, > > Larry ------------------------------ Message: 9 Date: Wed, 4 Apr 2012 14:16:18 -0400 From: "Diana Gale Matthiesen" <[email protected]> Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe To: <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain;    charset="us-ascii" I see, thank you, Ann, even though you're telling me it's not possible to do what I'd hoped. ;-)  I guess it doesn't really surprise me too much. What I am looking for is Hg I* and I1* men who had possibly tested at 23andMe, but not FTDNA, where I could read results for some of the phyloequivalent SNPs that people typically don't test a la carte and that aren't usually included in a deep clade test at FTDNA.  IOW, at FTDNA, if someone tests M253+ or M170+/M253-, there would usually be no reason to test anything else that isn't known to be downstream. To be more specific, I'd like to see if everyone who is M170+/M253- or M253+ is also L840+ (plus other allegedly M253 phyloequivalent SNPs). They are said to be equivalent, and I don't have any reason to doubt the person saying it, but if I'm going to site that as a proven fact on my web site, I would like to see the data for myself.  If that kind of hunt is not possible, then I need to try some other avenue. Am I correct in understanding that, essentially, the only way to get that information is if the test subject gives it to you?  Which means you have to somehow know whom to ask. Diana > -----Original Message----- > From: [email protected] [mailto:autosomal-dna- > [email protected]] On Behalf Of Ann Turner > Sent: Wednesday, April 04, 2012 12:07 PM > To: [email protected] > Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > > No, you wouldn't be able to look at the SNP status of all I1 men in > the > 23andMe database. > > If you don't have any access to a male's account, you can add the > demo > "Mendel" family  at Account | Settings | Example Profiles. Then you > can > Browse Raw Data for the SNP and see Greg Mendel's results.  He's > currently > classified as I1*. > > If you're talking about an "obscure" SNP that's not currently used > by > 23andMe or ISOGG to define a subclade, you can start a Community > Thread on > the topic and ask what people are finding. In fact, I have a vague > recollection about just such a thread, so Search the website for the > SNP > and see if it's under discussion. > > Ann ------------------------------ End of AUTOSOMAL-DNA Digest, Vol 2, Issue 54 ********************************************

I see, thank you, Ann, even though you're telling me it's not possible to do what I'd hoped. ;-) I guess it doesn't really surprise me too much. What I am looking for is Hg I* and I1* men who had possibly tested at 23andMe, but not FTDNA, where I could read results for some of the phyloequivalent SNPs that people typically don't test a la carte and that aren't usually included in a deep clade test at FTDNA. IOW, at FTDNA, if someone tests M253+ or M170+/M253-, there would usually be no reason to test anything else that isn't known to be downstream. To be more specific, I'd like to see if everyone who is M170+/M253- or M253+ is also L840+ (plus other allegedly M253 phyloequivalent SNPs). They are said to be equivalent, and I don't have any reason to doubt the person saying it, but if I'm going to site that as a proven fact on my web site, I would like to see the data for myself. If that kind of hunt is not possible, then I need to try some other avenue. Am I correct in understanding that, essentially, the only way to get that information is if the test subject gives it to you? Which means you have to somehow know whom to ask. Diana > -----Original Message----- > From: [email protected] [mailto:autosomal-dna- > [email protected]] On Behalf Of Ann Turner > Sent: Wednesday, April 04, 2012 12:07 PM > To: [email protected] > Subject: Re: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > > No, you wouldn't be able to look at the SNP status of all I1 men in > the > 23andMe database. > > If you don't have any access to a male's account, you can add the > demo > "Mendel" family at Account | Settings | Example Profiles. Then you > can > Browse Raw Data for the SNP and see Greg Mendel's results. He's > currently > classified as I1*. > > If you're talking about an "obscure" SNP that's not currently used > by > 23andMe or ISOGG to define a subclade, you can start a Community > Thread on > the topic and ask what people are finding. In fact, I have a vague > recollection about just such a thread, so Search the website for the > SNP > and see if it's under discussion. > > Ann

The limit of 5 per day has been removed but I still do approximately 5 a day similar to Jim's process. On Wed, Apr 4, 2012 at 1:41 PM, [email protected] wrote: >Diana > >I've found a couple dozen atCousins at 23&Me. Here's the process I used. > >1. Make up a standard message. I encluded links to my two ancestors-only trees on line; my name ans email; my desire to share my info, and hope to look at other's trees, my plea to at least accept the invite and/or share emails because some names drop off after 1,000 are posted - all under 1,000 letters-spaces. > >2. Click on Relative Finder and then click on "send invitation" and highlight the standard message and copy in your message; click send, then close; then repeat four more times. Limit is 5 per day. I've now sent messages to over a thousand matches. About half eventually reply. Make your brief message as inviting and easy as you can to get a good response rate. > >Jim - Sent from my iPhone - FaceTime! > >On Apr 4, 2012, at 10:00 AM, "Diana Gale Matthiesen" <[email protected]> wrote: > >> Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm >> familiar with the SNPs. When I ask for a "List of Mutations" for I1, >> it gives them to me, but when I click on one, it only gives me my >> result (nc of course). What I'm trying to find out, ideally, is the >> haplogroup-relevant SNP status of all the I1 men in the database. Is >> there a way to do that? What does it mean to have access to the raw >> data? I think that must be what I need because some people are >> talking about some "obscure" I1 SNPs being readable/available there, >> ones that are not on the List. >> >> I really mean it when I say all I've ever done at 23andMe is look at >> my medical data. I suppose there's a tutorial I should walk through, >> as in, "If all else fails, read the instructions." >> >> Diana >> >> >> >> >>> From: Ann Turner >>> Sent: Wednesday, April 04, 2012 9:22 AM >>> >>> You're speaking of cases where you don't have access >>> to the raw data, but you know the haplogroup? You can >>> use the Haplogroup Tree Mutation Mapper (under Ancestry >>> Labs) and enter any subclade into the query box. The >>> subclade label may very well be different than the one >>> assigned by FTDNA, depending on nomenclature and how >>> deeply the FTDNA customer has been tested. Take a note >>> of the most derived SNP (the one at the top of the >>> results list) and look it up in http://isogg.org/tree >>> under the major haplogroup label. >> >> >> >> >> ______________________________ >> For answers to Frequently Asked Questions about mailing lists, please see: >> http://dgmweb.net/MailingListFAQs.html >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message > > > >______________________________ >For answers to Frequently Asked Questions about mailing lists, please see: >http://dgmweb.net/MailingListFAQs.html > > >------------------------------- >To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message >

Thanks, Larry. I'm not asking how to download my own data, but I see Ann has answered my question... Diana > From: Larry Vick > Sent: Wednesday, April 04, 2012 11:35 AM > > Diana, > > If you are asking how to download the raw data go to "Account" at > the top of any screen on 23andMe, then select "Browse Raw > Data."  Next, click on the "Download Raw Data" link at the top left > (it has a green down arrow icon).  Then select "Y Chromosome" for > the data set.  You will have to enter the password and answer the > security question. > > Regards, > > Larry

Diana I've found a couple dozen atCousins at 23&Me. Here's the process I used. 1. Make up a standard message. I encluded links to my two ancestors-only trees on line; my name ans email; my desire to share my info, and hope to look at other's trees, my plea to at least accept the invite and/or share emails because some names drop off after 1,000 are posted - all under 1,000 letters-spaces. 2. Click on Relative Finder and then click on "send invitation" and highlight the standard message and copy in your message; click send, then close; then repeat four more times. Limit is 5 per day. I've now sent messages to over a thousand matches. About half eventually reply. Make your brief message as inviting and easy as you can to get a good response rate. Jim - Sent from my iPhone - FaceTime! On Apr 4, 2012, at 10:00 AM, "Diana Gale Matthiesen" <[email protected]> wrote: > Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm > familiar with the SNPs. When I ask for a "List of Mutations" for I1, > it gives them to me, but when I click on one, it only gives me my > result (nc of course). What I'm trying to find out, ideally, is the > haplogroup-relevant SNP status of all the I1 men in the database. Is > there a way to do that? What does it mean to have access to the raw > data? I think that must be what I need because some people are > talking about some "obscure" I1 SNPs being readable/available there, > ones that are not on the List. > > I really mean it when I say all I've ever done at 23andMe is look at > my medical data. I suppose there's a tutorial I should walk through, > as in, "If all else fails, read the instructions." > > Diana > > > > >> From: Ann Turner >> Sent: Wednesday, April 04, 2012 9:22 AM >> >> You're speaking of cases where you don't have access >> to the raw data, but you know the haplogroup? You can >> use the Haplogroup Tree Mutation Mapper (under Ancestry >> Labs) and enter any subclade into the query box. The >> subclade label may very well be different than the one >> assigned by FTDNA, depending on nomenclature and how >> deeply the FTDNA customer has been tested. Take a note >> of the most derived SNP (the one at the top of the >> results list) and look it up in http://isogg.org/tree >> under the major haplogroup label. > > > > > ______________________________ > For answers to Frequently Asked Questions about mailing lists, please see: > http://dgmweb.net/MailingListFAQs.html > > > ------------------------------- > To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

You might wish to look at Adriano Squecco's project where he has them all in nicely annotated Excel spreadsheets. http://www.snpedia.com/index.php/Squecco_List ----- Original Message ----- From: "Diana Gale Matthiesen" <[email protected]> To: [email protected] Sent: Wednesday, April 4, 2012 7:58:14 AM Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe I've been tested at 23andMe, and I must admit that, so far, I've only made use of the medical information.  I would like to learn how to extract data that would be relevant to the SNPs used to determine someone's Y-DNA haplogroup.  (Obviously not out of my own results, but those of particular males.)  Specifically, I'm trying to supplement results that are available at FTDNA, such as at the Haplogroup I1 project: http://www.familytreedna.com/public/yDNA_I1/default.aspx?section=ysnp How would I go about finding SNP results in Hg I1 males at 23andMe?   Diana ______________________________ For answers to Frequently Asked Questions about mailing lists, please see: http://dgmweb.net/MailingListFAQs.html ------------------------------- To unsubscribe from the list, please send an email to [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm familiar with the SNPs. When I ask for a "List of Mutations" for I1, it gives them to me, but when I click on one, it only gives me my result (nc of course). What I'm trying to find out, ideally, is the haplogroup-relevant SNP status of all the I1 men in the database. Is there a way to do that? What does it mean to have access to the raw data? I think that must be what I need because some people are talking about some "obscure" I1 SNPs being readable/available there, ones that are not on the List. I really mean it when I say all I've ever done at 23andMe is look at my medical data. I suppose there's a tutorial I should walk through, as in, "If all else fails, read the instructions." Diana > From: Ann Turner > Sent: Wednesday, April 04, 2012 9:22 AM > > You're speaking of cases where you don't have access > to the raw data, but you know the haplogroup? You can > use the Haplogroup Tree Mutation Mapper (under Ancestry > Labs) and enter any subclade into the query box. The > subclade label may very well be different than the one > assigned by FTDNA, depending on nomenclature and how > deeply the FTDNA customer has been tested. Take a note > of the most derived SNP (the one at the top of the > results list) and look it up in http://isogg.org/tree > under the major haplogroup label.

Thanks, Tim. Wow, my hat's off to the person compiling this. What a lot of work. Diana > From: [email protected] > Sent: Wednesday, April 04, 2012 9:10 AM > > You might wish to look at Adriano Squecco's project > where he has them all in nicely annotated Excel > spreadsheets. > > http://www.snpedia.com/index.php/Squecco_List

No, you wouldn't be able to look at the SNP status of all I1 men in the 23andMe database. If you don't have any access to a male's account, you can add the demo "Mendel" family at Account | Settings | Example Profiles. Then you can Browse Raw Data for the SNP and see Greg Mendel's results. He's currently classified as I1*. If you're talking about an "obscure" SNP that's not currently used by 23andMe or ISOGG to define a subclade, you can start a Community Thread on the topic and ask what people are finding. In fact, I have a vague recollection about just such a thread, so Search the website for the SNP and see if it's under discussion. Ann On Wed, Apr 4, 2012 at 8:00 AM, Diana Gale Matthiesen <[email protected]>wrote: > Yes, I'm looking for SNPs in a certain haplogroup, I1, and I'm > familiar with the SNPs. When I ask for a "List of Mutations" for I1, > it gives them to me, but when I click on one, it only gives me my > result (nc of course). What I'm trying to find out, ideally, is the > haplogroup-relevant SNP status of all the I1 men in the database. Is > there a way to do that? What does it mean to have access to the raw > data? I think that must be what I need because some people are > talking about some "obscure" I1 SNPs being readable/available there, > ones that are not on the List. > > I really mean it when I say all I've ever done at 23andMe is look at > my medical data. I suppose there's a tutorial I should walk through, > as in, "If all else fails, read the instructions." > > Diana >