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

4 rows where bioproject = "PRJNA1059246", 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
28519835	28519835	PRJNA1059246_P_NODE_18687_length_531_cov_1.082969_g18070_i0	PRJNA1059246	18687	531	1.082969	5.75056539	Nitrospinota bacterium	2026769	Bacteria	Bacteria	78.2	3.51e-13	NR	MDH4184556.1	2026769	g18070	i0	38.9	1.50847457627119	113	68	63.3	1	338	3	44	156	MDH4184556.1 tetratricopeptide repeat protein [Nitrospinota bacterium]	diamond	801	78.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
30066946	30066946	PRJNA1059246_P_NODE_52632_length_281_cov_1.480769_g52006_i0	PRJNA1059246	52632	281	1.480769	4.16096089	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	47	1.31e-4	NR	MFQ6673111.1	2528274	g52006	i0	49	0.523131672597865	49	23	50.2	1	2	142	13	61	MFQ6673111.1 glutathione synthetase [Candidatus Tectimicrobiota bacterium]	diamond	147	47	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
31140844	31140844	PRJNA1059246_P_NODE_43855_length_317_cov_1.750000_g43229_i0	PRJNA1059246	43855	317	1.75	5.5475	Nitrospinae bacterium RIFCSPLOWO2_	1801683	Bacteria	Bacteria	51.6	5.75e-5	NR	OGW00599.1	1801683	g43229	i0	29.1	1.61829652996845	86	54	76.7	3	14	256	160	243	OGW00599.1 MAG: hypothetical protein A2889_04190 [Nitrospinae bacterium RIFCSPLOWO2_01_FULL_39_10]	diamond	513	51.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium RIFCSPLOWO2_01_FULL_39_10
32470086	32470086	PRJNA1059246_P_NODE_60079_length_256_cov_1.316940_g59453_i0	PRJNA1059246	60079	256	1.31694	3.3713664	Candidatus Entotheonella factor	1429438	Bacteria	Bacteria	102	6.16e-25	NR	ETW94273.1	1429438	g59453	i0	58.9	1.0546875	90	31	98.4	1	255	4	91	180	ETW94273.1 MAG: hypothetical protein ETSY1_35570 [Candidatus Entotheonella factor]	diamond	270	102	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella factor

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