metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA675331" 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
8301078	8301078	PRJNA675331_P_NODE_15667_length_267_cov_1.190722_g15495_i0	PRJNA675331	15667	267	1.190722	3.17922774	Opitutaceae bacterium	2006848	Bacteria	Bacteria	73.6	7.3e-13	NR	MFA5264893.1	2006848	g15495	i0	52.8	1	89	31	100	4	267	1	261	338	MFA5264893.1 M4 family metallopeptidase [Opitutaceae bacterium]	diamond	267	73.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
27081931	27081931	PRJNA675331_P_NODE_13542_length_279_cov_0.878641_g13370_i0	PRJNA675331	13542	279	0.878641	2.45140839	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	51.2	1.88e-5	NR	MFK7883494.1	2052180	g13370	i0	44.6	0.602150537634409	56	29	60.2	1	176	9	86	139	MFK7883494.1 CBS domain-containing protein [Phycisphaerales bacterium]	diamond	168	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27346782	27346782	PRJNA675331_P_NODE_5763_length_400_cov_0.929664_g5591_i0	PRJNA675331	5763	400	0.929664	3.718656	Bacteria	2	Bacteria	Bacteria	49.3	0.00109	NR	MCU0708535.1	117	g5591	i0	35.6	1.53	104	55	70.5	5	8	289	66	167	MCU0708535.1 hypothetical protein [Pirellula sp.]	diamond	612	49.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27492777	27492777	PRJNA675331_P_NODE_19263_length_249_cov_0.875000_g19091_i0	PRJNA675331	19263	249	0.875	2.17875	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	44.7	0.00812	NR	MDX1967755.1	2026779	g19091	i0	39.4	3.74698795180723	71	41	83.1	2	21	227	228	298	MDX1967755.1 protein kinase [Planctomycetaceae bacterium]	diamond	933	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27714163	27714163	PRJNA675331_P_NODE_11404_length_298_cov_2.026667_g11232_i0	PRJNA675331	11404	298	2.026667	6.03946766	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	5.76e-6	NR	MBX3465197.1	2026780	g11232	i0	45.5	0.553691275167785	55	28	55.4	1	94	258	38	90	MBX3465197.1 hypothetical protein [Planctomycetota bacterium]	diamond	165	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28092589	28092589	PRJNA675331_P_NODE_17065_length_257_cov_1.434783_g16893_i0	PRJNA675331	17065	257	1.434783	3.68739231	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	62.4	4.25e-9	NR	OJU80447.1	1895742	g16893	i0	37.6	3.01167315175097	85	47	99.2	1	257	3	161	239	OJU80447.1 MAG: lipase [Chlamydia sp. 32-24]	diamond	774	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24
30030629	30030629	PRJNA675331_P_NODE_19951_length_248_cov_0.880000_g19779_i0	PRJNA675331	19951	248	0.88	2.1824	PVC group	1783257	Bacteria	Bacteria	98.6	1.29e-22	NR	MBA3684686.1	2026780	g19779	i0	50.6	14.7459677419355	81	38	98	1	243	1	18	96	MBA3684686.1 ribonuclease Z [Planctomycetota bacterium]	diamond	3657	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31218988	31218988	PRJNA675331_P_NODE_20055_length_248_cov_0.880000_g19883_i0	PRJNA675331	20055	248	0.88	2.1824	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	67	1.74e-11	NR	MBY0309153.1	2052180	g19883	i0	60.9	0.556451612903226	46	18	55.6	0	160	23	1	46	MBY0309153.1 hypothetical protein [Phycisphaerales bacterium]	diamond	138	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;