metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax

29 rows where analysis = "diamond", bioproject = "PRJNA993416" 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
2548638	2548638	PRJNA993416_P_NODE_9562_length_278_cov_1.321951_g9457_i0	PRJNA993416	9562	278	1.321951	3.67502378	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	167	3.709999999999999e-47	NR	MCU0684499.1	2268199	g9457	i0	81.5	1.98561151079137	92	17	99.3	0	3	278	310	401	MCU0684499.1 SpoVR family protein [Polyangiaceae bacterium]	diamond	552	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
15300770	15300770	PRJNA993416_P_NODE_10612_length_268_cov_1.774359_g10507_i0	PRJNA993416	10612	268	1.774359	4.75528212	Labilithrix sp.	1971228	Bacteria	Bacteria	157	1.14e-44	NR	HEY8073128.1	1971228	g10507	i0	92	4.92537313432836	88	7	98.5	0	266	3	221	308	HEY8073128.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Labilithrix sp.]	diamond	1320	157	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
18827560	18827560	PRJNA993416_P_NODE_12895_length_250_cov_0.870056_g12790_i0	PRJNA993416	12895	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	132	4.54e-36	NR	HVI93339.1	1872521	g12790	i0	81.9	10.932	83	15	99.6	0	249	1	150	232	HVI93339.1 ABC transporter ATP-binding protein [Anaeromyxobacter sp.]	diamond	2733	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp.
23928335	23928335	PRJNA993416_P_NODE_13479_length_248_cov_0.880000_g13374_i0	PRJNA993416	13479	248	0.88	2.1824	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	137	1.18e-37	NR	MFO0677635.1	2268199	g13374	i0	84.1	0.991935483870968	82	13	99.2	0	3	248	53	134	MFO0677635.1 nucleoside triphosphate pyrophosphohydrolase [Polyangiaceae bacterium]	diamond	246	137	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
26931566	26931566	PRJNA993416_P_NODE_16142_length_241_cov_0.916667_g16037_i0	PRJNA993416	16142	241	0.916667	2.20916747	Pendulispora rubella	2741070	Bacteria	Bacteria	67	7.61e-11	NR	WP_394831340.1	2741070	g16037	i0	54.8	0.908713692946058	73	33	90.9	0	23	241	11	83	WP_394831340.1 phosphodiester glycosidase family protein [Pendulispora rubella]	diamond	219	67	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
27190275	27190275	PRJNA993416_P_NODE_13302_length_249_cov_0.875000_g13197_i0	PRJNA993416	13302	249	0.875	2.17875	Polyangium	55	Bacteria	Bacteria	101	1.0199999999999999e-23	NR	WP_338046634.1	889282	g13197	i0	63.3	5.55421686746988	79	25	95.2	1	247	11	12	86	WP_338046634.1 fatty acid desaturase [Polyangium spumosum]	diamond	1383	101	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium spumosum
27374484	27374484	PRJNA993416_P_NODE_10083_length_273_cov_1.540000_g9978_i0	PRJNA993416	10083	273	1.54	4.2042	Myxococcales bacterium	2026763	Bacteria	Bacteria	70.9	7.03e-12	NR	MBK9001546.1	2026763	g9978	i0	45.5	1.96703296703297	88	47	96.7	1	1	264	92	178	MBK9001546.1 AAA family ATPase [Myxococcales bacterium]	diamond	537	70.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27374486	27374486	PRJNA993416_P_NODE_15363_length_243_cov_0.905882_g15258_i0	PRJNA993416	15363	243	0.905882	2.20129326	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	85.9	1.19e-17	NR	HEY8040359.1	2268199	g15258	i0	53.8	1.82716049382716	80	37	98.8	0	240	1	80	159	HEY8040359.1 hypothetical protein [Polyangiaceae bacterium]	diamond	444	85.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27443538	27443538	PRJNA993416_P_NODE_15663_length_242_cov_1.366864_g15558_i0	PRJNA993416	15663	242	1.366864	3.30781088	Pseudomonadati	3379134	Bacteria	Bacteria	73.9	3.69e-13	NR	MCX5862307.1	2026735	g15558	i0	51.4	1.83471074380165	72	35	89.3	0	17	232	68	139	MCX5862307.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	444	74.3	0.994616419919246	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27626935	27626935	PRJNA993416_P_NODE_4224_length_409_cov_2.020833_g4119_i0	PRJNA993416	4224	409	2.020833	8.26520697	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	58.9	5.4e-7	NR	NOZ87056.1	2026735	g4119	i0	32.1	1.73838630806846	112	62	72.6	3	64	360	1295	1405	NOZ87056.1 glycosyltransferase [Deltaproteobacteria bacterium]	diamond	711	58.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27690287	27690287	PRJNA993416_P_NODE_12584_length_251_cov_0.865169_g12479_i0	PRJNA993416	12584	251	0.865169	2.17157419	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	84	6.64e-19	NR	MEO6573287.1	2268199	g12479	i0	58.1	0.741035856573705	62	26	74.1	0	219	34	38	99	MEO6573287.1 hypothetical protein [Polyangiaceae bacterium]	diamond	186	84	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28037324	28037324	PRJNA993416_P_NODE_13265_length_249_cov_0.875000_g13160_i0	PRJNA993416	13265	249	0.875	2.17875	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	63.9	1.34e-9	NR	MEO6418451.1	2268199	g13160	i0	39	0.927710843373494	77	47	92.8	0	244	14	556	632	MEO6418451.1 PrsW family intramembrane metalloprotease [Polyangiaceae bacterium]	diamond	231	63.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28226389	28226389	PRJNA993416_P_NODE_15166_length_244_cov_0.900585_g15061_i0	PRJNA993416	15166	244	0.900585	2.1974274	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	72.8	9.67e-13	NR	MFO0613787.1	2268199	g15061	i0	50.6	0.971311475409836	79	39	97.1	0	239	3	61	139	MFO0613787.1 serine/threonine-protein kinase [Polyangiaceae bacterium]	diamond	237	72.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28384501	28384501	PRJNA993416_P_NODE_14766_length_245_cov_0.895349_g14661_i0	PRJNA993416	14766	245	0.895349	2.19360505	Polyangia bacterium	3058050	Bacteria	Bacteria	129	6.29e-34	NR	MEO6952509.1	3058050	g14661	i0	76.5	0.991836734693878	81	19	99.2	0	243	1	31	111	MEO6952509.1 pyridoxal phosphate-dependent aminotransferase [Polyangia bacterium]	diamond	243	129	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28447861	28447861	PRJNA993416_P_NODE_10766_length_267_cov_1.438144_g10661_i0	PRJNA993416	10766	267	1.438144	3.83984448	Polyangia bacterium	3058050	Bacteria	Bacteria	82.8	3.46e-16	NR	HEY4393031.1	3058050	g10661	i0	53.9	1	89	38	100	1	267	1	196	281	HEY4393031.1 hypothetical protein [Polyangia bacterium]	diamond	267	82.8	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28605556	28605556	PRJNA993416_P_NODE_14247_length_246_cov_0.890173_g14142_i0	PRJNA993416	14247	246	0.890173	2.18982558	Myxococcales bacterium	2026763	Bacteria	Bacteria	68.2	2.97e-11	NR	MCA9517574.1	2026763	g14142	i0	45	0.975609756097561	80	44	97.6	0	4	243	226	305	MCA9517574.1 DnaJ domain-containing protein [Myxococcales bacterium]	diamond	240	68.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28668844	28668844	PRJNA993416_P_NODE_13267_length_249_cov_0.875000_g13162_i0	PRJNA993416	13267	249	0.875	2.17875	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	74.7	7.26e-14	NR	HSQ67167.1	2268199	g13162	i0	64.7	0.614457831325301	51	18	61.4	0	95	247	1	51	HSQ67167.1 hypothetical protein [Polyangiaceae bacterium]	diamond	153	74.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28953126	28953126	PRJNA993416_P_NODE_12548_length_251_cov_0.865169_g12443_i0	PRJNA993416	12548	251	0.865169	2.17157419	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	137	1.58e-35	NR	MCC6648970.1	2268199	g12443	i0	79.5	0.99203187250996006	83	17	99.2	0	2	250	791	873	MCC6648970.1 BamA/TamA family outer membrane protein [Polyangiaceae bacterium]	diamond	249	137	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28984711	28984711	PRJNA993416_P_NODE_7328_length_306_cov_0.948498_g7223_i0	PRJNA993416	7328	306	0.948498	2.90240388	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	70.5	1.34e-11	NR	MCC6952669.1	2026735	g7223	i0	35.5	3.17647058823529	93	60	91.2	0	21	299	107	199	MCC6952669.1 PcfJ domain-containing protein [Deltaproteobacteria bacterium]	diamond	972	70.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29432078	29432078	PRJNA993416_P_NODE_5009_length_373_cov_1.283333_g4904_i0	PRJNA993416	5009	373	1.283333	4.78683209	Archangium	47	Bacteria	Bacteria	107	5.62e-26	NR	MFT3710687.1	1872627	g4904	i0	43	2.05898123324397	128	59	96.5	3	366	7	88	209	MFT3710687.1 histidine phosphatase family protein [Archangium sp.]	diamond	768	107	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
29995067	29995067	PRJNA993416_P_NODE_12851_length_250_cov_0.870056_g12746_i0	PRJNA993416	12851	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	68.9	2.41e-11	NR	WP_159397028.1	56	g12746	i0	52.1	0.852	71	34	85.2	0	3	215	1148	1218	WP_159397028.1 DEAD/DEAH box helicase [Sorangium cellulosum]	diamond	213	68.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
30279635	30279635	PRJNA993416_P_NODE_15112_length_244_cov_0.900585_g15007_i0	PRJNA993416	15112	244	0.900585	2.1974274	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	136	3.1e-36	NR	MBN8538930.1	2026735	g15007	i0	91.4	1.97950819672131	81	7	99.6	0	2	244	152	232	MBN8538930.1 TolC family protein [Deltaproteobacteria bacterium]	diamond	483	136	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31163637	31163637	PRJNA993416_P_NODE_15835_length_242_cov_0.911243_g15730_i0	PRJNA993416	15835	242	0.911243	2.20520806	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	70.5	1.11e-12	NR	HSQ63708.1	2268199	g15730	i0	58.2	0.681818181818182	55	23	68.2	0	241	77	147	201	HSQ63708.1 hypothetical protein [Polyangiaceae bacterium]	diamond	165	70.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31258772	31258772	PRJNA993416_P_NODE_6515_length_326_cov_3.367589_g6410_i0	PRJNA993416	6515	326	3.367589	10.97834014	Myxococcales bacterium	2026763	Bacteria	Bacteria	45.8	0.00754	NR	MDH3212708.1	2026763	g6410	i0	31.9	1.84049079754601	113	61	94.8	6	313	5	209	315	MDH3212708.1 hypothetical protein [Myxococcales bacterium]	diamond	600	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31512004	31512004	PRJNA993416_P_NODE_9456_length_279_cov_1.368932_g9351_i0	PRJNA993416	9456	279	1.368932	3.81932028	Labilithrix sp.	1971228	Bacteria	Bacteria	85.1	6.78e-17	NR	HEY8076987.1	1971228	g9351	i0	51.8	1.82795698924731	85	41	91.4	0	259	5	386	470	HEY8076987.1 hypothetical protein [Labilithrix sp.]	diamond	510	85.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
32271177	32271177	PRJNA993416_P_NODE_9718_length_277_cov_1.073529_g9613_i0	PRJNA993416	9718	277	1.073529	2.97367533	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	147	1.27e-40	NR	MBI3554712.1	2026735	g9613	i0	89	0.985559566787004	91	10	98.6	0	5	277	178	268	MBI3554712.1 efflux RND transporter permease subunit [Deltaproteobacteria bacterium]	diamond	273	147	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32429350	32429350	PRJNA993416_P_NODE_11659_length_258_cov_1.632432_g11554_i0	PRJNA993416	11659	258	1.632432	4.21167456	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	112	1.17e-28	NR	HEY2370146.1	2268199	g11554	i0	73.4	1.83720930232558	79	21	91.9	0	18	254	16	94	HEY2370146.1 PEGA domain-containing protein [Polyangiaceae bacterium]	diamond	474	112	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32461012	32461012	PRJNA993416_P_NODE_11199_length_263_cov_1.215789_g11094_i0	PRJNA993416	11199	263	1.215789	3.19752507	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	69.3	1.18e-11	NR	MCB9030029.1	2026735	g11094	i0	37.5	0.91254752851711	80	49	91.3	1	18	257	121	199	MCB9030029.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	240	69.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32498631	32498631	PRJNA993416_P_NODE_12459_length_251_cov_0.865169_g12354_i0	PRJNA993416	12459	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	113	2.46e-27	NR	MBK7069152.1	2026735	g12354	i0	70.8	3.38247011952191	72	21	86.1	0	249	34	377	448	MBK7069152.1 transposase [Deltaproteobacteria bacterium]	diamond	849	113	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);;