metadata: contig_metadata: 18 rows where bioproject = "PRJNA1046144", tax_phylum = "Myxococcota" and tax

18 rows where bioproject = "PRJNA1046144", 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
1009487	1009487	PRJNA1046144_P_NODE_8641_length_536_cov_2.965739_g8349_i0	PRJNA1046144	8641	536	2.965739	15.89636104	Pendulispora	3375062	Bacteria	Bacteria	614	5.349999999999998e-171	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g8349	i0	87.337	295.634328358209	537	66	100	2	1	536	7289992	7289457	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	158460	614	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
1009498	1009498	PRJNA1046144_P_NODE_9761_length_506_cov_2.533181_g9468_i0	PRJNA1046144	9761	506	2.533181	12.81789586	Myxococcia	32015	Bacteria	Bacteria	592	2.3599999999999998e-164	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9468	i0	87.921	354.606719367589	505	57	99	4	1	503	3941772	3942274	Labilithrix luteola strain DSM 27648, complete genome	blastn	179431	597	0.991624790619765	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1446996	1446996	PRJNA1046144_P_NODE_40382_length_270_cov_2.348259_g40087_i0	PRJNA1046144	40382	270	2.348259	6.3402993	Labilithrix luteola	1391654	Bacteria	Bacteria	189	1.8099999999999993e-43	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g40087	i0	80	0.962962962962963	260	48	96	3	1	258	8666523	8666266	Labilithrix luteola strain DSM 27648, complete genome	blastn	260	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2284558	2284558	PRJNA1046144_P_NODE_55762_length_235_cov_1.734940_g55467_i0	PRJNA1046144	55762	235	1.73494	4.077109	Myxococcia	32015	Bacteria	Bacteria	350	6.67e-92	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g55467	i0	93.617	277.212765957447	235	14	100	1	1	235	3944632	3944399	Labilithrix luteola strain DSM 27648, complete genome	blastn	65145	350	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3998628	3998628	PRJNA1046144_P_NODE_31064_length_302_cov_1.236052_g30769_i0	PRJNA1046144	31064	302	1.236052	3.73287704	FCB group	1783270	Bacteria	Bacteria	128	5.55e-32	NR	WP_043711593.1	35	g30769	i0	61.8	12.1887417218543	102	36	98.3	2	297	1	751	852	WP_043711593.1 non-ribosomal peptide synthetase [Corallococcus macrosporus]	diamond	3681	129	0.992248062015504	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
11650792	11650792	PRJNA1046144_P_NODE_38010_length_277_cov_2.076923_g37715_i0	PRJNA1046144	38010	277	2.076923	5.75307671	Labilithrix luteola	1391654	Bacteria	Bacteria	329	1.05e-85	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g37715	i0	88.364	138.70036101083	275	30	99	2	5	277	3943227	3942953	Labilithrix luteola strain DSM 27648, complete genome	blastn	38420	329	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12487761	12487761	PRJNA1046144_P_NODE_10390_length_492_cov_2.565012_g10096_i0	PRJNA1046144	10390	492	2.565012	12.61985904	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	222	9.63e-64	NR	WP_157601407.1	41	g10096	i0	69.3	24.8536585365854	163	50	99.4	0	3	491	1613	1775	WP_157601407.1 non-ribosomal peptide synthetase, partial [Stigmatella aurantiaca]	diamond	12228	224	0.991071428571429	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
12926353	12926353	PRJNA1046144_P_NODE_55911_length_235_cov_1.415663_g55616_i0	PRJNA1046144	55911	235	1.415663	3.32680805	Minicystis rosea	888845	Bacteria	Bacteria	390	3.93e-104	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g55616	i0	96.596	131.310638297872	235	8	100	0	1	235	770148	770382	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	30858	390	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
14201290	14201290	PRJNA1046144_P_NODE_54432_length_238_cov_1.408284_g54137_i0	PRJNA1046144	54432	238	1.408284	3.35171592	Polyangium aurulentum	2567896	Bacteria	Bacteria	346	8.76e-91	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g54137	i0	92.857	217.22268907563	238	17	100	0	1	238	2744011	2744248	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	51699	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
15036926	15036926	PRJNA1046144_P_NODE_45952_length_257_cov_1.255319_g45657_i0	PRJNA1046144	45952	257	1.255319	3.22616983	Myxococcia	32015	Bacteria	Bacteria	117	4.38e-30	NR	MEI7892574.1	2026763	g45657	i0	68.3	2.92996108949416	82	26	95.7	0	6	251	72	153	MEI7892574.1 flagellin [Myxococcales bacterium]	diamond	753	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
16311814	16311814	PRJNA1046144_P_NODE_62873_length_230_cov_1.664596_g62578_i0	PRJNA1046144	62873	230	1.664596	3.8285708	Haliangium	162027	Bacteria	Bacteria	285	1.86e-72	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g62578	i0	89.13	166.939130434783	230	24	100	1	1	230	847	1075	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	38396	285	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23124156	23124156	PRJNA1046144_P_NODE_17219_length_390_cov_2.451713_g16924_i0	PRJNA1046144	17219	390	2.451713	9.5616807	Pendulispora brunnea	2905690	Bacteria	Bacteria	556	6.48e-154	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g16924	i0	92.347	133.507692307692	392	28	100	2	1	390	7408028	7408419	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	52068	556	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
25235554	25235554	PRJNA1046144_P_NODE_50380_length_247_cov_1.269663_g50085_i0	PRJNA1046144	50380	247	1.269663	3.13606761	Myxococcia	32015	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50085	i0	97.166	203.287449392713	247	7	100	0	1	247	3944346	3944592	Labilithrix luteola strain DSM 27648, complete genome	blastn	50212	418	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
27887987	27887987	PRJNA1046144_P_NODE_22965_length_343_cov_1.430657_g22670_i0	PRJNA1046144	22965	343	1.430657	4.90715351	Minicystis sp.	1971901	Bacteria	Bacteria	43.9	0.0433	NR	HVY48277.1	1971901	g22670	i0	32.8	0.58600583090379	67	45	58.6	0	259	59	360	426	HVY48277.1 sigma 54-interacting transcriptional regulator [Minicystis sp.]	diamond	201	43.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
27919635	27919635	PRJNA1046144_P_NODE_53525_length_240_cov_1.362573_g53230_i0	PRJNA1046144	53525	240	1.362573	3.2701752	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	84.3	1.22e-17	NR	HEX7667158.1	2268199	g53230	i0	62.7	3.6125	75	27	93.8	1	16	240	26	99	HEX7667158.1 sigma factor-like helix-turn-helix DNA-binding protein [Polyangiaceae bacterium]	diamond	867	84.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28172218	28172218	PRJNA1046144_P_NODE_62766_length_230_cov_1.788820_g62471_i0	PRJNA1046144	62766	230	1.78882	4.114286	Archangium gephyra	48	Bacteria	Bacteria	135	1.26e-37	NR	PZR07590.1	48	g62471	i0	95.8	0.926086956521739	71	3	92.6	0	1	213	187	257	PZR07590.1 MAG: acyl-[acyl-carrier-protein]--UDP-N-acetylglucosamine O-acyltransferase [Archangium gephyra]	diamond	213	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
28606234	28606234	PRJNA1046144_P_NODE_51947_length_243_cov_2.195402_g51652_i0	PRJNA1046144	51947	243	2.195402	5.33482686	Pseudomonadati	3379134	Bacteria	Bacteria	97.8	1.51e-21	NR	MCH9681897.1	2026735	g51652	i0	67.1	1.95061728395062	79	26	97.5	0	242	6	407	485	MCH9681897.1 methylaspartate mutase subunit E [Deltaproteobacteria bacterium]	diamond	474	98.6	0.991886409736308	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29877444	29877444	PRJNA1046144_P_NODE_62811_length_230_cov_1.788820_g62516_i0	PRJNA1046144	62811	230	1.78882	4.114286	Myxococcota bacterium	2818507	Bacteria	Bacteria	68.2	3.42e-11	NR	MDQ3037144.1	2818507	g62516	i0	47.4	0.991304347826087	76	39	99.1	1	229	2	385	459	MDQ3037144.1 serine/threonine protein kinase [Myxococcota bacterium]	diamond	228	68.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;