view test-data/eggnogg_tiny.sh @ 11:5a30ae278db0 draft

planemo upload for repository https://github.com/galaxyproteomics/tools-galaxyp/tree/master/tools/eggnog_mapper/eggnog_mapper commit 75035b2919ce95fa8d3b785d86c7c7c9da531db2
author galaxyp
date Mon, 20 Jun 2022 12:49:52 +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 og
AS SELECT * FROM og
WHERE description = 'Cytidylyltransferase'
AND level LIKE "651137"
LIMIT 1;

CREATE TEMP TABLE event
AS SELECT * FROM event
WHERE level=651137
AND og='41T2K'
LIMIT 20;

CREATE TEMP TABLE prots
AS SELECT * FROM prots
WHERE name = "436308.Nmar_0135";

CREATE TEMP TABLE version
AS SELECT * FROM version;


.backup temp eggnog_tiny.db
EOF