metadata: contig_metadata: 8 rows where bioproject = "PRJNA414225", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA414225", 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
27581007	27581007	PRJNA414225_P_NODE_86824_length_162_cov_0.902655_g86737_i0	PRJNA414225	86824	162	0.902655	1.4623011	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	79.7	4.22e-16	NR	MFA6915034.1	2052178	g86737	i0	64.8	4	54	19	100	0	1	162	149	202	MFA6915034.1 hypothetical protein [Parachlamydiales bacterium]	diamond	648	79.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
29664601	29664601	PRJNA414225_P_NODE_58370_length_166_cov_0.871795_g58283_i0	PRJNA414225	58370	166	0.871795	1.4471797	Chlamydiales bacterium	2047757	Bacteria	Bacteria	79.7	9.76e-16	NR	MBN9378595.1	2047757	g58283	i0	76.4	0.993975903614458	55	13	99.4	0	165	1	307	361	MBN9378595.1 aspartate/tyrosine/aromatic aminotransferase [Chlamydiales bacterium]	diamond	165	79.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30233532	30233532	PRJNA414225_P_NODE_46692_length_167_cov_1.728814_g46605_i0	PRJNA414225	46692	167	1.728814	2.88711938	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	122	1.49e-33	NR	QLH37654.1	2052176	g46605	i0	100	0.988023952095808	55	0	98.8	0	3	167	93	147	QLH37654.1 MAG: 50S ribosomal protein L5 [Parachlamydiaceae bacterium]	diamond	165	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
30724067	30724067	PRJNA414225_P_NODE_80854_length_163_cov_0.894737_g80767_i0	PRJNA414225	80854	163	0.894737	1.45842131	PVC group	1783257	Bacteria	Bacteria	49.3	5.71e-5	NR	CRH92729.1	813	g80767	i0	50	1.74846625766871	46	22	82.8	1	27	161	44	89	CRH92729.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	285	49.7	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
32383511	32383511	PRJNA414225_P_NODE_74039_length_164_cov_0.886957_g73952_i0	PRJNA414225	74039	164	0.886957	1.45460948	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	102	2.23e-25	NR	MBY0529942.1	2047756	g73952	i0	98.1	1.97560975609756	54	1	98.8	0	3	164	88	141	MBY0529942.1 ATP-dependent Clp protease proteolytic subunit [Rhabdochlamydiaceae bacterium]	diamond	324	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32541941	32541941	PRJNA414225_P_NODE_90759_length_156_cov_2.317757_g90672_i0	PRJNA414225	90759	156	2.317757	3.61570092	Chlamydia trachomatis	813	Bacteria	Bacteria	77.8	1.55e-16	NR	WP_323848342.1	813	g90672	i0	73.1	88	52	14	100	0	1	156	17	68	WP_323848342.1 hypothetical protein [Chlamydia trachomatis]	diamond	13728	77.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
32762199	32762199	PRJNA414225_P_NODE_57060_length_166_cov_0.871795_g56973_i0	PRJNA414225	57060	166	0.871795	1.4471797	Candidatus Protochlamydia	282132	Bacteria	Bacteria	81.6	8.48e-17	NR	WP_011174673.1	282132	g56973	i0	74	1.80722891566265	50	13	90.4	0	3	152	246	295	WP_011174673.1 MULTISPECIES: glucose-1-phosphate thymidylyltransferase RfbA [Candidatus Protochlamydia]	diamond	300	81.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia
32856604	32856604	PRJNA414225_P_NODE_19700_length_188_cov_1.035971_g19613_i0	PRJNA414225	19700	188	1.035971	1.94762548	Chlamydiales bacterium	2047757	Bacteria	Bacteria	129	4.38e-33	NR	MBN9377981.1	2047757	g19613	i0	96.8	0.98936170212766	62	2	98.9	0	1	186	428	489	MBN9377981.1 fibronectin type III domain-containing protein [Chlamydiales bacterium]	diamond	186	129	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;