metadata: contig_metadata: 17 rows where bioproject = "PRJNA666695", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA666695", 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
1162966	1162966	PRJNA666695_S_NODE_4001_length_801_cov_2.965789_g3281_i0	PRJNA666695	4001	801	2.965789	23.75596989	Chlamydiales bacterium	2047757	Bacteria	Bacteria	335	2.62e-108	NR	MFT4552105.1	2047757	g3281	i0	69.3	2.68164794007491	238	73	89.1	0	801	88	361	598	MFT4552105.1 oligoendopeptidase F [Chlamydiales bacterium]	diamond	2148	335	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
3184276	3184276	PRJNA666695_S_NODE_83243_length_239_cov_1.161616_g82149_i0	PRJNA666695	83243	239	1.161616	2.77626224	Candidatus Protochlamydia sp.	2687294	Bacteria	Bacteria	54.3	2.95e-6	NR	MBA2368492.1	2687294	g82149	i0	30.6	0.903765690376569	72	50	90.4	0	22	237	338	409	MBA2368492.1 hypothetical protein [Candidatus Protochlamydia sp.]	diamond	216	54.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp.
7009118	7009118	PRJNA666695_S_NODE_130066_length_192_cov_2.470199_g128972_i0	PRJNA666695	130066	192	2.470199	4.74278208	Chlamydiia bacterium	2052156	Bacteria	Bacteria	72	9.23e-13	NR	MCB1117454.1	2052156	g128972	i0	67.3	12.96875	55	17	84.4	1	192	31	707	761	MCB1117454.1 endopeptidase La [Chlamydiia bacterium]	diamond	2490	72	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
9560896	9560896	PRJNA666695_S_NODE_42228_length_313_cov_4.415441_g41134_i0	PRJNA666695	42228	313	4.415441	13.820330330000001	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	73.6	2e-13	NR	WP_011174820.1	362787	g41134	i0	69.8	2.08945686900958	43	13	41.2	0	1	129	164	206	WP_011174820.1 Fe-Mn family superoxide dismutase [Candidatus Protochlamydia amoebophila]	diamond	654	73.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
10835793	10835793	PRJNA666695_S_NODE_1889_length_1098_cov_40.281930_g1392_i0	PRJNA666695	1889	1098	40.28193	442.2955914	Chlamydiota bacterium	2081524	Bacteria	Bacteria	220	1.84e-62	NR	MEC7839708.1	2081524	g1392	i0	56.2	0.486338797814208	178	75	48.1	2	1090	563	427	603	MEC7839708.1 phosphoenolpyruvate carboxykinase (GTP) [Chlamydiota bacterium]	diamond	534	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
22839873	22839873	PRJNA666695_S_NODE_117718_length_202_cov_11.105590_g116624_i0	PRJNA666695	117718	202	11.10559	22.4332918	Parachlamydia sp.	2052048	Bacteria	Bacteria	117	2.27e-31	NR	MCE2983688.1	2052048	g116624	i0	80	2.8960396039604	65	13	96.5	0	6	200	84	148	MCE2983688.1 M3 family metallopeptidase [Parachlamydia sp.]	diamond	585	117	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
27112924	27112924	PRJNA666695_S_NODE_120122_length_200_cov_3.471698_g119028_i0	PRJNA666695	120122	200	3.471698	6.943396	Chlamydiia bacterium	2052156	Bacteria	Bacteria	55.8	3.68e-7	NR	MCH9617826.1	2052156	g119028	i0	48.2	1.62	56	28	82.5	1	3	167	200	255	MCH9617826.1 hypothetical protein [Chlamydiia bacterium]	diamond	324	55.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
28439702	28439702	PRJNA666695_S_NODE_69626_length_257_cov_3.064815_g68532_i0	PRJNA666695	69626	257	3.064815	7.87657455	Chlamydiales bacterium	2047757	Bacteria	Bacteria	89.7	1.28e-18	NR	MCP5506519.1	2047757	g68532	i0	57.7	3.31517509727626	71	29	81.7	1	7	216	554	624	MCP5506519.1 S9 family peptidase [Chlamydiales bacterium]	diamond	852	89.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28439705	28439705	PRJNA666695_S_NODE_72906_length_252_cov_3.355450_g71812_i0	PRJNA666695	72906	252	3.35545	8.455734	Candidatus Amphrikana amoebophyrae	3076870	Bacteria	Bacteria	78.2	1.24e-14	NR	MDN3504120.1	3076870	g71812	i0	44	1	84	44	96.4	2	2	244	354	437	MDN3504120.1 sugar porter family MFS transporter [Candidatus Amphrikana amoebophyrae]	diamond	252	78.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Amphrikana	Candidatus Amphrikana amoebophyrae
28755297	28755297	PRJNA666695_S_NODE_36147_length_332_cov_6.731959_g35053_i0	PRJNA666695	36147	332	6.731959	22.35010388	Parachlamydia sp.	2052048	Bacteria	Bacteria	93.6	1.01e-19	NR	MCE5319049.1	2052048	g35053	i0	49	1.83433734939759	102	48	91.3	2	5	307	202	300	MCE5319049.1 hypothetical protein [Parachlamydia sp.]	diamond	609	93.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
28786705	28786705	PRJNA666695_S_NODE_89087_length_231_cov_5.342105_g87993_i0	PRJNA666695	89087	231	5.342105	12.34026255	Chlamydiales bacterium	2047757	Bacteria	Bacteria	62	4.2e-9	NR	HLB53444.1	2047757	g87993	i0	49.1	1.42857142857143	55	28	71.4	0	175	11	111	165	HLB53444.1 translation initiation factor IF-2 [Chlamydiales bacterium]	diamond	330	62	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29733859	29733859	PRJNA666695_S_NODE_92610_length_228_cov_1.358289_g91516_i0	PRJNA666695	92610	228	1.358289	3.09689892	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	61.6	2.39e-9	NR	MBX9922505.1	2047756	g91516	i0	51.6	0.842105263157895	64	28	84.2	3	32	223	116	176	MBX9922505.1 CHAP domain-containing protein [Rhabdochlamydiaceae bacterium]	diamond	192	61.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29777619	29777619	PRJNA666695_S_NODE_51111_length_291_cov_2.704000_g50017_i0	PRJNA666695	51111	291	2.704	7.86864	Bacteria	2	Bacteria	Bacteria	119	4.57e-29	NR	MFT4552105.1	2047757	g50017	i0	61.3	2.93814432989691	93	36	95.9	0	281	3	191	283	MFT4552105.1 oligoendopeptidase F [Chlamydiales bacterium]	diamond	855	119	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29840905	29840905	PRJNA666695_S_NODE_102271_length_217_cov_2.670455_g101177_i0	PRJNA666695	102271	217	2.670455	5.79488735	PVC group	1783257	Bacteria	Bacteria	55.1	1.2e-6	NR	HAZ15216.1	2052178	g101177	i0	44.4	4.75576036866359	63	34	85.7	1	11	196	489	551	HAZ15216.1 hypothetical protein [Parachlamydiales bacterium]	diamond	1032	55.5	0.992792792792793	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
31535506	31535506	PRJNA666695_S_NODE_56316_length_280_cov_3.000000_g55222_i0	PRJNA666695	56316	280	3	8.4	Chlamydiales bacterium	2047757	Bacteria	Bacteria	43.5	0.0312	NR	MFN0065266.1	2047757	g55222	i0	32.4	0.760714285714286	71	46	75	2	37	246	160	229	MFN0065266.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Chlamydiales bacterium]	diamond	213	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32326587	32326587	PRJNA666695_S_NODE_58239_length_276_cov_4.340426_g57145_i0	PRJNA666695	58239	276	4.340426	11.97957576	Chlamydiia bacterium	2052156	Bacteria	Bacteria	112	1.51e-26	NR	MCB1135442.1	2052156	g57145	i0	58.2	1.97826086956522	91	38	98.9	0	2	274	232	322	MCB1135442.1 oligoendopeptidase F [Chlamydiia bacterium]	diamond	546	112	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32610710	32610710	PRJNA666695_S_NODE_25180_length_380_cov_5.669617_g24087_i0	PRJNA666695	25180	380	5.669617	21.5445446	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	128	5.39e-32	NR	MBX7066963.1	2052178	g24087	i0	58.6	0.876315789473684	111	43	86.1	2	2	328	410	519	MBX7066963.1 hypothetical protein [Parachlamydiales bacterium]	diamond	333	128	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales 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);;