Printable View
Lol don't worry about it mate, i don't think i'll be in the top for anything - In the last IBD run i was a very 'unmatchy' person. So if it's going to slow you down don't worry.Maybe i'll appear in the top 30 somewhere haha.Quote:
Originally Posted by Graham
Cheers though!
Hmm.. I have tried to figure out how to sort ones population averages during an hour now... :P How do you do it? :)
I did mine manually. Just put my row to the top underneath the population names then ordered them by size. Slow but it worked!Quote:
Originally Posted by Jockman
Here's my Top 20 matches:
SAEU1
1 Utah_SE 0.7153422
2 British 0.714668946
3 Spanish_Aragon 0.7146094
4 Dutch 0.714476
5 Utah_Scot 0.714393222
6 Kent 0.714277
7 Irish 0.714188846
8 Norwegian 0.714168364
9 Spanish_Pais_Vasco 0.714166125
10 Utah_DK 0.714140778
11 Utah_UK 0.71407
12 German 0.714009607
13 Utah_DE 0.714007692
14 Orcadian 0.7139797
15 Cornish 0.713913097
16 Polish 0.713851263
17 Lithuanian 0.71382165
18 Swedish 0.713753966
19 White_American 0.713734833
20 French 0.713721095
What is your code? I can quickly do itQuote:
Originally Posted by Jockman
Heres for Sikelot to look at. :P
South Italian Average Top matches
- South_Italian IT17
- South_Italian IT14
- Sardinian HGDP00666
- Tuscan NA20759
- Italian IT26
- Tuscan NA20771
- North_Italian HGDP01173
- Tuscan NA20818
- Greek GR3
- Tuscan NA20586
- Tuscan NA20521
- Tuscan NA20799
- Cyprian GSM536609
- Sardinian HGDP00667
- Tuscan NA20543
- Greek GR4
- Italian IT29
- Tuscan NA20534
- Tuscan NA20754
- Tuscan NA20792
- Cyprian GSM536608
- Tuscan NA20758
- Tuscan NA20524
- Italian IT9
- Tuscan HGDP01163
- Tuscan NA20589
- Sardinian HGDP01072
- Tuscan NA20802
- Tuscan NA20581
- South_Italian IT8
North Italian Average Top Matches
- Sardinian HGDP00666
- North_Italian HGDP01173
- North_Italian HGDP01152
- French FR11
- Tuscan NA20771
- French FR4
- Italian IT29
- Spanish_Pais_Vasco HG01519
- North_Italian HGDP01151
- Spanish_Valencia HG01606
- Tuscan NA20799
- Sardinian HGDP00671
- Tuscan NA20524
- Tuscan NA20586
- Irish IE16
- Tuscan NA20543
- North_Italian HGDP01156
- Tuscan NA20759
- North_Italian HGDP01153
- North_Italian HGDP01155
- French HGDP00511
- North_Italian HGDP01172
- Utah_DE NA12282
- French_Basque HGDP01377
- North_Italian HGDP01171
- Sardinian HGDP00667
- Spanish_Cantabria HG01512
- Cornish HG00253
- Tuscan NA20804
- Tuscan NA20534
Could you do me as well, I'm NO2 :)
SE34Quote:
Originally Posted by Loki
thanks! :)
No it is not slow! Takes a few seconds :)Quote:
Originally Posted by Jackson
When you have copied the two rows above as you described, go to a new page in Excel and go: "Paste special -> Transpose".
Here you go:Quote:
Originally Posted by Jockman
SE34
1 Norwegian 0.714330909
2 Utah_SE 0.7140368
3 Swedish 0.713857929
4 Dutch 0.7136705
5 German 0.713385821
6 Utah_DK 0.713376778
7 Kent 0.713343917
8 British 0.713252054
9 Lithuanian 0.71318025
10 Orcadian 0.7131289
11 Utah_UK 0.713104759
12 Cornish 0.713022452
13 Polish 0.712915368
14 Utah_DE 0.712867923
15 Utah_Scot 0.712719333
16 White_American 0.712686667
17 Ukrainian_Northeast 0.712686
18 Belarusian 0.7126772
19 Irish 0.712613846
20 Ukrainian 0.712601615
Cheers, good sir!Quote:
Originally Posted by Loki
NO2Quote:
Originally Posted by Pallantides
1 Norwegian 0.716639
2 Utah_DK 0.716142333
3 British 0.716140432
4 Irish 0.715954923
5 Swedish 0.715947862
6 Dutch 0.715940833
7 Utah_Scot 0.715686111
8 German 0.715677536
9 Kent 0.715660306
10 Utah_UK 0.715628759
11 Utah_SE 0.7156236
12 Lithuanian 0.71558185
13 White_American 0.715369167
14 Orcadian 0.715323733
15 Cornish 0.715266968
16 Utah_DE 0.715199692
17 Ukrainian 0.714977923
18 Polish 0.714961368
19 Ukrainian_Northeast 0.7148915
20 Hungarian 0.714562875
My eurogenes K37 results, took about 40 mins :
24.79% Iberian
19.68% Italian
7.82% Eastern_British
6.97% Central_European
6.66% West_Mediterranean
5.55% Western_British
4.88% Basque
4.88% East_Mediterranean
4.34% East_Central_Europea
4.28% Mediterranean
3.56% French
1.92% Arabian
1.16% North_Central_Europe
0.83% Finnish
0.82% North_African
0.71% Armenian
0.63% Eastern_European
0.37% East_Balkan
0.11% Volga-Ural
0.03% West_Caucasian
0.00% Amerindian
0.00% Central_African
0.00% East_African
0.00% East_Asian
0.00% East_Central_Asian
0.00% Indo-Chinese
0.00% Malayan
0.00% Near_Eastern
0.00% North_Caucasian
0.00% Northeast_African
0.00% Oceanian
0.00% Pygmy
0.00% Siberian
0.00% South_Asian
0.00% South_Central_Asian
0.00% South_Chinese
0.00% West_African
My Top Areas
- Norwegian
- British
- Dutch
- Kent
- Orcadian
- Cornish
- Irish
- Swedish
- German
- French
Excludes those eejits from Utah & North American.
Haha you really dislike them.Quote:
Originally Posted by Graham
Kind of makes sense given your ancestry?
Here's mine without the Americans:
1 Norwegian 0.715538909
2 British 0.715482361
3 Kent 0.715435722
4 Cornish 0.715374484
5 German 0.715226286
6 Swedish 0.715144448
7 Dutch 0.715142167
8 Irish 0.715078231
9 Orcadian 0.715068967
10 Lithuanian 0.71498725
11 French 0.714918
12 Polish 0.714725579
13 Spanish_Aragon 0.7146836
14 Ukrainian_Northeast 0.714656
15 Spanish_Pais_Vasco 0.71461475
Surprised about the Polish and Lithuanian, and the Spanish being mixed together. Although to be honest my Grandmother is leaning towards the Spanish and my mother's family towards eastern Europe. So it makes sense?
Granny:
17.17% North_Sea
14.75% Finnish
14.06% Iberian
11.12% North_Atlantic
10.96% East_Central_Europea
8.45% Central_European
8.13% Eastern_European
7.03% French
4.31% Italian
1.93% East_Balkan
1.41% Basque
0.67% South_Central_Asian
0.01% Volga-Ural
0.01% North_Caucasian
0.00% Amerindian
0.00% Arabian
0.00% Armenian
0.00% Central_African
0.00% East_African
0.00% East_Asian
0.00% East_Central_Asian
0.00% East_Mediterranean
0.00% Indo-Chinese
0.00% Malayan
0.00% Mediterranean
0.00% Near_Eastern
0.00% North_African
0.00% Northeast_African
0.00% Oceanian
0.00% Pygmy
0.00% Siberian
0.00% South_Asian
0.00% South_Chinese
0.00% West_African
0.00% West_Caucasian
0.00% West_Mediterranean
Could you do SE6?Quote:
Originally Posted by Loki
I'm not sure what to make out of this. When I sorted the Turkish column by highest similarity using just the project participants, there were so many other people before I even got to the 5 placed Turk and there are 20 different Turkish project participants in that IBD data sheet!
Quote:
Turkish
IT17 0.712181974
IT29 0.711911282
TR6 0.711865211
TR3 0.711836868
GE2 0.711796641
GR3 0.711744641
IT26 0.711662487
GR4 0.711565795
GE5 0.711554872
ASY11 0.711551205
RO4 0.711519769
GR6 0.711509513
ASY2 0.711485385
IT14 0.711474154
GR7 0.711444949
IT8 0.711354974
ASY7 0.711273077
IT32 0.711237333
GE8 0.711041615
IT27 0.71103659
GE3 0.711033846
GE4 0.711026179
BS1 0.710994231
TR25 0.710971579
ASY14 0.710951795
IT13 0.710936667
TR15 0.710921184
BAL1 0.710917872
IT12 0.710820846
IT22 0.710810923
GR1 0.710802205
IT38 0.710796538
IT25 0.710754359
IT39 0.710743385
IT16 0.710695205
GE6 0.710692821
US8 0.710654179
IT35 0.710649718
ASY3 0.710644179
IT37 0.710616821
ASY5 0.710609821
IT5 0.710590077
BG1 0.710583974
GRDE1 0.710577231
ASY15 0.710504615
IT15 0.710487077
IT23 0.710481154
GR5 0.710459051
Kurd10 0.710456974
ASY8 0.710441103
GE7 0.710384538
IT1 0.710383692
CH2 0.710378231
TR8 0.710340421
Mom's top 20 populations:
1 Utah_SE 0.7167434
2 Dutch 0.716675
3 Norwegian 0.716429455
4 Utah_DK 0.716335222
5 German 0.716183536
6 British 0.716047568
7 Lithuanian 0.71603175
8 White_American 0.715993889
9 Swedish 0.715975429
10 Irish 0.715972385
11 Utah_UK 0.715963537
12 Kent 0.715895778
13 Orcadian 0.715795467
14 Ukrainian 0.715742308
15 Polish 0.715732684
16 Utah_DE 0.715727
17 Cornish 0.715694323
18 Utah_Scot 0.715489444
19 Ukrainian_Northeast 0.715318167
20 French 0.715228929
I suppose this won't run on gedmatch with oracle? Could someone do PT2 if it's not much trouble?
I posted K37 before, now K36 :
24.93% Iberian
19.79% Italian
8.00% North_Sea
7.08% Central_European
6.66% West_Mediterranean
5.75% North_Atlantic
4.90% Basque
4.87% East_Mediterranean
4.43% East_Central_European
4.26% Mediterranean
3.67% French
1.90% Arabian
0.98% Finnish
0.82% North_African
0.71% Armenian
0.70% Eastern_European
0.41% East_Balkan
0.12% Volga-Ural
0.04% West_Caucasian
0.00% Amerindian
0.00% Central_African
0.00% East_African
0.00% East_Asian
0.00% East_Central_Asian
0.00% Indo-Chinese
0.00% Malayan
0.00% Near_Eastern
0.00% North_Caucasian
0.00% Northeast_African
0.00% Oceanian
0.00% Pygmy
0.00% Siberian
0.00% South_Asian
0.00% South_Central_Asian
0.00% South_Chinese
0.00% West_African
My top 50:
Spanish_Aragon 0.7155386
Dutch 0.715019
Spanish_Pais_Vasco 0.714695125
Spanish_Castilla_Y_Leon 0.714691833
Spanish_Valencia 0.714659333
Spanish 0.714483086
Sardinian 0.714429833
British 0.71439527
Kent 0.714367056
Spanish_Galicia 0.714295875
French 0.714256738
White_American 0.714239778
Spanish_Cataluna 0.7142282
Utah_DE 0.714209769
Cornish 0.714133323
Utah_UK 0.714104222
Utah_SE 0.7140324
Spanish_Baleares 0.714007875
Italian 0.7139905
Tuscan 0.713953455
French_Basque 0.713929429
Irish 0.713904769
North_Italian 0.713805875
Utah_Scot 0.713788889
Spanish_Extremadura 0.7137775
Utah_DK 0.713736333
Norwegian 0.713731818
German 0.713726036
Orcadian 0.713657333
Spanish_Cantabria 0.713519
Bulgarian 0.713381286
Hungarian 0.7133315
Portuguese 0.713284889
Greek 0.713273556
Romanian 0.713116833
Ukrainian_Northeast 0.713111667
Swedish 0.713084621
Spanish_Murcia 0.7129815
Polish 0.712881
Ukrainian 0.712835308
Lithuanian 0.71270385
Belarusian 0.712638
South_Italian 0.71261985
Ukrainian_West 0.712506167
Cyprian 0.712307917
Sephardic_Jewish 0.712173722
Russian 0.711884111
Ashkenazi 0.711730806
Finnish 0.71087785
Moroccan_Jewish 0.710816417
Looks very Western European.
PT2 top 50:Quote:
Originally Posted by Alex Delarge
Spanish_Aragon 0.7154058
Spanish_Pais_Vasco 0.715146375
Spanish_Valencia 0.714934222
Dutch 0.714862167
Spanish 0.7148234
French_Basque 0.714762714
French 0.714756048
Spanish_Cantabria 0.7146225
White_American 0.714596667
Portuguese 0.714587444
Spanish_Castilla_Y_Leon 0.714509667
British 0.714507811
Sardinian 0.714461667
Tuscan 0.71444092
North_Italian 0.714417125
Utah_UK 0.714368593
Spanish_Galicia 0.71436725
Cornish 0.714362419
Spanish_Extremadura 0.7143285
Kent 0.714296389
Irish 0.714278846
German 0.714262643
Utah_Scot 0.714165778
Hungarian 0.714128375
Ukrainian_West 0.714104333
Utah_SE 0.7140566
Spanish_Baleares 0.714056125
Utah_DE 0.714003538
Utah_DK 0.713988111
Spanish_Cataluna 0.7139518
Orcadian 0.713907067
Spanish_Murcia 0.713853333
Italian 0.713812333
Bulgarian 0.713694214
Greek 0.713644889
Swedish 0.713569379
Polish 0.713563316
Ukrainian_Northeast 0.7135245
Romanian 0.713487611
Norwegian 0.713422636
Lithuanian 0.71338375
Ukrainian 0.713351385
Belarusian 0.7132794
South_Italian 0.7132684
Sephardic_Jewish 0.712698333
Russian 0.712618019
Ashkenazi 0.712309778
Cyprian 0.712099167
Armenian 0.711423036
Moroccan_Jewish 0.711356583
Can someone run me?? I'm IT40. Thanks!
IT40Quote:
Originally Posted by Sicilianu101
1 Greek 0.713954889
2 Spanish_Aragon 0.7138144
3 Tuscan 0.713616205
4 Sardinian 0.713568708
5 Cyprian 0.713511583
6 Italian 0.713483917
7 Spanish_Galicia 0.71310075
8 South_Italian 0.713060368
9 North_Italian 0.71302575
10 Spanish_Valencia 0.712938
11 Spanish_Baleares 0.712860125
12 Spanish_Murcia 0.712843333
13 Portuguese 0.7128328
14 Sephardic_Jewish 0.712817944
15 Spanish_Cataluna 0.7127944
16 Spanish 0.7126592
17 Bulgarian 0.712605357
18 French 0.712553976
19 Spanish_Pais_Vasco 0.712469125
20 Spanish_Extremadura 0.712428625
Updated K36, these are suppose to be less noisy and much faster, so i will try them:
https://skydrive.live.com/?cid=5223c...mQBnUpI66ezgpc
I'm so confused. How does this work? What do I do?
If confused it might be best to wait for it to come to gedmatch, this is for "hardcore" DNA geeks...but if you really want to do it, you need to get Dodecad DIY first and then get the files after following those instructions for installing ect:Quote:
Originally Posted by SkyBurn
http://dodecad.blogspot.no/2011/09/d...ecad-v-21.html
& download this.. RQuote:
Originally Posted by evon
http://cran.ms.unimelb.edu.au/
Running mine now, i'll do other family another time or wait for GEDmatch. Have work to be doing.
^^^ Need more to update.. lol
Western Europe North Atlantic, North Sea, French, Basque, Iberian & Italian.
70.79% -- Jackson Gran
67.83% -- Graham
67.04% -- Ibericus
65.99% -- Atlantic Islander
63.80% -- Jackson Dad
63.55% -- Alex Delarge
63.20% -- Jackson Grandad
62.05% -- loki
--------------------------------
58.02% -- Evon Aunt
57.41% -- Evon
55.76% -- Evon Uncle
55.10% -- Evon Gran
52.75% -- Pallantides
50.47% -- Otto Prohaska Wife
50.04% -- Jackson
--------------------------------
48.41% -- Otto Prohaska
48.00% -- Amerinese
42.71% -- Otto Prohaska Dad
35.81% -- Jockman
31.38% -- Jockman Grandad
--------------------------------
18.75% -- Mark
15.93% -- Xyresic
06.58% -- ZephyrousMandaru
East Central Europe -- East Europe, East Central Europe & Central Europe
28.13% -- Otto Prohaska Dad
27.54% -- Evon Gran
27.08% -- Jackson
26.80% -- Otto Prohaska
25.15% -- Otto Prohaska Wife
------------------------------
24.88% -- Jackson Grandad
24.86% -- Jackson Dad
24.61% -- Jockman
24.16% -- Pallantides
23.08% -- Evon
21.41% -- Graham
19.84% -- Evon Aunt
18.73% -- Jackson Gran
18.38% -- loki
18.02% -- Evon Uncle
17.48% -- Jockman Grandad
------------------------------
12.21% -- Ibericus
11.21% -- Alex Delarge
07.01% -- Amerinese
09.87% -- Mark
05.86% -- Atlantic Islander
03.62% -- Xyresic
00.00% -- ZephyrousMandaru
North Eurasia -- Volga Ural, Siberia, Finland
44.71% -- Jockman Grandad
30.81% -- Jockman
------------------------------
22.03% -- Evon Uncle
21.25% -- Evon Aunt
21.17% -- Pallantides
17.74% -- Evon
------------------------------
14.76% -- Evon Gran
14.13% -- Otto Prohaska Dad
11.33% -- Otto Prohaska
10.93% -- Otto Prohaska Wife
10.41% -- Graham
10.16% -- loki
10.06% -- Amerinese
09.30% -- Jackson Grandad
09.29% -- Jackson Dad
06.50% -- Jackson
06.23% -- Jackson Gran
------------------------------
03.87% -- Atlantic Islander
01.75% -- Alex Delarge
01.10% -- Ibericus
00.35% -- Mark
00.00% -- Xyresic
00.00% -- ZephyrousMandaru
I cant see how the new file is faster then the old, its taking forever this time around too...Quote:
Originally Posted by Jackson
the new K36 is radically different from the old K36:
My results:
24.63% North_Sea
16.14% Fennoscandian
14.98% Iberian
12.25% North_Atlantic
7.44% Central_Euro
7.02% Eastern_Euro
6.94% East_Central_Euro
5.64% French
2.18% East_Balkan
2.18% Italian
0.57% Basque
0.03% Volga-Ural
Granny:
21.26% North_Sea
13.87% Fennoscandian
12.18% Iberian
10.49% North_Atlantic
9.75% East_Central_Euro
8.53% Central_Euro
8.03% French
7.89% Eastern_Euro
4.50% Italian
2.01% East_Balkan
1.24% Basque
0.13% South_Central_Asian
0.08% Volga-Ural
0.05% West_Caucasian
0.01% North_Caucasian
Uncle:
22.98% North_Sea
19.93% Fennoscandian
13.64% Iberian
13.60% North_Atlantic
6.33% French
6.06% Central_Euro
5.61% East_Central_Euro
5.21% Eastern_Euro
2.50% East_Balkan
1.70% Italian
1.18% Basque
0.49% West_Med
0.38% Volga-Ural
0.24% West_Caucasian
0.15% South_Central_Asian
Here are mine. Might run others actually. :P
20.87% North_Sea
14.58% North_Atlantic
9.75% Central_Euro
8.77% Iberian
8.67% East_Central_Euro
8.32% Italian
7.56% French
4.94% Fennoscandian
4.03% Eastern_Euro
2.80% Basque
2.66% East_Med
2.54% East_Balkan
2.11% West_Caucasian
1.11% Volga-Ural
0.69% West_Med
0.21% West_African
0.16% South_Central_Asian
0.11% Near_Eastern
0.04% North_African
0.01% Omotic
Looks better for you Jackson..North Sea is more realistic.
Added up Western European. Before it was far too low Jackson in comparison. Now it's above Evon. You Jumped 50.4% to 62.90% & Evon 57.41% to 60.25%.
Makes more sense. :)Quote:
Originally Posted by Graham
Unfortunately you will have to wait for Gedmatch, because you're not a participant of the Eurogenes project (since you just got your 23andme).Quote:
Originally Posted by SkyBurn
New. :) 100% European.
21.63% North_Sea
17.92% North_Atlantic
10.94% Fennoscandian
9.77% French
8.75% Iberian
7.95% Italian
7.84% Central_Euro
5.43% East_Central_Euro
5.23% Eastern_Euro
4.24% Basque
0.29% West_Med
0.00% Amerindian
0.00% Arabian
0.00% Armenian
0.00% Central_African
0.00% East_African
0.00% East_Asian
0.00% East_Balkan
0.00% East_Central_Asian
0.00% East_Med
0.00% Indo-Chinese
0.00% Malayan
0.00% Near_Eastern
0.00% North_African
0.00% North_Caucasian
0.00% Northeast_African
0.00% Oceanian
0.00% Omotic
0.00% Pygmy
0.00% Siberian
0.00% South_Asian
0.00% South_Central_Asian
0.00% South_Chinese
0.00% Volga-Ural
0.00% West_African
0.00% West_Caucasian