metadata: contig_metadata: 13 rows where bioproject = "PRJNA558770" and tax

13 rows where bioproject = "PRJNA558770" and tax_phylum = "Candidatus Woeseibacteriota"

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
24766880	24766880	PRJNA558770_P_NODE_292380_length_234_cov_1.512563_g290375_i0	PRJNA558770	292380	234	1.512563	3.53939742	Bacteria	2	Bacteria	Bacteria	79	5.74e-15	NR	OGM56354.1	1802511	g290375	i0	59.7	4.93589743589744	77	11	98.7	1	3	233	69	125	OGM56354.1 MAG: excinuclease ABC subunit B [Candidatus Woesebacteria bacterium RIFCSPHIGHO2_12_FULL_42_9]	diamond	1155	79	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium RIFCSPHIGHO2_12_FULL_42_9
26952168	26952168	PRJNA558770_P_NODE_211522_length_234_cov_3.361809_g209517_i0	PRJNA558770	211522	234	3.361809	7.86663306	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	56.6	1.19e-7	NR	QQG41842.1	2026804	g209517	i0	47.9	0.91025641025641	71	9	91	1	223	11	1	43	QQG41842.1 MAG: hypothetical protein HYV90_00820 [Candidatus Woesebacteria bacterium]	diamond	213	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
27711180	27711180	PRJNA558770_P_NODE_284924_length_234_cov_1.658291_g282919_i0	PRJNA558770	284924	234	1.658291	3.88040094	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	51.2	3.54e-5	NR	MBP7119120.1	2026804	g282919	i0	39.5	0.974358974358974	76	25	97.4	1	234	7	1035	1089	MBP7119120.1 DNA polymerase III subunit alpha [Candidatus Woesebacteria bacterium]	diamond	228	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
28626535	28626535	PRJNA558770_P_NODE_154487_length_234_cov_6.110553_g152482_i0	PRJNA558770	154487	234	6.110553	14.29869402	Candidatus Woesebacteria bacterium GW2	2026804	Bacteria	Bacteria	47	8.45e-4	NR	KKS97634.1	1618578	g152482	i0	79.2	0.307692307692308	24	5	30.8	0	229	158	192	215	KKS97634.1 MAG: hypothetical protein UV74_C0011G0003 [Candidatus Woesebacteria bacterium GW2011_GWB1_43_14]	diamond	72	47	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_43_14
29604799	29604799	PRJNA558770_P_NODE_181490_length_234_cov_4.572864_g179485_i0	PRJNA558770	181490	234	4.572864	10.70050176	Candidatus Woesebacteria bacterium GW2	2026804	Bacteria	Bacteria	46.6	0.0014	NR	KKQ98778.1	1618549	g179485	i0	91.3	1.20512820512821	23	2	29.5	0	2	70	72	94	KKQ98778.1 MAG: hypothetical protein UT23_C0001G0059 [Candidatus Woesebacteria bacterium GW2011_GWA1_39_12]	diamond	282	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWA1_39_12
29840209	29840209	PRJNA558770_P_NODE_204531_length_234_cov_3.613065_g202526_i0	PRJNA558770	204531	234	3.613065	8.4545721	Bacteria	2	Bacteria	Bacteria	54.3	2.8e-6	NR	OGM79736.1	1802537	g202526	i0	88	3.20512820512821	25	3	32.1	0	160	234	347	371	OGM79736.1 MAG: magnesium chelatase, partial [Candidatus Woesebacteria bacterium RIFOXYB1_FULL_33_9]	diamond	750	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium RIFOXYB1_FULL_33_9
30124340	30124340	PRJNA558770_P_NODE_280792_length_234_cov_1.723618_g278787_i0	PRJNA558770	280792	234	1.723618	4.03326612	Bacteria	2	Bacteria	Bacteria	47.4	7.57e-4	NR	KKR85989.1	1618577	g278787	i0	80	1.6025641025641	25	5	32.1	0	76	2	422	446	KKR85989.1 MAG: hypothetical protein UU32_C0025G0012 [Candidatus Woesebacteria bacterium GW2011_GWB1_41_10]	diamond	375	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_41_10
30629918	30629918	PRJNA558770_P_NODE_221713_length_234_cov_3.040201_g219708_i0	PRJNA558770	221713	234	3.040201	7.11407034	Bacteria	2	Bacteria	Bacteria	82.8	2.58e-16	NR	KKU10430.1	1618581	g219708	i0	59.7	7.8974358974359	77	18	98.7	1	4	234	136	199	KKU10430.1 MAG: hypothetical protein UX13_C0012G0014 [Candidatus Woesebacteria bacterium GW2011_GWB1_45_5]	diamond	1848	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_45_5
30710778	30710778	PRJNA558770_P_NODE_247614_length_234_cov_2.361809_g245609_i0	PRJNA558770	247614	234	2.361809	5.52663306	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	45.1	0.00482	NR	MBP7119549.1	2026804	g245609	i0	95	0.256410256410256	20	1	25.6	0	74	15	246	265	MBP7119549.1 bifunctional phosphoglucose/phosphomannose isomerase [Candidatus Woesebacteria bacterium]	diamond	60	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
31690686	31690686	PRJNA558770_P_NODE_147717_length_234_cov_6.582915_g145712_i0	PRJNA558770	147717	234	6.582915	15.4040211	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	53.1	7.05e-6	NR	MCX6705848.1	2026804	g145712	i0	88	0.641025641025641	25	3	32.1	0	234	160	299	323	MCX6705848.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Candidatus Woesebacteria bacterium]	diamond	150	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32337840	32337840	PRJNA558770_P_NODE_170619_length_234_cov_5.130653_g168614_i0	PRJNA558770	170619	234	5.130653	12.00572802	Bacteria	2	Bacteria	Bacteria	45.1	0.00366	NR	MCX6705054.1	2026804	g168614	i0	87.5	0.628205128205128	24	3	30.8	0	74	3	97	120	MCX6705054.1 30S ribosomal protein S2 [Candidatus Woesebacteria bacterium]	diamond	147	45.4	0.993392070484582	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32702439	32702439	PRJNA558770_P_NODE_127820_length_234_cov_8.336683_g125815_i0	PRJNA558770	127820	234	8.336683	19.50783822	Candidatus Woesebacteria bacterium GW2	2026804	Bacteria	Bacteria	43.5	0.0173	NR	KKQ75335.1	1618569	g125815	i0	79.2	0.307692307692308	24	5	30.8	0	74	3	71	94	KKQ75335.1 MAG: ATP synthase subunit alpha [Candidatus Woesebacteria bacterium GW2011_GWB1_38_5b]	diamond	72	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_38_5b
32748063	32748063	PRJNA558770_P_NODE_322520_length_233_cov_8.171717_g320515_i0	PRJNA558770	322520	233	8.171717	19.04010061	Bacteria	2	Bacteria	Bacteria	43.1	0.0228	NR	KKQ75615.1	1618569	g320515	i0	79.2	2.13733905579399	24	5	30.9	0	230	159	106	129	KKQ75615.1 MAG: Phospho-N-acetylmuramoyl-pentapeptide-transferase, partial [Candidatus Woesebacteria bacterium GW2011_GWB1_38_5b]	diamond	498	43.5	0.990804597701149	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_38_5b

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