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

6 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
12375131	12375131	PRJNA917598_P_NODE_40970_length_359_cov_1.059441_g40026_i0	PRJNA917598	40970	359	1.059441	3.80339319	Bacteria	2	Bacteria	Bacteria	102	1.12e-25	NR	MFM7320239.1	2033014	g40026	i0	88.9	1.8050139275766	54	6	45.1	0	164	3	1	54	MFM7320239.1 50S ribosomal protein L27 [Armatimonadota bacterium]	diamond	648	102	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
26992716	26992716	PRJNA917598_P_NODE_31022_length_413_cov_2.247059_g30078_i0	PRJNA917598	31022	413	2.247059	9.28035367	Armatimonadota bacterium	2033014	Bacteria	Bacteria	63.9	2.51e-9	NR	MBS1713088.1	2033014	g30078	i0	44.7	0.552058111380145	76	39	55.2	2	151	378	133	205	MBS1713088.1 hypothetical protein [Armatimonadota bacterium]	diamond	228	63.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30624850	30624850	PRJNA917598_P_NODE_77853_length_254_cov_2.425414_g76909_i0	PRJNA917598	77853	254	2.425414	6.16055156	Armatimonas sp.	1872638	Bacteria	Bacteria	57.4	2.87e-7	NR	WP_395145221.1	1872638	g76909	i0	60	1.58267716535433	45	18	53.1	0	6	140	410	454	WP_395145221.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Armatimonas sp.]	diamond	402	57.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonas	Armatimonas sp.
31232383	31232383	PRJNA917598_P_NODE_83075_length_249_cov_0.875000_g82131_i0	PRJNA917598	83075	249	0.875	2.17875	Armatimonadia	1042312	Bacteria	Bacteria	131	1.17e-35	NR	HVK01885.1	2933160	g82131	i0	75	2.89156626506024	80	20	96.4	0	241	2	1	80	HVK01885.1 enoyl-ACP reductase [Armatimonadaceae bacterium]	diamond	720	131	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae		Armatimonadaceae bacterium
31731233	31731233	PRJNA917598_P_NODE_66017_length_280_cov_1.169082_g65073_i0	PRJNA917598	66017	280	1.169082	3.2734296	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	134	1.88e-36	NR	MEA2553947.1	2682144	g65073	i0	61.3	0.996428571428571	93	36	99.6	0	279	1	132	224	MEA2553947.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	279	134	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
32079347	32079347	PRJNA917598_P_NODE_81138_length_250_cov_0.870056_g80194_i0	PRJNA917598	81138	250	0.870056	2.17514	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	90.5	7.82e-22	NR	MDX1931705.1	2971800	g80194	i0	70.9	0.66	55	16	66	0	82	246	15	69	MDX1931705.1 hypothetical protein [Capsulimonadales bacterium]	diamond	165	90.5	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales 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);;