metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax

11 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
1399462	1399462	PRJEB58983_P_NODE_29342_length_249_cov_1.465909_g28927_i0	PRJEB58983	29342	249	1.465909	3.65011341	Bodo saltans	75058	Euglenozoa	other_Eukaryota	128	3.61e-32	NR	CUE66261.1	75058	g28927	i0	83.1	0.927710843373494	77	13	92.8	0	248	18	1178	1254	CUE66261.1 structural maintenance of chromosome family protein, putative [Bodo saltans]	diamond	231	128	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
7777354	7777354	PRJEB58983_P_NODE_23727_length_271_cov_1.479798_g23312_i0	PRJEB58983	23727	271	1.479798	4.01025258	Angomonas deanei	59799	Euglenozoa	other_Eukaryota	106	2.02e-27	NR	EPY34978.1	59799	g23312	i0	72.1	0.675276752767528	61	17	67.5	0	267	85	66	126	EPY34978.1 ubiquinol-cytochrome c reductase subunit 7 [Angomonas deanei]	diamond	183	106	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
11195475	11195475	PRJEB58983_P_NODE_34729_length_227_cov_2.025974_g34314_i0	PRJEB58983	34729	227	2.025974	4.59896098	Bodo saltans	75058	Euglenozoa	other_Eukaryota	127	2.9399999999999995e-35	NR	CUI14406.1	75058	g34314	i0	86.7	0.991189427312775	75	10	99.1	0	225	1	71	145	CUI14406.1 60S ribosomal protein L9, putative [Bodo saltans]	diamond	225	127	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
21394135	21394135	PRJEB58983_P_NODE_17717_length_306_cov_1.339056_g17302_i0	PRJEB58983	17717	306	1.339056	4.09751136	Bodo saltans	75058	Euglenozoa	other_Eukaryota	67	2.28e-10	NR	CUG87077.1	75058	g17302	i0	71.4	0.549019607843137	56	15	53.9	1	243	79	151	206	CUG87077.1 dihydrolipoamide acetyltransferase, putative [Bodo saltans]	diamond	168	67	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27785201	27785201	PRJEB58983_P_NODE_33064_length_238_cov_2.363636_g32649_i0	PRJEB58983	33064	238	2.363636	5.62545368	Leishmania	5658	Euglenozoa	other_Eukaryota	124	4.33e-33	NR	XP_067695602.1	5663	g32649	i0	78.2	8.84873949579832	78	17	98.3	0	237	4	15	92	XP_067695602.1 hypothetical protein CUR178_07471 [Leishmania enriettii]	diamond	2106	124	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania enriettii
27886431	27886431	PRJEB58983_P_NODE_31065_length_245_cov_1.087209_g30650_i0	PRJEB58983	31065	245	1.087209	2.66366205	Bodo saltans	75058	Euglenozoa	other_Eukaryota	69.3	1.7e-11	NR	CUF98858.1	75058	g30650	i0	73.8	0.514285714285714	42	11	51.4	0	33	158	1701	1742	CUF98858.1 Hypothetical protein, putative [Bodo saltans]	diamond	126	69.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
29685848	29685848	PRJEB58983_P_NODE_24970_length_265_cov_2.020833_g24555_i0	PRJEB58983	24970	265	2.020833	5.35520745	Bodo saltans	75058	Euglenozoa	other_Eukaryota	48.9	3.35e-4	NR	CUG90535.1	75058	g24555	i0	39	0.928301886792453	82	43	92.8	3	2	247	549	623	CUG90535.1 Hypothetical protein, putative [Bodo saltans]	diamond	246	48.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31771927	31771927	PRJEB58983_P_NODE_31457_length_244_cov_1.385965_g31042_i0	PRJEB58983	31457	244	1.385965	3.3817546	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	84	8.94e-19	NR	XP_011772066.1	679716	g31042	i0	67.2	0.75	61	20	75	0	243	61	53	113	XP_011772066.1 ribosomal protein S25, putative [Trypanosoma brucei gambiense DAL972]	diamond	183	84	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
32049886	32049886	PRJEB58983_P_NODE_12778_length_353_cov_2.953571_g12363_i0	PRJEB58983	12778	353	2.953571	10.42610563	root	1	Root_unresolved	Root_unresolved	125	6.46e-34	NR	EPY34433.1	59799	g12363	i0	54.3	3.4929178470255	105	46	87.5	1	353	45	73	177	EPY34433.1 large subunit ribosomal protein L23e [Angomonas deanei]	diamond	1233	125	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Angomonas	Angomonas deanei
32398094	32398094	PRJEB58983_P_NODE_25699_length_262_cov_1.010582_g25284_i0	PRJEB58983	25699	262	1.010582	2.64772484	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	112	5.670000000000001e-29	NR	9F9P_K	5693	g25284	i0	60.5	3.73282442748092	81	32	92.7	0	251	9	125	205	9F9P_K Chain K, Proteasome subunit beta [Trypanosoma cruzi]	diamond	978	112	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
32625829	32625829	PRJEB58983_P_NODE_28840_length_250_cov_1.994350_g28425_i0	PRJEB58983	28840	250	1.99435	4.985875	Leptomonas seymouri	5684	Euglenozoa	other_Eukaryota	65.9	4.96e-12	NR	KPI90566.1	5684	g28425	i0	68.6	1.764	51	15	61.2	1	24	176	28	77	KPI90566.1 hypothetical protein ABL78_0326 [Leptomonas seymouri]	diamond	441	65.9	1	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);;