metadata: contig_metadata: 4 rows where bioproject = "PRJEB30004", tax_clade = "Opisthokonta" and tax

4 rows where bioproject = "PRJEB30004", tax_clade = "Opisthokonta" and tax_phylum = "Nematoda"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
14069708	14069708	PRJEB30004_P_NODE_417332_length_220_cov_1.132597_g401705_i0	PRJEB30004	417332	220	1.132597	2.4917134	Caenorhabditis elegans	6239	Nematoda	Nematoda	401	1.6799999999999993e-107	NTclustered	gi\|1879207294\|gb\|MT797802.1\|	6239	g401705	i0	99.545	98.1409090909091	220	1	100	0	1	220	90	309	Caenorhabditis elegans isolate KZN large subunit ribosomal RNA gene, partial sequence	blastn	21591	401	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Rhabditidae	Caenorhabditis	Caenorhabditis elegans
29622254	29622254	PRJEB30004_P_NODE_313990_length_272_cov_2.493562_g298363_i0	PRJEB30004	313990	272	2.493562	6.78248864	Trichinella nativa	6335	Nematoda	Nematoda	41.6	0.0105	NR	KRZ47273.1	6335	g298363	i0	77.1	0.386029411764706	35	2	32	2	271	185	9	43	KRZ47273.1 hypothetical protein T02_1459 [Trichinella nativa]	diamond	105	41.6	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa
29843737	29843737	PRJEB30004_P_NODE_133411_length_509_cov_2.438298_g117922_i0	PRJEB30004	133411	509	2.438298	12.41093682	Trichinella sp. T9	181606	Nematoda	Nematoda	63.2	3.44e-10	NR	KRX35621.1	181606	g117922	i0	100	0.200392927308448	34	0	20	0	232	333	1	34	KRX35621.1 hypothetical protein T09_1644 [Trichinella sp. T9]	diamond	102	63.2	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella sp. T9
32088028	32088028	PRJEB30004_P_NODE_90658_length_674_cov_22.963780_g10514_i6	PRJEB30004	90658	674	22.96378	154.7758772	Trichinella nativa	6335	Nematoda	Nematoda	57	2.19e-7	NR	KRZ47273.1	6335	g10514	i6	82.9	0.155786350148368	35	6	15.6	0	285	181	9	43	KRZ47273.1 hypothetical protein T02_1459 [Trichinella nativa]	diamond	105	57	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Enoplea	Trichinellida	Trichinellidae	Trichinella	Trichinella nativa

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;