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

4 rows where bioproject = "PRJNA1204310", 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
10532412	10532412	PRJNA1204310_P_NODE_11069_length_528_cov_1.028571_g10774_i0	PRJNA1204310	11069	528	1.028571	5.43085488	Candidatus Tectomicrobia bacterium RIFCSPLOWO2_	1802342	Bacteria	Bacteria	237	5.790000000000001e-73	NR	OGL60582.1	1802342	g10774	i0	66.1	6.77272727272727	171	58	97.2	0	2	514	83	253	OGL60582.1 MAG: allophanate hydrolase [Candidatus Tectomicrobia bacterium RIFCSPLOWO2_02_FULL_70_19]	diamond	3576	237	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectomicrobia bacterium RIFCSPLOWO2_02_FULL_70_19
29472287	29472287	PRJNA1204310_P_NODE_45070_length_275_cov_1.405941_g44773_i0	PRJNA1204310	45070	275	1.405941	3.86633775	Nitrospinaceae bacterium	2358456	Bacteria	Bacteria	45.8	0.0044	NR	UCD11422.1	2358456	g44773	i0	31.4	0.763636363636364	70	48	76.4	0	214	5	293	362	UCD11422.1 MAG: pilus assembly protein PilP [Nitrospinaceae bacterium]	diamond	210	45.8	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae		Nitrospinaceae bacterium
30672786	30672786	PRJNA1204310_P_NODE_46873_length_268_cov_1.589744_g46576_i0	PRJNA1204310	46873	268	1.589744	4.26051392	Candidatus Tectimicrobiota bacterium	2528274	Bacteria	Bacteria	98.2	5e-24	NR	MBI3126658.1	2528274	g46576	i0	59.7	1.75746268656716	77	30	86.2	1	38	268	52	127	MBI3126658.1 hypothetical protein [Candidatus Tectimicrobiota bacterium]	diamond	471	98.2	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota					Candidatus Tectimicrobiota bacterium
32790536	32790536	PRJNA1204310_P_NODE_35900_length_311_cov_1.676471_g35603_i0	PRJNA1204310	35900	311	1.676471	5.21382481	Candidatus Entotheonella palauensis	93172	Bacteria	Bacteria	103	6.4999999999999985e-24	NR	WP_089938965.1	93172	g35603	i0	45.6	0.993569131832797	103	56	99.4	0	1	309	109	211	WP_089938965.1 tryptophan 2,3-dioxygenase family protein [Candidatus Entotheonella palauensis]	diamond	309	103	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Candidatus Tectimicrobiota	Candidatus Entotheonellia	Candidatus Entotheonellales	Candidatus Entotheonellaceae	Candidatus Entotheonella	Candidatus Entotheonella palauensis

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