Vahaduo calcs vol.2

[QUOTE=Ajeje Brazorf;7429965]I would propose, if others agree as well, to replace the entire K13 ancients spreadsheet with this one:

Target: PLogan(superkit) - Proposed K13 Ancient
Distance: 0.5748% / 0.57479796 | ADC: 0.25x RC
48.2 Sweden_Viking.SG
18.2 England_EarlyMedieval_Saxon.SG
10.4 Denmark_Viking.SG
9.4 Germany_EarlyMedieval.SG
8.1 Iceland_Viking.SG
5.7 Hungary_Langobard_sister.SZ14_sister.SZ6


Target: PLogan(superkit) - Old Existing K13 Ancient
Distance: 0.8636% / 0.86360677 | ADC: 0.25x RC
32.1 France_IA_BFM265
26.2 M1489_England_IA.SG_2035_ybp
20.7 I0774_England_Saxon.SG_1483_ybp
11.6 6DT18_England_Roman.SG_1750_ybp
7.3 nuf002_Sigtuna_10_12_century_M_t1a1j_
2.1 I3875_Beaker_South_France_I3875_2_

Quote:

---

Originally Posted by Ajeje Brazorf

I would propose, if others agree as well, to replace the entire K13 ancients spreadsheet with this one:

https://pastebin.com/raw/43AZUZP1
https://pastebin.com/raw/BUEvuPUW

---

I'm waiting for opinion of at least few experienced users. If not I will replace on Sunday.

Quote:

---

Originally Posted by Lucas

...

---

Please replace Tajik_Lowland and Tajik_Mountain for K13 with this single average. A few of those samples were mislabeled and confused

Code:

---

Tajik,9.77,12.89,0.80,36.11,9.68,0.61,14.46,4.67,7.87,2.21,0.34,0.37,0.22

---

And also delete this outdated one from K12b, I've already asked you

Code:

---

Moldovan_South,5.48,1.07,1.32,0.49,25.95,33.71,0.26,0.06,6.56,0.31,24.67,0.12

---

Just a reminder of this little update from pages back please Lucas.

Quote:

---

Originally Posted by Creoda

Updated K13 averages and population weighted averages for England and Scotland:

Code:

---

Cornish,50.74,22.64,14.54,5.18,3.71,0.60,0.82,0.12,0.06,0.70,0.52,0.17,0.14
Dutch_North,50.37,26.37,10.79,4.81,3.13,0.75,0.94,0.38,0.53,0.69,0.47,0.30,0.40
English,49.61,23.53,13.65,5.57,3.99,0.71,1.07,0.15,0.29,0.59,0.42,0.20,0.15
English_Southeast,48.87,23.39,13.79,5.65,4.52,0.76,1.11,0.19,0.31,0.56,0.42,0.22,0.13
French_Brittany,48.53,21.54,16.47,5.04,5.48,0.3,0.79,0.08,0.19,0.98,0.06,0.36,0.15
Irish_Leinster,51.74,22.93,13.11,6.58,2.04,0.63,1.08,0.25,0.12,0.79,0.36,0.16,0.15
Scottish,51.52,23.38,12.78,6.39,2.50,0.48,1.17,0.15,0.28,0.66,0.34,0.19,0.10

---

Rough population based weighting for England:

English_Southeast - 40%
English _North - 30%
English_Midlands - 20%
English_Southwest - 10%

Target: English_new
Distance: 0.0087% / 0.00871614 | ADC: 0.25x RC
49.8 English_Southeast
37.9 English_North
12.3 English_Southwest

Scotland:

Scottish_Southwest - 10/22
Scottish_East - 5/22
Scottish_Northeast - 4/22
Mixed Scottish Average - 2/22
Scottish_North_Highlands - 1/22

Target: Scottish_new
Distance: 0.0255% / 0.02545673 | ADC: 0.25x RC
46.0 Scottish_Southwest
34.3 Scottish_East
16.6 Scottish_Northeast
3.1 Scottish_North-Highlands

---

And could you fix the spelling for Scottish_Gaidhealtachd, some clown put a question mark in the name.

Quote:

---

Originally Posted by Lucas

I'm waiting for opinion of at least few experienced users. If not I will replace on Sunday.

