metadata: contig_metadata: 10 rows where bioproject = "PRJNA591000" and tax

10 rows where bioproject = "PRJNA591000" 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
26984699	26984699	PRJNA591000_P_NODE_342_length_1495_cov_10.058663_g237_i0	PRJNA591000	342	1495	10.058663	150.37701185	Nanobdellota archaeon	2026764	Archaea	Archaea	70.9	2.16e-9	NR	MEA2036391.1	2026764	g237	i0	59.6	0.11438127090301	57	23	11.4	0	1190	1360	71	127	MEA2036391.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	171	70.9	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
28924624	28924624	PRJNA591000_P_NODE_7428_length_512_cov_3.103520_g5964_i0	PRJNA591000	7428	512	3.10352	15.8900224	root	1	Root_unresolved	Root_unresolved	101	1.02e-21	NR	MBI2559338.1	2026803	g5964	i0	36.5	7.3359375	167	48	87.9	4	498	49	177	302	MBI2559338.1 methyltransferase domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	3756	101	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
29763630	29763630	PRJNA591000_P_NODE_12311_length_414_cov_1.072727_g10725_i0	PRJNA591000	12311	414	1.072727	4.44108978	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	54.3	1.2e-5	NR	MCK9570444.1	2026773	g10725	i0	71	0.22463768115942	31	9	22.5	0	1	93	167	197	MCK9570444.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	93	54.3	1	Archaea	Candidatus Pacearchaeota	Nanobdellati						Candidatus Pacearchaeota archaeon
29953342	29953342	PRJNA591000_P_NODE_5111_length_651_cov_8.289389_g4029_i0	PRJNA591000	5111	651	8.289389	53.96392239	Candidatus Tiddalikarchaeum anstoanum	2885756	Archaea	Archaea	76.6	9.08e-14	NR	VVB75731.1	2885756	g4029	i0	35.2	0.497695852534562	108	69	49.8	1	573	250	34	140	VVB75731.1 Acetyltransferase (GNAT) family protein [Candidatus Tiddalikarchaeum anstoanum]	diamond	324	76.6	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Tiddalikarchaeales	Candidatus Tiddalikarchaeaceae	Candidatus Tiddalikarchaeum	Candidatus Tiddalikarchaeum anstoanum
30364470	30364470	PRJNA591000_P_NODE_11832_length_419_cov_7.679487_g10246_i0	PRJNA591000	11832	419	7.679487	32.17705053	Candidatus Aenigmatarchaeota archaeon	3121606	Archaea	Archaea	68.6	1.3099999999999999e-10	NR	MFB6089005.1	3121606	g10246	i0	38.3	1.51073985680191	107	62	73.7	1	62	370	9	115	MFB6089005.1 glycosyltransferase family 2 protein [Candidatus Aenigmatarchaeota archaeon]	diamond	633	68.6	1	Archaea		Nanobdellati	Candidatus Aenigmatarchaeota					Candidatus Aenigmatarchaeota archaeon
30616701	30616701	PRJNA591000_P_NODE_16113_length_178_cov_3.825503_g14507_i0	PRJNA591000	16113	178	3.825503	6.80939534	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	56.2	2.7e-7	NR	MBW2986670.1	2026803	g14507	i0	41.8	0.926966292134832	55	32	92.7	0	171	7	281	335	MBW2986670.1 carboxypeptidase-like regulatory domain-containing protein [Candidatus Woesearchaeota archaeon]	diamond	165	56.2	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
30648156	30648156	PRJNA591000_P_NODE_6033_length_584_cov_1.605405_g4765_i0	PRJNA591000	6033	584	1.605405	9.3755652	Nanobdellota archaeon	2026764	Archaea	Archaea	48.5	8.81e-4	NR	MEK6879009.1	2026764	g4765	i0	53.5	0.220890410958904	43	19	21.6	1	377	502	11	53	MEK6879009.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	129	48.5	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
31248719	31248719	PRJNA591000_P_NODE_6875_length_535_cov_8.254941_g5477_i0	PRJNA591000	6875	535	8.254941	44.16393435	Nanobdellota archaeon	2026764	Archaea	Archaea	107	6.2e-26	NR	MEK6880998.1	2026764	g5477	i0	43	0.639252336448598	114	64	63.4	1	16	354	35	148	MEK6880998.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	342	107	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
31596940	31596940	PRJNA591000_P_NODE_1536_length_989_cov_19.940625_g1101_i0	PRJNA591000	1536	989	19.940625	197.21278125	Nanobdellota archaeon	2026764	Archaea	Archaea	70.1	2.15e-10	NR	MEK6878467.1	2026764	g1101	i0	38.1	0.35793731041456	118	54	35.5	3	83	433	18	117	MEK6878467.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	354	70.1	1	Archaea		Nanobdellati	Nanobdellota					Nanobdellota archaeon
32293072	32293072	PRJNA591000_P_NODE_16519_length_160_cov_1.725191_g14913_i0	PRJNA591000	16519	160	1.725191	2.7603056	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	93.6	3.52e-22	NR	MAG48440.1	2026803	g14913	i0	77.4	0.99375	53	12	99.4	0	160	2	74	126	MAG48440.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	159	93.6	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);;