how to get your parent's raw data without testing them (if you tested at ancestryDNA)

**vbnetkhio** · 08-01-2019, 04:01 PM

Originally Posted by Kaspias

For the people who don't have Ancestry data:

Download DNAStudio(here) and convert your raw data to the Ancestry. Open your converted raw data with notepad+, press ctrl+a, and ctrl+c. Create a new excel file and press ctrl+a and ctrl+v. You will be able to edit columns. Delete the column which allele2 written, copy the column which allele1 written and paste it to the column which you have just deleted and edit its name as allele2. Save it as .csv file (not xlsx) and exit the excel. Open the same file with notepad+, press ctrl+f and replace ; with 3 times of "space". Save the file again as .csv and it should be ready to upload Gedmatch. Then do the same process for allele2.

At least this is how i did it and it worked fine. Probably won't be precise as much as Ancestry testers though.

i'm not sure if that works. because other companies (as far as i know) don't test which allelle is from which parent , they just sort them in the alphabetical order. so in 23andme raw data i have

AG
AG
AG

and in ancestrydna (and in reality) it's

A G
G A
A G

check if you have any snps that aren't in alphabetical order (TC, GA), if you do than it's phased

**Lemgrant** · 08-01-2019, 04:43 PM

result:
file 1

Code:

Admix Results (sorted):

#	Population	Percent
1	Baltic	45.57
2	North_Atlantic	26.55
3	West_Med	10.72
4	East_Med	5.73
5	West_Asian	4.32
6	Sub-Saharan	2
7	Northeast_African	1.32
8	Red_Sea	1.27
9	Siberian	1.25
10	South_Asian	0.64
11	Amerindian	0.57
12	Oceanian	0.05

Single Population Sharing:

#	Population (source)	Distance
1	Ukrainian	4.11
2	Southwest_Russian	4.42
3	Polish	4.59
4	Estonian_Polish	4.67
5	Russian_Smolensk	4.91
6	Ukrainian_Lviv	5.15
7	Ukrainian_Belgorod	5.53
8	Belorussian	5.71
9	South_Polish	5.82
10	Kargopol_Russian	8.5
11	Lithuanian	9.4
12	Estonian	9.99
13	Croatian	10.44
14	Erzya	10.79
15	Finnish	11.74
16	East_Finnish	12.19
17	Southwest_Finnish	12.75
18	Moldavian	13.26
19	Hungarian	14.45
20	East_German	15.84

Mixed Mode Population Sharing:

#	 	Primary Population (source)	Secondary Population (source)	Distance
1	 	92.4%	Estonian_Polish	+	7.6%	Mozabite_Berber	@	1.91
2	 	92.5%	Estonian_Polish	+	7.5%	Tunisian	@	2.06
3	 	92.5%	Estonian_Polish	+	7.5%	Algerian	@	2.07
4	 	92.6%	Estonian_Polish	+	7.4%	Moroccan	@	2.11
5	 	85%	Lithuanian	+	15%	Tunisian	@	2.35
6	 	85.1%	Lithuanian	+	14.9%	Mozabite_Berber	@	2.36
7	 	85%	Lithuanian	+	15%	Algerian	@	2.46
8	 	92.5%	Russian_Smolensk	+	7.5%	Mozabite_Berber	@	2.52
9	 	92.6%	Russian_Smolensk	+	7.4%	Tunisian	@	2.61
10	 	92.5%	Russian_Smolensk	+	7.5%	Algerian	@	2.63
11	 	92.8%	Estonian_Polish	+	7.2%	Algerian_Jewish	@	2.66
12	 	91.5%	Estonian_Polish	+	8.5%	West_Sicilian	@	2.69
13	 	85.3%	Lithuanian	+	14.7%	Moroccan	@	2.69
14	 	92.7%	Russian_Smolensk	+	7.3%	Moroccan	@	2.71
15	 	82%	Lithuanian	+	18%	West_Sicilian	@	2.71
16	 	77.4%	Estonian_Polish	+	22.6%	Moldavian	@	2.72
17	 	91.6%	Estonian_Polish	+	8.4%	East_Sicilian	@	2.72
18	 	84.6%	Lithuanian	+	15.4%	Algerian_Jewish	@	2.72
19	 	92.2%	Estonian_Polish	+	7.8%	South_Italian	@	2.75
20	 	86.8%	Estonian_Polish	+	13.2%	Bulgarian	@	2.76

