metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA658591" 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
4453400	4453400	PRJNA658591_S_NODE_8464_length_171_cov_2.311475_g8401_i0	PRJNA658591	8464	171	2.311475	3.95262225	Paratrypanosoma confusum	1470209	Euglenozoa	other_Eukaryota	95.5	1.19e-22	NR	AGG11562.1	1470209	g8401	i0	80.7	2	57	11	100	0	171	1	88	144	AGG11562.1 hypothetical protein, partial [Paratrypanosoma confusum]	diamond	342	95.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Paratrypanosoma	Paratrypanosoma confusum
12104841	12104841	PRJNA658591_S_NODE_3610_length_235_cov_1.473118_g3547_i0	PRJNA658591	3610	235	1.473118	3.4618273	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	72.8	7.47e-13	NR	KAJ9460353.1	91374	g3547	i0	45.7	0.893617021276596	70	33	89.4	2	3	212	171	235	KAJ9460353.1 hypothetical protein DIPPA_02802 [Diplonema papillatum]	diamond	210	72.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
28356755	28356755	PRJNA658591_S_NODE_8966_length_168_cov_1.663866_g8903_i0	PRJNA658591	8966	168	1.663866	2.79529488	Trypanosoma	5690	Euglenozoa	other_Eukaryota	61.2	1.39e-10	NR	KAF8277798.1	5693	g8903	i0	74.4	9.98214285714286	43	10	76.8	1	38	166	1	42	KAF8277798.1 putative histone H4 [Trypanosoma cruzi]	diamond	1677	61.6	0.993506493506494	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
28755138	28755138	PRJNA658591_S_NODE_8047_length_174_cov_3.544000_g7984_i0	PRJNA658591	8047	174	3.544	6.16656	Phytomonas sp. Hart1	223615	Euglenozoa	other_Eukaryota	86.3	1.11e-19	NR	CCW71534.1	223615	g7984	i0	64.9	0.982758620689655	57	20	98.3	0	3	173	10	66	CCW71534.1 unnamed protein product [Phytomonas sp. Hart1]	diamond	171	86.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas sp. Hart1
29146590	29146590	PRJNA658591_S_NODE_3009_length_251_cov_1.772277_g2946_i0	PRJNA658591	3009	251	1.772277	4.44841527	Trypanosoma	5690	Euglenozoa	other_Eukaryota	107	1.34e-26	NR	KAG8344751.1	5699	g2946	i0	63.9	10.9123505976096	83	30	99.2	0	249	1	76	158	KAG8344751.1 60S ribosomal protein L13a [Trypanosoma vivax]	diamond	2739	107	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
29525224	29525224	PRJNA658591_S_NODE_9250_length_167_cov_0.881356_g9187_i0	PRJNA658591	9250	167	0.881356	1.47186452	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	85.9	6.3e-19	NR	GET93160.1	5689	g9187	i0	65.5	18.6826347305389	55	19	98.8	0	167	3	71	125	GET93160.1 40S ribosomal protein S18, putative [Leishmania tarentolae]	diamond	3120	86.7	0.990772779700115	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
32641781	32641781	PRJNA658591_S_NODE_7360_length_180_cov_1.572519_g7297_i0	PRJNA658591	7360	180	1.572519	2.8305341999999998	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	102	3.51e-24	NR	XP_029236609.1	5698	g7297	i0	84.2	5.7	57	9	95	0	173	3	20	76	XP_029236609.1 large subunit ribosomal protein L18Ae [Trypanosoma rangeli]	diamond	1026	102	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
32767926	32767926	PRJNA658591_S_NODE_10120_length_163_cov_0.912281_g10057_i0	PRJNA658591	10120	163	0.912281	1.48701803	Bodo saltans	75058	Euglenozoa	other_Eukaryota	82	1.68e-16	NR	CUG93847.1	75058	g10057	i0	73.6	0.975460122699387	53	13	95.7	1	6	161	191	243	CUG93847.1 ABC transporter, putative [Bodo saltans]	diamond	159	82	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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