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

9 rows where bioproject = "PRJEB8827", 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
25530398	25530398	PRJEB8827i_S_NODE_257_length_318_cov_5.501767_g252_i0	PRJEB8827	257	318	5.501767	17.49561906	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	549	8.669999999999997e-152	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g252	i0	100	125.377358490566	297	0	93	0	1	297	1249368	1249072	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	39870	549	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25530401	25530401	PRJEB8827i_S_NODE_489_length_264_cov_1087.829694_g484_i0	PRJEB8827	489	264	1087.829694	2871.87039216	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	394	3.48e-105	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g484	i0	99.537	79.0492424242424	216	1	82	0	3	218	1251043	1250828	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	20869	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25617861	25617861	PRJEB8827i_S_NODE_281_length_309_cov_6.587591_g276_i0	PRJEB8827	281	309	6.587591	20.35565619	Candidatus Protochlamydia	282132	Bacteria	Bacteria	531	3.0399999999999998e-146	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g276	i0	99.655	95.3495145631068	290	1	94	0	1	290	2475198	2474909	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29463	531	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25802462	25802462	PRJEB8827h_S_NODE_34355_length_172_cov_2.627737_g34336_i0	PRJEB8827	34355	172	2.627737	4.51970764	root	1	Root_unresolved	Root_unresolved	75.1	7.75e-15	NR	WP_041016398.1	340071	g34336	i0	76.9	18.9244186046512	39	9	68	0	172	56	163	201	WP_041016398.1 Fe-Mn family superoxide dismutase [Criblamydia sequanensis]	diamond	3255	75.5	0.994701986754967	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
25802523	25802523	PRJEB8827i_S_NODE_1547_length_199_cov_2.353659_g1542_i0	PRJEB8827	1547	199	2.353659	4.68378141	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	355	1.18e-93	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1542	i0	98.995	149.869346733668	199	1	100	1	1	199	1249919	1249722	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	29824	355	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25938759	25938759	PRJEB8827i_S_NODE_60_length_449_cov_12.780193_g55_i0	PRJEB8827	60	449	12.780193	57.38306657	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	819	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g55	i0	99.555	125.320712694877	449	2	100	0	1	449	1250041	1250489	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	56269	819	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26074721	26074721	PRJEB8827i_S_NODE_4821_length_171_cov_3.772059_g4816_i0	PRJEB8827	4821	171	3.772059	6.45022089	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	283	4.67e-72	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g4816	i0	96.491	2.00584795321637	171	6	100	0	1	171	2281086	2281256	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	343	283	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26210956	26210956	PRJEB8827i_S_NODE_2670_length_184_cov_5.832215_g2665_i0	PRJEB8827	2670	184	5.832215	10.7312756	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	327	2.3299999999999996e-85	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g2665	i0	98.907	221.032608695652	183	2	99	0	1	183	1249572	1249390	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	40670	327	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
26482840	26482840	PRJEB8827g_S_NODE_1168_length_278_cov_3.308642_g1147_i0	PRJEB8827	1168	278	3.308642	9.19802476	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	414	2.83e-111	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1147	i0	99.559	131.73381294964	227	1	82	0	22	248	1250182	1250408	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	36622	414	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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