file 2:

Code:

Admix Results (sorted):

#	Population	Percent
1	Baltic	46.05
2	North_Atlantic	28.12
3	West_Med	11.56
4	West_Asian	5.65
5	East_Med	3.17
6	Amerindian	3.02
7	East_Asian	1.08
8	Siberian	1.04
9	South_Asian	0.29
10	Oceanian	0.01

Single Population Sharing:

#	Population (source)	Distance
1	Polish	3.96
2	Ukrainian	4.17
3	Russian_Smolensk	4.99
4	Estonian_Polish	5.27
5	Ukrainian_Lviv	5.53
6	Southwest_Russian	5.59
7	Ukrainian_Belgorod	6.08
8	South_Polish	6.15
9	Belorussian	6.46
10	Kargopol_Russian	8.25
11	Estonian	8.78
12	Lithuanian	8.85
13	Erzya	11.04
14	Finnish	11.1
15	Croatian	11.33
16	Southwest_Finnish	11.78
17	East_Finnish	11.98
18	Moldavian	14.29
19	Hungarian	14.94
20	East_German	15.59

Mixed Mode Population Sharing:

#	 	Primary Population (source)	Secondary Population (source)	Distance
1	 	97.4%	Polish	+	2.6%	North_Amerindian	@	3.01
2	 	97.7%	Polish	+	2.3%	Pima	@	3.04
3	 	97.7%	Polish	+	2.3%	Mayan	@	3.04
4	 	98%	Polish	+	2%	Karitiana	@	3.06
5	 	75%	Ukrainian	+	25%	Lithuanian	@	3.12
6	 	96.6%	Polish	+	3.4%	West_Greenlander	@	3.15
7	 	97.1%	Polish	+	2.9%	East_Greenlander	@	3.2
8	 	75.6%	Ukrainian	+	24.4%	Estonian	@	3.23
9	 	95.7%	Polish	+	4.3%	MA-1	@	3.42
10	 	84.4%	Polish	+	15.6%	Erzya	@	3.46
11	 	63.3%	Ukrainian	+	36.7%	Estonian_Polish	@	3.48
12	 	80.1%	Polish	+	19.9%	Kargopol_Russian	@	3.5
13	 	65.5%	Ukrainian_Lviv	+	34.5%	Lithuanian	@	3.51
14	 	97.8%	Polish	+	2.2%	Chukchi	@	3.51
15	 	61.3%	Ukrainian	+	38.7%	Russian_Smolensk	@	3.51
16	 	54.9%	Polish	+	45.1%	Ukrainian	@	3.51
17	 	96.8%	Russian_Smolensk	+	3.2%	Mayan	@	3.56
18	 	93.7%	Polish	+	6.3%	Chuvash	@	3.6
19	 	98.1%	Polish	+	1.9%	Koryak	@	3.61
20	 	57.1%	Lithuanian	+	42.9%	Croatian	@	3.63

**Lemgrant** · 08-01-2019, 04:48 PM

+ EUtest

file 1:

Code:

Admix Results (sorted):

#	Population	Percent
1	SOUTH_BALTIC	31.2
2	EAST_EURO	22.89
3	ATLANTIC	13.17
4	NORTH-CENTRAL_EURO	12.95
5	WEST_MED	6.86
6	EAST_MED	4.7
7	MIDDLE_EASTERN	2.76
8	WEST_ASIAN	1.92
9	WEST_AFRICAN	1.37
10	SOUTH_ASIAN	1.25
11	SIBERIAN	0.68
12	EAST_AFRICAN	0.15
13	EAST_ASIAN	0.09

Single Population Sharing:

