metadata: contig_metadata: 11 rows where bioproject = "PRJNA661142", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA661142", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26701397	26701397	PRJNA661142_P_NODE_11621_length_166_cov_0.871795_g11556_i0	PRJNA661142	11621	166	0.871795	1.4471797	Nitrospirota bacterium	2026887	Bacteria	Bacteria	57	1.22e-7	NR	NJD55137.1	2026887	g11556	i0	51.9	0.975903614457831	54	26	97.6	0	5	166	1	54	NJD55137.1 hypothetical protein [Nitrospirota bacterium]	diamond	162	57	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
27618618	27618618	PRJNA661142_P_NODE_12204_length_163_cov_0.894737_g12139_i0	PRJNA661142	12204	163	0.894737	1.45842131	Nitrospirota bacterium	2026887	Bacteria	Bacteria	63.2	7.39e-10	NR	MBS1243022.1	2026887	g12139	i0	70.2	0.865030674846626	47	9	86.5	1	144	4	2	43	MBS1243022.1 hypothetical protein [Nitrospirota bacterium]	diamond	141	63.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28029074	28029074	PRJNA661142_P_NODE_11445_length_167_cov_0.864407_g11380_i0	PRJNA661142	11445	167	0.864407	1.44355969	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	107	1.11e-25	NR	MDA8387952.1	2026770	g11380	i0	100	0.988023952095808	55	0	98.8	0	3	167	111	165	MDA8387952.1 AsmA family protein [Nitrospiraceae bacterium]	diamond	165	107	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28849687	28849687	PRJNA661142_P_NODE_12668_length_161_cov_0.910714_g12603_i0	PRJNA661142	12668	161	0.910714	1.46624954	Candidatus Sulfobium mesophilum	2016548	Bacteria	Bacteria	103	2.12e-24	NR	SPQ01045.1	2016548	g12603	i0	84.9	0.987577639751553	53	8	98.8	0	160	2	136	188	SPQ01045.1 conserved exported hypothetical protein [Candidatus Sulfobium mesophilum]	diamond	159	103	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Candidatus Sulfobium	Candidatus Sulfobium mesophilum
29892036	29892036	PRJNA661142_P_NODE_12191_length_163_cov_0.894737_g12126_i0	PRJNA661142	12191	163	0.894737	1.45842131	Nitrospirota bacterium	2026887	Bacteria	Bacteria	80.1	3.77e-17	NR	HSA78355.1	2026887	g12126	i0	71.7	0.975460122699387	53	15	97.5	0	163	5	82	134	HSA78355.1 redoxin domain-containing protein [Nitrospirota bacterium]	diamond	159	80.1	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30586766	30586766	PRJNA661142_P_NODE_12673_length_161_cov_0.910714_g12608_i0	PRJNA661142	12673	161	0.910714	1.46624954	Thermodesulfovibrionales bacterium	2814272	Bacteria	Bacteria	94	8.810000000000001e-21	NR	HXX53849.1	2814272	g12608	i0	88.2	1.93788819875776	51	6	95	0	9	161	146	196	HXX53849.1 phosphomannomutase/phosphoglucomutase [Thermodesulfovibrionales bacterium]	diamond	312	94	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales			Thermodesulfovibrionales bacterium
30598972	30598972	PRJNA661142_P_NODE_12093_length_164_cov_0.886957_g12028_i0	PRJNA661142	12093	164	0.886957	1.45460948	Nitrospira	1234	Bacteria	Bacteria	84	1.18e-17	NR	MBM4147127.1	70125	g12028	i0	74.1	3.95121951219512	54	14	98.8	0	163	2	170	223	MBM4147127.1 hypothetical protein [Nitrospira sp.]	diamond	648	84.7	0.991735537190083	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31535329	31535329	PRJNA661142_P_NODE_12596_length_162_cov_0.858407_g12531_i0	PRJNA661142	12596	162	0.858407	1.39061934	Nitrospirota bacterium	2026887	Bacteria	Bacteria	70.5	5.68e-14	NR	HET6365281.1	2026887	g12531	i0	75.7	1.46296296296296	37	9	68.5	0	51	161	4	40	HET6365281.1 DUF3795 domain-containing protein [Nitrospirota bacterium]	diamond	237	70.5	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
31673731	31673731	PRJNA661142_P_NODE_11377_length_167_cov_0.864407_g11312_i0	PRJNA661142	11377	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	93.2	1.3400000000000002e-21	NR	OGW33727.1	1801696	g11312	i0	72.2	6.82634730538922	54	15	97	0	1	162	165	218	OGW33727.1 MAG: hypothetical protein A2X58_06505 [Nitrospirae bacterium GWC2_56_14]	diamond	1140	93.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirae bacterium GWC2_56_14
31693249	31693249	PRJNA661142_P_NODE_11997_length_164_cov_0.886957_g11932_i0	PRJNA661142	11997	164	0.886957	1.45460948	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	83.2	3.85e-18	NR	MDA8099069.1	2026770	g11932	i0	75.9	0.98780487804878	54	13	98.8	0	164	3	113	166	MDA8099069.1 TetR/AcrR family transcriptional regulator [Nitrospiraceae bacterium]	diamond	162	83.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
32874609	32874609	PRJNA661142_P_NODE_11000_length_183_cov_1.141791_g10935_i0	PRJNA661142	11000	183	1.141791	2.08947753	Pseudomonadati	3379134	Bacteria	Bacteria	73.9	1.71e-13	NR	HRB14792.1	70125	g10935	i0	72.7	1.80327868852459	55	15	90.2	0	183	19	1037	1091	HRB14792.1 DEAD/DEAH box helicase family protein [Nitrospira sp.]	diamond	330	74.3	0.994616419919246	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira 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);;