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

5 rows where bioproject = "PRJNA379145", 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
13827537	13827537	PRJNA379145_P_NODE_6911_length_1158_cov_2.510222_g6088_i0	PRJNA379145	6911	1158	2.510222	29.06837076	Nitrospinae bacterium RIFCSPHIGHO2_	1801680	Bacteria	Bacteria	146	2.76e-34	NR	OGV99462.1	1801680	g6088	i0	52.7	1.01554404145078	131	61	33.9	1	538	146	694	823	OGV99462.1 MAG: DNA mismatch repair protein MutS [Nitrospinae bacterium RIFCSPHIGHO2_02_39_11]	diamond	1176	146	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPHIGHO2_02_39_11
26853688	26853688	PRJNA379145_P_NODE_50061_length_233_cov_1.880000_g47907_i0	PRJNA379145	50061	233	1.88	4.3804	Nitrospinota bacterium	2026769	Bacteria	Bacteria	68.6	2.5e-11	NR	MCH8311371.1	2026769	g47907	i0	48.7	4.03004291845494	78	39	99.1	1	3	233	114	191	MCH8311371.1 5-oxoprolinase [Nitrospinota bacterium]	diamond	939	68.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
28828775	28828775	PRJNA379145_P_NODE_51308_length_226_cov_2.098446_g49154_i0	PRJNA379145	51308	226	2.098446	4.74248796	Pseudomonadati	3379134	Bacteria	Bacteria	80.9	1.12e-15	NR	MBT5470119.1	2024844	g49154	i0	52.7	3.95575221238938	74	35	98.2	0	4	225	31	104	MBT5470119.1 PAS domain S-box protein [Nitrospina sp.]	diamond	894	80.9	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
29033105	29033105	PRJNA379145_P_NODE_47848_length_246_cov_1.826291_g45695_i0	PRJNA379145	47848	246	1.826291	4.49267586	Nitrospinae bacterium RIFCSPLOWO2_12_FULL_45_22	1801687	Bacteria	Bacteria	59.3	1.34e-8	NR	OGW16534.1	1801687	g45695	i0	40.8	14.7926829268293	76	44	92.7	1	245	18	67	141	OGW16534.1 MAG: O-acetyl-ADP-ribose deacetylase [Nitrospinae bacterium RIFCSPLOWO2_12_FULL_45_22]	diamond	3639	59.3	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPLOWO2_12_FULL_45_22
32478057	32478057	PRJNA379145_P_NODE_9659_length_972_cov_6.580405_g8536_i0	PRJNA379145	9659	972	6.580405	63.9615366	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	186	1.29e-53	NR	MBI1725092.1	2528274	g8536	i0	42.9	2.26851851851852	245	131	75.6	3	870	136	18	253	MBI1725092.1 enoyl-CoA hydratase/isomerase family protein [Candidatus Tectimicrobiota bacterium]	diamond	2205	186	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota 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);;