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

10 rows where bioproject = "PRJNA533623", 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
6883970	6883970	PRJNA533623_P_NODE_32186_length_396_cov_13.862687_g30415_i0	PRJNA533623	32186	396	13.862687	54.89624052	Parachlamydiales	1963360	Bacteria	Bacteria	103	1.15e-24	NR	WP_198408063.1	83552	g30415	i0	76.7	0.916666666666667	60	14	45.5	0	26	205	141	200	WP_198408063.1 superoxide dismutase [Parachlamydia acanthamoebae]	diamond	363	103	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
7495778	7495778	PRJNA533623_P_NODE_11846_length_683_cov_79.545016_g10225_i0	PRJNA533623	11846	683	79.545016	543.29245928	Parachlamydia	83551	Bacteria	Bacteria	726	0	NTclustered	gi\|1491674\|emb\|Y07555.1\|	83552	g10225	i0	87.023	137.93850658858	655	71	95	14	14	663	978	1623	Parachlamydia acanthamoebae genomic LSU rRNA	blastn	94212	726	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
26649395	26649395	PRJNA533623_P_NODE_45001_length_318_cov_3.972763_g43227_i0	PRJNA533623	45001	318	3.972763	12.63338634	Parachlamydiales	1963360	Bacteria	Bacteria	77.4	2.04e-14	NR	MBX9923046.1	2047756	g43227	i0	48.8	3.64150943396226	82	41	77.4	1	25	270	122	202	MBX9923046.1 methyltransferase domain-containing protein [Rhabdochlamydiaceae bacterium]	diamond	1158	77.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
27092698	27092698	PRJNA533623_P_NODE_11402_length_696_cov_223.042520_g9792_i0	PRJNA533623	11402	696	223.04252	1552.3759392	Bacteria	2	Bacteria	Bacteria	271	1.74e-85	NR	MFT4553364.1	2047757	g9792	i0	59.9	1.81896551724138	212	85	91.4	0	684	49	254	465	MFT4553364.1 DASS family divalent anion:Na+ symporter [Chlamydiales bacterium]	diamond	1266	271	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27140625	27140625	PRJNA533623_P_NODE_19742_length_526_cov_21.576344_g17998_i0	PRJNA533623	19742	526	21.576344	113.49156944	Chlamydiales bacterium	2047757	Bacteria	Bacteria	139	1.3e-36	NR	HSX27127.1	2047757	g17998	i0	62.9	1.70532319391635	97	36	55.3	0	455	165	20	116	HSX27127.1 NAD-dependent epimerase/dehydratase family protein [Chlamydiales bacterium]	diamond	897	139	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28008879	28008879	PRJNA533623_P_NODE_12605_length_663_cov_9.588040_g10949_i0	PRJNA533623	12605	663	9.58804	63.5687052	Pseudomonadati	3379134	Bacteria	Bacteria	102	9.1e-23	NR	WP_013181635.1	71667	g10949	i0	46.4	4.95927601809955	112	50	49.8	3	182	511	107	210	WP_013181635.1 bifunctional nicotinamidase/pyrazinamidase [Waddlia chondrophila]	diamond	3288	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
30425756	30425756	PRJNA533623_P_NODE_63133_length_242_cov_28.381215_g61352_i0	PRJNA533623	63133	242	28.381215	68.6825403	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	63.2	4.93e-11	NR	EPP32950.1	1112230	g61352	i0	79.5	0.483471074380165	39	8	48.3	0	226	110	12	50	EPP32950.1 hypothetical protein CP8484711_2610, partial [Chlamydia psittaci 84-8471/1]	diamond	117	63.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30457320	30457320	PRJNA533623_P_NODE_47893_length_304_cov_1.604938_g46114_i0	PRJNA533623	47893	304	1.604938	4.87901152	Waddliaceae bacterium	2026802	Bacteria	Bacteria	114	1.25e-27	NR	HEY4831584.1	2026802	g46114	i0	49	1.89473684210526	96	49	94.7	0	290	3	55	150	HEY4831584.1 MFS transporter [Waddliaceae bacterium]	diamond	576	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
31405129	31405129	PRJNA533623_P_NODE_31796_length_399_cov_13.656805_g30025_i0	PRJNA533623	31796	399	13.656805	54.49065195	Chlamydiales bacterium	2047757	Bacteria	Bacteria	94.7	1.37e-19	NR	MCP5469731.1	2047757	g30025	i0	47.8	1.30075187969925	90	42	63.9	2	3	257	713	802	MCP5469731.1 phosphoketolase family protein [Chlamydiales bacterium]	diamond	519	94.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31468447	31468447	PRJNA533623_P_NODE_55396_length_271_cov_20.104762_g53616_i0	PRJNA533623	55396	271	20.104762	54.48390502	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	124	4.65e-33	NR	HEV8052036.1	2052176	g53616	i0	88.2	1.50553505535055	68	8	75.3	0	5	208	108	175	HEV8052036.1 tRNA 2-thiocytidine biosynthesis TtcA family protein [Parachlamydiaceae bacterium]	diamond	408	124	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);;