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

5 rows where bioproject = "PRJNA596867" 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
6244028	6244028	PRJNA596867_P_NODE_8805_length_281_cov_1.370192_g8730_i0	PRJNA596867	8805	281	1.370192	3.85023952	Gemmata	113	Bacteria	Bacteria	453	6.08e-123	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g8730	i0	95.73	79.1886120996441	281	12	100	0	1	281	1036284	1036004	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	22252	453	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
17145631	17145631	PRJNA596867_P_NODE_10254_length_263_cov_2.436842_g10179_i0	PRJNA596867	10254	263	2.436842	6.40889446	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g10179	i0	98.859	52.745247148289	263	3	100	0	1	263	3556569	3556831	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	13872	470	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
28879774	28879774	PRJNA596867_P_NODE_12168_length_249_cov_0.875000_g12093_i0	PRJNA596867	12168	249	0.875	2.17875	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.00823	NR	MCH7720669.1	2026780	g12093	i0	39.3	0.674698795180723	56	30	66.3	2	85	249	114	166	MCH7720669.1 hypothetical protein [Planctomycetota bacterium]	diamond	168	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31407162	31407162	PRJNA596867_P_NODE_12336_length_248_cov_1.754286_g12261_i0	PRJNA596867	12336	248	1.754286	4.35062928	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	60.5	1.1e-9	NR	MBC8548140.1	2760054	g12261	i0	40	0.967741935483871	80	47	96.8	1	242	3	16	94	MBC8548140.1 PAAR domain-containing protein [Candidatus Brocadiales bacterium]	diamond	240	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
32387742	32387742	PRJNA596867_P_NODE_12079_length_249_cov_0.875000_g12004_i0	PRJNA596867	12079	249	0.875	2.17875	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	69.3	1.75e-11	NR	HEX8341177.1	2876886	g12004	i0	47.5	1.85542168674699	80	42	96.4	0	10	249	393	472	HEX8341177.1 glycosyltransferase family 39 protein [Tepidisphaeraceae bacterium]	diamond	462	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;