metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
1664132	1664132	PRJNA326068_P_NODE_1582_length_852_cov_9.235723_g1171_i0	PRJNA326068	1582	852	9.235723	78.68835996	Myxococcales bacterium	2026763	Bacteria	Bacteria	490	1.5299999999999998e-133	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g1171	i0	79.913	148.983568075117	692	120	80	16	1	678	1313110	1313796	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	126934	490	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
3619853	3619853	PRJNA326068_P_NODE_14583_length_225_cov_2.341837_g13620_i0	PRJNA326068	14583	225	2.341837	5.26913325	Sorangium	39643	Bacteria	Bacteria	202	1.88e-47	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g13620	i0	83.19	60.28	232	27	100	11	1	225	3904813	3904587	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	13563	202	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3619885	3619885	PRJNA326068_P_NODE_9183_length_338_cov_4.954693_g8228_i0	PRJNA326068	9183	338	4.954693	16.74686234	Sorangium	39643	Bacteria	Bacteria	117	1.1200000000000002e-21	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g8228	i0	84.127	6.68934911242604	126	14	37	6	214	337	10559967	10560088	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	2261	117	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3619886	3619886	PRJNA326068_P_NODE_9743_length_323_cov_24.741497_g8784_i0	PRJNA326068	9743	323	24.741497	79.91503531	root	1	Root_unresolved	Root_unresolved	387	7.32e-103	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g8784	i0	88.509	209.393188854489	322	34	100	3	4	323	3690883	3690563	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	67634	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4216746	4216746	PRJNA326068_P_NODE_4824_length_502_cov_177.234672_g4017_i0	PRJNA326068	4824	502	177.234672	889.71805344	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	449	1.4899999999999995e-121	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g4017	i0	83.333	163.930278884462	504	67	99	14	1	495	9677483	9677978	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	82293	449	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
4897041	4897041	PRJNA326068_P_NODE_10884_length_294_cov_9.671698_g9923_i0	PRJNA326068	10884	294	9.671698	28.43479212	root	1	Root_unresolved	Root_unresolved	302	2.4500000000000002e-77	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g9923	i0	86.268	58.1836734693878	284	32	95	7	17	294	3450373	3450655	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	17106	302	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5492944	5492944	PRJNA326068_P_NODE_10265_length_310_cov_17.743772_g9305_i0	PRJNA326068	10265	310	17.743772	55.0056932	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	401	2.4999999999999992e-107	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g9305	i0	90.127	241.151612903226	314	24	100	7	1	310	180501	180191	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	74757	401	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
6767057	6767057	PRJNA326068_P_NODE_7306_length_394_cov_7.252055_g6371_i0	PRJNA326068	7306	394	7.252055	28.5730967	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	405	2.51e-108	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g6371	i0	85.39	193.994923857868	397	51	100	6	1	394	8616716	8617108	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	76434	405	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
8042703	8042703	PRJNA326068_P_NODE_17047_length_197_cov_14.630952_g16084_i0	PRJNA326068	17047	197	14.630952	28.82297544	Minicystis rosea	888845	Bacteria	Bacteria	276	9.3e-70	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g16084	i0	91.919	365.852791878173	198	15	100	1	1	197	768847	769044	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	72073	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
11272384	11272384	PRJNA326068_P_NODE_19349_length_159_cov_7.330769_g18386_i0	PRJNA326068	19349	159	7.330769	11.65592271	Haliangium	162027	Bacteria	Bacteria	167	4.51e-37	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g18386	i0	85.625	364.452830188679	160	22	100	1	1	159	3007	2848	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	57948	167	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11868019	11868019	PRJNA326068_P_NODE_13570_length_241_cov_2.476415_g12607_i0	PRJNA326068	13570	241	2.476415	5.96816015	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	344	3.199999999999999e-90	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g12607	i0	92.531	266.589211618257	241	17	100	1	1	241	3433160	3432921	Corallococcus sp. EGB chromosome, complete genome	blastn	64248	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
11868065	11868065	PRJNA326068_P_NODE_6150_length_441_cov_4.558252_g5261_i0	PRJNA326068	6150	441	4.558252	20.10189132	Labilithrix luteola	1391654	Bacteria	Bacteria	305	2.96e-78	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5261	i0	88.168	88.233560090703	262	24	59	6	184	441	3943063	3943321	Labilithrix luteola strain DSM 27648, complete genome	blastn	38911	305	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11868082	11868082	PRJNA326068_P_NODE_8970_length_343_cov_12.732484_g8016_i0	PRJNA326068	8970	343	12.732484	43.67242012	Sorangium cellulosum	56	Bacteria	Bacteria	344	4.78e-90	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g8016	i0	85.294	87.2040816326531	340	43	98	7	7	342	3906114	3905778	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	29911	344	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12547720	12547720	PRJNA326068_P_NODE_14330_length_228_cov_9.713568_g13367_i0	PRJNA326068	14330	228	9.713568	22.14693504	Anaeromyxobacter	161492	Bacteria	Bacteria	154	5.42e-33	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g13367	i0	97.778	89.8026315789474	90	0	39	1	139	228	2383951	2384038	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	20475	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
12547724	12547724	PRJNA326068_P_NODE_16450_length_204_cov_9.937143_g15487_i0	PRJNA326068	16450	204	9.937143	20.27177172	Sorangium	39643	Bacteria	Bacteria	228	2.7599999999999995e-55	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g15487	i0	87.817	94.3872549019608	197	20	95	4	11	204	208	13	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	19255	228	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12547727	12547727	PRJNA326068_P_NODE_18610_length_170_cov_221.702128_g17647_i0	PRJNA326068	18610	170	221.702128	376.8936176	Haliangium	162027	Bacteria	Bacteria	187	3.74e-43	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g17647	i0	86.705	327.870588235294	173	18	100	4	1	170	3005	2835	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	55738	187	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
13142956	13142956	PRJNA326068_P_NODE_12151_length_268_cov_2.799163_g11188_i0	PRJNA326068	12151	268	2.799163	7.50175684	Labilithrix luteola	1391654	Bacteria	Bacteria	324	4.71e-84	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11188	i0	88.645	106.548507462687	273	21	100	8	1	268	7089426	7089159	Labilithrix luteola strain DSM 27648, complete genome	blastn	28555	324	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13142994	13142994	PRJNA326068_P_NODE_3451_length_595_cov_78.289753_g2750_i0	PRJNA326068	3451	595	78.289753	465.82403035	Labilithrix luteola	1391654	Bacteria	Bacteria	669	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2750	i0	87.145	124.623529411765	599	65	99	11	1	592	7915203	7915796	Labilithrix luteola strain DSM 27648, complete genome	blastn	74151	669	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14418287	14418287	PRJNA326068_P_NODE_4512_length_520_cov_5.818737_g3729_i0	PRJNA326068	4512	520	5.818737	30.2574324	Labilithrix luteola	1391654	Bacteria	Bacteria	514	5.41e-141	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g3729	i0	85.83	105.413461538462	494	59	94	11	30	517	7915308	7915796	Labilithrix luteola strain DSM 27648, complete genome	blastn	54815	514	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15692101	15692101	PRJNA326068_P_NODE_18773_length_168_cov_2.021583_g17810_i0	PRJNA326068	18773	168	2.021583	3.39625944	Stigmatella aurantiaca	41	Bacteria	Bacteria	187	3.71e-43	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g17810	i0	87.273	115.119047619048	165	20	98	1	4	168	440	277	S.aurantiaca 23S rRNA gene	blastn	19340	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
18920640	18920640	PRJNA326068_P_NODE_19495_length_157_cov_187.125000_g18532_i0	PRJNA326068	19495	157	187.125	293.78625	Polyangiaceae	49	Bacteria	Bacteria	257	2.5600000000000003e-64	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g18532	i0	96.178	260.445859872611	157	6	100	0	1	157	771513	771669	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	40890	257	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18920647	18920647	PRJNA326068_P_NODE_4275_length_534_cov_40.825743_g3508_i0	PRJNA326068	4275	534	40.825743	218.00946762	Anaeromyxobacter	161492	Bacteria	Bacteria	182	6.41e-41	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g3508	i0	79.923	90.0861423220974	259	43	48	8	279	534	1669	1921	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	48106	183	0.994535519125683	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
20195272	20195272	PRJNA326068_P_NODE_7256_length_395_cov_84.289617_g6321_i0	PRJNA326068	7256	395	84.289617	332.94398715	Pendulispora	3375062	Bacteria	Bacteria	553	8.499999999999997e-153	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g6321	i0	91.899	172.20253164557	395	32	100	0	1	395	7289085	7289479	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	68020	553	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21470902	21470902	PRJNA326068_P_NODE_13097_length_249_cov_38.627273_g12134_i0	PRJNA326068	13097	249	38.627273	96.18190977	Polyangiaceae	49	Bacteria	Bacteria	279	9.5e-71	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g12134	i0	86.853	208.879518072289	251	31	100	2	1	249	3692097	3692347	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	52011	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21470904	21470904	PRJNA326068_P_NODE_14617_length_224_cov_208.789744_g13654_i0	PRJNA326068	14617	224	208.789744	467.68902656	root	1	Root_unresolved	Root_unresolved	276	1.0799999999999999e-69	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g13654	i0	88.938	131.941964285714	226	21	99	3	2	224	3690755	3690531	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	29555	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23341362	23341362	PRJNA326068_P_NODE_7079_length_402_cov_6.898123_g6149_i0	PRJNA326068	7079	402	6.898123	27.73045446	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	191	7.83e-44	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g6149	i0	85.946	96.8606965174129	185	18	45	6	223	402	352	533	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	38938	191	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5

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