metadata: contig_metadata: 24 rows where bioproject = "PRJNA1196384", tax_phylum = "Myxococcota" and tax

24 rows where bioproject = "PRJNA1196384", 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
322679	322679	PRJNA1196384_S_NODE_321_length_634_cov_15.396985_g266_i0	PRJNA1196384	321	634	15.396985	97.6168849	Labilithrix luteola	1391654	Bacteria	Bacteria	806	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g266	i0	89.748	124.656151419558	634	59	99	6	1	632	7090071	7090700	Labilithrix luteola strain DSM 27648, complete genome	blastn	79032	806	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1043148	1043148	PRJNA1196384_S_NODE_1901_length_284_cov_6.441296_g1837_i0	PRJNA1196384	1901	284	6.441296	18.29328064	Myxococcaceae	31	Bacteria	Bacteria	255	1.86e-63	NTclustered	gi\|545790947\|gb\|KF270710.1\|	34	g1837	i0	85.95	204.411971830986	242	30	85	3	6	245	415	176	Myxococcus xanthus strain Mxx132 23S ribosomal RNA gene, partial sequence	blastn	58053	255	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
1043190	1043190	PRJNA1196384_S_NODE_81_length_1045_cov_5.001984_g56_i0	PRJNA1196384	81	1045	5.001984	52.2707328	Corallococcus	83461	Bacteria	Bacteria	1033	0	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g56	i0	85.758	263.838277511962	983	132	94	7	50	1028	143020	143998	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	275711	1033	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
2873536	2873536	PRJNA1196384_S_NODE_823_length_423_cov_14.404145_g759_i0	PRJNA1196384	823	423	14.404145	60.92953335	Labilithrix luteola	1391654	Bacteria	Bacteria	737	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g759	i0	98.109	160.042553191489	423	8	100	0	1	423	3942473	3942895	Labilithrix luteola strain DSM 27648, complete genome	blastn	67698	737	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4871226	4871226	PRJNA1196384_S_NODE_544_length_506_cov_4.081023_g482_i0	PRJNA1196384	544	506	4.081023	20.64997638	Haliangium	162027	Bacteria	Bacteria	372	3.34e-98	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g482	i0	80.309	171.005928853755	518	80	100	16	1	506	554	47	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	86529	372	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
6700646	6700646	PRJNA1196384_S_NODE_846_length_417_cov_3.894737_g782_i0	PRJNA1196384	846	417	3.894737	16.24105329	Pseudomonadati	3379134	Bacteria	Bacteria	219	1.59e-70	NR	MCA9658156.1	2026763	g782	i0	82.4	16.2230215827338	125	22	89.9	0	417	43	48	172	MCA9658156.1 peptidylprolyl isomerase [Myxococcales bacterium]	diamond	6765	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
9250566	9250566	PRJNA1196384_S_NODE_228_length_724_cov_12.732169_g180_i0	PRJNA1196384	228	724	12.732169	92.18090356	Chondromyces crocatus	52	Bacteria	Bacteria	736	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g180	i0	86.686	124.506906077348	676	75	92	14	60	724	1380	2051	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	90143	736	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
12521832	12521832	PRJNA1196384_S_NODE_6730_length_162_cov_2.480000_g6666_i0	PRJNA1196384	6730	162	2.48	4.0176	Nannocystis	53	Bacteria	Bacteria	281	1.58e-71	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g6666	i0	98.137	192.888888888889	161	3	99	0	2	162	2393	2233	N.exedens 23S rRNA gene	blastn	31248	281	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
13076332	13076332	PRJNA1196384_S_NODE_6391_length_165_cov_2.703125_g6327_i0	PRJNA1196384	6391	165	2.703125	4.46015625	Labilithrix luteola	1391654	Bacteria	Bacteria	183	4.69e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6327	i0	86.982	93.3515151515151	169	15	100	7	1	165	3943305	3943140	Labilithrix luteola strain DSM 27648, complete genome	blastn	15403	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13076347	13076347	PRJNA1196384_S_NODE_71_length_1084_cov_10.772684_g46_i0	PRJNA1196384	71	1084	10.772684	116.77589456	Labilithrix luteola	1391654	Bacteria	Bacteria	1400	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g46	i0	90.027	153.927121771218	1093	94	100	11	1	1084	3941809	3942895	Labilithrix luteola strain DSM 27648, complete genome	blastn	166857	1400	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14351655	14351655	PRJNA1196384_S_NODE_1572_length_311_cov_7.894161_g1508_i0	PRJNA1196384	1572	311	7.894161	24.55084071	Labilithrix luteola	1391654	Bacteria	Bacteria	442	1.4799999999999995e-119	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1508	i0	92.581	276.909967845659	310	19	99	2	4	311	3944715	3944408	Labilithrix luteola strain DSM 27648, complete genome	blastn	86119	442	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16345656	16345656	PRJNA1196384_S_NODE_213_length_744_cov_12.018388_g166_i0	PRJNA1196384	213	744	12.018388	89.41680672	Polyangiaceae	49	Bacteria	Bacteria	965	0	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g166	i0	90.463	152.797043010753	734	67	99	3	1	733	2995143	2994412	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	113681	966	0.998964803312629	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19448683	19448683	PRJNA1196384_S_NODE_116_length_924_cov_11.417136_g46_i1	PRJNA1196384	116	924	11.417136	105.49433664	Labilithrix luteola	1391654	Bacteria	Bacteria	1421	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g46	i1	94.391	169.529220779221	927	48	100	3	1	924	3941936	3942861	Labilithrix luteola strain DSM 27648, complete genome	blastn	156645	1421	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19448715	19448715	PRJNA1196384_S_NODE_3216_length_217_cov_1.772222_g3152_i0	PRJNA1196384	3216	217	1.772222	3.84572174	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	102	2.71e-25	NR	MCL5044315.1	2026735	g3152	i0	75.9	2.97235023041475	54	13	74.7	0	217	56	139	192	MCL5044315.1 superoxide dismutase [Deltaproteobacteria bacterium]	diamond	645	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
21445101	21445101	PRJNA1196384_S_NODE_737_length_444_cov_6.810811_g673_i0	PRJNA1196384	737	444	6.810811	30.24000084	Stigmatella	40	Bacteria	Bacteria	619	9.39e-173	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g673	i0	92.237	288.792792792793	438	32	98	2	6	442	782	346	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	128224	619	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
23274903	23274903	PRJNA1196384_S_NODE_239_length_710_cov_11.936107_g166_i1	PRJNA1196384	239	710	11.936107	84.7463597	Labilithrix luteola	1391654	Bacteria	Bacteria	959	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g166	i1	91.348	158.753521126761	705	55	99	5	11	710	3942158	3942861	Labilithrix luteola strain DSM 27648, complete genome	blastn	112715	959	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
26723805	26723805	PRJNA1196384_S_NODE_6501_length_164_cov_3.055118_g6437_i0	PRJNA1196384	6501	164	3.0551179999999998	5.01039352	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	80.5	6.26e-16	NR	MFO0591302.1	2268199	g6437	i0	63	1.97560975609756	54	20	98.8	0	2	163	125	178	MFO0591302.1 M15 family metallopeptidase [Polyangiaceae bacterium]	diamond	324	80.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28209274	28209274	PRJNA1196384_S_NODE_3186_length_218_cov_1.414365_g3122_i0	PRJNA1196384	3186	218	1.414365	3.0833157	Byssovorax sp.	2927945	Bacteria	Bacteria	97.8	9.33e-22	NR	MFO0762933.1	2927945	g3122	i0	60.9	1.85779816513761	69	27	95	0	213	7	194	262	MFO0762933.1 hypothetical protein [Byssovorax sp.]	diamond	405	97.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Byssovorax	Byssovorax sp.
29491307	29491307	PRJNA1196384_S_NODE_6950_length_161_cov_0.935484_g6886_i0	PRJNA1196384	6950	161	0.935484	1.50612924	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	6.02e-16	NR	MFT3772446.1	1971901	g6886	i0	67.9	6.78260869565217	53	17	98.8	0	1	159	1783	1835	MFT3772446.1 MopE-related protein [Minicystis sp.]	diamond	1092	80.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
30799019	30799019	PRJNA1196384_S_NODE_4454_length_190_cov_1.235294_g4390_i0	PRJNA1196384	4454	190	1.235294	2.3470586	Minicystis sp.	1971901	Bacteria	Bacteria	114	4.27e-28	NR	MEO7331543.1	1971901	g4390	i0	76.2	2.98421052631579	63	15	99.5	0	2	190	343	405	MEO7331543.1 7-dehydrocholesterol reductase [Minicystis sp.]	diamond	567	114	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis sp.
30830693	30830693	PRJNA1196384_S_NODE_8294_length_151_cov_1.710526_g8230_i0	PRJNA1196384	8294	151	1.710526	2.58289426	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	47.8	1.82e-4	NR	MFN7700212.1	2026735	g8230	i0	55	1.58940397350993	40	18	79.5	0	25	144	66	105	MFN7700212.1 M15 family metallopeptidase [Deltaproteobacteria bacterium]	diamond	240	47.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31589642	31589642	PRJNA1196384_S_NODE_2716_length_235_cov_2.338384_g2652_i0	PRJNA1196384	2716	235	2.338384	5.4952024	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	45.8	0.00263	NR	HEY6081721.1	2268199	g2652	i0	35.5	0.791489361702128	62	40	79.1	0	27	212	334	395	HEY6081721.1 FAD-dependent oxidoreductase [Polyangiaceae bacterium]	diamond	186	45.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32032377	32032377	PRJNA1196384_S_NODE_1498_length_318_cov_5.046263_g1434_i0	PRJNA1196384	1498	318	5.046263	16.04711634	Myxococcota bacterium	2818507	Bacteria	Bacteria	44.7	0.00928	NR	MEO0606042.1	2818507	g1434	i0	31.7	1.91509433962264	101	63	95.3	2	310	8	68	162	MEO0606042.1 lipocalin/fatty-acid binding family protein [Myxococcota bacterium]	diamond	609	44.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32570492	32570492	PRJNA1196384_S_NODE_6299_length_166_cov_1.790698_g6235_i0	PRJNA1196384	6299	166	1.790698	2.97255868	Myxococcota bacterium	2818507	Bacteria	Bacteria	62	2.11e-9	NR	MCU0676089.1	2818507	g6235	i0	58.5	4.86144578313253	53	22	95.8	0	8	166	645	697	MCU0676089.1 heavy metal translocating P-type ATPase [Myxococcota bacterium]	diamond	807	62	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);;