-- tell postgres to cough up tab delimited files
\C
\f '\t'
\a

-- extract synonyms for halo genes
\o /local/halo.id.synonyms.txt
select g.name, s.name as synonym
from networks_gene g
  join networks_synonym s on g.id=s.target_id
where s.target_type='gene' and s.type like 'vng%';
\o

-- extract GO annotations
\o /local/halo.go.txt
select g.name, f.native_id
from networks_gene g
  join networks_gene_function gf on g.id=gf.gene_id
  join networks_function f on gf.function_id=f.id
where g.species_id=2 and f.type='go';
\o