metadata: contig_metadata: 31 rows where bioproject = "PRJNA1041773" and tax

31 rows where bioproject = "PRJNA1041773" 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
170866	170866	PRJNA1041773_P_NODE_80141_length_250_cov_0.870056_g79808_i0	PRJNA1041773	80141	250	0.870056	2.17514	Archangium sp.	1872627	Bacteria	Bacteria	149	8.52e-43	NR	MDP1825781.1	1872627	g79808	i0	84.3	0.996	83	13	99.6	0	249	1	126	208	MDP1825781.1 phosphatase PAP2 family protein [Archangium sp.]	diamond	249	149	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
2721339	2721339	PRJNA1041773_P_NODE_81083_length_250_cov_0.864407_g80750_i0	PRJNA1041773	81083	250	0.864407	2.1610175	Haliangium ochraceum	80816	Bacteria	Bacteria	124	4.729999999999999e-24	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g80750	i0	84.496	52.264	129	16	52	4	122	250	3369953	3370077	Haliangium ochraceum DSM 14365, complete genome	blastn	13066	124	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
2721397	2721397	PRJNA1041773_P_NODE_85123_length_248_cov_0.880000_g84790_i0	PRJNA1041773	85123	248	0.88	2.1824	Minicystis rosea	888845	Bacteria	Bacteria	222	1.62e-53	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g84790	i0	86.058	0.838709677419355	208	27	83	2	1	207	2677826	2677620	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	208	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5272953	5272953	PRJNA1041773_P_NODE_30045_length_381_cov_3.737013_g29713_i0	PRJNA1041773	30045	381	3.737013	14.23801953	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	211	5.66e-50	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g29713	i0	81.111	5.72178477690289	270	45	70	5	110	376	4744873	4745139	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	2180	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
6549079	6549079	PRJNA1041773_P_NODE_91766_length_245_cov_0.895349_g91433_i0	PRJNA1041773	91766	245	0.895349	2.19360505	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	140	4.39e-38	NR	HEX3479824.1	2212474	g91433	i0	82.1	2.86530612244898	78	14	95.5	0	11	244	227	304	HEX3479824.1 DNA methyltransferase [Kofleriaceae bacterium]	diamond	702	140	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
9098473	9098473	PRJNA1041773_P_NODE_82728_length_249_cov_0.875000_g82395_i0	PRJNA1041773	82728	249	0.875	2.17875	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	85.5	3.29e-17	NR	HSU39065.1	2268199	g82395	i0	68.9	6.07228915662651	61	19	73.5	0	184	2	39	99	HSU39065.1 serine/threonine-protein kinase [Polyangiaceae bacterium]	diamond	1512	85.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
14199482	14199482	PRJNA1041773_P_NODE_80092_length_250_cov_0.870056_g79759_i0	PRJNA1041773	80092	250	0.870056	2.17514	Polyangiales bacterium	3034171	Bacteria	Bacteria	157	1.11e-46	NR	MEZ4392350.1	3034171	g79759	i0	84.1	1.956	82	13	98.4	0	3	248	39	120	MEZ4392350.1 DUF2071 domain-containing protein [Polyangiales bacterium]	diamond	489	157	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
17586404	17586404	PRJNA1041773_P_NODE_64094_length_272_cov_1.547739_g63761_i0	PRJNA1041773	64094	272	1.547739	4.20985008	Pseudomonadati	3379134	Bacteria	Bacteria	171	6.599999999999999e-38	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g63761	i0	78.755	98.4154411764706	273	44	100	11	1	272	1950081	1949822	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	26769	171	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
18022937	18022937	PRJNA1041773_P_NODE_94275_length_244_cov_0.900585_g93942_i0	PRJNA1041773	94275	244	0.900585	2.1974274	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	152	2.11e-32	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g93942	i0	82.386	64.8893442622951	176	29	72	2	37	211	806753	806927	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	15833	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
23122833	23122833	PRJNA1041773_P_NODE_61959_length_276_cov_1.517241_g61626_i0	PRJNA1041773	61959	276	1.517241	4.18758516	Haliangium ochraceum	80816	Bacteria	Bacteria	211	3.96e-50	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g61626	i0	84.332	7.04347826086957	217	32	78	2	61	276	3341019	3340804	Haliangium ochraceum DSM 14365, complete genome	blastn	1944	211	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23123253	23123253	PRJNA1041773_P_NODE_89419_length_246_cov_0.890173_g89086_i0	PRJNA1041773	89419	246	0.890173	2.18982558	Sorangium	39643	Bacteria	Bacteria	138	3.1e-36	NR	WP_012240201.1	56	g89086	i0	84	3.95121951219512	81	13	98.8	0	244	2	88	168	WP_012240201.1 cytochrome c oxidase subunit I [Sorangium cellulosum]	diamond	972	138	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
26710297	26710297	PRJNA1041773_P_NODE_95641_length_243_cov_0.905882_g95308_i0	PRJNA1041773	95641	243	0.905882	2.20129326	Corallococcus	83461	Bacteria	Bacteria	102	2.62e-26	NR	WP_120597202.1	83462	g95308	i0	94.4	1.51851851851852	54	3	66.7	0	81	242	1	54	WP_120597202.1 hypothetical protein [Corallococcus exiguus]	diamond	369	103	0.990291262135922	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exiguus
27382980	27382980	PRJNA1041773_P_NODE_57703_length_284_cov_2.014218_g57370_i0	PRJNA1041773	57703	284	2.014218	5.72037912	Polyangiales bacterium	3034171	Bacteria	Bacteria	176	1.0999999999999999e-48	NR	MFO0652676.1	3034171	g57370	i0	89.2	3.9612676056338	93	10	98.2	0	282	4	529	621	MFO0652676.1 TonB family protein [Polyangiales bacterium]	diamond	1125	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
27414722	27414722	PRJNA1041773_P_NODE_105343_length_227_cov_2.701299_g105010_i0	PRJNA1041773	105343	227	2.701299	6.13194873	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	100	5.1399999999999994e-24	NR	NCC25966.1	2026735	g105010	i0	58.7	0.991189427312775	75	31	99.1	0	225	1	99	173	NCC25966.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	225	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28014566	28014566	PRJNA1041773_P_NODE_89365_length_246_cov_0.890173_g89032_i0	PRJNA1041773	89365	246	0.890173	2.18982558	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	100	2.1e-24	NR	HEY8086443.1	2268199	g89032	i0	41.4	3.4390243902439	140	21	96.3	2	239	3	1	140	HEY8086443.1 hypothetical protein [Polyangiaceae bacterium]	diamond	846	100	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28108923	28108923	PRJNA1041773_P_NODE_100505_length_241_cov_0.916667_g100172_i0	PRJNA1041773	100505	241	0.916667	2.20916747	Polyangiales bacterium	3034171	Bacteria	Bacteria	113	3.22e-29	NR	MFO0609024.1	3034171	g100172	i0	88.4	0.858921161825726	69	8	85.9	0	240	34	134	202	MFO0609024.1 GPR1/FUN34/YaaH family transporter [Polyangiales bacterium]	diamond	207	113	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
28140921	28140921	PRJNA1041773_P_NODE_100525_length_241_cov_0.916667_g100192_i0	PRJNA1041773	100525	241	0.916667	2.20916747	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	95.5	3.72e-23	NR	HEX6766013.1	2268199	g100192	i0	60	0.995850622406639	80	32	99.6	0	1	240	48	127	HEX6766013.1 YbjN domain-containing protein [Polyangiaceae bacterium]	diamond	240	95.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28172168	28172168	PRJNA1041773_P_NODE_101926_length_241_cov_0.869048_g101593_i0	PRJNA1041773	101926	241	0.869048	2.09440568	Myxococcota bacterium	2818507	Bacteria	Bacteria	142	8.609999999999998e-39	NR	MEC7240731.1	2818507	g101593	i0	90	0.995850622406639	80	8	99.6	0	241	2	22	101	MEC7240731.1 ADP-forming succinate--CoA ligase subunit beta [Myxococcota bacterium]	diamond	240	142	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28393247	28393247	PRJNA1041773_P_NODE_57806_length_284_cov_1.459716_g57473_i0	PRJNA1041773	57806	284	1.459716	4.14559344	Myxococcota bacterium	2818507	Bacteria	Bacteria	153	6.81e-42	NR	MEZ0314332.1	2818507	g57473	i0	76.6	0.992957746478873	94	22	99.3	0	1	282	76	169	MEZ0314332.1 hypothetical protein [Myxococcota bacterium]	diamond	282	153	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29592673	29592673	PRJNA1041773_P_NODE_93850_length_244_cov_0.900585_g93517_i0	PRJNA1041773	93850	244	0.900585	2.1974274	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	97.1	7.559999999999999e-23	NR	MCU0657106.1	2268199	g93517	i0	64.2	1.99180327868852	81	29	99.6	0	243	1	64	144	MCU0657106.1 hypothetical protein [Polyangiaceae bacterium]	diamond	486	97.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30383200	30383200	PRJNA1041773_P_NODE_91913_length_245_cov_0.895349_g91580_i0	PRJNA1041773	91913	245	0.895349	2.19360505	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	107	5.94e-25	NR	MBV8137559.1	2026735	g91580	i0	58.5	2.87755102040816	82	31	96.7	1	9	245	58	139	MBV8137559.1 glycosyltransferase family 39 protein [Deltaproteobacteria bacterium]	diamond	705	107	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30414692	30414692	PRJNA1041773_P_NODE_81533_length_249_cov_1.681818_g81200_i0	PRJNA1041773	81533	249	1.681818	4.18772682	Archangium sp.	1872627	Bacteria	Bacteria	128	5.9100000000000005e-33	NR	MDP3155111.1	1872627	g81200	i0	72	0.987951807228916	82	23	98.8	0	247	2	362	443	MDP3155111.1 tetratricopeptide repeat protein [Archangium sp.]	diamond	246	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
30509166	30509166	PRJNA1041773_P_NODE_84853_length_248_cov_0.880000_g84520_i0	PRJNA1041773	84853	248	0.88	2.1824	Myxococcota bacterium	2818507	Bacteria	Bacteria	114	2.5900000000000003e-27	NR	MEW6430003.1	2818507	g84520	i0	70.9	0.955645161290323	79	23	95.6	0	248	12	460	538	MEW6430003.1 TonB family protein [Myxococcota bacterium]	diamond	237	114	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30730288	30730288	PRJNA1041773_P_NODE_79174_length_250_cov_1.740113_g78841_i0	PRJNA1041773	79174	250	1.740113	4.3502825	Polyangiales bacterium	3034171	Bacteria	Bacteria	132	1.46e-34	NR	MFO0605650.1	3034171	g78841	i0	74.7	0.996	83	21	99.6	0	249	1	194	276	MFO0605650.1 AarF/ABC1/UbiB kinase family protein [Polyangiales bacterium]	diamond	249	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
30793416	30793416	PRJNA1041773_P_NODE_68134_length_265_cov_1.604167_g67801_i0	PRJNA1041773	68134	265	1.604167	4.25104255	Myxococcales bacterium	2026763	Bacteria	Bacteria	128	4.149999999999999e-32	NR	MBK8216952.1	2026763	g67801	i0	74.7	0.984905660377358	87	22	98.5	0	1	261	604	690	MBK8216952.1 hypothetical protein [Myxococcales bacterium]	diamond	261	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31362564	31362564	PRJNA1041773_P_NODE_95736_length_243_cov_0.905882_g95403_i0	PRJNA1041773	95736	243	0.905882	2.20129326	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	163	2.31e-50	NR	HBM54255.1	2026735	g95403	i0	96.3	0.987654320987654	80	3	98.8	0	242	3	6	85	HBM54255.1 high potential iron-sulfur protein [Deltaproteobacteria bacterium]	diamond	240	163	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31584007	31584007	PRJNA1041773_P_NODE_68196_length_265_cov_1.598958_g67863_i0	PRJNA1041773	68196	265	1.598958	4.2372387	Myxococcota bacterium	2818507	Bacteria	Bacteria	129	1.05e-33	NR	MDQ2644454.1	2818507	g67863	i0	91.9	0.70188679245283	62	5	70.2	0	2	187	323	384	MDQ2644454.1 hypothetical protein [Myxococcota bacterium]	diamond	186	129	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31710348	31710348	PRJNA1041773_P_NODE_91117_length_245_cov_0.895349_g90784_i0	PRJNA1041773	91117	245	0.895349	2.19360505	Archangium sp.	1872627	Bacteria	Bacteria	65.9	2.8e-10	NR	MDP1824164.1	1872627	g90784	i0	47.5	0.979591836734694	80	42	98	0	240	1	906	985	MDP1824164.1 hypothetical protein [Archangium sp.]	diamond	240	65.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
31931623	31931623	PRJNA1041773_P_NODE_67097_length_267_cov_1.484536_g66764_i0	PRJNA1041773	67097	267	1.484536	3.96371112	Polyangiales bacterium	3034171	Bacteria	Bacteria	115	1.34e-28	NR	MFO0626425.1	3034171	g66764	i0	64	1	89	28	100	1	1	267	74	158	MFO0626425.1 hypothetical protein [Polyangiales bacterium]	diamond	267	115	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
32564867	32564867	PRJNA1041773_P_NODE_94759_length_244_cov_0.877193_g94426_i0	PRJNA1041773	94759	244	0.877193	2.14035092	Stigmatella aurantiaca DW4/3-1	378806	Bacteria	Bacteria	42.7	0.0338	NR	ADO69156.1	378806	g94426	i0	38.8	0.823770491803279	67	38	82.4	1	9	209	177	240	ADO69156.1 uncharacterized protein STAUR_1352 [Stigmatella aurantiaca DW4/3-1]	diamond	201	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
32839797	32839797	PRJNA1041773_P_NODE_101860_length_241_cov_0.892857_g101527_i0	PRJNA1041773	101860	241	0.892857	2.15178537	Myxococcota	2818505	Bacteria	Bacteria	143	1.7899999999999998e-37	NR	HIN86283.1	2026763	g101527	i0	75	16.9419087136929	80	20	99.6	0	240	1	754	833	HIN86283.1 4Fe-4S dicluster domain-containing protein [Myxococcales bacterium]	diamond	4083	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;