metadata: contig_metadata: 13 rows where bioproject = "PRJNA885753" and tax

13 rows where bioproject = "PRJNA885753" and tax_phylum = "Candidatus Cloacimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2137197	2137197	PRJNA885753_S_NODE_4222_length_246_cov_0.901734_g4204_i0	PRJNA885753	4222	246	0.901734	2.21826564	Candidatus Syntrophosphaera	2593013	Bacteria	Bacteria	151	9.7e-41	NR	NLH93356.1	2030808	g4204	i0	100	4.39024390243902	72	0	87.8	0	29	244	1	72	NLH93356.1 methionine--tRNA ligase [Candidatus Cloacimonadota bacterium]	diamond	1080	151	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
18713099	18713099	PRJNA885753_S_NODE_2035_length_315_cov_0.966942_g2017_i0	PRJNA885753	2035	315	0.966942	3.0458673	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	138	2.84e-35	NR	MDD5536910.1	2030808	g2017	i0	59.2	0.933333333333333	98	40	93.3	0	22	315	262	359	MDD5536910.1 DUF2341 domain-containing protein [Candidatus Cloacimonadota bacterium]	diamond	294	138	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
25087821	25087821	PRJNA885753_S_NODE_4320_length_245_cov_0.906977_g4302_i0	PRJNA885753	4320	245	0.906977	2.22209365	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|2694686128\|dbj\|AP029619.1\|	2030808	g4302	i0	88.115	0.995918367346939	244	29	99	0	1	244	1595979	1596222	MAG: Candidatus Cloacimonadota bacterium ANCL-1 DNA, complete genome	blastn	244	291	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
27687676	27687676	PRJNA885753_S_NODE_4484_length_243_cov_0.917647_g4466_i0	PRJNA885753	4484	243	0.917647	2.22988221	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	154	5.3499999999999997e-42	NR	MDD5537151.1	2030808	g4466	i0	97.5	0.987654320987654	80	2	98.8	0	241	2	217	296	MDD5537151.1 phage tail tape measure protein [Candidatus Cloacimonadota bacterium]	diamond	240	154	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
27876692	27876692	PRJNA885753_S_NODE_2505_length_292_cov_1.301370_g2487_i0	PRJNA885753	2505	292	1.30137	3.8000004	Candidatus Syntrophosphaera sp.	2819277	Bacteria	Bacteria	53.9	5.79e-6	NR	HNU54726.1	2819277	g2487	i0	100	0.256849315068493	25	0	25.7	0	292	218	56	80	HNU54726.1 CRISPR-associated protein Cas5 [Candidatus Syntrophosphaera sp.]	diamond	75	53.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Syntrophosphaera	Candidatus Syntrophosphaera sp.
28571294	28571294	PRJNA885753_S_NODE_2787_length_279_cov_1.514563_g2769_i0	PRJNA885753	2787	279	1.514563	4.22563077	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	169	2.1799999999999998e-47	NR	MDD5537151.1	2030808	g2769	i0	97.8	2	93	2	100	0	1	279	71	163	MDD5537151.1 phage tail tape measure protein [Candidatus Cloacimonadota bacterium]	diamond	558	169	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
28760691	28760691	PRJNA885753_S_NODE_2007_length_317_cov_0.959016_g1989_i0	PRJNA885753	2007	317	0.959016	3.04008072	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	229	2.1999999999999998e-67	NR	MDD5536636.1	2030808	g1989	i0	99	0.993690851735016	105	1	99.4	0	1	315	874	978	MDD5536636.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	315	229	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
29810508	29810508	PRJNA885753_S_NODE_4351_length_244_cov_1.368421_g4333_i0	PRJNA885753	4351	244	1.368421	3.33894724	Candidatus Cloacimonas	456826	Bacteria	Bacteria	171	1.45e-49	NR	NLN35071.1	2030808	g4333	i0	100	2.98770491803279	81	0	99.6	0	244	2	221	301	NLN35071.1 IS256 family transposase [Candidatus Cloacimonadota bacterium]	diamond	729	171	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
29834324	29834324	PRJNA885753_S_NODE_1631_length_344_cov_0.985240_g1613_i0	PRJNA885753	1631	344	0.98524	3.3892256	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	215	7.789999999999999e-67	NR	MCB5256898.1	2030808	g1613	i0	93.9	1.98837209302326	114	7	99.4	0	1	342	9	122	MCB5256898.1 IS256 family transposase [Candidatus Cloacimonadota bacterium]	diamond	684	215	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
29960653	29960653	PRJNA885753_S_NODE_1111_length_404_cov_1.051360_g1093_i0	PRJNA885753	1111	404	1.05136	4.2474944	Candidatus Syntrophosphaera sp.	2819277	Bacteria	Bacteria	276	8.64e-91	NR	HRQ67628.1	2819277	g1093	i0	100	0.995049504950495	134	0	99.5	0	402	1	31	164	HRQ67628.1 IS5 family transposase [Candidatus Syntrophosphaera sp.]	diamond	402	276	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Syntrophosphaera	Candidatus Syntrophosphaera sp.
31422170	31422170	PRJNA885753_S_NODE_4036_length_248_cov_0.891429_g4018_i0	PRJNA885753	4036	248	0.891429	2.21074392	Candidatus Syntrophosphaera	2593013	Bacteria	Bacteria	107	8.87e-26	NR	OQB90372.1	1852837	g4018	i0	100	1.33064516129032	55	0	66.5	0	246	82	308	362	OQB90372.1 MAG: Lipopolysaccharide export system permease protein LptG [Candidatus Cloacimonetes bacterium ADurb.Bin117]	diamond	330	107	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonetes bacterium ADurb.Bin117
31604121	31604121	PRJNA885753_S_NODE_2976_length_272_cov_1.175879_g2958_i0	PRJNA885753	2976	272	1.175879	3.19839088	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	121	2.37e-33	NR	MDD5536634.1	2030808	g2958	i0	72.6	0.926470588235294	84	22	91.5	1	250	2	36	119	MDD5536634.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	252	121	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
31675087	31675087	PRJNA885753_S_NODE_1477_length_358_cov_1.378947_g1459_i0	PRJNA885753	1477	358	1.378947	4.93663026	Candidatus Cloacimonas	456826	Bacteria	Bacteria	248	1.11e-78	NR	NLN35071.1	2030808	g1459	i0	100	3.9888268156424602	119	0	99.7	0	357	1	293	411	NLN35071.1 IS256 family transposase [Candidatus Cloacimonadota bacterium]	diamond	1428	248	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota 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);;