metadata: contig_metadata: 13 rows where analysis = "diamond", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Chisholmiibacteriota"

13 rows where analysis = "diamond", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Chisholmiibacteriota"

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
6397049	6397049	PRJEB11748_P_NODE_372186_length_185_cov_23.983871_g370003_i0	PRJEB11748	372186	185	23.983871	44.37016135	Bacteria	2	Bacteria	Bacteria	95.5	4.4900000000000005e-21	NR	OGY17856.1	1797591	g370003	i0	73.7	2.77297297297297	57	15	92.4	0	173	3	288	344	OGY17856.1 MAG: DEAD/DEAH box helicase [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_52_32]	diamond	513	96.3	0.991692627206646	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_52_32
27331949	27331949	PRJNA558770_P_NODE_213983_length_234_cov_3.281407_g211978_i0	PRJNA558770	213983	234	3.281407	7.67849238	Candidatus Chisholmbacteria bacterium	2750073	Bacteria	Bacteria	52.8	9.89e-6	NR	MBI4034956.1	2750073	g211978	i0	84	0.320512820512821	25	4	32.1	0	234	160	520	544	MBI4034956.1 VanW family protein [Candidatus Chisholmbacteria bacterium]	diamond	75	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium
27352346	27352346	PRJNA1095825_P_NODE_244623_length_250_cov_0.870056_g241560_i0	PRJNA1095825	244623	250	0.870056	2.17514	Candidatus Chisholmbacteria bacterium	2750073	Bacteria	Bacteria	96.3	5.22e-21	NR	MBI2009978.1	2750073	g241560	i0	57.1	0.924	77	32	91.2	1	232	5	6	82	MBI2009978.1 radical SAM protein [Candidatus Chisholmbacteria bacterium]	diamond	231	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium
27963770	27963770	PRJNA565584_P_NODE_188085_length_247_cov_0.885057_g186933_i0	PRJNA565584	188085	247	0.885057	2.18609079	Candidatus Chisholmbacteria bacterium	2750073	Bacteria	Bacteria	43.9	0.014	NR	MBI2009889.1	2750073	g186933	i0	34.5	0.704453441295547	58	38	70.4	0	57	230	138	195	MBI2009889.1 glycosyltransferase family 2 protein [Candidatus Chisholmbacteria bacterium]	diamond	174	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium
28003879	28003879	PRJNA911178_P_NODE_305985_length_224_cov_4.211921_g303511_i0	PRJNA911178	305985	224	4.211921	9.43470304	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_	2750073	Bacteria	Bacteria	51.6	4.97e-6	NR	OGY22406.1	1797593	g303511	i0	38	1.05803571428571	79	39	93.8	2	14	223	2	79	OGY22406.1 MAG: hypothetical protein A3A65_04600 [Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14]	diamond	237	51.6	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14
30470457	30470457	PRJNA1148190_P_NODE_343653_length_303_cov_1.004348_g332480_i0	PRJNA1148190	343653	303	1.004348	3.04317444	Bacteria	2	Bacteria	Bacteria	191	2.9199999999999997e-54	NR	OGY20801.1	1797593	g332480	i0	87	31.5643564356436	100	13	99	0	302	3	109	208	OGY20801.1 MAG: hypothetical protein A3A65_01345 [Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14]	diamond	9564	192	0.994791666666667	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14
30923539	30923539	PRJNA1123436_P_NODE_121714_length_243_cov_0.905882_g120500_i0	PRJNA1123436	121714	243	0.905882	2.20129326	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	89	1.03e-18	NR	OGY15931.1	1797589	g120500	i0	57.7	0.962962962962963	78	32	96.3	1	5	238	187	263	OGY15931.1 MAG: hypothetical protein A2784_00960 [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12]	diamond	234	89	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12
31043807	31043807	PRJDB14274_S_NODE_9295_length_209_cov_0.878378_g9217_i0	PRJDB14274	9295	209	0.878378	1.83581002	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	40.4	0.0379	NR	OGY17377.1	1797590	g9217	i0	47.2	0.516746411483254	36	19	51.7	0	171	64	28	63	OGY17377.1 MAG: hypothetical protein A2785_03960 [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_49_18]	diamond	108	40.4	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_49_18
31247922	31247922	PRJNA558770_P_NODE_117875_length_234_cov_9.482412_g115870_i0	PRJNA558770	117875	234	9.482412	22.18884408	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	50.8	4.75e-5	NR	OGY17091.1	1797589	g115870	i0	95.2	0.269230769230769	21	1	26.9	0	222	160	648	668	OGY17091.1 MAG: ribonucleoside-diphosphate reductase, adenosylcobalamin-dependent [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12]	diamond	63	50.8	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12
31566539	31566539	PRJNA633835_S_NODE_7516_length_273_cov_1.105000_g7448_i0	PRJNA633835	7516	273	1.105	3.01665	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	42.7	0.0322	NR	OGY18492.1	1797591	g7448	i0	34.8	0.725274725274725	66	41	70.3	1	220	29	15	80	OGY18492.1 MAG: hypothetical protein A2786_03270 [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_52_32]	diamond	198	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_52_32
32786010	32786010	PRJNA1113956_P_NODE_22120_length_243_cov_0.905882_g21780_i0	PRJNA1113956	22120	243	0.905882	2.20129326	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_	2750073	Bacteria	Bacteria	45.1	0.00575	NR	OGY21556.1	1797593	g21780	i0	46.8	0.580246913580247	47	25	58	0	162	22	434	480	OGY21556.1 MAG: hypothetical protein A3A65_05550 [Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14]	diamond	141	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPLOWO2_01_FULL_49_14
32902076	32902076	PRJNA992237_P_NODE_8240_length_249_cov_1.556818_g8195_i0	PRJNA992237	8240	249	1.556818	3.87647682	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	72.4	1e-12	NR	OGY16299.1	1797589	g8195	i0	42.9	0.927710843373494	77	40	92.8	1	18	248	59	131	OGY16299.1 MAG: hypothetical protein A2784_02195 [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12]	diamond	231	72.4	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12
33142997	33142997	PRJNA737474g_S_NODE_91903_length_335_cov_2.324427_g90609_i0	PRJNA737474	91903	335	2.324427	7.78683045	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_	2750073	Bacteria	Bacteria	46.2	0.00195	NR	OGY15880.1	1797589	g90609	i0	50.7	1.7910447761194	69	31	61.8	1	255	49	3	68	OGY15880.1 MAG: 50S ribosomal protein L16 [Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12]	diamond	600	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Chisholmiibacteriota	Candidatus Chisholmbacteria bacterium RIFCSPHIGHO2_01_FULL_48_12

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