a guest Dec 15th, 2018 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT ARRAY_AGG(coalesce(ncbi_nodes.superkingdom, '--') || '|' || coalesce(ncbi_nodes.kingdom, '--'))
- FROM ncbi_nodes
- WHERE taxon_id in (SELECT ncbi_names.taxon_id from ncbi_names where lower(gbif_ct.class_name) = lower(ncbi_names.name))
- ) AS ncbi_taxa
- FROM combine_taxa as gbif_ct
RAW Paste Data