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

10 rows where analysis = "diamond", bioproject = "PRJNA662254" and tax_phylum = "Heterolobosea"

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_family	tax_genus	tax_species
1904562	1904562	PRJNA662254_P_NODE_7702_length_610_cov_1.486034_g7074_i0	PRJNA662254	7702	610	1.486034	9.0648074	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	356	2.5599999999999997e-121	NR	XP_044557880.1	5763	g7074	i0	85.2	1.99672131147541	203	30	99.8	0	1	609	52	254	XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri]	diamond	1218	356	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
15931156	15931156	PRJNA662254_P_NODE_36973_length_276_cov_1.137931_g36322_i0	PRJNA662254	36973	276	1.137931	3.14068956	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	153	4.72e-45	NR	XP_044556321.1	5763	g36322	i0	75	339.989130434783	92	23	100	0	1	276	21	112	XP_044556321.1 uncharacterized protein FDP41_010134 [Naegleria fowleri]	diamond	93837	154	0.993506493506494	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
19755191	19755191	PRJNA662254_P_NODE_23796_length_338_cov_1.162264_g23145_i0	PRJNA662254	23796	338	1.162264	3.92845232	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	124	9.03e-31	NR	XP_002682064.1	5762	g23145	i0	52.7	0.994082840236686	112	53	99.4	0	1	336	175	286	XP_002682064.1 ammonium transporter AmtA [Naegleria gruberi]	diamond	336	124	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
24854636	24854636	PRJNA662254_P_NODE_54400_length_247_cov_0.885057_g53749_i0	PRJNA662254	54400	247	0.885057	2.18609079	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	1.4099999999999998e-32	NR	XP_002678219.1	5762	g53749	i0	75.6	74.6842105263158	82	20	99.6	0	1	246	593	674	XP_002678219.1 P-type II calcium ATPase [Naegleria gruberi]	diamond	18447	130	0.992307692307692	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
27934309	27934309	PRJNA662254_P_NODE_47405_length_250_cov_0.870056_g46754_i0	PRJNA662254	47405	250	0.870056	2.17514	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	93.2	1.02e-20	NR	KAL0486964.1	1008807	g46754	i0	45.8	7.908	83	45	99.6	0	2	250	105	187	KAL0486964.1 hypothetical protein AKO1_001270 [Acrasis kona]	diamond	1977	93.2	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
28029115	28029115	PRJNA662254_P_NODE_59305_length_244_cov_0.900585_g58654_i0	PRJNA662254	59305	244	0.900585	2.1974274	Psalteriomonas lanterna	31290	Heterolobosea	other_Eukaryota	72.4	7.29e-13	NR	ACZ97597.1	31290	g58654	i0	40.7	0.995901639344262	81	48	99.6	0	1	243	108	188	ACZ97597.1 ADP-ATP carrier protein, partial [Psalteriomonas lanterna]	diamond	243	72.4	1	Eukaryota	Discoba	Heterolobosea	Psalteriomonadidae	Psalteriomonas	Psalteriomonas lanterna
29039619	29039619	PRJNA662254_P_NODE_60048_length_244_cov_0.900585_g59397_i0	PRJNA662254	60048	244	0.900585	2.1974274	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	43.5	0.0204	NR	XP_044563371.1	5763	g59397	i0	32.8	0.75	61	41	75	0	28	210	417	477	XP_044563371.1 uncharacterized protein FDP41_002478 [Naegleria fowleri]	diamond	183	43.5	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
29260139	29260139	PRJNA662254_P_NODE_24209_length_335_cov_1.412214_g23558_i0	PRJNA662254	24209	335	1.412214	4.7309169	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	100	3.0500000000000003e-22	NR	KAL0488809.1	1008807	g23558	i0	58.3	1.77313432835821	84	33	73.4	1	2	247	13	96	KAL0488809.1 dnaJ subfamily A protein [Acrasis kona]	diamond	594	100	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona
29323378	29323378	PRJNA662254_P_NODE_38109_length_272_cov_1.150754_g37458_i0	PRJNA662254	38109	272	1.150754	3.13005088	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	95.9	2.63e-21	NR	XP_044557751.1	5763	g37458	i0	50	1.88602941176471	84	42	92.6	0	256	5	29	112	XP_044557751.1 uncharacterized protein FDP41_008702 [Naegleria fowleri]	diamond	513	95.9	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
30776619	30776619	PRJNA662254_P_NODE_34334_length_285_cov_1.235849_g33683_i0	PRJNA662254	34334	285	1.235849	3.52216965	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	127	1.7399999999999998e-32	NR	KAL0477610.1	1008807	g33683	i0	64.9	1.97894736842105	94	33	98.9	0	3	284	210	303	KAL0477610.1 medium-chain specific acyl-CoA dehydrogenase ACADM, mitochondrial [Acrasis kona]	diamond	564	127	1	Eukaryota	Discoba	Heterolobosea	Acrasidae	Acrasis	Acrasis kona

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