metadata: contig_metadata: 5 rows where bioproject = "PRJNA796639" and tax

5 rows where bioproject = "PRJNA796639" 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_species
26927273	26927273	PRJNA796639_P_NODE_5162_length_260_cov_1.058824_g5037_i0	PRJNA796639	5162	260	1.058824	2.7529424	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	45.1	0.00658	NR	MDP3703451.1	2035772	g5037	i0	32.1	0.934615384615385	81	47	93.5	3	12	254	217	289	MDP3703451.1 COX15/CtaA family protein [Candidatus Omnitrophota bacterium]	diamond	243	45.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
28790612	28790612	PRJNA796639_P_NODE_6567_length_247_cov_0.885057_g6442_i0	PRJNA796639	6567	247	0.885057	2.18609079	Planctomycetota bacterium	2026780	Bacteria	Bacteria	54.3	3.3e-6	NR	MFC1792019.1	2026780	g6442	i0	38.3	0.983805668016194	81	47	98.4	3	5	247	40	117	MFC1792019.1 kelch repeat-containing protein [Planctomycetota bacterium]	diamond	243	54.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29674484	29674484	PRJNA796639_P_NODE_4730_length_270_cov_1.152284_g4605_i0	PRJNA796639	4730	270	1.152284	3.1111668	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.0107	NR	MCX6910854.1	2026799	g4605	i0	26.4	0.588888888888889	53	39	58.9	0	23	181	301	353	MCX6910854.1 O-antigen ligase family protein [Verrucomicrobiota bacterium]	diamond	159	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30275288	30275288	PRJNA796639_P_NODE_4172_length_283_cov_0.909524_g4047_i0	PRJNA796639	4172	283	0.909524	2.57395292	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	43.1	0.0426	NR	HEV7868427.1	2811408	g4047	i0	45.5	0.583038869257951	55	29	58.3	1	191	27	341	394	HEV7868427.1 DNA mismatch repair endonuclease MutL [Chthoniobacteraceae bacterium]	diamond	165	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacteraceae bacterium
32362008	32362008	PRJNA796639_P_NODE_5199_length_259_cov_0.956989_g5074_i0	PRJNA796639	5199	259	0.956989	2.47860151	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	43.5	0.0147	NR	MCI0541350.1	2026801	g5074	i0	33.3	0.590733590733591	51	33	59.1	1	52	204	72	121	MCI0541350.1 cation transporting ATPase C-terminal domain-containing protein [Verrucomicrobiales bacterium]	diamond	153	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales		Verrucomicrobiales 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);;