#	Population (source)	Distance
1	Ukrainian-Russian	5.5
2	UA	5.53
3	West_Russian	5.79
4	Belorussian	6.35
5	PL	6.72
6	Northwest_Russian	6.85
7	LIT	9.82
8	EE	10.13
9	East_Russian	11.76
10	North_Russian	12.23
11	Erzya	13.78
12	HU	14.46
13	East_Finnish	15
14	South_Finnish	15.21
15	AT	18.87
16	Serbian	19.48
17	North_Swedish	20.5
18	RO	20.98
19	Udmurt	22.12
20	Komi	23.12

Mixed Mode Population Sharing:

#	 	Primary Population (source)	Secondary Population (source)	Distance
1	 	88.7%	Northwest_Russian	+	11.3%	Algerian	@	2.9
2	 	88.7%	Northwest_Russian	+	11.3%	Moroccan	@	3.16
3	 	90.4%	Northwest_Russian	+	9.6%	Samaritan	@	3.36
4	 	90.1%	Northwest_Russian	+	9.9%	Mozabite_Berber	@	3.41
5	 	86.2%	Northwest_Russian	+	13.8%	AJ	@	3.41
6	 	87.3%	Northwest_Russian	+	12.7%	South_Italian_&_Sicilian	@	3.5
7	 	89.7%	Northwest_Russian	+	10.3%	IQ	@	3.63
8	 	87.3%	Northwest_Russian	+	12.7%	GR	@	3.63
9	 	78.6%	Northwest_Russian	+	21.4%	RO	@	3.92
10	 	91.1%	Northwest_Russian	+	8.9%	Druze	@	4
11	 	90.8%	Northwest_Russian	+	9.2%	Mandean	@	4.13
12	 	92.4%	Northwest_Russian	+	7.6%	Bedouin	@	4.15
13	 	85.4%	Northwest_Russian	+	14.6%	North_Italian	@	4.17
14	 	87%	Northwest_Russian	+	13%	Tuscan	@	4.17
15	 	91.1%	Belorussian	+	8.9%	Algerian	@	4.23
16	 	91.9%	Belorussian	+	8.1%	Mozabite_Berber	@	4.23
17	 	90.8%	Northwest_Russian	+	9.2%	Assyrian	@	4.25
18	 	78.2%	Northwest_Russian	+	21.8%	Serbian	@	4.35
19	 	91.3%	Belorussian	+	8.7%	Moroccan	@	4.41
20	 	91%	Northwest_Russian	+	9%	Armenian	@	4.42

file 2:

Code:

Admix Results (sorted):

#	Population	Percent
1	SOUTH_BALTIC	29.19
2	EAST_EURO	25.12
3	NORTH-CENTRAL_EURO	21.37
4	ATLANTIC	11.81
5	WEST_MED	6.52
6	WEST_ASIAN	3.35
7	EAST_ASIAN	1.25
8	SIBERIAN	0.81
9	EAST_MED	0.57

Single Population Sharing:

#	Population (source)	Distance
1	Belorussian	5.47
2	Ukrainian-Russian	5.67
3	West_Russian	5.77
4	UA	6.3
5	PL	6.45
6	EE	6.72
7	Northwest_Russian	7.3
8	LIT	9.48
9	East_Russian	9.72
10	South_Finnish	10.39
11	East_Finnish	10.59
12	North_Russian	10.6
13	Erzya	12.65
14	North_Swedish	15.97
15	HU	16.18
16	AT	19.05
17	South_&_Central_Swedish	19.08
18	NO	20.32
19	Serbian	21.29
20	Komi	21.3

Mixed Mode Population Sharing:

