metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA315314" 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
381059	381059	PRJNA315314_S_NODE_6001_length_329_cov_70.593333_g5680_i0	PRJNA315314	6001	329	70.593333	232.25206557	Labilithrix luteola	1391654	Bacteria	Bacteria	483	9.259999999999998e-132	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5680	i0	93.272	170.480243161094	327	22	99	0	1	327	3942367	3942693	Labilithrix luteola strain DSM 27648, complete genome	blastn	56088	483	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
381097	381097	PRJNA315314_S_NODE_7601_length_292_cov_26.372624_g7280_i0	PRJNA315314	7601	292	26.372624	77.00806208	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	189	1.98e-43	NTclustered	gi\|1950807334\|gb\|CP066680.1\|	2026735	g7280	i0	85.027	429.852739726027	187	26	64	2	107	292	310390	310205	MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome	blastn	125517	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
1655388	1655388	PRJNA315314_S_NODE_10202_length_253_cov_8.383929_g9881_i0	PRJNA315314	10202	253	8.383929	21.21134037	Sorangium cellulosum	56	Bacteria	Bacteria	195	3.6e-45	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g9881	i0	83.636	64.3794466403162	220	23	83	11	18	226	9930196	9930413	Sorangium cellulosum So0157-2, complete genome	blastn	16288	195	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1655831	1655831	PRJNA315314_S_NODE_6002_length_329_cov_49.016667_g5681_i0	PRJNA315314	6002	329	49.016667	161.26483443	Labilithrix luteola	1391654	Bacteria	Bacteria	392	1.6099999999999995e-104	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5681	i0	88.754	90.8085106382979	329	25	98	9	9	329	3943152	3943476	Labilithrix luteola strain DSM 27648, complete genome	blastn	29876	392	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2340508	2340508	PRJNA315314_S_NODE_13942_length_218_cov_96.677249_g13621_i0	PRJNA315314	13942	218	96.677249	210.75640282	Pendulispora	3375062	Bacteria	Bacteria	296	8.06e-76	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13621	i0	91.244	139.463302752294	217	19	99	0	1	217	7287904	7287688	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	30403	296	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
2931366	2931366	PRJNA315314_S_NODE_16583_length_201_cov_32.447674_g16262_i0	PRJNA315314	16583	201	32.447674	65.21982474	Labilithrix luteola	1391654	Bacteria	Bacteria	185	1.6499999999999998e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16262	i0	83.838	91.0398009950249	198	28	98	4	6	201	3942197	3942002	Labilithrix luteola strain DSM 27648, complete genome	blastn	18299	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2931540	2931540	PRJNA315314_S_NODE_27143_length_161_cov_203.500000_g26822_i0	PRJNA315314	27143	161	203.5	327.635	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	196	5.8399999999999996e-46	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g26822	i0	88.889	244.422360248447	162	14	99	3	2	161	2384803	2384962	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	39352	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
5484113	5484113	PRJNA315314_S_NODE_11145_length_242_cov_44.197183_g10824_i0	PRJNA315314	11145	242	44.197183	106.95718286	Pendulispora rubella	2741070	Bacteria	Bacteria	320	5.41e-83	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g10824	i0	90.535	140.318181818182	243	22	100	1	1	242	7289518	7289276	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	33957	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
6168129	6168129	PRJNA315314_S_NODE_24025_length_170_cov_4.921986_g23704_i0	PRJNA315314	24025	170	4.921986	8.3673762	Nannocystis	53	Bacteria	Bacteria	209	7.97e-50	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g23704	i0	88.889	129.988235294118	171	18	100	1	1	170	108	278	N.exedens 23S rRNA gene	blastn	22098	209	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
6168135	6168135	PRJNA315314_S_NODE_25285_length_166_cov_236.299270_g24964_i0	PRJNA315314	25285	166	236.29927	392.2567882	Sorangium	39643	Bacteria	Bacteria	220	3.6e-53	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g24964	i0	90.909	294.903614457831	165	14	99	1	3	166	3692401	3692237	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	48954	220	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6758311	6758311	PRJNA315314_S_NODE_11466_length_239_cov_60.028571_g11145_i0	PRJNA315314	11466	239	60.028571	143.46828469	Labilithrix luteola	1391654	Bacteria	Bacteria	316	6.9e-82	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11145	i0	90.283	176.36820083682	247	16	100	5	1	239	3942500	3942254	Labilithrix luteola strain DSM 27648, complete genome	blastn	42152	316	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6758677	6758677	PRJNA315314_S_NODE_5126_length_354_cov_33.430769_g4805_i0	PRJNA315314	5126	354	33.430769	118.34492226	Labilithrix luteola	1391654	Bacteria	Bacteria	361	4.9e-95	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4805	i0	86.337	37.3672316384181	344	31	94	12	21	354	3943139	3943476	Labilithrix luteola strain DSM 27648, complete genome	blastn	13228	361	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7443239	7443239	PRJNA315314_S_NODE_29206_length_156_cov_242.110236_g28885_i0	PRJNA315314	29206	156	242.110236	377.69196816	Sorangium	39643	Bacteria	Bacteria	244	1.9799999999999998e-60	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g28885	i0	94.872	273.532051282051	156	8	100	0	1	156	3692392	3692237	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	42671	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
8717997	8717997	PRJNA315314_S_NODE_747_length_885_cov_31.519860_g580_i0	PRJNA315314	747	885	31.51986	278.950761	Anaeromyxobacter	161492	Bacteria	Bacteria	185	8.44e-42	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g580	i0	88.816	23.3220338983051	152	16	17	1	699	849	573	422	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	20640	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
9993368	9993368	PRJNA315314_S_NODE_12528_length_229_cov_4694.175000_g12207_i0	PRJNA315314	12528	229	4694.175	10749.66075	Sorangium	39643	Bacteria	Bacteria	379	8.249999999999999e-101	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g12207	i0	96.507	286.982532751092	229	8	100	0	1	229	3451503	3451731	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	65719	381	0.994750656167979	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10584729	10584729	PRJNA315314_S_NODE_25989_length_164_cov_267.259259_g25668_i0	PRJNA315314	25989	164	267.259259	438.30518476	Polyangium aurulentum	2567896	Bacteria	Bacteria	222	9.859999999999999e-54	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g25668	i0	91.875	272.512195121951	160	11	96	2	7	164	441778	441937	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	44692	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
14409694	14409694	PRJNA315314_S_NODE_21092_length_180_cov_4.483444_g20771_i0	PRJNA315314	21092	180	4.483444	8.0701992	Archangium gephyra	48	Bacteria	Bacteria	80.5	7e-11	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g20771	i0	100	45.9388888888889	43	0	24	0	1	43	10869364	10869322	Archangium gephyra strain DSM 2261, complete genome	blastn	8269	80.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
15092970	15092970	PRJNA315314_S_NODE_15392_length_208_cov_515.905028_g15071_i0	PRJNA315314	15392	208	515.905028	1073.08245824	Chondromyces	50	Bacteria	Bacteria	313	7.569999999999998e-81	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g15071	i0	93.75	129.110576923077	208	13	100	0	1	208	1835	2042	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	26855	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
16367977	16367977	PRJNA315314_S_NODE_9153_length_267_cov_33.075630_g8832_i0	PRJNA315314	9153	267	33.07563	88.3119321	Sorangium	39643	Bacteria	Bacteria	357	4.6199999999999997e-94	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g8832	i0	91.011	144.539325842697	267	20	99	4	1	265	3449571	3449835	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	38592	359	0.994428969359331	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16958478	16958478	PRJNA315314_S_NODE_7934_length_286_cov_275.926070_g7613_i0	PRJNA315314	7934	286	275.92607	789.1485602	Myxococcota bacterium	2818507	Bacteria	Bacteria	281	3.1e-71	NTclustered	gi\|2907625649\|emb\|OZ223209.1\|	2818507	g7613	i0	84.722	113.660839160839	288	37	100	5	1	286	5220672	5220390	MAG: Myxococcota bacterium isolate 6e5ad1d4-156e-4916-952c-8a0b14857fe9 genome assembly, chromosome: 1	blastn	32507	281	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
19506996	19506996	PRJNA315314_S_NODE_5096_length_355_cov_39.677914_g4775_i0	PRJNA315314	5096	355	39.677914	140.8565947	Nannocystis punicea	2995304	Bacteria	Bacteria	405	2.24e-108	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g4775	i0	87.606	267.915492957746	355	37	98	7	4	352	7596337	7595984	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	95110	405	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
19507024	19507024	PRJNA315314_S_NODE_6156_length_325_cov_45.027027_g5835_i0	PRJNA315314	6156	325	45.027027	146.33783775	Labilithrix luteola	1391654	Bacteria	Bacteria	379	1.23e-100	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5835	i0	87.768	561.676923076923	327	36	100	4	1	325	3941950	3942274	Labilithrix luteola strain DSM 27648, complete genome	blastn	182545	379	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20191341	20191341	PRJNA315314_S_NODE_15716_length_206_cov_709.050847_g15395_i0	PRJNA315314	15716	206	709.050847	1460.64474482	Nannocystis	53	Bacteria	Bacteria	315	2.08e-81	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g15395	i0	94.175	220.747572815534	206	12	100	0	1	206	2506	2301	N.exedens 23S rRNA gene	blastn	45474	315	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
22057165	22057165	PRJNA315314_S_NODE_14058_length_217_cov_1269.675532_g13737_i0	PRJNA315314	14058	217	1269.675532	2755.19590444	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	329	7.91e-86	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g13737	i0	94.393	167.940092165899	214	12	99	0	4	217	9677737	9677950	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	36443	329	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
22057182	22057182	PRJNA315314_S_NODE_14918_length_211_cov_106.274725_g14597_i0	PRJNA315314	14918	211	106.274725	224.23966975	Myxococcales bacterium	2026763	Bacteria	Bacteria	219	1.7299999999999994e-52	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g14597	i0	85.377	178.635071090047	212	29	100	2	1	211	1313302	1313092	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	37692	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
22057199	22057199	PRJNA315314_S_NODE_15718_length_206_cov_556.717514_g15397_i0	PRJNA315314	15718	206	556.717514	1146.83807884	Labilithrix luteola	1391654	Bacteria	Bacteria	279	7.59e-71	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g15397	i0	91.22	133.092233009709	205	18	99	0	2	206	7090284	7090080	Labilithrix luteola strain DSM 27648, complete genome	blastn	27417	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22057225	22057225	PRJNA315314_S_NODE_16958_length_199_cov_209.611765_g16637_i0	PRJNA315314	16958	199	209.611765	417.12741235	Pendulispora rubella	2741070	Bacteria	Bacteria	198	2.1e-46	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g16637	i0	87.151	245.140703517588	179	17	88	6	1	176	7287219	7287044	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	48783	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22742200	22742200	PRJNA315314_S_NODE_5798_length_334_cov_1614.219672_g5477_i0	PRJNA315314	5798	334	1614.219672	5391.49370448	Polyangiaceae	49	Bacteria	Bacteria	490	5.629999999999998e-134	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g5477	i0	93.114	267.089820359281	334	23	100	0	1	334	771138	771471	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	89208	490	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
24606825	24606825	PRJNA315314_S_NODE_17560_length_196_cov_14.149701_g17239_i0	PRJNA315314	17560	196	14.149701	27.73341396	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	309	9.11e-80	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g17239	i0	95.361	145.637755102041	194	9	99	0	1	194	9677483	9677676	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	28545	309	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus

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