metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA575566" 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
14589133	14589133	PRJNA575566_P_NODE_9272_length_343_cov_1.432624_g9075_i0	PRJNA575566	9272	343	1.432624	4.91390032	Entosiphon sulcatum	101493	Euglenozoa	other_Eukaryota	197	4.26e-57	NR	ABG77330.1	101493	g9075	i0	84.1	9.92711370262391	113	18	98.8	0	343	5	318	430	ABG77330.1 Hsp90, partial [Entosiphon sulcatum]	diamond	3405	197	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemataceae	Entosiphon	Entosiphon sulcatum
26984559	26984559	PRJNA575566_P_NODE_26942_length_205_cov_0.888889_g26745_i0	PRJNA575566	26942	205	0.888889	1.82222245	Bodo saltans	75058	Euglenozoa	other_Eukaryota	90.1	1.63e-20	NR	CUG92810.1	75058	g26745	i0	75	0.819512195121951	56	14	82	0	170	3	1	56	CUG92810.1 40S ribosomal protein S21, putative [Bodo saltans]	diamond	168	90.1	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27332594	27332594	PRJNA575566_P_NODE_25743_length_207_cov_0.876712_g25546_i0	PRJNA575566	25743	207	0.876712	1.81479384	Trypanosoma brucei gambiense DAL972	679716	Euglenozoa	other_Eukaryota	63.5	9.01e-10	NR	XP_011774542.1	679716	g25546	i0	42	1	69	40	100	0	1	207	237	305	XP_011774542.1 heat shock protein DNAJ, putative [Trypanosoma brucei gambiense DAL972]	diamond	207	63.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma brucei
30553324	30553324	PRJNA575566_P_NODE_24513_length_209_cov_0.864865_g24316_i0	PRJNA575566	24513	209	0.864865	1.80756785	Leishmania tarentolae	5689	Euglenozoa	other_Eukaryota	90.9	1.3e-20	NR	GET93160.1	5689	g24316	i0	63.1	6.96172248803828	65	24	93.3	0	13	207	60	124	GET93160.1 40S ribosomal protein S18, putative [Leishmania tarentolae]	diamond	1455	90.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania tarentolae
32166177	32166177	PRJNA575566_P_NODE_19358_length_239_cov_1.078652_g19161_i0	PRJNA575566	19358	239	1.078652	2.57797828	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	67.8	5.23e-11	NR	XP_009310968.1	71804	g19161	i0	42	1.01673640167364	81	43	97.9	2	234	1	408	487	XP_009310968.1 cytochrome P450 [Trypanosoma grayi]	diamond	243	67.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
32211270	32211270	PRJNA575566_P_NODE_29198_length_202_cov_0.907801_g29001_i0	PRJNA575566	29198	202	0.907801	1.83375802	root	1	Root_unresolved	Root_unresolved	104	2.61e-24	NR	CUG88789.1	75058	g29001	i0	72.3	7.72277227722772	65	18	96.5	0	198	4	259	323	CUG88789.1 UTP-glucose-1-phosphate uridylyltransferase, putative [Bodo saltans]	diamond	1560	105	0.990476190476191	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32766094	32766094	PRJNA575566_P_NODE_17320_length_253_cov_1.333333_g17123_i0	PRJNA575566	17320	253	1.333333	3.37333249	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	57	3.9e-7	NR	XP_028877956.1	67003	g17123	i0	50	0.66403162055336	56	24	61.7	1	98	253	266	321	XP_028877956.1 cysteine protease [Trypanosoma theileri]	diamond	168	57	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri

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