metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1044115" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1044115" and tax_phylum = "Bacteroidota"

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
12925146	12925146	PRJNA1044115_P_NODE_29411_length_271_cov_1.242424_g29227_i0	PRJNA1044115	29411	271	1.242424	3.36696904	Bacteroidota bacterium	1898104	Bacteria	Bacteria	176	4.879999999999999e-54	NR	MBS1611573.1	1898104	g29227	i0	97.8	0.996309963099631	90	2	99.6	0	271	2	79	168	MBS1611573.1 50S ribosomal protein L3 [Bacteroidota bacterium]	diamond	270	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
12925247	12925247	PRJNA1044115_P_NODE_35251_length_251_cov_0.876404_g35067_i0	PRJNA1044115	35251	251	0.876404	2.19977404	Bacteroidota bacterium	1898104	Bacteria	Bacteria	159	4.3099999999999986e-43	NR	MDT7942228.1	1898104	g35067	i0	92.8	0.99203187250996006	83	6	99.2	0	249	1	157	239	MDT7942228.1 thiamine pyrophosphate-dependent enzyme [Bacteroidota bacterium]	diamond	249	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
24397755	24397755	PRJNA1044115_P_NODE_9120_length_505_cov_3.127315_g8937_i0	PRJNA1044115	9120	505	3.127315	15.79294075	Bacteroidota bacterium	1898104	Bacteria	Bacteria	234	1.48e-76	NR	MFN7821502.1	1898104	g8937	i0	94.5	0.76039603960396	128	7	76	0	23	406	1	128	MFN7821502.1 histone H2A [Bacteroidota bacterium]	diamond	384	234	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28330034	28330034	PRJNA1044115_P_NODE_38386_length_247_cov_0.896552_g38202_i0	PRJNA1044115	38386	247	0.896552	2.21448344	Mucilaginibacter gracilis	423350	Bacteria	Bacteria	77	3.27e-14	NR	WP_121198424.1	423350	g38202	i0	84.8	0.558704453441296	46	7	55.9	0	140	3	1	46	WP_121198424.1 SusC/RagA family TonB-linked outer membrane protein [Mucilaginibacter gracilis]	diamond	138	77	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter gracilis
28551319	28551319	PRJNA1044115_P_NODE_37727_length_248_cov_0.891429_g37543_i0	PRJNA1044115	37727	248	0.891429	2.21074392	Bacteroidota bacterium	1898104	Bacteria	Bacteria	137	4.64e-37	NR	MFO0468276.1	1898104	g37543	i0	75	0.919354838709677	76	18	91.9	1	230	3	219	293	MFO0468276.1 fatty acid desaturase [Bacteroidota bacterium]	diamond	228	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29561364	29561364	PRJNA1044115_P_NODE_30550_length_266_cov_1.569948_g30366_i0	PRJNA1044115	30550	266	1.569948	4.17606168	Bacteroidota bacterium	1898104	Bacteria	Bacteria	102	1.5e-23	NR	MDQ5930221.1	1898104	g30366	i0	50	0.992481203007519	88	44	99.2	0	1	264	202	289	MDQ5930221.1 hypothetical protein [Bacteroidota bacterium]	diamond	264	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30351732	30351732	PRJNA1044115_P_NODE_17092_length_353_cov_2.721429_g16908_i0	PRJNA1044115	17092	353	2.721429	9.60664437	Bacteroidota bacterium	1898104	Bacteria	Bacteria	102	6.339999999999999e-23	NR	MDQ5930221.1	1898104	g16908	i0	48.9	1.56373937677054	92	47	78.2	0	3	278	289	380	MDQ5930221.1 hypothetical protein [Bacteroidota bacterium]	diamond	552	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31394210	31394210	PRJNA1044115_P_NODE_41736_length_242_cov_0.923077_g41552_i0	PRJNA1044115	41736	242	0.923077	2.23384634	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	96.7	1.34e-23	NR	MCX8482525.1	2026728	g41552	i0	68.6	1.73553719008264	70	21	86.8	1	212	3	3	71	MCX8482525.1 methylglyoxal synthase [Crocinitomicaceae bacterium]	diamond	420	96.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae 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);;