metadata: contig_metadata: 9 rows where bioproject = "PRJNA674308", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA674308", 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
3195474	3195474	PRJNA674308_P_NODE_17643_length_232_cov_1.136612_g17408_i0	PRJNA674308	17643	232	1.136612	2.63693984	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	407	3.84e-109	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g17408	i0	98.276	61.375	232	4	100	0	1	232	791030	791261	Neochlamydia sp. S13 DNA, complete genome	blastn	14239	407	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
5748166	5748166	PRJNA674308_P_NODE_25445_length_198_cov_2.436242_g25210_i0	PRJNA674308	25445	198	2.436242	4.82375916	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g25210	i0	95.96	53.9848484848485	198	8	100	0	1	198	1250165	1249968	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	10689	322	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
12124034	12124034	PRJNA674308_P_NODE_31210_length_181_cov_1.568182_g30975_i0	PRJNA674308	31210	181	1.568182	2.83840942	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	132	1.92e-26	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g30975	i0	86.667	18.2044198895028	120	14	66	2	48	166	1294163	1294045	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	3295	132	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
12124271	12124271	PRJNA674308_P_NODE_8610_length_324_cov_1.854545_g8375_i0	PRJNA674308	8610	324	1.854545	6.0087258	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	472	1.97e-128	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g8375	i0	92.923	116.287037037037	325	21	100	2	1	324	1251037	1250714	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	37677	472	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
12646031	12646031	PRJNA674308_P_NODE_52170_length_162_cov_0.920354_g51935_i0	PRJNA674308	52170	162	0.920354	1.49097348	Neochlamydia	112987	Bacteria	Bacteria	272	9.51e-69	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g51935	i0	96.914	192.925925925926	162	5	100	0	1	162	652676	652515	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	31254	272	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
16469387	16469387	PRJNA674308_P_NODE_25533_length_198_cov_1.395973_g25298_i0	PRJNA674308	25533	198	1.395973	2.76402654	Candidatus Protochlamydia	282132	Bacteria	Bacteria	320	4.26e-83	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g25298	i0	96.392	163.227272727273	194	7	98	0	4	197	1249337	1249144	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	32319	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
19771503	19771503	PRJNA674308_P_NODE_18676_length_226_cov_2.016949_g18441_i0	PRJNA674308	18676	226	2.016949	4.55830474	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g18441	i0	94.69	251.035398230089	226	12	100	0	1	226	654541	654766	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	56734	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21568877	21568877	PRJNA674308_P_NODE_8077_length_335_cov_1.451049_g7842_i0	PRJNA674308	8077	335	1.451049	4.86101415	Candidatus Protochlamydia	282132	Bacteria	Bacteria	470	7.36e-128	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g7842	i0	91.964	73.3522388059701	336	26	100	1	1	335	1250288	1249953	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	24573	470	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
28566055	28566055	PRJNA674308_P_NODE_4547_length_449_cov_1.632500_g4312_i0	PRJNA674308	4547	449	1.6325	7.329925	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	48.5	2.23e-4	NR	HEV8052445.1	2052176	g4312	i0	53.7	2.45211581291759	41	19	27.4	0	6	128	24	64	HEV8052445.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	1101	48.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;