metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
954476	954476	PRJNA980585_P_NODE_18121_length_335_cov_2.091603_g17867_i0	PRJNA980585	18121	335	2.091603	7.00687005	Chondromyces crocatus	52	Bacteria	Bacteria	564	3.279999999999999e-156	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g17867	i0	97.015	133.29552238806	335	10	100	0	1	335	2241	2575	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	44654	564	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
955146	955146	PRJNA980585_P_NODE_55761_length_243_cov_1.670588_g55507_i0	PRJNA980585	55761	243	1.670588	4.05952884	Haliangium ochraceum	80816	Bacteria	Bacteria	58.4	4.71e-4	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g55507	i0	100	0.246913580246914	31	0	13	0	107	137	7766557	7766587	Haliangium ochraceum DSM 14365, complete genome	blastn	60	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
2230101	2230101	PRJNA980585_P_NODE_30682_length_278_cov_1.126829_g30428_i0	PRJNA980585	30682	278	1.126829	3.13258462	Labilithrix luteola	1391654	Bacteria	Bacteria	283	8.34e-72	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g30428	i0	86.09	365.248201438849	266	33	95	4	4	267	3942154	3941891	Labilithrix luteola strain DSM 27648, complete genome	blastn	101539	283	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5097813	5097813	PRJNA980585_P_NODE_9544_length_431_cov_2.150838_g9290_i0	PRJNA980585	9544	431	2.150838	9.27011178	Pendulispora	3375062	Bacteria	Bacteria	473	7.49e-129	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g9290	i0	87.028	135.419953596288	424	49	98	6	1	421	7288311	7288731	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	58366	473	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
7332247	7332247	PRJNA980585_P_NODE_17646_length_339_cov_0.770677_g17392_i0	PRJNA980585	17646	339	0.770677	2.61259503	Labilithrix luteola	1391654	Bacteria	Bacteria	484	2.6599999999999996e-132	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17392	i0	93.293	131.250737463127	328	22	97	0	1	328	7090171	7090498	Labilithrix luteola strain DSM 27648, complete genome	blastn	44494	484	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7332521	7332521	PRJNA980585_P_NODE_31926_length_274_cov_1.532338_g31672_i0	PRJNA980585	31926	274	1.532338	4.19860612	Labilithrix luteola	1391654	Bacteria	Bacteria	320	6.25e-83	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g31672	i0	87.857	46.5875912408759	280	24	99	7	2	274	3943402	3943126	Labilithrix luteola strain DSM 27648, complete genome	blastn	12765	320	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8922359	8922359	PRJNA980585_P_NODE_60427_length_241_cov_0.916667_g60173_i0	PRJNA980585	60427	241	0.916667	2.20916747	Myxococcaceae	31	Bacteria	Bacteria	163	9.61e-36	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g60173	i0	90.4	13.49377593361	125	10	51	2	71	194	6758725	6758602	Myxococcus xanthus strain DK1050 chromosome	blastn	3252	163	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10198003	10198003	PRJNA980585_P_NODE_34688_length_266_cov_8.984456_g34434_i0	PRJNA980585	34688	266	8.984456	23.89865296	Myxococcaceae	31	Bacteria	Bacteria	372	1.64e-98	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g34434	i0	92.045	287.03007518797	264	21	99	0	1	264	2908	2645	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	76350	372	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
11158562	11158562	PRJNA980585_P_NODE_57109_length_243_cov_0.905882_g56855_i0	PRJNA980585	57109	243	0.905882	2.20129326	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	76.8	1.3e-9	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g56855	i0	92.453	0.218106995884774	53	4	22	0	171	223	10059866	10059814	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	53	76.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12434441	12434441	PRJNA980585_P_NODE_7150_length_486_cov_1.677966_g6896_i0	PRJNA980585	7150	486	1.677966	8.15491476	Cystobacter fuscus	43	Bacteria	Bacteria	359	2.49e-94	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g6896	i0	80.287	71.6111111111111	487	86	99	6	2	486	5415563	5415085	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	34803	359	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
12748595	12748595	PRJNA980585_P_NODE_40790_length_251_cov_0.865169_g40536_i0	PRJNA980585	40790	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	178	3.6e-40	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g40536	i0	80.083	93.2151394422311	241	46	96	2	1	240	2559456	2559217	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	23397	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
12748602	12748602	PRJNA980585_P_NODE_42030_length_250_cov_1.841808_g41776_i0	PRJNA980585	42030	250	1.841808	4.60452	Polyangiales	3031712	Bacteria	Bacteria	355	1.54e-93	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g41776	i0	92.4	190.924	250	18	100	1	1	250	3489820	3490068	Sorangium cellulosum 'So ce 56' complete genome	blastn	47731	357	0.994397759103641	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15297262	15297262	PRJNA980585_P_NODE_32692_length_272_cov_1.537688_g32438_i0	PRJNA980585	32692	272	1.537688	4.18251136	Sorangium	39643	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g32438	i0	96.97	0.584558823529412	33	1	12	0	206	238	12394146	12394178	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	159	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16257991	16257991	PRJNA980585_P_NODE_55773_length_243_cov_1.629412_g55519_i0	PRJNA980585	55773	243	1.629412	3.95947116	Haliangium ochraceum	80816	Bacteria	Bacteria	62.1	3.64e-5	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g55519	i0	82.857	0.288065843621399	70	11	28	1	1	69	5513893	5513962	Haliangium ochraceum DSM 14365, complete genome	blastn	70	62.1	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
17532766	17532766	PRJNA980585_P_NODE_35394_length_264_cov_3.523560_g35140_i0	PRJNA980585	35394	264	3.52356	9.3021984	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	283	7.859999999999999e-72	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g35140	i0	86.364	169.780303030303	264	31	99	5	3	264	8617200	8617460	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	44822	283	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17532827	17532827	PRJNA980585_P_NODE_39194_length_254_cov_1.580110_g38940_i0	PRJNA980585	39194	254	1.58011	4.0134794	Pendulispora albinea	2741071	Bacteria	Bacteria	333	7.35e-87	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g38940	i0	90.551	112.429133858268	254	20	99	4	3	254	3589000	3589251	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	28557	333	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
17532925	17532925	PRJNA980585_P_NODE_45594_length_249_cov_0.875000_g45340_i0	PRJNA980585	45594	249	0.875	2.17875	Polyangium aurulentum	2567896	Bacteria	Bacteria	165	2.77e-36	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g45340	i0	84.431	72.1967871485944	167	26	67	0	1	167	3472897	3473063	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	17977	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17533139	17533139	PRJNA980585_P_NODE_60514_length_241_cov_0.916667_g60260_i0	PRJNA980585	60514	241	0.916667	2.20916747	Archangium violaceum	83451	Bacteria	Bacteria	189	1.58e-43	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g60260	i0	81.07	3.02489626556017	243	40	99	6	1	240	10014525	10014286	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	729	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
17846911	17846911	PRJNA980585_P_NODE_274_length_1782_cov_3.630778_g212_i0	PRJNA980585	274	1782	3.630778	64.70046396	Stigmatella	40	Bacteria	Bacteria	1945	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g212	i0	86.772	240.807519640853	1769	207	98	23	28	1782	1778	23	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	429119	1945	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
18806361	18806361	PRJNA980585_P_NODE_22275_length_310_cov_1.569620_g22021_i0	PRJNA980585	22275	310	1.56962	4.865822	Labilithrix luteola	1391654	Bacteria	Bacteria	457	5.25e-124	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22021	i0	93.485	154.683870967742	307	20	99	0	4	310	3942329	3942023	Labilithrix luteola strain DSM 27648, complete genome	blastn	47952	457	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18806854	18806854	PRJNA980585_P_NODE_51175_length_246_cov_0.890173_g50921_i0	PRJNA980585	51175	246	0.890173	2.18982558	Archangium violaceum	83451	Bacteria	Bacteria	207	4.48e-49	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g50921	i0	82.845	3.90650406504065	239	33	96	5	6	240	8702721	8702955	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	961	207	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
18806868	18806868	PRJNA980585_P_NODE_52035_length_245_cov_1.395349_g51781_i0	PRJNA980585	52035	245	1.395349	3.41860505	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	209	1.24e-49	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g51781	i0	91.447	61.1836734693878	152	13	62	0	6	157	631795	631946	Anaeromyxobacter paludicola DNA, complete genome	blastn	14990	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
18806997	18806997	PRJNA980585_P_NODE_60975_length_241_cov_0.916667_g60721_i0	PRJNA980585	60975	241	0.916667	2.20916747	Sorangium cellulosum	56	Bacteria	Bacteria	113	9.81e-21	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g60721	i0	79.268	5.0746887966805	164	33	68	1	40	203	745144	744982	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1223	113	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20081265	20081265	PRJNA980585_P_NODE_32156_length_274_cov_0.900498_g31902_i0	PRJNA980585	32156	274	0.900498	2.46736452	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	137	6.75e-28	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g31902	i0	93.478	42.4124087591241	92	6	34	0	157	248	1632453	1632362	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	11621	137	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20081716	20081716	PRJNA980585_P_NODE_59056_length_242_cov_0.911243_g58802_i0	PRJNA980585	59056	242	0.911243	2.20520806	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g58802	i0	100	0.119834710743802	29	0	12	0	64	92	2615486	2615458	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
20395743	20395743	PRJNA980585_P_NODE_32956_length_271_cov_1.818182_g32702_i0	PRJNA980585	32956	271	1.818182	4.92727322	Pendulispora	3375062	Bacteria	Bacteria	399	7.699999999999999e-107	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g32702	i0	93.358	157.671586715867	271	17	100	1	1	271	7289505	7289236	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	42729	399	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21356681	21356681	PRJNA980585_P_NODE_27757_length_286_cov_1.131455_g27503_i0	PRJNA980585	27757	286	1.131455	3.2359613	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	302	2.3800000000000002e-77	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g27503	i0	87.132	118.751748251748	272	28	94	7	1	268	8615823	8616091	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	33963	302	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
21356905	21356905	PRJNA980585_P_NODE_3977_length_622_cov_0.981785_g3723_i0	PRJNA980585	3977	622	0.981785	6.1067027	Pendulispora albinea	2741071	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g3723	i0	100	0.0466237942122186	29	0	5	0	405	433	1864762	1864790	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22632348	22632348	PRJNA980585_P_NODE_8878_length_444_cov_1.037736_g8624_i0	PRJNA980585	8878	444	1.037736	4.60754784	Nannocystis punicea	2995304	Bacteria	Bacteria	377	6.24e-100	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g8624	i0	84.694	89.9346846846847	392	45	88	9	55	443	5377540	5377161	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	39931	377	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
22947084	22947084	PRJNA980585_P_NODE_49878_length_247_cov_0.885057_g49624_i0	PRJNA980585	49878	247	0.885057	2.18609079	Myxococcales	29	Bacteria	Bacteria	172	1.64e-38	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g49624	i0	80.342	81.582995951417	234	40	94	5	1	231	4546252	4546482	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	20151	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
25180771	25180771	PRJNA980585_P_NODE_28240_length_284_cov_2.023697_g27986_i0	PRJNA980585	28240	284	2.023697	5.74729948	Melittangium boletus	83453	Bacteria	Bacteria	117	9.17e-22	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g27986	i0	89.362	3.4330985915493	94	9	33	1	191	284	8949944	8950036	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	975	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
25495849	25495849	PRJNA980585_P_NODE_3780_length_635_cov_7.229537_g3527_i0	PRJNA980585	3780	635	7.229537	45.90755995	Bacteria	2	Bacteria	Bacteria	54.7	0.018	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g3527	i0	100	0.18740157480315	29	0	5	0	158	186	1652717	1652689	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	119	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus

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