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

9 rows where bioproject = "PRJNA169559", 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
1639999	1639999	PRJNA169559_P_NODE_7822_length_607_cov_5.489619_g6236_i0	PRJNA169559	7822	607	5.489619	33.32198733	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	673	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g6236	i0	86.829	116.31136738056	615	66	99	15	2	607	2058780	2059388	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	70601	673	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11843784	11843784	PRJNA169559_P_NODE_690_length_2008_cov_3.763517_g322_i0	PRJNA169559	690	2008	3.763517	75.57142136	root	1	Root_unresolved	Root_unresolved	785	3.05e-278	NR	WP_013182645.1	71667	g322	i0	62.2	10.9093625498008	611	221	91.1	6	1861	32	2	603	WP_013182645.1 phosphoenolpyruvate carboxykinase (GTP) [Waddlia chondrophila]	diamond	21906	790	0.993670886075949	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
19491185	19491185	PRJNA169559_P_NODE_9016_length_565_cov_252.555970_g7331_i0	PRJNA169559	9016	565	252.55597	1426.9412305	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	656	0	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g7331	i0	87.805	187.955752212389	574	53	100	16	1	565	177528	176963	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	106195	656	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
22731624	22731624	PRJNA169559_P_NODE_7438_length_622_cov_3.241147_g5882_i0	PRJNA169559	7438	622	3.2411469999999998	20.15993434	Pseudomonadati	3379134	Bacteria	Bacteria	614	6.279999999999998e-171	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g5882	i0	85.294	80.2138263665595	612	70	97	16	1	600	1250228	1250831	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	49893	614	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
27737631	27737631	PRJNA169559_P_NODE_48424_length_159_cov_2.176923_g46347_i0	PRJNA169559	48424	159	2.176923	3.4613075699999998	Candidatus Rhabdochlamydia sp.	2320511	Bacteria	Bacteria	109	3.01e-26	NR	MFI0478845.1	2320511	g46347	i0	98	0.962264150943396	51	1	96.2	0	155	3	1100	1150	MFI0478845.1 hypothetical protein [Candidatus Rhabdochlamydia sp.]	diamond	153	109	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia sp.
28558388	28558388	PRJNA169559_P_NODE_46087_length_200_cov_1.356725_g44010_i0	PRJNA169559	46087	200	1.356725	2.71345	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	146	1.84e-42	NR	MFI0436095.1	2052176	g44010	i0	98.5	0.99	66	1	99	0	3	200	7	72	MFI0436095.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	198	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31748931	31748931	PRJNA169559_P_NODE_45197_length_213_cov_1.923913_g43120_i0	PRJNA169559	45197	213	1.923913	4.09793469	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	63.9	8.32e-10	NR	MFI0436003.1	2052176	g43120	i0	40.3	1.01408450704225	72	41	98.6	1	211	2	454	525	MFI0436003.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	216	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32160526	32160526	PRJNA169559_P_NODE_10278_length_528_cov_37.835671_g8515_i0	PRJNA169559	10278	528	37.835671	199.77234288	Chlamydiales bacterium	2047757	Bacteria	Bacteria	148	3.8e-42	NR	MCP5470421.1	2047757	g8515	i0	51.9	3.40340909090909	156	69	87.5	2	507	46	6	157	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1797	148	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32634362	32634362	PRJNA169559_P_NODE_26900_length_284_cov_1.635294_g24824_i0	PRJNA169559	26900	284	1.635294	4.64423496	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	57.8	2.25e-7	NR	MFI0435901.1	2052176	g24824	i0	76.3	0.401408450704225	38	9	40.1	0	282	169	140	177	MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	114	57.8	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);;