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

5 rows where analysis = "blastn", bioproject = "PRJNA904835" 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
2158102	2158102	PRJNA904835_P_NODE_25182_length_397_cov_0.808642_g24926_i0	PRJNA904835	25182	397	0.808642	3.21030874	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	267	1.25e-66	NTclustered	gi\|1002439656\|ref\|XM_015806403.1\|	157538	g24926	i0	86.585	43.7934508816121	246	27	61	6	47	289	91	333	Leptomonas pyrrhocoris putative 60S ribosomal protein L44 mRNA	blastn	17386	267	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
4712151	4712151	PRJNA904835_P_NODE_54244_length_247_cov_0.885057_g53988_i0	PRJNA904835	54244	247	0.885057	2.18609079	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	207	4.4999999999999994e-49	NTclustered	gi\|686640876\|ref\|XM_009314609.1\|	71804	g53988	i0	81.928	3.35222672064777	249	41	100	4	1	247	193	439	Trypanosoma grayi 40S ribosomal protein SA partial mRNA	blastn	828	207	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
7625577	7625577	PRJNA904835_P_NODE_51886_length_250_cov_0.870056_g51630_i0	PRJNA904835	51886	250	0.870056	2.17514	Leishmania	5658	Euglenozoa	other_Eukaryota	252	2.08e-62	NTclustered	gi\|2593254740\|emb\|OY748490.1\|	5660	g51630	i0	86.463	92.768	229	31	92	0	8	236	362271	362499	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 04	blastn	23192	252	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
12362226	12362226	PRJNA904835_P_NODE_41930_length_290_cov_1.142857_g41674_i0	PRJNA904835	41930	290	1.142857	3.3142853	Paratrypanosoma confusum	1470209	Euglenozoa	other_Eukaryota	178	4.25e-40	NTclustered	gi\|452768944\|gb\|KC534676.1\|	1470209	g41674	i0	80.508	1.49655172413793	236	42	81	4	28	261	1609	1842	Trypanosomatidae sp. TS-2013 clone C24978L43121o22 hypothetical protein gene, partial cds	blastn	434	178	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Paratrypanosoma	Paratrypanosoma confusum
18734034	18734034	PRJNA904835_P_NODE_18295_length_477_cov_1.118812_g18040_i0	PRJNA904835	18295	477	1.118812	5.33673324	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	274	9.1e-69	NTclustered	gi\|1624744253\|ref\|XM_029023055.1\|	67003	g18040	i0	80.328	15.1572327044025	366	68	76	4	67	430	6	369	Trypanosoma theileri ribosomal protein L21E (60S) (TM35_000054000), partial mRNA	blastn	7230	274	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri

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