metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Wildermuthiibacteriota"

12 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Wildermuthiibacteriota"

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_species
25261580	25261580	PRJNA1148190_P_NODE_452300_length_276_cov_1.231527_g441127_i0	PRJNA1148190	452300	276	1.231527	3.39901452	Bacteria	2	Bacteria	Bacteria	133	1.62e-37	NR	OHA70948.1	1802457	g441127	i0	71.4	1.84782608695652	84	24	91.3	0	258	7	14	97	OHA70948.1 MAG: hypothetical protein A3F15_02120 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_12_FULL_40_12]	diamond	510	134	0.992537313432836	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_12_FULL_40_12
27703518	27703518	PRJNA1148190_P_NODE_529584_length_261_cov_1.228723_g518411_i0	PRJNA1148190	529584	261	1.228723	3.20696703	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_	2053642	Bacteria	Bacteria	115	5.9899999999999995e-30	NR	OHA62859.1	1802444	g518411	i0	62.8	0.988505747126437	86	32	98.9	0	258	1	105	190	OHA62859.1 MAG: hypothetical protein A2748_00820 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_45_20]	diamond	258	115	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_45_20
27786305	27786305	PRJNA1148190_P_NODE_394544_length_287_cov_1.640187_g383371_i0	PRJNA1148190	394544	287	1.640187	4.70733669	Bacteria	2	Bacteria	Bacteria	99.4	8.289999999999999e-24	NR	OHA63411.1	1802444	g383371	i0	56.4	6.88850174216028	94	41	98.3	0	3	284	82	175	OHA63411.1 MAG: hypothetical protein A2748_02525 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_45_20]	diamond	1977	100	0.994	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_45_20
28302939	28302939	PRJNA1148190_P_NODE_45506_length_914_cov_2.184304_g34861_i0	PRJNA1148190	45506	914	2.184304	19.96453856	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_	2053642	Bacteria	Bacteria	209	1.44e-63	NR	OHA64335.1	1802447	g34861	i0	73	0.449671772428884	137	36	44.6	1	910	503	75	211	OHA64335.1 MAG: hypothetical protein A2843_02550 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27b]	diamond	411	209	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27b
30059377	30059377	PRJNA1148190_P_NODE_252811_length_342_cov_1.144981_g241641_i0	PRJNA1148190	252811	342	1.144981	3.91583502	Bacteria	2	Bacteria	Bacteria	115	1.15e-30	NR	OHA63736.1	1802447	g241641	i0	50.5	5.35964912280702	103	51	90.4	0	2	310	16	118	OHA63736.1 MAG: hypothetical protein A2843_02835 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27b]	diamond	1833	115	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_27b
30607685	30607685	PRJNA1148190_P_NODE_154453_length_423_cov_1.540000_g143286_i0	PRJNA1148190	154453	423	1.54	6.5142	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_	2053642	Bacteria	Bacteria	158	7.29e-43	NR	OHA69201.1	1802454	g143286	i0	56.4	0.99290780141844	140	61	99.3	0	4	423	372	511	OHA69201.1 MAG: hypothetical protein A3J57_00685 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_49_12b]	diamond	420	158	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_49_12b
31007491	31007491	PRJNA1148190_P_NODE_545514_length_258_cov_1.248649_g534341_i0	PRJNA1148190	545514	258	1.248649	3.22151442	Bacteria	2	Bacteria	Bacteria	71.2	3.79e-12	NR	OHA68889.1	1802453	g534341	i0	40.7	2	86	50	98.8	1	2	256	183	268	OHA68889.1 MAG: hypothetical protein A3J68_00820 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_48_16]	diamond	516	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_02_FULL_48_16
31260386	31260386	PRJNA1148190_P_NODE_721795_length_244_cov_0.900585_g710622_i0	PRJNA1148190	721795	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	70.1	7.93e-12	NR	MBI2003355.1	2053642	g710622	i0	49.2	1.5	61	31	75	0	185	3	8	68	MBI2003355.1 class I SAM-dependent methyltransferase [Candidatus Wildermuthbacteria bacterium]	diamond	366	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium
32252333	32252333	PRJNA1148190_P_NODE_14058_length_2481_cov_3.054817_g7663_i0	PRJNA1148190	14058	2481	3.054817	75.79000977	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_	2053642	Bacteria	Bacteria	583	1.5099999999999999e-199	NR	OHA64108.1	1802446	g7663	i0	72.7	1.4764207980653	407	111	49.2	0	2480	1260	9	415	OHA64108.1 MAG: hypothetical protein A2842_02325 [Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_25]	diamond	3663	583	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium RIFCSPHIGHO2_01_FULL_48_25
32347144	32347144	PRJNA1148190_P_NODE_105499_length_518_cov_2.946067_g94342_i0	PRJNA1148190	105499	518	2.946067	15.26062706	Candidatus Wildermuthbacteria bacterium	2053642	Bacteria	Bacteria	227	1.06e-69	NR	MBI2577321.1	2053642	g94342	i0	65.7	1.9980694980695	172	59	99.6	0	516	1	29	200	MBI2577321.1 sodium:proton antiporter NhaD [Candidatus Wildermuthbacteria bacterium]	diamond	1035	227	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium
32411394	32411394	PRJNA1148190_P_NODE_73899_length_643_cov_3.017544_g62795_i0	PRJNA1148190	73899	643	3.017544	19.40280792	Candidatus Wildermuthbacteria bacterium	2053642	Bacteria	Bacteria	209	5.73e-62	NR	MBI2577321.1	2053642	g62795	i0	67.1	4.26438569206843	155	51	72.3	0	1	465	269	423	MBI2577321.1 sodium:proton antiporter NhaD [Candidatus Wildermuthbacteria bacterium]	diamond	2742	209	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria bacterium
32694417	32694417	PRJNA1148190_P_NODE_227880_length_356_cov_1.745583_g216710_i0	PRJNA1148190	227880	356	1.745583	6.21427548	Candidatus Wildermuthbacteria bacterium	2053642	Bacteria	Bacteria	169	4.789999999999999e-48	NR	MBI2573808.1	2053642	g216710	i0	75	0.876404494382023	104	26	87.6	0	355	44	333	436	MBI2573808.1 serine--tRNA ligase [Candidatus Wildermuthbacteria bacterium]	diamond	312	169	1	Bacteria	Bacteria candidate phyla	Candidatus Wildermuthiibacteriota	Candidatus Wildermuthbacteria 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);;