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

6 rows where analysis = "diamond", bioproject = "PRJNA608660" 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_order	tax_family	tax_genus	tax_species
15887420	15887420	PRJNA608660_P_NODE_10353_length_463_cov_13.934783_g10008_i0	PRJNA608660	10353	463	13.934783	64.51804529	Pseudomonadati	3379134	Bacteria	Bacteria	95.1	8.17e-20	NR	MBN2123032.1	2026735	g10008	i0	48.5	4.5939524838013	99	51	64.1	0	447	151	159	257	MBN2123032.1 ABC transporter permease [Deltaproteobacteria bacterium]	diamond	2127	95.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26872101	26872101	PRJNA608660_P_NODE_5061_length_645_cov_4.981544_g4763_i0	PRJNA608660	5061	645	4.981544	32.1309588	root	1	Root_unresolved	Root_unresolved	47.8	0.0125	NR	MEO8551975.1	2212474	g4763	i0	33.8	1.95348837209302	74	49	34.4	0	47	268	90	163	MEO8551975.1 hypothetical protein [Kofleriaceae bacterium]	diamond	1260	47.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28406633	28406633	PRJNA608660_P_NODE_34286_length_212_cov_3.073620_g33930_i0	PRJNA608660	34286	212	3.07362	6.5160744	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	65.1	3.27e-10	NR	RLC27457.1	2026735	g33930	i0	53.6	1.95283018867925	69	32	97.6	0	2	208	694	762	RLC27457.1 MAG: CRISPR-associated endonuclease Cas1 [Deltaproteobacteria bacterium]	diamond	414	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28501360	28501360	PRJNA608660_P_NODE_21587_length_299_cov_3.632000_g21231_i0	PRJNA608660	21587	299	3.632	10.859680000000001	Myxococcota bacterium	2818507	Bacteria	Bacteria	44.7	0.00247	NR	HNC97725.1	2818507	g21231	i0	40.3	0.622073578595318	62	26	51.2	1	245	93	17	78	HNC97725.1 hypothetical protein [Myxococcota bacterium]	diamond	186	44.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28501362	28501362	PRJNA608660_P_NODE_29087_length_241_cov_1.604167_g28731_i0	PRJNA608660	29087	241	1.604167	3.86604247	Nannocystis sp.	1962667	Bacteria	Bacteria	99.4	3.88e-22	NR	WP_293259433.1	1962667	g28731	i0	78.5	0.983402489626556	79	16	98.3	1	4	240	201	278	WP_293259433.1 tetratricopeptide repeat protein [Nannocystis sp.]	diamond	237	99.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
28911425	28911425	PRJNA608660_P_NODE_27188_length_253_cov_2.318627_g26832_i0	PRJNA608660	27188	253	2.318627	5.86612631	Polyangiaceae bacterium LLY-WYZ-14_1	3034331	Bacteria	Bacteria	42.4	0.0412	NR	HJK99605.1	3034331	g26832	i0	36.8	0.806324110671937	68	40	80.6	2	239	36	53	117	HJK99605.1 GNAT family N-acetyltransferase [Polyangiaceae bacterium LLY-WYZ-14_1]	diamond	204	42.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium LLY-WYZ-14_1

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);;