metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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
21853638	21853638	PRJNA1059246_P_NODE_15598_length_591_cov_2.270270_g14997_i0	PRJNA1059246	15598	591	2.27027	13.4172957	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	287	9.32e-91	NR	MFH1260759.1	2250274	g14997	i0	69.4	5.96954314720812	196	60	99.5	0	590	3	28	223	MFH1260759.1 citrate/2-methylcitrate synthase [Candidatus Micrarchaeota archaeon]	diamond	3528	287	1	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
26750112	26750112	PRJNA1059246_P_NODE_61381_length_251_cov_1.477528_g60755_i0	PRJNA1059246	61381	251	1.477528	3.70859528	Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3	2013675	Archaea	Archaea	50.1	1.09e-4	NR	PKP54324.1	2013675	g60755	i0	38	0.848605577689243	71	44	84.9	0	19	231	379	449	PKP54324.1 MAG: hypothetical protein CVT90_01855, partial [Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3]	diamond	213	50.1	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales			Candidatus Altiarchaeales archaeon HGW-Altiarchaeales-3
26972028	26972028	PRJNA1059246_P_NODE_52982_length_280_cov_1.294686_g52356_i0	PRJNA1059246	52982	280	1.294686	3.6251208	Candidatus Bilamarchaeum sp.	3070761	Archaea	Archaea	56.2	1.01e-6	NR	HSB46950.1	3070761	g52356	i0	41.3	0.803571428571429	75	40	76.1	1	214	2	43	117	HSB46950.1 serine/threonine-protein kinase [Candidatus Bilamarchaeum sp.]	diamond	225	56.2	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Anstonellales	Candidatus Bilamarchaeaceae	Candidatus Bilamarchaeum	Candidatus Bilamarchaeum sp.
27161562	27161562	PRJNA1059246_P_NODE_44422_length_315_cov_0.900826_g43796_i0	PRJNA1059246	44422	315	0.900826	2.8376019	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	169	4e-47	NR	MFH1260759.1	2250274	g43796	i0	78.8	0.990476190476191	104	22	99	0	314	3	408	511	MFH1260759.1 citrate/2-methylcitrate synthase [Candidatus Micrarchaeota archaeon]	diamond	312	169	1	Archaea		Nanobdellati	Candidatus Micrarchaeota					Candidatus Micrarchaeota archaeon
27351671	27351671	PRJNA1059246_P_NODE_28143_length_416_cov_1.571429_g27518_i0	PRJNA1059246	28143	416	1.571429	6.53714464	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	137	1.97e-37	NR	MCD6477371.1	3121606	g27518	i0	48.6	0.995192307692308	138	67	98.8	3	414	4	44	178	MCD6477371.1 adenylate kinase [Candidatus Aenigmatarchaeota archaeon]	diamond	414	137	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
27825266	27825266	PRJNA1059246_P_NODE_61824_length_251_cov_0.865169_g61198_i0	PRJNA1059246	61824	251	0.865169	2.17157419	Nanobdellota archaeon	2026764	Archaea	Archaea	60.8	8.89e-9	NR	MFC1697897.1	2026764	g61198	i0	45	0.956175298804781	80	32	94.4	4	247	11	121	189	MFC1697897.1 Kazal-type serine protease inhibitor domain-containing protein [Nanoarchaeota archaeon]	diamond	240	60.8	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
28172391	28172391	PRJNA1059246_P_NODE_71786_length_241_cov_1.833333_g71160_i0	PRJNA1059246	71786	241	1.833333	4.41833253	Candidatus Iainarchaeum archaeon	3101447	Archaea	Archaea	55.8	5.79e-8	NR	HRT02854.1	2026736	g71160	i0	39.1	0.796680497925311	64	35	74.7	1	217	38	21	84	HRT02854.1 hypothetical protein [Candidatus Iainarchaeum archaeon]	diamond	192	55.8	1	Archaea		Nanobdellati	Candidatus Iainarchaeota				Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
28543382	28543382	PRJNA1059246_P_NODE_59207_length_259_cov_1.586022_g58581_i0	PRJNA1059246	59207	259	1.586022	4.10779698	root	1	Root_unresolved	Root_unresolved	104	3.35e-26	NR	MEM4326218.1	2026773	g58581	i0	98.1	1.22779922779923	53	1	61.4	0	161	3	1	53	MEM4326218.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	318	104	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
29655997	29655997	PRJNA1059246_P_NODE_55430_length_272_cov_1.497487_g54804_i0	PRJNA1059246	55430	272	1.497487	4.07316464	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	71.2	1.68e-13	NR	MBD3319325.1	2026803	g54804	i0	45.7	0.772058823529412	70	30	68.4	1	74	259	56	125	MBD3319325.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	210	71.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
30762216	30762216	PRJNA1059246_P_NODE_67514_length_246_cov_0.890173_g66888_i0	PRJNA1059246	67514	246	0.890173	2.18982558	Candidatus Altiarchaeales archaeon	2250256	Archaea	Archaea	53.1	2.56e-6	NR	MBD3260514.1	2250256	g66888	i0	56.5	1.13414634146341	46	19	56.1	1	239	102	84	128	MBD3260514.1 DUF4419 domain-containing protein [Candidatus Altiarchaeales archaeon]	diamond	279	53.1	1	Archaea		Nanobdellati	Candidatus Altarchaeota	Candidatus Altiarchaeia	Candidatus Altarchaeales			Candidatus Altiarchaeales archaeon
31552634	31552634	PRJNA1059246_P_NODE_6856_length_939_cov_3.331409_g6383_i0	PRJNA1059246	6856	939	3.331409	31.28193051	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	46.2	0.0451	NR	MFP4609112.1	3121606	g6383	i0	38.1	0.201277955271566	63	34	20.1	2	407	595	113	170	MFP4609112.1 hypothetical protein [Candidatus Aenigmatarchaeota archaeon]	diamond	189	46.2	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
31900359	31900359	PRJNA1059246_P_NODE_68677_length_245_cov_0.895349_g68051_i0	PRJNA1059246	68677	245	0.895349	2.19360505	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	52.8	7.01e-7	NR	MFA5796612.1	2026803	g68051	i0	43.1	1.49387755102041	58	33	71	0	245	72	15	72	MFA5796612.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	366	52.8	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
31995274	31995274	PRJNA1059246_P_NODE_58558_length_261_cov_2.957447_g57932_i0	PRJNA1059246	58558	261	2.957447	7.71893667	Candidatus Bilamarchaeum sp.	3070761	Archaea	Archaea	49.7	1.59e-4	NR	HSB46950.1	3070761	g57932	i0	51.1	1.13793103448276	47	20	54	1	90	230	44	87	HSB46950.1 serine/threonine-protein kinase [Candidatus Bilamarchaeum sp.]	diamond	297	49.7	1	Archaea		Nanobdellati	Candidatus Micrarchaeota	Candidatus Micrarchaeia	Candidatus Anstonellales	Candidatus Bilamarchaeaceae	Candidatus Bilamarchaeum	Candidatus Bilamarchaeum sp.
32122000	32122000	PRJNA1059246_P_NODE_51418_length_285_cov_1.146226_g50792_i0	PRJNA1059246	51418	285	1.146226	3.2667441	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	71.2	2.68e-13	NR	MBS3109792.1	2026803	g50792	i0	55.7	0.642105263157895	61	24	61.1	1	192	19	71	131	MBS3109792.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	183	71.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota 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);;