varianttools icon indicating copy to clipboard operation
varianttools copied to clipboard

vtools remove variants does not work for hdf5

Open BoPeng opened this issue 8 years ago • 2 comments

The syntax is vtools remove variants TABLE where TABLE is a variant table. In sqlite, the implementation is something like (code]

DELETE FROM genotype_2 WHERE variant_id IN (SELECT variant_id from TABLE)

Not sure what API to use though because all the IDs should be passed to HDF5.

BoPeng avatar Sep 20 '17 22:09 BoPeng

It seems the remove of variants, samples and genotypes are not reversible? Is this the ideal way? How about use a column to mark the visibility?

jma7 avatar Oct 05 '17 04:10 jma7

It is certainly ok as long as that does not affect the performance of retrieving genotype (variant) etc.

BoPeng avatar Oct 05 '17 14:10 BoPeng