metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA782235" 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
4591713	4591713	PRJNA782235_P_NODE_25404_length_243_cov_0.905882_g25215_i0	PRJNA782235	25404	243	0.905882	2.20129326	Myxococcota bacterium	2818507	Bacteria	Bacteria	151	1.75e-41	NR	MEZ0311045.1	2818507	g25215	i0	97.5	1.97530864197531	80	2	98.8	0	241	2	131	210	MEZ0311045.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Myxococcota bacterium]	diamond	480	151	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
21165974	21165974	PRJNA782235_P_NODE_24137_length_244_cov_1.801170_g23948_i0	PRJNA782235	24137	244	1.80117	4.3948548	Myxococcota bacterium	2818507	Bacteria	Bacteria	133	2.4e-36	NR	MFA6032311.1	2818507	g23948	i0	79	4.97950819672131	81	17	99.6	0	2	244	47	127	MFA6032311.1 site-specific integrase [Myxococcota bacterium]	diamond	1215	133	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
22440699	22440699	PRJNA782235_P_NODE_21778_length_246_cov_1.780347_g21589_i0	PRJNA782235	21778	246	1.780347	4.37965362	Bacteria candidate phyla	1783234	Bacteria	Bacteria	105	3.2299999999999997e-24	NR	HTN83717.1	2093377	g21589	i0	67.5	3.90243902439024	77	25	93.9	0	233	3	1522	1598	HTN83717.1 type I polyketide synthase [Sorangium sp.]	diamond	960	106	0.990566037735849	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium sp.
27874822	27874822	PRJNA782235_P_NODE_10625_length_285_cov_1.452830_g10436_i0	PRJNA782235	10625	285	1.45283	4.1405655	Myxococcales bacterium	2026763	Bacteria	Bacteria	43.5	0.0227	NR	GMV42276.1	2026763	g10436	i0	39.3	0.642105263157895	61	37	64.2	0	212	30	8	68	GMV42276.1 MAG: hypothetical protein AMXMBFR64_39920 [Myxococcales bacterium]	diamond	183	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29642687	29642687	PRJNA782235_P_NODE_27570_length_241_cov_1.291667_g27381_i0	PRJNA782235	27570	241	1.291667	3.11291747	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.4	0.0464	NR	MBN1226214.1	2026735	g27381	i0	34.6	0.647302904564315	52	32	62.2	1	218	69	184	235	MBN1226214.1 TAXI family TRAP transporter solute-binding subunit [Deltaproteobacteria bacterium]	diamond	156	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30211395	30211395	PRJNA782235_P_NODE_25472_length_243_cov_0.905882_g25283_i0	PRJNA782235	25472	243	0.905882	2.20129326	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	141	2.1399999999999996e-37	NR	MFN0247680.1	2212474	g25283	i0	87.8	1.80246913580247	74	9	91.4	0	241	20	45	118	MFN0247680.1 class II glutamine amidotransferase [Kofleriaceae bacterium]	diamond	438	141	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30811848	30811848	PRJNA782235_P_NODE_15814_length_253_cov_1.355556_g15625_i0	PRJNA782235	15814	253	1.355556	3.42955668	Myxococcus vastator	2709664	Bacteria	Bacteria	56.6	3.86e-7	NR	WP_163778624.1	2709664	g15625	i0	44.2	1.82608695652174	77	41	91.3	2	252	22	37	111	WP_163778624.1 endonuclease/exonuclease/phosphatase family protein [Myxococcus vastator]	diamond	462	56.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus vastator
31570783	31570783	PRJNA782235_P_NODE_19336_length_249_cov_0.875000_g19147_i0	PRJNA782235	19336	249	0.875	2.17875	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	119	4.489999999999999e-31	NR	HZZ84940.1	2510643	g19147	i0	70.6	2.03614457831325	85	21	97.6	1	6	248	131	215	HZZ84940.1 outer membrane beta-barrel domain-containing protein [Anaeromyxobacteraceae bacterium]	diamond	507	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
32266805	32266805	PRJNA782235_P_NODE_23138_length_245_cov_0.895349_g22949_i0	PRJNA782235	23138	245	0.895349	2.19360505	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	85.9	1.9e-18	NR	MFN7698519.1	2026735	g22949	i0	55.1	1.91020408163265	78	35	95.5	0	238	5	11	88	MFN7698519.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	468	85.9	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);;