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

6 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax_phylum = "Myxococcota"

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_species
996556	996556	PRJEB80557_S_NODE_34161_length_167_cov_1.237288_g33765_i0	PRJEB80557	34161	167	1.237288	2.06627096	Myxococcota bacterium	2818507	Bacteria	Bacteria	103	4.77e-24	NR	MEE2779060.1	2818507	g33765	i0	83.6	0.988023952095808	55	9	98.8	0	166	2	141	195	MEE2779060.1 aldehyde dehydrogenase family protein [Myxococcota bacterium]	diamond	165	103	1	Bacteria	Pseudomonadati	Myxococcota		Myxococcota bacterium
23090946	23090946	PRJEB80557_S_NODE_11939_length_267_cov_1.756881_g11543_i0	PRJEB80557	11939	267	1.756881	4.69087227	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	152	3.24e-41	NR	MBI2392224.1	2026735	g11543	i0	84.1	0.98876404494382	88	14	98.9	0	266	3	348	435	MBI2392224.1 slipin family protein [Deltaproteobacteria bacterium]	diamond	264	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Deltaproteobacteria bacterium
27413776	27413776	PRJEB80557_S_NODE_13603_length_252_cov_2.325123_g13207_i0	PRJEB80557	13603	252	2.325123	5.85930996	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	99.8	8.98e-25	NR	RLA97446.1	2026735	g13207	i0	62.8	1.9047619047619	78	29	92.9	0	12	245	51	128	RLA97446.1 MAG: methylmalonyl-CoA mutase [Deltaproteobacteria bacterium]	diamond	480	99.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Deltaproteobacteria bacterium
30729344	30729344	PRJEB80557_S_NODE_33854_length_167_cov_2.567797_g33458_i0	PRJEB80557	33854	167	2.567797	4.28822099	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	50.8	1.84e-5	NR	MBI2392715.1	2026735	g33458	i0	77.4	0.55688622754491	31	7	55.7	0	2	94	411	441	MBI2392715.1 sigma 54-interacting transcriptional regulator [Deltaproteobacteria bacterium]	diamond	93	50.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Deltaproteobacteria bacterium
32215637	32215637	PRJEB80557_S_NODE_10178_length_287_cov_1.193277_g9782_i0	PRJEB80557	10178	287	1.193277	3.42470499	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	48.1	4.76e-4	NR	MBM4273174.1	2026735	g9782	i0	47.7	0.45993031358885	44	23	46	0	223	92	14	57	MBM4273174.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	132	48.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Deltaproteobacteria bacterium
32342367	32342367	PRJEB80557_S_NODE_9459_length_296_cov_1.465587_g9063_i0	PRJEB80557	9459	296	1.465587	4.33813752	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	57.8	3.7e-7	NR	QQR79486.1	2026735	g9063	i0	51.4	1.43918918918919	72	23	61.8	4	33	215	688	758	QQR79486.1 MAG: efflux RND transporter permease subunit [Deltaproteobacteria bacterium]	diamond	426	57.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Deltaproteobacteria 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);;