metadata: contig_metadata: 11 rows where bioproject = "PRJNA902848" and tax

11 rows where bioproject = "PRJNA902848" 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_species
9809823	9809823	PRJNA902848_P_NODE_14868_length_250_cov_0.881356_g14818_i0	PRJNA902848	14868	250	0.881356	2.20339	Nanobdellota archaeon	2026764	Archaea	Archaea	153	1.9499999999999998e-42	NR	MDP3881745.1	2026764	g14818	i0	82.9	0.984	82	14	98.4	0	246	1	256	337	MDP3881745.1 aspartate--tRNA ligase [Nanoarchaeota archaeon]	diamond	246	153	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27466810	27466810	PRJNA902848_P_NODE_14403_length_251_cov_0.876404_g14353_i0	PRJNA902848	14403	251	0.876404	2.19977404	Nanobdellota archaeon	2026764	Archaea	Archaea	84.7	7.03e-17	NR	MFC1800567.1	2026764	g14353	i0	48.2	0.99203187250996006	83	42	99.2	1	250	2	285	366	MFC1800567.1 FG-GAP-like repeat-containing protein [Nanoarchaeota archaeon]	diamond	249	84.7	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27632206	27632206	PRJNA902848_P_NODE_16584_length_248_cov_0.880000_g16534_i0	PRJNA902848	16584	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	42.4	0.0377	NR	MBI4981139.1	2026803	g16534	i0	51.5	0.846774193548387	33	16	39.9	0	236	138	29	61	MBI4981139.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	210	42.4	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
27782525	27782525	PRJNA902848_P_NODE_20144_length_242_cov_0.923077_g20094_i0	PRJNA902848	20144	242	0.923077	2.23384634	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	70.1	8.6e-12	NR	MCK5614898.1	2026773	g20094	i0	46.8	0.954545454545455	77	39	94.2	2	2	229	605	680	MCK5614898.1 HNH endonuclease [Candidatus Pacearchaeota archaeon]	diamond	231	70.1	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota archaeon
28477051	28477051	PRJNA902848_P_NODE_16926_length_247_cov_0.896552_g16876_i0	PRJNA902848	16926	247	0.896552	2.21448344	Candidatus Micrarchaeota archaeon	2250274	Archaea	Archaea	95.5	1.09e-20	NR	MBU1198097.1	2250274	g16876	i0	57	0.959514170040486	79	26	94.7	2	247	14	772	843	MBU1198097.1 hypothetical protein [Candidatus Micrarchaeota archaeon]	diamond	237	95.5	1	Archaea		Nanobdellati	Candidatus Micrarchaeota		Candidatus Micrarchaeota archaeon
29463033	29463033	PRJNA902848_P_NODE_18370_length_245_cov_0.906977_g18320_i0	PRJNA902848	18370	245	0.906977	2.22209365	Nanobdellati	1783276	Archaea	Archaea	112	1.17e-26	NR	MBU1643590.1	2026764	g18320	i0	67.9	8.62040816326531	78	25	95.5	0	10	243	340	417	MBU1643590.1 DNA topoisomerase I [Nanoarchaeota archaeon]	diamond	2112	112	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
30277389	30277389	PRJNA902848_P_NODE_16412_length_248_cov_0.891429_g16362_i0	PRJNA902848	16412	248	0.891429	2.21074392	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	117	1.46e-30	NR	MEM3405841.1	2026773	g16362	i0	78.7	0.907258064516129	75	16	90.7	0	248	24	173	247	MEM3405841.1 NAD(P)-binding protein [Candidatus Pacearchaeota archaeon]	diamond	225	117	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota archaeon
30751028	30751028	PRJNA902848_P_NODE_17654_length_246_cov_0.901734_g17604_i0	PRJNA902848	17654	246	0.901734	2.21826564	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	117	6.679999999999999e-31	NR	MDP4012162.1	2910166	g17604	i0	71.6	3.95121951219512	81	23	98.8	0	245	3	97	177	MDP4012162.1 MFS transporter [Candidatus Nanoarchaeia archaeon]	diamond	972	117	1	Archaea		Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
31319735	31319735	PRJNA902848_P_NODE_16295_length_248_cov_0.891429_g16245_i0	PRJNA902848	16295	248	0.891429	2.21074392	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	125	1.7899999999999995e-31	NR	MBS3113315.1	2026803	g16245	i0	78	1.98387096774194	82	18	99.2	0	248	3	333	414	MBS3113315.1 CpaF family protein [Candidatus Woesearchaeota archaeon]	diamond	492	125	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
32213246	32213246	PRJNA902848_P_NODE_11278_length_270_cov_2.137056_g11228_i0	PRJNA902848	11278	270	2.137056	5.7700512	Nanobdellati	1783276	Archaea	Archaea	161	1.73e-44	NR	MBS3118471.1	2026803	g11228	i0	86.5	1.97777777777778	89	12	98.9	0	2	268	440	528	MBS3118471.1 aspartate--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	534	161	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
32458812	32458812	PRJNA902848_P_NODE_14499_length_251_cov_0.876404_g14449_i0	PRJNA902848	14499	251	0.876404	2.19977404	Candidatus Pacearchaeota archaeon	2026773	Archaea	Archaea	91.7	2.53e-19	NR	MBM3247619.1	2026773	g14449	i0	53	0.99203187250996006	83	38	99.2	1	250	2	572	653	MBM3247619.1 hypothetical protein [Candidatus Pacearchaeota archaeon]	diamond	249	91.7	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota 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);;