metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB11748" 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
15013039	15013039	PRJEB11748_P_NODE_68652_length_510_cov_4.409800_g66507_i0	PRJEB11748	68652	510	4.4098	22.48998	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	131	5.53e-36	NR	QLA09635.1	3039	g66507	i0	59.3	0.664705882352941	113	44	65.3	1	39	371	6	118	QLA09635.1 60S large subunit ribosomal protein eL34 [Euglena gracilis]	diamond	339	131	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
26589407	26589407	PRJEB11748_P_NODE_312541_length_213_cov_22.927632_g310358_i0	PRJEB11748	312541	213	22.927632	48.83585616	Leishmania enriettii	5663	Euglenozoa	other_Eukaryota	42.4	0.0341	NR	XP_067696237.1	5663	g310358	i0	41.5	0.577464788732394	41	23	57.7	1	212	90	477	516	XP_067696237.1 hypothetical protein CUR178_08507 [Leishmania enriettii]	diamond	123	42.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania enriettii
27601699	27601699	PRJEB11748_P_NODE_170784_length_311_cov_5.780000_g168601_i0	PRJEB11748	170784	311	5.78	17.9758	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	58.9	6.59e-8	NR	XP_067192558.1	715481	g168601	i0	54	0.945337620578778	50	23	48.2	0	189	40	130	179	XP_067192558.1 GNAT domain [Trypanosoma melophagium]	diamond	294	58.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
27601860	27601860	PRJEB11748_P_NODE_58424_length_556_cov_16.157576_g56296_i0	PRJEB11748	58424	556	16.157576	89.83612256	Bodo saltans	75058	Euglenozoa	other_Eukaryota	117	2.0500000000000003e-27	NR	CUG88897.1	75058	g56296	i0	50.7	0.755395683453237	140	50	70.1	4	533	144	285	415	CUG88897.1 sodium/hydrogen antiporter, putative [Bodo saltans]	diamond	420	117	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30317893	30317893	PRJEB11748_P_NODE_85732_length_452_cov_32.148338_g83567_i0	PRJEB11748	85732	452	32.148338	145.31048776	Bodo saltans	75058	Euglenozoa	other_Eukaryota	207	7.44e-64	NR	CUG90016.1	75058	g83567	i0	86.1	0.809734513274336	122	16	81	1	24	389	181	301	CUG90016.1 phosphoenolpyruvate mutase, putative [Bodo saltans]	diamond	366	207	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30816564	30816564	PRJEB11748_P_NODE_57454_length_561_cov_25.642000_g55327_i0	PRJEB11748	57454	561	25.642	143.85162	Trypanosoma	5690	Euglenozoa	other_Eukaryota	54.3	7.78e-5	NR	XP_029229905.1	83891	g55327	i0	33	1.79679144385027	109	67	58.3	2	350	24	262	364	XP_029229905.1 permease, family protein [Trypanosoma conorhini]	diamond	1008	54.7	0.992687385740402	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
30885845	30885845	PRJEB11748_P_NODE_151014_length_334_cov_2.241758_g148833_i0	PRJEB11748	151014	334	2.241758	7.48747172	Bodo saltans	75058	Euglenozoa	other_Eukaryota	85.5	2.51e-18	NR	CUF19896.1	75058	g148833	i0	51.8	0.745508982035928	83	38	72.8	1	92	334	1	83	CUF19896.1 transmembrane protein, putative [Bodo saltans]	diamond	249	85.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31455053	31455053	PRJEB11748_P_NODE_308896_length_215_cov_4.389610_g306713_i0	PRJEB11748	308896	215	4.38961	9.4376615	Bodo saltans	75058	Euglenozoa	other_Eukaryota	72.4	1.65e-13	NR	CUG93538.1	75058	g306713	i0	69.2	0.544186046511628	39	12	54.4	0	72	188	4	42	CUG93538.1 Hypothetical protein, putative, partial [Bodo saltans]	diamond	117	72.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32277784	32277784	PRJEB11748_P_NODE_93079_length_433_cov_186.424731_g90911_i0	PRJEB11748	93079	433	186.424731	807.21908523	Bodo saltans	75058	Euglenozoa	other_Eukaryota	55.8	7.36e-6	NR	CUF25741.1	75058	g90911	i0	34.6	0.561200923787529	81	51	54.7	2	28	264	136	216	CUF25741.1 GPI-anchored surface protein, putative [Bodo saltans]	diamond	243	55.8	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);;