metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1196384" 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
6700646	6700646	PRJNA1196384_S_NODE_846_length_417_cov_3.894737_g782_i0	PRJNA1196384	846	417	3.894737	16.24105329	Pseudomonadati	3379134	Bacteria	Bacteria	219	1.59e-70	NR	MCA9658156.1	2026763	g782	i0	82.4	16.2230215827338	125	22	89.9	0	417	43	48	172	MCA9658156.1 peptidylprolyl isomerase [Myxococcales bacterium]	diamond	6765	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
19448715	19448715	PRJNA1196384_S_NODE_3216_length_217_cov_1.772222_g3152_i0	PRJNA1196384	3216	217	1.772222	3.84572174	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	102	2.71e-25	NR	MCL5044315.1	2026735	g3152	i0	75.9	2.97235023041475	54	13	74.7	0	217	56	139	192	MCL5044315.1 superoxide dismutase [Deltaproteobacteria bacterium]	diamond	645	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26723805	26723805	PRJNA1196384_S_NODE_6501_length_164_cov_3.055118_g6437_i0	PRJNA1196384	6501	164	3.0551179999999998	5.01039352	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	80.5	6.26e-16	NR	MFO0591302.1	2268199	g6437	i0	63	1.97560975609756	54	20	98.8	0	2	163	125	178	MFO0591302.1 M15 family metallopeptidase [Polyangiaceae bacterium]	diamond	324	80.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28209274	28209274	PRJNA1196384_S_NODE_3186_length_218_cov_1.414365_g3122_i0	PRJNA1196384	3186	218	1.414365	3.0833157	Byssovorax sp.	2927945	Bacteria	Bacteria	97.8	9.33e-22	NR	MFO0762933.1	2927945	g3122	i0	60.9	1.85779816513761	69	27	95	0	213	7	194	262	MFO0762933.1 hypothetical protein [Byssovorax sp.]	diamond	405	97.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Byssovorax	Byssovorax sp.
29491307	29491307	PRJNA1196384_S_NODE_6950_length_161_cov_0.935484_g6886_i0	PRJNA1196384	6950	161	0.935484	1.50612924	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	6.02e-16	NR	MFT3772446.1	1971901	g6886	i0	67.9	6.78260869565217	53	17	98.8	0	1	159	1783	1835	MFT3772446.1 MopE-related protein [Minicystis sp.]	diamond	1092	80.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
30799019	30799019	PRJNA1196384_S_NODE_4454_length_190_cov_1.235294_g4390_i0	PRJNA1196384	4454	190	1.235294	2.3470586	Minicystis sp.	1971901	Bacteria	Bacteria	114	4.27e-28	NR	MEO7331543.1	1971901	g4390	i0	76.2	2.98421052631579	63	15	99.5	0	2	190	343	405	MEO7331543.1 7-dehydrocholesterol reductase [Minicystis sp.]	diamond	567	114	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
30830693	30830693	PRJNA1196384_S_NODE_8294_length_151_cov_1.710526_g8230_i0	PRJNA1196384	8294	151	1.710526	2.58289426	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47.8	1.82e-4	NR	MFN7700212.1	2026735	g8230	i0	55	1.58940397350993	40	18	79.5	0	25	144	66	105	MFN7700212.1 M15 family metallopeptidase [Deltaproteobacteria bacterium]	diamond	240	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31589642	31589642	PRJNA1196384_S_NODE_2716_length_235_cov_2.338384_g2652_i0	PRJNA1196384	2716	235	2.338384	5.4952024	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	45.8	0.00263	NR	HEY6081721.1	2268199	g2652	i0	35.5	0.791489361702128	62	40	79.1	0	27	212	334	395	HEY6081721.1 FAD-dependent oxidoreductase [Polyangiaceae bacterium]	diamond	186	45.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32032377	32032377	PRJNA1196384_S_NODE_1498_length_318_cov_5.046263_g1434_i0	PRJNA1196384	1498	318	5.046263	16.04711634	Myxococcota bacterium	2818507	Bacteria	Bacteria	44.7	0.00928	NR	MEO0606042.1	2818507	g1434	i0	31.7	1.91509433962264	101	63	95.3	2	310	8	68	162	MEO0606042.1 lipocalin/fatty-acid binding family protein [Myxococcota bacterium]	diamond	609	44.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32570492	32570492	PRJNA1196384_S_NODE_6299_length_166_cov_1.790698_g6235_i0	PRJNA1196384	6299	166	1.790698	2.97255868	Myxococcota bacterium	2818507	Bacteria	Bacteria	62	2.11e-9	NR	MCU0676089.1	2818507	g6235	i0	58.5	4.86144578313253	53	22	95.8	0	8	166	645	697	MCU0676089.1 heavy metal translocating P-type ATPase [Myxococcota bacterium]	diamond	807	62	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);;