metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA492406" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA492406" 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
1099169	1099169	PRJNA492406_P_NODE_1061_length_1175_cov_9.843920_g739_i1	PRJNA492406	1061	1175	9.84392	115.66606	Myxococcales	29	Bacteria	Bacteria	1277	0	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g739	i1	86.616	254.108936170213	1173	136	99	20	11	1174	3029	4189	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	298578	1277	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
1099367	1099367	PRJNA492406_P_NODE_921_length_1253_cov_15.754237_g739_i0	PRJNA492406	921	1253	15.754237	197.40058961	Myxococcus	32	Bacteria	Bacteria	1386	0	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g739	i0	87.047	254.508379888268	1243	141	99	19	9	1243	4259	3029	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	318899	1386	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
1727299	1727299	PRJNA492406_P_NODE_24602_length_260_cov_2.417112_g24303_i0	PRJNA492406	24602	260	2.417112	6.2844912	Myxococcales bacterium	2026763	Bacteria	Bacteria	99	3e-16	NTclustered	gi\|2108178552\|gb\|CP070713.1\|	2026763	g24303	i0	90.541	2.15	74	7	28	0	152	225	2178272	2178345	MAG: Myxococcales bacterium isolate bin5 chromosome	blastn	559	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
3003111	3003111	PRJNA492406_P_NODE_18563_length_290_cov_1.105991_g18264_i0	PRJNA492406	18563	290	1.105991	3.2073739	Pendulispora rubella	2741070	Bacteria	Bacteria	252	2.47e-62	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18264	i0	85.542	12.0034482758621	249	27	85	9	5	250	11859412	11859170	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	3481	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
4279819	4279819	PRJNA492406_P_NODE_5664_length_504_cov_4.501160_g5365_i0	PRJNA492406	5664	504	4.50116	22.6858464	Archangium gephyra	48	Bacteria	Bacteria	326	2.63e-84	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g5365	i0	81.75	64.6845238095238	400	64	79	8	93	489	8017319	8017712	Archangium gephyra strain DSM 2261, complete genome	blastn	32601	326	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
4927432	4927432	PRJNA492406_P_NODE_31704_length_241_cov_2.464286_g31405_i0	PRJNA492406	31704	241	2.464286	5.93892926	Myxococcaceae	31	Bacteria	Bacteria	335	1.9199999999999993e-87	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g31405	i0	91.701	288.087136929461	241	20	100	0	1	241	2659	2899	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	69429	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
5556088	5556088	PRJNA492406_P_NODE_24185_length_262_cov_2.137566_g23886_i0	PRJNA492406	24185	262	2.137566	5.60042292	Labilithrix luteola	1391654	Bacteria	Bacteria	307	4.62e-79	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23886	i0	87.833	94.7175572519084	263	30	100	2	1	262	10981453	10981192	Labilithrix luteola strain DSM 27648, complete genome	blastn	24816	307	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6830055	6830055	PRJNA492406_P_NODE_23146_length_268_cov_1.184615_g22847_i0	PRJNA492406	23146	268	1.184615	3.1747682	Labilithrix luteola	1391654	Bacteria	Bacteria	159	1.41e-34	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22847	i0	86.897	2.66044776119403	145	15	53	3	1	143	8763340	8763198	Labilithrix luteola strain DSM 27648, complete genome	blastn	713	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7477292	7477292	PRJNA492406_P_NODE_28566_length_247_cov_1.448276_g28267_i0	PRJNA492406	28566	247	1.448276	3.57724172	Myxococcus	32	Bacteria	Bacteria	320	5.54e-83	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g28267	i0	90.795	12.9878542510121	239	22	97	0	1	239	2805893	2805655	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	3208	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
8752257	8752257	PRJNA492406_P_NODE_8407_length_420_cov_26.319885_g8108_i0	PRJNA492406	8407	420	26.319885	110.543517	Pendulispora	3375062	Bacteria	Bacteria	224	8.1e-54	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g8108	i0	85.586	49.5238095238095	222	22	50	6	172	383	2910084	2909863	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	20800	226	0.991150442477876	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
10027611	10027611	PRJNA492406_P_NODE_8768_length_412_cov_3.525074_g8469_i0	PRJNA492406	8768	412	3.525074	14.52330488	Myxococcaceae	31	Bacteria	Bacteria	137	1.0600000000000002e-27	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g8469	i0	80.392	47.0752427184466	204	20	49	16	170	369	7213345	7213158	Myxococcus xanthus strain DK1050 chromosome	blastn	19395	137	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10655961	10655961	PRJNA492406_P_NODE_12889_length_348_cov_176.323636_g12590_i0	PRJNA492406	12889	348	176.323636	613.60625328	Pendulispora rubella	2741070	Bacteria	Bacteria	196	1.44e-45	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g12590	i0	77.528	9.17816091954023	356	61	99	17	2	348	11241067	11240722	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	3194	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
10656573	10656573	PRJNA492406_P_NODE_9009_length_407_cov_4.371257_g8710_i0	PRJNA492406	9009	407	4.371257	17.791015989999998	uncultured Sorangium sp.	491148	Bacteria	Bacteria	239	2.79e-58	NTclustered	gi\|219812134\|gb\|FJ552348.1\|	491148	g8710	i0	94.805	53.8550368550369	154	6	38	1	254	407	575	726	Uncultured Sorangium sp. clone LTSP_BACT_P6A23 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21919	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
11302460	11302460	PRJNA492406_P_NODE_31849_length_241_cov_1.375000_g31550_i0	PRJNA492406	31849	241	1.375	3.31375	Pendulispora	3375062	Bacteria	Bacteria	141	4.5e-29	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g31550	i0	100	40.3692946058091	76	0	32	0	1	76	4256998	4256923	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	9729	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11931186	11931186	PRJNA492406_P_NODE_26950_length_250_cov_1.655367_g26651_i0	PRJNA492406	26950	250	1.655367	4.1384175	Minicystis rosea	888845	Bacteria	Bacteria	248	2.69e-61	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g26651	i0	87.156	38.416	218	28	87	0	33	250	2305790	2306007	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	9604	248	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11931213	11931213	PRJNA492406_P_NODE_28410_length_248_cov_0.880000_g28111_i0	PRJNA492406	28410	248	0.88	2.1824	Minicystis rosea	888845	Bacteria	Bacteria	370	5.45e-98	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g28111	i0	94.215	100.633064516129	242	14	100	0	1	242	12817894	12818135	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	24957	370	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
12578218	12578218	PRJNA492406_P_NODE_310_length_1948_cov_656.373333_g225_i0	PRJNA492406	310	1948	656.373333	12786.15252684	Pendulispora	3375062	Bacteria	Bacteria	1967	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g225	i0	86.879	154.332135523614	1791	194	91	35	180	1945	9854188	9852414	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	300639	1969	0.998984255967496	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13206137	13206137	PRJNA492406_P_NODE_18611_length_290_cov_0.884793_g18312_i0	PRJNA492406	18611	290	0.884793	2.5658997	Labilithrix luteola	1391654	Bacteria	Bacteria	169	2.56e-37	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g18312	i0	82.075	3.3551724137931	212	24	70	11	87	288	3597738	3597945	Labilithrix luteola strain DSM 27648, complete genome	blastn	973	169	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13206198	13206198	PRJNA492406_P_NODE_21211_length_278_cov_0.975610_g20912_i0	PRJNA492406	21211	278	0.97561	2.7121958	Labilithrix luteola	1391654	Bacteria	Bacteria	331	2.9400000000000002e-86	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g20912	i0	88.364	106.298561151079	275	32	99	0	2	276	3700610	3700336	Labilithrix luteola strain DSM 27648, complete genome	blastn	29551	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13206235	13206235	PRJNA492406_P_NODE_22971_length_269_cov_0.790816_g22672_i0	PRJNA492406	22971	269	0.790816	2.12729504	Labilithrix luteola	1391654	Bacteria	Bacteria	359	1.3e-94	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22672	i0	90.706	73.996282527881	269	25	100	0	1	269	3942747	3942479	Labilithrix luteola strain DSM 27648, complete genome	blastn	19905	359	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13206373	13206373	PRJNA492406_P_NODE_29691_length_245_cov_1.418605_g29392_i0	PRJNA492406	29691	245	1.418605	3.47558225	Labilithrix luteola	1391654	Bacteria	Bacteria	143	1.28e-29	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g29392	i0	92.929	7.53877551020408	99	6	40	1	107	205	8561438	8561535	Labilithrix luteola strain DSM 27648, complete genome	blastn	1847	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17029478	17029478	PRJNA492406_P_NODE_10994_length_373_cov_2.370000_g10695_i0	PRJNA492406	10994	373	2.37	8.8401	Minicystis rosea	888845	Bacteria	Bacteria	289	2.48e-73	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g10695	i0	88.983	66.2466487935657	236	22	63	2	139	372	13018870	13019103	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	24710	289	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17029757	17029757	PRJNA492406_P_NODE_21914_length_274_cov_1.368159_g21615_i0	PRJNA492406	21914	274	1.368159	3.74875566	Labilithrix luteola	1391654	Bacteria	Bacteria	156	1.86e-33	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g21615	i0	78.947	0.832116788321168	228	48	83	0	1	228	3564427	3564654	Labilithrix luteola strain DSM 27648, complete genome	blastn	228	156	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19578405	19578405	PRJNA492406_P_NODE_26056_length_253_cov_1.605556_g25757_i0	PRJNA492406	26056	253	1.605556	4.06205668	Sorangium cellulosum	56	Bacteria	Bacteria	193	1.3e-44	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g25757	i0	84.158	1.60869565217391	202	29	79	3	52	252	4646270	4646469	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	407	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19578479	19578479	PRJNA492406_P_NODE_29896_length_245_cov_0.895349_g29597_i0	PRJNA492406	29896	245	0.895349	2.19360505	Labilithrix luteola	1391654	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g29597	i0	89.177	1.57551020408163	231	23	94	2	6	235	10969761	10969990	Labilithrix luteola strain DSM 27648, complete genome	blastn	386	287	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21501173	21501173	PRJNA492406_P_NODE_28297_length_248_cov_0.880000_g27998_i0	PRJNA492406	28297	248	0.88	2.1824	Pendulispora	3375062	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g27998	i0	87.097	7.33870967741935	248	32	100	0	1	248	9017082	9017329	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	1820	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22128806	22128806	PRJNA492406_P_NODE_18638_length_289_cov_2.300926_g18339_i0	PRJNA492406	18638	289	2.300926	6.64967614	Labilithrix luteola	1391654	Bacteria	Bacteria	230	1.1499999999999995e-55	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g18339	i0	84.615	11.7024221453287	234	32	80	4	55	286	10903908	10904139	Labilithrix luteola strain DSM 27648, complete genome	blastn	3382	230	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22128914	22128914	PRJNA492406_P_NODE_23618_length_265_cov_2.187500_g23319_i0	PRJNA492406	23618	265	2.1875	5.796875	Labilithrix luteola	1391654	Bacteria	Bacteria	255	1.72e-63	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23319	i0	84.091	1.51698113207547	264	42	99	0	2	265	179942	179679	Labilithrix luteola strain DSM 27648, complete genome	blastn	402	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23404812	23404812	PRJNA492406_P_NODE_22979_length_268_cov_3.394872_g22680_i0	PRJNA492406	22979	268	3.394872	9.09825696	Sorangium cellulosum	56	Bacteria	Bacteria	195	3.85e-45	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g22680	i0	83.636	60.7761194029851	220	23	78	11	33	241	9930196	9930413	Sorangium cellulosum So0157-2, complete genome	blastn	16288	195	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24051130	24051130	PRJNA492406_P_NODE_23379_length_266_cov_3.621762_g23080_i0	PRJNA492406	23379	266	3.621762	9.63388692	Sorangium	39643	Bacteria	Bacteria	339	1.6699999999999998e-88	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g23080	i0	89.552	289.364661654135	268	26	100	2	1	266	3692392	3692125	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	76971	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24051137	24051137	PRJNA492406_P_NODE_239_length_2171_cov_696.504290_g176_i0	PRJNA492406	239	2171	696.50429	15121.1081359	Pendulispora	3375062	Bacteria	Bacteria	2322	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g176	i0	89.695	131.432519576232	1834	170	88	16	300	2124	9854188	9852365	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	285340	2322	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella

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