A mí me daba cosa de 1,6%.Quote:
Originally Posted by Defcon2
Printable View
A mí me daba cosa de 1,6%.Quote:
Originally Posted by Defcon2
A ver si podéis verlo y modificarlo.
https://docs.google.com/spreadsheets...it?usp=sharing
Edit: está todo hecho a todo correr, así que si véis algún fallo pues...corregidlo. ;)
Supongo que uno de mis errores es usarme a mí mismo como referencia para probar si da resultados medianamente normales, no debo ser muy normal:
Distance to: gixajo_scaled
0.01793911 Iberian_Peninsula
0.02416049 Iberian_Average2
0.02594884 Popurri_Ibérico
Eres muy vascoide es normal, la mitad de mis coordenadas deben ser de portugueses. Aún así estás más cerca que yo.Quote:
Originally Posted by gixajo
No creo que que uses coordenadas con 8 decimales afecte tanto,no? pero de todas formas, el segundo sample que hice está bastante más cercano a la media en modelos antiguos:Quote:
Originally Posted by Defcon2
Por cierto, aumenta a 8 decimales el formato si quieres usar esa tabla .
Target: Iberian_Average2
Distance: 2.3179% / 0.02317937
54.2 Early_European_Farmer
30.8 Steppe_Pastoralist
10.6 Western_Hunter-Gatherer
4.4 Iberomaurusian
Target: Popurri_Ibérico
Distance: 1.8492% / 0.01849158
53.0 Early_European_Farmer
30.6 Steppe_Pastoralist
11.4 Western_Hunter-Gatherer
5.0 Iberomaurusian
Target: Iberian_Peninsula
Distance: 2.5126% / 0.02512638
55.2 Early_European_Farmer
29.2 Steppe_Pastoralist
12.8 Western_Hunter-Gatherer
2.8 Iberomaurusian
Target: gixajo_scaled
Distance: 2.6934% / 0.02693394
55.6 Early_European_Farmer
28.4 Steppe_Pastoralist
14.2 Western_Hunter-Gatherer
1.8 Iberomaurusian
Se me ha pasado la tarde sin darme cuenta con la tontería :D
Bueno, al menos Defcon2 me ha dejado claro que debo buscar.:thumb001:
https://i.imgur.com/sQc3fh7.png
Edit: qué y cómo.!!!
Cómo copio los números del average una vez hecho? solo me sale la fórmula.Quote:
Originally Posted by gixajo
Me váis a odiar, lo sé.
A ver si mejoramos esas distancias...;)
Code:Western_Iberia,0.102441,0.145729,0.036392,-0.000002,0.037699,-0.000976,-0.004818,-0.004385,0.025770,0.032529,-0.001624,0.011090,-0.012562,-0.014726,0.011469,0.000862,0.000065,-0.000765,-0.007919,-0.002001,0.001622,-0.003524,-0.001910,-0.001325,0.001797
No entiendo...en la línea de abajo deberían salir números que son el resultado de la fórmula, copias todos y pegas en un nuevo post, y luego les añades aquí el nombre, y tieens que quitar un espacio entre cada coordenada y poner una coma.Quote:
Originally Posted by Defcon2
Es un auténtico coñazo, para hacer una simple media, con o sin la tabla mierdosa esa se tarda un huevo.
El office te pone los decimales con punto, luego no funciona la fórmula, cambias el formato, da error... es una pesadilla. Luego cambio a decimales con coma y no me funciona la fórmula porque me sale una comilla simple delante da cada cifra y tengo que borrarlas una a una...:picard1:
Para hacer una mísera media la de vueltas que hay que dar. No sé porqué, ni que hice o dejé de hacer, pero se supone que funcionaba cuando la colgué ahí. ¿Se habrá cambiado algún formato al convertir a archivo a excel desde un odt?
¿No tenemos ningún infomático por aquí?:eek:
Distance to: Juan_scaledQuote:
Originally Posted by gixajo
0.03259993 Western_Iberia
Teneis vicios raros
Sale el número pero no es posible copiarlo pero sí la fórmula, al tocar con el puntero sale algo así: =SUMA(B4:B6)/3.Quote:
Originally Posted by gixajo
Tened paciencia, esto es ir estrechando el cerco poco a poco hasta atinar, tengo dos samples muy buenos para hacer una media que tendría (creo) mejor distancia pero quería probar añadiéndole un poquito de gracia con algo de SSA.
https://i.imgur.com/a1nNPJH.png
Pero esa fórmula te sale en la ventana de fórmula de arriba? No debería verse la fórmula, no entiendo porque pasa eso...Quote:
Originally Posted by Defcon2
Yo estoy usando la tabla original que hice en el open office,no la de excel importada de la original, a mí no me pasa eso.:confused:
me pasan otras cosas diferentes, pero no esa.:picard1:
Es un asco, pero la verdad es que estoy disfrutando, es un asco muy rico.;)
Edit:todo esto nos lo ahorraríamos si alguno nos dijera a qué componente hace referencia cada coordenada, los cambiaríamos a mano hasta dar con samples güenos güenos.
:rolleyes:Quote:
Originally Posted by Defcon2
Mi primer Iberian_Average mezclado con el Basque_Spanish en el modelo que hice de Africa vs Asia vs Europa ,como únicos samples de la península, borrando los 3 que puse, me un daba resultado con una distancia de 1.3 en vez de la distancia de 1.5 del modelo con tres samples Ibéricos previos.Quote:
Originally Posted by Defcon2
Es más, me hizo desaparecer el porcentaje asiático y africano que me salía en el primer resultado, me daba 100% Europeo .;)
Yo creo que ese mismo modelo con tu Sample y alguno de los míos puede ser gracioso probarlo.:D
Lo gracioso es que ahora con la otra tabla tampoco puedo copiar, joder que cosa.Quote:
Originally Posted by gixajo
Probando como se comportan nuestros samples en el modelo de African vs Asian vs Europa.
Si dejo Basque, me acorta la distancia pero me hace aflorar lo no europeo, si lo quito, me hace 100% europeo. :rotfl:
Añadiendo los 4 nuevos samples y quitando todos los anteriores Ibéricos estos son mis resultados:
Target: gixajo_scaled
Distance: 1.6646% / 0.01664574
92.4 European:Iberian_Peninsula
4.2 European:SlavicA
3.4 European:English
Target: gixajo_scaled
Distance: 1.6646% / 0.01664574
100.0 European
Añadiendo los 4 nuevos samples y dejando el Basque_Spanish:
Target: gixajo_scaled
Distance: 1.4209% / 0.01420880
40.8 European:Basque
30.8 European:Iberian_Peninsula
10.8 European:Iberian_Average2
5.8 European:SlavicA
4.8 European:Italian
2.8 European:Croatian
2.0 Asian:Yemenite
1.2 European:Georgian
0.6 Asian:Levantine
0.4 African:Berber
Target: gixajo_scaled
Distance: 1.4209% / 0.01420910
97.0 European
2.6 Asian
0.4 African
Dejo el modelo con los nuevos samples ibéricos con el Basque_Spanish , si queréis quitarlo lo quitáis, si queréis dejarlo lo dejáis.:)Quote:
Distance to: gixajo_scaled
0.01793911 European:Iberian_Peninsula
0.02416049 European:Iberian_Average2
0.02594884 European:Popurri_Ibérico
0.02916098 European:Western_Iberia
0.03475637 European:Basque
0.04156026 European:French
0.04716326 European:Italian
0.06458197 European:German
0.06793278 European:English
0.07323389 European:Croatian
0.07427512 European:Hungarian
0.07433635 European:Irish
0.08279618 European:Greek
0.10386202 European:SlavicA
0.10929737 European:SlavicC
0.11597926 European:SlavicB
0.14702167 Asian:Turkish
0.16603887 Asian:Azeri
0.16945488 Asian:Levantine
0.17255404 Asian:Iranian
0.18385545 European:Georgian
0.21727948 Asian:Arab
0.21862150 Asian:Yemenite
0.23976090 Asian:Balochi
0.33806014 Asian:Hazara
Code:European:Western_Iberia,0.102441,0.145729,0.036392,-0.000002,0.037699,-0.000976,-0.004818,-0.004385,0.025770,0.032529,-0.001624,0.011090,-0.012562,-0.014726,0.011469,0.000862,0.000065,-0.000765,-0.007919,-0.002001,0.001622,-0.003524,-0.001910,-0.001325,0.001797
European:Iberian_Average2,0.108511,0.145898,0.035449,-0.002261,0.043598,-0.002138,-0.003368,-0.000385,0.021816,0.036083,-0.000487,0.010541,-0.012934,-0.015184,0.012577,0.000663,0.004477,-0.004814,-0.002514,-0.000917,-0.001040,-0.003709,-0.004149,-0.001124,-0.002754
European:Popurri_Ibérico,0.104646,0.1449668125,0.0369343125,-0.00218025,0.0422385,-0.0020219375,-0.0034663125,0.004225875,0.0239805,0.030103125,-0.0028215625,0.006154,-0.0118743125,-0.0129968125,0.0093731875,-0.0017236875,-0.0036915625,-0.0015203125,-0.003008875,-0.002211875,-0.0001403125,-0.0019243125,0.0003313125,-0.0025830625,-0.0009205
European:Iberian_Peninsula,0.114392,0.146490,0.040823,-0.000162,0.045311,-0.000697,-0.001765,0.000693,0.023623,0.0365338,-0.001908,0.010303,-0.013639,-0.014691,0.013809,0.001226,0.002282,-0.002534,0.000314,-0.000969,0.00121675,-0.003091,-0.005577,-0.002952,-0.003742
African:Yoruba,-0.6300625,0.0625011,0.022113,0.0167079,0.0005035,0 .0124741,-0.044417,0.0477673,-0.0488813,0.0327694,0.0046205,0.0007904,0.0230561, 0.0009509,0.0125232,-0.0096067,0.0070763,0.0004491,0.006022,-0.00299,0.0015542,0.0023156,-0.0017592,-0.0004711,-0.0004246
European:Italian,0.1213354,0.1473534,0.0208925,-0.0145996,0.0292668,-0.0058844,0.0028435,0.0001615,0.0074653,0.0241279,-0.0002273,0.0063544,-0.0098859,-0.0045141,-0.0015744,-0.0027048,0.0011213,0.0008997,0.0021747,-0.0038269,-0.0025705,0.0018548,-0.0024033,0.0038316,-0.0014967
African:Berber,-0.189857,0.0814452,-0.0242866,-0.085595,0.027636,-0.0552202,-0.0705968,0.0184146,0.155397,0.003499,0.0209156,-0.0318316,0.0747168,-0.0513334,0.0711988,-0.0363032,0.0052676,-0.066106,-0.1424162,0.0389938,-0.0376836,-0.1255322,0.0730118,-0.0137606,0.0164534
European:German,0.1302626,0.1373792,0.0579811,0.0387068,0.0400035,0.0156461,0.0040665,0.0057865,0.003526,0.00188,-0.0044133,0.0023732,-0.0053706,-0.0025417,0.0085125,0.0032913,-0.0032728,0.0016631,0.0033669,0.0017191,0.00314,0.002005,7.18e-05,0.0083052,0.0002774
European:Irish,0.1334042,0.134875,0.0610876,0.0482532,0.0383388,0.0188992,0.003,0.0047738,0.0031318,0.002725,-0.00714,0.005606,-0.0143759,-0.0139278,0.0253478,0.0048208,-0.0110725,0.0022052,0.0007502,0.0013385,0.0051745,0.0012249,-0.0003563,0.0147667,0.0010665
Asian:Levantine,0.0853674,0.1486734,-0.0573978,-0.0925072,-0.0096018,-0.0350286,-0.002209,-0.0081688,0.016321,0.008237,0.0091586,-0.0099212,0.0204854,0.0118632,-0.0055372,0.0021214,-0.011239,0.0010134,0.0021116,-0.003652,-0.0005242,0.003116,0.000567,-0.0029402,0.0046462
Asian:Arab,0.0448462,0.143799,-0.0612444,-0.1170562,-0.0092324,-0.0479134,-0.0110452,-0.0045692,0.053626,-0.007581,0.0147122,-0.0271256,0.0514366,0.0055874,0.0004886,0.0201534,-0.021383,0.00451,0.0025894,0.0183086,0.0114298,0.013132,-0.0067292,0.004651,-0.0054844
Asian:Amerindian,0.0529278,-0.328016,0.1120048,0.0774392,-0.1061738,-0.0184068,-0.1983488,-0.2347978,-0.0037325,-0.020137,0.0082817,-0.0034098,0.0063925,6.87e-05,-0.0151328,-0.004508,-0.0005215,0.0032622,0.0115015,0.0073472,0.0038682,-0.0107578,0.0027115,0.0062055,0.0092805
European:Greek,0.118376,0.1438667,0.0037713,-0.0325153,0.0159003,-0.010412,0.001645,-0.000923,-0.000409,0.018102,0.000108,0.0039467,-0.0058967,0.0037157,-0.016377,0.0023863,0.0134297,0.0003377,0.009176,-0.0007083,-0.0092753,0.003998,0.0013967,-0.0001203,-0.0033927
Asian:Chinese,0.0220816,-0.454551,-0.0059588,-0.067184,0.0749678,0.03224,0.000235,-0.0044306,-0.0137848,0.0022232,-0.0520616,-0.0056348,0.0087414,-0.0073766,-0.005293,0.000106,0.0019038,0.0009374,-0.004148,-0.0133564,0.0203392,0.0022008,0.0134092,-0.0006268,-0.005173
Asian:Iranian,0.0916275,0.1077846,-0.0632191,-0.0225219,-0.045365,0.0040439,0.0018586,-0.005318,-0.028373,-0.0168403,-0.0002509,0.000361,0.0043652,-0.0049418,0.0071253,0.0135542,-0.0035262,0.002885,0.0017313,-0.0087712,-0.0032216,-0.0037657,0.0006777,-0.003489,0.0053669
European:SlavicA,0.1318405,0.1292694,0.0698685,0.0577382,0.0406754,0.0217127,0.0086781,0.0108626,-0.0009329,-0.0185524,-0.0043488,-0.0064187,0.013093,0.0186295,-0.0070244,-0.0005595,0.0015455,-7.41e-05,0.0026948,0.0012872,-0.0031286,-0.0031185,0.0056063,-0.0033328,-8.76e-05
European:SlavicB,0.1308965,0.1216098,0.0735385,0.0608855,0.0360838,0.0225205,0.009694,0.011711,-0.0024542,-0.0240098,0.0008118,-0.0079052,0.017282,0.024359,-0.0136402,-0.0037125,0.0012385,0.0011085,0.0028285,0.0034392,-0.0023708,-0.0032148,0.0023725,-0.0050305,-0.0019758
European:SlavicC,0.1309273,0.1240867,0.0683506,0.0575551,0.0376867,0.0212936,0.0087651,0.0113072,-0.002891,-0.0210999,-0.0016327,-0.0076594,0.0153563,0.0216328,-0.0112354,-0.0010965,0.0046903,-0.0006985,0.0025989,0.0017002,-0.0044989,-0.003479,0.0067387,-0.0040578,0.0007217
Asian:Turkish,0.097275,0.0841327,-0.0305758,-0.0405241,-0.0228443,-0.0133439,0.0035069,-0.0019525,-0.021066,-0.0021728,-0.0002998,0.0027898,-0.0036708,0.0009528,-0.0056584,-0.0015502,0.0006519,0.0011109,0.0010635,-0.0017988,-0.0013438,0.0018834,-0.0018203,-0.0004636,0.0004421
Asian:Azeri,0.0921965,0.0891527,-0.0493829,-0.040613,-0.0361848,-0.0047412,0.0043166,-0.0038378,-0.0282782,-0.0097641,-0.0018205,-0.0002366,0.0007668,-0.0014849,0.0015502,0.0043266,-0.002594,0.0012203,0.0019714,-0.0048904,-0.0002365,-0.0010218,-0.0012131,-0.0022832,0.0008886
African:Bantu,-0.600986,0.062455,0.014708,0.0117895,0.002,0.00753,-0.012338,0.0265375,0.0029655,-0.0244195,-0.0023545,0.013338,-0.0320365,0.003303,-0.0352875,0.025921,-0.015255,-0.0043705,-0.0152725,0.006003,0.00287,-0.0051315,-0.0030195,0.0003615,0.0022155
Asian:Balochi,0.068863,0.0518768,-0.1006282,0.0307388,-0.0726032,0.0314913,0.0055812,0.0015768,-0.0227362,-0.0208053,-0.0038838,-0.002148,0.0039271,-0.0080164,0.0159583,0.0300978,-0.0101374,0.0029245,0.0072694,-0.0265127,-0.0010711,-0.0152092,0.0003698,-0.0160965,0.0137612
Asian:Dong,0.0161882,-0.4507823,-0.0269014,-0.0680812,0.1080886,0.0530821,-0.0002872,-0.0074869,-0.0150439,-0.0095774,-0.021363,-0.0045626,0.0053021,-0.0076609,-0.0034532,0.0017237,0.0043606,-0.0002814,-0.0030168,-0.0116584,0.0161243,0.0068557,0.0160086,-0.0019014,0.0010113
European:English,0.1318551,0.137043,0.0617883,0.044013,0.0392299,0.0167481,0.0049845,0.0057448,0.0052637,0.0056781,-0.0047691,0.0056161,-0.0125892,-0.0103507,0.0206153,0.0035521,-0.0103689,0.004094,0.003685,0.0029619,0.0059369,0.0034036,-0.0032693,0.0137938,3.16e-05
European:French,0.1271714,0.1414355,0.0504313,0.0239901,0.0409027,0.0093048,0.0027985,0.0054544,0.0116022,0.0181739,-0.0077061,0.0068121,-0.0129065,-0.0103844,0.0137695,0.0060631,-0.0018255,0.0046644,0.0027082,-0.0009778,0.0022007,0.0035747,-0.0012325,0.0111405,-0.0019051
European:Georgian,0.108132,0.1332374,-0.0619988,-0.0459952,-0.0383456,-0.0089246,0.0113746,-0.0056768,-0.0639748,-0.0175312,-0.0004546,0.0130384,-0.0251532,0.0072388,0.001873,-0.0238662,0.0070668,-0.0044088,-0.0095026,0.0153074,0.0115046,0.0013602,2.46e-05,-0.0070852,-0.0017964
Asian:Gujarati,0.0513912,-0.0577328,-0.1560525,0.1108222,-0.0805842,0.0621926,-0.0002232,0.0116072,0.033,0.0188524,-0.0064955,8.24e-05,-0.0021779,0.0017408,-0.0006786,0.0003778,0.0008801,-0.0001711,-0.0014267,-0.0039332,0.0014288,-0.0033139,0.0011093,0.0011266,-0.0029757
Asian:Han1,0.0254964,-0.4441926,0.0088248,-0.0643416,0.0505322,0.020415,0.0067212,0.0033692,-0.0136212,0.0037906,-0.076355,-0.01142,0.0121306,-0.0083674,-0.0050218,0,0.0025556,-0.0011656,-0.0014832,-0.004377,0.0109056,0.0073698,0.0085288,-0.001687,-0.001868
Asian:Han2,0.0220816,-0.454551,-0.0059588,-0.067184,0.0749678,0.03224,0.000235,-0.0044306,-0.0137848,0.0022232,-0.0520616,-0.0056348,0.0087414,-0.0073766,-0.005293,0.000106,0.0019038,0.0009374,-0.004148,-0.0133564,0.0203392,0.0022008,0.0134092,-0.0006268,-0.005173
Asian:Hazara,0.0660172,-0.1622816,-0.0037712,0.0005168,-0.0405612,0.0043506,0.007755,0.0059536,-0.0124348,-0.0049568,-0.022637,-0.0029374,0.0022002,-0.0036884,0.0035286,0.0036064,-0.005737,0.0021032,0.0043996,0.0007004,-0.007936,-0.0018052,-0.0059652,-0.0006268,0.0021794
European:Hungarian,0.1270753,0.1296252,0.0553559,0.0364298,0.0363804,0.0119326,0.0066138,0.0075326,0.0020597,-0.0046731,-0.0014731,-0.0027191,0.0038544,0.0087488,-0.0043722,0.0001231,-8.4e-05,-0.0003891,0.0026486,-0.0013221,-0.003378,0.0013865,0.0055286,0.0026939,0.0004789
Asian:Kazakh,0.0676109,-0.2193543,0.0449527,-0.0068153,-0.0360989,-0.0139445,0.0105284,0.0112148,-0.0065242,-0.0015306,-0.0223771,-0.0026377,0.0011002,-0.0012386,0.001425,0.0014985,0.000339,0.000418,0.0016591,0.0059152,-0.0139006,-0.0059476,-0.0084054,0.0005302,0.0011376
African:Kongo,-0.628304,0.064994,0.020365,0.017442,-0.000615,0.016176,-0.016451,0.020076,-0.033746,0.020228,0.008607,-0.003147,-0.001933,0.001514,-0.006786,0.00769,-0.009648,0.00114,0.001257,0.003502,-0.002496,-0.000989,0.001109,-0.001084,-0.006826
Asian:Korean,0.0227267,-0.4546526,0.0184538,-0.0641155,0.0393303,0.0116484,0.0054755,0.0033615,-0.0087399,0.0063599,-0.0745742,-0.008947,0.0103418,-0.0051105,-0.0085052,-0.002559,0.0012865,0.0022087,-0.0005237,-0.0077496,0.0169077,-0.0043938,0.0076947,0.0005381,-0.0173996
Asian:Yemenite,0.0492282,0.1414123,-0.0630735,-0.1155542,-0.0106942,-0.0473418,-0.0094002,-0.0071535,0.0581358,-0.0025965,0.0128692,-0.0314348,0.0573088,0.003888,0.0038,0.0195902,-0.0204703,0.0039908,0.0031738,0.0221358,0.0107002,0.0147148,-0.0130642,0.0085552,-0.008562
Asian:Gujarati,0.0513912,-0.0577328,-0.1560525,0.1108222,-0.0805842,0.0621926,-0.0002232,0.0116072,0.033,0.0188524,-0.0064955,8.24e-05,-0.0021779,0.0017408,-0.0006786,0.0003778,0.0008801,-0.0001711,-0.0014267,-0.0039332,0.0014288,-0.0033139,0.0011093,0.0011266,-0.0029757
African:Ethiopian,-0.4108256,0.0677019,-0.018479,-0.0372957,0.0001025,-0.0225345,0.024864,-0.0243837,0.1059571,-0.0875462,-0.0119303,-0.003367,-0.0153219,-0.0002385,0.0253525,-0.0231944,0.0240254,0.0186992,0.0048015,-0.0091294,-0.0014974,0.004501,-0.0029989,-0.0015904,0.0007504
European:Croatian,0.128051,0.1338467,0.0518917,0.0314925,0.035822,0.0125223,0.0060161,0.0067381,0.0018408,-0.0058862,-0.001153,-0.0023827,0.0047275,0.0127851,-0.0066365,-0.0022011,0.0027512,-0.0007223,0.0018101,-0.0007503,-0.005166,-0.0024236,0.0044246,-0.0010966,0.0001796
European:Basque,0.1319083,0.1504111,0.0582862,0.0090081,0.0575834,0.0001239,-0.0033162,0.0004102,0.0313603,0.0455997,-0.0045288,0.0116063,-0.0227781,-0.0187627,0.0179452,0.0037271,-0.0058094,0.0027731,-0.0018156,-6.96e-05,0.0087901,0.0024868,-0.0068883,-0.0090371,0.0022619
O que é um "popurri ibérico"?
Por cierto, lo que pasa con el Basque en este caso concreto es una de las formas que conocemos todos de cómo dirigir el resultado de un modelo, el efecto que hace en una source meter un sample muy puro o más mezclado en los resultados, hace que a cada "etnia" le salga más o menos "caquita" en sus resultados del "single".
Tenemos que hacer un decálogo de como "manipular" los resultados de un modelo para "dirigirlo" a lo que nos interese en cada momento.;)
Odio a la gente que usa comillas.
Popurri= mezcla.Quote:
Originally Posted by Brás Garcia de Mascarenhas
Se suele usar por ejemplo en un disco de música con canciones de estilos diferentes.
Que palavra mais estranha, não temos nada idêntico em Português. Aqui diríamos "mistura" ou "miscelânea".Quote:
Originally Posted by gixajo
Code:Target: Viriato_scaled
Distance: 1.9630% / 0.01963017
95.8 European
3.2 Asian
1.0 African
Code:Target: Viriato_scaled
Distance: 1.9630% / 0.01963017
84.8 European:Popurri_Ibérico
6.2 European:Basque
3.6 European:SlavicA
3.2 Asian:Levantine
1.2 European:Georgian
1.0 African:Berber
Si le quitas el Basque te sube el % Europeo total y te baja la distancia o contigo se comporta diferente?Quote:
Originally Posted by Brás Garcia de Mascarenhas
Popurri viene del francés, "pot pourri", es un plato de cocina típico de nombre similar al español "olla podrida", no sé que ingredientes tiene, pero supongo que tendrá una mezcla de muchos ingredientes diferentes, y de ahí que se use la palabra con un significado parecido a mezcla.
Sem a referência Basca:Quote:
Originally Posted by gixajo
Code:Target: Viriato_scaled
Distance: 1.9658% / 0.01965833
96.6 European
3.0 Asian
0.4 African
Code:Target: Viriato_scaled
Distance: 1.9658% / 0.01965833
94.0 European:Popurri_Ibérico
3.0 Asian:Levantine
2.6 European:SlavicA
0.4 African:Berber
Quais são os vossos resultados para a datasheet "Global25 datasheet modern scaled" (4º link a contar do fim)?
http://eurogenes.blogspot.com/2019/0...obal25_12.html
Depois tentem Aggregate Yes ou No, a diferênça não é muita mas com Yes fica mais legível.
Têm algo sem sentido como eu? :confused:
Target: Gil_Vicente
Distance: 0.4299% / 0.00429911
17.6 Irish
12.2 Spanish_Andalucia
12.0 Basque_French
10.8 Sardinian
9.0 Swiss_French
7.8 French_Corsica
4.6 Spanish_Galicia
4.0 Italian_Aosta_Valley
3.8 Belgian
3.6 Italian_Campania
2.2 Moroccan_South
2.0 Mandenka
1.8 Moroccan_North
1.8 Dutch
1.6 Iraqi_Jew
1.2 Spanish_Penedes
1.0 Spanish_Girona
0.8 Spanish_Canarias
0.6 Iranian_Lor
0.6 Iranian_Mazandarani
0.6 Papuan
0.4 Iranian_Jew
Target: Pedro_scaled
Distance: 1.8115% / 0.01811478
79.4 European: Popurri_Ibérico
11.8 European:English
3.4 Asian:Arab
1.4 African:Yoruba
1.2 African:Berber
1.2 European:SlavicB
1.0 African:Ethiopian
0.6 Asian:Amerindian
Distance to: Pedro_scaled
0.02810010 European: Popurri_Ibérico
0.03226640 European:Western_Iberia
0.03970819 European:Iberian_Average2
0.04318802 European:Iberian_Peninsula
0.05393110 European:Italian
0.06081389 European:French
0.06864857 European:Basque
0.07645635 European:German
0.07939769 European:Croatian
0.07980513 European:Hungarian
0.08156023 European:English
0.08158773 European:Greek
0.08680372 European:Irish
0.11002013 European:SlavicA
0.11381339 European:SlavicC
0.11980625 European:SlavicB
0.13105188 Asian:Turkish
0.14920158 Asian:Azeri
0.15360365 Asian:Levantine
0.15690623 Asian:Iranian
0.17410277 European:Georgian
0.19575869 Asian:Arab
0.19845876 Asian:Yemenite
0.22390161 Asian:Balochi
0.32314530 Asian:Hazara
Te sube el Europeo, similar distancia un pelín peor, y el Basque actúa sobre todo sobre componentes Africanos.
Por cierto, al final a Georgia la tuve que poner en Asia, se quejaron tres personas.:picard1:
El popurri Ibérico de defcon es maravilloso...
Igual solo con el popurri como sample Ibérico sobra.
É um trilião de amostras por isso é normal. Nestes casos faz sentido adicionar no mínimo uma penalidade de 0.25x. Certamente a distância continuará a ser bastante aceitável e os resultados farão mais sentido.Quote:
Originally Posted by Damião de Góis
Ok, 0.25X sempre fez diferença:Quote:
Originally Posted by Brás Garcia de Mascarenhas
Target: Gil_Vicente
Distance: 0.8114% / 0.00811402 | ADC: 0.25x
43.0 Spanish_Andalucia
16.8 Italian_Aosta_Valley
8.8 Spanish_Alacant
8.4 Spanish_Canarias
6.8 Spanish_Barcelones
6.0 Spanish_Mallorca
3.6 Spanish_Galicia
2.8 Portuguese
2.4 Belgian
0.8 Esan_Nigeria
0.4 Italian_Campania
0.2 Papuan
Quote:
Originally Posted by Damião de Góis
Target: Endovelicus_scaled
Distance: 0.3599% / 0.00359924
17.6 Portuguese
13.0 Spanish_Eivissa
7.0 Spanish_Galicia
6.4 BedouinB
6.2 Basque_Spanish
6.0 Spanish_Navarra
5.6 Spanish_Mallorca
5.6 Spanish_Penedes
5.2 French_Auvergne
4.8 German
4.6 Basque_French
3.8 Sardinian
2.8 Spanish_Barcelones
2.2 Esan_Nigeria
2.0 Irish
1.8 Dutch
1.6 Berber_MAR_ERR
1.4 Spanish_Menorca
1.0 Egyptian
0.8 Moroccan_South
0.4 Mbuti
0.2 Spanish_Peri-Barcelona
Target: Endovelicus_scaled
Distance: 0.9402% / 0.00940158 | ADC: 0.25x
39.2 Spanish_Canarias
18.8 Spanish_Menorca
15.8 Portuguese
12.4 Spanish_Eivissa
6.6 Spanish_Barcelones
1.6 French_Provence
1.2 Esan_Nigeria
1.0 Belgian
1.0 Egyptian
1.0 Spanish_Navarra
0.8 French_Auvergne
0.6 Libyan
Code:Distance to: Endovelicus_scaled
0.02452146 Spanish_Canarias:CAN956
0.02675684 Portuguese:EBC_Portugal12
0.02698153 Spanish_Canarias:HG01694
0.02786214 Spanish_Extremadura:HG01527
0.02859786 Spanish_Extremadura:HG01509
0.02930387 Spanish_Galicia:HG01704
0.02958276 Spanish_Canarias:CAN11
0.03023284 Spanish_Canarias:CAN12
0.03101439 Spanish_Andalucia:AND86
0.03116706 Spanish_Castilla_Y_Leon:HG01501
0.03139380 Portuguese:EBC_Portugal7
0.03160617 Portuguese:EBC_Portugal10
0.03183564 Spanish_Canarias:CAN1220
0.03184663 Spanish_Canarias:CAN884
0.03187895 Spanish_Andalucia:HG01623
0.03204694 Spanish_Andalucia:AND77
0.03227587 Spanish_Galicia:GAL8
0.03237256 Portuguese:EBC_Portugal9
0.03253587 Spanish_Menorca:FER054
0.03254983 Portuguese:Portugal6
0.03299299 Spanish_Andalucia:HG01620
0.03338011 Spanish_Andalucia:AND2
0.03347340 Spanish_Canarias:CAN9
0.03352572 Portuguese:Portugal9
0.03360065 Portuguese:Portugal8
Code:Target: Viriato_scaled
Distance: 1.4861% / 0.01486100 | ADC: 0.25x
29.2 Spanish_Asturias
29.0 Spanish_Castilla_Y_Leon
20.0 Italian_Liguria
17.8 Spanish_Andalucia
2.4 Berber_Tunisia_Chen
1.6 Balochi
Code:Distance to: Viriato_scaled
0.02025617 Spanish_Andalucia
0.02098579 Spanish_Castilla_Y_Leon
0.02304137 Spanish_Galicia
0.02367662 Portuguese
0.02576491 Spanish_Extremadura
0.02644135 Spanish_Castilla_La_Mancha
0.02671431 Spanish_Eivissa
0.02685793 Spanish_Valencia
0.02733046 Spanish_Menorca
0.02743867 Spanish_Alacant
0.02750163 Spanish_Murcia
0.02759535 Spanish_Asturias
0.02907036 Spanish_Terres_de_l'Ebre
0.03063586 Spanish_Cataluna
0.03071827 Spanish_Baleares
0.03077932 Spanish_Aragon
0.03141076 Spanish_Barcelones
0.03169606 Spanish_Mallorca
0.03191545 Spanish_Pirineu
0.03237235 Spanish_Camp_de_Tarragona
0.03299895 Spanish_Peri-Barcelona
0.03384753 Spanish_Lleida
0.03402434 Spanish_Girona
0.03419969 Italian_Liguria
0.03478890 Spanish_Penedes
Target: gixajo_scaledQuote:
Originally Posted by Damião de Góis
Distance: 0.5609% / 0.00560858
25.8 Basque_Spanish
10.4 Spanish_Galicia
9.4 Dutch
9.2 Spanish_Peri-Barcelona
8.8 French_South
7.8 Basque_French
7.4 Sardinian
5.0 Portuguese
4.2 Spanish_Andalucia
4.0 Berber_Tunisia_Sen
3.6 Polish
3.0 French_Occitanie
0.8 German
0.2 Ju_hoan_North
0.2 Koinanbe
0.2 Yemenite_Mahra
Não sei se a folha de dados é para calcular resultados ou para ter todas as amostras agrupadas num único ficheiro.
Os resultados são estranhos, sim.
Edit: AGGREGATE : NO
Target: gixajo_scaled
Distance: 0.5615% / 0.00561514
21.8 Basque_Spanish:BAS32
10.2 Spanish_Galicia:GAL20
9.6 Spanish_Peri-Barcelona:ROS008
9.0 Dutch:Netherlands22
9.0 French_South:SouthFrench1323
8.2 Basque_French:HGDP01359
5.8 Sardinian:HGDP01078
5.4 Portuguese:Portugal1
4.0 Spanish_Andalucia:AND46
3.8 Berber_Tunisia_Sen:BerSF7
3.6 Polish:Polish7
3.4 Basque_Spanish:BAS28
3.4 French_Occitanie:T_57
1.2 Sardinian:HGDP01066
0.8 German:German38
0.4 Yemenite_Mahra:Y312
0.2 Ju_hoan_North:A_Ju_hoan_North-5
0.2 Koinanbe:GS000035255
Os resultados são estranhos porque o G25 são coordenadas de PCA, se adicionarmos centenas de samples sem qualquer penalidade ele por default irá tentar encontrar aproximações a todo o tipo de amostras, independentemente de termos herança genética dessas regiões.
Sem penalidade os teus resultados são completamente fora.Quote:
Originally Posted by Damião de Góis
pese embora que sem penalidade os meus resultados não são assim tão estranhos. Como foram os teus resultados sem penalidade?Quote:
Originally Posted by Brás Garcia de Mascarenhas
Quote:
Originally Posted by PT Tagus
Curioso que vocês todos tenham distâncias bem abaixo de 1% e eu não.Code:Target: Viriato_scaled
Distance: 1.2258% / 0.01225780
33.2 Spanish_Pais_Vasco
18.6 Spanish_Asturias
17.6 Italian_Liguria
9.6 Berber_Tunisia_Chen
7.0 Italian_Lombardy
4.8 Sardinian
3.6 Balochi
3.2 Lithuanian_VZ
2.2 Lithuanian_PZ
0.2 Koinanbe
Já agora, diferença não tem acento. Enganei-me naquele post atrás.
Target: gixajo_scaled
Distance: 0.7636% / 0.00763625 | ADC: 0.25x
17.0 Spanish_Peri-Barcelona
14.0 Portuguese
13.2 French_South
11.4 Spanish_Castello
11.0 Basque_Spanish
10.0 Spanish_Galicia
8.4 French_Occitanie
6.2 Spanish_Barcelones
6.2 Spanish_Valencia
2.6 Spanish_Mallorca
Distance to: gixajo_scaled
0.01950974 Spanish_Castilla_Y_Leon:HG01506
0.02062329 Spanish_Cantabria:HG01513
0.02086292 Spanish_Aragon:HG01673
0.02144147 Spanish_Extremadura:HG01510
0.02219181 Spanish_Navarra:Navarra1
0.02276497 Spanish_Eivissa:EIV014_2
0.02287657 Spanish_Penedes:FER023
0.02309047 Spanish_Cantabria:HG01679
0.02360072 Spanish_Pirineu:GRA029
0.02424015 Spanish_Catalunya_Central:SOL051
0.02438934 Spanish_Castello:SAB019
0.02446617 Spanish_Aragon:HG01675
0.02447669 Spanish_Cantabria:HG01512
0.02513818 French_Auvergne:C_21
0.02542444 Spanish_Pirineu:FER101
0.02572752 Spanish_Eivissa:EIV013_2
0.02576538 Spanish_Castello:PIT001
0.02578495 Spanish_Aragon:HG01676
0.02581134 Spanish_Peri-Barcelona:ROI042
0.02588615 Basque_French:HGDP01364
0.02591149 French_Occitanie:T_90
0.02595363 Spanish_Cataluna:HG01537
0.02602345 Spanish_Castilla_La_Mancha:HG01504
0.02608425 Spanish_Penedes:SAB014
melhor com penalidadeQuote:
Originally Posted by Brás Garcia de Mascarenhas
sim, as distâncias são consideravelmente baixas.