metadata: contig_metadata: 23 rows where bioproject = "PRJNA315314", tax_clade = "PVC group" and tax

23 rows where bioproject = "PRJNA315314", 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
1655626	1655626	PRJNA315314_S_NODE_23122_length_173_cov_4.104167_g22801_i0	PRJNA315314	23122	173	4.104167	7.10020891	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g22801	i0	100	0.173410404624277	30	0	17	0	1	30	2363010	2362981	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
4208286	4208286	PRJNA315314_S_NODE_7464_length_295_cov_5.300752_g7143_i0	PRJNA315314	7464	295	5.300752	15.6372184	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	418	2.3399999999999992e-112	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g7143	i0	93.31	74.5220338983051	284	18	96	1	13	295	1827228	1826945	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	21984	418	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
4208311	4208311	PRJNA315314_S_NODE_8384_length_279_cov_4.504000_g8063_i0	PRJNA315314	8384	279	4.504	12.56616	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	394	3.709999999999999e-105	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g8063	i0	92.143	100.358422939068	280	21	100	1	1	279	2362765	2363044	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	28000	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
6758691	6758691	PRJNA315314_S_NODE_5886_length_332_cov_5.887789_g5565_i0	PRJNA315314	5886	332	5.887789	19.54745948	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	385	2.71e-102	NTclustered	gi\|2041293252\|gb\|CP073763.1\|	2698248	g5565	i0	88.182	146.490963855422	330	29	98	10	7	332	8070	7747	MAG: Simkaniaceae bacterium isolate M30B1 chromosome, complete genome	blastn	48635	385	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
11859667	11859667	PRJNA315314_S_NODE_4490_length_377_cov_143.014368_g4169_i0	PRJNA315314	4490	377	143.014368	539.16416736	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	507	6.38e-139	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4169	i0	91.803	113.376657824934	366	27	97	3	2	365	2059647	2060011	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	42743	507	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15683377	15683377	PRJNA315314_S_NODE_16073_length_204_cov_10.022857_g15752_i0	PRJNA315314	16073	204	10.022857	20.44662828	Candidatus Rubidus massiliensis	1444712	Bacteria	Bacteria	320	4.42e-83	NTclustered	gi\|565666443\|emb\|HG726047.1\|	1444712	g15752	i0	95.098	109.529411764706	204	8	100	2	1	204	125	326	Candidatus Rubidus massiliensis partial 16S rRNA gene, strain Rubis	blastn	22344	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Candidatus Rubidus	Candidatus Rubidus massiliensis
15683385	15683385	PRJNA315314_S_NODE_1653_length_604_cov_6.059130_g1390_i0	PRJNA315314	1653	604	6.05913	36.5971452	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	592	2.8499999999999993e-164	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1390	i0	84.426	284.756622516556	610	86	100	9	1	604	2059776	2060382	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	171993	592	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15683556	15683556	PRJNA315314_S_NODE_2793_length_472_cov_76.476298_g2478_i0	PRJNA315314	2793	472	76.476298	360.96812656	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	8.389999999999998e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g2478	i0	92.787	99.5148305084746	305	21	65	1	165	469	654938	654635	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	46971	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15683557	15683557	PRJNA315314_S_NODE_28033_length_159_cov_3.176923_g27712_i0	PRJNA315314	28033	159	3.176923	5.05130757	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	195	2.07e-45	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g27712	i0	88.75	89.6037735849057	160	16	100	2	1	159	870	712	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	14247	195	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
16367856	16367856	PRJNA315314_S_NODE_24353_length_169_cov_4.742857_g24032_i0	PRJNA315314	24353	169	4.742857	8.01542833	Pseudomonadati	3379134	Bacteria	Bacteria	241	2.81e-59	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g24032	i0	92.353	156.076923076923	170	12	100	1	1	169	9282	9451	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	26377	241	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
16958380	16958380	PRJNA315314_S_NODE_3754_length_413_cov_5.580729_g3433_i0	PRJNA315314	3754	413	5.580729	23.04841077	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	409	2.04e-109	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g3433	i0	84.634	124.075060532688	410	63	99	0	3	412	2363356	2363765	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	51243	409	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
17643002	17643002	PRJNA315314_S_NODE_4294_length_386_cov_4.904762_g3973_i0	PRJNA315314	4294	386	4.904762	18.93238132	Bacteria	2	Bacteria	Bacteria	383	1.1499999999999998e-101	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g3973	i0	84.733	453.235751295337	393	49	100	10	1	386	3520	3132	Chlamydiales symbiont of Xenoturbella westbladi 16S ribosomal RNA gene, partial sequence; 23S ribosomal RNA gene, complete sequence; and putative homing endonuclease gene, complete cds	blastn	174949	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
19506768	19506768	PRJNA315314_S_NODE_1996_length_552_cov_76.495220_g1714_i0	PRJNA315314	1996	552	76.49522	422.2536144	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	440	9.919999999999996e-119	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1714	i0	92.787	83.4746376811594	305	21	55	1	4	308	654635	654938	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	46078	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20782308	20782308	PRJNA315314_S_NODE_1997_length_552_cov_70.602294_g1715_i0	PRJNA315314	1997	552	70.602294	389.72466288	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	446	2.13e-120	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1715	i0	81.607	88.7391304347826	560	83	99	15	1	549	655185	654635	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48984	446	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
20782531	20782531	PRJNA315314_S_NODE_4817_length_365_cov_48.241071_g4496_i0	PRJNA315314	4817	365	48.241071	176.07990915	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	505	2.209999999999999e-138	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g4496	i0	91.736	119.778082191781	363	30	99	0	1	363	2361248	2361610	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	43719	505	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
21467103	21467103	PRJNA315314_S_NODE_26997_length_162_cov_1.917293_g26676_i0	PRJNA315314	26997	162	1.917293	3.10601466	Candidatus Protochlamydia	282132	Bacteria	Bacteria	147	6.009999999999999e-31	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g26676	i0	84.211	21.5864197530864	152	23	94	1	1	152	1249894	1250044	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	3497	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
22057517	22057517	PRJNA315314_S_NODE_5678_length_337_cov_3747.532468_g5357_i0	PRJNA315314	5678	337	3747.532468	12629.18441716	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	440	5.809999999999998e-119	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g5357	i0	90.663	177.350148367953	332	30	98	1	1	331	413840	413509	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	59767	440	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
23332880	23332880	PRJNA315314_S_NODE_24339_length_169_cov_5.435714_g24018_i0	PRJNA315314	24339	169	5.435714	9.18635666	Estrella lausannensis	483423	Bacteria	Bacteria	185	1.33e-42	NTclustered	gi\|343183590\|gb\|JN201889.1\|	483423	g24018	i0	86.747	63.6272189349112	166	22	98	0	4	169	2432	2267	Estrella lausannensis 23S ribosomal RNA gene, complete sequence	blastn	10753	185	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Estrella	Estrella lausannensis
24606787	24606787	PRJNA315314_S_NODE_15560_length_207_cov_274.932584_g15239_i0	PRJNA315314	15560	207	274.932584	569.11044888	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	281	2.12e-71	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g15239	i0	91.304	125.724637681159	207	16	99	2	2	206	654085	654291	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	26025	281	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
24606832	24606832	PRJNA315314_S_NODE_18000_length_194_cov_3.884848_g17679_i0	PRJNA315314	18000	194	3.884848	7.53660512	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	239	1.1999999999999999e-58	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g17679	i0	89.119	81.7577319587629	193	19	99	2	1	193	2366206	2366016	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	15861	239	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
24606969	24606969	PRJNA315314_S_NODE_25780_length_165_cov_2.838235_g25459_i0	PRJNA315314	25780	165	2.838235	4.68308775	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	193	7.79e-45	NTclustered	gi\|18029192\|gb\|AF364563.1\|	174324	g25459	i0	87.647	88.9818181818182	170	16	100	3	1	165	13	182	Uncultured Chlamydiales bacterium clone P-3 16S ribosomal RNA gene, partial sequence	blastn	14682	193	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
29442484	29442484	PRJNA315314_S_NODE_20470_length_183_cov_1.792208_g20149_i0	PRJNA315314	20470	183	1.792208	3.27974064	Waddliaceae bacterium	2026802	Bacteria	Bacteria	94	5.07e-21	NR	HEY4831209.1	2026802	g20149	i0	81.4	0.967213114754098	59	11	96.7	0	3	179	215	273	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	177	94	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
32287680	32287680	PRJNA315314_S_NODE_27699_length_160_cov_2.557252_g27378_i0	PRJNA315314	27699	160	2.557252	4.0916032	Chlamydia suis	83559	Bacteria	Bacteria	39.3	0.0327	NR	WP_219663935.1	83559	g27378	i0	43.9	0.76875	41	23	76.9	0	31	153	2	42	WP_219663935.1 hypothetical protein, partial [Chlamydia suis]	diamond	123	39.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia suis

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