metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_clade = "Nitrospinota/Tectimicrobiota group"

5 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_clade = "Nitrospinota/Tectimicrobiota group"

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
27022731	27022731	PRJNA814235_P_NODE_125142_length_201_cov_1.426829_g123747_i0	PRJNA814235	125142	201	1.426829	2.86792629	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	84	2.02e-17	NR	HEY7491056.1	2528274	g123747	i0	67.7	6.82089552238806	65	21	97	0	5	199	84	148	HEY7491056.1 ABC transporter permease [Candidatus Tectimicrobiota bacterium]	diamond	1371	84	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
29399876	29399876	PRJNA814235_P_NODE_118429_length_203_cov_1.825301_g117034_i0	PRJNA814235	118429	203	1.825301	3.70536103	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.00642	NR	MDH5761345.1	2026769	g117034	i0	62.5	3.19211822660099	24	9	35.5	0	201	130	1061	1084	MDH5761345.1 acyl-[ACP]--phospholipid O-acyltransferase [Nitrospinota bacterium]	diamond	648	44.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30189421	30189421	PRJNA814235_P_NODE_14312_length_503_cov_4.517167_g13036_i0	PRJNA814235	14312	503	4.517167	22.72135001	Pseudomonadati	3379134	Bacteria	Bacteria	178	2.38e-52	NR	PON19048.1	1652106	g13036	i0	54.5	3.98409542743539	167	73	99.6	1	501	1	20	183	PON19048.1 carboxyvinyl-carboxyphosphonate phosphorylmutase [Candidatus Entotheonella serta]	diamond	2004	178	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella serta
30275858	30275858	PRJNA814235_P_NODE_201052_length_150_cov_2.752212_g199657_i0	PRJNA814235	201052	150	2.752212	4.128318	Candidatus Entotheonella sp.	2066855	Bacteria	Bacteria	63.9	1.08e-10	NR	HEY7712717.1	2066855	g199657	i0	68.8	0.96	48	14	96	1	146	3	106	152	HEY7712717.1 MarC family protein [Candidatus Entotheonella sp.]	diamond	144	63.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella sp.
32267513	32267513	PRJNA814235_P_NODE_105678_length_203_cov_2.204819_g104283_i0	PRJNA814235	105678	203	2.204819	4.47578257	Nitrospinota bacterium	2026769	Bacteria	Bacteria	46.6	9.45e-4	NR	MBI3329296.1	2026769	g104283	i0	88	1.10837438423645	25	3	36.9	0	129	203	339	363	MBI3329296.1 L-2-hydroxyglutarate oxidase [Nitrospinota bacterium]	diamond	225	46.6	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);;