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

13 rows where bioproject = "PRJNA1120060" 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
4087647	4087647	PRJNA1120060_P_NODE_3225104_length_230_cov_3.312102_g3206997_i0	PRJNA1120060	3225104	230	3.312102	7.6178346	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621706016\|emb\|OY764078.1\|	3060593	g3206997	i0	100	0.130434782608696	30	0	13	0	197	226	617500	617529	MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
5359242	5359242	PRJNA1120060_P_NODE_2813485_length_246_cov_0.867052_g2795399_i0	PRJNA1120060	2813485	246	0.867052	2.13294792	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621786041\|emb\|OY782499.1\|	3060593	g2795399	i0	100	0.117886178861789	29	0	12	0	181	209	1138543	1138515	MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
7888753	7888753	PRJNA1120060_P_NODE_1291547_length_307_cov_3.277778_g1273600_i0	PRJNA1120060	1291547	307	3.277778	10.06277846	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2626245904\|emb\|OY829950.1\|	3060593	g1273600	i0	100	0.0912052117263844	28	0	9	0	58	85	839325	839352	MAG: Candidatus Cloacimonadales bacterium isolate 55f7dba2-411d-4d06-9fab-9545568f0b98 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
14285878	14285878	PRJNA1120060_P_NODE_2892452_length_244_cov_0.906433_g2874363_i0	PRJNA1120060	2892452	244	0.906433	2.21169652	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621703985\|emb\|OY762940.1\|	2030808	g2874363	i0	100	0.114754098360656	28	0	11	0	175	202	1196576	1196549	MAG: Candidatus Cloacimonadota bacterium isolate fde15138-546a-48ac-9104-3b47d2f39405 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
21926897	21926897	PRJNA1120060_P_NODE_2328318_length_260_cov_1.877005_g2310258_i0	PRJNA1120060	2328318	260	1.877005	4.880213	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	58.4	5.09e-4	NTclustered	gi\|2621786041\|emb\|OY782499.1\|	3060593	g2310258	i0	97.059	0.130769230769231	34	1	13	0	129	162	2242490	2242523	MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1	blastn	34	58.4	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
24457538	24457538	PRJNA1120060_P_NODE_1004280_length_312_cov_2.506276_g986351_i0	PRJNA1120060	1004280	312	2.506276	7.81958112	Candidatus Cloacimonadales bacterium	3060593	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621786041\|emb\|OY782499.1\|	3060593	g986351	i0	100	0.0961538461538462	30	0	10	0	59	88	740078	740107	MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales			Candidatus Cloacimonadales bacterium
27384547	27384547	PRJNA1120060_P_NODE_1443963_length_296_cov_2.578475_g1425979_i0	PRJNA1120060	1443963	296	2.578475	7.632286	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	44.3	0.0103	NR	MCK4357680.1	2030808	g1425979	i0	39.8	0.841216216216216	83	42	78	4	231	1	1	81	MCK4357680.1 cyclic nucleotide-binding domain-containing protein [Candidatus Cloacimonadota bacterium]	diamond	249	44.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
28142755	28142755	PRJNA1120060_P_NODE_1971165_length_274_cov_1.338308_g1953139_i0	PRJNA1120060	1971165	274	1.338308	3.66696392	Candidatus Cloacimonas sp.	2053534	Bacteria	Bacteria	48.9	3.47e-4	NR	HPB18743.1	2053534	g1953139	i0	32.2	0.985401459854015	90	55	92	4	2	253	95	184	HPB18743.1 apolipoprotein N-acyltransferase [Candidatus Cloacimonas sp.]	diamond	270	48.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas sp.
29911313	29911313	PRJNA1120060_P_NODE_2539911_length_252_cov_4.094972_g2521836_i0	PRJNA1120060	2539911	252	4.094972	10.31932944	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	41.2	0.0487	NR	MCK5050258.1	2030808	g2521836	i0	41.5	0.630952380952381	53	31	63.1	0	180	22	5	57	MCK5050258.1 hypothetical protein [Candidatus Cloacimonadota bacterium]	diamond	159	41.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
30416744	30416744	PRJNA1120060_P_NODE_2193033_length_265_cov_2.213542_g2174981_i0	PRJNA1120060	2193033	265	2.213542	5.8658863	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	47	0.00164	NR	PCJ20077.1	2030808	g2174981	i0	33.3	3.35094339622642	60	39	66.8	1	177	1	26	85	PCJ20077.1 MAG: DNA-directed RNA polymerase subunit beta' [Candidatus Cloacimonadota bacterium]	diamond	888	47	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
31395994	31395994	PRJNA1120060_P_NODE_1872356_length_278_cov_1.297561_g1854340_i0	PRJNA1120060	1872356	278	1.297561	3.60721958	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	43.9	0.0223	NR	MCK4338456.1	2030808	g1854340	i0	37.5	0.863309352517986	80	44	84.2	4	247	14	551	626	MCK4338456.1 type I DNA topoisomerase [Candidatus Cloacimonadota bacterium]	diamond	240	43.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
31744068	31744068	PRJNA1120060_P_NODE_2496557_length_254_cov_1.558011_g2478486_i0	PRJNA1120060	2496557	254	1.558011	3.95734794	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	44.3	0.0124	NR	MCK5050347.1	2030808	g2478486	i0	43.5	0.543307086614173	46	25	53.1	1	30	164	287	332	MCK5050347.1 NADH-quinone oxidoreductase subunit F [Candidatus Cloacimonadota bacterium]	diamond	138	44.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium
32473006	32473006	PRJNA1120060_P_NODE_787859_length_322_cov_1.437751_g769983_i0	PRJNA1120060	787859	322	1.437751	4.62955822	Candidatus Cloacimonetes bacterium 4572_65	1972455	Bacteria	Bacteria	43.9	0.0344	NR	OQY37773.1	1972455	g769983	i0	29.9	0.81055900621118	87	53	74.5	3	48	287	216	301	OQY37773.1 MAG: apolipoprotein N-acyltransferase [Candidatus Cloacimonetes bacterium 4572_65]	diamond	261	43.9	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonetes bacterium 4572_65

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