metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA643700" 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
26701263	26701263	PRJNA643700_P_NODE_415541_length_164_cov_0.904348_g413985_i0	PRJNA643700	415541	164	0.904348	1.48313072	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	76.3	1.59e-14	NR	KAF5217509.1	5693	g413985	i0	83.6	1.00609756097561	55	8	98.8	1	2	163	153	207	KAF5217509.1 Mucin-associated surface protein (MASP) subgroup S049 [Trypanosoma cruzi]	diamond	165	76.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
28028937	28028937	PRJNA643700_P_NODE_362085_length_180_cov_1.190840_g360529_i0	PRJNA643700	362085	180	1.19084	2.143512	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	109	7.6e-27	NR	RNC49760.1	5693	g360529	i0	98.3	0.983333333333333	59	1	98.3	0	2	178	124	182	RNC49760.1 hypothetical protein TcCL_NonESM00081 [Trypanosoma cruzi]	diamond	177	109	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
28912636	28912636	PRJNA643700_P_NODE_359988_length_181_cov_1.128788_g358432_i0	PRJNA643700	359988	181	1.128788	2.04310628	Trypanosoma cruzi cruzi	85057	Euglenozoa	other_Eukaryota	110	1.98e-28	NR	PBJ71303.1	85057	g358432	i0	100	0.994475138121547	60	0	99.4	0	1	180	41	100	PBJ71303.1 mucin TcMUCII [Trypanosoma cruzi cruzi]	diamond	180	110	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
31092309	31092309	PRJNA643700_P_NODE_413455_length_164_cov_0.904348_g411899_i0	PRJNA643700	413455	164	0.904348	1.48313072	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	70.5	2.06e-12	NR	EKG07770.1	5693	g411899	i0	67.3	1.00609756097561	55	16	97	1	2	160	74	128	EKG07770.1 hypothetical protein TCSYLVIO_001099 [Trypanosoma cruzi]	diamond	165	70.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
32136173	32136173	PRJNA643700_P_NODE_287058_length_217_cov_0.976190_g285502_i0	PRJNA643700	287058	217	0.97619	2.1183323	Trypanosoma cruzi cruzi	85057	Euglenozoa	other_Eukaryota	97.8	1.1e-21	NR	PBJ68388.1	85057	g285502	i0	100	2.03225806451613	49	0	67.7	0	148	2	1	49	PBJ68388.1 hypothetical protein BCY84_21650 [Trypanosoma cruzi cruzi]	diamond	441	97.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
32136176	32136176	PRJNA643700_P_NODE_398318_length_167_cov_0.881356_g396762_i0	PRJNA643700	398318	167	0.881356	1.47186452	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	44.3	0.00329	NR	RNF15585.1	5693	g396762	i0	100	0.359281437125749	20	0	35.9	0	165	106	202	221	RNF15585.1 hypothetical protein TcG_06964 [Trypanosoma cruzi]	diamond	60	44.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi

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