metadata: contig_metadata: 10 rows where bioproject = "PRJNA605033", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA605033", 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
8798837	8798837	PRJNA605033_P_NODE_95407_length_222_cov_2.053476_g93838_i0	PRJNA605033	95407	222	2.053476	4.55871672	Chlamydia trachomatis	813	Bacteria	Bacteria	53.9	3.37e-6	NR	CRH62505.1	813	g93838	i0	96	0.337837837837838	25	1	33.8	0	148	222	400	424	CRH62505.1 ATP-dependent RNA helicase HrpA [Chlamydia trachomatis]	diamond	75	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
27111512	27111512	PRJNA605033_P_NODE_122522_length_221_cov_2.553763_g120953_i0	PRJNA605033	122522	221	2.553763	5.64381623	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	77	1.43e-16	NR	HEY5234598.1	2047756	g120953	i0	55.6	0.97737556561086	72	32	97.7	0	219	4	4	75	HEY5234598.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	216	77	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27522370	27522370	PRJNA605033_P_NODE_30183_length_277_cov_2.276860_g28617_i0	PRJNA605033	30183	277	2.27686	6.3069022	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	123	2.34e-33	NR	HEY5234670.1	2047756	g28617	i0	64	0.931407942238267	86	31	93.1	0	20	277	1	86	HEY5234670.1 ATP-binding protein [Rhabdochlamydiaceae bacterium]	diamond	258	123	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28419874	28419874	PRJNA605033_P_NODE_92646_length_222_cov_2.122995_g91077_i0	PRJNA605033	92646	222	2.122995	4.7130489	Candidatus Protochlamydia	282132	Bacteria	Bacteria	56.6	3.63e-7	NR	WP_039356713.1	362787	g91077	i0	95.8	2.27027027027027	24	1	32.4	0	149	220	712	735	WP_039356713.1 DNA polymerase III subunit alpha [Candidatus Protochlamydia amoebophila]	diamond	504	56.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
29935424	29935424	PRJNA605033_P_NODE_117071_length_222_cov_1.657754_g115502_i0	PRJNA605033	117071	222	1.657754	3.68021388	Bacteria	2	Bacteria	Bacteria	48.1	2.52e-4	NR	MCB1213736.1	2052156	g115502	i0	79.2	1.28378378378378	24	5	32.4	0	149	220	53	76	MCB1213736.1 acyl-ACP--UDP-N-acetylglucosamine O-acyltransferase [Chlamydiia bacterium]	diamond	285	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
30459613	30459613	PRJNA605033_P_NODE_127293_length_219_cov_4.250000_g125724_i0	PRJNA605033	127293	219	4.25	9.3075	Chlamydia psittaci	83554	Bacteria	Bacteria	79.7	5.2e-18	NR	EPP28643.1	1112246	g125724	i0	88.1	0.575342465753425	42	5	57.5	0	194	69	5	46	EPP28643.1 hypothetical protein CP082626L3_1561, partial [Chlamydia psittaci 08-2626_L3]	diamond	126	79.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
31926482	31926482	PRJNA605033_P_NODE_158397_length_187_cov_3.828947_g156828_i0	PRJNA605033	158397	187	3.828947	7.16013089	Chlamydia	810	Bacteria	Bacteria	83.2	1.94e-19	NR	EPJ31100.1	1112244	g156828	i0	100	1.2192513368984	38	0	61	0	187	74	1	38	EPJ31100.1 hypothetical protein CP061683_2291 [Chlamydia psittaci 06-1683]	diamond	228	83.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32514812	32514812	PRJNA605033_P_NODE_101359_length_222_cov_1.930481_g99790_i0	PRJNA605033	101359	222	1.930481	4.28566782	Chlamydiales bacterium	2047757	Bacteria	Bacteria	53.9	3.2e-6	NR	MCE5294938.1	2047757	g99790	i0	95.8	0.648648648648649	24	1	32.4	0	221	150	367	390	MCE5294938.1 polyribonucleotide nucleotidyltransferase [Chlamydiales bacterium]	diamond	144	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32797958	32797958	PRJNA605033_P_NODE_95760_length_222_cov_2.048128_g94191_i0	PRJNA605033	95760	222	2.048128	4.54684416	Waddlia chondrophila	71667	Bacteria	Bacteria	55.1	1.31e-7	NR	WP_013183007.1	71667	g94191	i0	46.4	0.932432432432432	69	35	93.2	1	211	5	1	67	WP_013183007.1 hypothetical protein [Waddlia chondrophila]	diamond	207	55.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
32829742	32829742	PRJNA605033_P_NODE_189300_length_170_cov_2.888889_g187731_i0	PRJNA605033	189300	170	2.888889	4.9111113	Chlamydia psittaci	83554	Bacteria	Bacteria	49.3	2.58e-6	NR	EPP29515.1	1112246	g187731	i0	72.7	1.34117647058824	33	9	58.2	0	2	100	2	34	EPP29515.1 hypothetical protein CP082626L3_1566 [Chlamydia psittaci 08-2626_L3]	diamond	228	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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