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

10 rows where analysis = "diamond", bioproject = "PRJNA801875" 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
3351984	3351984	PRJNA801875_P_NODE_2903_length_197_cov_1.160494_g2800_i0	PRJNA801875	2903	197	1.160494	2.28617318	Trypanosoma rangeli SC58	429131	Euglenozoa	other_Eukaryota	80.5	3.85e-17	NR	ESL07736.1	429131	g2800	i0	60	0.913705583756345	60	24	91.4	0	193	14	105	164	ESL07736.1 60S ribosomal protein L12 [Trypanosoma rangeli SC58]	diamond	180	80.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
27054217	27054217	PRJNA801875_P_NODE_4562_length_153_cov_1.338983_g4459_i0	PRJNA801875	4562	153	1.338983	2.04864399	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	64.7	1.99e-10	NR	XP_002681945.1	5762	g4459	i0	57.1	1.92156862745098	49	21	96.1	0	150	4	242	290	XP_002681945.1 rRNA (uridine-2'-O-)-methyltransferase [Naegleria gruberi]	diamond	294	64.7	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
27148520	27148520	PRJNA801875_P_NODE_1982_length_258_cov_1.708520_g1879_i0	PRJNA801875	1982	258	1.70852	4.4079816	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	77.8	1.64e-14	NR	KAJ9468047.1	91374	g1879	i0	45.6	3.13953488372093	90	40	94.2	2	6	248	244	333	KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum]	diamond	810	77.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27654570	27654570	PRJNA801875_P_NODE_1324_length_345_cov_2.032258_g1221_i0	PRJNA801875	1324	345	2.032258	7.0112901	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	142	1.53e-39	NR	KAJ9455829.1	91374	g1221	i0	63.2	0.991304347826087	114	41	99.1	1	3	344	13	125	KAJ9455829.1 hypothetical protein DIPPA_11672 [Diplonema papillatum]	diamond	342	142	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27663440	27663440	PRJNA801875_P_NODE_3784_length_168_cov_2.067669_g3681_i0	PRJNA801875	3784	168	2.067669	3.47368392	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77	1.13e-14	NR	KAJ9453110.1	91374	g3681	i0	68.5	2.91071428571429	54	17	96.4	0	4	165	397	450	KAJ9453110.1 ABC transporter F family member 1 [Diplonema papillatum]	diamond	489	77	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29106915	29106915	PRJNA801875_P_NODE_3988_length_164_cov_1.356589_g3885_i0	PRJNA801875	3988	164	1.356589	2.22480596	Bodo saltans	75058	Euglenozoa	other_Eukaryota	80.5	6.22e-16	NR	AAC38978.1	75058	g3885	i0	67.9	0.969512195121951	53	17	97	0	6	164	104	156	AAC38978.1 cytochrome c oxidase subunit 1 [Bodo saltans]	diamond	159	80.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29769739	29769739	PRJNA801875_P_NODE_1931_length_265_cov_1.017391_g1828_i0	PRJNA801875	1931	265	1.017391	2.69608615	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	93.2	8.39e-20	NR	KAJ9472100.1	91374	g1828	i0	56.6	1.91320754716981	83	34	94	1	251	3	6	86	KAJ9472100.1 hypothetical protein DIPPA_14401 [Diplonema papillatum]	diamond	507	93.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
30148731	30148731	PRJNA801875_P_NODE_1852_length_273_cov_3.252101_g1749_i0	PRJNA801875	1852	273	3.252101	8.87823573	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	106	1.7999999999999997e-24	NR	AAF71706.1	3039	g1749	i0	56.8	0.967032967032967	88	38	96.7	0	9	272	443	530	AAF71706.1 elongation factor 2, partial [Euglena gracilis]	diamond	264	106	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
31222989	31222989	PRJNA801875_P_NODE_1315_length_347_cov_1.897436_g1212_i0	PRJNA801875	1315	347	1.897436	6.58410292	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	112	1.0600000000000002e-27	NR	KAJ9455829.1	91374	g1212	i0	48.7	0.976945244956772	113	57	97.7	1	343	5	23	134	KAJ9455829.1 hypothetical protein DIPPA_11672 [Diplonema papillatum]	diamond	339	112	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32330761	32330761	PRJNA801875_P_NODE_899_length_441_cov_5.674877_g797_i0	PRJNA801875	899	441	5.674877	25.02620757	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	180	3.2199999999999992e-55	NR	KAL0482313.1	1008807	g797	i0	62.4	1.92517006802721	141	52	95.9	1	9	431	5	144	KAL0482313.1 peroxiredoxin [Acrasis kona]	diamond	849	180	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona

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