Export Specific Column From MT

Hail Query & hailctl
1

I have a MT with VEP and Variant_qc applied, i just wanted to export some of the columns as a tsv file for example only the gene_symbol and AF. How to do it.

2

Hi @Haseeb1
You’re looking for Table.export:

t.key_by().select('gene_symbol', 'AF').export('/path/to/file.tsv')
1 Like
3

How to convert mt to table?

4

It sounds like you just want to export row fields. In which case, you can do mt.rows() to get a table of just the row fields.

1 Like
5

2 posts were split to a new topic: I tried to select some nested fields but I received a LookupError