---

Ok. By mistake, I didn't exclude these modern samples from that list.

Code:

---

China_Lahu.DG:S_Lahu-1.DG,0.00,1.21,0.36,0.24,0.00,0.45,3.39,82.61,9.87,0.00,0.50,1.06,0.29
China_Lahu.DG:S_Lahu-2.DG,0.50,0.00,0.00,0.00,0.00,0.00,4.69,87.11,6.05,0.03,1.63,0.00,0.00
China_Lahu.SDG:HGDP01317.SDG,0.00,1.25,0.00,0.00,0.00,0.00,3.52,82.43,11.44,0.20,1.16,0.00,0.00
China_Lahu.SDG:HGDP01318.SDG,0.00,1.33,0.00,0.00,0.00,0.00,5.86,84.97,6.33,0.84,0.00,0.04,0.62
China_Lahu.SDG:HGDP01319.SDG,0.00,1.65,0.00,0.00,0.00,0.00,4.25,87.15,3.70,0.06,1.93,1.27,0.00
China_Lahu.SDG:HGDP01320.SDG,0.52,0.00,0.00,0.00,0.00,0.00,4.76,87.01,6.17,0.00,1.53,0.00,0.00
China_Lahu.SDG:HGDP01321.SDG,0.96,1.57,1.09,0.00,0.00,0.00,2.44,83.15,7.10,0.37,1.91,0.51,0.90
China_Lahu.SDG:HGDP01322.SDG,0.00,2.04,0.00,0.00,0.00,0.46,4.40,83.60,7.56,0.00,1.07,0.00,0.87
China_Lahu.SDG:HGDP01323.SDG,0.00,1.02,0.20,0.27,0.00,0.64,3.70,82.44,9.88,0.00,0.50,1.09,0.26
China_Lahu.SDG:HGDP01326.SDG,0.20,0.00,0.01,0.53,0.00,1.03,2.66,82.18,10.15,2.08,1.16,0.00,0.00
China_Lahu:HGDP01317,0.00,1.26,0.00,0.00,0.00,0.00,3.49,82.60,11.30,0.18,1.17,0.00,0.00
China_Lahu:HGDP01318,0.00,1.47,0.00,0.00,0.00,0.00,5.82,84.78,6.36,0.87,0.00,0.12,0.58
China_Lahu:HGDP01319,1.05,0.84,0.00,0.97,0.00,0.00,3.01,82.63,7.44,1.32,2.60,0.14,0.00
China_Lahu:HGDP01320,0.51,0.00,0.00,0.00,0.00,0.00,4.77,87.03,6.14,0.00,1.55,0.00,0.00
China_Lahu:HGDP01321,1.00,1.66,1.09,0.00,0.00,0.00,2.36,83.27,6.99,0.38,1.93,0.37,0.94
China_Lahu:HGDP01322,0.00,2.24,0.00,0.00,0.00,0.45,4.55,83.63,7.31,0.00,0.97,0.00,0.86
China_Lahu:HGDP01323,0.00,1.03,0.24,0.21,0.00,0.66,3.73,82.41,9.92,0.00,0.50,1.09,0.22
China_Lahu:HGDP01326,0.44,0.00,0.02,0.33,0.00,1.09,2.73,81.99,10.11,2.13,1.16,0.00,0.00
Finland_Saami_Modern.SG:Saami.SG,26.86,47.74,0.00,0.00,0.00,1.12,0.00,1.41,21.67,0.80,0.40,0.00,0.00
Lebanese_Christian:Lebanese1AQ127,3.75,0.00,15.51,21.45,42.84,9.15,2.44,0.33,0.00,0.00,1.33,3.09,0.11
Lebanese_Christian:Lebanese1AQ170,2.01,0.38,16.34,23.25,42.43,12.99,0.00,0.00,0.97,0.00,0.07,1.56,0.00
Lebanese_Christian:Lebanese4AQ115,2.62,0.00,17.72,20.57,46.12,10.68,0.46,0.00,0.00,0.00,0.55,1.08,0.19
Lebanese_Christian:Lebanese6AQ115,2.37,0.16,16.81,20.70,44.45,14.33,0.00,0.00,0.00,0.00,0.00,1.17,0.00
Lebanese_Christian:Lebanese6AQ170,4.94,1.79,12.67,20.22,44.22,12.55,0.48,0.00,0.22,0.39,1.21,1.30,0.00
Lebanese_Christian:Lebanese8AS15,3.49,1.30,17.28,19.82,42.56,11.57,2.85,0.00,0.39,0.00,0.00,0.73,0.00
Lebanese_Christian:Lebanese10AR37,3.31,0.00,17.00,19.90,45.48,10.51,1.86,0.30,0.00,0.00,0.79,0.84,0.00
Lebanese_Christian:Lebanese15AR37,6.02,0.00,15.97,19.77,42.32,12.39,0.00,0.00,1.99,0.00,0.00,0.09,1.45
Lebanese_Christian:Lebanese22BA23,4.56,0.00,15.09,20.57,47.55,7.66,0.02,1.28,0.00,0.22,0.80,2.23,0.00
Lebanese_Muslim:Lebanese2AQ121,2.73,2.23,13.55,18.82,41.96,11.84,3.39,0.00,0.50,0.00,0.46,4.07,0.43
Lebanese_Muslim:Lebanese2AQ127,0.87,5.61,12.30,23.12,36.63,11.74,3.24,0.24,0.00,0.80,0.44,4.62,0.40
Lebanese_Muslim:Lebanese6AS15,5.87,5.11,13.28,20.33,39.23,9.50,2.85,0.00,0.00,0.00,0.00,3.83,0.00
Lebanese_Muslim:Lebanese7AQ150,2.08,3.07,13.03,29.00,37.22,7.73,1.52,0.00,3.63,0.52,0.00,0.80,1.39
Lebanese_Muslim:Lebanese7AR20,4.77,3.79,13.91,21.20,39.09,11.83,2.75,0.19,0.00,0.41,0.15,1.42,0.50
Lebanese_Muslim:Lebanese7AR23,0.00,3.64,17.49,24.90,38.64,10.27,2.07,0.08,0.02,0.00,0.30,2.58,0.00
Lebanese_Muslim:Lebanese10AQ127,0.63,2.05,15.43,18.28,43.42,13.41,2.49,0.33,0.76,0.07,0.00,2.44,0.68
Lebanese_Muslim:Lebanese11AS14,4.46,2.65,16.61,20.09,37.36,14.67,0.00,0.01,0.00,0.07,1.08,2.57,0.43
Lebanese_Muslim:Lebanese20AR21,2.65,2.23,12.32,21.10,47.24,9.20,1.45,0.96,0.00,0.00,0.00,2.85,0.00
Lebanese_Muslim:Lebanese24AR27,2.81,3.62,14.24,23.29,36.23,11.81,2.51,0.00,0.00,1.76,0.00,3.73,0.00
Lebanese_Muslim:Lebanese30AR21,0.00,2.30,14.17,24.72,35.30,12.81,4.45,0.12,0.00,0.50,0.27,4.46,0.89
Mexico_Zapotec.DG:S_Zapotec-1.DG,0.00,0.02,2.89,0.00,0.00,0.00,0.18,2.09,3.70,91.13,0.00,0.00,0.00
Mexico_Zapotec.DG:S_Zapotec-2.DG,0.00,0.00,4.18,0.00,0.00,0.00,1.30,1.89,2.66,89.98,0.00,0.00,0.00
Russia_Abkhasian.DG:S_Abkhasian-1.DG,0.00,0.00,10.61,75.02,10.88,0.00,0.00,1.19,0.00,1.04,0.00,1.26,0.00
Russia_Abkhasian.DG:S_Abkhasian-2.DG,3.07,4.71,9.96,53.62,19.25,3.49,3.30,1.64,0.47,0.00,0.00,0.00,0.50
Russia_Abkhasian:abh107,0.00,0.00,10.76,75.22,10.56,0.00,0.00,1.21,0.00,0.99,0.00,1.27,0.00
Russia_NorthOssetian.DG:S_North_Ossetian-1.DG,4.50,10.04,9.21,52.64,11.79,1.40,2.19,1.40,6.23,0.00,0.00,0.00,0.60
Russia_NorthOssetian.DG:S_North_Ossetian-2.DG,2.71,9.90,11.93,61.28,5.28,0.00,0.00,1.54,6.51,0.15,0.00,0.69,0.00
Russia_NorthOssetian:NorthOssetia5,2.40,10.29,11.94,60.53,5.96,0.00,0.00,1.71,6.49,0.03,0.00,0.65,0.00
Russia_NorthOssetian:NorthOssetia12,4.48,10.25,9.28,52.42,11.88,1.23,2.12,1.54,6.25,0.00,0.00,0.00,0.55

