metadata: contig_metadata: 19 rows where bioproject = "PRJNA627467", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA627467", tax_kingdom = "Pseudomonadati" 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
4979207	4979207	PRJNA627467_P_NODE_964_length_370_cov_1.644860_g897_i0	PRJNA627467	964	370	1.64486	6.085982	Sorangium	39643	Bacteria	Bacteria	265	4.15e-66	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g897	i0	98.026	69.5567567567568	152	3	67	0	218	369	2994758	2994909	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	25736	265	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6254487	6254487	PRJNA627467_P_NODE_18505_length_162_cov_4.088496_g18436_i0	PRJNA627467	18505	162	4.088496	6.62336352	Myxococcia	32015	Bacteria	Bacteria	235	1.25e-57	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g18436	i0	95.862	178.598765432099	145	6	90	0	17	161	2550	2406	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	28933	235	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
9527528	9527528	PRJNA627467_P_NODE_13508_length_176_cov_1.346457_g13439_i0	PRJNA627467	13508	176	1.346457	2.36976432	Corallococcus coralloides	184914	Bacteria	Bacteria	139	1.11e-28	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g13439	i0	87.603	14.5681818181818	121	13	69	2	56	176	2286242	2286124	Corallococcus coralloides DSM 2259, complete genome	blastn	2564	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
9527534	9527534	PRJNA627467_P_NODE_14148_length_173_cov_5.241935_g14079_i0	PRJNA627467	14148	173	5.241935	9.06854755	Pendulispora albinea	2741071	Bacteria	Bacteria	193	8.21e-45	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g14079	i0	87.574	16.8901734104046	169	17	97	4	1	167	8305501	8305667	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	2922	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15179286	15179286	PRJNA627467_P_NODE_4932_length_316_cov_1.647940_g4864_i0	PRJNA627467	4932	316	1.64794	5.2074904	Pendulispora	3375062	Bacteria	Bacteria	169	2.8199999999999997e-37	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g4864	i0	97.938	76.0253164556962	97	2	59	0	217	313	7288890	7288986	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	24024	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16453536	16453536	PRJNA627467_P_NODE_15993_length_167_cov_11.279661_g15924_i0	PRJNA627467	15993	167	11.279661	18.83703387	Myxococcaceae	31	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|1669280777\|gb\|MK968787.1\|	33	g15924	i0	99.394	110.658682634731	165	0	98	1	4	167	451	287	Myxococcus fulvus strain 2 16S ribosomal RNA gene, partial sequence	blastn	18480	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
21552842	21552842	PRJNA627467_P_NODE_6037_length_315_cov_1.695489_g5969_i0	PRJNA627467	6037	315	1.695489	5.34079035	Minicystis sp.	1971901	Bacteria	Bacteria	55.1	4.14e-6	NR	MFT3775382.1	1971901	g5969	i0	38.2	2.08571428571429	110	18	98.1	2	309	1	107	173	MFT3775382.1 hypothetical protein [Minicystis sp.]	diamond	657	55.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
26872230	26872230	PRJNA627467_P_NODE_9481_length_189_cov_3.564286_g9412_i0	PRJNA627467	9481	189	3.564286	6.73650054	Pseudomonadati	3379134	Bacteria	Bacteria	79.7	2.93e-16	NR	MBI3544197.1	2026735	g9412	i0	54.1	4.85714285714286	61	28	96.8	0	185	3	56	116	MBI3544197.1 adenylyl-sulfate kinase [Deltaproteobacteria bacterium]	diamond	918	79.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27333638	27333638	PRJNA627467_P_NODE_17863_length_164_cov_0.886957_g17794_i0	PRJNA627467	17863	164	0.886957	1.45460948	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	55.8	2.24e-7	NR	MBN8553904.1	2026735	g17794	i0	54.2	0.878048780487805	48	22	87.8	0	159	16	206	253	MBN8553904.1 ribosomal RNA small subunit methyltransferase A [Deltaproteobacteria bacterium]	diamond	144	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27428468	27428468	PRJNA627467_P_NODE_12063_length_181_cov_1.234848_g11994_i0	PRJNA627467	12063	181	1.234848	2.23507488	Myxococcales bacterium	2026763	Bacteria	Bacteria	65.1	2.13e-10	NR	MBL8606704.1	2026763	g11994	i0	48.2	0.92817679558011	56	29	92.8	0	175	8	315	370	MBL8606704.1 hypothetical protein [Myxococcales bacterium]	diamond	168	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28501835	28501835	PRJNA627467_P_NODE_11027_length_184_cov_2.059259_g10958_i0	PRJNA627467	11027	184	2.059259	3.78903656	Myxococcales bacterium	2026763	Bacteria	Bacteria	95.5	7.82e-22	NR	MBN9166958.1	2026763	g10958	i0	81	0.945652173913043	58	11	94.6	0	3	176	88	145	MBN9166958.1 type II secretion system F family protein [Myxococcales bacterium]	diamond	174	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29209321	29209321	PRJNA627467_P_NODE_4009_length_316_cov_1.861423_g3941_i0	PRJNA627467	4009	316	1.861423	5.88209668	Pseudomonadati	3379134	Bacteria	Bacteria	48.9	5.76e-4	NR	HEY6909767.1	2026763	g3941	i0	77.8	3.33227848101266	27	6	25.6	0	6	86	438	464	HEY6909767.1 YncE family protein [Myxococcales bacterium]	diamond	1053	48.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29732912	29732912	PRJNA627467_P_NODE_13190_length_177_cov_1.539062_g13121_i0	PRJNA627467	13190	177	1.539062	2.72413974	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	69.3	2.03e-13	NR	MBI2395139.1	2026735	g13121	i0	73.2	0.949152542372881	56	12	94.9	1	174	7	37	89	MBI2395139.1 DUF167 domain-containing protein [Deltaproteobacteria bacterium]	diamond	168	69.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29827771	29827771	PRJNA627467_P_NODE_2491_length_316_cov_2.576779_g2423_i0	PRJNA627467	2491	316	2.576779	8.14262164	Myxococcota bacterium	2818507	Bacteria	Bacteria	60.8	1.46e-8	NR	MBY0402053.1	2818507	g2423	i0	96.9	0.911392405063291	32	1	30.4	0	312	217	167	198	MBY0402053.1 response regulator transcription factor [Myxococcota bacterium]	diamond	288	60.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30838878	30838878	PRJNA627467_P_NODE_12574_length_179_cov_1.538462_g12505_i0	PRJNA627467	12574	179	1.538462	2.75384698	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	106	7.410000000000001e-26	NR	HMJ51131.1	2268199	g12505	i0	78.9	0.955307262569832	57	12	95.5	0	6	176	167	223	HMJ51131.1 hypothetical protein [Polyangiaceae bacterium]	diamond	171	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30965443	30965443	PRJNA627467_P_NODE_16814_length_166_cov_1.333333_g16745_i0	PRJNA627467	16814	166	1.333333	2.21333278	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	47.4	3.09e-4	NR	HEU5074278.1	2268199	g16745	i0	55	1.62650602409639	40	18	72.3	0	5	124	368	407	HEU5074278.1 GMC family oxidoreductase [Polyangiaceae bacterium]	diamond	270	47.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31122868	31122868	PRJNA627467_P_NODE_14575_length_172_cov_2.219512_g14506_i0	PRJNA627467	14575	172	2.219512	3.81756064	Myxococcota bacterium	2818507	Bacteria	Bacteria	73.2	6.62e-15	NR	MEZ4281380.1	2818507	g14506	i0	94.7	1.37790697674419	38	2	66.3	0	22	135	1	38	MEZ4281380.1 hypothetical protein [Myxococcota bacterium]	diamond	237	73.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32198725	32198725	PRJNA627467_P_NODE_2998_length_316_cov_2.243446_g2930_i0	PRJNA627467	2998	316	2.243446	7.08928936	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	112	2.95e-26	NR	HEX5059157.1	2212474	g2930	i0	61.5	3.9493670886076	104	29	98.7	1	314	3	408	500	HEX5059157.1 ATP-binding protein [Kofleriaceae bacterium]	diamond	1248	112	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
32672638	32672638	PRJNA627467_P_NODE_5160_length_316_cov_1.610487_g5092_i0	PRJNA627467	5160	316	1.610487	5.08913892	Labilithrix luteola	1391654	Bacteria	Bacteria	63.5	4.24e-9	NR	WP_146652429.1	1391654	g5092	i0	84.8	0.617088607594937	33	5	31.3	0	217	315	423	455	WP_146652429.1 type IV pilus biogenesis protein PilM [Labilithrix luteola]	diamond	195	63.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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