metadata: contig_metadata: 14 rows where bioproject = "PRJNA773778" and tax

14 rows where bioproject = "PRJNA773778" 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
9679334	9679334	PRJNA773778_S_NODE_17708_length_344_cov_2.542435_g17558_i0	PRJNA773778	17708	344	2.542435	8.7459764	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	244	5e-60	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g17558	i0	80.805	42.2151162790698	323	53	92	9	1	318	2527928	2527610	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	14522	244	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
22428706	22428706	PRJNA773778_S_NODE_41578_length_249_cov_4.198864_g41428_i0	PRJNA773778	41578	249	4.198864	10.45517136	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	300	7.29e-77	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g41428	i0	93.532	66.6224899598394	201	13	81	0	1	201	964828	964628	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	16589	300	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
26704951	26704951	PRJNA773778_S_NODE_34421_length_268_cov_1.184615_g34271_i0	PRJNA773778	34421	268	1.184615	3.1747682	Candidatus Rifleibacterium sp.	3022866	Bacteria	Bacteria	129	3.83e-35	NR	HNX77617.1	3022866	g34271	i0	74.2	0.996268656716418	89	23	99.6	0	267	1	11	99	HNX77617.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Rifleibacterium sp.]	diamond	267	129	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacterium	Candidatus Rifleibacterium sp.
27274654	27274654	PRJNA773778_S_NODE_23743_length_309_cov_1.152542_g23593_i0	PRJNA773778	23743	309	1.152542	3.56135478	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	126	4.41e-32	NR	MBW7954729.1	2044595	g23593	i0	73.8	0.776699029126214	80	21	77.7	0	241	2	342	421	MBW7954729.1 S41 family peptidase [Candidatus Altimarinota bacterium]	diamond	240	126	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
27369753	27369753	PRJNA773778_S_NODE_7303_length_483_cov_6.009756_g7153_i0	PRJNA773778	7303	483	6.009756	29.02712148	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	168	4.88e-48	NR	MBS7346392.1	2830836	g7153	i0	68	3.03105590062112	122	39	75.8	0	2	367	162	283	MBS7346392.1 glycosyltransferase family 2 protein [Candidatus Saccharimonadaceae bacterium]	diamond	1464	168	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
28127312	28127312	PRJNA773778_S_NODE_39065_length_254_cov_1.276243_g38915_i0	PRJNA773778	39065	254	1.276243	3.24165722	Candidatus Rifleibacterium amylolyticum	2760816	Bacteria	Bacteria	91.7	1.68e-22	NR	KAF1080359.1	2760816	g38915	i0	100	0.55511811023622	47	0	55.5	0	112	252	1	47	KAF1080359.1 MAG: hypothetical protein GQF41_3183 [Candidatus Rifleibacterium amylolyticum]	diamond	141	91.7	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacterium	Candidatus Rifleibacterium amylolyticum
28221763	28221763	PRJNA773778_S_NODE_39126_length_254_cov_1.248619_g38976_i0	PRJNA773778	39126	254	1.248619	3.17149226	Candidatus Rifleibacterium amylolyticum	2760816	Bacteria	Bacteria	66.6	1.34e-12	NR	KAF1079635.1	2760816	g38976	i0	91.4	0.413385826771654	35	3	41.3	0	2	106	15	49	KAF1079635.1 MAG: hypothetical protein GQF41_4193 [Candidatus Rifleibacterium amylolyticum]	diamond	105	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacterium	Candidatus Rifleibacterium amylolyticum
29516298	29516298	PRJNA773778_S_NODE_28030_length_290_cov_3.608295_g27880_i0	PRJNA773778	28030	290	3.608295	10.4640555	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.1	7.34e-4	NR	MDO8266012.1	2026720	g27880	i0	39.1	1.82068965517241	64	39	66.2	0	85	276	177	240	MDO8266012.1 PepSY domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	528	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30021933	30021933	PRJNA773778_S_NODE_38211_length_256_cov_2.032787_g38061_i0	PRJNA773778	38211	256	2.032787	5.20393472	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	60.5	2.11e-8	NR	MDB5176421.1	2026720	g38061	i0	84.4	0.375	32	5	37.5	0	1	96	286	317	MDB5176421.1 mechanosensitive ion channel MscS, small conductance mechanosensitive channel [Candidatus Saccharibacteria bacterium]	diamond	96	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30306593	30306593	PRJNA773778_S_NODE_29072_length_286_cov_2.089202_g28922_i0	PRJNA773778	29072	286	2.089202	5.97511772	Candidatus Rifleibacterium amylolyticum	2760816	Bacteria	Bacteria	140	1.38e-41	NR	KAF1080357.1	2760816	g28922	i0	98.5	0.713286713286713	68	1	71.3	0	29	232	1	68	KAF1080357.1 MAG: hypothetical protein GQF41_3181 [Candidatus Rifleibacterium amylolyticum]	diamond	204	140	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacterium	Candidatus Rifleibacterium amylolyticum
30369781	30369781	PRJNA773778_S_NODE_44932_length_245_cov_1.081395_g44782_i0	PRJNA773778	44932	245	1.081395	2.64941775	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	111	1.3999999999999996e-29	NR	HRY22430.1	2099670	g44782	i0	67.6	0.906122448979592	74	24	90.6	0	245	24	47	120	HRY22430.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	222	111	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
30527210	30527210	PRJNA773778_S_NODE_38213_length_256_cov_2.005464_g38063_i0	PRJNA773778	38213	256	2.005464	5.13398784	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	41.6	0.0126	NR	NLE31306.1	2099670	g38063	i0	39.3	0.71484375	61	30	69.1	3	234	58	4	59	NLE31306.1 hypothetical protein [Candidatus Dojkabacteria bacterium]	diamond	183	41.6	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
31095904	31095904	PRJNA773778_S_NODE_49035_length_236_cov_5.668712_g48885_i0	PRJNA773778	49035	236	5.668712	13.37816032	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	82.8	8.58e-17	NR	HUD10702.1	2973664	g48885	i0	62.1	1.51271186440678	58	22	73.7	0	5	178	238	295	HUD10702.1 sugar phosphate nucleotidyltransferase [Candidatus Saccharimonadales bacterium]	diamond	357	82.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31602134	31602134	PRJNA773778_S_NODE_9756_length_434_cov_10.739612_g9606_i0	PRJNA773778	9756	434	10.739612	46.60991608	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	120	3.2399999999999996e-32	NR	MBB1523567.1	2026720	g9606	i0	65.3	0.69815668202765	101	33	69.8	1	388	86	23	121	MBB1523567.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	303	120	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;