---

Quote:

---

Originally Posted by Lucas

I'm waiting for opinion of at least few experienced users. If not I will replace on Sunday.

---

It looks like these are low quality versions from the reich_HO dataset. I think those which are missing in the current list should be added, but they should be replaced by higher quality versions in the future. I'll try to merge the sheets today.

Quote:

---

Originally Posted by Lucas

I'm waiting for opinion of at least few experienced users. If not I will replace on Sunday.

---

Although I do not consider myself an experienced user, let me express my opinion. If they are taken from HO_public - then they are different from 1240K.public samples. This applies even to good quality samples.

Sungir_6 from 1240K:

Quote:

---

Sungir_6, 25.54,45.75,13.11,4.08,6.12,0.54,0.05,0.11,2.55,1. 07,0.57,0.50,0.01

---

Sungir_6 from HO:

Quote:

---

Sungir_6,26.12,47.38,12.20,0.50,6.11,1.90,0.00,1.3 4,2.53,0.61,0.00,1.31,0.00

---

This is despite the fact that the sample is of good quality, and both databases have a decent number of snips.

I removed duplicate samples, unecessary suffixes like .brother, .sister, .SG, and low qualitiy samples from Komintasavalta's sheet, and replaced HO samples with 1240k where available.
These can be added if everybody agrees.

