Query based on other column

[aardes]

I am wondering would it possible to query the data based on the other columns rather than chromosomal coordinates? For example based on the GT or BaseQRankSum.

[nishunathan]

I would like to add few points to the issue raised by Amin.
Are there any updates to the issue #65 ? We are looking for a similar search feature to filter sample data based on vcf attributes.

If you consider the query.json below,
{
"workspace" : "/GenomicsDBTest/vcfWorkSpace1/",
"array" : "test3",
"query_column_ranges": [{
"range_list": [{
"low": 0,
"high": 10000000000
}]
}],
"vid_mapping_file": "/GenomicsDBTest/json/json_new/vid_mapping_file.json",
"callset_mapping_file": "/GenomicsDBTest/json/json_new/callset_mapping_file.json",
"query_attributes" : [ "REF", "ALT", "BaseQRankSum", "DP", "GT", "AD", "PL","END" ]
}

Is there any option we can filter with attribute, example BaseQRankSum > 1.23

[kgururaj]

This is a popular request among users - I have added a wiki page: https://github.com/Intel-HLS/GenomicsDB/wiki/Query-supplementary