metadata: contig_metadata: 29 rows where bioproject = "PRJNA797475", tax_phylum = "Myxococcota" and tax

29 rows where bioproject = "PRJNA797475", 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
2492336	2492336	PRJNA797475_P_NODE_13742_length_290_cov_1.419355_g13643_i0	PRJNA797475	13742	290	1.419355	4.1161295	Archangiaceae bacterium	2684409	Bacteria	Bacteria	199	9.58e-62	NR	MBM4783721.1	2684409	g13643	i0	97.9	0.993103448275862	96	2	99.3	0	2	289	8	103	MBM4783721.1 alpha/beta fold hydrolase [Archangiaceae bacterium]	diamond	288	199	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
5884925	5884925	PRJNA797475_P_NODE_21965_length_251_cov_0.865169_g21866_i0	PRJNA797475	21965	251	0.865169	2.17157419	Myxococcota bacterium	2818507	Bacteria	Bacteria	118	6.67e-29	NR	MED5463391.1	2818507	g21866	i0	74.4	4.8406374501992	82	21	98	0	251	6	194	275	MED5463391.1 NAD(P)/FAD-dependent oxidoreductase [Myxococcota bacterium]	diamond	1215	118	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
7159796	7159796	PRJNA797475_P_NODE_24106_length_248_cov_0.880000_g24007_i0	PRJNA797475	24106	248	0.88	2.1824	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	174	4.59e-39	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g24007	i0	82.353	1.64112903225806	204	32	81	4	47	248	3916974	3917175	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	407	174	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15245375	15245375	PRJNA797475_P_NODE_25552_length_246_cov_1.780347_g25453_i0	PRJNA797475	25552	246	1.780347	4.37965362	Polyangia bacterium	3058050	Bacteria	Bacteria	102	4.429999999999999e-23	NR	HEX2659345.1	3058050	g25453	i0	59.3	6.97560975609756	91	27	98.8	1	4	246	381	471	HEX2659345.1 ATP-binding protein [Polyangia bacterium]	diamond	1716	102	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
16083927	16083927	PRJNA797475_P_NODE_21433_length_251_cov_0.865169_g21334_i0	PRJNA797475	21433	251	0.865169	2.17157419	Nannocystis punicea	2995304	Bacteria	Bacteria	217	7.619999999999999e-52	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g21334	i0	82.4	96.4741035856574	250	42	99	2	1	249	5377540	5377292	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	24215	217	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
17359829	17359829	PRJNA797475_P_NODE_24474_length_248_cov_0.880000_g24375_i0	PRJNA797475	24474	248	0.88	2.1824	Polyangium aurulentum	2567896	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g24375	i0	94.286	0.141129032258065	35	2	14	0	214	248	1923284	1923250	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	35	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
22458604	22458604	PRJNA797475_P_NODE_27098_length_245_cov_0.895349_g26999_i0	PRJNA797475	27098	245	0.895349	2.19360505	Archangium sp.	1872627	Bacteria	Bacteria	143	7.699999999999999e-38	NR	MBL8932930.1	1872627	g26999	i0	83.8	0.979591836734694	80	13	98	0	4	243	171	250	MBL8932930.1 DUF2723 domain-containing protein [Archangium sp.]	diamond	240	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
23734099	23734099	PRJNA797475_P_NODE_13959_length_289_cov_1.425926_g13860_i0	PRJNA797475	13959	289	1.425926	4.12092614	Pendulispora albinea	2741071	Bacteria	Bacteria	307	5.1700000000000007e-79	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g13860	i0	86.007	12.2283737024221	293	34	100	7	1	289	3589172	3589461	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	3534	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
25007747	25007747	PRJNA797475_P_NODE_17320_length_271_cov_1.994949_g17221_i0	PRJNA797475	17320	271	1.994949	5.40631179	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	149	1.84e-41	NR	MBI3535785.1	2026735	g17221	i0	81.1	14.9114391143911	90	17	99.6	0	270	1	236	325	MBI3535785.1 dihydrolipoyllysine-residue succinyltransferase [Deltaproteobacteria bacterium]	diamond	4041	149	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26683040	26683040	PRJNA797475_P_NODE_22121_length_250_cov_1.700565_g22022_i0	PRJNA797475	22121	250	1.700565	4.2514125	Archangium	47	Bacteria	Bacteria	158	1.0899999999999997e-42	NR	MBL8934431.1	1872627	g22022	i0	98.8	2.904	81	1	97.2	0	3	245	2025	2105	MBL8934431.1 HEAT repeat domain-containing protein [Archangium sp.]	diamond	726	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
27085576	27085576	PRJNA797475_P_NODE_21522_length_251_cov_0.865169_g21423_i0	PRJNA797475	21522	251	0.865169	2.17157419	Archangium gephyra	48	Bacteria	Bacteria	128	2.7499999999999996e-32	NR	PZR14009.1	48	g21423	i0	71.1	0.99203187250996006	83	24	99.2	0	1	249	132	214	PZR14009.1 MAG: hypothetical protein DI536_11880 [Archangium gephyra]	diamond	249	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
27654334	27654334	PRJNA797475_P_NODE_27924_length_244_cov_0.900585_g27825_i0	PRJNA797475	27924	244	0.900585	2.1974274	Archangiaceae bacterium	2684409	Bacteria	Bacteria	85.9	2.49e-17	NR	MBM4779275.1	2684409	g27825	i0	92.9	0.516393442622951	42	3	51.6	0	244	119	720	761	MBM4779275.1 glycogen/starch/alpha-glucan phosphorylase [Archangiaceae bacterium]	diamond	126	85.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
28285394	28285394	PRJNA797475_P_NODE_26206_length_246_cov_0.890173_g26107_i0	PRJNA797475	26206	246	0.890173	2.18982558	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	85.5	1.41e-18	NR	MBI1816798.1	2026735	g26107	i0	51.9	0.98780487804878	81	39	98.8	0	3	245	53	133	MBI1816798.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	243	85.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28484239	28484239	PRJNA797475_P_NODE_23446_length_249_cov_0.875000_g23347_i0	PRJNA797475	23446	249	0.875	2.17875	Myxococcales	29	Bacteria	Bacteria	126	7.18e-34	NR	MBL8936035.1	1872627	g23347	i0	95.7	1.66265060240964	69	3	83.1	0	207	1	1	69	MBL8936035.1 hypothetical protein [Archangium sp.]	diamond	414	126	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28633163	28633163	PRJNA797475_P_NODE_22567_length_250_cov_0.870056_g22468_i0	PRJNA797475	22567	250	0.870056	2.17514	Polyangiales bacterium	3034171	Bacteria	Bacteria	164	5.76e-45	NR	MFO0607353.1	3034171	g22468	i0	90.4	0.996	83	8	99.6	0	249	1	811	893	MFO0607353.1 hypothetical protein [Polyangiales bacterium]	diamond	249	164	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
28853762	28853762	PRJNA797475_P_NODE_10288_length_328_cov_1.207843_g10189_i0	PRJNA797475	10288	328	1.207843	3.96172504	Myxococcota bacterium	2818507	Bacteria	Bacteria	66.2	1.75e-10	NR	MEZ4270368.1	2818507	g10189	i0	53.1	1.31707317073171	49	23	44.8	0	320	174	43	91	MEZ4270368.1 DUF4215 domain-containing protein [Myxococcota bacterium]	diamond	432	66.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29526192	29526192	PRJNA797475_P_NODE_28570_length_243_cov_0.905882_g28471_i0	PRJNA797475	28570	243	0.905882	2.20129326	Myxococcales	29	Bacteria	Bacteria	154	1.87e-41	NR	MER2561465.1	2484252	g28471	i0	90	1.97530864197531	80	8	98.8	0	2	241	91	170	MER2561465.1 TIM-barrel domain-containing protein [Myxococcaceae bacterium]	diamond	480	155	0.993548387096774	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
29864329	29864329	PRJNA797475_P_NODE_16451_length_276_cov_1.482759_g16352_i0	PRJNA797475	16451	276	1.482759	4.09241484	Sorangium	39643	Bacteria	Bacteria	45.8	0.0044	NR	WP_207217895.1	39643	g16352	i0	35.3	0.923913043478261	85	51	92.4	2	2	256	170	250	WP_207217895.1 MULTISPECIES: AAA family ATPase [Sorangium]	diamond	255	45.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium
29959106	29959106	PRJNA797475_P_NODE_24251_length_248_cov_0.880000_g24152_i0	PRJNA797475	24251	248	0.88	2.1824	Labilithrix sp.	1971228	Bacteria	Bacteria	103	1.5899999999999999e-24	NR	MBX3233258.1	1971228	g24152	i0	58.7	0.907258064516129	75	31	90.7	0	226	2	144	218	MBX3233258.1 glycosyltransferase family 2 protein [Labilithrix sp.]	diamond	225	103	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30379327	30379327	PRJNA797475_P_NODE_19872_length_258_cov_1.664865_g19773_i0	PRJNA797475	19872	258	1.664865	4.2953517	Pseudomonadati	3379134	Bacteria	Bacteria	112	2.78e-28	NR	MCW5832353.1	1971228	g19773	i0	61.6	3.96511627906977	86	32	98.8	1	3	257	15	100	MCW5832353.1 hypothetical protein [Labilithrix sp.]	diamond	1023	112	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
31127769	31127769	PRJNA797475_P_NODE_16835_length_274_cov_1.343284_g16736_i0	PRJNA797475	16835	274	1.343284	3.68059816	Archangium sp.	1872627	Bacteria	Bacteria	124	1.57e-32	NR	MBL8937808.1	1872627	g16736	i0	92.4	0.722627737226277	66	5	72.3	0	3	200	242	307	MBL8937808.1 alpha/beta hydrolase [Archangium sp.]	diamond	198	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
31190984	31190984	PRJNA797475_P_NODE_26995_length_245_cov_0.895349_g26896_i0	PRJNA797475	26995	245	0.895349	2.19360505	Myxococcales bacterium	2026763	Bacteria	Bacteria	80.1	2.66e-15	NR	GMV42290.1	2026763	g26896	i0	61.4	0.697959183673469	57	22	69.8	0	239	69	683	739	GMV42290.1 MAG: hypothetical protein AMXMBFR64_40060 [Myxococcales bacterium]	diamond	171	80.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31728930	31728930	PRJNA797475_P_NODE_24557_length_248_cov_0.880000_g24458_i0	PRJNA797475	24557	248	0.88	2.1824	Polyangia bacterium	3058050	Bacteria	Bacteria	47.4	8.94e-4	NR	HSY40628.1	3058050	g24458	i0	35.6	1.70564516129032	73	41	81	1	4	204	76	148	HSY40628.1 cytochrome c biogenesis protein CcdA [Polyangia bacterium]	diamond	423	47.4	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31792065	31792065	PRJNA797475_P_NODE_19937_length_258_cov_1.270270_g19838_i0	PRJNA797475	19937	258	1.27027	3.2772966	Myxococcota bacterium	2818507	Bacteria	Bacteria	154	6.879999999999999e-43	NR	MCU0668550.1	2818507	g19838	i0	87.8	0.953488372093023	82	10	95.3	0	1	246	65	146	MCU0668550.1 hypothetical protein [Myxococcota bacterium]	diamond	246	154	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31918838	31918838	PRJNA797475_P_NODE_28777_length_243_cov_0.905882_g28678_i0	PRJNA797475	28777	243	0.905882	2.20129326	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	46.6	0.00162	NR	MBL8920338.1	2484252	g28678	i0	59.4	0.777777777777778	32	13	39.5	0	236	141	189	220	MBL8920338.1 hypothetical protein [Myxococcaceae bacterium]	diamond	189	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
32022882	32022882	PRJNA797475_P_NODE_2098_length_669_cov_3.578859_g2002_i0	PRJNA797475	2098	669	3.578859	23.94256671	Pseudomonadati	3379134	Bacteria	Bacteria	207	3.9e-64	NR	MDO8426395.1	2026735	g2002	i0	53.3	8.05381165919282	197	91	87.9	1	9	596	1	197	MDO8426395.1 NAD(P)H:quinone oxidoreductase [Deltaproteobacteria bacterium]	diamond	5388	209	0.990430622009569	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32045481	32045481	PRJNA797475_P_NODE_10618_length_323_cov_4.028000_g10519_i0	PRJNA797475	10618	323	4.028	13.01044	Myxococcota bacterium	2818507	Bacteria	Bacteria	90.5	3.9800000000000006e-21	NR	MEQ1507343.1	2818507	g10519	i0	50	0.910216718266254	98	42	87.3	2	19	300	1	95	MEQ1507343.1 hypothetical protein [Myxococcota bacterium]	diamond	294	90.5	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32235575	32235575	PRJNA797475_P_NODE_26398_length_245_cov_1.790698_g26299_i0	PRJNA797475	26398	245	1.790698	4.3872101	Myxococcota bacterium	2818507	Bacteria	Bacteria	52.8	9.16e-6	NR	MDP6979517.1	2818507	g26299	i0	29.6	1.57959183673469	81	57	99.2	0	245	3	60	140	MDP6979517.1 tetratricopeptide repeat protein [Myxococcota bacterium]	diamond	387	52.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32267073	32267073	PRJNA797475_P_NODE_24618_length_248_cov_0.880000_g24519_i0	PRJNA797475	24618	248	0.88	2.1824	Archangium sp.	1872627	Bacteria	Bacteria	146	4.11e-39	NR	MBL8938738.1	1872627	g24519	i0	98.8	0.967741935483871	80	1	96.8	0	240	1	1	80	MBL8938738.1 gamma-glutamyltransferase [Archangium sp.]	diamond	240	146	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.

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