metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA565584" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA565584" 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
26762885	26762885	PRJNA565584_P_NODE_40661_length_470_cov_2.115869_g39510_i0	PRJNA565584	40661	470	2.115869	9.9445843	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	119	6.949999999999998e-32	NR	HRN71285.1	2026804	g39510	i0	62.4	0.542553191489362	85	32	54.3	0	90	344	1	85	HRN71285.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	255	119	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
26826355	26826355	PRJNA565584_P_NODE_14481_length_862_cov_2.017744_g13458_i0	PRJNA565584	14481	862	2.017744	17.39295328	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	88.2	3.41e-18	NR	MBP9690675.1	2026804	g13458	i0	54.5	0.522041763341067	77	35	26.8	0	534	764	2	78	MBP9690675.1 RNA-binding protein [Candidatus Woesebacteria bacterium]	diamond	450	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
27774504	27774504	PRJNA565584_P_NODE_169284_length_251_cov_0.865169_g168132_i0	PRJNA565584	169284	251	0.865169	2.17157419	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	77	2.76e-16	NR	MBP9781962.1	2026804	g168132	i0	60.7	0.729083665338645	61	24	72.9	0	247	65	29	89	MBP9781962.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	183	77	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
28640731	28640731	PRJNA565584_P_NODE_93307_length_310_cov_1.299578_g92155_i0	PRJNA565584	93307	310	1.299578	4.0286918	Bacteria	2	Bacteria	Bacteria	85.1	7.01e-18	NR	MBP9691092.1	2026804	g92155	i0	48.9	4.93548387096774	90	45	86.1	1	292	26	8	97	MBP9691092.1 aquaporin [Candidatus Woesebacteria bacterium]	diamond	1530	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
29114257	29114257	PRJNA565584_P_NODE_34968_length_512_cov_2.667426_g33817_i0	PRJNA565584	34968	512	2.667426	13.65722112	Bacteria	2	Bacteria	Bacteria	121	2.4e-30	NR	HPT66021.1	2026804	g33817	i0	41.2	2.689453125	153	90	89.6	0	463	5	45	197	HPT66021.1 SIMPL domain-containing protein [Candidatus Woesebacteria bacterium]	diamond	1377	121	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
29731753	29731753	PRJNA565584_P_NODE_5350_length_1486_cov_3.958953_g4765_i0	PRJNA565584	5350	1486	3.958953	58.83004158	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	473	9.059999999999999e-164	NR	HRN71286.1	2026804	g4765	i0	97.1	0.488559892328398	242	7	48.9	0	1165	440	1	242	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	726	473	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
30332562	30332562	PRJNA565584_P_NODE_12272_length_950_cov_2.423033_g11293_i0	PRJNA565584	12272	950	2.423033	23.0188135	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	97.8	9.02e-20	NR	HRN71286.1	2026804	g11293	i0	30.1	0.745263157894737	236	147	71.7	4	686	6	1	227	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	708	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
31501635	31501635	PRJNA565584_P_NODE_130236_length_275_cov_1.524752_g129084_i0	PRJNA565584	130236	275	1.524752	4.193068	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	130	1.95e-35	NR	MCD8506697.1	2026804	g129084	i0	65.9	3.97090909090909	91	31	99.3	0	3	275	125	215	MCD8506697.1 NTP transferase domain-containing protein [Candidatus Woesebacteria bacterium]	diamond	1092	130	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32166067	32166067	PRJNA565584_P_NODE_53778_length_405_cov_2.906627_g52627_i0	PRJNA565584	53778	405	2.906627	11.77183935	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	166	1.6999999999999998e-48	NR	HRN71286.1	2026804	g52627	i0	73.1	0.8	108	29	80	0	80	403	138	245	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	324	166	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32797311	32797311	PRJNA565584_P_NODE_26200_length_605_cov_1.669173_g25060_i0	PRJNA565584	26200	605	1.669173	10.09849665	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	149	1.17e-40	NR	HRN71286.1	2026804	g25060	i0	70.1	0.530578512396694	107	27	51.6	2	292	603	1	105	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	321	149	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria 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);;