metadata: contig_metadata: 29 rows where bioproject = "PRJNA540466" and tax

29 rows where bioproject = "PRJNA540466" 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
1783569	1783569	PRJNA540466_S_NODE_51802_length_260_cov_3.021390_g51253_i0	PRJNA540466	51802	260	3.02139	7.855614	Pendulispora brunnea	2905690	Bacteria	Bacteria	58.4	5.09e-4	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g51253	i0	97.059	0.130769230769231	34	1	13	0	91	124	4167438	4167471	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
8160684	8160684	PRJNA540466_S_NODE_2127_length_841_cov_19.052083_g1854_i0	PRJNA540466	2127	841	19.052083	160.22801803	Pseudomonadati	3379134	Bacteria	Bacteria	307	6.6e-94	NR	MCB9640303.1	2026763	g1854	i0	58.8	18.3923900118906	245	97	86	1	840	118	709	953	MCB9640303.1 aminomethyl-transferring glycine dehydrogenase [Myxococcales bacterium]	diamond	15468	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
13262128	13262128	PRJNA540466_S_NODE_71811_length_202_cov_4.186047_g71262_i0	PRJNA540466	71811	202	4.186047	8.45581494	Myxococcus fulvus	33	Bacteria	Bacteria	200	5.929999999999999e-47	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g71262	i0	87.719	12.990099009901	171	21	85	0	10	180	127515	127685	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	2624	200	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
23460075	23460075	PRJNA540466_S_NODE_19859_length_397_cov_1.234568_g19310_i0	PRJNA540466	19859	397	1.234568	4.90123496	Paraliomyxa miuraensis	376150	Bacteria	Bacteria	173	2.1999999999999998e-48	NR	WP_266221892.1	376150	g19310	i0	82.5	0.732997481108312	97	17	73.3	0	2	292	104	200	WP_266221892.1 serine/threonine-protein kinase [Paraliomyxa miuraensis]	diamond	291	173	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales		Paraliomyxa	Paraliomyxa miuraensis
27314155	27314155	PRJNA540466_S_NODE_24683_length_359_cov_1.342657_g24134_i0	PRJNA540466	24683	359	1.342657	4.82013863	Bacteria	2	Bacteria	Bacteria	167	1.25e-50	NR	MDF1563219.1	2026735	g24134	i0	71.4	36.2423398328691	105	30	87.7	0	45	359	4	108	MDF1563219.1 rubrerythrin family protein [Deltaproteobacteria bacterium]	diamond	13011	168	0.994047619047619	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27330812	27330812	PRJNA540466_S_NODE_30363_length_327_cov_1.019685_g29814_i0	PRJNA540466	30363	327	1.019685	3.33436995	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	79.7	1.91e-15	NR	MCB9610633.1	2268199	g29814	i0	45.5	1.81651376146789	99	52	90.8	2	309	13	130	226	MCB9610633.1 N-formylglutamate amidohydrolase [Polyangiaceae bacterium]	diamond	594	79.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27850699	27850699	PRJNA540466_S_NODE_39264_length_292_cov_3.378995_g38715_i0	PRJNA540466	39264	292	3.378995	9.8666654	Bacteria	2	Bacteria	Bacteria	68.6	5.18e-11	NR	MEO8179397.1	2026735	g38715	i0	76.6	2.41438356164384	47	11	48.3	0	178	38	337	383	MEO8179397.1 phosphoglycerate kinase [Deltaproteobacteria bacterium]	diamond	705	68.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28071764	28071764	PRJNA540466_S_NODE_61925_length_244_cov_1.263158_g61376_i0	PRJNA540466	61925	244	1.263158	3.08210552	Bacteria	2	Bacteria	Bacteria	45.8	0.00298	NR	MBO6935416.1	2026735	g61376	i0	75	0.922131147540984	24	6	29.5	0	1	72	332	355	MBO6935416.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	225	46.2	0.991341991341991	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28120093	28120093	PRJNA540466_S_NODE_30805_length_325_cov_1.246032_g30256_i0	PRJNA540466	30805	325	1.246032	4.049604	Myxococcus xanthus	34	Bacteria	Bacteria	51.2	2.43e-5	NR	WP_140799318.1	34	g30256	i0	71.4	0.535384615384615	28	8	25.8	0	64	147	38	65	WP_140799318.1 c-type cytochrome [Myxococcus xanthus]	diamond	174	51.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
28246221	28246221	PRJNA540466_S_NODE_7886_length_583_cov_7.445098_g7396_i0	PRJNA540466	7886	583	7.445098	43.40492134	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	144	4.49e-38	NR	RYZ16148.1	2484252	g7396	i0	53.7	0.622641509433962	121	55	62.3	1	10	372	205	324	RYZ16148.1 MAG: glycoside hydrolase, partial [Myxococcaceae bacterium]	diamond	363	144	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28435955	28435955	PRJNA540466_S_NODE_71786_length_202_cov_4.782946_g71237_i0	PRJNA540466	71786	202	4.782946	9.66155092	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	45.8	0.00175	NR	MBI5516620.1	2026735	g71237	i0	63.3	0.445544554455446	30	11	44.6	0	39	128	125	154	MBI5516620.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	90	45.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28829535	28829535	PRJNA540466_S_NODE_46088_length_273_cov_1.950000_g45539_i0	PRJNA540466	46088	273	1.95	5.3235	Pseudomonadati	3379134	Bacteria	Bacteria	51.2	5.81e-5	NR	MEI6261627.1	2026735	g45539	i0	43.2	2.46153846153846	44	25	48.4	0	1	132	989	1032	MEI6261627.1 PAS domain S-box protein [Deltaproteobacteria bacterium]	diamond	672	51.6	0.992248062015504	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29113889	29113889	PRJNA540466_S_NODE_43168_length_281_cov_1.115385_g42619_i0	PRJNA540466	43168	281	1.115385	3.13423185	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.00123	NR	MCB9539227.1	2026763	g42619	i0	40	1.15302491103203	55	32	58.7	1	280	116	113	166	MCB9539227.1 pyridoxamine 5'-phosphate oxidase family protein [Myxococcales bacterium]	diamond	324	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29208699	29208699	PRJNA540466_S_NODE_55149_length_254_cov_1.331492_g54600_i0	PRJNA540466	55149	254	1.331492	3.38198968	Archangium	47	Bacteria	Bacteria	47.4	9.94e-4	NR	WP_395824820.1	83450	g54600	i0	51.3	1.85433070866142	39	19	46.1	0	244	128	585	623	WP_395824820.1 S8 family serine peptidase [Archangium minus]	diamond	471	47.8	0.99163179916318	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
29319875	29319875	PRJNA540466_S_NODE_59729_length_247_cov_1.114943_g59180_i0	PRJNA540466	59729	247	1.114943	2.75390921	Nannocystis sp.	1962667	Bacteria	Bacteria	120	2.8e-32	NR	HEY0135474.1	1962667	g59180	i0	83.6	0.88663967611336	73	12	88.7	0	226	8	115	187	HEY0135474.1 sigma-70 family RNA polymerase sigma factor [Nannocystis sp.]	diamond	219	120	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
29492681	29492681	PRJNA540466_S_NODE_31430_length_322_cov_1.301205_g30881_i0	PRJNA540466	31430	322	1.301205	4.1898801	Bacteria	2	Bacteria	Bacteria	121	5.23e-32	NR	WP_012233550.1	56	g30881	i0	52.8	3.95031055900621	106	47	97.8	2	321	7	45	148	WP_012233550.1 DUF1990 family protein [Sorangium cellulosum]	diamond	1272	121	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
29492685	29492685	PRJNA540466_S_NODE_41730_length_285_cov_1.103774_g41181_i0	PRJNA540466	41730	285	1.103774	3.1457559	Labilithrix	1524217	Bacteria	Bacteria	57.8	5e-8	NR	MDB4942166.1	1971228	g41181	i0	42.7	3.09473684210526	75	43	78.9	0	10	234	63	137	MDB4942166.1 uncharacterized protein [Labilithrix sp.]	diamond	882	57.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
29540825	29540825	PRJNA540466_S_NODE_4590_length_690_cov_3.675851_g4195_i0	PRJNA540466	4590	690	3.675851	25.3633719	Cystobacter fuscus	43	Bacteria	Bacteria	117	7.650000000000001e-27	NR	WP_198316543.1	43	g4195	i0	43.9	1.74782608695652	132	70	55.7	3	601	218	315	446	WP_198316543.1 EGF domain-containing protein [Cystobacter fuscus]	diamond	1206	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
29730152	29730152	PRJNA540466_S_NODE_55730_length_253_cov_1.244444_g55181_i0	PRJNA540466	55730	253	1.244444	3.14844332	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	47.4	9.76e-4	NR	MFT3698007.1	2212474	g55181	i0	50	1.63636363636364	46	22	54.5	1	28	165	189	233	MFT3698007.1 glycoside hydrolase family 43 protein [Kofleriaceae bacterium]	diamond	414	47.4	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30046094	30046094	PRJNA540466_S_NODE_52591_length_259_cov_1.241935_g52042_i0	PRJNA540466	52591	259	1.241935	3.21661165	Polyangiales bacterium	3034171	Bacteria	Bacteria	46.2	0.00257	NR	MEZ4406426.1	3034171	g52042	i0	38.5	2.28185328185328	65	40	75.3	0	26	220	241	305	MEZ4406426.1 hypothetical protein [Polyangiales bacterium]	diamond	591	46.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
30614865	30614865	PRJNA540466_S_NODE_64113_length_240_cov_3.544910_g63564_i0	PRJNA540466	64113	240	3.54491	8.507784	Polyangium jinanense	2829994	Bacteria	Bacteria	55.8	7.85e-8	NR	WP_272429125.1	2829994	g63564	i0	54.5	0.55	44	20	55	0	239	108	57	100	WP_272429125.1 peptidase inhibitor family I36 protein [Polyangium jinanense]	diamond	132	55.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium jinanense
30836123	30836123	PRJNA540466_S_NODE_48594_length_267_cov_2.474227_g48045_i0	PRJNA540466	48594	267	2.474227	6.60618609	Polyangia bacterium	3058050	Bacteria	Bacteria	55.1	1.95e-6	NR	HEY3351711.1	3058050	g48045	i0	37.7	1.68539325842697	69	43	77.5	0	44	250	78	146	HEY3351711.1 serine/threonine-protein kinase [Polyangia bacterium]	diamond	450	55.1	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31373566	31373566	PRJNA540466_S_NODE_23696_length_366_cov_2.102389_g23147_i0	PRJNA540466	23696	366	2.102389	7.69474374	Archangium sp.	1872627	Bacteria	Bacteria	43.1	0.0233	NR	WP_331110787.1	1872627	g23147	i0	29	0.762295081967213	93	60	74.6	2	365	93	12	100	WP_331110787.1 DUF4286 family protein [Archangium sp.]	diamond	279	43.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
31468512	31468512	PRJNA540466_S_NODE_60276_length_246_cov_1.705202_g59727_i0	PRJNA540466	60276	246	1.705202	4.19479692	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	45.4	0.00347	NR	HEX7703061.1	2212474	g59727	i0	43.6	3.26829268292683	39	22	47.6	0	106	222	162	200	HEX7703061.1 histidine phosphatase family protein [Kofleriaceae bacterium]	diamond	804	45.4	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31799337	31799337	PRJNA540466_S_NODE_43337_length_280_cov_2.830918_g42788_i0	PRJNA540466	43337	280	2.830918	7.9265704	Bacteria	2	Bacteria	Bacteria	109	2.3e-25	NR	MBL8636222.1	2026763	g42788	i0	67.1	1.82142857142857	85	28	91.1	0	256	2	283	367	MBL8636222.1 hypothetical protein [Myxococcales bacterium]	diamond	510	110	0.990909090909091	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32006118	32006118	PRJNA540466_S_NODE_2558_length_805_cov_7.132514_g2258_i0	PRJNA540466	2558	805	7.132514	57.4167377	Nannocystaceae bacterium	2545255	Bacteria	Bacteria	128	9.899999999999998e-32	NR	MEE9383925.1	2545255	g2258	i0	34.7	2.25093167701863	196	125	73	2	24	611	61	253	MEE9383925.1 N-formylglutamate amidohydrolase [Nannocystaceae bacterium]	diamond	1812	128	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae bacterium
32116011	32116011	PRJNA540466_S_NODE_10598_length_521_cov_3.029018_g10061_i0	PRJNA540466	10598	521	3.029018	15.78118378	Myxococcia	32015	Bacteria	Bacteria	57.8	2.81e-7	NR	MCA9639913.1	2026763	g10061	i0	40.5	2.03262955854127	84	47	48.4	2	3	254	23	103	MCA9639913.1 N-formylglutamate amidohydrolase [Myxococcales bacterium]	diamond	1059	58.2	0.993127147766323	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32432461	32432461	PRJNA540466_S_NODE_63519_length_242_cov_0.923077_g62970_i0	PRJNA540466	63519	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	76.3	1.68e-14	NR	MEE9383925.1	2545255	g62970	i0	43	1.94628099173554	79	45	97.9	0	237	1	88	166	MEE9383925.1 N-formylglutamate amidohydrolase [Nannocystaceae bacterium]	diamond	471	77	0.990909090909091	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae bacterium
32701382	32701382	PRJNA540466_S_NODE_38080_length_296_cov_2.304933_g37531_i0	PRJNA540466	38080	296	2.304933	6.82260168	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	56.2	1.26e-6	NR	MAA78745.1	2026735	g37531	i0	52.7	2.08783783783784	55	23	52.7	1	176	21	222	276	MAA78745.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	618	56.2	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);;