k13 ancient averages:
https://pastebin.com/jLR2NNNJ

k13 ancient individuals:
part1: https://pastebin.com/bwNidkpb
part2: https://pastebin.com/yMt3n75V

Global25 scaled coordinates simulated with Genoplot from the unofficial spreadsheet of modern Eurogenes K13 populations (to be taken with a grain of salt)

https://pastebin.com/raw/f8VgGQgB

Eurogenes K13 coordinates Genoplot couldn't simulate

Code:

---

English_North,50.43,23.89,13.25,5.51,3.41,0.67,1.00,0.11,0.29,0.60,0.40,0.19,0.18
German_Westphalia,48.90,25.72,11.45,6.87,3.44,0.81,1.08,0.20,0.26,0.57,0.25,0.06,0.39
Persian_Eastcentral,3.29,4.79,3.67,39.54,25.33,5.16,15.06,0.17,1.02,0.62,0.51,0.37,1.89
Sardinian,23.14,1.64,49.58,0.38,22.02,2.41,0,0.13,0.03,0,0.31,0.26,0.1
Scottish,51.37,23.36,12.70,6.44,2.73,0.57,1.18,0.16,0.32,0.63,0.27,0.14,0.05
Scottish_East,51.30,23.28,12.93,6.42,2.73,0.47,1.14,0.15,0.28,0.72,0.34,0.12,0.10
Scottish_North-Highlands,51.33,23.07,13.18,6.37,2.40,0.60,1.03,0.19,0.36,0.84,0.33,0.10,0.19
Scottish_Northeast,51.34,23.90,13.12,6.02,2.29,0.50,1.04,0.26,0.31,0.61,0.27,0.20,0.16
She,0.14,0.16,0.08,0.15,0.05,0.23,0.30,84.56,14.06,0.08,0.03,0.07,0.10
Swedish,48.45,30.99,9.81,3.64,2.43,0.84,1.41,0.21,0.68,0.56,0.40,0.32,0.23
Tujia,0.08,0.06,0.20,0.07,0.09,0.03,0.23,81.06,17.07,0.15,0.54,0.22,0.21
Vietnamese,0.05,1.24,0.02,0.14,0.05,0.24,5.11,86.45,5.20,0.16,1.06,0.16,0.12
Welsh,50.73,23.16,13.73,6.18,2.84,0.53,0.97,0.13,0.32,0.58,0.4,0.25,0.12

---