metadata: contig_metadata: 8 rows where bioproject = "PRJNA758087" and tax

8 rows where bioproject = "PRJNA758087" and tax_clade = "Bacteria candidate phyla"

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
10937128	10937128	PRJNA758087_P_NODE_14949_length_768_cov_47.302158_g13718_i0	PRJNA758087	14949	768	47.302158	363.28057344	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	96.3	1.61e-18	NR	MBI3231938.1	2052150	g13718	i0	34.6	0.74609375	191	104	73.8	6	632	66	413	584	MBI3231938.1 hypothetical protein [Candidatus Doudnabacteria bacterium]	diamond	573	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium
19860647	19860647	PRJNA758087_P_NODE_36136_length_320_cov_8.619433_g34816_i0	PRJNA758087	36136	320	8.619433	27.5821856	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	167	1.0700000000000001e-49	NR	MBY0538849.1	2052139	g34816	i0	83.7	0.91875	98	16	91.9	0	26	319	122	219	MBY0538849.1 sortase [Patescibacteria group bacterium]	diamond	294	167	1	Bacteria	Bacteria candidate phyla		Patescibacteria group bacterium
21135924	21135924	PRJNA758087_P_NODE_26057_length_481_cov_4.424020_g24737_i0	PRJNA758087	26057	481	4.42402	21.2795362	root	1	Root_unresolved	Root_unresolved	167	3.5699999999999995e-47	NR	MFA5623267.1	2099670	g24737	i0	53.6	2.86278586278586	153	70	94.8	1	459	4	95	247	MFA5623267.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	1377	168	0.994047619047619	Bacteria	Bacteria candidate phyla		Candidatus Dojkabacteria bacterium
22410937	22410937	PRJNA758087_P_NODE_33498_length_357_cov_2.661972_g32178_i0	PRJNA758087	33498	357	2.661972	9.50324004	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	178	2.49e-52	NR	MBW7954587.1	2044595	g32178	i0	76.4	2.77310924369748	110	26	92.4	0	3	332	4	113	MBW7954587.1 3-deoxy-7-phosphoheptulonate synthase [Candidatus Altimarinota bacterium]	diamond	990	178	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota	Candidatus Altimarinota bacterium
29895117	29895117	PRJNA758087_P_NODE_42731_length_246_cov_0.890173_g41411_i0	PRJNA758087	42731	246	0.890173	2.18982558	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	157	8.22e-44	NR	MBI3889855.1	2026720	g41411	i0	91.5	3.97560975609756	82	7	100	0	1	246	273	354	MBI3889855.1 ribosome biogenesis GTPase Der [Candidatus Saccharibacteria bacterium]	diamond	978	157	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
30916031	30916031	PRJNA758087_P_NODE_37634_length_301_cov_1.850877_g36314_i0	PRJNA758087	37634	301	1.850877	5.57113977	Bacteria	2	Bacteria	Bacteria	147	3.68e-40	NR	KKT98425.1	1618506	g36314	i0	81.1	10.8338870431894	90	17	89.7	0	270	1	106	195	KKT98425.1 MAG: Tyrosine-tRNA ligase [Microgenomates group bacterium GW2011_GWB1_45_17]	diamond	3261	147	1	Bacteria	Bacteria candidate phyla		Microgenomates group bacterium GW2011_GWB1_45_17
31886172	31886172	PRJNA758087_P_NODE_14657_length_780_cov_7.538897_g13438_i0	PRJNA758087	14657	780	7.538897	58.8033966	Candidatus Moranbacteria bacterium RIFCSPLOWO2_	1801642	Bacteria	Bacteria	97.8	1.05e-19	NR	OGI19596.1	1801642	g13438	i0	49.5	0.719230769230769	99	42	38.1	2	454	750	71	161	OGI19596.1 MAG: hypothetical protein A3J06_01065 [Candidatus Moranbacteria bacterium RIFCSPLOWO2_02_FULL_48_19]	diamond	561	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moranbacteria bacterium RIFCSPLOWO2_02_FULL_48_19
32139427	32139427	PRJNA758087_P_NODE_39078_length_284_cov_1.071090_g37758_i0	PRJNA758087	39078	284	1.07109	3.0418956	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	60.8	2.6e-8	NR	MBI3231938.1	2052150	g37758	i0	46	0.665492957746479	63	34	66.5	0	278	90	521	583	MBI3231938.1 hypothetical protein [Candidatus Doudnabacteria bacterium]	diamond	189	60.8	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria 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);;