view test-data/eggnogg_tiny_taxa.sh @ 14:d9c3016f7283 draft default tip

planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit 192779247c3385704ebd98a2cc47a210fb1f4d0c
author galaxyp
date Thu, 07 Sep 2023 18:51:23 +0000
parents 96cac424c870
children
line wrap: on
line source

#!/bin/bash

# Script adapted from https://github.com/galaxyproteomics/egglet to produce a minimal eggnog 5.0.2 database

sqlite3 $1 << "EOF"

CREATE TEMP TABLE species
AS SELECT * FROM species
WHERE taxid in (1131266, 436308);

CREATE TEMP TABLE synonym
AS SELECT * FROM synonym
WHERE taxid in (1131266, 436308);

CREATE TEMP TABLE merged
AS SELECT * FROM merged
WHERE taxid_old in (1131266, 436308);

CREATE TEMP TABLE stats
AS SELECT * FROM stats;

.backup temp eggnog_tiny_taxa.db
EOF