metadata: contig_metadata: 27 rows where bioproject = "PRJNA642647" and tax

27 rows where bioproject = "PRJNA642647" 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
3168792	3168792	PRJNA642647_P_NODE_1123_length_333_cov_4.854730_g1073_i0	PRJNA642647	1123	333	4.85473	16.1662509	Labilithrix luteola	1391654	Bacteria	Bacteria	516	9.26e-142	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1073	i0	94.848	142.621621621622	330	17	99	0	4	333	3942534	3942863	Labilithrix luteola strain DSM 27648, complete genome	blastn	47493	516	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4445696	4445696	PRJNA642647_P_NODE_5364_length_164_cov_1.929134_g5314_i0	PRJNA642647	5364	164	1.929134	3.16377976	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	158	2.82e-34	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g5314	i0	88.148	315.341463414634	135	13	81	3	31	163	8617341	8617474	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	51716	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
10822208	10822208	PRJNA642647_P_NODE_2869_length_206_cov_1.792899_g2819_i0	PRJNA642647	2869	206	1.792899	3.69337194	Labilithrix luteola	1391654	Bacteria	Bacteria	309	9.68e-80	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2819	i0	94.089	238.461165048544	203	12	99	0	1	203	3942258	3942056	Labilithrix luteola strain DSM 27648, complete genome	blastn	49123	309	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12097424	12097424	PRJNA642647_P_NODE_4290_length_175_cov_1.072464_g4240_i0	PRJNA642647	4290	175	1.072464	1.876812	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	279	6.21e-71	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g4240	i0	95.93	76.8057142857143	172	7	98	0	1	172	8615902	8616073	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	13441	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13372000	13372000	PRJNA642647_P_NODE_1651_length_270_cov_2.051502_g1601_i0	PRJNA642647	1651	270	2.051502	5.5390554	Stigmatella aurantiaca	41	Bacteria	Bacteria	246	1.06e-60	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g1601	i0	84.706	215.307407407407	255	29	93	7	14	265	322	75	S.aurantiaca 23S rRNA gene	blastn	58133	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
13372040	13372040	PRJNA642647_P_NODE_5611_length_161_cov_0.862903_g5561_i0	PRJNA642647	5611	161	0.862903	1.38927383	Myxococcales bacterium	2026763	Bacteria	Bacteria	215	1.61e-51	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g5561	i0	91.139	191.354037267081	158	14	98	0	1	158	1309887	1309730	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	30808	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
13912545	13912545	PRJNA642647_P_NODE_3971_length_180_cov_3.545455_g3921_i0	PRJNA642647	3971	180	3.545455	6.381819	Pendulispora	3375062	Bacteria	Bacteria	161	2.43e-35	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3921	i0	92.174	158.783333333333	115	7	63	1	1	113	7287283	7287169	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	28581	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21020390	21020390	PRJNA642647_P_NODE_3757_length_184_cov_2.802721_g3707_i0	PRJNA642647	3757	184	2.802721	5.15700664	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	217	5.26e-52	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g3707	i0	88.398	100.527173913043	181	19	97	2	6	184	8616426	8616246	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	18497	217	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
22295099	22295099	PRJNA642647_P_NODE_5998_length_156_cov_1.100840_g5948_i0	PRJNA642647	5998	156	1.10084	1.7173104	Chondromyces crocatus	52	Bacteria	Bacteria	209	7.2e-50	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g5948	i0	91.503	259.820512820513	153	12	98	1	4	156	1404	1253	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	40532	209	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
26796469	26796469	PRJNA642647_P_NODE_5921_length_157_cov_0.916667_g5871_i0	PRJNA642647	5921	157	0.916667	1.43916719	Corallococcus exiguus	83462	Bacteria	Bacteria	42.7	0.0112	NR	WP_206884372.1	83462	g5871	i0	51.5	1.31847133757962	33	16	63.1	0	149	51	227	259	WP_206884372.1 HNH endonuclease [Corallococcus exiguus]	diamond	207	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exiguus
27460620	27460620	PRJNA642647_P_NODE_2483_length_219_cov_2.510989_g2433_i0	PRJNA642647	2483	219	2.510989	5.49906591	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	40	0.0499	NR	HQP34498.1	2268199	g2433	i0	66.7	0.328767123287671	24	8	32.9	0	128	57	46	69	HQP34498.1 hypothetical protein [Polyangiaceae bacterium]	diamond	72	40	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27492121	27492121	PRJNA642647_P_NODE_1323_length_304_cov_2.063670_g1273_i0	PRJNA642647	1323	304	2.06367	6.2735568	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	69.3	2.1e-12	NR	MBK9260809.1	2268199	g1273	i0	38.8	1.14473684210526	116	29	73	2	5	226	26	141	MBK9260809.1 hypothetical protein [Polyangiaceae bacterium]	diamond	348	69.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27902315	27902315	PRJNA642647_P_NODE_2885_length_205_cov_4.672619_g2835_i0	PRJNA642647	2885	205	4.672619	9.57886895	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	63.2	8.68e-10	NR	MBK9263032.1	2268199	g2835	i0	61	0.6	41	13	55.6	1	200	87	229	269	MBK9263032.1 PD-(D/E)XK nuclease-like domain-containing protein [Polyangiaceae bacterium]	diamond	123	63.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28028933	28028933	PRJNA642647_P_NODE_5685_length_160_cov_1.186992_g5635_i0	PRJNA642647	5685	160	1.186992	1.8991872	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	41.2	0.0149	NR	HHD11908.1	2026735	g5635	i0	40.5	0.69375	37	22	69.4	0	4	114	71	107	HHD11908.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	111	41.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28091909	28091909	PRJNA642647_P_NODE_4185_length_176_cov_3.597122_g4135_i0	PRJNA642647	4185	176	3.597122	6.33093472	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	56.2	7.47e-8	NR	MCU0689773.1	2268199	g4135	i0	82.1	0.477272727272727	28	5	47.7	0	6	89	24	51	MCU0689773.1 HNH endonuclease [Polyangiaceae bacterium]	diamond	84	56.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28407770	28407770	PRJNA642647_P_NODE_866_length_380_cov_1.930029_g816_i0	PRJNA642647	866	380	1.930029	7.3341102	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	124	1.89e-30	NR	MCL2724853.1	2268199	g816	i0	70.5	0.694736842105263	88	26	69.5	0	265	2	336	423	MCL2724853.1 hypothetical protein [Polyangiaceae bacterium]	diamond	264	124	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28660401	28660401	PRJNA642647_P_NODE_2547_length_216_cov_3.921788_g2497_i0	PRJNA642647	2547	216	3.921788	8.47106208	Labilithrix luteola	1391654	Bacteria	Bacteria	48.5	1.43e-4	NR	AKU93339.1	1391654	g2497	i0	56.9	0.708333333333333	51	16	69.4	2	57	206	116	161	AKU93339.1 hypothetical protein AKJ09_00003 [Labilithrix luteola]	diamond	153	48.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
28692067	28692067	PRJNA642647_P_NODE_5887_length_157_cov_1.800000_g5837_i0	PRJNA642647	5887	157	1.8	2.826	Myxococcales bacterium	2026763	Bacteria	Bacteria	87.4	4.67e-20	NR	MBL0197634.1	2026763	g5837	i0	95.3	0.821656050955414	43	2	82.2	0	28	156	1	43	MBL0197634.1 hypothetical protein [Myxococcales bacterium]	diamond	129	87.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28912621	28912621	PRJNA642647_P_NODE_3228_length_196_cov_1.509434_g3178_i0	PRJNA642647	3228	196	1.509434	2.95849064	Polyangium sp.	3409587	Bacteria	Bacteria	67	8.49e-12	NR	HMY20343.1	57	g3178	i0	84.6	0.596938775510204	39	6	59.7	0	195	79	138	176	HMY20343.1 hypothetical protein [Polyangium sp.]	diamond	117	67	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium sp.
29134078	29134078	PRJNA642647_P_NODE_3829_length_183_cov_1.760274_g3779_i0	PRJNA642647	3829	183	1.760274	3.22130142	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	56.6	2.2e-8	NR	MDP3937728.1	2026735	g3779	i0	48.3	0.950819672131147	58	28	91.8	1	183	16	55	112	MDP3937728.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	174	56.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29260002	29260002	PRJNA642647_P_NODE_3969_length_180_cov_3.671329_g3919_i0	PRJNA642647	3969	180	3.671329	6.6083922	Labilithrix sp.	1971228	Bacteria	Bacteria	77.4	7.73e-15	NR	MBX3218891.1	1971228	g3919	i0	66.1	2.98333333333333	59	20	98.3	0	2	178	92	150	MBX3218891.1 hypothetical protein [Labilithrix sp.]	diamond	537	77.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30555003	30555003	PRJNA642647_P_NODE_5073_length_166_cov_2.891473_g5023_i0	PRJNA642647	5073	166	2.891473	4.79984518	Myxococcales bacterium	2026763	Bacteria	Bacteria	45.4	5.73e-4	NR	MBL0197454.1	2026763	g5023	i0	76	0.451807228915663	25	6	45.2	0	165	91	68	92	MBL0197454.1 DUF2190 family protein [Myxococcales bacterium]	diamond	75	45.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31123555	31123555	PRJNA642647_P_NODE_4055_length_179_cov_1.563380_g4005_i0	PRJNA642647	4055	179	1.56338	2.7984502	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	42	0.0299	NR	MEZ4219428.1	2268199	g4005	i0	40.8	0.82122905027933	49	29	82.1	0	27	173	270	318	MEZ4219428.1 CxxxxCH/CxxCH domain-containing protein [Polyangiaceae bacterium]	diamond	147	42	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31926843	31926843	PRJNA642647_P_NODE_4277_length_175_cov_1.463768_g4227_i0	PRJNA642647	4277	175	1.463768	2.561594	Myxococcia	32015	Bacteria	Bacteria	58.9	1.07e-8	NR	MFO0712413.1	2024858	g4227	i0	57.1	17.7257142857143	56	24	96	0	171	4	136	191	MFO0712413.1 sigma factor-like helix-turn-helix DNA-binding protein [Sandaracinus sp.]	diamond	3102	59.3	0.993254637436762	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus sp.
32104393	32104393	PRJNA642647_P_NODE_2558_length_216_cov_2.849162_g2508_i0	PRJNA642647	2558	216	2.849162	6.15418992	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57	2.34e-7	NR	MCL2777727.1	2268199	g2508	i0	60.5	0.527777777777778	38	15	52.8	0	118	5	23	60	MCL2777727.1 phage protease [Polyangiaceae bacterium]	diamond	114	57	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32673265	32673265	PRJNA642647_P_NODE_5360_length_164_cov_2.055118_g5310_i0	PRJNA642647	5360	164	2.0551179999999998	3.37039352	Pyxidicoccus xibeiensis	2906759	Bacteria	Bacteria	41.6	0.0327	NR	WP_253982249.1	2906759	g5310	i0	32	0.914634146341463	50	34	91.5	0	158	9	175	224	WP_253982249.1 hypothetical protein [Pyxidicoccus xibeiensis]	diamond	150	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus xibeiensis
32767815	32767815	PRJNA642647_P_NODE_1320_length_304_cov_2.883895_g1270_i0	PRJNA642647	1320	304	2.883895	8.7670408	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	65.5	6.21e-11	NR	MBK9260806.1	2268199	g1270	i0	66.7	0.384868421052632	39	13	38.5	0	290	174	1	39	MBK9260806.1 hypothetical protein [Polyangiaceae bacterium]	diamond	117	65.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae 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);;