metadata: contig_metadata: 7 rows where bioproject = "PRJNA902848", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA902848", tax_clade = "PVC group" and tax_phylum = "Chlamydiota"

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
9809819	9809819	PRJNA902848_P_NODE_14768_length_250_cov_1.355932_g14718_i0	PRJNA902848	14768	250	1.355932	3.38983	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	339	1.55e-88	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g14718	i0	91.837	112.268	245	16	97	3	5	247	653924	654166	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	28067	339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27466817	27466817	PRJNA902848_P_NODE_19223_length_243_cov_0.917647_g19173_i0	PRJNA902848	19223	243	0.917647	2.22988221	Chlamydiales bacterium	2047757	Bacteria	Bacteria	147	2.6799999999999993e-43	NR	MCP5470420.1	2047757	g19173	i0	86.4	1	81	11	100	0	1	243	10	90	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	243	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27940385	27940385	PRJNA902848_P_NODE_17645_length_246_cov_0.901734_g17595_i0	PRJNA902848	17645	246	0.901734	2.21826564	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	75.9	8.31e-14	NR	WP_154017830.1	1414722	g17595	i0	66.7	4.81707317073171	54	15	62.2	1	244	92	498	551	WP_154017830.1 PKD-like domain-containing protein [Candidatus Protochlamydia phocaeensis]	diamond	1185	75.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
29014108	29014108	PRJNA902848_P_NODE_18188_length_245_cov_0.906977_g18138_i0	PRJNA902848	18188	245	0.906977	2.22209365	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	107	3.7100000000000005e-27	NR	HAB99199.1	2052178	g18138	i0	75.8	0.808163265306122	66	16	80.8	0	6	203	63	128	HAB99199.1 hypothetical protein [Parachlamydiales bacterium]	diamond	198	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
30529696	30529696	PRJNA902848_P_NODE_17593_length_246_cov_0.901734_g17543_i0	PRJNA902848	17593	246	0.901734	2.21826564	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	122	5.979999999999999e-31	NR	WP_228840628.1	1414722	g17543	i0	64.2	0.98780487804878	81	29	98.8	0	3	245	247	327	WP_228840628.1 PP2C family protein-serine/threonine phosphatase [Candidatus Protochlamydia phocaeensis]	diamond	243	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
30656101	30656101	PRJNA902848_P_NODE_13393_length_253_cov_0.866667_g13343_i0	PRJNA902848	13393	253	0.866667	2.19266751	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	164	3.41e-45	NR	MBX7066987.1	2052178	g13343	i0	92.8	0.984189723320158	83	6	98.4	0	251	3	428	510	MBX7066987.1 YjbH domain-containing protein [Parachlamydiales bacterium]	diamond	249	164	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
32395501	32395501	PRJNA902848_P_NODE_5339_length_362_cov_1.577855_g5289_i0	PRJNA902848	5339	362	1.577855	5.7118351	Simkania sp.	34094	Bacteria	Bacteria	144	3.199999999999999e-41	NR	MCB1084323.1	34094	g5289	i0	65.7	0.895027624309392	108	36	89.5	1	38	361	33	139	MCB1084323.1 AMP-binding protein [Simkania sp.]	diamond	324	144	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.

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