metadata: contig_metadata: 7 rows where bioproject = "PRJNA980839", tax_clade = "Bacteria candidate phyla" and tax

7 rows where bioproject = "PRJNA980839", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Methylomirabilota"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3507551	3507551	PRJNA980839_P_NODE_129623_length_310_cov_2.527426_g125839_i0	PRJNA980839	129623	310	2.527426	7.8350206	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	124	1.88e-30	NR	HTO81485.1	2072417	g125839	i0	62.1	0.996774193548387	103	39	99.7	0	309	1	240	342	HTO81485.1 winged helix-turn-helix domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	309	124	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
22635036	22635036	PRJNA980839_P_NODE_176958_length_265_cov_1.421875_g173174_i0	PRJNA980839	176958	265	1.421875	3.76796875	Candidatus Methylomirabilis oxygeniifera	671143	Bacteria	Bacteria	124	1.26e-31	NR	KAB2959692.1	671143	g173174	i0	75.3	1.85660377358491	81	20	91.7	0	243	1	1	81	KAB2959692.1 MAG: tyrosine--tRNA ligase [Candidatus Methylomirabilis oxygeniifera]	diamond	492	124	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis oxygeniifera
28794598	28794598	PRJNA980839_P_NODE_236547_length_241_cov_1.625000_g232763_i0	PRJNA980839	236547	241	1.625	3.91625	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	47.8	6.12e-4	NR	HXG20666.1	2072417	g232763	i0	44.6	1.35684647302905	74	33	82.2	2	241	44	112	185	HXG20666.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	327	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30089398	30089398	PRJNA980839_P_NODE_229452_length_243_cov_0.905882_g225668_i0	PRJNA980839	229452	243	0.905882	2.20129326	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	108	9.2e-26	NR	HEX2481392.1	2072417	g225668	i0	67.5	0.987654320987654	80	26	98.8	0	240	1	65	144	HEX2481392.1 FAD-dependent oxidoreductase [Candidatus Methylomirabilota bacterium]	diamond	240	108	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
30721243	30721243	PRJNA980839_P_NODE_203134_length_250_cov_0.870056_g199350_i0	PRJNA980839	203134	250	0.870056	2.17514	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	121	4.48e-32	NR	HXG21456.1	2072417	g199350	i0	74.4	0.984	82	21	98.4	0	2	247	63	144	HXG21456.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	246	121	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
31163407	31163407	PRJNA980839_P_NODE_169835_length_270_cov_2.304569_g166051_i0	PRJNA980839	169835	270	2.304569	6.2223363	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	82.4	1.03e-17	NR	HTZ32687.1	2072417	g166051	i0	97.5	0.444444444444444	40	1	44.4	0	270	151	99	138	HTZ32687.1 hypothetical protein [Candidatus Methylomirabilota bacterium]	diamond	120	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota bacterium
32302816	32302816	PRJNA980839_P_NODE_205879_length_249_cov_0.875000_g202095_i0	PRJNA980839	205879	249	0.875	2.17875	Candidatus Methylomirabilota bacterium	2072417	Bacteria	Bacteria	95.9	3e-22	NR	HXG21419.1	2072417	g202095	i0	93.5	1.10843373493976	46	3	55.4	0	248	111	179	224	HXG21419.1 response regulator transcription factor [Candidatus Methylomirabilota bacterium]	diamond	276	95.9	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					Candidatus Methylomirabilota 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);;