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

5 rows where bioproject = "PRJNA924320", 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
27150669	27150669	PRJNA924320_S_NODE_28622_length_202_cov_2.555556_g28480_i0	PRJNA924320	28622	202	2.555556	5.16222312	Nitrospinota bacterium	2026769	Bacteria	Bacteria	49.3	6.82e-5	NR	MFQ5915144.1	2026769	g28480	i0	61	1.23267326732673	41	16	60.9	0	127	5	73	113	MFQ5915144.1 ribonuclease HI family protein [Nitrospinota bacterium]	diamond	249	49.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
28698693	28698693	PRJNA924320_S_NODE_32627_length_192_cov_2.496503_g32485_i0	PRJNA924320	32627	192	2.496503	4.79328576	Candidatus Entotheonella factor	1429438	Bacteria	Bacteria	68.6	1.44e-11	NR	ETW99796.1	1429438	g32485	i0	54.5	1.71875	55	25	85.9	0	184	20	135	189	ETW99796.1 MAG: peptidase M20 [Candidatus Entotheonella factor]	diamond	330	68.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella factor
30537487	30537487	PRJNA924320_S_NODE_29113_length_201_cov_1.342105_g28971_i0	PRJNA924320	29113	201	1.342105	2.69763105	Bacteria	2	Bacteria	Bacteria	45.1	0.00288	NR	MFQ5894118.1	2026769	g28971	i0	50	1.25373134328358	42	19	62.7	1	197	72	182	221	MFQ5894118.1 alpha/beta hydrolase [Nitrospinota bacterium]	diamond	252	45.4	0.993392070484582	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
31699850	31699850	PRJNA924320_S_NODE_54377_length_162_cov_3.159292_g54235_i0	PRJNA924320	54377	162	3.159292	5.11805304	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	61.2	1.75e-9	NR	HEY5863932.1	2528274	g54235	i0	57.4	1.72222222222222	47	19	87	1	4	144	41	86	HEY5863932.1 molecular chaperone Tir [Candidatus Tectimicrobiota bacterium]	diamond	279	61.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31826164	31826164	PRJNA924320_S_NODE_47137_length_167_cov_0.864407_g46995_i0	PRJNA924320	47137	167	0.864407	1.44355969	Candidatus Entotheonella sp.	2066855	Bacteria	Bacteria	46.2	7.91e-4	NR	HEY7712818.1	2066855	g46995	i0	47.2	2.94610778443114	36	19	64.7	0	114	7	390	425	HEY7712818.1 IS701 family transposase [Candidatus Entotheonella sp.]	diamond	492	46.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella sp.

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