#	 	Primary Population (source)	Secondary Population (source)	Distance
1	 	58.8%	Ukrainian-Russian	+	41.2%	EE	@	4.42
2	 	74.7%	Belorussian	+	25.3%	South_Finnish	@	4.45
3	 	83.1%	Belorussian	+	16.9%	North_Swedish	@	4.5
4	 	75.6%	Belorussian	+	24.4%	East_Finnish	@	4.51
5	 	68.8%	UA	+	31.2%	East_Finnish	@	4.58
6	 	73.8%	Ukrainian-Russian	+	26.2%	South_Finnish	@	4.6
7	 	73%	Northwest_Russian	+	27%	North_Swedish	@	4.61
8	 	87.1%	Belorussian	+	12.9%	NO	@	4.62
9	 	77.9%	Northwest_Russian	+	22.1%	NO	@	4.67
10	 	75%	Belorussian	+	25%	East_Russian	@	4.68
11	 	86.7%	Belorussian	+	13.3%	South_&_Central_Swedish	@	4.68
12	 	76.8%	Northwest_Russian	+	23.2%	South_&_Central_Swedish	@	4.7
13	 	89%	Belorussian	+	11%	DK	@	4.75
14	 	80.1%	Northwest_Russian	+	19.9%	DK	@	4.82
15	 	69.5%	UA	+	30.5%	South_Finnish	@	4.84
16	 	84%	Ukrainian-Russian	+	16%	North_Swedish	@	4.87
17	 	90.3%	Belorussian	+	9.7%	NL	@	4.9
18	 	91.2%	Belorussian	+	8.8%	English	@	4.92
19	 	89.8%	Belorussian	+	10.2%	Komi	@	4.94
20	 	86.9%	Ukrainian-Russian	+	13.1%	South_&_Central_Swedish	@	4.95

**Lemgrant** · 08-01-2019, 04:53 PM

looks accurate

**Dorian** · 08-01-2019, 05:01 PM

Could someone create these 2 files for me If easy?no excel...

**Lemgrant** · 08-01-2019, 05:02 PM

Originally Posted by vbnetkhio

i'm not sure if that works. because other companies (as far as i know) don't test which allelle is from which parent , they just sort them in the alphabetical order. so in 23andme raw data i have

AG
AG
AG

and in ancestrydna (and in reality) it's

A G
G A
A G

check if you have any snps that aren't in alphabetical order (TC, GA), if you do than it's phased

AncestryDNA and MyHeritage DNA are currently the only two companies which phase the data before assigning matches. Ancestry has developing its own phasing algorithm known as Underdog. The technical details are provided in the AncestryDNA Matching White Paper. They claim to have an error rate of under 1% and the error rate improves as the size of the training reference dataset increases. As of the beginning of 2016, AncestryDNA uses a reference panel of more than 300,000 genotypes. The details of MyHeritage DNA's phasing is given in the their blog post on major updates and improvements to MyHeritage DNA matching. See also the presentation given by Yaniv Erlich, MyHeritage DNA's Chief Scientific Officer, at Rootstech 2018 MyHeritage DNA 1010: from test to results

Note, however, that if you download the raw data from AncestryDNA or MyHeritage to upload to third-party sites you will receive a file of unphased data.

https://isogg.org/wiki/Phasing

**vbnetkhio** · 08-01-2019, 05:20 PM

Originally Posted by Lemgrant

AncestryDNA and MyHeritage DNA are currently the only two companies which phase the data before assigning matches. Ancestry has developing its own phasing algorithm known as Underdog. The technical details are provided in the AncestryDNA Matching White Paper. They claim to have an error rate of under 1% and the error rate improves as the size of the training reference dataset increases. As of the beginning of 2016, AncestryDNA uses a reference panel of more than 300,000 genotypes. The details of MyHeritage DNA's phasing is given in the their blog post on major updates and improvements to MyHeritage DNA matching. See also the presentation given by Yaniv Erlich, MyHeritage DNA's Chief Scientific Officer, at Rootstech 2018 MyHeritage DNA 1010: from test to results

Note, however, that if you download the raw data from AncestryDNA or MyHeritage to upload to third-party sites you will receive a file of unphased data.

https://isogg.org/wiki/Phasing

hmm.. i'm sure my ancestry raw data is at least partially phased.. i have GCs and CGs, TAs and ATs etc... maybe they started doing that recently