metadata: contig_metadata: 30 rows where bioproject = "PRJNA436017", tax_phylum = "Myxococcota" and tax

30 rows where bioproject = "PRJNA436017", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
4257884	4257884	PRJNA436017_P_NODE_26784_length_158_cov_0.942149_g26486_i0	PRJNA436017	26784	158	0.942149	1.48859542	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	176	7.429999999999999e-40	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g26486	i0	87.662	147.056962025316	154	16	96	3	2	153	8617162	8617314	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	23235	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
4917147	4917147	PRJNA436017_P_NODE_184_length_1728_cov_61.361916_g146_i0	PRJNA436017	184	1728	61.361916	1060.33390848	Pendulispora	3375062	Bacteria	Bacteria	2202	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g146	i0	89.758	166.070023148148	1738	154	100	21	1	1728	9854139	9852416	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	286969	2202	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
4917238	4917238	PRJNA436017_P_NODE_7204_length_331_cov_10.500000_g6907_i0	PRJNA436017	7204	331	10.5	34.755	Myxococcia	32015	Bacteria	Bacteria	390	5.82e-104	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g6907	i0	87.988	141.368580060423	333	36	100	4	1	331	8615314	8615644	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	46793	392	0.994897959183674	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
5534327	5534327	PRJNA436017_P_NODE_12065_length_244_cov_5.333333_g11767_i0	PRJNA436017	12065	244	5.333333	13.01333252	Labilithrix luteola	1391654	Bacteria	Bacteria	337	5.429999999999998e-88	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11767	i0	91.532	98.3647540983606	248	15	100	4	1	244	3943101	3943346	Labilithrix luteola strain DSM 27648, complete genome	blastn	24001	337	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6192068	6192068	PRJNA436017_P_NODE_185_length_1728_cov_60.814311_g146_i1	PRJNA436017	185	1728	60.814311	1050.87129408	Pendulispora	3375062	Bacteria	Bacteria	2119	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g146	i1	88.895	168.143518518519	1738	169	100	21	1	1728	9854139	9852416	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	290552	2119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
6808486	6808486	PRJNA436017_P_NODE_2186_length_640_cov_142.817579_g1943_i0	PRJNA436017	2186	640	142.817579	914.0325056	Sorangium cellulosum	56	Bacteria	Bacteria	632	1.7899999999999997e-176	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g1943	i0	84.639	124.80625	651	83	100	16	1	640	3905471	3906115	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	79876	632	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7467122	7467122	PRJNA436017_P_NODE_21906_length_175_cov_0.840580_g21608_i0	PRJNA436017	21906	175	0.84058	1.471015	Stigmatella	40	Bacteria	Bacteria	281	1.73e-71	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g21608	i0	95.954	189.114285714286	173	7	99	0	3	175	563	735	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	33095	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
7467174	7467174	PRJNA436017_P_NODE_4126_length_455_cov_1181.421053_g3835_i0	PRJNA436017	4126	455	1181.421053	5375.46579115	Pseudomonadati	3379134	Bacteria	Bacteria	549	1.2799999999999994e-151	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g3835	i0	88.571	255.975824175824	455	48	100	4	1	452	3691944	3692397	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	116469	549	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10017162	10017162	PRJNA436017_P_NODE_2288_length_627_cov_7.049153_g2039_i0	PRJNA436017	2288	627	7.049153	44.19818931	Myxococcia	32015	Bacteria	Bacteria	645	2.239999999999999e-180	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2039	i0	85.512	161.349282296651	635	72	99	17	1	620	3941765	3942394	Labilithrix luteola strain DSM 27648, complete genome	blastn	101166	649	0.993836671802773	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11909596	11909596	PRJNA436017_P_NODE_22930_length_170_cov_2.203008_g22632_i0	PRJNA436017	22930	170	2.203008	3.7451136	Pendulispora albinea	2741071	Bacteria	Bacteria	206	1.03e-48	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g22632	i0	89.937	63.7764705882353	159	16	95	0	12	170	3589270	3589112	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	10842	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
12567830	12567830	PRJNA436017_P_NODE_1550_length_758_cov_181.104022_g1343_i0	PRJNA436017	1550	758	181.104022	1372.76848676	Sorangium	39643	Bacteria	Bacteria	1066	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g1343	i0	92.196	159.79419525066	756	56	99	3	4	758	1204	451	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	121124	1066	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12567899	12567899	PRJNA436017_P_NODE_26210_length_159_cov_1.540984_g25912_i0	PRJNA436017	26210	159	1.540984	2.45016456	Pseudomonadati	3379134	Bacteria	Bacteria	99	1.67e-16	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g25912	i0	89.61	10.188679245283	77	8	48	0	1	77	3767962	3768038	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1620	100	0.99	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
14459867	14459867	PRJNA436017_P_NODE_9892_length_275_cov_1.949580_g9594_i0	PRJNA436017	9892	275	1.94958	5.361345	Polyangium aurulentum	2567896	Bacteria	Bacteria	209	1.42e-49	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g9594	i0	86.528	120.927272727273	193	23	69	3	86	275	443239	443431	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	33255	209	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
15116859	15116859	PRJNA436017_P_NODE_24412_length_165_cov_1.468750_g24114_i0	PRJNA436017	24412	165	1.46875	2.4234375	Haliangium	162027	Bacteria	Bacteria	147	6.149999999999999e-31	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g24114	i0	84.564	164.836363636364	149	21	90	2	1	148	978	1125	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	27198	147	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
16391568	16391568	PRJNA436017_P_NODE_20753_length_179_cov_5.936620_g20455_i0	PRJNA436017	20753	179	5.93662	10.6265498	root	1	Root_unresolved	Root_unresolved	248	1.8e-61	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g20455	i0	92.09	161.72625698324	177	13	99	1	1	177	1789	1964	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	28949	250	0.992	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16391632	16391632	PRJNA436017_P_NODE_453_length_1265_cov_114.563518_g373_i0	PRJNA436017	453	1265	114.563518	1449.2285027	Polyangiaceae	49	Bacteria	Bacteria	1506	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g373	i0	88.37	149.002371541502	1264	132	99	15	13	1265	2677	1418	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	188488	1506	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
17666585	17666585	PRJNA436017_P_NODE_11994_length_245_cov_2.182692_g11696_i0	PRJNA436017	11994	245	2.182692	5.3475954	Sorangium	39643	Bacteria	Bacteria	165	2.72e-36	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g11696	i0	80.734	124.289795918367	218	37	90	4	1	218	3689949	3690161	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	30451	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18282460	18282460	PRJNA436017_P_NODE_25055_length_163_cov_1.230159_g24757_i0	PRJNA436017	25055	163	1.230159	2.00515917	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	213	5.89e-51	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g24757	i0	90.184	79.5460122699387	163	16	100	0	1	163	9677905	9677743	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	12966	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
18940467	18940467	PRJNA436017_P_NODE_11895_length_246_cov_6.320574_g11597_i0	PRJNA436017	11895	246	6.320574	15.54861204	Sorangium	39643	Bacteria	Bacteria	274	4.36e-69	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g11597	i0	86.8	72.5121951219512	250	27	99	6	1	245	1521	1769	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	17838	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22765976	22765976	PRJNA436017_P_NODE_1898_length_686_cov_148.597843_g1667_i0	PRJNA436017	1898	686	148.597843	1019.38120298	Polyangiaceae	49	Bacteria	Bacteria	961	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g1667	i0	92.105	164.18804664723	684	51	99	3	4	686	1204	523	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	112633	966	0.994824016563147	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23382997	23382997	PRJNA436017_P_NODE_219_length_1623_cov_64.540984_g43_i1	PRJNA436017	219	1623	64.540984	1047.50017032	Pendulispora rubella	2741070	Bacteria	Bacteria	1151	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g43	i1	81.323	178.117683302526	1451	242	89	23	184	1623	9852707	9854139	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	289085	1151	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
23383160	23383160	PRJNA436017_P_NODE_399_length_1336_cov_34.571978_g66_i1	PRJNA436017	399	1336	34.571978	461.88162608	Minicystis rosea	888845	Bacteria	Bacteria	843	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g66	i1	79.967	200.672904191617	1228	179	89	47	153	1336	13716242	13715038	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	268099	843	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
26632648	26632648	PRJNA436017_P_NODE_14081_length_222_cov_2.091892_g13783_i0	PRJNA436017	14081	222	2.091892	4.64400024	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	99.8	9.33e-23	NR	RYZ13579.1	2484252	g13783	i0	63.5	2	74	27	100	0	1	222	66	139	RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium]	diamond	444	99.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28071312	28071312	PRJNA436017_P_NODE_11725_length_249_cov_1.207547_g11427_i0	PRJNA436017	11725	249	1.207547	3.00679203	Pseudomonadati	3379134	Bacteria	Bacteria	67.8	8.32e-12	NR	NOY87572.1	2026735	g11427	i0	60	4.19277108433735	50	20	60.2	0	249	100	125	174	NOY87572.1 AmmeMemoRadiSam system protein A [Deltaproteobacteria bacterium]	diamond	1044	68.2	0.994134897360704	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29822884	29822884	PRJNA436017_P_NODE_4631_length_427_cov_2.482051_g4335_i0	PRJNA436017	4631	427	2.482051	10.59835777	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	179	2.2299999999999998e-54	NR	RTZ91411.1	2026735	g4335	i0	60.5	2.62060889929742	124	49	87.1	0	54	425	24	147	RTZ91411.1 MAG: hypothetical protein DSY91_05075 [Deltaproteobacteria bacterium]	diamond	1119	179	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30282210	30282210	PRJNA436017_P_NODE_25972_length_160_cov_1.252033_g25674_i0	PRJNA436017	25972	160	1.252033	2.0032528	Bacteria	2	Bacteria	Bacteria	61.6	2.54e-9	NR	HIM03099.1	2026763	g25674	i0	55.8	4.875	52	16	97.5	1	158	3	968	1012	HIM03099.1 pyruvate, phosphate dikinase [Myxococcales bacterium]	diamond	780	61.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31371607	31371607	PRJNA436017_P_NODE_14236_length_221_cov_1.385870_g13938_i0	PRJNA436017	14236	221	1.38587	3.0627727	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	64.3	5.31e-10	NR	BDD48268.1	2026735	g13938	i0	43.7	0.963800904977376	71	40	96.4	0	217	5	3	73	BDD48268.1 hypothetical protein 1 [Deltaproteobacteria bacterium]	diamond	213	64.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32320840	32320840	PRJNA436017_P_NODE_26979_length_157_cov_1.300000_g26681_i0	PRJNA436017	26979	157	1.3	2.041	Plesiocystis pacifica	191768	Bacteria	Bacteria	45.4	0.0013	NR	WP_006973217.1	191768	g26681	i0	71	2.42675159235669	31	9	59.2	0	94	2	5	35	WP_006973217.1 adenosylhomocysteinase [Plesiocystis pacifica]	diamond	381	45.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Plesiocystis	Plesiocystis pacifica
32762451	32762451	PRJNA436017_P_NODE_11620_length_250_cov_1.436620_g11322_i0	PRJNA436017	11620	250	1.43662	3.59155	Myxococcota bacterium	2818507	Bacteria	Bacteria	50.4	6.88e-6	NR	MEC8422185.1	2818507	g11322	i0	42.5	0.96	80	43	92.4	1	236	6	4	83	MEC8422185.1 hypothetical protein [Myxococcota bacterium]	diamond	240	50.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32793722	32793722	PRJNA436017_P_NODE_7460_length_325_cov_2.454861_g7163_i0	PRJNA436017	7460	325	2.454861	7.97829825	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	84.3	3.67e-18	NR	HEU18094.1	2026735	g7163	i0	44.3	1.82769230769231	97	53	89.5	1	3	293	43	138	HEU18094.1 acyl-CoA thioesterase [Deltaproteobacteria bacterium]	diamond	594	84.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;