metadata: contig_metadata: 21 rows where bioproject = "PRJNA492406", tax_clade = "PVC group" and tax

21 rows where bioproject = "PRJNA492406", 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
1099366	1099366	PRJNA492406_P_NODE_9181_length_404_cov_2.338369_g8882_i0	PRJNA492406	9181	404	2.338369	9.44701076	Parachlamydiales	1963360	Bacteria	Bacteria	460	5.429999999999998e-125	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g8882	i0	87.376	181.556930693069	404	47	99	4	3	404	1105	1506	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	73349	460	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
3650336	3650336	PRJNA492406_P_NODE_16883_length_304_cov_2.580087_g16584_i0	PRJNA492406	16883	304	2.580087	7.84346448	Parachlamydia	83551	Bacteria	Bacteria	418	2.4199999999999993e-112	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g16584	i0	91.475	87.4046052631579	305	24	100	2	1	304	1084	781	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	26571	418	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
4279782	4279782	PRJNA492406_P_NODE_4224_length_584_cov_4.201566_g3930_i0	PRJNA492406	4224	584	4.201566	24.53714544	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	647	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3930	i0	86.757	106.708904109589	589	69	100	8	1	584	654307	653723	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	62318	647	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8752207	8752207	PRJNA492406_P_NODE_2987_length_697_cov_2.440705_g2699_i0	PRJNA492406	2987	697	2.440705	17.01171385	Neochlamydia	112987	Bacteria	Bacteria	725	0	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g2699	i0	87.231	111.219512195122	650	65	92	17	1	643	1505	2143	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	77520	725	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
10656066	10656066	PRJNA492406_P_NODE_16869_length_304_cov_3.186147_g16570_i0	PRJNA492406	16869	304	3.186147	9.68588688	Chlamydiales bacterium QZY	2803004	Bacteria	Bacteria	289	1.9799999999999996e-73	NTclustered	gi\|1955632013\|gb\|MW471098.1\|	2803004	g16570	i0	90.783	40.7105263157895	217	19	71	1	1	217	252	37	Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence	blastn	12376	289	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium QZY
13852796	13852796	PRJNA492406_P_NODE_15031_length_323_cov_2.088000_g14732_i0	PRJNA492406	15031	323	2.088	6.74424	Bacteria	2	Bacteria	Bacteria	503	6.97e-138	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g14732	i0	94.737	170.291021671827	323	17	100	0	1	323	627123	626801	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	55004	503	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
15127173	15127173	PRJNA492406_P_NODE_10692_length_378_cov_1.259016_g10393_i0	PRJNA492406	10692	378	1.259016	4.75908048	Pseudomonadati	3379134	Bacteria	Bacteria	403	8.63e-108	NTclustered	gi\|5042360\|gb\|U68460.2\|SSU68460	83561	g10393	i0	86.016	143.994708994709	379	49	100	4	1	378	4999	4624	Simkania negevensis 16S and 23S ribosomal RNA operon, complete sequence; and putative endonuclease homodimer gene, complete cds	blastn	54430	403	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
15127228	15127228	PRJNA492406_P_NODE_18912_length_288_cov_1.790698_g18613_i0	PRJNA492406	18912	288	1.790698	5.15721024	Parachlamydia	83551	Bacteria	Bacteria	276	1.45e-69	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g18613	i0	84.192	135.739583333333	291	38	100	8	1	288	482	197	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	39093	276	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
15127257	15127257	PRJNA492406_P_NODE_22552_length_271_cov_1.176768_g22253_i0	PRJNA492406	22552	271	1.176768	3.18904128	Candidatus Protochlamydia	282132	Bacteria	Bacteria	351	2.19e-92	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g22253	i0	90.11	108.011070110701	273	23	100	3	1	271	1249436	1249166	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	29271	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
17029991	17029991	PRJNA492406_P_NODE_3434_length_647_cov_4.916376_g3144_i0	PRJNA492406	3434	647	4.916376	31.80895272	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	723	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3144	i0	86.85	337.197836166924	654	76	100	6	1	647	654215	653565	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	218167	723	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
18303939	18303939	PRJNA492406_P_NODE_15555_length_318_cov_1.257143_g15256_i0	PRJNA492406	15555	318	1.257143	3.99771474	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	211	4.65e-50	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g15256	i0	78.947	145.584905660377	323	58	100	10	1	318	835895	836212	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	46296	211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
20854277	20854277	PRJNA492406_P_NODE_29317_length_246_cov_0.890173_g29018_i0	PRJNA492406	29317	246	0.890173	2.18982558	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g29018	i0	81.893	198.768292682927	243	35	98	9	1	239	653739	653976	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48897	196	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21501212	21501212	PRJNA492406_P_NODE_5177_length_526_cov_4.205298_g4882_i0	PRJNA492406	5177	526	4.205298	22.11986748	Waddlia	71666	Bacteria	Bacteria	394	7.44e-105	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g4882	i0	80.529	170.467680608365	529	90	99	9	3	526	1188	1708	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	89666	394	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
22129009	22129009	PRJNA492406_P_NODE_27778_length_249_cov_0.875000_g27479_i0	PRJNA492406	27778	249	0.875	2.17875	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	124	4.709999999999999e-24	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g27479	i0	91.209	1.39759036144578	91	8	37	0	29	119	1297087	1296997	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	348	124	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
24678746	24678746	PRJNA492406_P_NODE_3740_length_620_cov_2.868373_g3447_i0	PRJNA492406	3740	620	2.868373	17.7839126	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	904	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3447	i0	93.076	156.970967741935	621	37	99	5	1	618	654209	654826	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	97322	904	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27455818	27455818	PRJNA492406_P_NODE_19463_length_286_cov_1.276995_g19164_i0	PRJNA492406	19463	286	1.276995	3.6522057	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.00604	NR	NGX31959.1	2081524	g19164	i0	58.6	1.3006993006993	29	12	30.4	0	23	109	2	30	NGX31959.1 hypothetical protein [Chlamydiota bacterium]	diamond	372	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
28907771	28907771	PRJNA492406_P_NODE_23368_length_267_cov_0.891753_g23069_i0	PRJNA492406	23368	267	0.891753	2.38098051	Chlamydiia bacterium	2052156	Bacteria	Bacteria	105	3.99e-25	NR	MCH9621550.1	2052156	g23069	i0	55.2	0.97752808988764	87	39	97.8	0	267	7	71	157	MCH9621550.1 hypothetical protein [Chlamydiia bacterium]	diamond	261	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
29145362	29145362	PRJNA492406_P_NODE_6889_length_460_cov_1.400517_g6590_i0	PRJNA492406	6889	460	1.400517	6.4423782	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.02e-15	NR	OGN62432.1	1797603	g6590	i0	32.3	4.00434782608696	161	96	99.8	4	2	460	79	234	OGN62432.1 MAG: hypothetical protein A3F09_04955 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11]	diamond	1842	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11
29302883	29302883	PRJNA492406_P_NODE_29849_length_245_cov_0.895349_g29550_i0	PRJNA492406	29849	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	81.3	1.03e-15	NR	MCB1107385.1	2052156	g29550	i0	43.8	3.61224489795918	73	41	89.4	0	237	19	62	134	MCB1107385.1 hypothetical protein [Chlamydiia bacterium]	diamond	885	81.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30487235	30487235	PRJNA492406_P_NODE_22473_length_271_cov_1.555556_g22174_i0	PRJNA492406	22473	271	1.555556	4.21555676	Chlamydiales bacterium	2047757	Bacteria	Bacteria	202	7.07e-62	NR	MFI5344317.1	2047757	g22174	i0	94.4	0.996309963099631	90	5	99.6	0	2	271	170	259	MFI5344317.1 fatty acid desaturase [Chlamydiales bacterium]	diamond	270	202	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31624985	31624985	PRJNA492406_P_NODE_15556_length_318_cov_1.257143_g15257_i0	PRJNA492406	15556	318	1.257143	3.99771474	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	82.8	9.53e-17	NR	OJU81588.1	1895742	g15257	i0	70.4	1	54	16	50.9	0	157	318	3	56	OJU81588.1 MAG: 50S ribosomal protein L1 [Chlamydia sp. 32-24]	diamond	318	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24

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