1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
|
Setup
$ source "$TESTDIR"/_setup.sh
A column with True and False values is query-able by boolean comparisons.
$ cat >metadata.tsv <<~~
> strain column
> SEQ_1 True
> SEQ_2 True
> SEQ_3 False
> ~~
$ ${AUGUR} filter \
> --metadata metadata.tsv \
> --query "column == True" \
> --output-strains filtered_strains.txt
1 strain was dropped during filtering
1 was filtered out by the query: "column == True"
2 strains passed all filters
$ sort filtered_strains.txt
SEQ_1
SEQ_2
Note that the string value is case-insensitive.
$ cat >metadata.tsv <<~~
> strain column
> SEQ_1 True
> SEQ_2 trUe
> SEQ_3 FALSE
> ~~
$ ${AUGUR} filter \
> --metadata metadata.tsv \
> --query "column == True" \
> --output-strains filtered_strains.txt
1 strain was dropped during filtering
1 was filtered out by the query: "column == True"
2 strains passed all filters
Note that 1/0 can also be compared to boolean literals.
$ cat >metadata.tsv <<~~
> strain column
> SEQ_1 1
> SEQ_2 1
> SEQ_3 0
> ~~
$ ${AUGUR} filter \
> --metadata metadata.tsv \
> --query "column == True" \
> --output-strains filtered_strains.txt
1 strain was dropped during filtering
1 was filtered out by the query: "column == True"
2 strains passed all filters
Empty values are ignored.
$ cat >metadata.tsv <<~~
> strain column
> SEQ_1 True
> SEQ_2 False
> SEQ_3
> ~~
$ ${AUGUR} filter \
> --metadata metadata.tsv \
> --query "column == True" \
> --output-strains filtered_strains.txt
2 strains were dropped during filtering
2 were filtered out by the query: "column == True"
1 strain passed all filters
$ sort filtered_strains.txt
SEQ_1
|