metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA206070" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA206070" 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
9294449	9294449	PRJNA206070_S_NODE_22248_length_189_cov_1.789474_g20372_i0	PRJNA206070	22248	189	1.789474	3.38210586	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.07e-17	NR	HZV04970.1	2052164	g20372	i0	64.5	3.82539682539683	62	22	98.4	0	187	2	160	221	HZV04970.1 class II aldolase/adducin family protein [Gemmataceae bacterium]	diamond	723	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27358610	27358610	PRJNA206070_S_NODE_23223_length_183_cov_1.746575_g21347_i0	PRJNA206070	23223	183	1.746575	3.19623225	Prosthecobacter sp.	1965333	Bacteria	Bacteria	57	1.92e-8	NR	WP_395739302.1	1965333	g21347	i0	58.3	0.983606557377049	60	24	98.4	1	180	1	59	117	WP_395739302.1 hypothetical protein [Prosthecobacter sp.]	diamond	180	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31102651	31102651	PRJNA206070_S_NODE_19395_length_211_cov_3.775862_g17519_i0	PRJNA206070	19395	211	3.775862	7.96706882	Pseudomonadati	3379134	Bacteria	Bacteria	84	5.88e-17	NR	WP_020469806.1	360055	g17519	i0	58	2.80094786729858	69	29	98.1	0	3	209	152	220	WP_020469806.1 hypothetical protein [Zavarzinella formosa]	diamond	591	84	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Zavarzinella	Zavarzinella formosa
31861640	31861640	PRJNA206070_S_NODE_5317_length_697_cov_3.309091_g3530_i0	PRJNA206070	5317	697	3.309091	23.06436427	Bacteria	2	Bacteria	Bacteria	156	3.269999999999999e-42	NR	MCR5183256.1	2026772	g3530	i0	50	4.63988522238164	154	60	61.1	4	5	430	186	334	MCR5183256.1 adenine-specific methyltransferase EcoRI family protein [Opitutales bacterium]	diamond	3234	157	0.993630573248408	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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);;