metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax_phylum = "Euglenozoa"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3623928	3623928	PRJNA358490_P_NODE_6383_length_522_cov_2.420290_g6056_i0	PRJNA358490	6383	522	2.42029	12.6339138	Leishmania	5658	Euglenozoa	other_Eukaryota	451	4.32e-122	NTclustered	gi\|2593247693\|emb\|OY748410.1\|	5660	g6056	i0	89.415	63.7605363984674	359	36	69	2	9	366	595376	595019	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 16	blastn	33283	451	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
7451163	7451163	PRJNA358490_P_NODE_6646_length_506_cov_4.370450_g6317_i0	PRJNA358490	6646	506	4.37045	22.114477	Leishmania	5658	Euglenozoa	other_Eukaryota	394	7.14e-105	NTclustered	gi\|2593255734\|emb\|OY748497.1\|	5660	g6317	i0	87.941	49.7845849802372	340	33	66	5	59	394	489219	488884	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 11	blastn	25191	394	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
8052374	8052374	PRJNA358490_P_NODE_7547_length_457_cov_4.222488_g7210_i0	PRJNA358490	7547	457	4.222488	19.29677016	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	219	4.13e-52	NTclustered	gi\|2794848421\|ref\|XM_067897202.1\|	2761500	g7210	i0	77.482	19.5207877461707	413	62	90	15	47	457	461	78	Porcisia hertigi uncharacterized protein (JKF63_01154), partial mRNA	blastn	8921	219	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
16976437	16976437	PRJNA358490_P_NODE_2534_length_899_cov_5.174419_g2363_i0	PRJNA358490	2534	899	5.174419	46.51802681	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	603	1.9999999999999996e-167	NTclustered	gi\|686647083\|ref\|XM_009317712.1\|	71804	g2363	i0	81.719	39.349276974416	733	124	81	10	171	898	1168	441	Trypanosoma grayi proteasome regulatory ATPase subunit 3 partial mRNA	blastn	35375	603	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
20800433	20800433	PRJNA358490_P_NODE_11737_length_259_cov_2.377273_g11393_i0	PRJNA358490	11737	259	2.377273	6.15713707	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	135	2.28e-27	NTclustered	gi\|1002436068\|ref\|XM_015808312.1\|	157538	g11393	i0	81.707	6.9034749034749	164	28	63	2	75	237	967	805	Leptomonas pyrrhocoris putative mitochondrial iron superoxide dismutase (FESODA) mRNA	blastn	1788	135	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris

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);;