metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1068513" 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
27225163	27225163	PRJNA1068513_S_NODE_6443_length_360_cov_1.327526_g6397_i0	PRJNA1068513	6443	360	1.327526	4.7790936	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	76.6	1.88e-13	NR	XP_044559436.1	5763	g6397	i0	54.8	1.03333333333333	62	28	51.7	0	240	55	553	614	XP_044559436.1 uncharacterized protein FDP41_006197 [Naegleria fowleri]	diamond	372	76.6	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
28038140	28038140	PRJNA1068513_S_NODE_2725_length_514_cov_5.945578_g2681_i0	PRJNA1068513	2725	514	5.945578	30.56027092	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	4.06e-16	NR	XP_002673674.1	5762	g2681	i0	42.7	4.92607003891051	103	59	60.1	0	39	347	222	324	XP_002673674.1 protein kinase [Naegleria gruberi]	diamond	2532	87	0.991954022988506	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
29593173	29593173	PRJNA1068513_S_NODE_7490_length_332_cov_6.216216_g7444_i0	PRJNA1068513	7490	332	6.216216	20.63783712	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	82.8	1.56e-17	NR	XP_002676892.1	5762	g7444	i0	54.3	0.632530120481928	70	32	63.3	0	4	213	71	140	XP_002676892.1 uncharacterized protein NAEGRDRAFT_33801, partial [Naegleria gruberi]	diamond	210	82.8	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
30635827	30635827	PRJNA1068513_S_NODE_8133_length_318_cov_1.510204_g8087_i0	PRJNA1068513	8133	318	1.510204	4.80244872	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	43.5	0.0485	NR	XP_044544297.1	51637	g8087	i0	33.3	0.679245283018868	72	44	64.2	2	14	217	221	292	XP_044544297.1 uncharacterized protein C9374_010127 [Naegleria lovaniensis]	diamond	216	43.5	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria lovaniensis
30825555	30825555	PRJNA1068513_S_NODE_6394_length_361_cov_2.375000_g6348_i0	PRJNA1068513	6394	361	2.375	8.57375	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	62	2.62e-9	NR	XP_002676892.1	5762	g6348	i0	42.6	0.565096952908587	68	38	56.5	1	361	158	74	140	XP_002676892.1 uncharacterized protein NAEGRDRAFT_33801, partial [Naegleria gruberi]	diamond	204	62	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
30888795	30888795	PRJNA1068513_S_NODE_4354_length_431_cov_5.748603_g4309_i0	PRJNA1068513	4354	431	5.748603	24.77647893	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	76.6	3.56e-15	NR	XP_044563804.1	5763	g4309	i0	51.5	0.473317865429234	68	33	47.3	0	301	98	24	91	XP_044563804.1 uncharacterized protein FDP41_002161 [Naegleria fowleri]	diamond	204	76.6	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri
31995557	31995557	PRJNA1068513_S_NODE_12318_length_251_cov_0.876404_g12272_i0	PRJNA1068513	12318	251	0.876404	2.19977404	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	76.3	9.14e-15	NR	XP_002672241.1	5762	g12272	i0	52.8	0.860557768924303	72	31	86.1	1	36	251	115	183	XP_002672241.1 uncharacterized protein NAEGRDRAFT_72753 [Naegleria gruberi]	diamond	216	76.3	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria gruberi
32785342	32785342	PRJNA1068513_S_NODE_9760_length_287_cov_2.037383_g9714_i0	PRJNA1068513	9760	287	2.037383	5.84728921	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	76.3	5.19e-14	NR	XP_044556529.1	5763	g9714	i0	47.4	0.794425087108014	76	40	79.4	0	285	58	235	310	XP_044556529.1 uncharacterized protein FDP41_010036 [Naegleria fowleri]	diamond	228	76.3	1	Eukaryota	Discoba	Heterolobosea	Vahlkampfiidae	Naegleria	Naegleria fowleri

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