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

18 rows where bioproject = "PRJNA1111077", 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
5317359	5317359	PRJNA1111077_P_NODE_15745_length_310_cov_2.755274_g15524_i0	PRJNA1111077	15745	310	2.755274	8.5413494	Pseudomonadati	3379134	Bacteria	Bacteria	189	3.1299999999999997e-56	NR	WP_256439911.1	292833	g15524	i0	92.2	34.5290322580645	102	5	98.7	1	308	3	278	376	WP_256439911.1 MULTISPECIES: transcription termination factor Rho [Candidatus Rhabdochlamydia]	diamond	10704	189	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia
27194074	27194074	PRJNA1111077_P_NODE_25922_length_266_cov_2.756477_g25701_i0	PRJNA1111077	25922	266	2.756477	7.33222882	Candidatus Protochlamydia sp. W-9	1785087	Bacteria	Bacteria	65.5	4.85e-10	NR	WP_075883060.1	1785087	g25701	i0	78.9	0.857142857142857	38	8	42.9	0	99	212	1	38	WP_075883060.1 excinuclease ABC subunit UvrC [Candidatus Protochlamydia sp. W-9]	diamond	228	65.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia sp. W-9
27857391	27857391	PRJNA1111077_P_NODE_24705_length_271_cov_1.494949_g24484_i0	PRJNA1111077	24705	271	1.494949	4.05131179	Chlamydiales bacterium	2047757	Bacteria	Bacteria	126	2.37e-33	NR	MCC5831931.1	2047757	g24484	i0	69.7	1.97047970479705	89	27	98.5	0	269	3	40	128	MCC5831931.1 DMT family transporter [Chlamydiales bacterium]	diamond	534	126	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28931043	28931043	PRJNA1111077_P_NODE_21968_length_280_cov_2.048309_g21747_i0	PRJNA1111077	21968	280	2.048309	5.7352652	Chlamydiota bacterium	2081524	Bacteria	Bacteria	68.2	4.43e-11	NR	MEM1282983.1	2081524	g21747	i0	44.7	1.81071428571429	76	34	72.9	2	1	204	203	278	MEM1282983.1 glycosyltransferase family 92 protein [Chlamydiota bacterium]	diamond	507	68.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29120641	29120641	PRJNA1111077_P_NODE_21109_length_283_cov_1.728571_g20888_i0	PRJNA1111077	21109	283	1.728571	4.89185593	Parachlamydia sp.	2052048	Bacteria	Bacteria	174	1.5e-52	NR	MCE5318033.1	2052048	g20888	i0	96.8	0.996466431095406	94	3	99.6	0	282	1	136	229	MCE5318033.1 segregation/condensation protein A [Parachlamydia sp.]	diamond	282	174	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
29341522	29341522	PRJNA1111077_P_NODE_27069_length_262_cov_2.640212_g26848_i0	PRJNA1111077	27069	262	2.640212	6.91735544	Chlamydiota bacterium	2081524	Bacteria	Bacteria	154	3.580000000000001e-44	NR	NGX55651.1	2081524	g26848	i0	86.2	0.99618320610687	87	12	99.6	0	2	262	203	289	NGX55651.1 Acetyl-coenzyme A carboxylase carboxyl transferase subunit beta [Chlamydiota bacterium]	diamond	261	154	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29404626	29404626	PRJNA1111077_P_NODE_35909_length_242_cov_0.911243_g35688_i0	PRJNA1111077	35909	242	0.911243	2.20520806	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	57.8	1.64e-7	NR	HEY5235279.1	2047756	g35688	i0	39	3.80578512396694	77	41	95.5	3	10	240	9	79	HEY5235279.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	921	57.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30225686	30225686	PRJNA1111077_P_NODE_18912_length_290_cov_1.981567_g18691_i0	PRJNA1111077	18912	290	1.981567	5.7465443	Chlamydiales bacterium	2047757	Bacteria	Bacteria	167	4.92e-49	NR	MDP1834418.1	2047757	g18691	i0	78.1	0.993103448275862	96	21	99.3	0	288	1	114	209	MDP1834418.1 aldo/keto reductase [Chlamydiales bacterium]	diamond	288	167	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30352666	30352666	PRJNA1111077_P_NODE_20912_length_284_cov_1.241706_g20691_i0	PRJNA1111077	20912	284	1.241706	3.52644504	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	49.7	2.1e-4	NR	MBP7075398.1	2047756	g20691	i0	53.8	0.411971830985915	39	18	41.2	0	284	168	358	396	MBP7075398.1 transposase [Rhabdochlamydiaceae bacterium]	diamond	117	49.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30889288	30889288	PRJNA1111077_P_NODE_18094_length_294_cov_6.230769_g17873_i0	PRJNA1111077	18094	294	6.230769	18.31846086	Chlamydiales bacterium	2047757	Bacteria	Bacteria	70.5	1.06e-11	NR	MCH9625342.1	2047757	g17873	i0	60.4	2.38775510204082	48	19	49	0	6	149	36	83	MCH9625342.1 Methionine aminopeptidase 1, mitochondrial [Chlamydiales bacterium]	diamond	702	70.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30952619	30952619	PRJNA1111077_P_NODE_20374_length_285_cov_4.306604_g20153_i0	PRJNA1111077	20374	285	4.306604	12.2738214	Parachlamydia sp.	2052048	Bacteria	Bacteria	178	4.739999999999999e-52	NR	MCE5318365.1	2052048	g20153	i0	93.6	0.989473684210526	94	6	98.9	0	284	3	159	252	MCE5318365.1 sodium:proton antiporter NhaD [Parachlamydia sp.]	diamond	282	178	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
31070252	31070252	PRJNA1111077_P_NODE_21175_length_283_cov_1.404762_g20954_i0	PRJNA1111077	21175	283	1.404762	3.97547646	Chlamydiia	204429	Bacteria	Bacteria	72.4	4.07e-14	NR	WP_006341453.1	83552	g20954	i0	63.5	3.77385159010601	52	18	54.1	1	1	153	50	101	WP_006341453.1 YbaB/EbfC family nucleoid-associated protein [Parachlamydia acanthamoebae]	diamond	1068	72.8	0.994505494505495	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
31458365	31458365	PRJNA1111077_P_NODE_14436_length_311_cov_4.588235_g14215_i0	PRJNA1111077	14436	311	4.588235	14.26941085	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	82.8	6.68e-16	NR	MBA3238056.1	2052176	g14215	i0	50	0.887459807073955	92	42	85.9	2	38	304	296	386	MBA3238056.1 DUF687 family protein [Parachlamydiaceae bacterium]	diamond	276	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31806167	31806167	PRJNA1111077_P_NODE_30677_length_250_cov_1.451977_g30456_i0	PRJNA1111077	30677	250	1.451977	3.6299425	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	60.5	3.47e-10	NR	HEV8051416.1	2052176	g30456	i0	52.3	1.044	44	21	52.8	0	185	54	1	44	HEV8051416.1 cbb3-type cytochrome oxidase assembly protein CcoS [Parachlamydiaceae bacterium]	diamond	261	60.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
31932625	31932625	PRJNA1111077_P_NODE_38477_length_199_cov_4.079365_g38256_i0	PRJNA1111077	38477	199	4.079365	8.11793635	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	114	1.33e-27	NR	WP_059060529.1	389348	g38256	i0	84.8	0.994974874371859	66	10	99.5	0	199	2	1102	1167	WP_059060529.1 translocation/assembly module TamB domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	198	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32217534	32217534	PRJNA1111077_P_NODE_35058_length_243_cov_5.305882_g34837_i0	PRJNA1111077	35058	243	5.305882	12.89329326	Chlamydiales bacterium	2047757	Bacteria	Bacteria	89.7	9.88e-19	NR	MCH9625135.1	2047757	g34837	i0	55.7	3.75308641975309	79	33	97.5	1	6	242	254	330	MCH9625135.1 hypothetical protein [Chlamydiales bacterium]	diamond	912	89.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32280969	32280969	PRJNA1111077_P_NODE_14819_length_310_cov_4.805907_g14598_i0	PRJNA1111077	14819	310	4.805907	14.8983117	Chlamydiia bacterium	2052156	Bacteria	Bacteria	78.6	9.91e-15	NR	MCB1181420.1	2052156	g14598	i0	72	0.483870967741935	50	14	48.4	0	150	1	21	70	MCB1181420.1 rhodanese-related sulfurtransferase [Chlamydiia bacterium]	diamond	150	78.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32375789	32375789	PRJNA1111077_P_NODE_18619_length_291_cov_6.000000_g18398_i0	PRJNA1111077	18619	291	6	17.46	Simkania negevensis	83561	Bacteria	Bacteria	87	1.86e-17	NR	MBN4066828.1	83561	g18398	i0	50	1.88659793814433	90	43	90.7	1	27	290	2196	2285	MBN4066828.1 DUF3638 domain-containing protein [Simkania negevensis]	diamond	549	87	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis

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