metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
1172689	1172689	PRJNA682078_P_NODE_203961_length_261_cov_0.914894_g202184_i0	PRJNA682078	203961	261	0.914894	2.38787334	Sorangium	39643	Bacteria	Bacteria	97.1	1.08e-15	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g202184	i0	81.967	9.74329501915709	122	15	44	5	135	250	4644246	4644366	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	2543	97.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1933704	1933704	PRJNA682078_P_NODE_105982_length_343_cov_1.177778_g104205_i0	PRJNA682078	105982	343	1.177778	4.03977854	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	209	1.82e-49	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g104205	i0	78.395	9.06997084548105	324	68	94	2	21	343	3930561	3930883	Corallococcus sp. NCRR chromosome, complete genome	blastn	3111	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
1935724	1935724	PRJNA682078_P_NODE_189582_length_269_cov_1.433673_g187805_i0	PRJNA682078	189582	269	1.433673	3.85658037	Labilithrix luteola	1391654	Bacteria	Bacteria	339	1.6899999999999998e-88	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g187805	i0	90.625	3.4907063197026	256	23	95	1	1	255	4811475	4811220	Labilithrix luteola strain DSM 27648, complete genome	blastn	939	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3725237	3725237	PRJNA682078_P_NODE_283063_length_242_cov_0.911243_g281286_i0	PRJNA682078	283063	242	0.911243	2.20520806	Myxococcus	32	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g281286	i0	100	167.004132231405	242	0	100	0	1	242	380120	380361	Myxococcus xanthus strain DK1050 chromosome	blastn	40415	448	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5762832	5762832	PRJNA682078_P_NODE_168045_length_282_cov_1.191388_g166268_i0	PRJNA682078	168045	282	1.191388	3.35971416	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	422	1.72e-113	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g166268	i0	93.684	238.673758865248	285	12	100	6	1	282	941	660	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	67306	422	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
5766407	5766407	PRJNA682078_P_NODE_42345_length_525_cov_2.446903_g40585_i0	PRJNA682078	42345	525	2.446903	12.84624075	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	826	0	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g40585	i0	95.048	141.167619047619	525	26	100	0	1	525	9678198	9677674	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	74113	826	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
5767701	5767701	PRJNA682078_P_NODE_98945_length_353_cov_1.703571_g97169_i0	PRJNA682078	98945	353	1.703571	6.01360563	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	588	2.0599999999999994e-163	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g97169	i0	96.866	166.546742209632	351	11	99	0	3	353	8615617	8615267	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	58791	588	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7037747	7037747	PRJNA682078_P_NODE_165586_length_283_cov_1.928571_g163809_i0	PRJNA682078	165586	283	1.928571	5.45785593	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	211	4.07e-50	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g163809	i0	80.851	405.007067137809	282	42	99	12	1	280	178840	178569	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	114617	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
7551320	7551320	PRJNA682078_P_NODE_279166_length_243_cov_0.905882_g277389_i0	PRJNA682078	279166	243	0.905882	2.20129326	Myxococcus	32	Bacteria	Bacteria	220	5.67e-53	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g277389	i0	83.333	33.0781893004115	246	34	99	5	3	243	1965342	1965099	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	8038	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8312075	8312075	PRJNA682078_P_NODE_156827_length_289_cov_1.351852_g155050_i0	PRJNA682078	156827	289	1.351852	3.90685228	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g155050	i0	100	0.0968858131487889	28	0	10	0	185	212	10837308	10837281	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
12140207	12140207	PRJNA682078_P_NODE_231290_length_250_cov_0.870056_g229513_i0	PRJNA682078	231290	250	0.870056	2.17514	Labilithrix luteola	1391654	Bacteria	Bacteria	270	5.74e-68	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g229513	i0	86.381	75.388	257	23	100	11	1	250	7915582	7915833	Labilithrix luteola strain DSM 27648, complete genome	blastn	18847	270	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12141678	12141678	PRJNA682078_P_NODE_290310_length_241_cov_0.916667_g288533_i0	PRJNA682078	290310	241	0.916667	2.20916747	Nannocystis punicea	2995304	Bacteria	Bacteria	145	3.48e-30	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g288533	i0	79.703	0.838174273858921	202	39	83	2	2	202	4620339	4620139	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	202	145	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
12653070	12653070	PRJNA682078_P_NODE_36850_length_562_cov_1.267894_g35096_i0	PRJNA682078	36850	562	1.267894	7.12556428	Myxococcales	29	Bacteria	Bacteria	606	9.429999999999998e-169	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g35096	i0	86.535	251.099644128114	557	67	98	7	11	562	849	1402	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	141118	610	0.99344262295082	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
13412763	13412763	PRJNA682078_P_NODE_154531_length_290_cov_2.502304_g152754_i0	PRJNA682078	154531	290	2.502304	7.2566816	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	215	3.24e-51	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g152754	i0	80.42	4.05172413793103	286	52	98	4	6	289	3626776	3626493	Anaeromyxobacter paludicola DNA, complete genome	blastn	1175	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
13413802	13413802	PRJNA682078_P_NODE_194571_length_266_cov_1.492228_g192794_i0	PRJNA682078	194571	266	1.492228	3.96932648	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	479	9.42e-131	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g192794	i0	99.245	9.05639097744361	265	2	99	0	2	266	1193705	1193441	Myxococcus sp. MH1 DNA, complete genome	blastn	2409	479	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
14690858	14690858	PRJNA682078_P_NODE_274532_length_243_cov_1.152941_g272755_i0	PRJNA682078	274532	243	1.152941	2.80164663	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	108	4.61e-19	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g272755	i0	81.818	40.4444444444444	132	20	53	4	1	130	9873917	9874046	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	9828	108	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15963577	15963577	PRJNA682078_P_NODE_231093_length_250_cov_0.870056_g229316_i0	PRJNA682078	231093	250	0.870056	2.17514	Archangium violaceum	83451	Bacteria	Bacteria	156	1.68e-33	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g229316	i0	87.143	0.904	140	14	55	3	113	250	12975123	12974986	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	226	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
17236726	17236726	PRJNA682078_P_NODE_147274_length_297_cov_1.375000_g145497_i0	PRJNA682078	147274	297	1.375	4.08375	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	507	4.8999999999999996e-139	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g145497	i0	97.627	238.653198653199	295	7	99	0	2	296	2161787	2161493	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	70880	507	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
17236921	17236921	PRJNA682078_P_NODE_155574_length_290_cov_1.147465_g153797_i0	PRJNA682078	155574	290	1.147465	3.3276485	Myxococcus fulvus	33	Bacteria	Bacteria	100	9.46e-17	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g153797	i0	98.246	0.393103448275862	57	1	20	0	234	290	10373918	10373862	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	114	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
18513317	18513317	PRJNA682078_P_NODE_248755_length_247_cov_0.885057_g246978_i0	PRJNA682078	248755	247	0.885057	2.18609079	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g246978	i0	100	0.11336032388664	28	0	11	0	94	121	174795	174822	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
19023625	19023625	PRJNA682078_P_NODE_13555_length_940_cov_2.523645_g12186_i0	PRJNA682078	13555	940	2.523645	23.722263	Pendulispora	3375062	Bacteria	Bacteria	1303	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g12186	i0	91.817	118.104255319149	941	68	99	9	4	940	9853355	9852420	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	111018	1303	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
19786831	19786831	PRJNA682078_P_NODE_193776_length_266_cov_3.326425_g191999_i0	PRJNA682078	193776	266	3.326425	8.8482905	Pendulispora rubella	2741070	Bacteria	Bacteria	326	1.3e-84	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g191999	i0	89.015	500.744360902256	264	27	99	2	4	266	7289728	7289990	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	133198	326	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20299552	20299552	PRJNA682078_P_NODE_253096_length_246_cov_2.346821_g251319_i0	PRJNA682078	253096	246	2.346821	5.77317966	Myxococcus	32	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g251319	i0	100	22.9878048780488	246	0	100	0	1	246	7031325	7031080	Myxococcus xanthus strain DK1050 chromosome	blastn	5655	455	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
21061697	21061697	PRJNA682078_P_NODE_166857_length_283_cov_0.780952_g165080_i0	PRJNA682078	166857	283	0.780952	2.21009416	Myxococcus landrumensis	2813577	Bacteria	Bacteria	195	4.1e-45	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g165080	i0	79.71	13.86925795053	276	50	96	6	1	273	7260193	7260465	Myxococcus landrumus strain SCHIC003 chromosome	blastn	3925	195	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
21062547	21062547	PRJNA682078_P_NODE_200997_length_262_cov_1.661376_g199220_i0	PRJNA682078	200997	262	1.661376	4.35280512	uncultured myxobacterium HF0200_01L06	723556	Bacteria	Bacteria	93.5	1.41e-14	NTclustered	gi\|297170971\|gb\|GU567972.1\|	723556	g199220	i0	88.608	87.7709923664122	79	5	29	3	187	262	29197	29120	Uncultured myxobacterium HF0200_01L06 genomic sequence	blastn	22996	93.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured myxobacterium HF0200_01L06
21063190	21063190	PRJNA682078_P_NODE_225977_length_251_cov_0.865169_g224200_i0	PRJNA682078	225977	251	0.865169	2.17157419	Archangium gephyra	48	Bacteria	Bacteria	346	9.32e-91	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g224200	i0	91.6	0.99601593625498	250	21	99	0	1	250	10855626	10855377	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	250	346	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
21575679	21575679	PRJNA682078_P_NODE_280857_length_242_cov_1.366864_g279080_i0	PRJNA682078	280857	242	1.366864	3.30781088	Myxococcus	32	Bacteria	Bacteria	191	4.43e-44	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g279080	i0	81.702	211.111570247934	235	38	96	4	5	237	377012	376781	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	51089	191	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
21576359	21576359	PRJNA682078_P_NODE_68937_length_415_cov_3.514620_g67162_i0	PRJNA682078	68937	415	3.51462	14.585673	Pendulispora	3375062	Bacteria	Bacteria	645	1.4399999999999993e-180	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g67162	i0	94.699	185.73734939759	415	22	100	0	1	415	9852124	9851710	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	77081	651	0.990783410138249	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21576736	21576736	PRJNA682078_P_NODE_98017_length_355_cov_0.946809_g96241_i0	PRJNA682078	98017	355	0.946809	3.36117195	Anaeromyxobacter	161492	Bacteria	Bacteria	254	8.58e-63	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g96241	i0	81.505	74.5211267605634	319	49	88	8	2	315	4301247	4301560	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	26455	254	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
24126039	24126039	PRJNA682078_P_NODE_65939_length_424_cov_1.923077_g64164_i0	PRJNA682078	65939	424	1.923077	8.15384648	Pendulispora	3375062	Bacteria	Bacteria	532	1.1999999999999999e-146	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g64164	i0	91	318.091981132075	400	28	93	4	1	393	7289669	7289271	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	134871	534	0.99625468164794	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24886979	24886979	PRJNA682078_P_NODE_232980_length_250_cov_0.870056_g231203_i0	PRJNA682078	232980	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	135	2.1900000000000003e-27	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g231203	i0	86.508	3.424	126	13	50	3	127	250	12161655	12161778	Sorangium cellulosum 'So ce 56' complete genome	blastn	856	135	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24889529	24889529	PRJNA682078_P_NODE_68220_length_418_cov_0.971014_g66445_i0	PRJNA682078	68220	418	0.971014	4.05883852	Sorangium cellulosum	56	Bacteria	Bacteria	459	2.0299999999999993e-124	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g66445	i0	86.683	19.9066985645933	413	55	99	0	6	418	4405274	4404862	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	8321	459	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25398271	25398271	PRJNA682078_P_NODE_130480_length_313_cov_2.995833_g128703_i0	PRJNA682078	130480	313	2.995833	9.37695729	Anaeromyxobacter	161492	Bacteria	Bacteria	375	1.5299999999999998e-99	NTclustered	gi\|470484038\|ref\|NR_076626.1\|	161493	g128703	i0	88.71	237.79552715655	310	31	98	4	1	307	1681	1989	Anaeromyxobacter dehalogenans strain 2CP-1 23S ribosomal RNA gene, complete sequence	blastn	74430	375	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans

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