metadata: contig_metadata: 8 rows where bioproject = "PRJNA690592", tax_phylum = "Nanobdellota" and tax

8 rows where bioproject = "PRJNA690592", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_class	tax_species
4498898	4498898	PRJNA690592_S_NODE_1204_length_1927_cov_4.110572_g985_i0	PRJNA690592	1204	1927	4.110572	79.21072244	Nanobdellota archaeon	2026764	Archaea	Archaea	798	2.9300000000000003e-281	NR	MCA9485224.1	2026764	g985	i0	67.5	1.84483653347172	566	182	87.8	2	1922	231	217	782	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	3555	798	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
21073420	21073420	PRJNA690592_S_NODE_146497_length_280_cov_1.115942_g145483_i0	PRJNA690592	146497	280	1.115942	3.1246376	Nanobdellota archaeon	2026764	Archaea	Archaea	135	1.2699999999999998e-35	NR	MCK5282594.1	2026764	g145483	i0	68.8	1.99285714285714	93	29	99.6	0	280	2	264	356	MCK5282594.1 phosphopyruvate hydratase [Nanoarchaeota archaeon]	diamond	558	135	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
27714697	27714697	PRJNA690592_S_NODE_174104_length_259_cov_1.236559_g173090_i0	PRJNA690592	174104	259	1.236559	3.20268781	Nanobdellota archaeon	2026764	Archaea	Archaea	75.9	9.65e-14	NR	MCA9485224.1	2026764	g173090	i0	41.5	0.94980694980695	82	48	95	0	3	248	267	348	MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon]	diamond	246	75.9	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
27840367	27840367	PRJNA690592_S_NODE_175944_length_257_cov_2.173913_g174930_i0	PRJNA690592	175944	257	2.173913	5.58695641	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	41.6	0.0205	NR	HZX45182.1	2910166	g174930	i0	37.5	0.653696498054475	56	30	59.5	1	173	21	25	80	HZX45182.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	168	41.6	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
28314296	28314296	PRJNA690592_S_NODE_35206_length_513_cov_2.779545_g34199_i0	PRJNA690592	35206	513	2.779545	14.25906585	Nanobdellota archaeon	2026764	Archaea	Archaea	58.2	1.91e-6	NR	MEK6926779.1	2026764	g34199	i0	45.9	0.35672514619883	61	32	35.7	1	184	2	1	60	MEK6926779.1 FAD-dependent oxidoreductase [Nanoarchaeota archaeon]	diamond	183	58.2	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
28440650	28440650	PRJNA690592_S_NODE_217466_length_237_cov_2.079268_g216452_i0	PRJNA690592	217466	237	2.079268	4.92786516	Nanobdellota archaeon	2026764	Archaea	Archaea	47.8	3.62e-4	NR	MCA9460294.1	2026764	g216452	i0	29.6	1.0253164556962	81	54	98.7	1	1	234	20	100	MCA9460294.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	243	47.8	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31958794	31958794	PRJNA690592_S_NODE_197257_length_247_cov_1.281609_g196243_i0	PRJNA690592	197257	247	1.281609	3.16557423	root	1	Root_unresolved	Root_unresolved	121	1.82e-33	NR	MCA9460013.1	2026764	g196243	i0	73.2	1.96761133603239	82	22	99.6	0	2	247	28	109	MCA9460013.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	486	121	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
32042374	32042374	PRJNA690592_S_NODE_181858_length_253_cov_2.416667_g180844_i0	PRJNA690592	181858	253	2.416667	6.11416751	Nanobdellota archaeon	2026764	Archaea	Archaea	50.4	7.94e-5	NR	MDO8467912.1	2026764	g180844	i0	39	4.74308300395257	82	45	97.2	2	2	247	53	129	MDO8467912.1 DEAD/DEAH box helicase [Nanoarchaeota archaeon]	diamond	1200	50.4	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);;