metadata: contig_metadata: 4 rows where bioproject = "PRJNA971593", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax

4 rows where bioproject = "PRJNA971593", tax_clade = "Nitrospinota/Tectimicrobiota group" and tax_superkingdom = "Bacteria"

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
17522398	17522398	PRJNA971593_P_NODE_28314_length_242_cov_0.911243_g28165_i0	PRJNA971593	28314	242	0.911243	2.20520806	Nitrospinota/Tectimicrobiota group	1802340	Bacteria	Bacteria	86.3	1.23e-17	NR	WP_089937561.1	93172	g28165	i0	57.7	8.83884297520661	71	30	88	0	28	240	321	391	WP_089937561.1 acyl-CoA dehydrogenase family protein [Candidatus Entotheonella palauensis]	diamond	2139	87	0.991954022988506	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella palauensis
27342225	27342225	PRJNA971593_P_NODE_29083_length_241_cov_0.916667_g28934_i0	PRJNA971593	29083	241	0.916667	2.20916747	Nitrospinota bacterium	2026769	Bacteria	Bacteria	49.7	1.29e-4	NR	MBF0171721.1	2026769	g28934	i0	33.8	0.809128630705394	65	43	80.9	0	198	4	5	69	MBF0171721.1 hypothetical protein [Nitrospinota bacterium]	diamond	195	49.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29488946	29488946	PRJNA971593_P_NODE_28610_length_242_cov_0.911243_g28461_i0	PRJNA971593	28610	242	0.911243	2.20520806	Nitrospinota bacterium	2026769	Bacteria	Bacteria	89.7	9.73e-19	NR	MBF0171721.1	2026769	g28461	i0	49.4	1.00413223140496	81	39	97.9	1	237	1	78	158	MBF0171721.1 hypothetical protein [Nitrospinota bacterium]	diamond	243	89.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30247340	30247340	PRJNA971593_P_NODE_23672_length_249_cov_0.875000_g23523_i0	PRJNA971593	23672	249	0.875	2.17875	Nitrospinota bacterium	2026769	Bacteria	Bacteria	47.4	9.11e-4	NR	MBF0171721.1	2026769	g23523	i0	32	1.87951807228916	75	47	88	2	227	9	345	417	MBF0171721.1 hypothetical protein [Nitrospinota bacterium]	diamond	468	47.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium

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);;