metadata: contig_metadata: 9 rows where bioproject = "PRJEB55250" and tax

9 rows where bioproject = "PRJEB55250" 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
26653432	26653432	PRJEB55250_P_NODE_3421_length_363_cov_1.734483_g3297_i0	PRJEB55250	3421	363	1.734483	6.29617329	Candidatus Kaiserbacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5	2030810	Bacteria	Bacteria	151	1.34e-39	NR	PIV86963.1	1974613	g3297	i0	58.7	1	121	50	100	0	1	363	326	446	PIV86963.1 MAG: hypothetical protein COW49_02305 [Candidatus Kaiserbacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_51_7]	diamond	363	151	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_51_7
26780501	26780501	PRJEB55250_P_NODE_13181_length_248_cov_0.880000_g13057_i0	PRJEB55250	13181	248	0.88	2.1824	Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b	1797282	Bacteria	Bacteria	43.5	0.021	NR	OGY35185.1	1797282	g13057	i0	38.7	0.75	62	31	75	3	244	59	253	307	OGY35185.1 MAG: hypothetical protein A3E36_00725 [Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b]	diamond	186	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota					Candidatus Andersenbacteria bacterium RIFCSPHIGHO2_12_FULL_45_11b
26843878	26843878	PRJEB55250_P_NODE_761_length_750_cov_2.587888_g652_i0	PRJEB55250	761	750	2.587888	19.40916	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	226	1.05e-70	NR	MCA9368469.1	2030810	g652	i0	72.7	0.572	143	39	57.2	0	320	748	8	150	MCA9368469.1 site-specific DNA-methyltransferase [Candidatus Kaiserbacteria bacterium]	diamond	429	226	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
27760460	27760460	PRJEB55250_P_NODE_10504_length_257_cov_2.510870_g10380_i0	PRJEB55250	10504	257	2.51087	6.4529359	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	71.2	3.93e-12	NR	MDE2103921.1	2052139	g10380	i0	51.5	0.793774319066148	68	32	79.4	1	204	1	98	164	MDE2103921.1 hypothetical protein [Patescibacteria group bacterium]	diamond	204	71.2	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29370526	29370526	PRJEB55250_P_NODE_4769_length_321_cov_1.862903_g4645_i0	PRJEB55250	4769	321	1.862903	5.97991863	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	87	1.29e-18	NR	NBP58683.1	2802965	g4645	i0	58	0.644859813084112	69	25	64.5	1	315	109	138	202	NBP58683.1 phosphoesterase [Candidatus Elulimicrobium humile]	diamond	207	87	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
31550767	31550767	PRJEB55250_P_NODE_17196_length_226_cov_3.928105_g17072_i0	PRJEB55250	17196	226	3.928105	8.8775173	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	97.1	2.09e-21	NR	MEI9966248.1	2045217	g17072	i0	68.6	2.73451327433628	70	22	92.9	0	223	14	344	413	MEI9966248.1 arabinofuranosidase catalytic domain-containing protein [Candidatus Moraniibacteriota bacterium]	diamond	618	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
31796623	31796623	PRJEB55250_P_NODE_16457_length_241_cov_0.916667_g16333_i0	PRJEB55250	16457	241	0.916667	2.20916747	root	1	Root_unresolved	Root_unresolved	67.8	5.39e-11	NR	TXG77608.1	2099670	g16333	i0	63.5	2.98755186721992	52	19	64.7	0	157	2	375	426	TXG77608.1 MAG: DEAD/DEAH box helicase [Candidatus Dojkabacteria bacterium]	diamond	720	67.8	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
32341651	32341651	PRJEB55250_P_NODE_10499_length_257_cov_2.951087_g10375_i0	PRJEB55250	10499	257	2.951087	7.58429359	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	112	3.3800000000000006e-27	NR	HJP81593.1	2973664	g10375	i0	65.9	0.992217898832685	85	29	99.2	0	257	3	272	356	HJP81593.1 glycosyltransferase family 4 protein [Candidatus Saccharimonadales bacterium]	diamond	255	112	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32745234	32745234	PRJEB55250_P_NODE_220_length_1378_cov_3.605364_g157_i0	PRJEB55250	220	1378	3.605364	49.68191592	Sphingomonadaceae	41297	Bacteria	Bacteria	249	3.32e-77	NR	MDE2103179.1	2052139	g157	i0	67.6	1.55878084179971	179	58	39	0	470	1006	8	186	MDE2103179.1 hypothetical protein [Patescibacteria group bacterium]	diamond	2148	249	1	Bacteria	Bacteria candidate phyla						Patescibacteria group 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);;