metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1263632" 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
27989974	27989974	PRJNA1263632_P_NODE_4685_length_290_cov_1.345622_g4667_i0	PRJNA1263632	4685	290	1.345622	3.9023038	Phytomonas sp. EM1	479712	Euglenozoa	other_Eukaryota	142	8.879999999999998e-37	NR	CCW61537.1	479712	g4667	i0	68.5	3.83793103448276	92	29	95.2	0	279	4	280	371	CCW61537.1 unnamed protein product [Phytomonas sp. EM1]	diamond	1113	142	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Phytomonas	Phytomonas sp. EM1
28400342	28400342	PRJNA1263632_P_NODE_3946_length_313_cov_0.841667_g3928_i0	PRJNA1263632	3946	313	0.841667	2.63441771	Bodo saltans	75058	Euglenozoa	other_Eukaryota	172	6.47e-53	NR	CUE73723.1	75058	g3928	i0	87.9	0.87220447284345	91	11	87.2	0	1	273	57	147	CUE73723.1 ubiquitin ribosomal protein S27a, putative [Bodo saltans]	diamond	273	172	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28431966	28431966	PRJNA1263632_P_NODE_6846_length_249_cov_0.875000_g6828_i0	PRJNA1263632	6846	249	0.875	2.17875	Bodo saltans	75058	Euglenozoa	other_Eukaryota	79.7	8.81e-17	NR	CUF83951.1	75058	g6828	i0	55.7	0.734939759036145	61	27	73.5	0	247	65	81	141	CUF83951.1 membrane-associated protein, putative [Bodo saltans]	diamond	183	79.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28842238	28842238	PRJNA1263632_P_NODE_7468_length_246_cov_0.890173_g7450_i0	PRJNA1263632	7468	246	0.890173	2.18982558	Trypanosoma vivax	5699	Euglenozoa	other_Eukaryota	96.3	2.83e-21	NR	KAG8348314.1	5699	g7450	i0	61.4	3.98780487804878	83	31	100	1	246	1	247	329	KAG8348314.1 putative protein phosphatase 2C [Trypanosoma vivax]	diamond	981	96.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
29126799	29126799	PRJNA1263632_P_NODE_7649_length_245_cov_0.895349_g7631_i0	PRJNA1263632	7649	245	0.895349	2.19360505	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	107	7.56e-26	NR	XP_028887220.1	67003	g7631	i0	63.5	6.29387755102041	74	27	90.6	0	244	23	238	311	XP_028887220.1 cell division related protein kinase 2 [Trypanosoma theileri]	diamond	1542	107	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
30358736	30358736	PRJNA1263632_P_NODE_6612_length_250_cov_0.870056_g6594_i0	PRJNA1263632	6612	250	0.870056	2.17514	Bodo saltans	75058	Euglenozoa	other_Eukaryota	70.5	6.65e-12	NR	CUG91655.1	75058	g6594	i0	50.8	0.78	65	28	73.2	1	63	245	154	218	CUG91655.1 Hypothetical protein, putative [Bodo saltans]	diamond	195	70.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31210841	31210841	PRJNA1263632_P_NODE_5095_length_280_cov_1.014493_g5077_i0	PRJNA1263632	5095	280	1.014493	2.8405804	Bodo saltans	75058	Euglenozoa	other_Eukaryota	95.5	6.050000000000001e-21	NR	CUG54525.1	75058	g5077	i0	50.5	1.89642857142857	93	45	99.6	1	280	2	174	265	CUG54525.1 arginase-like protein, putative [Bodo saltans]	diamond	531	95.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32223691	32223691	PRJNA1263632_P_NODE_8018_length_243_cov_0.905882_g8000_i0	PRJNA1263632	8018	243	0.905882	2.20129326	Bodo saltans	75058	Euglenozoa	other_Eukaryota	63.5	1.72e-9	NR	CUG87619.1	75058	g8000	i0	38.8	0.987654320987654	80	46	95.1	1	232	2	2	81	CUG87619.1 Hypothetical protein, putative [Bodo saltans]	diamond	240	63.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32350376	32350376	PRJNA1263632_P_NODE_8459_length_241_cov_0.916667_g8441_i0	PRJNA1263632	8459	241	0.916667	2.20916747	Bodo saltans	75058	Euglenozoa	other_Eukaryota	72	1.67e-12	NR	CUG92886.1	75058	g8441	i0	50	1.59336099585062	80	27	99.6	1	241	2	132	198	CUG92886.1 GTPase activating protein, putative [Bodo saltans]	diamond	384	72	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32715342	32715342	PRJNA1263632_P_NODE_6680_length_250_cov_0.870056_g6662_i0	PRJNA1263632	6680	250	0.870056	2.17514	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	124	8.369999999999999e-31	NR	TPP54184.1	5661	g6662	i0	67.5	4.98	83	27	99.6	0	250	2	795	877	TPP54184.1 RNB domain family protein [Leishmania donovani]	diamond	1245	125	0.992	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani

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