metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA665531" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA665531" and tax_clade = "PVC group"

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
1905423	1905423	PRJNA665531_P_NODE_17762_length_248_cov_0.880000_g17526_i0	PRJNA665531	17762	248	0.88	2.1824	Pirellulales bacterium	2715253	Bacteria	Bacteria	156	3.51e-45	NR	HTU25858.1	2715253	g17526	i0	89	1.98387096774194	82	9	99.2	0	2	247	25	106	HTU25858.1 50S ribosomal protein L2 [Pirellulales bacterium]	diamond	492	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
7007970	7007970	PRJNA665531_P_NODE_17506_length_249_cov_0.875000_g17270_i0	PRJNA665531	17506	249	0.875	2.17875	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	155	6.82e-42	NR	MBX3357020.1	2026777	g17270	i0	92.8	2	83	6	100	0	1	249	338	420	MBX3357020.1 ATP-dependent zinc metalloprotease FtsH [Phycisphaeraceae bacterium]	diamond	498	155	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27049971	27049971	PRJNA665531_P_NODE_13562_length_281_cov_1.927885_g13326_i0	PRJNA665531	13562	281	1.927885	5.41735685	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	105	3.85e-24	NR	WP_059062089.1	389348	g13326	i0	55.2	0.928825622775801	87	39	92.9	0	278	18	586	672	WP_059062089.1 penicillin-binding transpeptidase domain-containing protein [Candidatus Protochlamydia naegleriophila]	diamond	261	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
29512848	29512848	PRJNA665531_P_NODE_17070_length_251_cov_0.865169_g16834_i0	PRJNA665531	17070	251	0.865169	2.17157419	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	94.7	2.13e-20	NR	HMN39257.1	2052180	g16834	i0	62.4	1.01593625498008	85	29	99.2	2	251	3	1145	1228	HMN39257.1 ATP-dependent RNA helicase HrpA [Phycisphaerales bacterium]	diamond	255	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29544425	29544425	PRJNA665531_P_NODE_18190_length_246_cov_0.890173_g17954_i0	PRJNA665531	18190	246	0.890173	2.18982558	Planctomycetota bacterium	2026780	Bacteria	Bacteria	140	1.4299999999999998e-37	NR	MEK6643633.1	2026780	g17954	i0	81.5	1.96341463414634	81	15	98.8	0	3	245	275	355	MEK6643633.1 site-specific integrase [Planctomycetota bacterium]	diamond	483	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32579375	32579375	PRJNA665531_P_NODE_17499_length_249_cov_0.875000_g17263_i0	PRJNA665531	17499	249	0.875	2.17875	Gemmata sp.	1914242	Bacteria	Bacteria	83.2	2.25e-16	NR	HEV3436776.1	1914242	g17263	i0	57.8	1	83	31	97.6	2	248	6	365	445	HEV3436776.1 HEAT repeat domain-containing protein [Gemmata sp.]	diamond	249	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
32862533	32862533	PRJNA665531_P_NODE_17960_length_247_cov_0.885057_g17724_i0	PRJNA665531	17960	247	0.885057	2.18609079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.00503	NR	MEM9353643.1	2026780	g17724	i0	45.5	0.40080971659919	33	18	40.1	0	78	176	48	80	MEM9353643.1 hypothetical protein [Planctomycetota bacterium]	diamond	99	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;