Results 1 to 6 of 6

Thread: R1b-P312xL21 Haplotypes Spreadsheet & SNP Tree

  1. #1
    Registered Users
    Posts
    4,565
    Sex
    Y-DNA (P)
    R1b
    mtDNA (M)
    H

    R1b-P312xL21 Haplotypes Spreadsheet & SNP Tree

    I maintain the R1b-P312xL21_haplotypes spreadsheet of all the confirmed P312+ haplotypes that I can find from public projects. L21 is subclade of P312 but there are too many too include in this file so I save those separately. The P312xL21 spreadsheet is found under the Links section of the R1b-P312-Project Yahoo group under "Haplotype Data". The Links section is in alphabetic order. There is a second file for L21 as well. I do NOT use any robot type programs to copy information from projects. I do it manually and only from public information.

    There is a "Readme" help tab on the far left at the bottom. You may have to hit the left arrow to get to it.

    The "AllHts" tab has all of the haplotypes.

    All Haplotypes are displayed, but only the first 67 STRs per each haplotype.

    The first group of columns provides background information including the kit #, Most Distant Known Ancestor (MDKA) surname, SNP based haplogroup definition, STR signature based variety (cluster) and geographic origin.
    The Hg (haplogroup) column shows a description of the phylogenetic tree branch that the haplotype is on, according to the relevant Downstream SNPs.

    The next group of columns is the first set of STR columns. They are the STR values in FTDNA panel sequence order with each multi-copy element broken out.

    The Relevant SNPs column is a list of directly relevant SNP test results. Only the lowest level (youngest) positive (derived) SNP is shown plus any negative (ancestral) tested SNPs one level younger than the. In additioned, unpositioned (on the tree) SNP results are also shown.

    The second set of STR columns shows only the Genetic Distance (GD) from the Base Haplotype at the top of the screen per each STR. This STR columns are displayed in order from slowest to fastest mutation rate.

    On the far right are three columns that control GD calculations for the distance across all 67 STRs for any haplotype that you select versus all of the other 67 STR length haplotypes in the worksheet. You select the Target haplotype by putting an "x" in the yellow cell next to it. You can only select one haplotype as the target. You can make the target haplotype the modal for a selected set of haplotypes by putting an "x" at the top of the spreadsheet next to the calculated Mode row.

    The last column has the Ysearch IDs where we could find them. You can use Ysearch to directly to contact the owner of the haplotype.

    A statistical summary section is at the bottom of the spreadsheet. The calculations include:
    Allele distribution table per each STR, 1-67
    Count
    Mode per each STR
    Diversity per each STR
    Variance per each STR
    Standard Deviation per each STR
    Mean per each STR
    Sum of the Variance for all 67 STRs

    The blue titled rows are numbers totalled for the whole spreadsheet. The green titled rows are totals for just the selected haplotypes.

    You can use the autofiltering function of the spreadsheet in conjunction with the the green titled totals. Select (filter) to just view the haplotypes you want and the green titled statistics will subtotal for just those selected. Selection is accomplished by using the to the Column heading drop down arrow "autofilter" functionality.


    The "ExtHts" tab has all of the 111 STR haplotypes.

    Extended 111 STRs (only) are displayed on this worksheet. The GD and statistical capabilities are similar to AllHts.


    The "Clades" tab has the SNP/haplogroup tree pointer information and the STR signatures of the deep ancestral varieties assigned.

    Clades has two sections. First, a list of SNPs with associated haplogroup labels. The haplogroup labels on the other worksheets are displayed based on the SNPs in the Downstream SNPs column and how they align with this first table within Clade. This table contains branching depth levels as well as SNPs that need to be translated to other synomous SNPs for consistency purposes

    The second section of Clade is a list of STR based variety labels along with their actual off-modal STR values.


    The "Rates" tab has misc. information.

    This worksheet primarily just contains supplemental information, like mutation rates for STRs. There are a set of columns where the modal values for the largest R1b subclades is kept. WAMH, the Western Atlantic Modal Haplotype, is an obsolete set of modals based on a conglomeration of R1b clades. Effectively, the R1b-P312 modal supersedes it in represent the most common subclade in Western Europe.

  2. The Following User Says Thank You to TigerMW For This Useful Post:

     Fire Haired (09-22-2013)

  3. #2
    Registered Users
    Posts
    4,565
    Sex
    Y-DNA (P)
    R1b
    mtDNA (M)
    H

    I updated the R1b-P312xL21_haplotypes spreadsheet of all the confirmed P312+ haplotypes that I can find from public projects. The L21 is subclade P312 is excluded because there are too many. I save L21 separately. The P312xL21 spreadsheet is found under the Links section of the R1b-P312-Project Yahoo group under "Haplotype Data".

    I've checked the R1b-P312, U152, R1b and SRY2627 files in the last day for this update.

  4. #3
    Registered Users
    Posts
    4,565
    Sex
    Y-DNA (P)
    R1b
    mtDNA (M)
    H

    I've just updated this spreadsheet.

  5. The Following User Says Thank You to TigerMW For This Useful Post:

     MikeWhalen (07-15-2013)

  6. #4
    Registered Users
    Posts
    4,565
    Sex
    Y-DNA (P)
    R1b
    mtDNA (M)
    H

    I just updated the R1b-P312xL21 Haplotypes spreadsheet out under the Links section again under "Haplotype Data"

    This is based on my latest draft phylogenetic trees for P312, DF27 and U152.
    http://tinyurl.com/R1b-P312-Tree
    http://tinyurl.com/R1b-DF27-Tree
    http://tinyurl.com/R1b-U152-Tree

    I added a number of suspected P312+ haplotypes, including DF19 suspects. I tried to take care to classify P312** people into STR based varieties. I also added several L238 suspects, in some cases, not necessarily Norse. Keep in mind they are just suspects.

  7. #5
    Registered Users
    Posts
    4,565
    Sex
    Y-DNA (P)
    R1b
    mtDNA (M)
    H

    Quote Originally Posted by Mikewww View Post
    I just updated the R1b-P312xL21 Haplotypes spreadsheet out under the Links section again under "Haplotype Data"

    This is based on my latest draft phylogenetic trees for P312, DF27 and U152.
    http://tinyurl.com/R1b-P312-Tree
    http://tinyurl.com/R1b-DF27-Tree
    http://tinyurl.com/R1b-U152-Tree
    I updated and uploaded this spreadsheet this morning. We've got a new L238 person or two plus more progression on DF27 (and subclade) testing. We've also got the DF99 guy so P312** dwindles and will have to be redefined to include DF99- soon.

  8. The Following 2 Users Say Thank You to TigerMW For This Useful Post:

     dp (07-17-2014),  Fire Haired (09-22-2013)

  9. #6
    Registered Users
    Posts
    5,080
    Sex
    Location
    Eastern North America
    Ethnicity
    80% Brit/Irish, 19% N Eur
    Nationality
    AMCIT
    aDNA Match (1st)
    I12771 Mid Iron Age Derbyshire England 0.0216
    aDNA Match (2nd)
    I0774 Anglo-Saxon Cambridge England 0.0221
    aDNA Match (3rd)
    VK364 Viking Age Langeland Denmark 0.0228
    Y-DNA (P)
    U152>L2>Z49>Z142>
    mtDNA (M)
    H1bt
    Y-DNA (M)
    I2a2a1b2a1b1>Y4925
    mtDNA (P)
    H37

    England Scotland Wales Germany Palatinate Ireland Leinster Sweden Finns
    Last update I found for this spreadsheet was 12/7/2013. Are more recent versions available or is it no longer being updated?
    Y DNA line continued: Z142>Z12222>FGC12378>FGC12401>FGC12384
    35% English, 15% Scottish, 14% Welsh, 14% German, 11% Ulster Scot, 5% Ireland, 3% Scandinavian, 2% French/Dutch, 1% India
    "Nemo est supra leges."

Similar Threads

  1. Replies: 39
    Last Post: 03-09-2019, 02:44 AM
  2. Haplotypes Network
    By Pannonius in forum Inquiries Corner
    Replies: 0
    Last Post: 12-10-2017, 08:54 PM
  3. R1b-L21 Haplotypes Spreadsheet
    By TigerMW in forum R1b-L21
    Replies: 54
    Last Post: 06-23-2014, 08:10 PM
  4. R1b-Early Subclades Haplotypes Spreadsheet
    By TigerMW in forum R1b Early Subclades
    Replies: 0
    Last Post: 10-18-2013, 04:07 AM
  5. R1b-U106 Haplotypes Spreadsheet
    By TigerMW in forum R1b-U106
    Replies: 4
    Last Post: 09-10-2013, 01:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •