metadata: contig_metadata: 25 rows where bioproject = "PRJNA864829", tax_clade = "PVC group" and tax

25 rows where bioproject = "PRJNA864829", 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
3398012	3398012	PRJNA864829_S_NODE_283_length_776_cov_22.356259_g227_i0	PRJNA864829	283	776	22.356259	173.48456984	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	966	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g227	i0	89.217	121.725515463918	779	77	100	6	1	776	654267	653493	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	94459	966	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
3788793	3788793	PRJNA864829_S_NODE_743_length_536_cov_34.747433_g660_i0	PRJNA864829	743	536	34.747433	186.24624088	Parachlamydia	83551	Bacteria	Bacteria	841	0	NTclustered	gi\|262292950\|gb\|FJ976106.1\|	83552	g660	i0	94.963	113.194029850746	536	27	100	0	1	536	193	728	Parachlamydia acanthamoebae strain cvE19 16S ribosomal RNA gene, partial sequence	blastn	60672	841	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
7225466	7225466	PRJNA864829_S_NODE_16766_length_156_cov_3.046729_g16680_i0	PRJNA864829	16766	156	3.046729	4.75289724	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	250	4.25e-62	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g16680	i0	95.513	139.698717948718	156	7	100	0	1	156	654579	654734	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	21793	250	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7225501	7225501	PRJNA864829_S_NODE_86_length_1195_cov_28.780105_g65_i0	PRJNA864829	86	1195	28.780105	343.92225475	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1400	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g65	i0	88.4	173.694560669456	1181	113	98	20	1	1167	654229	655399	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	207565	1400	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8500193	8500193	PRJNA864829_S_NODE_287_length_774_cov_6.372414_g229_i0	PRJNA864829	287	774	6.372414	49.32248436	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	915	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g229	i0	88.031	118.651162790698	777	88	100	5	1	774	654267	653493	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	91836	915	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
8500209	8500209	PRJNA864829_S_NODE_767_length_531_cov_11.431535_g684_i0	PRJNA864829	767	531	11.431535	60.70145085	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	564	5.41e-156	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g684	i0	86.888	205.83615819209	511	57	95	9	29	531	655403	654895	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	109299	564	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
9775325	9775325	PRJNA864829_S_NODE_7068_length_231_cov_1.450549_g6982_i0	PRJNA864829	7068	231	1.450549	3.35076819	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	311	3.08e-80	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g6982	i0	90.987	37.1428571428571	233	17	99	3	2	231	655170	655401	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	8580	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
11440645	11440645	PRJNA864829_S_NODE_6869_length_234_cov_1.156757_g6783_i0	PRJNA864829	6869	234	1.156757	2.70681138	Candidatus Neptunichlamydia	1891669	Bacteria	Bacteria	195	3.29e-45	NTclustered	gi\|124021662\|gb\|EF177461.1\|	420390	g6783	i0	81.933	160.076923076923	238	36	100	7	1	234	2379	2145	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	37458	195	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Chlamydiales symbiont of Xenoturbella westbladi
13600988	13600988	PRJNA864829_S_NODE_531_length_607_cov_36.021505_g453_i0	PRJNA864829	531	607	36.021505	218.65053535	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	852	0	NTclustered	gi\|1590092048\|gb\|MK616426.1\|	305355	g453	i0	93.391	100.747940691928	575	38	95	0	33	607	1	575	Uncultured Chlamydiae bacterium clone LG126_2 16S ribosomal RNA gene, partial sequence	blastn	61154	852	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
13600998	13600998	PRJNA864829_S_NODE_7551_length_224_cov_3.274286_g7465_i0	PRJNA864829	7551	224	3.274286	7.33440064	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	339	1.36e-88	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g7465	i0	94.144	123.683035714286	222	13	99	0	3	224	654679	654900	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	27705	339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14875292	14875292	PRJNA864829_S_NODE_292_length_769_cov_26.691667_g234_i0	PRJNA864829	292	769	26.691667	205.25891923	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	845	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g234	i0	86.693	121.133940182055	774	88	100	13	1	767	654308	653543	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	93152	845	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14875302	14875302	PRJNA864829_S_NODE_532_length_607_cov_28.956989_g454_i0	PRJNA864829	532	607	28.956989	175.76892323	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	845	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g454	i0	92.979	103.476112026359	584	33	96	8	27	607	657294	656716	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	62810	845	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17425437	17425437	PRJNA864829_S_NODE_1174_length_450_cov_10.655860_g1088_i0	PRJNA864829	1174	450	10.65586	47.95137	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	604	2.6699999999999992e-168	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1088	i0	90.929	157.47111111111099	452	38	100	3	1	450	2059724	2059274	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	70862	604	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19973882	19973882	PRJNA864829_S_NODE_2156_length_356_cov_20.530945_g2070_i0	PRJNA864829	2156	356	20.530945	73.0901642	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure	1771895	Bacteria	Bacteria	573	5.819999999999998e-159	NTclustered	gi\|985700640\|emb\|LN995859.1\|	1771895	g2070	i0	97.885	97.4494382022472	331	7	93	0	26	356	1068	1398	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure partial 16S rRNA gene, clone Trut23-12-2015_Venoge-Embouchure	blastn	34692	573	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. Trut23-12-2015_Venoge-Embouchure
19973890	19973890	PRJNA864829_S_NODE_3396_length_303_cov_2.031496_g3310_i0	PRJNA864829	3396	303	2.031496	6.15543288	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	370	6.859999999999999e-98	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g3310	i0	90.909	49.0759075907591	275	25	91	0	2	276	2060301	2060027	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	14870	370	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
19973911	19973911	PRJNA864829_S_NODE_876_length_504_cov_34.101099_g790_i0	PRJNA864829	876	504	34.101099	171.86953896	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	684	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g790	i0	92.165	105.765873015873	485	37	96	1	21	504	657200	656716	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	53306	684	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21249428	21249428	PRJNA864829_S_NODE_1457_length_415_cov_2.948087_g1371_i0	PRJNA864829	1457	415	2.948087	12.23456105	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	131	7.96e-37	NR	HEV8051784.1	2052176	g1371	i0	86.7	0.6	83	11	60	0	387	139	7	89	HEV8051784.1 DUF5407 family protein [Parachlamydiaceae bacterium]	diamond	249	131	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
21249438	21249438	PRJNA864829_S_NODE_2477_length_338_cov_6.280277_g2391_i0	PRJNA864829	2477	338	6.280277	21.22733626	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	348	3.63e-91	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g2391	i0	86.646	127.399408284024	322	33	93	9	1	316	654870	655187	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	43061	348	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21249457	21249457	PRJNA864829_S_NODE_677_length_560_cov_4.250489_g594_i0	PRJNA864829	677	560	4.250489	23.8027384	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	649	0	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g594	i0	88.519	150.471428571429	540	56	96	6	24	560	2364424	2363888	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	84264	649	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
21249460	21249460	PRJNA864829_S_NODE_717_length_543_cov_4.382591_g634_i0	PRJNA864829	717	543	4.382591	23.79746913	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	593	7.069999999999998e-165	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g634	i0	86.397	108.20073664825	544	72	100	2	1	543	653551	654093	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	58753	593	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
22524007	22524007	PRJNA864829_S_NODE_7938_length_219_cov_3.129412_g7852_i0	PRJNA864829	7938	219	3.129412	6.85341228	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	344	2.85e-90	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g7852	i0	98.462	15.9634703196347	195	3	89	0	25	219	1250544	1250738	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	3496	344	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
25073348	25073348	PRJNA864829_S_NODE_1020_length_476_cov_2.634660_g934_i0	PRJNA864829	1020	476	2.63466	12.5409816	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum	3342349	Bacteria	Bacteria	617	3.64e-172	NTclustered	gi\|2851290179\|emb\|OZ197277.1\|	3342349	g934	i0	91.429	151.470588235294	455	31	95	5	27	476	174938	175389	Rhabdochlamydiaceae symbiont of Dictyostelium giganteum strain Digiganteum-PALH genome assembly, chromosome: 1	blastn	72100	617	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae symbiont of Dictyostelium giganteum
29778917	29778917	PRJNA864829_S_NODE_5051_length_263_cov_2.224299_g4965_i0	PRJNA864829	5051	263	2.224299	5.84990637	Neochlamydia	112987	Bacteria	Bacteria	144	6.64e-39	NR	WP_044881375.1	1478175	g4965	i0	93.4	8.54372623574145	76	5	86.7	0	1	228	24	99	WP_044881375.1 flagellar protein export ATPase FliI [Neochlamydia sp. EPS4]	diamond	2247	144	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. EPS4
29833972	29833972	PRJNA864829_S_NODE_11271_length_189_cov_4.964286_g11185_i0	PRJNA864829	11271	189	4.964286	9.38250054	Chlamydiota bacterium	2081524	Bacteria	Bacteria	62	2.78e-9	NR	NGX45755.1	2081524	g11185	i0	49.1	0.904761904761905	57	29	90.5	0	17	187	48	104	NGX45755.1 Tetracycline resistance protein, class C [Chlamydiota bacterium]	diamond	171	62	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31477375	31477375	PRJNA864829_S_NODE_10416_length_196_cov_1.523810_g10330_i0	PRJNA864829	10416	196	1.52381	2.9866676	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	73.9	1.39e-13	NR	MBA3958290.1	2052176	g10330	i0	60.9	0.979591836734694	64	24	96.4	1	6	194	98	161	MBA3958290.1 alpha/beta hydrolase [Parachlamydiaceae bacterium]	diamond	192	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		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);;