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

8 rows where analysis = "diamond", bioproject = "PRJNA382558" 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
28513218	28513218	PRJNA382558_S_NODE_1107_length_311_cov_8.704380_g1103_i0	PRJNA382558	1107	311	8.70438	27.0706218	Pseudomonadati	3379134	Bacteria	Bacteria	91.7	4.92e-19	NR	HTN52801.1	1872521	g1103	i0	55.1	5.02572347266881	89	35	85.9	1	309	43	425	508	HTN52801.1 hypothetical protein [Anaeromyxobacter sp.]	diamond	1563	92.4	0.992424242424242	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp.
29854082	29854082	PRJNA382558_S_NODE_5111_length_210_cov_7.433526_g5107_i0	PRJNA382558	5111	210	7.433526	15.6104046	Myxococcota bacterium	2818507	Bacteria	Bacteria	102	2.62e-24	NR	MEW5741872.1	2818507	g5107	i0	64.3	6.92857142857143	70	25	100	0	210	1	75	144	MEW5741872.1 alpha/beta hydrolase [Myxococcota bacterium]	diamond	1455	102	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30296786	30296786	PRJNA382558_S_NODE_6592_length_195_cov_7.873418_g6588_i0	PRJNA382558	6592	195	7.873418	15.3531651	Myxococcota bacterium	2818507	Bacteria	Bacteria	41.6	0.032	NR	MDP9033838.1	2818507	g6588	i0	47.5	0.615384615384615	40	19	61.5	1	183	64	52	89	MDP9033838.1 hypothetical protein [Myxococcota bacterium]	diamond	120	41.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30328456	30328456	PRJNA382558_S_NODE_772_length_337_cov_8.686667_g768_i0	PRJNA382558	772	337	8.686667	29.27406779	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	135	1.38e-37	NR	MBM2803994.1	2026735	g768	i0	70.7	0.818991097922849	92	25	80.1	1	52	321	42	133	MBM2803994.1 uncharacterized protein [Deltaproteobacteria bacterium]	diamond	276	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30580459	30580459	PRJNA382558_S_NODE_793_length_335_cov_10.926174_g789_i0	PRJNA382558	793	335	10.926174	36.6026829	Myxococcus qinghaiensis	2906758	Bacteria	Bacteria	83.6	2.44e-16	NR	WP_323389881.1	2906758	g789	i0	42.7	0.985074626865672	110	60	95.8	2	334	14	108	217	WP_323389881.1 pre-peptidase C-terminal domain-containing protein, partial [Myxococcus qinghaiensis]	diamond	330	83.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus qinghaiensis
31686947	31686947	PRJNA382558_S_NODE_4977_length_211_cov_10.798851_g4973_i0	PRJNA382558	4977	211	10.798851	22.78557561	Myxococcota bacterium	2818507	Bacteria	Bacteria	65.9	1.73e-10	NR	MES2639945.1	2818507	g4973	i0	53.2	0.881516587677725	62	27	88.2	1	187	2	104	163	MES2639945.1 hypothetical protein [Myxococcota bacterium]	diamond	186	65.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32400146	32400146	PRJNA382558_S_NODE_15299_length_152_cov_5.591304_g15295_i0	PRJNA382558	15299	152	5.591304	8.49878208	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	2.7e-13	NR	MBN1210300.1	2484252	g15295	i0	66.7	1.89473684210526	48	16	94.7	0	2	145	623	670	MBN1210300.1 ATP-binding protein [Myxococcaceae bacterium]	diamond	288	72.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
32698732	32698732	PRJNA382558_S_NODE_8820_length_179_cov_8.654930_g8816_i0	PRJNA382558	8820	179	8.65493	15.4923247	Myxococcota bacterium	2818507	Bacteria	Bacteria	51.2	7.6e-7	NR	MEO1335893.1	2818507	g8816	i0	42.6	0.905027932960894	54	29	87.2	1	2	157	3	56	MEO1335893.1 hypothetical protein [Myxococcota bacterium]	diamond	162	51.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;