metadata: contig_metadata: 11 rows where bioproject = "PRJNA1122875", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA1122875", 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
1552153	1552153	PRJNA1122875_P_NODE_25762_length_326_cov_1.988142_g25538_i0	PRJNA1122875	25762	326	1.988142	6.48134292	Simkania sp.	34094	Bacteria	Bacteria	75.1	1.08e-13	NR	MCB1084310.1	34094	g25538	i0	64.2	0.487730061349693	53	19	48.8	0	325	167	120	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	159	75.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
1552230	1552230	PRJNA1122875_P_NODE_3182_length_832_cov_1.808959_g3001_i0	PRJNA1122875	3182	832	1.808959	15.05053888	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	1020	0	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g3001	i0	88.889	117.123798076923	837	81	100	11	1	832	174366	175195	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	97447	1020	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
10481037	10481037	PRJNA1122875_P_NODE_11709_length_486_cov_2.285714_g11487_i0	PRJNA1122875	11709	486	2.285714	11.10857004	Candidatus Euplotechlamydia quinta	2936506	Bacteria	Bacteria	652	0	NTclustered	gi\|2226301499\|gb\|ON271409.1\|	2936506	g11487	i0	92.544	101.156378600823	456	32	94	2	32	486	464	10	Chlamydiia bacterium (ex Euplotes octocarinatus) isolate Zam5b-1 16S ribosomal RNA gene, partial sequence	blastn	49162	652	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Euplotechlamydia	Candidatus Euplotechlamydia quinta
24503286	24503286	PRJNA1122875_P_NODE_10420_length_513_cov_2.193182_g10200_i0	PRJNA1122875	10420	513	2.193182	11.25102366	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	484	4.179999999999999e-132	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10200	i0	83.908	95.0740740740741	522	68	100	14	1	513	2059082	2058568	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48773	484	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
27006755	27006755	PRJNA1122875_P_NODE_43822_length_250_cov_3.338983_g43598_i0	PRJNA1122875	43822	250	3.338983	8.3474575	Chlamydiales bacterium	2047757	Bacteria	Bacteria	110	7.7e-29	NR	MCP5470421.1	2047757	g43598	i0	70.4	0.972	81	24	97.2	0	6	248	49	129	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	243	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27533314	27533314	PRJNA1122875_P_NODE_51903_length_243_cov_0.905882_g51679_i0	PRJNA1122875	51903	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	66.6	1.33e-10	NR	SCA62480.1	1871324	g51679	i0	54.7	1.28395061728395	53	24	65.4	0	2	160	350	402	SCA62480.1 Dihydroorotase [Chlamydiales bacterium SCGC AG-110-M15]	diamond	312	66.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium SCGC AG-110-M15
29375339	29375339	PRJNA1122875_P_NODE_18909_length_384_cov_0.974277_g18685_i0	PRJNA1122875	18909	384	0.974277	3.74122368	Simkania sp.	34094	Bacteria	Bacteria	191	1.89e-58	NR	MCB1084310.1	34094	g18685	i0	79.2	0.9375	120	25	93.8	0	360	1	1	120	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	360	191	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29722365	29722365	PRJNA1122875_P_NODE_19130_length_381_cov_2.006494_g18906_i0	PRJNA1122875	19130	381	2.006494	7.64474214	Waddliaceae bacterium	2026802	Bacteria	Bacteria	163	2.2e-46	NR	HEY4831209.1	2026802	g18906	i0	69.8	0.992125984251969	126	38	99.2	0	380	3	212	337	HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium]	diamond	378	163	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
29754094	29754094	PRJNA1122875_P_NODE_14531_length_438_cov_1.002740_g14307_i0	PRJNA1122875	14531	438	1.00274	4.3920012	Chlamydiota bacterium	2081524	Bacteria	Bacteria	54.3	2.58e-6	NR	MCX6991377.1	2081524	g14307	i0	31.8	1.17808219178082	85	58	58.2	0	257	3	13	97	MCX6991377.1 ASCH domain-containing protein [Chlamydiota bacterium]	diamond	516	54.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30196365	30196365	PRJNA1122875_P_NODE_42352_length_253_cov_1.672222_g42128_i0	PRJNA1122875	42352	253	1.672222	4.23072166	Chlamydiales bacterium	2047757	Bacteria	Bacteria	63.5	1.53e-9	NR	MCP5506404.1	2047757	g42128	i0	60.9	0.545454545454545	46	18	54.5	0	2	139	212	257	MCP5506404.1 hypothetical protein [Chlamydiales bacterium]	diamond	138	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31998367	31998367	PRJNA1122875_P_NODE_16118_length_416_cov_1.483965_g15894_i0	PRJNA1122875	16118	416	1.483965	6.1732944	Chlamydiales bacterium	2047757	Bacteria	Bacteria	150	1.6299999999999999e-43	NR	MCP5470421.1	2047757	g15894	i0	62.3	2.46634615384615	114	43	82.2	0	34	375	1	114	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	1026	150	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);;