metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1195551" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1195551" 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_species
26851164	26851164	PRJNA1195551_S_NODE_20121_length_223_cov_2.120690_g19768_i0	PRJNA1195551	20121	223	2.12069	4.7291387	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0398	NR	MBM4027505.1	2026780	g19768	i0	44.3	0.820627802690583	61	28	82.1	2	37	219	29	83	MBM4027505.1 LamG domain-containing protein [Planctomycetota bacterium]	diamond	183	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetota bacterium
28051558	28051558	PRJNA1195551_S_NODE_29005_length_188_cov_2.366906_g28652_i0	PRJNA1195551	29005	188	2.366906	4.44978328	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.00935	NR	MBI4554663.1	2026780	g28652	i0	43.2	1.77127659574468	37	21	59	0	120	10	184	220	MBI4554663.1 cytochrome C [Planctomycetota bacterium]	diamond	333	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetota bacterium
28746203	28746203	PRJNA1195551_S_NODE_31487_length_181_cov_1.575758_g31134_i0	PRJNA1195551	31487	181	1.575758	2.85212198	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	41.6	0.0426	NR	MBI3416934.1	2026799	g31134	i0	48.8	0.679558011049724	41	16	68	1	177	55	483	518	MBI3416934.1 2-isopropylmalate synthase [Verrucomicrobiota bacterium]	diamond	123	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiota bacterium
31747504	31747504	PRJNA1195551_S_NODE_20117_length_223_cov_2.298851_g19764_i0	PRJNA1195551	20117	223	2.298851	5.12643773	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0466	NR	HVG94163.1	2026780	g19764	i0	37.5	0.645739910313901	48	30	64.6	0	49	192	68	115	HVG94163.1 phosphatase PAP2 family protein [Planctomycetota bacterium]	diamond	144	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetota bacterium
31937276	31937276	PRJNA1195551_S_NODE_34317_length_174_cov_1.248000_g33964_i0	PRJNA1195551	34317	174	1.248	2.17152	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42	0.028	NR	MBU4366548.1	2026799	g33964	i0	32.2	1.01724137931034	59	35	94.8	2	171	7	202	259	MBU4366548.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	177	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiota bacterium
32443945	32443945	PRJNA1195551_S_NODE_21379_length_217_cov_2.464286_g21026_i0	PRJNA1195551	21379	217	2.464286	5.34750062	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0348	NR	MEP7015433.1	2026799	g21026	i0	42.6	0.649769585253456	47	25	62.2	1	6	140	120	166	MEP7015433.1 acyl-CoA dehydrogenase family protein [Verrucomicrobiota bacterium]	diamond	141	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiota 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);;