metadata: contig_metadata: 30 rows where bioproject = "PRJEB29441" and tax

30 rows where bioproject = "PRJEB29441" 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
2263570	2263570	PRJEB29441_P_NODE_28362_length_197_cov_1.108108_g27921_i0	PRJEB29441	28362	197	1.108108	2.18297276	Myxococcaceae	31	Bacteria	Bacteria	298	1.98e-76	NTclustered	gi\|545790946\|gb\|KF270709.1\|	83456	g27921	i0	94	239.07614213198	200	6	100	6	1	197	388	192	Myxococcus virescens strain Mxv76 23S ribosomal RNA gene, partial sequence	blastn	47098	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus virescens
3538889	3538889	PRJEB29441_P_NODE_34763_length_177_cov_1.593750_g34322_i0	PRJEB29441	34763	177	1.59375	2.8209375	Myxococcia	32015	Bacteria	Bacteria	185	1.4099999999999999e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g34322	i0	94.215	83.9717514124294	121	7	68	0	57	177	3941887	3941767	Labilithrix luteola strain DSM 27648, complete genome	blastn	14863	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3852666	3852666	PRJEB29441_P_NODE_28524_length_196_cov_1.734694_g28083_i0	PRJEB29441	28524	196	1.734694	3.40000024	Labilithrix luteola	1391654	Bacteria	Bacteria	241	3.37e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g28083	i0	88.776	224.867346938776	196	22	100	0	1	196	7089172	7088977	Labilithrix luteola strain DSM 27648, complete genome	blastn	44074	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4816158	4816158	PRJEB29441_P_NODE_33144_length_182_cov_1.127820_g32703_i0	PRJEB29441	33144	182	1.12782	2.0526324	root	1	Root_unresolved	Root_unresolved	276	8.440000000000001e-70	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g32703	i0	94.054	165.318681318681	185	5	100	6	1	182	2464	2283	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	30088	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
4816247	4816247	PRJEB29441_P_NODE_44724_length_163_cov_0.894737_g44283_i0	PRJEB29441	44724	163	0.894737	1.45842131	Corallococcus	83461	Bacteria	Bacteria	121	3.669999999999999e-23	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g44283	i0	92.771	37.398773006135	83	6	51	0	1	83	143796	143878	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	6096	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
7365892	7365892	PRJEB29441_P_NODE_3286_length_676_cov_157.039872_g2914_i0	PRJEB29441	3286	676	157.039872	1061.58953472	root	1	Root_unresolved	Root_unresolved	780	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g2914	i0	87.518	129.37426035503	689	69	100	13	1	676	2064	1380	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	87457	780	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7679143	7679143	PRJEB29441_P_NODE_7987_length_408_cov_275.844011_g7548_i0	PRJEB29441	7987	408	275.844011	1125.44356488	Labilithrix luteola	1391654	Bacteria	Bacteria	597	4.009999999999999e-166	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7548	i0	93.12	137.191176470588	407	28	99	0	2	408	7090059	7090465	Labilithrix luteola strain DSM 27648, complete genome	blastn	55974	597	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11504957	11504957	PRJEB29441_P_NODE_6010_length_483_cov_14.658986_g5576_i0	PRJEB29441	6010	483	14.658986	70.80290238	Labilithrix luteola	1391654	Bacteria	Bacteria	773	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5576	i0	95.464	157.192546583851	485	20	100	2	1	483	3942800	3942316	Labilithrix luteola strain DSM 27648, complete genome	blastn	75924	773	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15016050	15016050	PRJEB29441_P_NODE_1812_length_916_cov_22.636678_g1563_i0	PRJEB29441	1812	916	22.636678	207.35197048	Pendulispora	3375062	Bacteria	Bacteria	1112	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g1563	i0	88.636	117.260917030568	924	91	99	12	2	916	9852411	9853329	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	107411	1112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
15328417	15328417	PRJEB29441_P_NODE_14833_length_283_cov_14.863248_g14392_i0	PRJEB29441	14833	283	14.863248	42.06299184	Labilithrix luteola	1391654	Bacteria	Bacteria	372	1.76e-98	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14392	i0	98.571	236.254416961131	210	3	74	0	74	283	3944599	3944390	Labilithrix luteola strain DSM 27648, complete genome	blastn	66860	372	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16603229	16603229	PRJEB29441_P_NODE_22394_length_223_cov_2.591954_g21953_i0	PRJEB29441	22394	223	2.591954	5.78005742	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	390	3.689999999999999e-104	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g21953	i0	98.206	233.878923766816	223	4	100	0	1	223	2161592	2161814	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	52155	390	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
17566025	17566025	PRJEB29441_P_NODE_1434_length_1025_cov_16.512295_g1220_i0	PRJEB29441	1434	1025	16.512295	169.25102375	Myxococcia	32015	Bacteria	Bacteria	1245	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1220	i0	88.621	180.798048780488	1037	100	99	15	1	1024	3942800	3941769	Labilithrix luteola strain DSM 27648, complete genome	blastn	185318	1245	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17566244	17566244	PRJEB29441_P_NODE_4534_length_567_cov_8.830116_g4115_i0	PRJEB29441	4534	567	8.830116	50.06675772	Myxococcia	32015	Bacteria	Bacteria	649	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4115	i0	87.413	133.913580246914	572	63	100	9	1	567	3942333	3941766	Labilithrix luteola strain DSM 27648, complete genome	blastn	75929	654	0.992354740061162	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18840011	18840011	PRJEB29441_P_NODE_37675_length_169_cov_4.091667_g37234_i0	PRJEB29441	37675	169	4.091667	6.91491723	Myxococcales	29	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g37234	i0	99.412	251.360946745562	170	0	100	1	1	169	554	723	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	42480	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
20427512	20427512	PRJEB29441_P_NODE_4797_length_548_cov_5.965932_g4115_i1	PRJEB29441	4797	548	5.965932	32.69330736	Labilithrix luteola	1391654	Bacteria	Bacteria	641	2.52e-179	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4115	i1	87.95	137.591240875912	556	52	100	11	1	548	3941785	3942333	Labilithrix luteola strain DSM 27648, complete genome	blastn	75400	641	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21390399	21390399	PRJEB29441_P_NODE_26297_length_205_cov_1.275641_g25856_i0	PRJEB29441	26297	205	1.275641	2.61506405	Sorangium	39643	Bacteria	Bacteria	313	7.4399999999999995e-81	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g25856	i0	94.175	132.868292682927	206	11	100	1	1	205	3689994	3689789	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	27238	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21703550	21703550	PRJEB29441_P_NODE_4758_length_551_cov_15.400398_g4339_i0	PRJEB29441	4758	551	15.400398	84.85619298	Pendulispora rubella	2741070	Bacteria	Bacteria	865	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g4339	i0	95.1	170.838475499093	551	23	100	3	1	551	7288976	7289522	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	94132	865	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24252465	24252465	PRJEB29441_P_NODE_38140_length_168_cov_2.025210_g37699_i0	PRJEB29441	38140	168	2.02521	3.4023528	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g37699	i0	95.238	16.0119047619048	168	8	100	0	1	168	1384069	1383902	Anaeromyxobacter paludicola DNA, complete genome	blastn	2690	267	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
24252580	24252580	PRJEB29441_P_NODE_46840_length_161_cov_0.910714_g46399_i0	PRJEB29441	46840	161	0.910714	1.46624954	Labilithrix luteola	1391654	Bacteria	Bacteria	161	2.13e-35	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g46399	i0	85	4.26086956521739	160	22	99	2	1	159	7915815	7915657	Labilithrix luteola strain DSM 27648, complete genome	blastn	686	161	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26843593	26843593	PRJEB29441_P_NODE_25741_length_207_cov_1.936709_g25300_i0	PRJEB29441	25741	207	1.936709	4.00898763	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	70.5	3.4e-12	NR	RYZ13579.1	2484252	g25300	i0	49.3	0.971014492753623	67	34	97.1	0	2	202	43	109	RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium]	diamond	201	70.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27697047	27697047	PRJEB29441_P_NODE_38844_length_167_cov_0.864407_g38403_i0	PRJEB29441	38844	167	0.864407	1.44355969	Polyangia bacterium	3058050	Bacteria	Bacteria	60.1	1.01e-8	NR	MFO0622583.1	3058050	g38403	i0	93.5	0.55688622754491	31	2	55.7	0	167	75	1291	1321	MFO0622583.1 LamG domain-containing protein [Polyangia bacterium]	diamond	93	60.1	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28864869	28864869	PRJEB29441_P_NODE_40168_length_166_cov_0.871795_g39727_i0	PRJEB29441	40168	166	0.871795	1.4471797	Archangium gephyra	48	Bacteria	Bacteria	104	2.39e-26	NR	PZR05007.1	48	g39727	i0	96.4	0.993975903614458	55	2	99.4	0	2	166	77	131	PZR05007.1 MAG: hypothetical protein DI536_33150 [Archangium gephyra]	diamond	165	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
30222761	30222761	PRJEB29441_P_NODE_45392_length_162_cov_0.902655_g44951_i0	PRJEB29441	45392	162	0.902655	1.4623011	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	41.6	0.0314	NR	RMD97591.1	2026735	g44951	i0	50	0.888888888888889	48	23	88.9	1	11	154	202	248	RMD97591.1 MAG: DMT family transporter [Deltaproteobacteria bacterium]	diamond	144	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31233738	31233738	PRJEB29441_P_NODE_46795_length_161_cov_0.910714_g46354_i0	PRJEB29441	46795	161	0.910714	1.46624954	Myxococcales bacterium	2026763	Bacteria	Bacteria	112	9.729999999999999e-30	NR	MBL8636728.1	2026763	g46354	i0	100	0.987577639751553	53	0	98.8	0	159	1	66	118	MBL8636728.1 YbjN domain-containing protein [Myxococcales bacterium]	diamond	159	112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31297162	31297162	PRJEB29441_P_NODE_45695_length_162_cov_0.902655_g45254_i0	PRJEB29441	45695	162	0.902655	1.4623011	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47.8	2.05e-4	NR	MBS2014456.1	2026735	g45254	i0	44.7	0.703703703703704	38	21	70.4	0	116	3	272	309	MBS2014456.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	114	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31834703	31834703	PRJEB29441_P_NODE_32057_length_185_cov_1.213235_g31616_i0	PRJEB29441	32057	185	1.213235	2.24448475	Myxococcales bacterium	2026763	Bacteria	Bacteria	109	5.840000000000001e-26	NR	MBK6461489.1	2026763	g31616	i0	90.2	0.989189189189189	61	6	98.9	0	1	183	103	163	MBK6461489.1 threonine--tRNA ligase [Myxococcales bacterium]	diamond	183	109	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31859855	31859855	PRJEB29441_P_NODE_42157_length_165_cov_0.879310_g41716_i0	PRJEB29441	42157	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	86.7	4.28e-18	NR	MBL8605774.1	2026763	g41716	i0	72.2	1.96363636363636	54	14	98.2	1	163	2	260	312	MBL8605774.1 hypothetical protein [Myxococcales bacterium]	diamond	324	86.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31923251	31923251	PRJEB29441_P_NODE_39057_length_167_cov_0.864407_g38616_i0	PRJEB29441	39057	167	0.864407	1.44355969	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.0344	NR	WP_044987101.1	56	g38616	i0	29.5	3.61077844311377	61	35	97	2	2	163	404	463	WP_044987101.1 hypothetical protein [Sorangium cellulosum]	diamond	603	42	0.990476190476191	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
32436322	32436322	PRJEB29441_P_NODE_31059_length_188_cov_1.215827_g30618_i0	PRJEB29441	31059	188	1.215827	2.28575476	Myxococcales bacterium	2026763	Bacteria	Bacteria	65.1	2.08e-10	NR	HVE87905.1	2026763	g30618	i0	57.1	0.893617021276596	56	21	89.4	1	187	20	240	292	HVE87905.1 hypothetical protein [Myxococcales bacterium]	diamond	168	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32467949	32467949	PRJEB29441_P_NODE_44159_length_163_cov_0.894737_g43718_i0	PRJEB29441	44159	163	0.894737	1.45842131	Myxococcota bacterium	2818507	Bacteria	Bacteria	65.1	1.07e-10	NR	MFQ5458834.1	2818507	g43718	i0	66.7	0.828220858895706	45	15	82.8	0	18	152	55	99	MFQ5458834.1 glycosyltransferase family 2 protein [Myxococcota bacterium]	diamond	135	65.1	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium

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