metadata: contig_metadata: 4 rows where bioproject = "PRJNA675638" and tax

4 rows where bioproject = "PRJNA675638" 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
648509	648509	PRJNA675638_S_NODE_7641_length_167_cov_0.864407_g7579_i0	PRJNA675638	7641	167	0.864407	1.44355969	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	69.7	2.25e-12	NR	RYD85128.1	2026800	g7579	i0	90	6.44910179640719	40	4	71.9	0	167	48	245	284	RYD85128.1 MAG: SAM-dependent DNA methyltransferase, partial [Verrucomicrobiaceae bacterium]	diamond	1077	69.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27081947	27081947	PRJNA675638_P_NODE_16802_length_175_cov_1.142857_g16605_i0	PRJNA675638	16802	175	1.142857	1.99999975	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.1	0.0106	NR	HYE97375.1	2026780	g16605	i0	44.7	0.805714285714286	47	25	78.9	1	3	140	115	161	HYE97375.1 alginate export family protein [Planctomycetota bacterium]	diamond	141	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27081951	27081951	PRJNA675638_S_NODE_9342_length_161_cov_0.910714_g9280_i0	PRJNA675638	9342	161	0.910714	1.46624954	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	50.1	1.59e-5	NR	MFN9913902.1	2699754	g9280	i0	65.7	0.652173913043478	35	12	65.2	0	7	111	143	177	MFN9913902.1 hypothetical protein [Pirellulaceae bacterium]	diamond	105	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
30650420	30650420	PRJNA675638_P_NODE_4233_length_326_cov_1.288809_g4036_i0	PRJNA675638	4233	326	1.288809	4.20151734	Candidatus Chordibacter forsetii	3381758	Bacteria	Bacteria	78.6	7.23e-16	NR	WP_407679510.1	3381758	g4036	i0	42.7	1.63803680981595	89	46	81.9	1	317	51	58	141	WP_407679510.1 6-pyruvoyl trahydropterin synthase family protein [Candidatus Chordibacter forsetii]	diamond	534	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Candidatus Seribacteraceae	Candidatus Chordibacter	Candidatus Chordibacter forsetii

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