metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax_phylum = "Ignavibacteriota"

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
27537982	27537982	PRJNA986481_P_NODE_1103_length_1253_cov_5.994186_g896_i0	PRJNA986481	1103	1253	5.994186	75.10715058	Pseudomonadati	3379134	Bacteria	Bacteria	156	7.09e-39	NR	WP_014856245.1	1134405	g896	i0	34.9	6.41420590582602	332	179	74.9	17	117	1055	24	337	WP_014856245.1 PQQ-dependent sugar dehydrogenase [Melioribacter roseus]	diamond	8037	157	0.993630573248408	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter roseus
29931816	29931816	PRJNA986481_P_NODE_29351_length_302_cov_2.359684_g28826_i0	PRJNA986481	29351	302	2.359684	7.12624568	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	58.2	2.97e-7	NR	QOJ28167.1	2049428	g28826	i0	36.9	2.0364238410596	103	59	98.3	3	5	301	898	998	QOJ28167.1 MAG: choice-of-anchor A family protein [Ignavibacteriales bacterium]	diamond	615	58.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
30063845	30063845	PRJNA986481_P_NODE_23231_length_340_cov_2.371134_g22706_i0	PRJNA986481	23231	340	2.371134	8.0618556	Bacteria	2	Bacteria	Bacteria	99.8	8.59e-22	NR	PID57661.1	2026749	g22706	i0	50	5.01176470588235	90	44	79.4	1	38	307	398	486	PID57661.1 MAG: cytosol nonspecific dipeptidase [Ignavibacteriota bacterium]	diamond	1704	100	0.998	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
31226924	31226924	PRJNA986481_P_NODE_28335_length_308_cov_1.559846_g27810_i0	PRJNA986481	28335	308	1.559846	4.80432568	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	148	7.83e-39	NR	MDD5361482.1	2053306	g27810	i0	69.6	18.8279220779221	102	31	99.4	0	1	306	561	662	MDD5361482.1 aminomethyl-transferring glycine dehydrogenase [Ignavibacteria bacterium]	diamond	5799	148	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31954451	31954451	PRJNA986481_P_NODE_26637_length_318_cov_1.821561_g26112_i0	PRJNA986481	26637	318	1.821561	5.79256398	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	44.3	0.0253	NR	MBI5474766.1	2026749	g26112	i0	36.8	0.537735849056604	57	35	53.8	1	193	23	279	334	MBI5474766.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium]	diamond	171	44.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota 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);;