metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax_phylum = "Acidobacteriota"

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_species
4347723	4347723	PRJNA551951_S_NODE_3584_length_487_cov_12.360619_g3470_i0	PRJNA551951	3584	487	12.360619	60.19621453	Bacteria	2	Bacteria	Bacteria	118	1.37e-31	NR	OFW18531.1	1797182	g3470	i0	73	0.91170431211499	74	20	45.6	0	337	116	1	74	OFW18531.1 MAG: hypothetical protein A3H97_17670 [Acidobacteria bacterium RIFCSPLOWO2_02_FULL_65_29]	diamond	444	118	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteria bacterium RIFCSPLOWO2_02_FULL_65_29
26951507	26951507	PRJNA551951_S_NODE_10562_length_226_cov_2.319372_g10444_i0	PRJNA551951	10562	226	2.319372	5.24178072	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	70.1	1.94e-12	NR	MBK6750918.1	1978231	g10444	i0	47.8	0.915929203539823	69	36	91.6	0	1	207	110	178	MBK6750918.1 class I SAM-dependent methyltransferase [Acidobacteriota bacterium]	diamond	207	70.1	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27678782	27678782	PRJNA551951_S_NODE_1864_length_697_cov_5.107251_g1781_i0	PRJNA551951	1864	697	5.107251	35.59753947	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	128	7.539999999999999e-30	NR	HEX7175395.1	2283092	g1781	i0	55.6	1.08034433285509	126	56	54.2	0	309	686	2	127	HEX7175395.1 fused MFS/spermidine synthase [Pyrinomonadaceae bacterium]	diamond	753	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
29762186	29762186	PRJNA551951_S_NODE_10911_length_220_cov_2.151351_g10793_i0	PRJNA551951	10911	220	2.151351	4.7329722	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	63.9	9.49e-10	NR	PYX92234.1	1978231	g10793	i0	58.7	1.02272727272727	75	27	99.5	3	220	2	298	370	PYX92234.1 MAG: hypothetical protein DMG71_18485, partial [Acidobacteriota bacterium]	diamond	225	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
29793771	29793771	PRJNA551951_S_NODE_15971_length_162_cov_1.984252_g15853_i0	PRJNA551951	15971	162	1.984252	3.21448824	Terriglobales bacterium	2282142	Bacteria	Bacteria	57.8	6.3e-8	NR	HEY4930282.1	2282142	g15853	i0	57.4	1	54	23	100	0	162	1	537	590	HEY4930282.1 hypothetical protein [Terriglobales bacterium]	diamond	162	57.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales		Terriglobales bacterium
31437026	31437026	PRJNA551951_S_NODE_11976_length_204_cov_2.005917_g11858_i0	PRJNA551951	11976	204	2.005917	4.09207068	Bryobacterales bacterium	2026791	Bacteria	Bacteria	42.4	0.0178	NR	MCL4785142.1	2026791	g11858	i0	59.3	0.397058823529412	27	11	39.7	0	4	84	99	125	MCL4785142.1 DUF805 domain-containing protein [Bryobacterales bacterium]	diamond	81	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
31690033	31690033	PRJNA551951_S_NODE_17637_length_151_cov_1.913793_g17519_i0	PRJNA551951	17637	151	1.913793	2.88982743	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	42.4	0.015	NR	HEY6341854.1	2212468	g17519	i0	65.9	0.814569536423841	41	9	81.5	1	133	11	196	231	HEY6341854.1 PEP-CTERM sorting domain-containing protein [Bryobacteraceae bacterium]	diamond	123	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae 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);;