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

10 rows where bioproject = "PRJNA986481", 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
974045	974045	PRJNA986481_P_NODE_841_length_1384_cov_4.538577_g678_i0	PRJNA986481	841	1384	4.538577	62.81390568	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	2359	0	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g678	i0	97.946	118.014450867052	1363	25	98	2	22	1384	1249613	1250972	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	163332	2359	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
2547762	2547762	PRJNA986481_P_NODE_33342_length_283_cov_1.632479_g32817_i0	PRJNA986481	33342	283	1.632479	4.61991557	Candidatus Protochlamydia	282132	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|262292945\|gb\|FJ976101.1\|	389348	g32817	i0	100	110.689045936396	283	0	100	0	1	283	300	18	Protochlamydia naegleriophila strain cvE27 16S ribosomal RNA gene, partial sequence	blastn	31325	523	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
16276441	16276441	PRJNA986481_P_NODE_34653_length_277_cov_36.872807_g34128_i0	PRJNA986481	34653	277	36.872807	102.13767539	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	399	7.899999999999999e-107	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g34128	i0	98.667	97.3862815884477	225	3	81	0	53	277	1249073	1249297	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	26976	399	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17551344	17551344	PRJNA986481_P_NODE_27734_length_311_cov_2.923664_g27209_i0	PRJNA986481	27734	311	2.923664	9.09259504	PVC group	1783257	Bacteria	Bacteria	116	3.66e-28	NR	MEC7840177.1	2081524	g27209	i0	75.3	6.33762057877814	73	17	70.4	1	22	240	371	442	MEC7840177.1 adenosylhomocysteinase [Chlamydiota bacterium]	diamond	1971	116	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
20100463	20100463	PRJNA986481_P_NODE_62156_length_229_cov_4.166667_g61631_i0	PRJNA986481	62156	229	4.166667	9.54166743	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	379	8.249999999999999e-101	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g61631	i0	96.507	1	229	8	100	0	1	229	2288496	2288268	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	229	379	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
27721867	27721867	PRJNA986481_P_NODE_38024_length_266_cov_1.018433_g37499_i0	PRJNA986481	38024	266	1.018433	2.70903178	Chlamydiota bacterium	2081524	Bacteria	Bacteria	91.3	1.08e-19	NR	MCX6987222.1	2081524	g37499	i0	67.6	0.800751879699248	71	23	80.1	0	213	1	2	72	MCX6987222.1 transaldolase [Chlamydiota bacterium]	diamond	213	91.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30658299	30658299	PRJNA986481_P_NODE_253_length_1890_cov_6.629006_g193_i0	PRJNA986481	253	1890	6.629006	125.2882134	Chlamydiales bacterium	2047757	Bacteria	Bacteria	456	2.0199999999999992e-148	NR	MFT5319030.1	2047757	g193	i0	40.4	0.985714285714286	621	263	96.3	14	1821	1	14	541	MFT5319030.1 5-histidylcysteine sulfoxide synthase/putative 4-mercaptohistidine N1-methyltransferase [Chlamydiales bacterium]	diamond	1863	456	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30847907	30847907	PRJNA986481_P_NODE_4054_length_768_cov_5.470097_g3658_i0	PRJNA986481	4054	768	5.470097	42.01034496	Chlamydiota bacterium	2081524	Bacteria	Bacteria	59.7	2.08e-6	NR	NGX39248.1	2081524	g3658	i0	28.5	0.7265625	186	105	68	6	97	618	38	207	NGX39248.1 hypothetical protein [Chlamydiota bacterium]	diamond	558	59.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30974396	30974396	PRJNA986481_P_NODE_42814_length_260_cov_1.781991_g42289_i0	PRJNA986481	42814	260	1.781991	4.6331766	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	166	4.799999999999999e-46	NR	WP_059062019.1	389348	g42289	i0	97.7	0.992307692307692	86	2	99.2	0	3	260	135	220	WP_059062019.1 succinate dehydrogenase flavoprotein subunit [Candidatus Protochlamydia naegleriophila]	diamond	258	166	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
32397691	32397691	PRJNA986481_P_NODE_28219_length_309_cov_1.165385_g27694_i0	PRJNA986481	28219	309	1.165385	3.60103965	Candidatus Rhabdochlamydia porcellionis	225148	Bacteria	Bacteria	46.2	0.00482	NR	WP_194845061.1	225148	g27694	i0	58.5	0.398058252427184	41	17	39.8	0	2	124	130	170	WP_194845061.1 NEL-type E3 ubiquitin ligase domain-containing protein [Candidatus Rhabdochlamydia porcellionis]	diamond	123	46.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia porcellionis

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