metadata: contig_metadata: 14 rows where bioproject = "PRJNA493827" and tax

14 rows where bioproject = "PRJNA493827" 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_family	tax_genus	tax_species
7483455	7483455	PRJNA493827_P_NODE_216226_length_244_cov_1.508772_g214028_i0	PRJNA493827	216226	244	1.508772	3.68140368	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	96.3	4.59e-21	NR	MDD3174963.1	2910166	g214028	i0	71.2	3.59016393442623	59	17	72.5	0	68	244	194	252	MDD3174963.1 lysine--tRNA ligase [Candidatus Nanoarchaeia archaeon]	diamond	876	96.3	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia				Candidatus Nanoarchaeia archaeon
8125001	8125001	PRJNA493827_P_NODE_214727_length_245_cov_0.895349_g212529_i0	PRJNA493827	214727	245	0.895349	2.19360505	Nanobdellati	1783276	Archaea	Archaea	53.9	4.36e-6	NR	MEW6329313.1	2250274	g212529	i0	52.3	1.60408163265306	44	21	53.9	0	239	108	66	109	MEW6329313.1 choice-of-anchor X domain-containing protein [Candidatus Micrarchaeota archaeon]	diamond	393	54.3	0.992633517495396	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
17050592	17050592	PRJNA493827_P_NODE_5534_length_1828_cov_4.405698_g4745_i0	PRJNA493827	5534	1828	4.405698	80.53615944	Nanobdellota archaeon	2026764	Archaea	Archaea	282	1.01e-85	NR	MBU0536262.1	2026764	g4745	i0	49.5	2.15809628008753	329	156	53.8	5	823	1806	58	377	MBU0536262.1 NAD-dependent malic enzyme [Nanoarchaeota archaeon]	diamond	3945	282	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
27202981	27202981	PRJNA493827_P_NODE_157562_length_273_cov_1.290000_g155364_i0	PRJNA493827	157562	273	1.29	3.5217	Nanobdellota archaeon	2026764	Archaea	Archaea	73.6	1.27e-14	NR	MCA9459619.1	2026764	g155364	i0	47.6	0.901098901098901	82	43	90.1	0	24	269	4	85	MCA9459619.1 rhodanese-like domain-containing protein [Nanoarchaeota archaeon]	diamond	246	73.6	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
27487699	27487699	PRJNA493827_P_NODE_49783_length_506_cov_1.690531_g47593_i0	PRJNA493827	49783	506	1.690531	8.55408686	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	45.1	0.0311	NR	MEM3857933.1	2953041	g47593	i0	37.3	1.25691699604743	59	28	35	2	470	294	6	55	MEM3857933.1 ankyrin repeat domain-containing protein [Candidatus Micrarchaeaceae archaeon]	diamond	636	45.1	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
28150876	28150876	PRJNA493827_P_NODE_44465_length_542_cov_1.445629_g42278_i0	PRJNA493827	44465	542	1.445629	7.83530918	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	96.7	1.22e-19	NR	MCK5617231.1	2026773	g42278	i0	43.7	0.747232472324723	135	69	70.8	3	384	1	4	138	MCK5617231.1 phage tail sheath subtilisin-like domain-containing protein [Candidatus Pacearchaeota archaeon]	diamond	405	96.7	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
28308647	28308647	PRJNA493827_P_NODE_51946_length_493_cov_4.664286_g49756_i0	PRJNA493827	51946	493	4.664286	22.99492998	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	114	3.67e-29	NR	MAG22070.1	2026736	g49756	i0	46.9	0.778904665314402	128	68	77.9	0	41	424	3	130	MAG22070.1 hypothetical protein [Candidatus Iainarchaeum archaeon]	diamond	384	114	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
28719087	28719087	PRJNA493827_P_NODE_26347_length_739_cov_2.878378_g24391_i0	PRJNA493827	26347	739	2.878378	21.27121342	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	212	2.95e-63	NR	MEM4261305.1	2026803	g24391	i0	52.1	0.880920162381597	217	95	87.3	5	95	739	9	218	MEM4261305.1 putative DNA base hypermodification protein [Candidatus Woesearchaeota archaeon]	diamond	651	212	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
28845090	28845090	PRJNA493827_P_NODE_178248_length_255_cov_2.401099_g176050_i0	PRJNA493827	178248	255	2.401099	6.12280245	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	46.2	0.00263	NR	NYZ76090.1	2250274	g176050	i0	50	0.882352941176471	44	22	51.8	0	13	144	18	61	NYZ76090.1 serpin family protein [Candidatus Micrarchaeota archaeon]	diamond	225	46.2	1	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
28908096	28908096	PRJNA493827_P_NODE_133408_length_296_cov_0.923767_g131210_i0	PRJNA493827	133408	296	0.923767	2.73435032	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	60.5	3.94e-8	NR	MBD3309741.1	2026803	g131210	i0	68.3	0.983108108108108	41	11	40.5	2	3	122	198	237	MBD3309741.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	291	60.5	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29318878	29318878	PRJNA493827_P_NODE_84169_length_375_cov_1.019868_g81971_i0	PRJNA493827	84169	375	1.019868	3.824505	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	44.7	0.0343	NR	MBS3075971.1	2026773	g81971	i0	38.7	0.496	62	32	49.6	1	188	373	160	215	MBS3075971.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	186	44.7	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
30898419	30898419	PRJNA493827_P_NODE_191214_length_250_cov_0.870056_g189016_i0	PRJNA493827	191214	250	0.870056	2.17514	Candidatus ainarchaeum sp.	N/A	Archaea	Archaea	52.4	1.65e-5	NR	MDD3159933.1	3018264	g189016	i0	48.3	5.004	60	29	70.8	2	202	26	379	437	MDD3159933.1 hypothetical protein [Candidatus ainarchaeum sp.]	diamond	1251	52.4	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus ainarchaeum sp.
32068251	32068251	PRJNA493827_P_NODE_34938_length_626_cov_2.410488_g32782_i0	PRJNA493827	34938	626	2.410488	15.08965488	Candidatus Micrarchaeaceae archaeon	2953041	Archaea	Archaea	76.3	2.29e-12	NR	MEM0149941.1	2953041	g32782	i0	53.4	4.31309904153355	73	33	34.5	1	1	216	13	85	MEM0149941.1 molecular chaperone DnaJ [Candidatus Micrarchaeaceae archaeon]	diamond	2700	76.3	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Micrarchaeales	Candidatus Micrarchaeaceae		Candidatus Micrarchaeaceae archaeon
32099896	32099896	PRJNA493827_P_NODE_148738_length_281_cov_0.889423_g146540_i0	PRJNA493827	148738	281	0.889423	2.49927863	Nanobdellota archaeon	2026764	Archaea	Archaea	44.3	0.0138	NR	MEK6860013.1	2026764	g146540	i0	42.3	1.77224199288256	52	30	55.5	0	122	277	79	130	MEK6860013.1 50S ribosomal protein L2 [Nanoarchaeota archaeon]	diamond	498	44.3	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota 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);;