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

10 rows where analysis = "diamond", bioproject = "PRJNA700095" 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
26670927	26670927	PRJNA700095_P_NODE_2961_length_1128_cov_2.759242_g2231_i0	PRJNA700095	2961	1128	2.759242	31.12424976	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	360	5.999999999999999e-114	NR	KAJ9455383.1	91374	g2231	i0	56.3	2.84042553191489	334	128	88.6	7	1001	3	464	780	KAJ9455383.1 2-oxoisovalerate dehydrogenase subunit beta [Diplonema papillatum]	diamond	3204	360	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
26924625	26924625	PRJNA700095_P_NODE_5402_length_849_cov_2.503866_g4387_i0	PRJNA700095	5402	849	2.503866	21.25782234	Bodo saltans	75058	Euglenozoa	other_Eukaryota	123	8.22e-28	NR	CUG88796.1	75058	g4387	i0	36.7	0.597173144876325	169	100	57.6	4	30	518	419	586	CUG88796.1 cation ATPase alpha subunit, putative, partial [Bodo saltans]	diamond	507	123	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
26956041	26956041	PRJNA700095_P_NODE_22182_length_370_cov_1.898990_g20918_i0	PRJNA700095	22182	370	1.89899	7.026263	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	58.5	4.07e-7	NR	KAJ9468047.1	91374	g20918	i0	33.3	2.69189189189189	117	56	87.6	4	368	45	256	359	KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum]	diamond	996	58.5	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27998901	27998901	PRJNA700095_P_NODE_17405_length_432_cov_3.208914_g16142_i0	PRJNA700095	17405	432	3.208914	13.86250848	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	106	2.46e-24	NR	KAJ9442796.1	91374	g16142	i0	45.5	3.33333333333333	121	66	84	0	3	365	214	334	KAJ9442796.1 hypothetical protein DIPPA_16099 [Diplonema papillatum]	diamond	1440	106	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
28914129	28914129	PRJNA700095_P_NODE_36488_length_285_cov_1.330189_g35224_i0	PRJNA700095	36488	285	1.330189	3.79103865	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	92.8	1.58e-19	NR	KAJ9443059.1	91374	g35224	i0	52.2	0.947368421052632	90	43	94.7	0	284	15	1171	1260	KAJ9443059.1 Upf0753 protein [Diplonema papillatum]	diamond	270	92.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29482462	29482462	PRJNA700095_P_NODE_3030_length_1118_cov_2.516746_g2287_i0	PRJNA700095	3030	1118	2.516746	28.13722028	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	290	7.48e-92	NR	KAJ9460099.1	91374	g2287	i0	43.5	0.998211091234347	372	180	99.6	8	1114	2	39	381	KAJ9460099.1 Pectin acetylesterase 3 [Diplonema papillatum]	diamond	1116	290	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
30841094	30841094	PRJNA700095_P_NODE_28874_length_316_cov_2.489712_g27610_i0	PRJNA700095	28874	316	2.489712	7.86748992	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	68.2	9.37e-11	NR	KAJ9468047.1	91374	g27610	i0	36.6	1.06329113924051	112	62	99.7	2	2	316	151	260	KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum]	diamond	336	68.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31757855	31757855	PRJNA700095_P_NODE_26977_length_329_cov_1.503906_g25713_i0	PRJNA700095	26977	329	1.503906	4.94785074	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	101	3.9699999999999997e-23	NR	KAJ9442796.1	91374	g25713	i0	50.5	1.67781155015198	97	47	87.5	1	3	290	189	285	KAJ9442796.1 hypothetical protein DIPPA_16099 [Diplonema papillatum]	diamond	552	101	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32496960	32496960	PRJNA700095_P_NODE_31199_length_306_cov_2.163090_g29935_i0	PRJNA700095	31199	306	2.16309	6.6190554	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	5.59e-23	NR	CUI15460.1	75058	g29935	i0	53	6.90196078431373	100	47	98	0	305	6	127	226	CUI15460.1 sodium potassium-transporting ATPase subunit alpha, putative [Bodo saltans]	diamond	2112	101	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32549119	32549119	PRJNA700095_P_NODE_34279_length_291_cov_5.270642_g33015_i0	PRJNA700095	34279	291	5.270642	15.33756822	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	65.5	6.38e-10	NR	XP_009307861.1	71804	g33015	i0	46	2.25773195876289	63	34	64.9	0	98	286	4	66	XP_009307861.1 putative phosphomevalonate kinase protein [Trypanosoma grayi]	diamond	657	65.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi

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