• Don't want to see ads? Install an adblocker like uBlock Origin or use a Europe-based privacy-friendly browser like Vivaldi or Mullvad.

Admixtools ancIBD github

One way of extracting a sample IBD and chrs matches (similar to Post #15 zip download.

Open the ibd and the ch_all files and copy exactly the sample name.
With grep:
open a command prompt:
grep -w "sample_name" "AncIBDfile.tsv" > ibd_sample.tsv
and/or:
grep -w "sample_name" "ch_all_Anc_Ita.tsv" > ch_sample.tsv
(keep the quotes in the command).

It should extract all lines containing sample_name.

To append the Header:
do copy and paste, or create a new text file, add the ibd header below, and save it as: ibd_header.txt
Code:
iid1    iid2    max_IBD    sum_IBD>8.0    n_IBD>8.0    sum_IBD>12.0    n_IBD>12.0    sum_IBD>16.0    n_IBD>16.0    sum_IBD>20.0    n_IBD>20.0

... and the ch_all Header below and save it as: ch_all_header.txt
Code:
Start    End    StartM    EndM    length    lengthM    ch    iid1    iid2

cat ibd_header.txt ibd_sample.tsv >> ibd-sample.tsv
and:
cat ch_all_header.txt ch_sample.tsv >> ch-sample.tsv

We could also merge the sample ibd and ch files:
cat ibd-sample.tsv ch-sample.tsv >> ibd-ch-sample.tsv
 
Last edited:
f1R (Pompeii) extraction:
In Windows, ... I'll use grep.exe and cat.exe part of WGSExtract2.

ibd
D:\WGSExtract2\programs\samtools-cygwin\grep.exe -w "f1R_Pompeii_Roman" "Anc_ibd_Ita.tsv" > ibd-f1R_Pompeii.tsv
D:\WGSExtract2\programs\samtools-cygwin\cat.exe ibd_header.txt ibd-f1R_Pompeii.tsv >> ibd_f1R_Pompeii.tsv

ch
D:\WGSExtract2\programs\samtools-cygwin\grep.exe -w "f1R_Pompeii_Roman" "ch_all_Anc_Ita.tsv" > ch-f1R_Pompeii.tsv
D:\WGSExtract2\programs\samtools-cygwin\cat.exe ch_all_header.txt ch-f1R_Pompeii.tsv >> ch_f1R_Pompeii.tsv

ibd ch merge ... optional, but it also defeat the Excel limitation of not opening 2 files with the same name, ... though I could have renamed them :)

D:\WGSExtract2\programs\samtools-cygwin\cat.exe ibd_f1R_Pompeii.tsv ch_f1R_Pompeii.tsv >> ibd_ch_f1R_Pompeii.tsv

... the output:
[TABLE=collapse]
[TR]
[TD]iid1[/TD]
[TD]iid2[/TD]
[TD]max_IBD[/TD]
[TD]sum_IBD>8.0[/TD]
[TD]n_IBD>8.0[/TD]
[TD]sum_IBD>12.0[/TD]
[TD]n_IBD>12.0[/TD]
[TD]sum_IBD>16.0[/TD]
[TD]n_IBD>16.0[/TD]
[TD]sum_IBD>20.0[/TD]
[TD]n_IBD>20.0[/TD]
[/TR]
[TR]
[TD]f1R_Pompeii_Roman[/TD]
[TD]TAQ007_Etruscan[/TD]

[TD]
8.507699​
[/TD]

[TD]
8.507699​
[/TD]

[TD]
1​
[/TD]

[TD]
0​
[/TD]

[TD]
0​
[/TD]

[TD]
0​
[/TD]

[TD]
0​
[/TD]

[TD]
0​
[/TD]

[TD]
0​
[/TD]
[/TR]
[TR]
[TD]Start[/TD]
[TD]End[/TD]
[TD]StartM[/TD]
[TD]EndM[/TD]
[TD]length[/TD]
[TD]lengthM[/TD]
[TD]ch[/TD]
[TD]iid1[/TD]
[TD]iid2[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
13132​
[/TD]

[TD]
15278​
[/TD]

[TD]
0.592117​
[/TD]

[TD]
0.677194​
[/TD]

[TD]
2146​
[/TD]

[TD]
0.085077​
[/TD]

[TD]
1​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]TAQ007_Etruscan[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
1507​
[/TD]

[TD]
2914​
[/TD]

[TD]
0.049938​
[/TD]

[TD]
0.112881​
[/TD]

[TD]
1407​
[/TD]

[TD]
0.062943​
[/TD]

[TD]
3​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]R1_Proto-Villanovan[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
5841​
[/TD]

[TD]
7853​
[/TD]

[TD]
0.235944​
[/TD]

[TD]
0.297853​
[/TD]

[TD]
2012​
[/TD]

[TD]
0.061909​
[/TD]

[TD]
6​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]R1016_IA[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
57372​
[/TD]

[TD]
59523​
[/TD]

[TD]
1.347888​
[/TD]

[TD]
1.411825​
[/TD]

[TD]
2151​
[/TD]

[TD]
0.063937​
[/TD]

[TD]
6​
[/TD]

[TD]R11119_Roman_Imperial[/TD]
[TD]f1R_Pompeii_Roman[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
45959​
[/TD]

[TD]
47324​
[/TD]

[TD]
1.385171​
[/TD]

[TD]
1.446945​
[/TD]

[TD]
1365​
[/TD]

[TD]
0.061774​
[/TD]

[TD]
9​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]I16170_Sardinia_MBA[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
20609​
[/TD]

[TD]
22130​
[/TD]

[TD]
0.69623​
[/TD]

[TD]
0.764228​
[/TD]

[TD]
1521​
[/TD]

[TD]
0.067998​
[/TD]

[TD]
10​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]VK536_Medieval[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
51241​
[/TD]

[TD]
52674​
[/TD]

[TD]
1.445873​
[/TD]

[TD]
1.507216​
[/TD]

[TD]
1433​
[/TD]

[TD]
0.061343​
[/TD]

[TD]
11​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]PRZ001_Etruscan[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
5088​
[/TD]

[TD]
6667​
[/TD]

[TD]
0.237875​
[/TD]

[TD]
0.30684​
[/TD]

[TD]
1579​
[/TD]

[TD]
0.068965​
[/TD]

[TD]
12​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]C4-R1550_Imperial[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
42449​
[/TD]

[TD]
44941​
[/TD]

[TD]
1.273792​
[/TD]

[TD]
1.345665​
[/TD]

[TD]
2492​
[/TD]

[TD]
0.071873​
[/TD]

[TD]
12​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]R11109_Roman_Imperial[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]
4764​
[/TD]

[TD]
6095​
[/TD]

[TD]
0.271265​
[/TD]

[TD]
0.331541​
[/TD]

[TD]
1331​
[/TD]

[TD]
0.060276​
[/TD]

[TD]
17​
[/TD]

[TD]f1R_Pompeii_Roman[/TD]
[TD]UZZ061_Sicily_MN[/TD]
[TD][/TD]

[TD][/TD]
[/TR]
[/TABLE]
 
Last edited:
Back
Top