metadata: contig_metadata: 12 rows where bioproject = "PRJNA399711", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA399711", 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
27928259	27928259	PRJNA399711_P_NODE_18465_length_167_cov_3.915385_g18399_i0	PRJNA399711	18465	167	3.915385	6.53869295	Candidatus Protochlamydia phocaeensis	1414722	Bacteria	Bacteria	79.3	1.67e-15	NR	WP_068471286.1	1414722	g18399	i0	48.9	1.65269461077844	92	7	93.4	1	12	167	427	518	WP_068471286.1 protein-disulfide reductase DsbD family protein [Candidatus Protochlamydia phocaeensis]	diamond	276	79.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia phocaeensis
28023072	28023072	PRJNA399711_P_NODE_23945_length_150_cov_1.699115_g23879_i0	PRJNA399711	23945	150	1.699115	2.5486725	Simkania negevensis	83561	Bacteria	Bacteria	63.5	4.6e-10	NR	WP_013943569.1	83561	g23879	i0	63.8	0.94	47	17	94	0	8	148	101	147	WP_013943569.1 Npt1/Npt2 family nucleotide transporter [Simkania negevensis]	diamond	141	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
28970227	28970227	PRJNA399711_P_NODE_3928_length_257_cov_3.127273_g3862_i0	PRJNA399711	3928	257	3.127273	8.03709161	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	61.2	3.36e-9	NR	NGX35633.1	2705072	g3862	i0	39.5	0.88715953307393	76	45	87.5	1	4	228	105	180	NGX35633.1 hypothetical protein [Candidatus Anoxychlamydiales bacterium]	diamond	228	61.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
29428708	29428708	PRJNA399711_P_NODE_16709_length_171_cov_3.186567_g16643_i0	PRJNA399711	16709	171	3.186567	5.44902957	Chlamydia	810	Bacteria	Bacteria	42	0.0278	NR	WP_011458476.1	83556	g16643	i0	69.2	3.57894736842105	26	8	45.6	0	1	78	857	882	WP_011458476.1 DNA polymerase III subunit alpha [Chlamydia felis]	diamond	612	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia felis
30060377	30060377	PRJNA399711_P_NODE_20751_length_158_cov_7.264463_g20685_i0	PRJNA399711	20751	158	7.264463	11.47785154	Bacteria	2	Bacteria	Bacteria	42	0.00527	NR	WP_044881606.1	1478175	g20685	i0	58.1	4.12025316455696	31	13	58.9	0	154	62	6	36	WP_044881606.1 SWIB/MDM2 domain-containing protein [Neochlamydia sp. EPS4]	diamond	651	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. EPS4
30833690	30833690	PRJNA399711_P_NODE_12294_length_185_cov_1.891892_g12228_i0	PRJNA399711	12294	185	1.891892	3.5000002	Chlamydiota bacterium	2081524	Bacteria	Bacteria	75.1	6.72e-14	NR	NGX41964.1	2081524	g12228	i0	61.5	3.37297297297297	52	20	84.3	0	184	29	908	959	NGX41964.1 hypothetical protein [Chlamydiota bacterium]	diamond	624	75.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30897077	30897077	PRJNA399711_P_NODE_10134_length_196_cov_1.836478_g10068_i0	PRJNA399711	10134	196	1.836478	3.59949688	Simkania negevensis	83561	Bacteria	Bacteria	60.5	1.29e-9	NR	WP_013944335.1	83561	g10068	i0	52.8	1.77551020408163	53	25	81.1	0	162	4	63	115	WP_013944335.1 type III secretion system chaperone [Simkania negevensis]	diamond	348	60.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
32225231	32225231	PRJNA399711_P_NODE_958_length_369_cov_4.295181_g898_i0	PRJNA399711	958	369	4.295181	15.84921789	Chlamydiota bacterium	2081524	Bacteria	Bacteria	91.3	2.03e-19	NR	MEM7174647.1	2081524	g898	i0	53.5	0.699186991869919	86	35	69.9	2	104	361	49	129	MEM7174647.1 alpha/beta fold hydrolase [Chlamydiota bacterium]	diamond	258	91.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32383340	32383340	PRJNA399711_P_NODE_8759_length_204_cov_4.245509_g8693_i0	PRJNA399711	8759	204	4.245509	8.66083836	Simkania negevensis	83561	Bacteria	Bacteria	57.4	3.04e-8	NR	MBI3211163.1	83561	g8693	i0	44.9	1.14705882352941	78	28	92.6	1	200	12	67	144	MBI3211163.1 SsrA-binding protein SmpB [Simkania negevensis]	diamond	234	57.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
33003279	33003279	PRJNA399711_S_NODE_62091_length_184_cov_2.965986_g61949_i0	PRJNA399711	62091	184	2.965986	5.45741424	Chlamydia trachomatis	813	Bacteria	Bacteria	55.1	7.3e-7	NR	CRH85172.1	813	g61949	i0	47.5	0.96195652173913	59	31	96.2	0	3	179	111	169	CRH85172.1 Uncharacterized protein conserved in bacteria [Chlamydia trachomatis]	diamond	177	55.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
33139900	33139900	PRJNA399711_S_NODE_91863_length_160_cov_0.943089_g91721_i0	PRJNA399711	91863	160	0.943089	1.5089424	Chlamydiia bacterium	2052156	Bacteria	Bacteria	47.4	2.69e-4	NR	MCB1181375.1	2052156	g91721	i0	69	1.0875	29	9	54.4	0	2	88	246	274	MCB1181375.1 hypothetical protein [Chlamydiia bacterium]	diamond	174	47.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
33173995	33173995	PRJNA399711_S_NODE_67152_length_179_cov_1.830986_g67010_i0	PRJNA399711	67152	179	1.830986	3.27746494	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	89	4.6800000000000005e-21	NR	HEV8051528.1	2052176	g67010	i0	92.2	0.854748603351955	51	4	85.5	0	177	25	58	108	HEV8051528.1 HU family DNA-binding protein [Parachlamydiaceae bacterium]	diamond	153	89	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);;