metadata: contig_metadata: 36 rows where bioproject = "PRJEB39269" and tax

36 rows where bioproject = "PRJEB39269" 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
57138	57138	PRJEB39269_P_NODE_81481_length_158_cov_1.033613_g81076_i0	PRJEB39269	81481	158	1.033613	1.63310854	Myxococcales	29	Bacteria	Bacteria	60.8	2.82e-9	NR	HEY0881086.1	1872627	g81076	i0	64.7	3.81645569620253	51	18	96.8	0	156	4	190	240	HEY0881086.1 3-oxoacyl-[acyl-carrier-protein] reductase [Archangium sp.]	diamond	603	60.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
2264535	2264535	PRJEB39269_P_NODE_37942_length_223_cov_2.831522_g37537_i0	PRJEB39269	37942	223	2.831522	6.31429406	root	1	Root_unresolved	Root_unresolved	228	3.0599999999999992e-55	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g37537	i0	85.398	232.991031390135	226	26	100	6	1	223	1181	1402	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	51957	230	0.991304347826087	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7366847	7366847	PRJEB39269_P_NODE_75966_length_162_cov_1.284553_g75561_i0	PRJEB39269	75966	162	1.284553	2.08097586	Archangium	47	Bacteria	Bacteria	261	2.06e-65	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g75561	i0	95.679	228.456790123457	162	7	100	0	1	162	5101532	5101371	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	37010	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
11535232	11535232	PRJEB39269_P_NODE_31730_length_245_cov_5.645631_g31325_i0	PRJEB39269	31730	245	5.645631	13.83179595	Sorangium cellulosum	56	Bacteria	Bacteria	231	2.65e-56	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g31325	i0	84.064	56.2897959183673	251	28	99	11	2	245	4849444	4849689	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	13791	231	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16633913	16633913	PRJEB39269_P_NODE_51434_length_191_cov_2.756579_g51029_i0	PRJEB39269	51434	191	2.756579	5.26506589	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	176	9.34e-40	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g51029	i0	84.324	96.8848167539267	185	23	96	4	1	183	1549577	1549397	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	18505	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
16633922	16633922	PRJEB39269_P_NODE_64534_length_172_cov_1.827068_g64129_i0	PRJEB39269	64534	172	1.827068	3.14255696	Nannocystis sp.	1962667	Bacteria	Bacteria	248	1.71e-61	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g64129	i0	92.529	2.01744186046512	174	11	100	2	1	172	18	191	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	347	248	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
17567129	17567129	PRJEB39269_P_NODE_8874_length_465_cov_3.826291_g8476_i0	PRJEB39269	8874	465	3.826291	17.79225315	Polyangiaceae	49	Bacteria	Bacteria	616	1.2799999999999996e-171	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g8476	i0	90.538	162.387096774194	465	44	100	0	1	465	11965039	11964575	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	75510	621	0.99194847020934	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17908658	17908658	PRJEB39269_P_NODE_15395_length_357_cov_8.069182_g14990_i0	PRJEB39269	15395	357	8.069182	28.80697974	Sorangium cellulosum	56	Bacteria	Bacteria	361	4.94e-95	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g14990	i0	85.165	74.7114845938375	364	40	99	12	1	356	4849801	4849444	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	26672	361	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23009153	23009153	PRJEB39269_P_NODE_85439_length_154_cov_2.991304_g85034_i0	PRJEB39269	85439	154	2.991304	4.60660816	Labilithrix luteola	1391654	Bacteria	Bacteria	119	1.23e-22	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g85034	i0	82.353	0.883116883116883	136	24	88	0	19	154	8372064	8371929	Labilithrix luteola strain DSM 27648, complete genome	blastn	136	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24282840	24282840	PRJEB39269_P_NODE_46160_length_202_cov_1.141104_g45755_i0	PRJEB39269	46160	202	1.141104	2.30503008	Chondromyces crocatus	52	Bacteria	Bacteria	178	2.7799999999999993e-40	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g45755	i0	89.437	97.0148514851485	142	14	70	1	1	141	2685	2826	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	19597	178	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
26716398	26716398	PRJEB39269_P_NODE_29441_length_256_cov_1.502304_g29036_i0	PRJEB39269	29441	256	1.502304	3.84589824	Polyangium fumosum	889272	Bacteria	Bacteria	72.4	1.13e-13	NR	WP_136935045.1	889272	g29036	i0	61.5	1.21875	52	20	60.9	0	254	99	111	162	WP_136935045.1 hypothetical protein [Polyangium fumosum]	diamond	312	72.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium fumosum
26875430	26875430	PRJEB39269_P_NODE_5501_length_573_cov_5.741573_g5138_i0	PRJEB39269	5501	573	5.741573	32.89921329	Myxococcales bacterium	2026763	Bacteria	Bacteria	48.5	0.00223	NR	HTO98605.1	2026763	g5138	i0	31.1	0.554973821989529	106	51	48.7	4	552	274	33	129	HTO98605.1 Hsp20/alpha crystallin family protein [Myxococcales bacterium]	diamond	318	48.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27317983	27317983	PRJEB39269_P_NODE_66783_length_170_cov_3.091603_g66378_i0	PRJEB39269	66783	170	3.091603	5.2557251	Myxococcales bacterium 68-2	2026763	Bacteria	Bacteria	45.8	1.07e-4	NR	OJY30211.1	1895795	g66378	i0	52.9	0.9	51	22	90	1	169	17	2	50	OJY30211.1 MAG: hypothetical protein BGO98_26080 [Myxococcales bacterium 68-20]	diamond	153	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium 68-20
27602230	27602230	PRJEB39269_P_NODE_70564_length_167_cov_2.351562_g70159_i0	PRJEB39269	70564	167	2.351562	3.92710854	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	55.5	1.64e-8	NR	HVZ31771.1	2268199	g70159	i0	52.2	0.826347305389222	46	22	82.6	0	30	167	5	50	HVZ31771.1 hypothetical protein [Polyangiaceae bacterium]	diamond	138	55.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27602232	27602232	PRJEB39269_P_NODE_79024_length_159_cov_2.916667_g78619_i0	PRJEB39269	79024	159	2.916667	4.63750053	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	45.4	7.33e-4	NR	MDB5217040.1	2484252	g78619	i0	62.5	0.452830188679245	24	9	45.3	0	151	80	137	160	MDB5217040.1 hypothetical protein [Myxococcaceae bacterium]	diamond	72	45.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27690565	27690565	PRJEB39269_P_NODE_59544_length_179_cov_1.171429_g59139_i0	PRJEB39269	59544	179	1.171429	2.09685791	Pseudomonadati	3379134	Bacteria	Bacteria	60.5	2.13e-10	NR	HXS18576.1	2268199	g59139	i0	100	5.16201117318436	28	0	46.9	0	3	86	40	67	HXS18576.1 DUF3612 domain-containing protein [Polyangiaceae bacterium]	diamond	924	60.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27753551	27753551	PRJEB39269_P_NODE_51764_length_191_cov_1.335526_g51359_i0	PRJEB39269	51764	191	1.335526	2.55085466	Pseudomonadati	3379134	Bacteria	Bacteria	86.7	2.52e-19	NR	MBI1997099.1	2026735	g51359	i0	57.1	9.95811518324607	63	27	99	0	1	189	109	171	MBI1997099.1 archaemetzincin family Zn-dependent metalloprotease [Deltaproteobacteria bacterium]	diamond	1902	87.4	0.991990846681922	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28012695	28012695	PRJEB39269_P_NODE_32085_length_244_cov_1.800000_g31680_i0	PRJEB39269	32085	244	1.8	4.392	Myxococcota bacterium	2818507	Bacteria	Bacteria	65.9	2.46e-10	NR	MEN8183890.1	2818507	g31680	i0	43.9	3.87295081967213	66	37	81.1	0	202	5	1	66	MEN8183890.1 aromatic ring-hydroxylating dioxygenase subunit alpha [Myxococcota bacterium]	diamond	945	65.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28107126	28107126	PRJEB39269_P_NODE_89265_length_151_cov_3.321429_g88860_i0	PRJEB39269	89265	151	3.321429	5.01535779	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	87	2.4e-18	NR	MDB5214851.1	2484252	g88860	i0	85.7	0.973509933774834	49	7	97.4	0	1	147	382	430	MDB5214851.1 hypothetical protein [Myxococcaceae bacterium]	diamond	147	87	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28201759	28201759	PRJEB39269_P_NODE_46026_length_202_cov_1.668712_g45621_i0	PRJEB39269	46026	202	1.668712	3.37079824	Byssovorax sp.	2927945	Bacteria	Bacteria	77.4	2.77e-16	NR	MFS8064965.1	2927945	g45621	i0	57.9	0.846534653465347	57	24	84.7	0	31	201	62	118	MFS8064965.1 hypothetical protein [Byssovorax sp.]	diamond	171	77.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Byssovorax	Byssovorax sp.
28264931	28264931	PRJEB39269_P_NODE_8526_length_474_cov_1.494253_g8128_i0	PRJEB39269	8526	474	1.494253	7.08275922	Archangium sp.	1872627	Bacteria	Bacteria	63.9	1.46e-8	NR	MDP2270461.1	1872627	g8128	i0	37.6	0.740506329113924	117	61	72.8	3	458	114	271	377	MDP2270461.1 serine protease [Archangium sp.]	diamond	351	63.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
28612461	28612461	PRJEB39269_P_NODE_64427_length_172_cov_2.240602_g64022_i0	PRJEB39269	64427	172	2.240602	3.85383544	Myxococcota bacterium	2818507	Bacteria	Bacteria	94	8.709999999999999e-23	NR	MEO1482256.1	2818507	g64022	i0	79.6	1.67441860465116	49	10	85.5	0	148	2	3	51	MEO1482256.1 GCN5 family acetyltransferase [Myxococcota bacterium]	diamond	288	94	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28770239	28770239	PRJEB39269_P_NODE_89327_length_151_cov_2.866071_g88922_i0	PRJEB39269	89327	151	2.866071	4.32776721	Labilithrix sp.	1971228	Bacteria	Bacteria	75.9	7.97e-15	NR	HEY8079817.1	1971228	g88922	i0	52.7	2.94039735099338	74	11	99.3	1	150	1	12	85	HEY8079817.1 uracil phosphoribosyltransferase [Labilithrix sp.]	diamond	444	75.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
29054606	29054606	PRJEB39269_P_NODE_40108_length_217_cov_1.449438_g39703_i0	PRJEB39269	40108	217	1.449438	3.14528046	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	44.3	0.00707	NR	HEY5147220.1	2268199	g39703	i0	38.7	0.857142857142857	62	37	84.3	1	188	6	85	146	HEY5147220.1 LD-carboxypeptidase [Polyangiaceae bacterium]	diamond	186	44.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30001914	30001914	PRJEB39269_P_NODE_14711_length_366_cov_1.697248_g14306_i0	PRJEB39269	14711	366	1.697248	6.21192768	Cystobacter fuscus	43	Bacteria	Bacteria	119	1.11e-29	NR	WNG16887.1	43	g14306	i0	57.3	1.45901639344262	89	38	73	0	2	268	259	347	WNG16887.1 alpha/beta hydrolase [Cystobacter fuscus]	diamond	534	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
30191205	30191205	PRJEB39269_P_NODE_67612_length_170_cov_2.419847_g67207_i0	PRJEB39269	67612	170	2.419847	4.1137399	Labilithrix sp.	1971228	Bacteria	Bacteria	47	4.41e-4	NR	MDB4933499.1	1971228	g67207	i0	80.8	0.458823529411765	26	5	45.9	0	2	79	386	411	MDB4933499.1 peroxidase [Labilithrix sp.]	diamond	78	47	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30222841	30222841	PRJEB39269_P_NODE_29032_length_258_cov_1.123288_g28627_i0	PRJEB39269	29032	258	1.123288	2.89808304	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	72.4	1.6e-12	NR	HVP66227.1	2510643	g28627	i0	50	1.7906976744186	82	37	95.3	1	3	248	464	541	HVP66227.1 PKD domain-containing protein [Anaeromyxobacteraceae bacterium]	diamond	462	72.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
30254812	30254812	PRJEB39269_P_NODE_67092_length_170_cov_2.770992_g66687_i0	PRJEB39269	67092	170	2.770992	4.7106864	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	43.5	0.00747	NR	MDB5218906.1	2484252	g66687	i0	76.9	0.458823529411765	26	6	45.9	0	93	170	126	151	MDB5218906.1 hypothetical protein [Myxococcaceae bacterium]	diamond	78	43.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
30412793	30412793	PRJEB39269_P_NODE_88393_length_152_cov_1.548673_g87988_i0	PRJEB39269	88393	152	1.548673	2.35398296	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	77.4	4.16e-16	NR	MBI3758952.1	2026735	g87988	i0	68	0.986842105263158	50	16	98.7	0	3	152	34	83	MBI3758952.1 TolC family protein [Deltaproteobacteria bacterium]	diamond	150	77.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30943174	30943174	PRJEB39269_P_NODE_67314_length_170_cov_2.625954_g66909_i0	PRJEB39269	67314	170	2.625954	4.4641218	Bacteria	2	Bacteria	Bacteria	54.3	1.13e-6	NR	MEA2750805.1	2026763	g66909	i0	100	1.83529411764706	26	0	45.9	0	169	92	62	87	MEA2750805.1 PmbA protein [Myxococcales bacterium]	diamond	312	54.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31201939	31201939	PRJEB39269_P_NODE_60015_length_178_cov_1.525180_g59610_i0	PRJEB39269	60015	178	1.52518	2.7148204	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	73.9	1.58e-13	NR	HLK39604.1	2268199	g59610	i0	64.3	1.90449438202247	56	20	94.4	0	178	11	6	61	HLK39604.1 MupA/Atu3671 family FMN-dependent luciferase-like monooxygenase [Polyangiaceae bacterium]	diamond	339	73.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31265644	31265644	PRJEB39269_P_NODE_41455_length_213_cov_2.252874_g41050_i0	PRJEB39269	41455	213	2.252874	4.79862162	Myxococcales bacterium	2026763	Bacteria	Bacteria	70.5	2.22e-13	NR	HKC58682.1	2026763	g41050	i0	50	0.985915492957746	70	35	98.6	0	211	2	20	89	HKC58682.1 hypothetical protein [Myxococcales bacterium]	diamond	210	70.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31328876	31328876	PRJEB39269_P_NODE_52496_length_190_cov_0.894040_g52091_i0	PRJEB39269	52496	190	0.89404	1.698676	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42	0.0351	NR	MBA2320376.1	2026735	g52091	i0	51.4	0.58421052631579	37	17	56.8	1	49	156	205	241	MBA2320376.1 IMP dehydrogenase [Deltaproteobacteria bacterium]	diamond	111	42	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31708438	31708438	PRJEB39269_P_NODE_90837_length_150_cov_2.270270_g90432_i0	PRJEB39269	90837	150	2.27027	3.405405	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	44.3	0.00307	NR	MDB5212839.1	2484252	g90432	i0	87.5	0.48	24	3	48	0	79	150	21	44	MDB5212839.1 Serine/threonine kinase [Myxococcaceae bacterium]	diamond	72	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
31828201	31828201	PRJEB39269_P_NODE_80457_length_158_cov_3.151261_g80052_i0	PRJEB39269	80457	158	3.151261	4.97899238	Bacteria	2	Bacteria	Bacteria	46.2	6.98e-4	NR	MEA2750603.1	2026763	g80052	i0	88	0.949367088607595	25	3	47.5	0	76	2	502	526	MEA2750603.1 uncharacterized protein [Myxococcales bacterium]	diamond	150	46.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32088084	32088084	PRJEB39269_P_NODE_66638_length_170_cov_3.267176_g66233_i0	PRJEB39269	66638	170	3.267176	5.5541992	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	49.7	4.8e-5	NR	MBI2605272.1	2026735	g66233	i0	80.8	0.917647058823529	26	5	45.9	0	79	2	21	46	MBI2605272.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium]	diamond	156	49.7	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);;