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

5 rows where bioproject = "PRJNA662254", 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
26732883	26732883	PRJNA662254_P_NODE_65641_length_241_cov_0.916667_g64990_i0	PRJNA662254	65641	241	0.916667	2.20916747	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	64.3	5.02e-10	NR	HEY7494518.1	2528274	g64990	i0	72.7	0.547717842323652	44	12	54.8	0	109	240	1	44	HEY7494518.1 class II aldolase/adducin family protein [Candidatus Tectimicrobiota bacterium]	diamond	132	64.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
26808872	26808872	PRJNA662254_P_NODE_59341_length_244_cov_0.900585_g58690_i0	PRJNA662254	59341	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	54.3	8.03e-7	NR	MCH7615782.1	2026769	g58690	i0	59.1	3.03688524590164	44	18	54.1	0	243	112	74	117	MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium]	diamond	741	54.7	0.992687385740402	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29575858	29575858	PRJNA662254_P_NODE_49070_length_249_cov_0.875000_g48419_i0	PRJNA662254	49070	249	0.875	2.17875	Nitrospinota bacterium	2026769	Bacteria	Bacteria	130	1.07e-35	NR	MBI3330470.1	2026769	g48419	i0	72.8	0.975903614457831	81	22	97.6	0	6	248	134	214	MBI3330470.1 Uma2 family endonuclease [Nitrospinota bacterium]	diamond	243	130	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
31598606	31598606	PRJNA662254_P_NODE_33736_length_287_cov_1.289720_g33085_i0	PRJNA662254	33736	287	1.28972	3.7014964	Candidatus Nitrohelix vancouverensis	2705534	Bacteria	Bacteria	137	7.36e-36	NR	QPJ64473.1	2705534	g33085	i0	63.4	3.90940766550523	93	34	97.2	0	286	8	245	337	QPJ64473.1 MAG: radical SAM protein [Candidatus Nitrohelix vancouverensis]	diamond	1122	137	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Candidatus Nitrohelix	Candidatus Nitrohelix vancouverensis
31977964	31977964	PRJNA662254_P_NODE_47938_length_250_cov_0.870056_g47287_i0	PRJNA662254	47938	250	0.870056	2.17514	Nitrospinaceae bacterium	2358456	Bacteria	Bacteria	70.9	3.72e-12	NR	MEE9499610.1	2358456	g47287	i0	52.4	1.008	84	36	96	3	1	240	136	219	MEE9499610.1 hypothetical protein [Nitrospinaceae bacterium]	diamond	252	70.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae		Nitrospinaceae 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);;