metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

34 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
426491	426491	PRJNA429937_P_NODE_31941_length_643_cov_2.263844_g19549_i0	PRJNA429937	31941	643	2.263844	14.55651692	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	141	1.33e-28	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g19549	i0	74.214	44.5303265940902	318	70	48	10	333	643	3054321	3054633	Anaeromyxobacter oryzae DNA, complete genome	blastn	28633	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
1700993	1700993	PRJNA429937_P_NODE_17982_length_867_cov_9.572792_g10647_i0	PRJNA429937	17982	867	9.572792	82.99610664	Labilithrix luteola	1391654	Bacteria	Bacteria	1147	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10647	i0	91.187	125.956170703576	851	65	97	8	23	867	3941757	3942603	Labilithrix luteola strain DSM 27648, complete genome	blastn	109204	1147	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1701770	1701770	PRJNA429937_P_NODE_52382_length_487_cov_3.502183_g32814_i1	PRJNA429937	52382	487	3.502183	17.05563121	Pendulispora albinea	2741071	Bacteria	Bacteria	60.2	2.84e-4	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g32814	i1	97.143	0.0718685831622177	35	1	7	0	35	69	8579681	8579715	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	35	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
1701848	1701848	PRJNA429937_P_NODE_56642_length_464_cov_3.045977_g37731_i0	PRJNA429937	56642	464	3.045977	14.13333328	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	405	3e-108	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g37731	i0	90.554	40.25	307	28	81	1	3	309	1384581	1384886	Anaeromyxobacter paludicola DNA, complete genome	blastn	18676	405	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
3638363	3638363	PRJNA429937_P_NODE_131023_length_222_cov_42.341969_g108396_i0	PRJNA429937	131023	222	42.341969	93.99917118	Myxococcia	32015	Bacteria	Bacteria	276	1.07e-69	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g108396	i0	89.545	232.527027027027	220	19	98	4	5	222	3489848	3490065	Sorangium cellulosum 'So ce 56' complete genome	blastn	51621	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5529377	5529377	PRJNA429937_P_NODE_116165_length_258_cov_2.803493_g93539_i0	PRJNA429937	116165	258	2.803493	7.23301194	Labilithrix luteola	1391654	Bacteria	Bacteria	174	4.7999999999999997e-39	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g93539	i0	79.31	8.04651162790698	261	44	99	6	3	258	9585699	9585444	Labilithrix luteola strain DSM 27648, complete genome	blastn	2076	174	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5529776	5529776	PRJNA429937_P_NODE_157485_length_155_cov_1.642857_g134858_i0	PRJNA429937	157485	155	1.642857	2.54642835	Labilithrix luteola	1391654	Bacteria	Bacteria	165	1.57e-36	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g134858	i0	85.987	5	157	18	100	4	1	155	8190288	8190442	Labilithrix luteola strain DSM 27648, complete genome	blastn	775	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6804734	6804734	PRJNA429937_P_NODE_56626_length_464_cov_3.411494_g32814_i4	PRJNA429937	56626	464	3.411494	15.82933216	Polyangium aurulentum	2567896	Bacteria	Bacteria	78.7	7.44e-10	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g32814	i4	95.918	4.5301724137931	49	0	12	2	409	456	2547969	2548016	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	2102	78.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
6805384	6805384	PRJNA429937_P_NODE_92466_length_325_cov_3.618243_g69880_i0	PRJNA429937	92466	325	3.618243	11.75928975	Sorangium cellulosum	56	Bacteria	Bacteria	185	2.8899999999999995e-42	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g69880	i0	87.117	2.17230769230769	163	21	50	0	44	206	10771979	10772141	Sorangium cellulosum 'So ce 56' complete genome	blastn	706	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7465778	7465778	PRJNA429937_P_NODE_7466_length_1294_cov_5.120949_g4413_i0	PRJNA429937	7466	1294	5.120949	66.26508006	Myxococcales	29	Bacteria	Bacteria	730	0	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g4413	i0	79.205	100.589644513138	1082	202	83	22	12	1081	6731378	6732448	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	130163	736	0.991847826086957	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
8080254	8080254	PRJNA429937_P_NODE_52927_length_484_cov_4.367033_g7151_i3	PRJNA429937	52927	484	4.367033	21.13643972	Nannocystis punicea	2995304	Bacteria	Bacteria	279	1.99e-70	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g7151	i3	80.311	40.4896694214876	386	62	78	13	100	478	10214860	10214482	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	19597	279	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
8740159	8740159	PRJNA429937_P_NODE_127027_length_231_cov_18.009901_g104400_i0	PRJNA429937	127027	231	18.009901	41.60287131	Pendulispora	3375062	Bacteria	Bacteria	254	5.27e-63	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g104400	i0	87.907	316.4329004329	215	26	93	0	1	215	7289487	7289273	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	73096	254	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9353870	9353870	PRJNA429937_P_NODE_12168_length_1046_cov_3.410029_g7151_i0	PRJNA429937	12168	1046	3.410029	35.66890334	Nannocystis punicea	2995304	Bacteria	Bacteria	416	3.2699999999999998e-111	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g7151	i0	76.396	44.7237093690249	788	160	74	23	18	794	10214860	10214088	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	46781	416	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
10015342	10015342	PRJNA429937_P_NODE_112428_length_268_cov_2.167364_g89805_i0	PRJNA429937	112428	268	2.167364	5.80853552	root	1	Root_unresolved	Root_unresolved	248	2.92e-61	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g89805	i0	91.209	107.884328358209	182	16	68	0	1	182	1356	1537	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	28913	248	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11904851	11904851	PRJNA429937_P_NODE_158570_length_151_cov_2.811475_g135943_i0	PRJNA429937	158570	151	2.811475	4.24532725	Chondromyces crocatus	52	Bacteria	Bacteria	60.2	7.36e-5	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g135943	i0	100	0.211920529801325	32	0	21	0	69	100	372691	372660	Chondromyces crocatus strain Cm c5, complete genome	blastn	32	60.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
12566157	12566157	PRJNA429937_P_NODE_143650_length_199_cov_6.252941_g121023_i0	PRJNA429937	143650	199	6.252941	12.44335259	Anaeromyxobacter	161492	Bacteria	Bacteria	351	1.52e-92	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g121023	i0	98.492	256.793969849246	199	3	100	0	1	199	707	509	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	51102	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
13179511	13179511	PRJNA429937_P_NODE_130471_length_224_cov_1.882051_g107844_i0	PRJNA429937	130471	224	1.882051	4.21579424	Pendulispora brunnea	2905690	Bacteria	Bacteria	143	1.15e-29	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g107844	i0	78.509	4.52232142857143	228	41	100	7	1	224	2733609	2733832	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	1013	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
13180683	13180683	PRJNA429937_P_NODE_55431_length_470_cov_7.199546_g36793_i0	PRJNA429937	55431	470	7.199546	33.8378662	Minicystis rosea	888845	Bacteria	Bacteria	388	3.0699999999999996e-103	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g36793	i0	81.895	164.51914893617	475	72	100	11	1	470	768841	769306	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	77324	388	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
13181406	13181406	PRJNA429937_P_NODE_97531_length_309_cov_14.785714_g74926_i0	PRJNA429937	97531	309	14.785714	45.68785626	Sorangium cellulosum	56	Bacteria	Bacteria	326	1.54e-84	NTclustered	gi\|28395343\|gb\|AY190668.1\|	56	g74926	i0	86.076	211.058252427184	316	29	100	13	1	309	964	657	Polyangium cellulosum strain So9733-1 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	65217	326	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14455191	14455191	PRJNA429937_P_NODE_24292_length_745_cov_3.937151_g7151_i1	PRJNA429937	24292	745	3.937151	29.33177495	Nannocystis punicea	2995304	Bacteria	Bacteria	300	2.41e-76	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g7151	i1	79.379	28.1248322147651	451	73	60	18	7	450	10214482	10214919	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	20953	300	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
14455584	14455584	PRJNA429937_P_NODE_41552_length_557_cov_66.647727_g26383_i0	PRJNA429937	41552	557	66.647727	371.22783939	Labilithrix luteola	1391654	Bacteria	Bacteria	691	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g26383	i0	89.127	127.211849192101	561	53	100	8	1	557	7090337	7089781	Labilithrix luteola strain DSM 27648, complete genome	blastn	70857	691	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14456595	14456595	PRJNA429937_P_NODE_98372_length_307_cov_2.830935_g75764_i0	PRJNA429937	98372	307	2.830935	8.69097045	Sorangium cellulosum	56	Bacteria	Bacteria	185	2.71e-42	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g75764	i0	87.117	2.44299674267101	163	21	53	0	142	304	10771979	10772141	Sorangium cellulosum 'So ce 56' complete genome	blastn	750	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15728232	15728232	PRJNA429937_P_NODE_108933_length_277_cov_2.822581_g86312_i0	PRJNA429937	108933	277	2.822581	7.81854937	Archangium gephyra	48	Bacteria	Bacteria	134	8.850000000000001e-27	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g86312	i0	80.435	11.3104693140794	184	28	65	8	58	237	5623784	5623605	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	3133	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
16389876	16389876	PRJNA429937_P_NODE_150573_length_179_cov_207.973333_g127946_i0	PRJNA429937	150573	179	207.973333	372.27226607	Stigmatella	40	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g127946	i0	98.883	244.111731843575	179	2	100	0	1	179	993	1171	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	43696	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
16390163	16390163	PRJNA429937_P_NODE_61593_length_439_cov_4.860976_g41577_i0	PRJNA429937	61593	439	4.860976	21.33968464	Stigmatella	40	Bacteria	Bacteria	514	4.5e-141	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g41577	i0	88.416	202.102505694761	423	41	96	5	17	439	1596	1182	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	88723	514	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
18277372	18277372	PRJNA429937_P_NODE_119415_length_250_cov_2.004525_g96789_i0	PRJNA429937	119415	250	2.004525	5.0113125	Minicystis rosea	888845	Bacteria	Bacteria	67.6	8.09e-7	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g96789	i0	95.238	0.332	42	2	17	0	157	198	13781106	13781147	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	83	67.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18278120	18278120	PRJNA429937_P_NODE_31935_length_643_cov_2.866450_g19544_i0	PRJNA429937	31935	643	2.86645	18.4312735	Myxococcus sp. MxC21-1	3041439	Bacteria	Bacteria	287	1.6099999999999998e-72	NTclustered	gi\|2592002496\|gb\|CP123278.1\|	3041439	g19544	i0	80.203	16.0668740279938	394	65	61	6	245	636	2700092	2699710	Myxococcus sp. MxC21-1 chromosome, complete genome	blastn	10331	287	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MxC21-1
18938846	18938846	PRJNA429937_P_NODE_14715_length_957_cov_23.812500_g8673_i0	PRJNA429937	14715	957	23.8125	227.885625	Anaeromyxobacter	161492	Bacteria	Bacteria	1194	0	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g8673	i0	89.757	242.92789968652	947	77	98	10	18	957	1636	703	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	232482	1205	0.990871369294606	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
19551383	19551383	PRJNA429937_P_NODE_102096_length_296_cov_2.928839_g79482_i0	PRJNA429937	102096	296	2.928839	8.66936344	Sorangium cellulosum	56	Bacteria	Bacteria	185	2.6e-42	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g79482	i0	87.117	2.38513513513514	163	21	55	0	131	293	10771979	10772141	Sorangium cellulosum 'So ce 56' complete genome	blastn	706	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19553306	19553306	PRJNA429937_P_NODE_78236_length_372_cov_2.813411_g55937_i0	PRJNA429937	78236	372	2.813411	10.46588892	Sorangium cellulosum	56	Bacteria	Bacteria	224	7.079999999999999e-54	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g55937	i0	86.634	6.2715053763440904	202	27	54	0	44	245	10771979	10772180	Sorangium cellulosum 'So ce 56' complete genome	blastn	2333	224	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20213468	20213468	PRJNA429937_P_NODE_111076_length_271_cov_4.834711_g88454_i0	PRJNA429937	111076	271	4.834711	13.10206681	Myxococcales	29	Bacteria	Bacteria	209	1.3900000000000001e-49	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g88454	i0	82.857	142.169741697417	245	30	88	10	33	271	7840050	7839812	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	38528	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
23379681	23379681	PRJNA429937_P_NODE_85759_length_347_cov_3.144654_g63223_i0	PRJNA429937	85759	347	3.144654	10.91194938	Myxococcus stipitatus	83455	Bacteria	Bacteria	132	4.1e-26	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g63223	i0	90.816	2.46685878962536	98	9	28	0	248	345	6709203	6709106	Myxococcus stipitatus DSM 14675, complete genome	blastn	856	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
24039008	24039008	PRJNA429937_P_NODE_101759_length_297_cov_2.753731_g79145_i0	PRJNA429937	101759	297	2.753731	8.17858107	Sorangium	39643	Bacteria	Bacteria	296	1.15e-75	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g79145	i0	83.612	45.7441077441077	299	46	100	3	1	297	1771	1474	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	13586	296	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24653326	24653326	PRJNA429937_P_NODE_58300_length_455_cov_10.265258_g39008_i0	PRJNA429937	58300	455	10.265258	46.7069239	Sorangium cellulosum	56	Bacteria	Bacteria	263	1.8700000000000001e-65	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g39008	i0	86.722	171.705494505494	241	26	88	5	216	453	840	603	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	78126	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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