metadata: contig_metadata: 15 rows where bioproject = "PRJNA1240804", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA1240804", 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
4174867	4174867	PRJNA1240804_P_NODE_19364_length_315_cov_9.421053_g18998_i0	PRJNA1240804	19364	315	9.421053	29.67631695	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	372	1.99e-98	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g18998	i0	92.941	124.526984126984	255	18	81	0	54	308	835389	835643	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	39226	372	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
4877937	4877937	PRJNA1240804_P_NODE_102204_length_172_cov_1.260163_g101838_i0	PRJNA1240804	102204	172	1.260163	2.16748036	Parachlamydiales	1963360	Bacteria	Bacteria	243	7.979999999999999e-60	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g101838	i0	94.34	115.354651162791	159	8	92	1	1	158	1250932	1251090	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	19841	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
10551173	10551173	PRJNA1240804_P_NODE_12469_length_374_cov_3.593846_g12104_i0	PRJNA1240804	12469	374	3.593846	13.44098404	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	490	6.36e-134	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g12104	i0	91.761	458.729946524064	352	29	94	0	15	366	653292	652941	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	171565	490	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10552034	10552034	PRJNA1240804_P_NODE_30289_length_265_cov_1.712963_g29923_i0	PRJNA1240804	30289	265	1.712963	4.53935195	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	335	2.149999999999999e-87	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g29923	i0	89.811	178.675471698113	265	22	99	5	4	265	1249428	1249166	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	47349	335	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
11826424	11826424	PRJNA1240804_P_NODE_170_length_1828_cov_4.599775_g92_i0	PRJNA1240804	170	1828	4.599775	84.083887	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	2169	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g92	i0	88.39	184.098468271335	1826	180	99	29	15	1828	655359	653554	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	336532	2169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14375820	14375820	PRJNA1240804_P_NODE_105892_length_169_cov_2.366667_g105526_i0	PRJNA1240804	105892	169	2.366667	3.99966723	Parachlamydiaceae bacterium CRIB38	553506	Bacteria	Bacteria	196	6.16e-46	NTclustered	gi\|196051291\|gb\|EU683886.1\|	553506	g105526	i0	89.809	88.9763313609467	157	11	92	5	15	169	98	251	Parachlamydiaceae bacterium CRIB38 16S ribosomal RNA gene, partial sequence	blastn	15037	196	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium CRIB38
16925621	16925621	PRJNA1240804_P_NODE_49154_length_220_cov_1.637427_g48788_i0	PRJNA1240804	49154	220	1.637427	3.6023394	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	348	2.2200000000000005e-91	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g48788	i0	97.087	149.063636363636	206	6	94	0	1	206	653893	654098	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32794	348	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21452202	21452202	PRJNA1240804_P_NODE_72897_length_191_cov_1.830986_g72531_i0	PRJNA1240804	72897	191	1.830986	3.49718326	Parachlamydia	83551	Bacteria	Bacteria	287	4.14e-73	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g72531	i0	93.75	118.774869109948	192	11	100	1	1	191	845	1036	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	22686	287	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22023534	22023534	PRJNA1240804_P_NODE_10318_length_403_cov_2.290960_g9955_i0	PRJNA1240804	10318	403	2.29096	9.2325688	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	508	1.91e-139	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g9955	i0	90.256	96.697270471464	390	37	97	1	1	389	1250660	1250271	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	38969	508	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
23301567	23301567	PRJNA1240804_P_NODE_86279_length_182_cov_1.496241_g85913_i0	PRJNA1240804	86279	182	1.496241	2.72315862	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	143	8.93e-30	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g85913	i0	82.927	1.35164835164835	164	22	89	3	7	168	1715	1556	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	246	143	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
29599433	29599433	PRJNA1240804_P_NODE_109830_length_169_cov_0.866667_g109464_i0	PRJNA1240804	109830	169	0.866667	1.46466723	Chlamydiia bacterium	2052156	Bacteria	Bacteria	48.5	1.25e-4	NR	MCH9612746.1	2052156	g109464	i0	68.8	1.24260355029586	32	10	56.8	0	154	59	270	301	MCH9612746.1 putative peptidoglycan glycosyltransferase FtsW [Chlamydiia bacterium]	diamond	210	48.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30610481	30610481	PRJNA1240804_P_NODE_46473_length_225_cov_1.011364_g46107_i0	PRJNA1240804	46473	225	1.011364	2.275569	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	60.1	2.35e-8	NR	WP_068468395.1	1414722	g46107	i0	45.8	2.94666666666667	59	32	78.7	0	1	177	460	518	WP_068468395.1 PKD-like domain-containing protein [Candidatus Protochlamydia phocaeensis]	diamond	663	60.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
30642045	30642045	PRJNA1240804_P_NODE_149953_length_162_cov_0.920354_g149587_i0	PRJNA1240804	149953	162	0.920354	1.49097348	Parachlamydia sp.	2052048	Bacteria	Bacteria	82.4	6.64e-17	NR	MCE5317346.1	2052048	g149587	i0	73.5	2.72222222222222	49	13	90.7	0	149	3	58	106	MCE5317346.1 glutamyl-tRNA reductase [Parachlamydia sp.]	diamond	441	82.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
30926720	30926720	PRJNA1240804_P_NODE_100134_length_173_cov_1.564516_g99768_i0	PRJNA1240804	100134	173	1.564516	2.70661268	Waddliaceae bacterium	2026802	Bacteria	Bacteria	75.9	3e-14	NR	HEY4832839.1	2026802	g99768	i0	79.2	0.832369942196532	48	10	83.2	0	20	163	109	156	HEY4832839.1 murein biosynthesis integral membrane protein MurJ [Waddliaceae bacterium]	diamond	144	75.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
32255144	32255144	PRJNA1240804_P_NODE_100418_length_173_cov_1.435484_g100052_i0	PRJNA1240804	100418	173	1.435484	2.48338732	Chlamydiia bacterium	2052156	Bacteria	Bacteria	52	7.72e-6	NR	MCB1119066.1	2052156	g100052	i0	44.2	0.901734104046243	52	29	90.2	0	158	3	173	224	MCB1119066.1 polysaccharide export protein [Chlamydiia bacterium]	diamond	156	52	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia 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);;