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

10 rows where analysis = "diamond", bioproject = "PRJNA849822" and tax_kingdom = "Nanobdellati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_species
3389224	3389224	PRJNA849822_P_NODE_1443_length_1344_cov_3.821400_g1347_i0	PRJNA849822	1443	1344	3.8214	51.359616	Nanobdellota archaeon	2026764	Archaea	Archaea	137	1.7e-32	NR	MDO8563577.1	2026764	g1347	i0	28.7	0.808035714285714	362	215	79.5	9	1264	197	1	325	MDO8563577.1 FAD-dependent oxidoreductase [Nanoarchaeota archaeon]	diamond	1086	137	1	Archaea		Nanobdellati	Nanobdellota			Nanobdellota archaeon
12317651	12317651	PRJNA849822_P_NODE_10130_length_470_cov_1.239295_g9957_i0	PRJNA849822	10130	470	1.239295	5.8246865	Candidatus Undinarchaeales archaeon SRR5007147.bin71	2756142	Archaea	Archaea	192	5.3499999999999995e-56	NR	HIK01832.1	2756142	g9957	i0	70.5	0.887234042553191	139	41	88.7	0	422	6	4	142	HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71]	diamond	417	192	1	Archaea		Nanobdellati	Candidatus Undinarchaeota	Candidatus Undinarchaeia	Candidatus Undinarchaeales	Candidatus Undinarchaeales archaeon SRR5007147.bin71
26833519	26833519	PRJNA849822_P_NODE_39461_length_246_cov_0.901734_g39287_i0	PRJNA849822	39461	246	0.901734	2.21826564	Candidatus Altiarchaeales archaeon IMC4	1878999	Archaea	Archaea	67.4	8.15e-11	NR	ODS42022.1	1878999	g39287	i0	38.5	1.9390243902439	78	48	95.1	0	1	234	535	612	ODS42022.1 MAG: methionine--tRNA ligase [Candidatus Altiarchaeales archaeon IMC4]	diamond	477	67.4	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales	Candidatus Altiarchaeales archaeon IMC4
27781596	27781596	PRJNA849822_P_NODE_28844_length_272_cov_1.175879_g28670_i0	PRJNA849822	28844	272	1.175879	3.19839088	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	114	2.85e-27	NR	MDA3855007.1	2026803	g28670	i0	55.1	0.981617647058823	89	40	98.2	0	4	270	333	421	MDA3855007.1 adenylosuccinate synthetase [Candidatus Woesearchaeota archaeon]	diamond	267	114	1	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
28539531	28539531	PRJNA849822_P_NODE_39187_length_246_cov_1.734104_g39013_i0	PRJNA849822	39187	246	1.734104	4.26589584	Candidatus Pacearchaeota archaeon CG1	2026773	Archaea	Archaea	64.3	9.41e-10	NR	PIN88984.1	1974444	g39013	i0	55.7	0.74390243902439	61	27	74.4	0	184	2	214	274	PIN88984.1 MAG: hypothetical protein COU60_04895 [Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_34_76]	diamond	183	64.3	1	Archaea	Candidatus Pacearchaeota	Nanobdellati				Candidatus Pacearchaeota archaeon CG10_big_fil_rev_8_21_14_0_10_34_76
29643991	29643991	PRJNA849822_P_NODE_6310_length_619_cov_1.272894_g6141_i0	PRJNA849822	6310	619	1.272894	7.87921386	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	45.1	0.0445	NR	MDD4352955.1	2910166	g6141	i0	26.2	0.499192245557351	103	74	49.9	1	367	59	21	121	MDD4352955.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	309	45.1	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia		Candidatus Nanoarchaeia archaeon
30054759	30054759	PRJNA849822_P_NODE_32111_length_258_cov_1.389189_g31937_i0	PRJNA849822	32111	258	1.389189	3.58410762	Nanobdellota archaeon	2026764	Archaea	Archaea	74.7	2.42e-13	NR	MBU0461306.1	2026764	g31937	i0	47.6	0.976744186046512	84	37	97.7	2	252	1	273	349	MBU0461306.1 class I tRNA ligase family protein [Nanoarchaeota archaeon]	diamond	252	74.7	1	Archaea		Nanobdellati	Nanobdellota			Nanobdellota archaeon
30094658	30094658	PRJNA849822_P_NODE_9852_length_477_cov_2.009901_g9679_i0	PRJNA849822	9852	477	2.009901	9.58722777	root	1	Root_unresolved	Root_unresolved	60.1	4.13e-7	NR	MBN2420797.1	2026803	g9679	i0	58.5	2.73584905660377	41	17	25.8	0	463	341	1075	1115	MBN2420797.1 DUF4215 domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	1305	60.5	0.993388429752066	Archaea		Nanobdellati	Candidatus Woesearchaeota			Candidatus Woesearchaeota archaeon
31097434	31097434	PRJNA849822_P_NODE_17655_length_345_cov_1.378676_g17481_i0	PRJNA849822	17655	345	1.378676	4.7564322	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	94.7	1.94e-20	NR	MBI5035844.1	2250274	g17481	i0	47.8	3.9304347826087	92	47	80	1	284	9	2	92	MBI5035844.1 polyprenyl synthetase family protein [Candidatus Micrarchaeota archaeon]	diamond	1356	94.7	1	Archaea		Nanobdellati	Candidatus Micrarchaeota			Candidatus Micrarchaeota archaeon
31445398	31445398	PRJNA849822_P_NODE_23576_length_298_cov_1.733333_g23402_i0	PRJNA849822	23576	298	1.733333	5.16533234	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	63.2	4.8e-9	NR	HLC47378.1	2910166	g23402	i0	40.7	0.865771812080537	86	17	86.6	1	18	275	346	397	HLC47378.1 DUF4215 domain-containing protein [Candidatus Nanoarchaeia archaeon]	diamond	258	63.2	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia		Candidatus Nanoarchaeia archaeon

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