metadata: contig_metadata: 12 rows where bioproject = "PRJNA478247", tax_phylum = "Myxococcota" and tax

12 rows where bioproject = "PRJNA478247", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
27724549	27724549	PRJNA478247_P_NODE_924_length_430_cov_2.875312_g818_i0	PRJNA478247	924	430	2.875312	12.3638416	Polyangiales	3031712	Bacteria	Bacteria	124	1.37e-32	NR	MBV8758597.1	2026735	g818	i0	47.4	5.67906976744186	135	68	93.5	3	405	4	4	136	MBV8758597.1 glutathione S-transferase family protein [Deltaproteobacteria bacterium]	diamond	2442	125	0.992	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27992361	27992361	PRJNA478247_P_NODE_5_length_3562_cov_11.818002_g4_i0	PRJNA478247	5	3562	11.818002	420.95723124	Archangium sp.	1872627	Bacteria	Bacteria	96.7	6e-16	NR	MBL8914003.1	1872627	g4	i0	23.1	0.851487928130264	1011	515	67.6	44	951	3359	267	1223	MBL8914003.1 hypothetical protein [Archangium sp.]	diamond	3033	96.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28371090	28371090	PRJNA478247_P_NODE_6_length_3554_cov_12.257305_g4_i1	PRJNA478247	6	3554	12.257305	435.6246197	Archangium sp.	1872627	Bacteria	Bacteria	86.3	9.05e-13	NR	MBL8914003.1	1872627	g4	i1	23.5	0.763083849184018	904	453	60.4	40	951	3095	267	1120	MBL8914003.1 hypothetical protein [Archangium sp.]	diamond	2712	86.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28402727	28402727	PRJNA478247_P_NODE_66_length_1768_cov_10.338125_g4_i3	PRJNA478247	66	1768	10.338125	182.77805	Myxococcales bacterium	2026763	Bacteria	Bacteria	60.5	1.62e-5	NR	HUB08957.1	2026763	g4	i3	28.1	0.568438914027149	335	161	51.2	19	810	1715	99	386	HUB08957.1 hypothetical protein [Myxococcales bacterium]	diamond	1005	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28623924	28623924	PRJNA478247_P_NODE_7_length_3550_cov_12.614030_g4_i2	PRJNA478247	7	3550	12.61403	447.798065	Archangium sp.	1872627	Bacteria	Bacteria	95.5	1.21e-15	NR	MBL8940874.1	1872627	g4	i2	25	0.500281690140845	592	348	48	23	1353	3056	84	603	MBL8940874.1 hypothetical protein [Archangium sp.]	diamond	1776	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
29192183	29192183	PRJNA478247_P_NODE_1409_length_320_cov_1.580756_g1303_i0	PRJNA478247	1409	320	1.580756	5.0584192	Myxococcus dinghuensis	2906761	Bacteria	Bacteria	49.3	4.38e-4	NR	WP_253970464.1	2906761	g1303	i0	44.2	0.80625	43	24	40.3	0	1	129	283	325	WP_253970464.1 tectonin domain-containing protein [Myxococcus dinghuensis]	diamond	258	49.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus dinghuensis
29318277	29318277	PRJNA478247_P_NODE_1729_length_274_cov_3.085714_g1623_i0	PRJNA478247	1729	274	3.085714	8.45485636	Nannocystis exedens	54	Bacteria	Bacteria	57.4	3.67e-7	NR	WP_245913943.1	54	g1623	i0	59.5	0.91970802919708	42	11	39.4	1	73	180	368	409	WP_245913943.1 hypothetical protein [Nannocystis exedens]	diamond	252	57.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
29428963	29428963	PRJNA478247_P_NODE_2029_length_244_cov_3.027907_g1923_i0	PRJNA478247	2029	244	3.027907	7.38809308	Nannocystis	53	Bacteria	Bacteria	50.4	7.06e-5	NR	WP_245913943.1	54	g1923	i0	61.1	2.25	36	8	36.9	1	172	83	368	403	WP_245913943.1 hypothetical protein [Nannocystis exedens]	diamond	549	50.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
30424235	30424235	PRJNA478247_P_NODE_233_length_1028_cov_3.073073_g177_i0	PRJNA478247	233	1028	3.073073	31.59119044	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	50.1	0.0128	NR	MEZ4302001.1	2268199	g177	i0	38.4	0.501945525291829	86	20	25.1	3	395	652	524	576	MEZ4302001.1 isopeptide-forming domain-containing fimbrial protein [Polyangiaceae bacterium]	diamond	516	50.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30708122	30708122	PRJNA478247_P_NODE_3014_length_177_cov_2.020270_g2908_i0	PRJNA478247	3014	177	2.02027	3.5758779	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52	8.27e-6	NR	MDF1564400.1	2026735	g2908	i0	47.4	1.76271186440678	57	27	93.2	2	173	9	101	156	MDF1564400.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	312	52	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32384166	32384166	PRJNA478247_P_NODE_219_length_1060_cov_2.521823_g164_i0	PRJNA478247	219	1060	2.521823	26.7313238	Myxococcota bacterium	2818507	Bacteria	Bacteria	60.5	8.43e-6	NR	MCK6571135.1	2818507	g164	i0	24.4	1.07830188679245	381	187	94.2	18	15	1013	1464	1791	MCK6571135.1 hypothetical protein [Myxococcota bacterium]	diamond	1143	60.5	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32384167	32384167	PRJNA478247_P_NODE_2339_length_219_cov_1.321053_g2233_i0	PRJNA478247	2339	219	1.321053	2.89310607	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	93.6	1.15e-20	NR	MBS1110927.1	2510643	g2233	i0	56.9	2.95890410958904	72	27	98.6	1	4	219	41	108	MBS1110927.1 domain protein beta Propeller [Anaeromyxobacteraceae bacterium]	diamond	648	93.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae 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);;