metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA928559" 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_genus	tax_species
14930451	14930451	PRJNA928559_P_NODE_146332_length_292_cov_0.958904_g144763_i0	PRJNA928559	146332	292	0.958904	2.79999968	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	87	3.58e-19	NR	MBS3172691.1	2026803	g144763	i0	36.5	1.18150684931507	115	45	90.4	3	292	29	8	121	MBS3172691.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	345	87	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
26835119	26835119	PRJNA928559_P_NODE_83641_length_388_cov_2.758730_g82072_i0	PRJNA928559	83641	388	2.75873	10.7038724	Nanobdellota archaeon	2026764	Archaea	Archaea	124	2.13e-34	NR	MCA9460205.1	2026764	g82072	i0	81	0.610824742268041	79	15	61.1	0	237	1	1	79	MCA9460205.1 NADH-quinone oxidoreductase subunit L [Nanoarchaeota archaeon]	diamond	237	124	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
27214280	27214280	PRJNA928559_P_NODE_188842_length_252_cov_31.983240_g187273_i0	PRJNA928559	188842	252	31.98324	80.5977648	Nanobdellota archaeon	2026764	Archaea	Archaea	119	5.399999999999999e-33	NR	MCA9460427.1	2026764	g187273	i0	89.3	0.892857142857143	75	8	89.3	0	251	27	6	80	MCA9460427.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	225	119	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
28004198	28004198	PRJNA928559_P_NODE_180165_length_259_cov_1.440860_g178596_i0	PRJNA928559	180165	259	1.44086	3.7318274	Nanobdellota archaeon	2026764	Archaea	Archaea	43.1	0.0293	NR	MEK6829632.1	2026764	g178596	i0	35.1	0.66023166023166	57	37	66	0	172	2	54	110	MEK6829632.1 glycosyltransferase family A protein [Nanoarchaeota archaeon]	diamond	171	43.1	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
28004261	28004261	PRJNA928559_P_NODE_71305_length_417_cov_2.232558_g69736_i0	PRJNA928559	71305	417	2.232558	9.30976686	Nanobdellota archaeon	2026764	Archaea	Archaea	179	2.29e-49	NR	MCA9485224.1	2026764	g69736	i0	61.8	1.96402877697842	136	51	97.1	1	413	9	228	363	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	819	179	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
29084789	29084789	PRJNA928559_P_NODE_207048_length_245_cov_0.906977_g205479_i0	PRJNA928559	207048	245	0.906977	2.22209365	Nanobdellati	1783276	Archaea	Archaea	50.4	7.09e-5	NR	MBI4053156.1	2026736	g205479	i0	36.7	1.93469387755102	79	47	96.7	1	7	243	73	148	MBI4053156.1 ammonium transporter [Candidatus Iainarchaeum archaeon]	diamond	474	50.8	0.992125984251969	Archaea		Nanobdellati	Candidatus Iainarchaeota	Candidatus Iainarchaeum	Candidatus Iainarchaeum archaeon
29613949	29613949	PRJNA928559_P_NODE_34530_length_562_cov_3.059305_g32984_i0	PRJNA928559	34530	562	3.059305	17.1932941	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	130	2.1999999999999994e-32	NR	MBT7557133.1	2026803	g32984	i0	57.8	3.80071174377224	102	43	54.4	0	560	255	329	430	MBT7557133.1 aminotransferase [Candidatus Woesearchaeota archaeon]	diamond	2136	130	1	Archaea		Nanobdellati	Candidatus Woesearchaeota		Candidatus Woesearchaeota archaeon
31478664	31478664	PRJNA928559_P_NODE_145176_length_293_cov_1.418182_g143607_i0	PRJNA928559	145176	293	1.418182	4.15527326	Nanobdellota archaeon	2026764	Archaea	Archaea	58.2	2.67e-7	NR	MCK5283566.1	2026764	g143607	i0	35.4	0.808873720136519	79	45	80.9	1	28	264	1059	1131	MCK5283566.1 DUF2341 domain-containing protein [Nanoarchaeota archaeon]	diamond	237	58.2	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
32174663	32174663	PRJNA928559_P_NODE_158278_length_279_cov_1.932039_g156709_i0	PRJNA928559	158278	279	1.932039	5.39038881	Nanobdellota archaeon	2026764	Archaea	Archaea	70.5	7.17e-12	NR	MEK6873354.1	2026764	g156709	i0	44.2	4.08602150537634	95	48	97.8	2	5	277	88	181	MEK6873354.1 deoxyhypusine synthase [Nanoarchaeota archaeon]	diamond	1140	70.5	1	Archaea		Nanobdellati	Nanobdellota		Nanobdellota archaeon
32617214	32617214	PRJNA928559_P_NODE_202200_length_247_cov_0.896552_g200631_i0	PRJNA928559	202200	247	0.896552	2.21448344	Candidatus Pacearchaeota archaeon CG1_	2026773	Archaea	Archaea	50.4	2.82e-5	NR	OIO43237.1	1805298	g200631	i0	30.5	1.7246963562753	82	57	99.6	0	246	1	23	104	OIO43237.1 MAG: 30S ribosomal protein S13 [Candidatus Pacearchaeota archaeon CG1_02_39_14]	diamond	426	50.4	1	Archaea	Candidatus Pacearchaeota	Nanobdellati			Candidatus Pacearchaeota archaeon CG1_02_39_14
32774512	32774512	PRJNA928559_P_NODE_179720_length_259_cov_2.129032_g178151_i0	PRJNA928559	179720	259	2.129032	5.51419288	Nanobdellota archaeon	2026764	Archaea	Archaea	140	1.29e-36	NR	MCA9485224.1	2026764	g178151	i0	72.9	0.984555984555985	85	23	98.5	0	257	3	297	381	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	255	140	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);;