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

7 rows where bioproject = "PRJNA888821", 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
9790877	9790877	PRJNA888821_P_NODE_36988_length_246_cov_1.335260_g36905_i0	PRJNA888821	36988	246	1.33526	3.2847396	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g36905	i0	98.374	107.577235772358	246	4	100	0	1	246	1250571	1250326	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	26464	433	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
10170416	10170416	PRJNA888821_P_NODE_32168_length_260_cov_14.417112_g32085_i0	PRJNA888821	32168	260	14.417112	37.4844912	Bacteria	2	Bacteria	Bacteria	165	2.92e-36	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g32085	i0	88.971	297.407692307692	136	11	52	4	127	260	1827353	1827486	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	77326	165	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17441437	17441437	PRJNA888821_P_NODE_774_length_595_cov_2.260536_g702_i0	PRJNA888821	774	595	2.260536	13.4501892	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1083	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g702	i0	99.497	105.356302521008	596	2	100	1	1	595	2474674	2475269	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	62687	1083	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
22919679	22919679	PRJNA888821_P_NODE_518_length_691_cov_13.357605_g454_i0	PRJNA888821	518	691	13.357605	92.30105055	Waddlia	71666	Bacteria	Bacteria	481	7.42e-131	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g454	i0	89.529	111.408104196816	382	36	91	3	1	380	1461	1082	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	76983	481	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
27727174	27727174	PRJNA888821_P_NODE_22644_length_307_cov_9.893162_g22562_i0	PRJNA888821	22644	307	9.893162	30.37200734	Parachlamydiales	1963360	Bacteria	Bacteria	54.3	3.97e-6	NR	WP_068471341.1	1414722	g22562	i0	53.3	1.76872964169381	45	21	44	0	3	137	167	211	WP_068471341.1 class I SAM-dependent methyltransferase [Candidatus Protochlamydia phocaeensis]	diamond	543	54.7	0.992687385740402	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
29834348	29834348	PRJNA888821_P_NODE_2571_length_411_cov_1.000000_g2492_i0	PRJNA888821	2571	411	1	4.11	Chlamydia psittaci	83554	Bacteria	Bacteria	50.8	9.19e-6	NR	EPL00669.1	1112260	g2492	i0	55	0.291970802919708	40	18	29.2	0	190	309	2	41	EPL00669.1 hypothetical protein CP02DC24_1093 [Chlamydia psittaci 02DC24]	diamond	120	50.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31762179	31762179	PRJNA888821_P_NODE_22957_length_307_cov_3.324786_g22875_i0	PRJNA888821	22957	307	3.324786	10.20709302	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	87.8	6.65e-18	NR	WP_195155545.1	1414722	g22875	i0	81.6	0.478827361563518	49	9	47.9	0	307	161	135	183	WP_195155545.1 THUMP domain-containing class I SAM-dependent RNA methyltransferase [Candidatus Protochlamydia phocaeensis]	diamond	147	87.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis

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