metadata: contig_metadata: 11 rows where bioproject = "PRJNA753704", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA753704", 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
730894	730894	PRJNA753704_P_NODE_12381_length_337_cov_7.469697_g12020_i0	PRJNA753704	12381	337	7.469697	25.17287889	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	623	5.369999999999999e-174	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g12020	i0	100	114.93175074184	337	0	100	0	1	337	1251243	1251579	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	38732	623	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
731102	731102	PRJNA753704_P_NODE_3941_length_564_cov_1.747454_g3583_i0	PRJNA753704	3941	564	1.747454	9.85564056	Candidatus Syngnamydia salmonis	504270	Bacteria	Bacteria	564	5.78e-156	NTclustered	gi\|1214145827\|gb\|KY427067.1\|	504270	g3583	i0	84.886	113.471631205674	569	75	100	10	1	564	2486	1924	Candidatus Syngnamydia salmonis isolate H03/14Pp 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer 23S ribosomal RNA and 5S ribosomal RNA genes, complete sequence	blastn	63998	564	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Syngnamydia	Candidatus Syngnamydia salmonis
2007096	2007096	PRJNA753704_P_NODE_23722_length_252_cov_2.206704_g23361_i0	PRJNA753704	23722	252	2.206704	5.56089408	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	316	7.34e-82	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g23361	i0	89.37	63.2539682539683	254	23	100	3	1	252	1249574	1249323	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	15940	316	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
3753703	3753703	PRJNA753704_P_NODE_13063_length_329_cov_3.316406_g12702_i0	PRJNA753704	13063	329	3.316406	10.91097574	Candidatus Protochlamydia	282132	Bacteria	Bacteria	508	1.53e-139	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g12702	i0	94.545	146.686930091185	330	16	100	2	1	329	1250703	1250375	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	48260	512	0.9921875	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
4559534	4559534	PRJNA753704_P_NODE_25644_length_248_cov_0.891429_g25283_i0	PRJNA753704	25644	248	0.891429	2.21074392	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	309	1.21e-79	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g25283	i0	89.113	53.866935483871	248	27	100	0	1	248	1250662	1250415	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	13359	309	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
14759945	14759945	PRJNA753704_P_NODE_1952_length_779_cov_12.237960_g1621_i0	PRJNA753704	1952	779	12.23796	95.3337084	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1439	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1621	i0	100	123.103979460847	779	0	100	0	1	779	1249611	1250389	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	95898	1439	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
16033792	16033792	PRJNA753704_P_NODE_3453_length_601_cov_6.590909_g3097_i0	PRJNA753704	3453	601	6.590909	39.61136309	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	1110	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g3097	i0	100	116.37936772046601	601	0	100	0	1	601	1250989	1250389	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	69944	1110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
16505039	16505039	PRJNA753704_P_NODE_5813_length_475_cov_2.144279_g5452_i0	PRJNA753704	5813	475	2.144279	10.18532525	Bacteria	2	Bacteria	Bacteria	490	8.269999999999998e-134	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g5452	i0	85.867	98.2547368421053	467	59	98	5	1	465	2363381	2363842	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	46671	494	0.991902834008097	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
23683927	23683927	PRJNA753704_P_NODE_10959_length_357_cov_4.566901_g10598_i0	PRJNA753704	10959	357	4.566901	16.30383657	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	399	1.0499999999999998e-106	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g10598	i0	86.981	134.890756302521	361	39	100	8	1	357	1316726	1316370	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	48156	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis
31158385	31158385	PRJNA753704_P_NODE_23575_length_253_cov_0.866667_g23214_i0	PRJNA753704	23575	253	0.866667	2.19266751	Chlamydiota bacterium	2081524	Bacteria	Bacteria	108	1.84e-26	NR	MCH9631726.1	2081524	g23214	i0	64.3	0.99604743083004	84	30	99.6	0	252	1	116	199	MCH9631726.1 Ribonuclease Z [Chlamydiota bacterium]	diamond	252	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32613697	32613697	PRJNA753704_P_NODE_27560_length_244_cov_0.912281_g27199_i0	PRJNA753704	27560	244	0.912281	2.22596564	Chlamydiota bacterium	2081524	Bacteria	Bacteria	98.2	5.81e-22	NR	MBM3194281.1	2081524	g27199	i0	58.8	0.983606557377049	80	33	98.4	0	241	2	292	371	MBM3194281.1 glycosyltransferase [Chlamydiota bacterium]	diamond	240	98.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;