The data is from table S5 and S4 of Tambets et al. 2018 ("Genes reveal traces of common recent demographic history for most of the Uralic-speaking populations"): https://genomebiology.biomedcentral....059-018-1522-1.
I omitted a few columns where the total percentage among all populations was 4% or less.
In the table for the distribution of Y-DNA haplogroups, there were rows for data about Kets and Selkups from two different sources, but I replaced them with the average value of the rows (not weighted by sample size).
The dendrograms are sorted based on the frequency of haplogroups that are characteristic of East Eurasians. The clustering is done with the hclust function using Euclidean distances and the complete linkage method.
Sources for Y-DNA:
Saami from Sweden (n=73): 1,2,3
Saami from Kola Peninsula (n=23): 4
Finns (n=536): 5,6
Karelians (n=140): this study; updated from 7,8,9
Vepsians (n=39): this study; updated from 7,8,9
Estonians (n=327): 1,2,6
Latvians (n=199): 1,2,6
Lithuanians (n=164): 6
Swedes (n=1188): 3,6
Russians North (n=380): 10
Russians Central (n=364): 10
Russians South (n=484): 10
Hungarians (n=110): 1.2
Mordovians (n=82): 1
Udmurts (n=184): this study; 1,11
Komis (n=135): this study; updated from 7,8,9,12
Maris (n=97): this study; updated from 7,8,9,11
Bashkirs (n=122): this study; updated from 8,9
Chuvashes (n=193): this study; updated from 8,9,11
Tatars (n=207): this study; updated from 8,9,13
Gagauz (Moldova) (n=80): this study; updated from 2
Khanty (n=86): 12,13,14
Mansis (n=25): 14
Nenets (n=148): 12
Enets (n=9): 12
Nganasans (n=38): 12
Selkups (n=131): 12
Selkups (n=43): this study
Yakuts (n=369): 15,13,12
Buryats (n=385): 16,12,13
Mongolians (n=350): 12,17
Kalmyk (n=68): 16,12,13
Even (n=31): 12
Evenks (n=50): 16
Oroqens (n=30): 12,18
Uygurs (n=109): 12,4
Uzbeks (n=78): 12,13
Altaians (n=380): 13,12,16
Chelkans (n=25): 19
Tubulars (n=27): 19
Altai-Kizhi (n=120): 19
Dolgans (n=67): 12
Khakassians (n=228): 7,16
Shors (n=74): 7,16
Tuvinians (n=518): this study; updated from 8,13,16
Turks (n=523): 20
Turkmen (n=30): 4
Kazakhs (n=139): 4,13,12
Kyrgyz (n=91): 12.13
Nogay (Kuban) (n=87): 21
Balkar (n=135): 21
Kumyk (n=73): 21
Kets (n=69): 12.13
Kets (n=22): this study
Nivhkis (n=10): 13
Yukaghirs (n=11): 12
Tadjiks (n=24): 13
1. Tambets et al. (2004). The western and eastern roots of the Saami - The story of genetic "outliers" told by mitochondrial DNA and Y chromosomes. American Journal of Human Genetics 74, 661-682.
2. Rootsi et al. (2004). Phylogeography of Y-chromosome haplogroup I reveals distinct domains of prehistoric gene flow in Europe. American Journal of Human Genetics 75, 128-137.
3. Karlsson et al. (2006). Y-chromosome diversity in Sweden - A long-time perspective. Eur J Hum Genet 14, 963-970.
4. Wells et al. (2001). The Eurasian heartland: a continental perspective on Y-chromosome diversity. Proc Natl Acad Sci U S A 98, 10244-10249.
5. Lappalainen et al. (2006). Regional differences among the finns: A Y-chromosomal perspective. Gene 376, 207-215.
6. Lappalainen et al. (2008). Migration waves to the Baltic Sea region. Annals of Human Genetics 72, 337-348.
7. Rootsi et al. (2007). A counter-clockwise northern route of the Y-chromosome haplogroup N from Southeast Asia towards Europe. Eur J Hum Genet 15, 204-211.
8. Underhill et al. (2010). Separating the post-Glacial coancestry of European and Asian Y chromosomes within haplogroup R1a. Eur J Hum Genet 18, 479-484.
9. Myres et al. (2011). A major Y-chromosome haplogroup R1b Holocene era founder effect in Central and Western Europe. Eur J Hum Genet 19, 95-101.
10. Balanovsky et al. (2008). Two sources of the Russian patrilineal heritage in their Eurasian context. Am J Hum Genet 82, 236-250.
11. Semino et al. (2000). The genetic legacy of Paleolithic Homo sapiens sapiens in extant Europeans: a Y chromosome perspective. Science 290, 1155-1159.
12. Karafet et al. (2002). High levels of Y-chromosome differentiation among native Siberian populations and the genetic signature of a boreal hunter-gatherer way of life. Hum Biol 74, 761-789.
13. Kharkov, V.N.: Structure of Y-chromosomal lineages in Siberian populations. PhD thesis (in Russian). Tomsk, Research Institute of Medical Genetics at the Tomsk Scientific Center, Siberian Division of Russian Academy of Medical Sciences, 2005.
14. Pimenoff et al. (2008). Northwest Siberian Khanty and Mansi in the junction of West and East Eurasian gene pools as revealed by uniparental markers. Eur J Hum Genet 16, 1254-1264.
15. Fedorova et al. (2013). Autosomal and uniparental portraits of the native populations of Sakha (Yakutia): implications for the peopling of Northeast Eurasia. BMC Evol Biol 13, 127.
16. Derenko et al. (2006). Contrasting patterns of Y-chromosome variation in south Siberian populations from Baikal and Altai-Sayan regions. Human Genetics 118, 591-604.
17. Katoh et al. (2005). Genetic features of Mongolian ethnic groups revealed by Y-chromosomal analysis. Gene 346, 63-70.
18. Sengupta et al. (2006). Polarity and temporality of high-resolution y-chromosome distributions in India identify both indigenou
and exogenous expansions and reveal minor genetic influence of Central Asian pastoralists. Am J Hum Genet 78, 202-221.
19. Dulik et al. (2012). Mitochondrial DNA and Y Chromosome Variation Provides Evidence for a Recent Common Ancestry between Native Americans and Indigenous Altaians
(vol 90, pg 229, 2012). American Journal of Human Genetics 90, 573-573.
20. Cinnioglu et al. (2004). Excavating Y-chromosome haplotype strata in Anatolia. Hum Genet 114, 127-148.
21. Yunusbayev et al. (2011). The Caucasus as an Asymmetric Semipermeable Barrier to Ancient Human Migrations. Mol Biol Evol.
Sources for mtDNA:
Estonians (n=409): Loogväli et al. 2004, this study
Finns (n=603): Meinilä et al. 2001; Hedman et al. 2007
Ingrian Finns (n=36): Lappalainen et al. 2008
Karelians (n=595): Lappalainen et al. 2008; this study
Vepsians (n=125): Lappalainen et al. 2008; this study
Saami from Finland (n=69): Lappalainen et al. 2008; Sajantila et al. 1995
Saami from Norway (n=278): Sajantila et al. 1995; Dupuy and Olaisen et al. 1996; Delghandi et al. 1998
Saami from Sweden (n=98): Sajantila et al. 1995; Tambets et al. 2004
Saami from Kola Peninsula (n=86): this study
Maris (n=136): Bermisheva et al. 2002
Mordovians (n=298): Bermisheva et al. 2002; this study
Komis (n=345): Bermisheva et al. 2002; Gubina et al. 2005; this study
Udmurts (n=182): Bermisheva et al. 2002; this study
Hungarians (n=116): this study
Khanty (n=405): Gubina et al. 2005; Pimenoff et al. 2008; Naumova et al. 2009, this study
Mansis (n=199): Derbeneva et al. 2002, Pimenoff et al. 2008; this study
Selkup (n=120): this study
Nenets (n=137): Saillard et al. 2000; this study
Nganasans (n=131): Derbeneva et al. 2002; Goltsova et al. 2005
Tu (n=35): Yao et al. 2002a
Buryat (n=472): Derenko et al. 2003; 2007; Starikovskaya et al. 2005; Gibert et al. 2010
Daur (n=45): Kong et al. 2003
Kalmyk (n=230): Derenko et al. 2007; this study
Mongol (n=262): Kolman et al. 1996; Yao et al. 2002a; 2004; Kong et al. 2003; Derenko et al. 2007
Oroqen (n=44): Kong et al. 2003
Even (n=215): Derenko et al. 1997; Pakendorf et al. 2007; Fedorova et al. 2013
Evenk (n=480): this study; Kong et al. 2003; Starikovskaya et al. 2005; Derenko et al. 2007; Gibert et al. 2010; Fedorova et al. 2013
Hezhen (n=86): this study
Balkar (n=160): Quintana-Murci et al. 2004; this study
Nogay (n=129): Yunusbayev et al. 2010
Kumyk (n=112): this study
Turk (n=478): Quintana-Murci et al. 2004; this study
Gagauz (n=134): this study
Bashkir (n=215): Bermisheva et al. 2002; this study
Chuvash (n=169): Richards et al. 2000; Bermisheva et al. 2002; this study
Tatar (n=196): Bermisheva et al. 2002; Comas et al. 2004
Kazakh (n=572): Yao et al. 2000, 2004; this study
Kyrgyz (n=157): Comas et al. 2004; this study
Turkmen (n=77): Comas et al. 2004; Quintana-Murci et al. 2004; this study
Uzbek (n=259): Quintana-Murci et al. 2004; Yao et al. 2004; this study
Altaian (n=110): Derenko et al. 2003
Tuvinian (n=291): Derenko et al. 2003; 2007; Starikovskaya et al. 2005
Khakas (n=110): Derenko et al. 2003; 2007
Shor (n=82): Derenko et al. 2007
Uyghur (n=166): Yao et al. 2000; this study
Yakut (n=562): Derenko et al. 1997; 2007; Puzyrev et al. 2003; Fedorova et al. 2013
Dolgan (n=156): this study; Fedorova et al. 2013
Latvian (n=411): Lappalainen et al. 2008; Pliss et al. 2006
Lithuanian (n=201): Lappalainen et al. 2008; this study
Swede (n=550): Lappalainen et al. 2008; this study
Russian_North (n=144): this study
Russian_South (n=199): Malyarchuk et al. 2002
Tadjik (n=20): Comas et al. 2004
Ket (n=104): Derbeneva et al. 2002; this study
Nivkhi (n=56): Starikovskaya et al. 2005
Yukaghir (n=100): Volodko et al. 2008
1. this study
2. Bermisheva, M., Tambets, K., Villems, R., and Khusnutdinova, E. (2002). Diversity of mitochondrial DNA haplotypes in ethnic populations of the Volga-Ural region of Russia. Mol Biol 36, 990–1001.
3. Comas, D., Plaza, S., Wells, R.S., Yuldaseva, N., Lao, O., Calafell, F., and Bertranpetit, J. (2004). Admixture, migrations, and dispersals in Central Asia: evidence from maternal DNA lineages. Eur J Hum Genet 12, 495–504.
4. Delghandi, M., Utsi, E., and Krauss, S. (1998). Saami mitochondrial DNA reveals deep maternal lineage clusters. Hum Hered 48, 108–114.
5. Dupuy, B.M., and Olaisen, B. (1996). MtDNA sequences in the Norwegian Saami and main population. In Advances in Forensic Haemogenetics. 6, A. Carracedo, B. Brinkmann, and W. Bär, eds. (Berlin, Heidelberg, New York: Springer-Verlag), pp. 23–25.
6. Fedorova, S.A., Reidla, M., Metspalu, E., Metspalu, M., Rootsi, S., Tambets, K., Trofimova, N., Zhadanov, S.I., Kashani, B., Olivieri, A., et al. (2013). Autosomal and uniparental portraits of the native populations of Sakha (Yakutia): implications for the peopling of Northeast Eurasia. BMC Evol. Biol. 13, 127.
7. Gibert, M., Theves, C., Ricaut, F.X., Dambueva, I., Bazarov, B., Moral, P., Crubezy, E., Perrucho, M., Felix-Sanchez, M., and Sevin, A. (2010). mtDNA variation in the Buryat population of the Barguzin Valley: New insights into the micro-evolutionary history of the Baikal area. Ann. Hum. Biol. 37, 501–523.
8. Goltsova, T.V., Osipova, L., Zhadanov, S., Villems, R, T. V (2005). The Effect of Marriage Migration on the Genetic Structure of the Taimyr Nganasan Population. Russ. J. Genet. 41, 954–965.
9. Губина, М.А., Осипова, Л.П., and Виллемс, Р. (2005). Анализ материнского генофондапо полиморфизму митохондриальной ДНК в популяциях хантов и коми Шурышкарского района ЯНАО. In Коренное Население Шурышкарского Района Ямало-Ненецкого Автономного Округа: Демографические, Генетичесцкие И Медитцинские Аспекты, Л.П. Осипова, ed. (Новосибирск: ART-AVENUE), pp. 105–117.
10. Hedman, M., Brandstätter, A., Pimenoff, V., Sistonen, P., Palo, J.U., Parson, W., and Sajantila, A. (2007). Finnish mitochondrial DNA HVS-I and HVS-II population data. Forensic Sci. Int. 172, 171–178.
11. Kong, Q.-P., Yao, Y.-G., Liu, M., Shen, S.-P., Chen, C., Zhu, C.-L., Palanichamy, M.G., and Zhang, Y.-P. (2003). Mitochondrial DNA sequence polymorphisms of five ethnic populations from northern China. Hum. Genet. 113, 391–405.
12. Naumova, O.I., Khaiat, S.S., and Rychkov, S.I. (2009). [Mitochondrial DNA diversity in Kazym Khanty]. Genetika 45, 857–861.
13. Pakendorf, B., Novgorodov, I.N., Osakovskij, V.L., and Stoneking, M. (2007). Mating patterns amongst Siberian reindeer herders: Inferences from mtDNA and Y-chromosomal analyses. Am. J. Phys. Anthropol. 133, 1013–1027.
14. Pimenoff, V.N., Comas, D., Palo, J.U., Vershubsky, G., Kozlov, A., and Sajantila, A. (2008). Northwest Siberian Khanty and Mansi in the junction of West and East Eurasian gene pools as revealed by uniparental markers. Eur. J. Hum. Genet. 16, 1254–1264.
15. Pliss, L., Tambets, K., Loogvali, E.L., Pronina, N., Lazdins, M., Krumina, A., Baumanis, V., and Villems, R. (2006). Mitochondrial DNA portrait of Latvians: towards the understanding of the genetic structure of Baltic-speaking populations. Ann Hum Genet 70, 439–458.
16. Puzyrev, V.P., Stepanov, V.A., Golubenko, M. V, Puzyrev, K. V, Maximova, N.R., Kharkov, V.N., Spiridonova, M.G., and Nogovitsina, A.N. (2003). MtDNA and Y-Chromosome Lineages in the Yakut Population. Genetika 39, 975–981.
17. Quintana-Murci, L., Chaix, R., Wells, S., Behar, D., Sayar, H., Scozzari, R., Rengo, C., Al-Zahery, N., Semino, O., Santachiara-Benerecetti, A.S., et al. (2004). Where West meets East: The complex mtDNA landscape of the Southwest and Central Asian corridor. Am J Hum Genet 74, 827–845.
18. Sajantila, A., Lahermo, P., Anttinen, T., Lukka, M., Sistonen, P., Savontaus, M.L., Aula, P., Beckman, L., Tranebjaerg, L., Gedde-Dahl, T., et al. (1995). Genes and languages in Europe: an analysis of mitochondrial lineages. Genome Res 5, 42–52.
19. Starikovskaya, E.B., Sukernik, R.I., Derbeneva, O.A., Volodko, N. V, Ruiz-Pesini, E., Torroni, A., Brown, M.D., Lott, M.T., Hosseini, S.H., Huoponen, K., et al. (2005). Mitochondrial DNA diversity in indigenous populations of the southern extent of Siberia, and the origins of Native American haplogroups. Ann. Hum. Genet. 69, 67–89.
20. Tambets, K., Rootsi, S., Kivisild, T., Help, H., Serk, P., Loogvali, E.L., Tolk, H. V, Reidla, M., Metspalu, E., Pliss, L., et al. (2004). The Western and Eastern Roots of the Saami--the Story of Genetic "Outliers" Told by Mitochondrial DNA and Y Chromosomes. Am J Hum Genet 74, 661–682.
21. Yao, Y.-G., Nie, L., Harpending, H., Fu, Y.X., Yuan, Z.-G., and Zhang, Y.-P. (2002). Genetic relationship of Chinese ethnic populations revealed by mtDNA sequence diversity. Am J Phys Anthr. 118, 63–76.
22. Yao, Y.G., Kong, Q.P., Wang, C.Y., Zhu, C.L., and Zhang, Y.P. (2004). Different matrilineal contributions to genetic structure of ethnic groups in the silk road region in china. Mol Biol Evol 21, 2265–2280.
23. Derbeneva, O.A., Starikovskaya, E.B., Wallace, D.C., and Sukernik, R.I. (2002). Traces of early Eurasians in the Mansi of northwest Siberia revealed by mitochondrial DNA analysis. Am J Hum Genet 70, 1009–1114.
24. Derbeneva, O.A., Starikovskaya, E.B., Volod’ko, N. V, Wallace, D.C., and Sukernik, R.I. (2002). [Mitochondrial DNA variation in Kets and Nganasans and the early peoples of Northern Eurasia]. Genetika 38, 1554–1560.
25. Derenko, M. V, and Shields, G.F. (1997). [Diversity of mitochondrial DNA nucleotide sequences in three groups of aboriginal inhabitants of Northern Asia]. Mol Biol 31, 784–789.
26. Derenko, M. V, Grzybowski, T., Malyarchuk, B.A., Dambueva, I.K., Denisova, G.A., Czarny, J., Dorzhu, C.M., Kakpakov, V.T., Miscicka-Sliwka, D., Wozniak, M., et al. (2003). Diversity of mitochondrial DNA lineages in South Siberia. Ann Hum Genet 67, 391–411.
27. Derenko, M., Malyarchuk, B., Grzybowski, T., Denisova, G., Dambueva, I., Perkova, M., Dorzhu, C., Luzina, F., Lee, H.K., Vanecek, T., et al. (2007). Phylogeographic analysis of mitochondrial DNA in northern Asian Populations. Am J Hum Genet 81, 1025–1041.
28. Kolman, C., Sambuughin, N., and Bermingham, E. (1996). Mitochondrial DNA analysis of Mongolian populations and implications for the origin of New World founders. Genetics 142, 1321–1334.
29. Lappalainen, T., Laitinen, V., Salmela, E., Andersen, P., Huoponen, K., Savontaus, M.L., and Lahermo, P. (2008). Migration waves to the Baltic Sea region. Ann. Hum. Genet. 72, 337–348.
30. Loogväli, E.-L., Roostalu, U., Malyarchuk, B.A., Derenko, M. V, Kivisild, T., Metspalu, E., Tambets, K., Reidla, M., Tolk, H.-V., Parik, J., et al. (2004). Disuniting uniformity: a pied cladistic canvas of mtDNA haplogroup H in Eurasia. Mol Biol Evol 21, 2012–2021.
31. Malyarchuk, B.A., Grzybowski, T., Derenko, M. V, Czarny, J., Wozniak, M., and Miscicka-Sliwka, D. (2002). Mitochondrial DNA variability in Poles and Russians. Ann Hum Genet 66, 261–283.
32. Meinilä, M., Finnilä, S., and Majamaa, K. (2001). Evidence for mtDNA admixture between the Finns and the Saami. Hum Hered 52, 160–170.
33. Richards, M., Macaulay, V., Hickey, E., Vega, E., Sykes, B., Guida, V., Rengo, C., Sellitto, D., Cruciani, F., Kivisild, T., et al. (2000). Tracing European founder lineages in the Near Eastern mtDNA pool. Am J Hum Genet 67, 1251–1276.
34. Saillard, J., Evseva, I., Tranebjaerg, L., and Norby, S. (2000). Mitochondrial DNA diversity among Nenets. In Archaeogenetics: DNA and and the Population Prehistory of Europe, C. Renfrew, and K. Boyle, eds. (Cambridge: McDonald Institute for Archaeological Research Monograph Series, Cambridge University), pp. 255–258.
35. Volodko, N. V, Starikovskaya, E.B., Mazunin, I.O., Eltsov, N.P., Naidenko, P. V, Wallace, D.C., and Sukernik, R.I. (2008). Mitochondrial genome diversity in arctic Siberians, with particular reference to the evolutionary history of Beringia and Pleistocenic peopling of the Americas. Am. J. Hum. Genet. 82, 1084–1100.
36. Yao, Y.G., Lu, X.M., Luo, H.R., Li, W.H., and Zhang, Y.P. (2000). Gene admixture in the silk road region of China: evidence from mtDNA and melanocortin 1 receptor polymorphism. Genes Genet Syst 75, 173–178.
37. Yunusbayev, B., Metspalu, M., Järve, M., Kutuev, I., Rootsi, S., Metspalu, E., Behar, D.M., Varendi, K., Sahakyan, H., Khusainova, R., et al. (2012). The Caucasus as an asymmetric semipermeable barrier to ancient human migrations. Mol. Biol. Evol. 29, 359–365.
Code:library(pheatmap) library(colorspace) # for hex() library(vegan) # for reorder.hclust() t=read.csv("https://pastebin.com/raw/aGPQSC24",row.names=1,header=T,check.names=F) # Y-DNA # t=read.csv("https://pastebin.com/raw/MmttxJJM",row.names=1,header=T,check.names=F) # mtDNA t=t[,colSums(t)>=4] wts=t[,"C3 (M217)"]+t[,"N(xN3)1# (M231)"]+t[,"N32# (TAT/M178)"]+t[,"P+Q+R*+R2 (M74/M242/M207/M124)"] # wts=t[,"A"]+t[,"B"]+t[,"C"]+t[,"D"]+t[,"X"]+t[,"Z"] sort=reorder(hclust(dist(t)),wts=wts) pheatmap( t, clustering_callback=function(...){sort}, cluster_cols=F, filename="output.png", legend=F, treeheight_row=80, treeheight_col=80, cellwidth=16, cellheight=16, fontsize=8, border_color=NA, display_numbers=T, number_format="%.0f", fontsize_number=7, number_color="black", breaks=seq(0,100,100/256), colorRampPalette(hex(HSV(c(210,210,120,60,40,20,0),c(0,.5,.5,.5,.5,.5,.5),1)))(256) )