metadata: contig_metadata: 6 rows where bioproject = "PRJNA572587" and tax

6 rows where bioproject = "PRJNA572587" and tax_phylum = "Nanobdellota"

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
26858380	26858380	PRJNA572587_P_NODE_41341_length_170_cov_2.223140_g41013_i0	PRJNA572587	41341	170	2.22314	3.779338	Candidatus Nanoarchaeia archaeon	2910166	Archaea	Archaea	80.9	4.77e-18	NR	HZX12758.1	2910166	g41013	i0	68.1	0.829411764705882	47	15	82.9	0	144	4	37	83	HZX12758.1 hypothetical protein [Candidatus Nanoarchaeia archaeon]	diamond	141	80.9	1	Archaea	Nanobdellati	Nanobdellota	Candidatus Nanoarchaeia	Candidatus Nanoarchaeia archaeon
27142358	27142358	PRJNA572587_P_NODE_17582_length_271_cov_42.423423_g17254_i0	PRJNA572587	17582	271	42.423423	114.96747633	Nanobdellota archaeon	2026764	Archaea	Archaea	115	4.8899999999999994e-30	NR	MEK6898648.1	2026764	g17254	i0	87	0.763837638376384	69	9	76.4	0	12	218	146	214	MEK6898648.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	207	115	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
27963883	27963883	PRJNA572587_P_NODE_3645_length_683_cov_9.686120_g3365_i0	PRJNA572587	3645	683	9.68612	66.1561996	Nanobdellota archaeon	2026764	Archaea	Archaea	48.9	0.00786	NR	MEK6829909.1	2026764	g3365	i0	29	0.408491947291362	93	64	40.8	2	324	602	156	246	MEK6829909.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	279	48.9	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
28879463	28879463	PRJNA572587_P_NODE_7988_length_429_cov_7.944737_g7663_i0	PRJNA572587	7988	429	7.944737	34.08292173	Nanobdellota archaeon	2026764	Archaea	Archaea	54.3	2.31e-5	NR	MBU0628104.1	2026764	g7663	i0	68.4	1.38461538461538	38	12	26.6	0	117	4	3	40	MBU0628104.1 glycosyltransferase family 4 protein [Nanoarchaeota archaeon]	diamond	594	54.3	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
31831325	31831325	PRJNA572587_P_NODE_44757_length_164_cov_2.191304_g44429_i0	PRJNA572587	44757	164	2.191304	3.59373856	Archaea	2157	Archaea	Archaea	93.2	1.21e-22	NR	MEK6964020.1	2026764	g44429	i0	88.5	1.90243902439024	52	6	95.1	0	158	3	26	77	MEK6964020.1 hypothetical protein [Nanoarchaeota archaeon]	diamond	312	93.2	1	Archaea	Nanobdellati	Nanobdellota		Nanobdellota archaeon
32039417	32039417	PRJNA572587_P_NODE_12598_length_328_cov_21.419355_g12270_i0	PRJNA572587	12598	328	21.419355	70.2554844	Nanobdellota archaeon	2026764	Archaea	Archaea	102	1.66e-25	NR	MEK6898895.1	2026764	g12270	i0	89.7	0.530487804878049	58	6	53	0	192	19	10	67	MEK6898895.1 DoxX family protein [Nanoarchaeota archaeon]	diamond	174	102	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);;