Ancient DNA spreadsheet

[nomad01]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://1drv.ms/x/c/b735e500e74aa344/ETv...SdHoxH10mg

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

[venustas]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://onedrive.live.com/view.aspx?resi...upxXlV_Tto

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

[nomad01]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://onedrive.live.com/view.aspx?resi...upxXlV_Tto

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

Also it lacks the Dzuduana haplogroup K

Is that a prediction by Pribislav or another forum member?

[venustas]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://onedrive.live.com/view.aspx?resi...upxXlV_Tto

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

Also it lacks the Dzuduana haplogroup K

Is that a prediction by Pribislav or another forum member?

 I suppose he is probably K? But the quality of the sample is poor.    
https://genarchivist.com/showthread.php?tid=1113&page=2
Yes it was pribislav

[nomad01]

Update:
-Ranis Paleolithic
-Moedling Avar haplogorup assignments
-Origin of Indo-europeans study g25 coordinates

-in column A likely duplicates (same master ID) are marked.
-in column BB, g25 samples are divided into basic clusters (EEF, Yamnaya..)

[nomad01]

Here's a google sheets version:

https://docs.google.com/spreadsheets/d/1...sp=sharing

If somebody wants to help with updating the database, PM me.

[ilabv]

Here's a google sheets version:

https://docs.google.com/spreadsheets/d/1...sp=sharing

If somebody wants to help with updating the database, PM me.

You should also use these, which contain all samples 12% coverage and above (some that are below this threshold as well):

https://www.dropbox.com/scl/fi/0q39lrsyn...o&e=5&dl=0
https://www.dropbox.com/scl/fi/gyeqmlps1...g&e=1&dl=0

Contains many samples that don't exist in the AADR or the other link

[nomad01]

Here's a google sheets version:

https://docs.google.com/spreadsheets/d/1...sp=sharing

If somebody wants to help with updating the database, PM me.

You should also use these, which contain all samples 12% coverage and above (some that are below this threshold as well):

https://www.dropbox.com/scl/fi/0q39lrsyn...o&e=5&dl=0
https://www.dropbox.com/scl/fi/gyeqmlps1...g&e=1&dl=0

Contains many samples that don't exist in the AADR or the other link

They are already in there, but for most of them I haven't yet added additional information, like Y/MT-DNA, study name, etc.

[ChrisR]

Here's a google sheets version:

I found that the active area impacting sorting does include only up until 27015 while there are 27126 lines
BTW: Thx for the effort and sharing it

[nomad01]

Here's a google sheets version:

I found that the active area impacting sorting does include only up until 27015 while there are 27126 lines
BTW: Thx for the effort and sharing it

I see, that seems to be some kind of maximum lengnth imposed automatically by the software. But there is also another sorting function, if you click on the column name above (B, C...) which includes all cells.

[billh]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://1drv.ms/x/c/b735e500e74aa344/ETv...SdHoxH10mg

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

Thank you bro, I might try and use this for a class project lol

[Open Genomes]

An excel spreadsheet of ancient DNA samples, with date, location, Y-DNA, mtDNA, G25 coordinates.

https://onedrive.live.com/view.aspx?resi...upxXlV_Tto

Compiled from indo-european.eu, AADR database, and a dozen recent studies.

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

Also it lacks the Dzuduana haplogroup K

Is that a prediction by Pribislav or another forum member?

I did it and Pribislav posted it. pre-K*.

[nomad01]

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

Also it lacks the Dzuduana haplogroup K

Is that a prediction by Pribislav or another forum member?

I did it and Pribislav posted it. pre-K*.

I added it, I guess the C assignment in the AADR database was copied from Sunghir by mistake?

[venustas]

This lacks the ranis samples can you add them please? Perhaps I can make one of my own if I have the time.
Also it lacks the Dzuduana haplogroup K

Also it lacks the Dzuduana haplogroup K

Is that a prediction by Pribislav or another forum member?

I did it and Pribislav posted it. pre-K*.

An error occurs when I try to access that link

[nomad01]

I have added FTDNA Y-dna assignments for all samples with the help from another user. The link is still the same:
https://docs.google.com/spreadsheets/d/1...drive_link

i reccomend to use the column AL/Y-dna final to sort closely related subclades together. Most of the labels should be correct.