# Last edited on 2019-05-23 09:57:07 by stolfilocal # https://www.biorxiv.org/highwire/filestream/3855/field_highwire_adjunct_files/1/013433-2.xlsx # Rows from data table with dates 2500-1700 BCE S0047 | I0047 | HAL16 | Adelaide | plus | 2 | Unetice_EBA | Halberstadt-Sonntagsfeld | 2022-1937 calBCE | Germany | 51.8900000000000 | 11.0400000000000 | 2731438 | 752991 | 7724 | 65 | 63650 | 54580 | 159.00 | 0.008 | V | 0.999 | [ 0.9953444,0.9998609 ] | 80 | 4091989 | 3617329 | 2893716 | 804344 | 0.026 | 1401 | 1 | 0.78 | 2.04 | 78 | passed | 250 | .. S0811 | I0047 | HAL16 | Adelaide | half | 11 | Unetice_EBA | Halberstadt-Sonntagsfeld | 2022-1937 calBCE | Germany | 51.8900000000000 | 11.0400000000000 | 701875 | 373097 | 2729 | 51 | 544601 | 319348 | 154.00 | 0.122 | V | 1.000 | [ 0.9967931,0.9999728 ] | 60 | 2031309 | 1464192 | 422505 | 111500 | 0.125 | 425 | 0 | 0.24 | 0.28 | 48 | passed | 53 | .. S0049 | I0049 | ESP22 | Adelaide | plus | 2 | Corded_Ware_LN | Esperstedt | 2454-2291 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 6797 | 292 | 2 | 47 | 44640 | 40641 | 119.00 | 0.003 | X2b4 | 1.000 | [ 0.9976945,0.9999817 ] | 75 | 3579496 | 2501780 | 1985046 | 143741 | 0.029 | 556 | 0 | 0.29 | 0.37 | 62 | passed | 1885 | .. S0105 | I0049 | ESP22 | Adelaide | plus | 3 | Corded_Ware_LN | Esperstedt | 2454-2291 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 25144 | 730 | 7 | 55 | 137529 | 106014 | 278.00 | 0.006 | X2b4 | 1.000 | [ 0.9986603,0.9999893 ] | 73 | 2242824 | 1564348 | 1311181 | 147192 | 0.038 | 527 | 0 | 0.29 | 0.37 | 63 | passed | 2100 | .. S0227 | I0058 | BZH4 | Adelaide | plus | 5 | BenzigerodeHeimburg_LN | Benzingerode-Heimburg | 2283-2146 calBCE | Germany | 51.8200000000000 | 10.9100000000000 | 37039 | 1669 | 10 | 40 | 106415 | 67321 | 135.00 | 0.010 | H1e | 0.998 | [ 0.9943749,0.9992037 ] | 55 | 5965256 | 4972823 | 3522935 | 844787 | 0.042 | 1068 | 1 | 0.67 | 2.15 | 53 | passed | 2187 | .. S0812 | I0058 | BZH4 | Adelaide | half | 11 | BenzigerodeHeimburg_LN | Benzingerode-Heimburg | 2283-2146 calBCE | Germany | 51.8200000000000 | 10.9100000000000 | 1261021 | 49830 | 301 | 39 | 683656 | 446292 | 117.00 | 0.098 | H1e | 1.000 | [ 0.9961541,0.9999822 ] | 55 | 1490090 | 819288 | 494594 | 96008 | 0.11 | 316 | 0 | 0.2 | 0.24 | 49 | passed | 1391 | .. S0228 | I0059 | BZH6 | Adelaide | plus | 5 | BenzigerodeHeimburg_LN | Benzingerode-Heimburg | 2286-2153 calBCE | Germany | 51.8200000000000 | 10.9100000000000 | 25794 | 689 | 6 | 45 | 82605 | 53295 | 127.00 | 0.006 | H1/H1b'ad | 0.998 | [ 0.9949915,0.9993036 ] | 60 | 4330140 | 3364371 | 2933130 | 501820 | 0.023 | 1123 | 0 | 0.63 | 1.27 | 68 | passed | 2912 | .. S0813 | I0059 | BZH6 | Adelaide | half | 11 | BenzigerodeHeimburg_LN | Benzingerode-Heimburg | 2286-2153 calBCE | Germany | 51.8200000000000 | 10.9100000000000 | 673687 | 10855 | 73 | 26 | 539388 | 331159 | 229.00 | 0.093 | H1/H1b'ad | 0.999 | [ 0.9930633,0.9997158 ] | 67 | 1449027 | 476380 | 357880 | 96944 | 0.062 | 383 | 1 | 0.21 | 0.25 | 71 | passed | 2279 | .. S0109 | I0060 | ROT3 | Adelaide | plus | 3 | Bell_Beaker_LN | Rothenschirmbach | 2500-2050 BCE | Germany | 51.4500000000000 | 11.5400000000000 | 23484 | 653 | 3 | 47 | 174473 | 132246 | 258.00 | 0.005 | K1a2c | 0.993 | [ 0.9902611,0.9964915 ] | 70 | 3548386 | 2202894 | 1663546 | 62360 | 0.027 | 257 | 0 | 0.14 | 0.16 | 54 | passed | 3670 | .. S0103 | I0103 | ESP16 | Adelaide | plus | 3 | Corded_Ware_LN | Esperstedt | 2566-2477 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 2790227 | 1509872 | 13815 | 56 | 101141 | 61599 | 175.00 | 0.015 | W6a | 0.973 | [ 0.9662224,0.9776750 ] | 61 | 40077139 | 36684002 | 25034855 | 10062749 | 0.03 | 1748 | 1 | 0.96 | 25.55 | 65 | passed | 126 | .. S0660 | I0103 | ESP16 | Adelaide | half | 10 | Corded_Ware_LN | Esperstedt | 2566-2477 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | n/a | n/a | n/a | n/a | 1058501 | 565988 | 506.00 | 0.126 | W6a | 0.976 | [ 0.9689997,0.9805270 ] | 76 | 21496863 | 18903918 | 8853971 | 2564121 | 0.132 | 1726 | 2 | 0.94 | 6.51 | 50 | passed | n/a | .. S0661 | I0103 | ESP16 | Adelaide | half | 10 | Corded_Ware_LN | Esperstedt | 2566-2477 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | n/a | n/a | n/a | n/a | 1370022 | 736265 | 713.00 | 0.122 | W6a | 0.968 | [ 0.9608269,0.9740453 ] | 83 | 24599461 | 21534525 | 10747547 | 3403865 | 0.133 | 1757 | 1 | 0.95 | 8.64 | 52 | passed | n/a | .. S0104 | I0104 | ESP11 | Adelaide | plus | 3 | Corded_Ware_LN | Esperstedt | 2473-2348 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 5889703 | 1970313 | 24979 | 78 | 138845 | 97513 | 267.00 | 0.006 | U4b1a1a1 | 1.000 | [ 0.9985719,0.9999883 ] | 78 | 9211261 | 7940902 | 5580344 | 1505957 | 0.017 | 1451 | 1474 | 0.9 | 3.82 | 79 | passed | 143 | .. S0401 | I0104 | ESP11 | Adelaide | plus | 7 | Corded_Ware_LN | Esperstedt | 2473-2348 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 367752 | 163382 | 2047 | 71 | 110560 | 86649 | 303.00 | 0.006 | .. | 0.995 | [ 0.8902294,0.9992865 ] | 82 | 1170858 | 1021323 | 683824 | 469327 | 0.016 | 698 | 676 | 0.57 | 1.19 | 73 | passed | 105 | .. S0402 | I0104 | ESP11 | Adelaide | plus | 7 | Corded_Ware_LN | Esperstedt | 2473-2348 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 1601993 | 775991 | 11297 | 93 | 89518 | 68316 | 209.00 | 0.015 | U4b1a1a1 | 0.904 | [ 0.8177389,0.9495856 ] | 93 | 3943860 | 3569261 | 2848603 | 600775 | 0.023 | 920 | 932 | 0.71 | 1.53 | 94 | passed | 102 | Manual examination indicates that the apparent signal of mt-DNA contamination is driven by reads aligning to nuclear mitochondrial insertions S0106 | I0106 | ESP26 | Adelaide | plus | 3 | Corded_Ware_LN | Esperstedt | 2454-2291 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 13612 | 322 | 3 | 50 | 195980 | 146859 | 389.00 | 0.008 | T2a1b1 | 1.000 | [ 0.9985374,0.9999871 ] | 77 | 1255958 | 888085 | 746869 | 99757 | 0.044 | 354 | 0 | 0.2 | 0.25 | 61 | passed | 2698 | .. S0108 | I0108 | ROT6 | Adelaide | plus | 3 | Bell_Beaker_LN | Rothenschirmbach | 2497-2436 calBCE | Germany | 51.4500000000000 | 11.5400000000000 | 8443357 | 2484244 | 30790 | 90 | 97918 | 68262 | 146.00 | 0.007 | H5a3 | 0.997 | [ 0.9917046,0.9992383 ] | 76 | 3858323 | 3243855 | 2673841 | 512408 | 0.023 | 1237 | 0 | 0.67 | 1.3 | 94 | passed | 190 | .. S0816 | I0108 | ROT6 | Adelaide | half | 11 | Bell_Beaker_LN | Rothenschirmbach | 2497-2436 calBCE | Germany | 51.4500000000000 | 11.5400000000000 | 1106095 | 460555 | 3322 | 57 | 716789 | 460447 | 266.00 | 0.096 | H5a3 | 0.997 | [ 0.9931615,0.9986173 ] | 67 | 1491906 | 1033297 | 474667 | 133746 | 0.086 | 501 | 0 | 0.28 | 0.34 | 57 | passed | 106 | .. S0111 | I0111 | ROT4 | Adelaide | plus | 3 | Bell_Beaker_LN | Rothenschirmbach | 2414-2333 calBCE | Germany | 51.4500000000000 | 11.5400000000000 | 23670 | 1563 | 12 | 74 | 77241 | 58029 | 192.00 | 0.004 | H3 | 1.000 | [ 0.9975786,0.9999633 ] | 80 | 3701598 | 2958926 | 2578636 | 419675 | 0.023 | 1071 | 2 | 0.59 | 1.07 | 83 | passed | 1374 | .. S0112 | I0112 | QUEXII6 | Adelaide | plus | 3 | Bell_Beaker_LN | Quedlinburg_XII | 2340-2190 calBCE | Germany | 51.7900000000000 | 11.1400000000000 | 6853583 | 3910494 | 51705 | 83 | 203679 | 154883 | 475.00 | 0.008 | H13a1a2 | 0.998 | [ 0.9939945,0.9991429 ] | 90 | 21498151 | 20032946 | 15763483 | 2668335 | 0.015 | 1737 | 2 | 0.96 | 6.78 | 81 | passed | 97 | .. S0113 | I0113 | QUEXII4 | Adelaide | plus | 3 | Bell_Beaker_LN | Quedlinburg_XII | 2290-2130 calBCE | Germany | 51.7900000000000 | 11.1400000000000 | 7801389 | 1136361 | 12328 | 75 | 142178 | 97146 | 151.00 | 0.012 | J1c5 | 0.997 | [ 0.9937015,0.9987303 ] | 73 | 3259712 | 2754148 | 2364017 | 352281 | 0.028 | 1050 | 2 | 0.55 | 0.89 | 81 | passed | 459 | .. S0115 | I0115 | ESP3 | Adelaide | plus | 3 | Unetice_EBA | Esperstedt | 1931-1780 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 11150788 | 2541416 | 18588 | 52 | 535703 | 363903 | 144.00 | 0.020 | U5a1 | 0.972 | [ 0.9645126,0.9777838 ] | 57 | 2714453 | 2430729 | 1801089 | 209591 | 0.03 | 665 | 2 | 0.36 | 0.53 | 58 | passed | 398 | .. S0116 | I0116 | ESP4 | Adelaide | plus | 3 | Unetice_EBA | Esperstedt | 2118-1961 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 8892682 | 7956986 | 95568 | 72 | 177550 | 108782 | 97.50 | 0.019 | W3a1 | 0.965 | [ 0.9588887,0.9705920 ] | 68 | 11538135 | 11229145 | 8075010 | 1615810 | 0.027 | 1302 | 1321 | 0.87 | 4.1 | 78 | passed | 65 | .. S0117 | I0117 | ESP29 | Adelaide | plus | 3 | Unetice_EBA | Esperstedt | 2199-2064 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 9432628 | 2922190 | 31891 | 67 | 106064 | 67628 | 123.00 | 0.006 | I3a | 0.979 | [ 0.9725647,0.9834183 ] | 69 | 3747569 | 3347043 | 2699297 | 750029 | 0.006 | 1352 | 0 | 0.74 | 1.9 | 75 | passed | 213 | .. S0819 | I0117 | ESP29 | Adelaide | half | 11 | Unetice_EBA | Esperstedt | 2199-2064 calBCE | Germany | 51.4200000000000 | 11.6800000000000 | 872273 | 379216 | 2485 | 45 | 751677 | 480806 | 93.80 | 0.119 | I3a | 0.970 | [ 0.9632835,0.9758637 ] | 52 | 1811490 | 1311872 | 574589 | 159514 | 0.092 | 581 | 1 | 0.32 | 0.41 | 48 | passed | 111 | .. S0118 | I0118 | ALB3 | Adelaide | plus | 3 | Alberstedt_LN | Alberstedt | 2459-2345 calBCE | Germany | 51.4500000000000 | 11.6300000000000 | 9062524 | 4643820 | 48032 | 67 | 215472 | 154655 | 391.00 | 0.008 | HV6'17 | 0.989 | [ 0.9831525,0.9933091 ] | 82 | 40405579 | 37683597 | 29370096 | 5910511 | 0.035 | 1785 | 1 | 0.97 | 15.01 | 74 | passed | 137 | .. S0398 | I0118 | ALB3 | Adelaide | plus | 7 | Alberstedt_LN | Alberstedt | 2459-2345 calBCE | Germany | 51.4500000000000 | 11.6300000000000 | 1345830 | 629309 | 7331 | 65 | 72203 | 51790 | 165.00 | 0.008 | HV6'17 | 0.764 | [ 0.4696674,0.8996898 ] | 74 | 16609223 | 14343419 | 8861708 | 2234024 | 0.029 | 1664 | 2 | 0.91 | 5.67 | 65 | passed | 98 | Manual examination indicates that the apparent signal of mt-DNA contamination is driven by reads aligning to nuclear mitochondrial insertions S0274 | I0164 | QUEVIII6 | Adelaide | plus | 6 | Unetice_EBA | Quedlinburg_VIII | 2012-1919 calBCE | Germany | 51.7900000000000 | 11.1400000000000 | 954640 | 318671 | 3075 | 70 | 246042 | 214448 | 475.00 | 0.004 | U5b2a1 | 0.999 | [ 0.9956509,0.9998782 ] | 70 | 14329407 | 12976024 | 10550601 | 1875867 | 0.023 | 1722 | 1 | 0.93 | 4.76 | 73 | passed | 229 | .. S0471 | I0171 | BZH12 | Adelaide | plus | 8 | BenzigerodeHeimburg_LN | Benzingerode-Heimburg | 2204-2136 calBCE | Germany | 51.8200000000000 | 10.9100000000000 | 38329 | 323 | 2 | 35 | 159729 | 123040 | 157.00 | 0.048 | U5a1a2a | 0.999 | [ 0.9969233,0.9999219 ] | 66 | 5999748 | 4891892 | 4129661 | 107104 | 0.063 | 348 | 0 | 0.2 | 0.27 | 59 | passed | 13191 | .. S0803 | I0803 | EUL41 | Adelaide | half | 11 | Unetice_EBA | Eulau | 2115-1996 calBCE | Germany | 51.1676630000000 | 11.8475270000000 | 832371 | 319169 | 2224 | 46 | 489989 | 326404 | 200.00 | 0.114 | H4a1a1 | 0.993 | [ 0.9890610,0.9957563 ] | 63 | 6945881 | 4859309 | 1372025 | 234775 | 0.117 | 714 | 0 | 0.42 | 0.6 | 45 | passed | 74 | .. S0804 | I0804 | EUL57 | Adelaide | half | 11 | Unetice_EBA | Eulau | 2131-1982 calBCE | Germany | 51.1676630000000 | 11.8475270000000 | 745138 | 40102 | 265 | 44 | 618793 | 357769 | 131.00 | 0.077 | H3 | 0.987 | [ 0.9797656,0.9927128 ] | 65 | 997306 | 359867 | 200626 | 28439 | 0.1 | 50 | 72 | 0.07 | 0.07 | 49 | passed | 566 | .. S0806 | I0806 | QLB28 | Adelaide | half | 11 | Bell_Beaker_LN | Quedlinburg_VII | 2296-2206 calBCE | Germany | 51.7900000000000 | 11.1400000000000 | 754524 | 211361 | 1954 | 61 | 611758 | 386565 | 268.00 | 0.091 | H1 | 0.999 | [ 0.9969754,0.9998347 ] | 73 | 7086265 | 3443887 | 995191 | 129321 | 0.075 | 244 | 284 | 0.27 | 0.33 | 56 | passed | 54 | .. S0099 | I0099 | HAL36C | Adelaide | minus | 3 | Halberstadt_LBA | Halberstadt-Sonntagsfeld | 1113-1021 calBCE | Germany | 51.8900000000000 | 11.0400000000000 | 13808 | 4649 | 70 | 79 | 234376 | 149682 | 523.00 | 0.244 | H23 | 0.954 | [ 0.9381630,0.9680522 ] | 87 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | not considered for 390k (UDG- library) | n/a | .. S0272 | I0099 | HAL36C | Adelaide | plus | 6 | Halberstadt_LBA | Halberstadt-Sonntagsfeld | 1113-1021 calBCE | Germany | 51.8900000000000 | 11.0400000000000 | 494900 | 208840 | 2465 | 65 | 398562 | 337905 | 925.00 | 0.003 | H23 | 0.996 | [ 0.9926606,0.9983101 ] | 93 | 21779671 | 20330206 | 15738966 | 3697714 | 0.018 | 1620 | 1676 | 0.95 | 9.39 | 72 | passed | 145 | ..