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

8 rows where bioproject = "PRJEB75227" 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_class	tax_order	tax_family	tax_genus	tax_species
9062906	9062906	PRJEB75227_P_NODE_11668_length_242_cov_0.923077_g11497_i0	PRJEB75227	11668	242	0.923077	2.23384634	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g11497	i0	97.942	7.99586776859504	243	3	100	2	1	242	596826	596585	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	1935	420	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
26781112	26781112	PRJEB75227_P_NODE_8181_length_253_cov_0.866667_g8010_i0	PRJEB75227	8181	253	0.866667	2.19266751	Candidatus Muiribacteriota bacterium	3061976	Bacteria	Bacteria	43.5	0.0227	NR	MFA5479044.1	3061976	g8010	i0	38.7	2.1699604743083	62	25	58.1	2	246	100	444	505	MFA5479044.1 hypothetical protein [Candidatus Muiribacteriota bacterium]	diamond	549	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Muiribacteriota					Candidatus Muiribacteriota bacterium
27539826	27539826	PRJEB75227_P_NODE_8104_length_253_cov_2.427778_g7933_i0	PRJEB75227	8104	253	2.427778	6.14227834	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	61.6	9.59e-9	NR	MFA5207253.1	2053589	g7933	i0	49.4	0.91304347826087	77	29	91.3	2	2	232	71	137	MFA5207253.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	231	61.6	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
28171193	28171193	PRJEB75227_P_NODE_5466_length_298_cov_1.386667_g5295_i0	PRJEB75227	5466	298	1.386667	4.13226766	Candidatus Dependentiae bacterium	2030827	Bacteria	Bacteria	86.7	4.27e-18	NR	RTL06913.1	2030827	g5295	i0	42.9	0.916107382550336	91	52	91.6	0	297	25	47	137	RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium]	diamond	273	86.7	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
28518631	28518631	PRJEB75227_P_NODE_7867_length_257_cov_1.690217_g7696_i0	PRJEB75227	7867	257	1.690217	4.34385769	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	130	1.33e-33	NR	MCS7317269.1	2099670	g7696	i0	78	0.957198443579767	82	18	95.7	0	9	254	4	85	MCS7317269.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	246	130	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
29181764	29181764	PRJEB75227_P_NODE_6549_length_279_cov_1.233010_g6378_i0	PRJEB75227	6549	279	1.23301	3.4400979	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	55.1	2.39e-6	NR	MFS8159754.1	2282149	g6378	i0	26.6	1.37634408602151	64	47	68.8	0	194	3	64	127	MFS8159754.1 glycosyltransferase family 32 protein [Candidatus Roizmanbacteria bacterium]	diamond	384	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota					Candidatus Roizmanbacteria bacterium
31045583	31045583	PRJEB75227_P_NODE_11455_length_243_cov_0.917647_g11284_i0	PRJEB75227	11455	243	0.917647	2.22988221	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	56.2	1.16e-7	NR	NCU44048.1	2026720	g11284	i0	43.8	0.592592592592593	48	27	59.3	0	7	150	92	139	NCU44048.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	144	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31772501	31772501	PRJEB75227_P_NODE_9737_length_248_cov_0.891429_g9566_i0	PRJEB75227	9737	248	0.891429	2.21074392	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	107	1.43e-26	NR	NBP58133.1	2802965	g9566	i0	56.8	1.8991935483871	81	34	98	1	248	6	109	188	NBP58133.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	471	107	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile

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