metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
821153	821153	PRJNA827593_P_NODE_32241_length_363_cov_1.327586_g31942_i0	PRJNA827593	32241	363	1.327586	4.81913718	Polyangium aurulentum	2567896	Bacteria	Bacteria	134	1.2e-26	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g31942	i0	93.333	4.65289256198347	90	6	26	0	201	290	3445216	3445127	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1689	134	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
821648	821648	PRJNA827593_P_NODE_61281_length_251_cov_0.865169_g60982_i0	PRJNA827593	61281	251	0.865169	2.17157419	Pendulispora albinea	2741071	Bacteria	Bacteria	196	9.93e-46	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g60982	i0	81.897	2.58167330677291	232	42	92	0	5	236	4397879	4398110	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	648	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
821651	821651	PRJNA827593_P_NODE_61501_length_250_cov_2.175141_g61202_i0	PRJNA827593	61501	250	2.175141	5.4378525	Cystobacter fuscus	43	Bacteria	Bacteria	97.1	1.03e-15	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g61202	i0	89.474	2.36	76	8	30	0	85	160	2492485	2492410	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	590	97.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
2096653	2096653	PRJNA827593_P_NODE_34642_length_348_cov_2.003636_g34343_i0	PRJNA827593	34642	348	2.003636	6.97265328	Pendulispora rubella	2741070	Bacteria	Bacteria	130	1.48e-25	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g34343	i0	94.118	19.7442528735632	85	5	69	0	32	116	1173371	1173287	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	6871	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
2096890	2096890	PRJNA827593_P_NODE_48502_length_288_cov_1.320930_g48203_i0	PRJNA827593	48502	288	1.32093	3.8042784	Labilithrix luteola	1391654	Bacteria	Bacteria	195	4.18e-45	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g48203	i0	80.784	22.8993055555556	255	43	88	5	35	286	9305032	9304781	Labilithrix luteola strain DSM 27648, complete genome	blastn	6595	195	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2097210	2097210	PRJNA827593_P_NODE_66922_length_242_cov_1.988166_g66623_i0	PRJNA827593	66922	242	1.988166	4.81136172	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g66623	i0	85.232	4.14876033057851	237	34	98	1	7	242	1081875	1081639	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	1004	243	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
3371602	3371602	PRJNA827593_P_NODE_15083_length_558_cov_1.220619_g14787_i0	PRJNA827593	15083	558	1.220619	6.81105402	Pendulispora albinea	2741071	Bacteria	Bacteria	156	4.07e-33	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g14787	i0	87.143	18.7186379928315	140	15	25	2	155	291	2429225	2429364	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	10445	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
3371831	3371831	PRJNA827593_P_NODE_27983_length_393_cov_2.109375_g27684_i0	PRJNA827593	27983	393	2.109375	8.28984375	Haliangium ochraceum	80816	Bacteria	Bacteria	176	2.14e-39	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g27684	i0	84.153	32.35368956743	183	27	46	2	24	205	6173320	6173139	Haliangium ochraceum DSM 14365, complete genome	blastn	12715	176	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
4649387	4649387	PRJNA827593_P_NODE_26964_length_402_cov_1.364742_g26665_i0	PRJNA827593	26964	402	1.364742	5.48626284	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	207	7.77e-49	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g26665	i0	80.282	0.706467661691542	284	48	70	8	46	325	434899	434620	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	284	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
4649786	4649786	PRJNA827593_P_NODE_50664_length_281_cov_1.274038_g50365_i0	PRJNA827593	50664	281	1.274038	3.58004678	Polyangium aurulentum	2567896	Bacteria	Bacteria	267	8.5e-67	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g50365	i0	85.271	7.90035587188612	258	38	92	0	20	277	965557	965814	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	2220	267	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
5924062	5924062	PRJNA827593_P_NODE_18545_length_497_cov_1.360849_g18247_i0	PRJNA827593	18545	497	1.360849	6.76341953	Polyangium aurulentum	2567896	Bacteria	Bacteria	272	3.4199999999999993e-68	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g18247	i0	83.972	2.30985915492958	287	42	57	4	20	304	4322134	4322418	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1148	272	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
7199643	7199643	PRJNA827593_P_NODE_53846_length_271_cov_1.166667_g53547_i0	PRJNA827593	53846	271	1.166667	3.16166757	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	244	3.82e-60	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g53547	i0	87.156	7.11070110701107	218	25	80	3	14	229	9470570	9470354	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1927	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8474366	8474366	PRJNA827593_P_NODE_54147_length_270_cov_1.370558_g53848_i0	PRJNA827593	54147	270	1.370558	3.7005066	Sorangium cellulosum	56	Bacteria	Bacteria	60.2	1.48e-4	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g53848	i0	82.895	1.24814814814815	76	3	27	9	164	235	8214574	8214643	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	337	60.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
8474398	8474398	PRJNA827593_P_NODE_55607_length_266_cov_1.196891_g55308_i0	PRJNA827593	55607	266	1.196891	3.18373006	Chondromyces crocatus	52	Bacteria	Bacteria	84.2	8.63e-12	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g55308	i0	92.982	0.357142857142857	57	4	21	0	53	109	1849148	1849204	Chondromyces crocatus strain Cm c5, complete genome	blastn	95	84.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
9749214	9749214	PRJNA827593_P_NODE_37108_length_335_cov_1.396947_g36809_i0	PRJNA827593	37108	335	1.396947	4.67977245	Anaeromyxobacter sp. K	447217	Bacteria	Bacteria	420	7.52e-113	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g36809	i0	89.877	80.6537313432836	326	33	97	0	1	326	4764901	4765226	Anaeromyxobacter sp. K, complete genome	blastn	27019	420	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
9749446	9749446	PRJNA827593_P_NODE_49868_length_283_cov_2.271429_g49569_i0	PRJNA827593	49868	283	2.271429	6.42814407	Sorangium cellulosum	56	Bacteria	Bacteria	222	1.88e-53	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g49569	i0	88.172	64.6996466431095	186	22	66	0	1	186	12313382	12313567	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	18310	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9749543	9749543	PRJNA827593_P_NODE_55768_length_265_cov_2.005208_g55469_i0	PRJNA827593	55768	265	2.005208	5.3138012	Labilithrix luteola	1391654	Bacteria	Bacteria	152	2.3199999999999995e-32	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g55469	i0	83.537	0.618867924528302	164	25	62	2	30	193	1860909	1860748	Labilithrix luteola strain DSM 27648, complete genome	blastn	164	152	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9749720	9749720	PRJNA827593_P_NODE_66648_length_243_cov_0.905882_g66349_i0	PRJNA827593	66648	243	0.905882	2.20129326	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	196	9.56e-46	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g66349	i0	81.557	7.51028806584362	244	39	99	4	1	241	329560	329320	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	1825	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
10156862	10156862	PRJNA827593_P_NODE_31568_length_367_cov_1.860544_g31269_i0	PRJNA827593	31568	367	1.860544	6.82819648	Myxococcus	32	Bacteria	Bacteria	143	2.01e-29	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g31269	i0	81.356	5.58310626702997	177	31	48	2	15	190	7591654	7591829	Myxococcus xanthus strain DK1050 chromosome	blastn	2049	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
11432071	11432071	PRJNA827593_P_NODE_19829_length_478_cov_1.901235_g19531_i0	PRJNA827593	19829	478	1.901235	9.0879033	Pseudomonadati	3379134	Bacteria	Bacteria	322	3.21e-83	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g19531	i0	90.244	47.9811715481172	246	24	51	0	1	246	7470182	7470427	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	22935	322	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
13575081	13575081	PRJNA827593_P_NODE_58451_length_258_cov_1.664865_g58152_i0	PRJNA827593	58451	258	1.664865	4.2953517	Minicystis rosea	888845	Bacteria	Bacteria	235	2.1699999999999997e-57	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g58152	i0	83.268	74.1162790697674	257	42	99	1	3	258	9368247	9367991	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	19122	235	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
15256400	15256400	PRJNA827593_P_NODE_36852_length_336_cov_1.904943_g36553_i0	PRJNA827593	36852	336	1.904943	6.40060848	Pendulispora	3375062	Bacteria	Bacteria	531	3.34e-146	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g36553	i0	96.285	145.458333333333	323	12	98	0	1	323	7287490	7287812	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	48874	531	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16123888	16123888	PRJNA827593_P_NODE_43013_length_308_cov_1.965957_g42714_i0	PRJNA827593	43013	308	1.965957	6.05514756	Labilithrix luteola	1391654	Bacteria	Bacteria	252	2.64e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g42714	i0	82.373	3.67532467532468	295	47	95	5	16	308	6440681	6440390	Labilithrix luteola strain DSM 27648, complete genome	blastn	1132	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16531115	16531115	PRJNA827593_P_NODE_61753_length_250_cov_1.305085_g61454_i0	PRJNA827593	61753	250	1.305085	3.2627125	Bacteria	2	Bacteria	Bacteria	191	4.6e-44	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g61454	i0	80.4	11.372	250	49	100	0	1	250	5507747	5507498	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	2843	191	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19947541	19947541	PRJNA827593_P_NODE_26396_length_407_cov_0.922156_g26097_i0	PRJNA827593	26396	407	0.922156	3.75317492	Myxococcus stipitatus	83455	Bacteria	Bacteria	237	9.999999999999998e-58	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g26097	i0	79.472	45.8697788697789	341	65	84	5	67	406	6479734	6480070	Myxococcus stipitatus DSM 14675, complete genome	blastn	18669	237	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
21223035	21223035	PRJNA827593_P_NODE_25857_length_412_cov_1.126844_g25558_i0	PRJNA827593	25857	412	1.126844	4.64259728	Polyangium aurulentum	2567896	Bacteria	Bacteria	239	2.8300000000000003e-58	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g25558	i0	87.264	48.7669902912621	212	24	51	2	4	212	4800016	4799805	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	20092	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
23774089	23774089	PRJNA827593_P_NODE_65719_length_244_cov_1.350877_g65420_i0	PRJNA827593	65719	244	1.350877	3.29613988	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	217	7.38e-52	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g65420	i0	85.577	94.0655737704918	208	28	85	2	2	208	4256725	4256931	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	22952	217	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);;