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

8 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_clade = "Discoba"

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
6530305	6530305	PRJNA1002570_P_NODE_15586_length_310_cov_3.113924_g15391_i0	PRJNA1002570	15586	310	3.113924	9.6531644	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.4	5.62e-7	NR	XP_028884666.1	67003	g15391	i0	58.5	1.40322580645161	41	17	39.7	0	188	310	284	324	XP_028884666.1 mitogen activated protein kinase [Trypanosoma theileri]	diamond	435	57.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
13754014	13754014	PRJNA1002570_P_NODE_17631_length_299_cov_3.548673_g17436_i0	PRJNA1002570	17631	299	3.548673	10.61053227	Bodo saltans	75058	Euglenozoa	other_Eukaryota	137	1.21e-38	NR	CUG89991.1	75058	g17436	i0	69.2	2.08695652173913	104	26	98.3	1	299	6	33	136	CUG89991.1 60S ribosomal protein L34, putative [Bodo saltans]	diamond	624	137	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
28676772	28676772	PRJNA1002570_P_NODE_40527_length_245_cov_2.029070_g40332_i0	PRJNA1002570	40527	245	2.02907	4.9712215	Bodo saltans	75058	Euglenozoa	other_Eukaryota	52.4	1.53e-5	NR	CUG83922.1	75058	g40332	i0	49.1	0.673469387755102	55	28	67.3	0	2	166	509	563	CUG83922.1 Hypothetical protein, putative [Bodo saltans]	diamond	165	52.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29174563	29174563	PRJNA1002570_P_NODE_40949_length_245_cov_0.895349_g40754_i0	PRJNA1002570	40949	245	0.895349	2.19360505	Naegleria	5761	Heterolobosea	other_Eukaryota	144	6.73e-38	NR	XP_002678727.1	5762	g40754	i0	88.9	1.98367346938776	81	9	99.2	0	245	3	436	516	XP_002678727.1 uncharacterized protein NAEGRDRAFT_83074 [Naegleria gruberi]	diamond	486	145	0.993103448275862	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
29206202	29206202	PRJNA1002570_P_NODE_39849_length_246_cov_1.572254_g39654_i0	PRJNA1002570	39849	246	1.572254	3.86774484	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	44.7	5.57e-4	NR	XP_015657785.1	157538	g39654	i0	70.6	0.829268292682927	34	10	41.5	0	237	136	15	48	XP_015657785.1 hypothetical protein ABB37_05795 [Leptomonas pyrrhocoris]	diamond	204	45.1	0.991130820399113	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
29268923	29268923	PRJNA1002570_P_NODE_28669_length_271_cov_1.181818_g28474_i0	PRJNA1002570	28669	271	1.181818	3.20272678	Trypanosoma	5690	Euglenozoa	other_Eukaryota	48.1	6.56e-4	NR	KAF8275499.1	5693	g28474	i0	40	2.46863468634686	80	35	74.2	1	6	206	979	1058	KAF8275499.1 hypothetical protein TcBrA4_0137620 [Trypanosoma cruzi]	diamond	669	48.5	0.991752577319588	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
30034538	30034538	PRJNA1002570_P_NODE_45171_length_233_cov_2.612500_g44976_i0	PRJNA1002570	45171	233	2.6125	6.087125	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	74.7	1.72e-13	NR	KAJ9464842.1	91374	g44976	i0	56.7	0.862660944206009	67	28	85	1	1	198	409	475	KAJ9464842.1 Cyclic nucleotide-gated cation channel [Diplonema papillatum]	diamond	201	74.7	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32429876	32429876	PRJNA1002570_P_NODE_39479_length_247_cov_0.885057_g39284_i0	PRJNA1002570	39479	247	0.885057	2.18609079	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	120	1.38e-32	NR	KPI87218.1	5684	g39284	i0	63.4	9	82	30	99.6	0	2	247	78	159	KPI87218.1 hypothetical protein ABL78_3688 [Leptomonas seymouri]	diamond	2223	121	0.991735537190083	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri

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