metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1069776" 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_species
26782709	26782709	PRJNA1069776_S_NODE_28501_length_201_cov_5.645570_g28187_i0	PRJNA1069776	28501	201	5.64557	11.3475957	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.00436	NR	TAN36928.1	2026799	g28187	i0	43.2	0.552238805970149	37	21	55.2	0	33	143	372	408	TAN36928.1 MAG: citrate transporter [Verrucomicrobiota bacterium]	diamond	111	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
26877770	26877770	PRJNA1069776_S_NODE_28041_length_203_cov_2.400000_g27727_i0	PRJNA1069776	28041	203	2.4	4.872	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	43.9	0.00865	NR	MBL9167005.1	2026801	g27727	i0	41.1	0.827586206896552	56	30	82.8	1	181	14	471	523	MBL9167005.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	168	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiales bacterium
27951830	27951830	PRJNA1069776_S_NODE_14105_length_271_cov_3.789474_g13791_i0	PRJNA1069776	14105	271	3.789474	10.26947454	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	42.7	0.0485	NR	HXL27472.1	2201154	g13791	i0	32.8	0.675276752767528	61	39	67.5	1	10	192	43	101	HXL27472.1 NAD(P)-dependent oxidoreductase [Chthoniobacterales bacterium]	diamond	183	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacterales bacterium
28109490	28109490	PRJNA1069776_S_NODE_16025_length_258_cov_3.525581_g15711_i0	PRJNA1069776	16025	258	3.525581	9.09599898	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47	0.00137	NR	MEL7337588.1	2026780	g15711	i0	50	0.488372093023256	42	21	48.8	0	11	136	36	77	MEL7337588.1 HTTM domain-containing protein [Planctomycetota bacterium]	diamond	126	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota			Planctomycetota bacterium
28520206	28520206	PRJNA1069776_S_NODE_14827_length_266_cov_2.107623_g14513_i0	PRJNA1069776	14827	266	2.107623	5.60627718	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.0351	NR	RME91193.1	2026799	g14513	i0	41.7	0.541353383458647	48	28	54.1	0	245	102	47	94	RME91193.1 MAG: hypothetical protein D6766_12205 [Verrucomicrobiota bacterium]	diamond	144	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
31552963	31552963	PRJNA1069776_S_NODE_15336_length_262_cov_4.557078_g15022_i0	PRJNA1069776	15336	262	4.557078	11.93954436	Phycisphaerae bacterium SM23_33	1703412	Bacteria	Bacteria	46.6	0.00191	NR	KPK80200.1	1703412	g15022	i0	37.7	0.698473282442748	61	34	69.8	2	254	72	124	180	KPK80200.1 MAG: hypothetical protein AMJ81_12360 [Phycisphaerae bacterium SM23_33]	diamond	183	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae		Phycisphaerae bacterium SM23_33
31900653	31900653	PRJNA1069776_S_NODE_33697_length_187_cov_3.263889_g33383_i0	PRJNA1069776	33697	187	3.263889	6.10347243	Pirellulales bacterium	2715253	Bacteria	Bacteria	42.4	0.0247	NR	HUY31662.1	2715253	g33383	i0	47.5	0.641711229946524	40	21	64.2	0	61	180	115	154	HUY31662.1 hypothetical protein [Pirellulales bacterium]	diamond	120	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulales bacterium
31932176	31932176	PRJNA1069776_S_NODE_40877_length_171_cov_3.875000_g40563_i0	PRJNA1069776	40877	171	3.875	6.62625	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	41.2	0.05	NR	MAV54538.1	2026778	g40563	i0	40.5	0.649122807017544	37	22	64.9	0	152	42	260	296	MAV54538.1 ATP-dependent RNA helicase HrpA [Phycisphaerae bacterium]	diamond	111	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae		Phycisphaerae bacterium
32090502	32090502	PRJNA1069776_S_NODE_10758_length_299_cov_16.671875_g10444_i0	PRJNA1069776	10758	299	16.671875	49.84890625	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	124	9.25e-35	NR	MBQ3747114.1	2212473	g10444	i0	65.9	0.852842809364548	85	29	85.3	0	43	297	10	94	MBQ3747114.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	255	124	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia		Kiritimatiellia bacterium
32343870	32343870	PRJNA1069776_S_NODE_34119_length_186_cov_2.888112_g33805_i0	PRJNA1069776	34119	186	2.888112	5.37188832	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40	0.049	NR	MBM3857925.1	2026799	g33805	i0	50	0.483870967741935	30	15	48.4	0	153	64	15	44	MBM3857925.1 FAD-dependent oxidoreductase [Verrucomicrobiota bacterium]	diamond	90	40	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota 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);;