metadata: contig_metadata: 13 rows where bioproject = "PRJNA1000943", tax_clade = "Bacteria candidate phyla" and tax

13 rows where bioproject = "PRJNA1000943", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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
145135	145135	PRJNA1000943_P_NODE_13341_length_247_cov_0.896552_g13203_i0	PRJNA1000943	13341	247	0.896552	2.21448344	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g13203	i0	98.387	7.75303643724696	248	3	100	1	1	247	680382	680629	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	1915	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
9072614	9072614	PRJNA1000943_P_NODE_3468_length_417_cov_2.026163_g3331_i0	PRJNA1000943	3468	417	2.026163	8.44909971	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	198	1.8e-60	NR	MEK7673148.1	2052139	g3331	i0	73.9	38.9712230215827	134	35	96.4	0	3	404	60	193	MEK7673148.1 pyridoxal 5'-phosphate synthase lyase subunit PdxS [Patescibacteria group bacterium]	diamond	16251	198	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
16722021	16722021	PRJNA1000943_P_NODE_3394_length_421_cov_2.747126_g3257_i0	PRJNA1000943	3394	421	2.747126	11.56540046	Bacteria	2	Bacteria	Bacteria	106	4.37e-24	NR	OGL31136.1	1802138	g3257	i0	52.6	49.5605700712589	97	33	69.1	1	81	371	304	387	OGL31136.1 MAG: translation elongation factor Tu [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_12_FULL_41_12]	diamond	20865	107	0.990654205607477	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_12_FULL_41_12
23097247	23097247	PRJNA1000943_P_NODE_11179_length_253_cov_0.866667_g11041_i0	PRJNA1000943	11179	253	0.866667	2.19266751	Bacteria	2	Bacteria	Bacteria	89.7	2.06e-20	NR	HRY91651.1	2044595	g11041	i0	70.2	7.17391304347826	57	17	67.6	0	171	1	3	59	HRY91651.1 magnesium chelatase domain-containing protein [Candidatus Altimarinota bacterium]	diamond	1815	89.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
26995066	26995066	PRJNA1000943_P_NODE_3702_length_405_cov_3.102410_g3565_i0	PRJNA1000943	3702	405	3.10241	12.5647605	Bacteria	2	Bacteria	Bacteria	60.8	1.04e-7	NR	MBU4421411.1	2052139	g3565	i0	32	3.8962962962963	122	71	88.1	5	41	397	349	461	MBU4421411.1 hypothetical protein [Patescibacteria group bacterium]	diamond	1578	60.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27097511	27097511	PRJNA1000943_P_NODE_10602_length_257_cov_2.119565_g10464_i0	PRJNA1000943	10602	257	2.119565	5.44728205	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	45.1	9.75e-4	NR	MBI4235190.1	2030811	g10464	i0	51.2	0.478599221789883	41	20	47.9	0	255	133	43	83	MBI4235190.1 glutaredoxin [Candidatus Peregrinibacteria bacterium]	diamond	123	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
28929200	28929200	PRJNA1000943_P_NODE_1348_length_649_cov_1.512153_g1217_i0	PRJNA1000943	1348	649	1.512153	9.81387297	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	47.8	0.0242	NR	HET9946446.1	2052139	g1217	i0	28.4	0.845916795069337	183	111	80.9	6	634	110	2607	2777	HET9946446.1 DUF2341 domain-containing protein [Patescibacteria group bacterium]	diamond	549	47.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29339749	29339749	PRJNA1000943_P_NODE_15569_length_242_cov_0.923077_g15431_i0	PRJNA1000943	15569	242	0.923077	2.23384634	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	143	2.2599999999999996e-41	NR	HXI51812.1	2973664	g15431	i0	90	1.98347107438017	80	8	99.2	0	2	241	2	81	HXI51812.1 50S ribosomal protein L6 [Candidatus Saccharimonadales bacterium]	diamond	480	143	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30192267	30192267	PRJNA1000943_P_NODE_12632_length_249_cov_0.886364_g12494_i0	PRJNA1000943	12632	249	0.886364	2.20704636	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	86.3	3.39e-19	NR	MDR3571063.1	2053589	g12494	i0	78.2	0.662650602409639	55	12	66.3	0	2	166	73	127	MDR3571063.1 prohibitin family protein [Candidatus Paceibacterota bacterium]	diamond	165	86.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
30950830	30950830	PRJNA1000943_P_NODE_4214_length_383_cov_1.409677_g4077_i0	PRJNA1000943	4214	383	1.409677	5.39906291	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	57	1.87e-6	NR	MET0500055.1	2838779	g4077	i0	36.1	2.38120104438642	83	52	64.2	1	98	343	418	500	MET0500055.1 FAD-dependent oxidoreductase [Candidatus Binatia bacterium]	diamond	912	57	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
31424764	31424764	PRJNA1000943_P_NODE_1556_length_611_cov_2.483271_g1421_i0	PRJNA1000943	1556	611	2.483271	15.17278581	Candidatus Saccharicenans sp.	2819258	Bacteria	Bacteria	191	2.5399999999999994e-54	NR	HOJ26828.1	2819258	g1421	i0	54.5	4.92471358428805	167	71	82	2	502	2	130	291	HOJ26828.1 hydroxylamine reductase [Candidatus Saccharicenans sp.]	diamond	3009	191	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantia	Candidatus Aminicenantales	Candidatus Saccharicenantaceae	Candidatus Saccharicenans	Candidatus Saccharicenans sp.
32279169	32279169	PRJNA1000943_P_NODE_4519_length_372_cov_1.227425_g4382_i0	PRJNA1000943	4519	372	1.227425	4.566021	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	119	8.169999999999998e-31	NR	MBI5167934.1	2212470	g4382	i0	57.9	1.95161290322581	121	47	96.8	2	3	362	82	199	MBI5167934.1 DUF4397 domain-containing protein [Candidatus Eiseniibacteriota bacterium]	diamond	726	119	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
32721194	32721194	PRJNA1000943_P_NODE_13220_length_247_cov_1.390805_g13082_i0	PRJNA1000943	13220	247	1.390805	3.43528835	Candidatus Falkowbacteria bacterium HGW-Falkowbacteria-2	2013769	Bacteria	Bacteria	43.1	0.0295	NR	PKM87958.1	2013769	g13082	i0	30.1	1.12955465587045	93	43	94.7	3	4	237	939	1024	PKM87958.1 MAG: hypothetical protein CVU83_02370 [Candidatus Falkowbacteria bacterium HGW-Falkowbacteria-2]	diamond	279	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Falkowiibacteriota					Candidatus Falkowbacteria bacterium HGW-Falkowbacteria-2

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