metadata: contig_metadata: 18 rows where bioproject = "PRJNA1067370", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA1067370", 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
5283422	5283422	PRJNA1067370_P_NODE_114085_length_241_cov_0.916667_g113536_i0	PRJNA1067370	114085	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	126	8.04e-34	NR	MCB1109125.1	2052156	g113536	i0	75	1.99170124481328	80	20	99.6	0	240	1	36	115	MCB1109125.1 SDR family NAD(P)-dependent oxidoreductase [Chlamydiia bacterium]	diamond	480	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
11216713	11216713	PRJNA1067370_P_NODE_73049_length_260_cov_1.363636_g72500_i0	PRJNA1067370	73049	260	1.363636	3.5454536	Chlamydiales bacterium	2047757	Bacteria	Bacteria	135	1.75e-38	NR	MCP5470421.1	2047757	g72500	i0	75.3	0.980769230769231	85	21	98.1	0	255	1	1	85	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	255	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
15483341	15483341	PRJNA1067370_P_NODE_11113_length_547_cov_1.837553_g10571_i0	PRJNA1067370	11113	547	1.837553	10.05141491	Parachlamydia sp. AcF125	2795736	Bacteria	Bacteria	175	1.5599999999999994e-48	NR	WP_213157060.1	2795736	g10571	i0	55.3	2.85191956124314	179	78	97.1	1	531	1	348	526	WP_213157060.1 Gfo/Idh/MocA family oxidoreductase [Parachlamydia sp. AcF125]	diamond	1560	175	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp. AcF125
21857508	21857508	PRJNA1067370_P_NODE_17538_length_445_cov_1.545699_g16990_i0	PRJNA1067370	17538	445	1.545699	6.87836055	Waddliaceae bacterium	2026802	Bacteria	Bacteria	230	2.86e-71	NR	MBT6928840.1	2026802	g16990	i0	74.3	2.99325842696629	148	38	99.8	0	2	445	147	294	MBT6928840.1 adenosylhomocysteinase [Waddliaceae bacterium]	diamond	1332	230	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
27888310	27888310	PRJNA1067370_P_NODE_111085_length_242_cov_0.911243_g110536_i0	PRJNA1067370	111085	242	0.911243	2.20520806	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	55.5	1.02e-6	NR	NGX34602.1	2705072	g110536	i0	36.3	2.97520661157025	80	42	95.5	3	2	232	6	79	NGX34602.1 hypothetical protein [Candidatus Anoxychlamydiales bacterium]	diamond	720	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
28164375	28164375	PRJNA1067370_P_NODE_70545_length_264_cov_1.041885_g69996_i0	PRJNA1067370	70545	264	1.041885	2.7505764	root	1	Root_unresolved	Root_unresolved	140	3.62e-38	NR	MBN4066512.1	83561	g69996	i0	74.4	5.89772727272727	86	22	97.7	0	259	2	221	306	MBN4066512.1 S-methyl-5-thioribose-1-phosphate isomerase [Simkania negevensis]	diamond	1557	140	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
28235575	28235575	PRJNA1067370_P_NODE_94086_length_247_cov_0.885057_g93537_i0	PRJNA1067370	94086	247	0.885057	2.18609079	Parachlamydia sp.	2052048	Bacteria	Bacteria	42.7	0.0369	NR	MCE2983737.1	2052048	g93537	i0	36.2	0.704453441295547	58	35	70.4	1	245	72	293	348	MCE2983737.1 DUF559 domain-containing protein [Parachlamydia sp.]	diamond	174	42.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
28298793	28298793	PRJNA1067370_P_NODE_107726_length_243_cov_0.905882_g107177_i0	PRJNA1067370	107726	243	0.905882	2.20129326	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	53.1	8.34e-6	NR	MFA6914796.1	2052178	g107177	i0	44.4	0.666666666666667	54	25	66.7	1	162	1	1086	1134	MFA6914796.1 BTB/POZ domain-containing protein [Parachlamydiales bacterium]	diamond	162	53.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
28741001	28741001	PRJNA1067370_P_NODE_75827_length_256_cov_1.300546_g75278_i0	PRJNA1067370	75827	256	1.300546	3.32939776	Chlamydiales bacterium	2047757	Bacteria	Bacteria	94.7	2.11e-20	NR	HSX10467.1	2047757	g75278	i0	81.8	0.64453125	55	10	64.5	0	90	254	1	55	HSX10467.1 pyruvate kinase [Chlamydiales bacterium]	diamond	165	94.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29656201	29656201	PRJNA1067370_P_NODE_48550_length_300_cov_0.973568_g48002_i0	PRJNA1067370	48550	300	0.973568	2.920704	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	94.7	1.03e-21	NR	WP_198408063.1	83552	g48002	i0	70.2	1.12	57	17	57	0	300	130	146	202	WP_198408063.1 superoxide dismutase [Parachlamydia acanthamoebae]	diamond	336	94.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
29909326	29909326	PRJNA1067370_P_NODE_101631_length_245_cov_0.895349_g101082_i0	PRJNA1067370	101631	245	0.895349	2.19360505	Chlamydiia bacterium	2052156	Bacteria	Bacteria	61.2	3.88e-9	NR	MCB1114783.1	2052156	g101082	i0	89.7	0.355102040816327	29	3	35.5	0	158	244	6	34	MCB1114783.1 superoxide dismutase [Chlamydiia bacterium]	diamond	87	61.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30635690	30635690	PRJNA1067370_P_NODE_118033_length_218_cov_3.744828_g117484_i0	PRJNA1067370	118033	218	3.744828	8.16372504	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	146	9.81e-39	NR	MBA2728321.1	2052176	g117484	i0	90.1	1.96788990825688	71	7	97.7	0	214	2	31	101	MBA2728321.1 DNA ligase D [Parachlamydiaceae bacterium]	diamond	429	146	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30920476	30920476	PRJNA1067370_P_NODE_22974_length_396_cov_2.380805_g22426_i0	PRJNA1067370	22974	396	2.380805	9.4279878	Chlamydiales bacterium	2047757	Bacteria	Bacteria	160	1.3599999999999999e-47	NR	MCP5470420.1	2047757	g22426	i0	63.6	0.977272727272727	129	47	97.7	0	394	8	2	130	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	387	160	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30983648	30983648	PRJNA1067370_P_NODE_47254_length_303_cov_1.391304_g46706_i0	PRJNA1067370	47254	303	1.391304	4.21565112	Candidatus Protochlamydia sp.	2687294	Bacteria	Bacteria	83.6	3.23e-16	NR	MBA2369415.1	2687294	g46706	i0	48.5	1.9009900990099	97	49	95	1	289	2	111	207	MBA2369415.1 DUF4804 domain-containing protein [Candidatus Protochlamydia sp.]	diamond	576	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp.
31837086	31837086	PRJNA1067370_P_NODE_7737_length_645_cov_8.858392_g7212_i0	PRJNA1067370	7737	645	8.858392	57.1366284	Chlamydiales bacterium	2047757	Bacteria	Bacteria	199	2.03e-61	NR	MCP5470421.1	2047757	g7212	i0	66.5	1.46046511627907	158	48	72.1	2	622	158	1	156	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	942	199	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31932023	31932023	PRJNA1067370_P_NODE_44097_length_310_cov_2.645570_g43549_i0	PRJNA1067370	44097	310	2.64557	8.201267	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	48.5	7.47e-4	NR	HEV8052666.1	2052176	g43549	i0	33.9	0.570967741935484	59	39	57.1	0	197	21	197	255	HEV8052666.1 DDE-type integrase/transposase/recombinase [Parachlamydiaceae bacterium]	diamond	177	48.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32565331	32565331	PRJNA1067370_P_NODE_92379_length_247_cov_1.586207_g91830_i0	PRJNA1067370	92379	247	1.586207	3.91793129	Neochlamydia sp. AcF84	2315858	Bacteria	Bacteria	51.2	1.23e-5	NR	WP_347566619.1	2315858	g91830	i0	30.2	2.08906882591093	86	54	98.4	3	3	245	18	102	WP_347566619.1 F-box protein [Neochlamydia sp. AcF84]	diamond	516	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. AcF84
32848245	32848245	PRJNA1067370_P_NODE_116300_length_236_cov_2.073620_g115751_i0	PRJNA1067370	116300	236	2.07362	4.8937432	Chlamydiota bacterium	2081524	Bacteria	Bacteria	56.2	5.83e-7	NR	MES2273423.1	2081524	g115751	i0	45.3	2.09745762711864	53	29	67.4	0	57	215	2	54	MES2273423.1 asparagine--tRNA ligase [Chlamydiota bacterium]	diamond	495	56.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;