Results 1 to 3 of 3

Thread: Spreadsheet for combBed SNPs and Adamov-based TMRCAs - Hg38 coordinates

  1. #1
    Registered Users
    Posts
    339
    Sex
    Location
    USA
    Nationality
    USA
    Y-DNA (P)
    R1b-L21 L513*

    United States of America Ireland Germany Belgium Wallonia

    Spreadsheet for combBed SNPs and Adamov-based TMRCAs - Hg38 coordinates

    For anyone who used the older "YFull-based SNP Block Age Estimator" spreadsheet, I have updated the combBed regions in that spreadsheet to Hg38 coordinates. The version linked below can be used with any new (i.e. Hg38) SNP position references. Please note the older version of the spreadsheet is valid only for Hg19 coordinate references! This version should be used for any "new" position references.

    The two main uses of the spreadsheet are to narrow down a list of SNPs (by position reference) to what's in YFull's combBed (i.e. one measure of higher quality), and to estimate the age of the given block of SNPs using the method from the Adamov et al paper.

    One additional note - I was horrified a while ago to get a question as to whether this spreadsheet replaces YFull's analysis. Certainly not! There is much more to YFull's analysis than just number of SNPs and TMRCAs. In fact, YFull does a more customized TMRCA calculation based on your specific test's coverage of the combBed (the "Length Coverage for Age" figure), which after their analysis you can also enter in the spreadsheet here to get the same customization. But this spreadsheet is neither a replacement for nor an advertisement for YFull's methods. It simply automates the calculations from the Adamov paper for anyone who wants to apply that method to a phylogenetic block of SNPs.

    Rant over . The combBed was converted to Hg38 using Alex Williamson's list of conversion rules at http://www.ytree.net/hg19tohg38.html so thanks to Alex.

    The Hg38 version of the spreadsheet can be downloaded here: https://drive.google.com/open?id=1xq...zkRD_Cq6BuWV7Z

  2. The Following 2 Users Say Thank You to Dave-V For This Useful Post:

     Iyyovi (02-10-2020),  JMcB (03-14-2018)

  3. #2
    Gold Class Member
    Posts
    347
    Sex
    Location
    Ohio
    Ethnicity
    German
    Nationality
    Galactic Empire
    Y-DNA (P)
    R-Z324, Z5055, L188+
    mtDNA (M)
    H5

    Thanks. But users should beware of the statistical problems associated with the use of small data sets in estimating ages. N=1 is bad. N=100 is OK.

  4. #3
    Registered Users
    Posts
    339
    Sex
    Location
    USA
    Nationality
    USA
    Y-DNA (P)
    R1b-L21 L513*

    United States of America Ireland Germany Belgium Wallonia
    Quote Originally Posted by Cofgene View Post
    Thanks. But users should beware of the statistical problems associated with the use of small data sets in estimating ages. N=1 is bad. N=100 is OK.
    A valid point but it's a criticism of the variance of TMRCA estimates in general, and they are still in high demand. Statistically, even at N=1, 95% of the population should fit within the error range given. Whether that range is meaningful or not to the user is another question.

Similar Threads

  1. World K=8 calculator based on G25 scaled coordinates
    By michal3141 in forum Autosomal (auDNA)
    Replies: 110
    Last Post: 02-22-2021, 02:24 AM
  2. NEW K35 Calculator based on modern G25 spreadsheet
    By michal3141 in forum Autosomal (auDNA)
    Replies: 149
    Last Post: 09-02-2020, 08:24 PM
  3. Replies: 480
    Last Post: 08-27-2019, 06:41 PM
  4. Plot of WHG & S. Eurasian based on K8 Spreadsheet
    By Kurd in forum Autosomal (auDNA)
    Replies: 28
    Last Post: 01-22-2015, 02:21 AM
  5. SNP-based TMRCAs for R1b-U106 and subclades
    By Michał in forum R1b-U106
    Replies: 10
    Last Post: 05-14-2014, 04:55 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
  •