metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA484127" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA484127" 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
27929179	27929179	PRJNA484127_P_NODE_24505_length_272_cov_11.703518_g24356_i0	PRJNA484127	24505	272	11.703518	31.83356896	Candidatus Anoxychlamydiales bacterium	2705072	Bacteria	Bacteria	43.1	0.0376	NR	NGX48595.1	2705072	g24356	i0	32.3	0.716911764705882	65	44	71.7	0	260	66	123	187	NGX48595.1 hypothetical protein [Candidatus Anoxychlamydiales bacterium]	diamond	195	43.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Candidatus Anoxychlamydiales			Candidatus Anoxychlamydiales bacterium
28213036	28213036	PRJNA484127_P_NODE_39026_length_242_cov_0.923077_g38877_i0	PRJNA484127	39026	242	0.923077	2.23384634	Pirellulales bacterium	2715253	Bacteria	Bacteria	87	7.85e-18	NR	MCL6503502.1	2715253	g38877	i0	54.3	1.00413223140496	81	31	96.7	3	234	1	278	355	MCL6503502.1 NAD(+)/NADH kinase [Pirellulales bacterium]	diamond	243	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28687174	28687174	PRJNA484127_P_NODE_32267_length_250_cov_0.881356_g32118_i0	PRJNA484127	32267	250	0.881356	2.20339	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	137	2.8099999999999997e-35	NR	MDX1947954.1	2699754	g32118	i0	87.8	5.904	82	10	98.4	0	3	248	381	462	MDX1947954.1 pyruvate, phosphate dikinase [Pirellulaceae bacterium]	diamond	1476	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29776396	29776396	PRJNA484127_P_NODE_35411_length_246_cov_0.901734_g35262_i0	PRJNA484127	35411	246	0.901734	2.21826564	Luteolibacter	518753	Bacteria	Bacteria	53.9	3.62e-6	NR	WP_264511626.1	2989719	g35262	i0	51.9	2.28048780487805	52	23	63.4	1	213	58	194	243	WP_264511626.1 class I SAM-dependent methyltransferase [Luteolibacter rhizosphaerae]	diamond	561	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter rhizosphaerae
31514742	31514742	PRJNA484127_P_NODE_12936_length_347_cov_1.138686_g12787_i0	PRJNA484127	12936	347	1.138686	3.95124042	Bacteria	2	Bacteria	Bacteria	56.6	1.67e-6	NR	MFT5090471.1	2026780	g12787	i0	43.1	1.13256484149856	65	37	56.2	0	346	152	383	447	MFT5090471.1 tetratricopeptide (TPR) repeat protein [Planctomycetota bacterium]	diamond	393	56.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32194432	32194432	PRJNA484127_P_NODE_2938_length_638_cov_9.189381_g2796_i0	PRJNA484127	2938	638	9.189381	58.62825078	Mariniblastus sp.	2005381	Bacteria	Bacteria	186	1.93e-56	NR	MFK7768787.1	2005381	g2796	i0	56.5	1.56583072100313	168	70	79	2	516	13	4	168	MFK7768787.1 thiol peroxidase [Mariniblastus sp.]	diamond	999	186	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus sp.

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