Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- (
- 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
Add Comment
Please, Sign In to add comment