{"id":7411,"date":"2018-10-29T20:36:57","date_gmt":"2018-10-29T20:36:57","guid":{"rendered":"http:\/\/www.jmhartley.com\/HBlog\/?p=7411"},"modified":"2018-10-29T20:36:57","modified_gmt":"2018-10-29T20:36:57","slug":"visual-phasing-six-siblings-with-the-fox-spreadsheet-part-1-the-x-chromosome-and-a-deceptive-cousin-match","status":"publish","type":"post","link":"http:\/\/www.jmhartley.com\/HBlog\/2018\/10\/29\/visual-phasing-six-siblings-with-the-fox-spreadsheet-part-1-the-x-chromosome-and-a-deceptive-cousin-match\/","title":{"rendered":"Visual Phasing Six Siblings with the Fox Spreadsheet: Part 1 &#8211; The X Chromosome and a Deceptive Cousin Match"},"content":{"rendered":"<p>My brother Jim was the last of six siblings to have his DNA tested. As a result, I am behind on phasing his DNA. The Visual Phasing process puts your DNA into four categories. Those four categories correspond to the DNA that you got from your four grandparents.<\/p>\n<p>First I used the Steven Fox\u00a0Visual Phasing Spreadsheet. I downloaded information from gedmatch using that spreadsheet. The program timed out, but it looks like I have enough to get started. Usually, Visual Phasing is just done with three siblings at a time, but I thought I&#8217;d try it with all six.<\/p>\n<h2>Starting with the X Chromosome<\/h2>\n<p>Some people like to start with the X Chromosome. Part of the reason is that it is already phased between maternal and paternal. Females get two X Chromosomes, but males get one. The one that males get is from the maternal side. I had already looked into Jim&#8217;s X Chromosome. I compared it without the Fox Spreadsheet and got this:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7412\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel.png\" alt=\"\" width=\"1057\" height=\"311\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel.png 1057w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel-300x88.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel-768x226.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-17_59_07-XChromosome.xlsx-Excel-1024x301.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Here is the complicated six sibling comparison:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7413\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"1117\" height=\"890\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png 1117w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-300x239.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-768x612.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_02_08-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-1024x816.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>In this comparison, Jim is V, Jon is F, and Joel is D. V&amp;F, V&amp;D and F&amp;D correspond to my three brother comparison above. My three sisters have two X Chromosomes, so they have a maternal and paternal side. The paternal side is the same for all three sisters, so they are at least half identical in all places. Yellow is the half identical areas. Red is no match and green means that my sisters match on both the maternal and paternal sides.<\/p>\n<p>I have set the crossover points here:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7414\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"1112\" height=\"889\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png 1112w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-300x240.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-768x614.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_16_21-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-1024x819.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Next I need to figure out who owns each crossover. It looks like the first one belongs to Heidi:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_24_43-Greenshot-image-editor.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7415\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_24_43-Greenshot-image-editor.png\" alt=\"\" width=\"353\" height=\"898\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_24_43-Greenshot-image-editor.png 353w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_24_43-Greenshot-image-editor-118x300.png 118w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/a><\/p>\n<p>Every time there is a change in one of the comparisons, Heidi is involved. In three sibling visual phasing, Heidi would be involved in match changes with two other siblings. In six sibling visual phasing, she shows the changes with each of her five siblings. This gives more certainty to setting crossover lines.<\/p>\n<h3>Second Try at Building the Chromosomes<\/h3>\n<p>I tried to build the chromosomes a second time without all the added cousins as that was slowing the process down. The spreadsheet allows you to add them later. Here is the assuring message I got:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_40_16-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7416\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-27-18_40_16-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"227\" height=\"167\" \/><\/a><\/p>\n<p>I can add the cousins in later.<\/p>\n<h3>An Apparent Jim Crossover That Is Not<\/h3>\n<p>Note that at about position 23, it appears that Jim should have a crossover, but it actually goes to his two brothers:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_06_10-XChromosome.xlsx-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7417\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_06_10-XChromosome.xlsx-Excel.png\" alt=\"\" width=\"321\" height=\"311\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_06_10-XChromosome.xlsx-Excel.png 321w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_06_10-XChromosome.xlsx-Excel-300x291.png 300w\" sizes=\"auto, (max-width: 321px) 100vw, 321px\" \/><\/a><\/p>\n<p>This is a little easier to see in the six sibling comparison:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_08_19-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7418\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_08_19-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"510\" height=\"887\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_08_19-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png 510w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_08_19-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-172x300.png 172w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/a><\/p>\n<p>Jon (F) is in purple and Joel (D) is in orange. These two crossovers are not in the same place but are very close to each other. Joel&#8217;s is first at about 23M and Jon is next at about 23.3M.<\/p>\n<h3>Another Close Set of Crossovers: Jim and Lori<\/h3>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_37_33-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7419\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_37_33-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"800\" height=\"884\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_37_33-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png 800w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_37_33-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-271x300.png 271w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_37_33-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-768x849.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Here Jim&#8217;s crossover is at 87.5M and Lori&#8217;s is at 87.7M. That means I need to add another Line for Lori. Now I have 13 crossovers for six siblings:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7420\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png\" alt=\"\" width=\"1108\" height=\"886\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel.png 1108w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-300x240.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-768x614.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-07_43_40-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1.xlsm-Excel-1024x819.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<h2>Adding Cousins<\/h2>\n<p>I would like to add cousins to the spreadsheet, as I took them out earlier to make the spreadsheet build run smoothly. Now I will add them back in. I went through Steve Fox&#8217;s instruction manual. I added back in cousins and hit the &#8216;add&#8217; button. I had added my father&#8217;s cousin Jim and the program didn&#8217;t like that as my brother is also Jim, so I changed my father&#8217;s cousin&#8217;s name to James and the program was happy. I added 17 cousins, so it could take the spreadsheet a while to add in 17 cousins for 6 siblings. Based on the progress, this process should take about an hour if nothing times out. Actually, it did time out or Excel hung up and I wasn&#8217;t happy with the results. So I deleted the cousins and added them in in two batches after closing unneeded programs and Excel spreadsheets.<\/p>\n<p>Here is another assuring announcement:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-10_26_12-Microsoft-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7422\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-10_26_12-Microsoft-Excel.png\" alt=\"\" width=\"212\" height=\"153\" \/><\/a><\/p>\n<p>After this, I ran the other 9 cousins and I successfully completed the build.\u00a0This build process took a while but should be well worth it.<\/p>\n<h2>Back to Visual Phasing of the X<\/h2>\n<p>Heidi, Sharon, and Lori will all have their X DNA from their paternal grandmother &#8211; Frazer.<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7425\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1167\" height=\"314\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1167w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x81.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x207.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_31_24-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x276.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>I put Frazer on the bottom. That means the maternal side will go on top. For that, I just need to see a few cousin matches. When I choose &#8216;all cousins&#8217;, I see that Anita and her sister have the best X Chromosome matches with my family:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7426\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1426\" height=\"403\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1426w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x85.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x217.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_34_04-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x289.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Anita matches Jim, Sharon, Heidi, and Lori on the right. Anita has smaller matches near the middle of the Chromosome with Sharon and Lori . By comparing the chromosomes on the right, it looks like I can see a crossover for Sharon (at 68M) and Lori. For some reason, the position numbers for the matching comparisons are not all showing at the left.<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7427\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1176\" height=\"754\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1176w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x192.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x492.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_43_42-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x657.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Remember, I said that Lori had a crossover on the right hand side? It shows as my crossover (D or Joel). That means I probably missed a crossover for Lori.<\/p>\n<p>Here is a comparison between Lori and Jim that shows where Lori&#8217;s crossover is:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_53_15-https___www.gedmatch.com_fcgi-bin_ux_compare2.fcgi_kit1A427813kit2T852423cha.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7428\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_53_15-https___www.gedmatch.com_fcgi-bin_ux_compare2.fcgi_kit1A427813kit2T852423cha.png\" alt=\"\" width=\"467\" height=\"111\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_53_15-https___www.gedmatch.com_fcgi-bin_ux_compare2.fcgi_kit1A427813kit2T852423cha.png 467w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_53_15-https___www.gedmatch.com_fcgi-bin_ux_compare2.fcgi_kit1A427813kit2T852423cha-300x71.png 300w\" sizes=\"auto, (max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p>Every carat mark is one million, so Lori&#8217;s crossover is at 142M.<\/p>\n<p>Anita above represents Rathfelder, so I just need to put in Rathfelder everwhere that Anita matches my family.<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7429\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1191\" height=\"752\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1191w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x189.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x485.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-11_59_38-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x647.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>The spreadsheet has a function called Extend, but it didn&#8217;t work for the Rathfelder entries for some reason. I&#8217;ll just extend Rathfelder manually to the crossovers:<\/p>\n<h4>A Problem for Sharon<\/h4>\n<p>I extended Jim, but ran into a problem with Sharon:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7430\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1173\" height=\"316\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1173w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x81.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x207.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_04_02-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x276.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>If I extend Sharon to the right, it goes through a crossover line. A crossover line is where there should be a change from Rathfelder to Lentz. That means that something is wrong. I&#8217;ll just visually phase the brothers:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7431\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1160\" height=\"313\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1160w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x81.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x207.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_27_30-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x276.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Then I will go segment by segment from Jim to his sisters to see where the change is needed.<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7432\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1433\" height=\"799\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1433w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x167.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x428.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-12_42_41-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x571.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>It turns out that I was doing it right, but the two small matches with Anita and Inese were wrong. The common wisdom is to ignore X Chromosome matches under 15 or 20 cM. In my opinion, this is especially true between two females. I find this a bit confusing as three cousins match on those two segments of Sharon and Lori.<\/p>\n<p>So that was supposed to be the &#8216;easy&#8217; Chromosome!<\/p>\n<p>Here is another way of looking at the X Chromosome and cousin match:<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-15_45_49-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7433\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-15_45_49-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"913\" height=\"431\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-15_45_49-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 913w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-15_45_49-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x142.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-15_45_49-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x363.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Jim (V) matches Lori and Sharon at segment S-F as shown by the blue bars above. Sharon and Lori match cousins Anita, Inese and Catherine at the same segment. However, James does not match cousins Anita, Inese or Catherine at the same segment. That is further confirmation that the X Chromosome match Anita has with Lori and Sharon is not good for use in Visual Phasing.<\/p>\n<h2>Checking the Segment Map<\/h2>\n<p>The Fox Spreadsheet also has a Segment Map. This is a check to see if your final results match up with the original Gedmatch comparison. It is not a proof that the visual phasing is right. However, if it does not match, it is pretty good proof that something went wrong.<\/p>\n<p>For the X Chromosome, it only works for the three sisters.<\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7434\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1169\" height=\"499\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1169w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x128.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x328.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_13_37-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x437.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7435\" src=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png\" alt=\"\" width=\"1165\" height=\"128\" srcset=\"http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6.png 1165w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-300x33.png 300w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-768x84.png 768w, http:\/\/www.jmhartley.com\/HBlog\/wp-content\/uploads\/2018\/10\/2018-10-29-16_14_39-DNA-Visual-Phasing-Spreadsheet-V2.3a-Official-1_2018_10_27_182733_Hartley6-1024x113.png 1024w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>The top part is the Gedmatch comparisons with my three sisters. The bottom spreadsheet part should mimic the topgedmatch comparisons if the Visual Phasing is done correctly. Also in Chromosomes other that the X, there will be red sections where there is no matching. When three sister always match on the paternal grandmother, there is no place on the X Chromosome where there is no match.<\/p>\n<h2>Summary and Conclusions<\/h2>\n<ul>\n<li>I had never visually phased my brother Jim except for the X Chromosome. I decided to start the process by working with the Steven Fox Visual Phasing Spreadsheet.<\/li>\n<li>I had never clearly understood why a crossover that looked like it should belong to one sibling could belong to the other two. Using six siblings, it was visually clear how that could happen. The other two siblings have crossovers that are close to each other. In this example, Joel and Jon had crossovers near each other. As a result, they both matched Jim in those close crossovers. This made it look like Jim had one crossover when the three sisters were not considered.<\/li>\n<li>\u00a0A match that three of my sisters had with three cousins made the visual phasing confusing. By re-checking the crossovers and the match between my brother Jim and my three sisters, it became clear that the X Chromosome matches with my sisters that was around 10 cM was either not valid or too ancient to be helpful. In order for these 10 cM cousin matches to be valid there would have had to have been a match with these cousins and my brother Jim also.<\/li>\n<li>Visual Phasing of the X Chromosome is simple in that there are only three grandparents to consider and one grandparent is always the sisters&#8217; paternal grandmother&#8217;s DNA unrecombined. However, there are other issues that can make the visual phasing of the X Chromosome complicated.<\/li>\n<li>I used the segment map to check my work.<\/li>\n<li>The Steven Fox Visual Phasing Spreadsheet is a great tool for Visual Phasing. It is time-saving and a great way to organize your work. For six siblings, it shows the results for those siblings all in one location.<\/li>\n<li>I&#8217;m ready to Visually Phase Jim and the other 5 siblings for Chromosomes 1-22.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>My brother Jim was the last of six siblings to have his DNA tested. As a result, I am behind on phasing his DNA. The Visual Phasing process puts your DNA into four categories. Those four categories correspond to the DNA that you got from your four grandparents. First I used the Steven Fox\u00a0Visual Phasing &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.jmhartley.com\/HBlog\/2018\/10\/29\/visual-phasing-six-siblings-with-the-fox-spreadsheet-part-1-the-x-chromosome-and-a-deceptive-cousin-match\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Visual Phasing Six Siblings with the Fox Spreadsheet: Part 1 &#8211; The X Chromosome and a Deceptive Cousin Match&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7411","post","type-post","status-publish","format-standard","hentry","category-heading"],"_links":{"self":[{"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/posts\/7411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/comments?post=7411"}],"version-history":[{"count":3,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/posts\/7411\/revisions"}],"predecessor-version":[{"id":7436,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/posts\/7411\/revisions\/7436"}],"wp:attachment":[{"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/media?parent=7411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/categories?post=7411"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jmhartley.com\/HBlog\/wp-json\/wp\/v2\/tags?post=7411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}