metadata: contig_metadata: 6 rows where bioproject = "PRJNA788929", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA788929", 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
4597824	4597824	PRJNA788929_P_NODE_43724_length_235_cov_20.777778_g43063_i0	PRJNA788929	43724	235	20.777778	48.8277783	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	268	1.92e-67	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g43063	i0	89.72	115.493617021277	214	17	90	5	24	235	2364439	2364229	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	27141	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
8422866	8422866	PRJNA788929_P_NODE_7387_length_690_cov_150.565640_g6750_i0	PRJNA788929	7387	690	150.56564	1038.902916	Chlamydiales bacterium	2047757	Bacteria	Bacteria	199	1.73e-61	NR	MCP5470421.1	2047757	g6750	i0	66.5	0.68695652173913	158	48	67.4	2	56	520	1	156	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	474	199	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
10973611	10973611	PRJNA788929_P_NODE_44749_length_230_cov_8.528662_g44088_i0	PRJNA788929	44749	230	8.528662	19.6159226	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	381	2.309999999999999e-101	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g44088	i0	99.061	107	213	1	92	1	1	212	1250962	1250750	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	24610	381	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
16072121	16072121	PRJNA788929_P_NODE_47713_length_212_cov_19.208633_g47052_i0	PRJNA788929	47713	212	19.208633	40.72230196	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	311	2.79e-80	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g47052	i0	96.316	59.5283018867925	190	6	89	1	1	189	1249297	1249108	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	12620	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
27053791	27053791	PRJNA788929_P_NODE_7442_length_687_cov_45.074919_g6803_i0	PRJNA788929	7442	687	45.074919	309.66469353	Chlamydiales bacterium	2047757	Bacteria	Bacteria	201	6.06e-62	NR	MCP5470421.1	2047757	g6803	i0	66	0.694323144104803	159	49	68.1	2	70	537	1	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	477	201	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29021204	29021204	PRJNA788929_P_NODE_39928_length_246_cov_15.317919_g39267_i0	PRJNA788929	39928	246	15.317919	37.68208074	Candidatus Protochlamydia	282132	Bacteria	Bacteria	134	9.06e-36	NR	WP_213106441.1	362787	g39267	i0	83.1	1.8780487804878	77	13	93.9	0	3	233	194	270	WP_213106441.1 amino acid permease [Candidatus Protochlamydia amoebophila]	diamond	462	135	0.992592592592593	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila

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