metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax_clade = "PVC group"

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
3003258	3003258	PRJNA492406_P_NODE_25543_length_256_cov_1.213115_g25244_i0	PRJNA492406	25543	256	1.213115	3.1055744	Phycisphaera sp.	2030824	Bacteria	Bacteria	296	9.74e-76	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g25244	i0	90.043	497.13671875	231	19	90	4	2	231	3046480	3046707	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	127267	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
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
4279443	4279443	PRJNA492406_P_NODE_18364_length_291_cov_1.059633_g18065_i0	PRJNA492406	18364	291	1.059633	3.08353203	Planctomycetota bacterium	2026780	Bacteria	Bacteria	117	9.43e-22	NTclustered	gi\|1949774590\|gb\|CP066225.1\|	2026780	g18065	i0	90	28.6426116838488	90	9	31	0	193	282	4975449	4975538	Planctomycetota bacterium strain ZRK32 chromosome, complete genome	blastn	8335	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
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
4927369	4927369	PRJNA492406_P_NODE_21724_length_275_cov_1.465347_g21425_i0	PRJNA492406	21724	275	1.465347	4.02970425	Planctomycetota	203682	Bacteria	Bacteria	233	8.41e-57	NTclustered	gi\|1927964719\|gb\|CP054188.1\|	2052181	g21425	i0	82.576	337.516363636364	264	46	96	0	1	264	585708	585971	MAG: Planctomycetia bacterium isolate H1_AMX1 chromosome, complete genome	blastn	92817	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
8105571	8105571	PRJNA492406_P_NODE_20627_length_280_cov_1.937198_g20328_i0	PRJNA492406	20627	280	1.937198	5.4241544	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	372	1.7399999999999995e-98	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g20328	i0	91.039	132.657142857143	279	19	99	5	2	278	1728192	1728466	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	37144	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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
9380636	9380636	PRJNA492406_P_NODE_508_length_1602_cov_2.741007_g384_i0	PRJNA492406	508	1602	2.741007	43.91093214	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1467	0	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g384	i0	83.488	442.92759051186	1617	223	99	35	4	1602	1867802	1866212	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	709570	1467	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
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
18303977	18303977	PRJNA492406_P_NODE_17175_length_301_cov_2.504386_g16876_i0	PRJNA492406	17175	301	2.504386	7.53820186	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	392	1.4499999999999994e-104	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g16876	i0	91.034	325.102990033223	290	26	96	0	1	290	2192489	2192200	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	97856	392	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
19578263	19578263	PRJNA492406_P_NODE_19856_length_284_cov_1.450237_g19557_i0	PRJNA492406	19856	284	1.450237	4.11867308	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g19557	i0	99.648	100.246478873239	284	1	100	0	1	284	408	125	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	28470	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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
22128916	22128916	PRJNA492406_P_NODE_23678_length_265_cov_1.567708_g23379_i0	PRJNA492406	23678	265	1.567708	4.1544262	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|673538887\|gb\|KJ611639.1\|	100371	g23379	i0	99.245	99.3320754716981	265	2	100	0	1	265	156	420	Uncultured Planctomycetales bacterium clone Uvmin2_16 16S ribosomal RNA gene, partial sequence	blastn	26323	479	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
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

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