metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA1160211" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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
309020	309020	PRJNA1160211_S_NODE_110381_length_438_cov_2.446575_g109152_i0	PRJNA1160211	110381	438	2.446575	10.7159985	Minicystis rosea	888845	Bacteria	Bacteria	363	1.72e-95	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g109152	i0	82.619	196.575342465753	420	64	95	9	24	438	13715047	13715462	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	86100	363	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
2313343	2313343	PRJNA1160211_S_NODE_1022_length_1397_cov_14.999245_g808_i0	PRJNA1160211	1022	1397	14.999245	209.53945265	root	1	Root_unresolved	Root_unresolved	1977	0	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g808	i0	93.478	125.014316392269	1334	81	95	6	49	1379	8621765	8623095	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	174645	1977	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
2313639	2313639	PRJNA1160211_S_NODE_18022_length_724_cov_8.365591_g17060_i0	PRJNA1160211	18022	724	8.365591	60.56687884	Archangiaceae	39	Bacteria	Bacteria	1225	0	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g17060	i0	97.881	223.520718232044	708	15	98	0	17	724	1062959	1063666	Archangium gephyra strain DSM 2261, complete genome	blastn	161829	1230	0.995934959349594	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
3589236	3589236	PRJNA1160211_S_NODE_281703_length_241_cov_14.208333_g280470_i0	PRJNA1160211	281703	241	14.208333	34.24208253	Pseudomonadati	3379134	Bacteria	Bacteria	248	2.58e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g280470	i0	87.273	303.016597510373	220	25	90	3	24	241	3941756	3941974	Labilithrix luteola strain DSM 27648, complete genome	blastn	73027	248	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3589323	3589323	PRJNA1160211_S_NODE_3383_length_1036_cov_19.009346_g808_i1	PRJNA1160211	3383	1036	19.009346	196.93682456	root	1	Root_unresolved	Root_unresolved	1435	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g808	i1	92.232	122.180501930502	1017	73	98	6	4	1018	1013	1	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	126579	1435	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4137555	4137555	PRJNA1160211_S_NODE_68224_length_526_cov_4.419426_g67020_i0	PRJNA1160211	68224	526	4.419426	23.24618076	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	145	8.27e-30	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g67020	i0	88.43	7.22433460076046	121	13	23	1	1	121	1383677	1383558	Anaeromyxobacter paludicola DNA, complete genome	blastn	3800	145	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
4866961	4866961	PRJNA1160211_S_NODE_57904_length_553_cov_6.062500_g56722_i0	PRJNA1160211	57904	553	6.0625	33.525625	Myxococcales	29	Bacteria	Bacteria	819	0	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g56722	i0	94.528	277.544303797468	530	29	96	0	24	553	785	1314	S.aurantiaca 23S rRNA gene	blastn	153482	819	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
5413297	5413297	PRJNA1160211_S_NODE_284525_length_239_cov_5.246988_g283292_i0	PRJNA1160211	284525	239	5.246988	12.54030132	Pendulispora albinea	2741071	Bacteria	Bacteria	351	1.89e-92	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g283292	i0	95.853	141.90376569037701	217	9	91	0	1	217	3588641	3588425	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	33915	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
5413621	5413621	PRJNA1160211_S_NODE_54505_length_562_cov_34.165644_g53330_i0	PRJNA1160211	54505	562	34.165644	192.01091928	Minicystis rosea	888845	Bacteria	Bacteria	560	7.44e-155	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g53330	i0	86.233	187.498220640569	523	64	92	8	22	539	769345	768826	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	105374	560	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
6141601	6141601	PRJNA1160211_S_NODE_286625_length_236_cov_5.631902_g285392_i0	PRJNA1160211	286625	236	5.631902	13.29128872	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|189171986\|gb\|EU545509.1\|	56	g285392	i0	96.97	12.7076271186441	33	1	14	0	185	217	951	919	Sorangium cellulosum strain 0157-26 16S ribosomal RNA gene, complete sequence	blastn	2999	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6688361	6688361	PRJNA1160211_S_NODE_35706_length_626_cov_23.580470_g34582_i0	PRJNA1160211	35706	626	23.58047	147.6137422	Sorangium cellulosum	56	Bacteria	Bacteria	431	6.829999999999998e-116	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g34582	i0	80	89.0447284345048	605	103	95	16	30	625	11485589	11484994	Sorangium cellulosum 'So ce 56' complete genome	blastn	55742	431	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7962525	7962525	PRJNA1160211_S_NODE_151767_length_372_cov_3.715719_g150534_i0	PRJNA1160211	151767	372	3.715719	13.82247468	Sorangium cellulosum	56	Bacteria	Bacteria	379	1.43e-100	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g150534	i0	86.533	106.427419354839	349	42	93	5	1	345	3489874	3489527	Sorangium cellulosum 'So ce 56' complete genome	blastn	39591	379	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7964169	7964169	PRJNA1160211_S_NODE_97187_length_463_cov_1.453846_g95962_i0	PRJNA1160211	97187	463	1.453846	6.73130698	Labilithrix luteola	1391654	Bacteria	Bacteria	494	6.219999999999998e-135	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g95962	i0	86.475	1.17278617710583	451	59	97	2	12	461	7012713	7013162	Labilithrix luteola strain DSM 27648, complete genome	blastn	543	494	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8691725	8691725	PRJNA1160211_S_NODE_292187_length_228_cov_4.767742_g290954_i0	PRJNA1160211	292187	228	4.767742	10.87045176	Myxococcales	29	Bacteria	Bacteria	113	9.19e-21	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g290954	i0	98.462	63.9078947368421	65	0	29	1	140	204	3612	3549	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	14571	113	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
9238025	9238025	PRJNA1160211_S_NODE_255388_length_257_cov_3.918478_g254155_i0	PRJNA1160211	255388	257	3.918478	10.07048846	Sorangium cellulosum	56	Bacteria	Bacteria	364	2.6399999999999993e-96	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g254155	i0	94.167	92.6108949416342	240	13	93	1	1	239	3449283	3449044	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	23801	364	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10512786	10512786	PRJNA1160211_S_NODE_114069_length_431_cov_11.885475_g112840_i0	PRJNA1160211	114069	431	11.885475	51.22639725	Labilithrix luteola	1391654	Bacteria	Bacteria	250	1.37e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g112840	i0	78.892	0.879350348027842	379	73	87	5	42	415	7213040	7213416	Labilithrix luteola strain DSM 27648, complete genome	blastn	379	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10512839	10512839	PRJNA1160211_S_NODE_119429_length_422_cov_3.842407_g118200_i0	PRJNA1160211	119429	422	3.842407	16.21495754	Chondromyces crocatus	52	Bacteria	Bacteria	512	1.55e-140	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g118200	i0	89.32	120.651658767773	412	38	97	6	14	422	3066	2658	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	50915	512	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
10514377	10514377	PRJNA1160211_S_NODE_68969_length_524_cov_4.973392_g67764_i0	PRJNA1160211	68969	524	4.973392	26.06057408	Labilithrix luteola	1391654	Bacteria	Bacteria	185	4.859999999999998e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67764	i0	74.181	0.990458015267176	519	101	95	24	8	505	1853583	1854089	Labilithrix luteola strain DSM 27648, complete genome	blastn	519	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10514453	10514453	PRJNA1160211_S_NODE_78569_length_501_cov_28.315421_g77353_i0	PRJNA1160211	78569	501	28.315421	141.86025921	Labilithrix luteola	1391654	Bacteria	Bacteria	374	9.2e-99	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g77353	i0	86.167	0.692614770459082	347	46	69	2	29	374	9270807	9270462	Labilithrix luteola strain DSM 27648, complete genome	blastn	347	374	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11242028	11242028	PRJNA1160211_S_NODE_292729_length_227_cov_12.188312_g291496_i0	PRJNA1160211	292729	227	12.188312	27.66746824	Sorangium	39643	Bacteria	Bacteria	235	1.87e-57	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g291496	i0	87.379	107.079295154185	206	24	90	2	1	204	2994170	2993965	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	24307	235	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11788982	11788982	PRJNA1160211_S_NODE_292070_length_228_cov_9.361290_g290837_i0	PRJNA1160211	292070	228	9.36129	21.3437412	Pendulispora rubella	2741070	Bacteria	Bacteria	209	1.14e-49	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g290837	i0	85.437	95.1798245614035	206	25	90	5	1	203	7289809	7290012	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	21701	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13062756	13062756	PRJNA1160211_S_NODE_124551_length_413_cov_33.676471_g123322_i0	PRJNA1160211	124551	413	33.676471	139.08382523	Labilithrix luteola	1391654	Bacteria	Bacteria	654	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g123322	i0	95.181	151.019370460048	415	18	100	1	1	413	3942655	3942241	Labilithrix luteola strain DSM 27648, complete genome	blastn	62371	654	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13063950	13063950	PRJNA1160211_S_NODE_299811_length_203_cov_8.584615_g298578_i0	PRJNA1160211	299811	203	8.584615	17.42676845	Pendulispora brunnea	2905690	Bacteria	Bacteria	224	3.539999999999999e-54	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g298578	i0	89.326	105.576354679803	178	19	88	0	24	201	7408362	7408185	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	21432	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
13792422	13792422	PRJNA1160211_S_NODE_96531_length_464_cov_3.255754_g95306_i0	PRJNA1160211	96531	464	3.255754	15.10669856	Myxococcus	32	Bacteria	Bacteria	579	1.6699999999999995e-160	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g95306	i0	90.2	236.859913793103	449	36	96	6	1	446	3886	3443	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	109903	579	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
15066176	15066176	PRJNA1160211_S_NODE_211992_length_297_cov_30.098214_g210759_i0	PRJNA1160211	211992	297	30.098214	89.39169558	Myxococcota	2818505	Bacteria	Bacteria	143	1.59e-29	NTclustered	gi\|213517456\|gb\|FJ176772.1\|	52	g210759	i0	94.565	32.2356902356902	92	5	31	0	186	277	1511	1420	Chondromyces crocatus strain KYC2823 16S ribosomal RNA gene, partial sequence	blastn	9574	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
18162147	18162147	PRJNA1160211_S_NODE_4895_length_951_cov_32.768793_g4333_i0	PRJNA1160211	4895	951	32.768793	311.63122143	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	56.5	0.007	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g4333	i0	96.97	0.0347003154574132	33	1	3	0	61	93	3765150	3765182	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	33	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20711051	20711051	PRJNA1160211_S_NODE_192357_length_319_cov_11.357724_g191124_i0	PRJNA1160211	192357	319	11.357724	36.23113956	Sorangium cellulosum	56	Bacteria	Bacteria	320	7.43e-83	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g191124	i0	87.77	487.755485893417	278	28	86	4	24	297	595	870	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	155594	320	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20711662	20711662	PRJNA1160211_S_NODE_28277_length_660_cov_17.364566_g27188_i0	PRJNA1160211	28277	660	17.364566	114.6061356	Minicystis rosea	888845	Bacteria	Bacteria	754	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g27188	i0	88.006	133.207575757576	642	71	97	5	23	660	13715047	13715686	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	87917	754	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea

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