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

10 rows where analysis = "diamond", bioproject = "PRJNA680334" 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
29450102	29450102	PRJNA680334_S_NODE_41830_length_203_cov_1.723529_g41344_i0	PRJNA680334	41830	203	1.723529	3.49876387	Paratrypanosoma confusum	1470209	Euglenozoa	other_Eukaryota	103	4.059999999999999e-24	NR	AGG11530.1	1470209	g41344	i0	73.4	0.945812807881773	64	17	94.6	0	7	198	324	387	AGG11530.1 hypothetical protein, partial [Paratrypanosoma confusum]	diamond	192	103	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Paratrypanosoma	Paratrypanosoma confusum
30208043	30208043	PRJNA680334_S_NODE_77292_length_167_cov_1.910448_g76806_i0	PRJNA680334	77292	167	1.910448	3.19044816	Leptomonas seymouri	5684	Euglenozoa	other_Eukaryota	41.2	0.0455	NR	KPI82425.1	5684	g76806	i0	60.5	0.682634730538922	38	15	68.3	0	165	52	221	258	KPI82425.1 putative 40S ribosomal protein S4 [Leptomonas seymouri]	diamond	114	41.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri
30788848	30788848	PRJNA680334_S_NODE_27334_length_231_cov_3.646465_g26848_i0	PRJNA680334	27334	231	3.646465	8.42333415	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	42.7	0.0331	NR	KPI87126.1	5684	g26848	i0	45.9	3.01298701298701	37	20	48.1	0	19	129	9	45	KPI87126.1 putative vacuolar proton translocating ATPase subunit A [Leptomonas seymouri]	diamond	696	43.1	0.990719257540603	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas seymouri
31041952	31041952	PRJNA680334_S_NODE_70155_length_172_cov_3.496403_g69669_i0	PRJNA680334	70155	172	3.496403	6.01381316	root	1	Root_unresolved	Root_unresolved	73.6	9.71e-14	NR	KAL0487522.1	1008807	g69669	i0	70.6	3.75	51	15	89	0	171	19	161	211	KAL0487522.1 pantothenate synthetase [Acrasis kona]	diamond	645	73.9	0.995940460081191	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31093006	31093006	PRJNA680334_S_NODE_108115_length_150_cov_1.247863_g107629_i0	PRJNA680334	108115	150	1.247863	1.8717945	Bodo saltans	75058	Euglenozoa	other_Eukaryota	44.7	0.00217	NR	CUG84127.1	75058	g107629	i0	49	0.98	49	25	98	0	3	149	1529	1577	CUG84127.1 Hypothetical protein, putative [Bodo saltans]	diamond	147	44.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31124254	31124254	PRJNA680334_S_NODE_72555_length_170_cov_3.963504_g72069_i0	PRJNA680334	72555	170	3.963504	6.7379568	Bodo saltans	75058	Euglenozoa	other_Eukaryota	76.6	2e-15	NR	CUG89078.1	75058	g72069	i0	70.6	1.8	51	15	90	0	6	158	139	189	CUG89078.1 translation elongation factor 1-beta, putative [Bodo saltans]	diamond	306	76.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31567560	31567560	PRJNA680334_S_NODE_27096_length_232_cov_1.814070_g26610_i0	PRJNA680334	27096	232	1.81407	4.2086424	Bodo saltans	75058	Euglenozoa	other_Eukaryota	123	1.12e-33	NR	CUG90960.1	75058	g26610	i0	75.7	1.91379310344828	74	17	94.4	1	232	14	106	179	CUG90960.1 40S ribosomal protein S11, putative, partial [Bodo saltans]	diamond	444	123	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31599138	31599138	PRJNA680334_S_NODE_42696_length_201_cov_8.101190_g42210_i0	PRJNA680334	42696	201	8.10119	16.2833919	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	50.8	2.01e-5	NR	XP_817427.1	5693	g42210	i0	46.9	1.46268656716418	49	25	71.6	1	194	51	16	64	XP_817427.1 hypothetical protein, conserved [Trypanosoma cruzi]	diamond	294	50.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
31820233	31820233	PRJNA680334_S_NODE_81557_length_164_cov_2.221374_g81071_i0	PRJNA680334	81557	164	2.221374	3.64305336	Leishmania utingensis	653362	Euglenozoa	other_Eukaryota	48.9	1.56e-5	NR	KAL0507949.1	653362	g81071	i0	60	1.60975609756098	45	18	82.3	0	1	135	64	108	KAL0507949.1 hypothetical protein Q4I30_003146, partial [Leishmania utingensis]	diamond	264	48.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania utingensis
32168612	32168612	PRJNA680334_S_NODE_105178_length_151_cov_2.305085_g104692_i0	PRJNA680334	105178	151	2.305085	3.48067835	Bodo saltans	75058	Euglenozoa	other_Eukaryota	48.9	7.11e-5	NR	CUG46614.1	75058	g104692	i0	74.2	1.25165562913907	31	8	61.6	0	5	97	471	501	CUG46614.1 Hypothetical protein, putative [Bodo saltans]	diamond	189	48.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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