I’ve been given a one-page html multiqc (v1.23) report and I exported the samtools-flags table as TSV. It looks like the output file is encoded as an unicode UTF-8-BOM file.
$ head -n1 samtools-flagstat-dp.tsv | cut -f1 | file -
/dev/stdin: Unicode text, UTF-8 (with BOM) text
$ head -n1 samtools-flagstat-dp.tsv | cut -f1 | hexdump -C
00000000 ef bb bf 53 61 6d 70 6c 65 0a |...Sample.|
0000000a
is it a bug or is it a feature ?
EDIT: furthermore, it looks like the export function adds an extra trailing TAB in the data and R doesn’t like this
Asking because when I try to load the table in R, R ‘shifts’ the colums. I tried: