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

9 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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
14304787	14304787	PRJNA1120586_P_NODE_25932_length_274_cov_1.053659_g25741_i0	PRJNA1120586	25932	274	1.053659	2.88702566	Bodo saltans	75058	Euglenozoa	other_Eukaryota	79.7	2.41e-15	NR	CUG01306.1	75058	g25741	i0	85.9	0.930656934306569	85	12	93.1	0	4	258	61	145	CUG01306.1 WD40 repeat-containing protein, putative [Bodo saltans]	diamond	255	79.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
15579243	15579243	PRJNA1120586_P_NODE_51353_length_227_cov_0.911392_g51162_i0	PRJNA1120586	51353	227	0.911392	2.06885984	Bodo saltans	75058	Euglenozoa	other_Eukaryota	110	2.76e-28	NR	CUG83879.1	75058	g51162	i0	72.1	0.898678414096916	68	19	89.9	0	24	227	102	169	CUG83879.1 Hypothetical protein, putative [Bodo saltans]	diamond	204	110	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29627472	29627472	PRJNA1120586_P_NODE_46610_length_230_cov_0.894410_g46419_i0	PRJNA1120586	46610	230	0.89441	2.057143	Trypanosoma congolense IL3	5692	Euglenozoa	other_Eukaryota	51.6	2.32e-5	NR	CCC92215.1	1068625	g46419	i0	43.8	0.952173913043478	73	35	95.2	3	221	3	93	159	CCC92215.1 conserved hypothetical protein [Trypanosoma congolense IL3000]	diamond	219	51.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma congolense
29754071	29754071	PRJNA1120586_P_NODE_41411_length_234_cov_0.872727_g41220_i0	PRJNA1120586	41411	234	0.872727	2.04218118	Trypanosoma vivax	5699	Euglenozoa	other_Eukaryota	43.9	0.0133	NR	KAG8344580.1	5699	g41220	i0	32.9	0.935897435897436	73	49	93.6	0	228	10	189	261	KAG8344580.1 hypothetical protein TRVL_04590 [Trypanosoma vivax]	diamond	219	43.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma vivax
29785709	29785709	PRJNA1120586_P_NODE_46811_length_230_cov_0.894410_g46620_i0	PRJNA1120586	46811	230	0.89441	2.057143	Bodo saltans	75058	Euglenozoa	other_Eukaryota	69.7	9.83e-12	NR	CUG06210.1	75058	g46620	i0	54	0.652173913043478	50	23	65.2	0	150	1	314	363	CUG06210.1 membrane-associated protein, putative [Bodo saltans]	diamond	150	69.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30090764	30090764	PRJNA1120586_P_NODE_22132_length_289_cov_1.309091_g21941_i0	PRJNA1120586	22132	289	1.309091	3.78327299	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	77	1.35e-15	NR	RNF05392.1	5693	g21941	i0	46.7	7.39100346020761	90	43	88.2	3	269	15	2	91	RNF05392.1 profilin, partial [Trypanosoma cruzi]	diamond	2136	77.4	0.994832041343669	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
32219871	32219871	PRJNA1120586_P_NODE_51518_length_227_cov_0.911392_g51327_i0	PRJNA1120586	51518	227	0.911392	2.06885984	Bodo saltans	75058	Euglenozoa	other_Eukaryota	83.6	1.19e-16	NR	CUF54605.1	75058	g51327	i0	70.2	0.753303964757709	57	17	75.3	0	1	171	268	324	CUF54605.1 transmembrane protein, putative [Bodo saltans]	diamond	171	83.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32630619	32630619	PRJNA1120586_P_NODE_53040_length_226_cov_0.917197_g52849_i0	PRJNA1120586	53040	226	0.917197	2.07286522	Bodo saltans	75058	Euglenozoa	other_Eukaryota	70.9	3.79e-12	NR	CUF96838.1	75058	g52849	i0	50.7	0.915929203539823	69	34	91.6	0	20	226	1861	1929	CUF96838.1 transmembrane protein, putative, partial [Bodo saltans]	diamond	207	70.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32662088	32662088	PRJNA1120586_P_NODE_52760_length_226_cov_0.917197_g52569_i0	PRJNA1120586	52760	226	0.917197	2.07286522	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	90.1	6.43e-19	NR	KAJ9453785.1	91374	g52569	i0	63	4.81858407079646	73	27	96.9	0	7	225	1357	1429	KAJ9453785.1 ABC transporter A family member 1 [Diplonema papillatum]	diamond	1089	90.1	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum

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