metadata: contig_metadata: 11 rows where bioproject = "PRJNA795983", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA795983", 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
27148208	27148208	PRJNA795983_S_NODE_28902_length_271_cov_1.919192_g28777_i0	PRJNA795983	28902	271	1.919192	5.20101032	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	175	6.47e-53	NR	HRN71286.1	2026804	g28777	i0	97.8	0.985239852398524	89	2	98.5	0	269	3	24	112	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	267	175	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
27812154	27812154	PRJNA795983_S_NODE_14224_length_343_cov_2.503704_g14099_i0	PRJNA795983	14224	343	2.503704	8.58770472	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	110	1.77e-25	NR	MDB5160357.1	2026720	g14099	i0	50	7.89795918367347	110	53	96.2	2	4	333	145	252	MDB5160357.1 putative 1,4-alpha-glucan branching enzyme [Candidatus Saccharibacteria bacterium]	diamond	2709	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29579816	29579816	PRJNA795983_S_NODE_18150_length_317_cov_2.016393_g18025_i0	PRJNA795983	18150	317	2.016393	6.39196581	Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_	2026717	Bacteria	Bacteria	46.6	6.13e-4	NR	OGH64422.1	1798672	g18025	i0	48.4	0.586750788643533	62	31	57.7	1	190	8	35	96	OGH64422.1 MAG: hypothetical protein A2821_02795 [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23]	diamond	186	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Magasanikiibacteriota					Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23
29810112	29810112	PRJNA795983_S_NODE_20391_length_305_cov_2.573276_g20266_i0	PRJNA795983	20391	305	2.573276	7.8484918	Candidatus Babeliae	2497643	Bacteria	Bacteria	49.3	3.7e-4	NR	WP_023790961.1	673862	g20266	i0	41.3	0.944262295081967	46	27	45.2	0	157	20	41	86	WP_023790961.1 D-arabinono-1,4-lactone oxidase [Candidatus Babela massiliensis]	diamond	288	49.3	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
29990713	29990713	PRJNA795983_S_NODE_37311_length_249_cov_0.875000_g37186_i0	PRJNA795983	37311	249	0.875	2.17875	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	59.3	3.74e-8	NR	HRN71286.1	2026804	g37186	i0	34.1	1.06024096385542	88	49	95.2	1	248	12	129	216	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	264	59.3	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
30812067	30812067	PRJNA795983_S_NODE_38294_length_247_cov_1.609195_g38169_i0	PRJNA795983	38294	247	1.609195	3.97471165	Candidatus Shapirobacteria bacterium	2053613	Bacteria	Bacteria	65.5	1.98e-10	NR	MDD4027124.1	2053613	g38169	i0	45.3	3.09716599190283	64	35	77.7	0	192	1	107	170	MDD4027124.1 SIMPL domain-containing protein [Candidatus Shapirobacteria bacterium]	diamond	765	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Shapironibacteriota					Candidatus Shapirobacteria bacterium
31033571	31033571	PRJNA795983_S_NODE_23015_length_293_cov_2.231818_g22890_i0	PRJNA795983	23015	293	2.231818	6.53922674	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	196	8.43e-61	NR	HRN71286.1	2026804	g22890	i0	96.9	0.993174061433447	97	3	99.3	0	3	293	141	237	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	291	196	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
31254453	31254453	PRJNA795983_S_NODE_28955_length_271_cov_1.555556_g28830_i0	PRJNA795983	28955	271	1.555556	4.21555676	Candidatus Desantisiibacteriota bacterium	2282144	Bacteria	Bacteria	71.6	3.75e-12	NR	MFH1098086.1	2282144	g28830	i0	42.7	0.985239852398524	89	51	98.5	0	267	1	228	316	MFH1098086.1 PEGA domain-containing protein [Candidatus Desantisbacteria bacterium]	diamond	267	71.6	1	Bacteria	Bacteria candidate phyla	Candidatus Desantisiibacteriota					Candidatus Desantisiibacteriota bacterium
31823707	31823707	PRJNA795983_S_NODE_32857_length_259_cov_1.365591_g32732_i0	PRJNA795983	32857	259	1.365591	3.53688069	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	165	3.49e-51	NR	HRN71285.1	2026804	g32732	i0	96.4	0.972972972972973	84	3	97.3	0	7	258	1	84	HRN71285.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	252	165	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria bacterium
32393391	32393391	PRJNA795983_S_NODE_17359_length_322_cov_1.184739_g17234_i0	PRJNA795983	17359	322	1.184739	3.81485958	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	97.8	3.039999999999999e-23	NR	PCI31026.1	2030810	g17234	i0	46.1	0.950310559006211	102	54	95	1	15	320	4	104	PCI31026.1 MAG: hypothetical protein COB52_00540 [Candidatus Kaiserbacteria bacterium]	diamond	306	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
32425043	32425043	PRJNA795983_S_NODE_25199_length_284_cov_2.009479_g25074_i0	PRJNA795983	25199	284	2.009479	5.70692036	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	44.3	0.0172	NR	MFO0744005.1	2053589	g25074	i0	40	0.633802816901408	60	28	54.9	1	78	233	309	368	MFO0744005.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	180	44.3	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota 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);;