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

4 rows where bioproject = "PRJNA931595" 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
909710	909710	PRJNA931595_P_NODE_2061_length_485_cov_0.934466_g1954_i0	PRJNA931595	2061	485	0.934466	4.5321601	Caulifigura coniformis	2527983	Bacteria	Bacteria	752	0	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g1954	i0	94.639	357.701030927835	485	26	100	0	1	485	2924762	2925246	Caulifigura coniformis strain Pan44 chromosome	blastn	173485	752	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
27150933	27150933	PRJNA931595_P_NODE_11122_length_262_cov_1.513228_g11013_i0	PRJNA931595	11122	262	1.513228	3.96465736	Planctopirus limnophila	120	Bacteria	Bacteria	46.2	0.00263	NR	WP_041402393.1	120	g11013	i0	33.3	0.99618320610687	87	49	89.3	1	257	24	300	386	WP_041402393.1 tRNA 2-thiouridine(34) synthase MnmA [Planctopirus limnophila]	diamond	261	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctopirus	Planctopirus limnophila
27404356	27404356	PRJNA931595_P_NODE_15623_length_241_cov_0.916667_g15514_i0	PRJNA931595	15623	241	0.916667	2.20916747	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	47	0.00109	NR	MEO1996474.1	2026779	g15514	i0	33.8	1.69294605809129	74	48	92.1	1	15	236	23	95	MEO1996474.1 S49 family peptidase [Planctomycetaceae bacterium]	diamond	408	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31668346	31668346	PRJNA931595_P_NODE_13577_length_247_cov_0.885057_g13468_i0	PRJNA931595	13577	247	0.885057	2.18609079	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	134	3.71e-39	NR	MDB5294465.1	2052180	g13468	i0	84.6	0.947368421052632	78	12	94.7	0	245	12	1	78	MDB5294465.1 hypothetical protein [Phycisphaerales bacterium]	diamond	234	134	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);;