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

17 rows where bioproject = "PRJNA752278", 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
4555369	4555369	PRJNA752278_P_NODE_1104_length_1034_cov_8.442248_g948_i0	PRJNA752278	1104	1034	8.442248	87.29284432	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	375	7.850000000000001e-123	NR	WP_059059927.1	389348	g948	i0	62.2	4.93230174081238	283	100	82.1	3	1028	180	315	590	WP_059059927.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Protochlamydia naegleriophila]	diamond	5100	375	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7578865	7578865	PRJNA752278_P_NODE_4066_length_628_cov_5.495495_g3868_i0	PRJNA752278	4066	628	5.495495	34.5117086	Chlamydiales bacterium	2047757	Bacteria	Bacteria	182	1.15e-52	NR	HSX26922.1	2047757	g3868	i0	52.7	2.37898089171975	167	78	79.3	1	628	131	158	324	HSX26922.1 cysteine synthase family protein [Chlamydiales bacterium]	diamond	1494	182	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
10931189	10931189	PRJNA752278_P_NODE_28569_length_311_cov_2.449580_g28366_i0	PRJNA752278	28569	311	2.44958	7.6181938	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	311	4.34e-80	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g28366	i0	84.858	154.697749196141	317	38	100	10	1	311	655037	655349	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48111	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
15229143	15229143	PRJNA752278_P_NODE_11412_length_433_cov_2.563889_g11209_i0	PRJNA752278	11412	433	2.563889	11.10163937	Parachlamydia	83551	Bacteria	Bacteria	617	3.29e-172	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g11209	i0	92.379	112.170900692841	433	33	100	0	1	433	2111	2543	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	48570	617	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
27274060	27274060	PRJNA752278_P_NODE_101443_length_242_cov_1.011834_g101240_i0	PRJNA752278	101443	242	1.011834	2.44863828	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	107	5.7900000000000005e-27	NR	MFA6915990.1	2052178	g101240	i0	67.1	0.979338842975207	79	25	97.9	1	4	240	133	210	MFA6915990.1 DNA alkylation repair protein [Parachlamydiales bacterium]	diamond	237	107	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27463739	27463739	PRJNA752278_P_NODE_1223_length_987_cov_7.423414_g1064_i0	PRJNA752278	1223	987	7.423414	73.26909618	Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8	1797601	Bacteria	Bacteria	127	8.109999999999999e-31	NR	OGN61875.1	1797601	g1064	i0	38.5	0.583586626139818	192	101	55	5	662	120	67	252	OGN61875.1 MAG: hypothetical protein A3F40_03365 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8]	diamond	576	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_27_8
28168219	28168219	PRJNA752278_P_NODE_8605_length_481_cov_1.750000_g8402_i0	PRJNA752278	8605	481	1.75	8.4175	root	1	Root_unresolved	Root_unresolved	140	1.11e-35	NR	WP_059060745.1	389348	g8402	i0	51.8	1.64656964656965	137	62	83	1	481	83	393	529	WP_059060745.1 ADP-ribosylhydrolase MavL family protein [Candidatus Protochlamydia naegleriophila]	diamond	792	140	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
29421014	29421014	PRJNA752278_P_NODE_40449_length_286_cov_1.995305_g40246_i0	PRJNA752278	40449	286	1.995305	5.7065723	Chlamydiales bacterium	2047757	Bacteria	Bacteria	110	3.62e-29	NR	HSX13502.1	2047757	g40246	i0	61.5	2.75874125874126	78	28	81.8	1	240	7	11	86	HSX13502.1 2OG-Fe(II) oxygenase [Chlamydiales bacterium]	diamond	789	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29894973	29894973	PRJNA752278_P_NODE_55171_length_272_cov_1.859296_g54968_i0	PRJNA752278	55171	272	1.859296	5.05728512	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	78.2	1.54e-14	NR	WP_059061921.1	389348	g54968	i0	84.1	0.485294117647059	44	7	48.5	0	52	183	1	44	WP_059061921.1 purple acid phosphatase family protein [Candidatus Protochlamydia naegleriophila]	diamond	132	78.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
30495256	30495256	PRJNA752278_P_NODE_14813_length_395_cov_1.239130_g14610_i0	PRJNA752278	14813	395	1.23913	4.8945635	Parachlamydia sp.	2052048	Bacteria	Bacteria	52	1.17e-4	NR	MCE5316532.1	2052048	g14610	i0	36.8	0.660759493670886	87	52	66.1	2	32	292	377	460	MCE5316532.1 tetratricopeptide repeat protein [Parachlamydia sp.]	diamond	261	52	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
30495281	30495281	PRJNA752278_P_NODE_42913_length_284_cov_1.322275_g42710_i0	PRJNA752278	42913	284	1.322275	3.755261	Chlamydiales bacterium	2047757	Bacteria	Bacteria	137	6.03e-39	NR	MDP1835510.1	2047757	g42710	i0	62.8	3.97183098591549	94	35	99.3	0	282	1	63	156	MDP1835510.1 transposase [Chlamydiales bacterium]	diamond	1128	137	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31221632	31221632	PRJNA752278_P_NODE_42475_length_284_cov_1.966825_g42272_i0	PRJNA752278	42475	284	1.966825	5.585783	Chlamydiota bacterium	2081524	Bacteria	Bacteria	63.5	1.13e-10	NR	MBI1883479.1	2081524	g42272	i0	40	1.58450704225352	75	41	79.2	2	29	253	29	99	MBI1883479.1 hypothetical protein [Chlamydiota bacterium]	diamond	450	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31316741	31316741	PRJNA752278_P_NODE_21835_length_345_cov_1.106618_g21632_i0	PRJNA752278	21835	345	1.106618	3.8178321	Chlamydiota bacterium	2081524	Bacteria	Bacteria	58.2	4.67e-7	NR	NGX61847.1	2081524	g21632	i0	35.5	2.58260869565217	76	49	66.1	0	20	247	520	595	NGX61847.1 Acyl-homoserine lactone acylase QuiP [Chlamydiota bacterium]	diamond	891	58.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
31411719	31411719	PRJNA752278_P_NODE_7616_length_502_cov_1.086247_g7413_i0	PRJNA752278	7616	502	1.086247	5.45295994	Chlamydiota bacterium	2081524	Bacteria	Bacteria	198	8.82e-60	NR	NGX47840.1	2081524	g7413	i0	58.1	0.926294820717131	155	65	92.6	0	1	465	152	306	NGX47840.1 GDP-L-fucose synthase [Chlamydiota bacterium]	diamond	465	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32171130	32171130	PRJNA752278_P_NODE_91418_length_246_cov_0.890173_g91215_i0	PRJNA752278	91418	246	0.890173	2.18982558	Chlamydiales bacterium	2047757	Bacteria	Bacteria	72.4	3.3e-13	NR	MCE5293304.1	2047757	g91215	i0	80.5	0.5	41	8	50	0	123	245	154	194	MCE5293304.1 hypothetical protein [Chlamydiales bacterium]	diamond	123	72.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32455846	32455846	PRJNA752278_P_NODE_3599_length_656_cov_3.708405_g3402_i0	PRJNA752278	3599	656	3.708405	24.3271368	Simkania sp.	34094	Bacteria	Bacteria	205	1.46e-62	NR	MCB1084310.1	34094	g3402	i0	53.4	0.864329268292683	189	88	86.4	0	656	90	5	193	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	567	205	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32802474	32802474	PRJNA752278_P_NODE_98540_length_243_cov_1.476471_g98337_i0	PRJNA752278	98540	243	1.476471	3.58782453	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	101	7.879999999999999e-23	NR	WP_068469007.1	1414722	g98337	i0	66.7	1.72839506172839	69	23	85.2	0	241	35	466	534	WP_068469007.1 ADP-ribosylhydrolase MavL family protein [Candidatus Protochlamydia phocaeensis]	diamond	420	101	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis

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