metadata: contig_metadata: 29 rows where bioproject = "PRJNA674048", tax_phylum = "Myxococcota" and tax

29 rows where bioproject = "PRJNA674048", 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
2441520	2441520	PRJNA674048_P_NODE_5842_length_423_cov_3.877005_g5639_i0	PRJNA674048	5842	423	3.877005	16.39973115	Pendulispora	3375062	Bacteria	Bacteria	224	8.159999999999999e-54	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g5639	i0	85.586	49.1725768321513	222	22	50	6	175	386	2910084	2909863	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	20800	226	0.991150442477876	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
3194083	3194083	PRJNA674048_P_NODE_9263_length_312_cov_5.619772_g9060_i0	PRJNA674048	9263	312	5.619772	17.53368864	Pendulispora albinea	2741071	Bacteria	Bacteria	442	1.4799999999999995e-119	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g9060	i0	92.308	258.599358974359	312	22	99	2	3	312	3590691	3590380	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	80683	442	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
9571543	9571543	PRJNA674048_P_NODE_12108_length_264_cov_1.846512_g11905_i0	PRJNA674048	12108	264	1.846512	4.87479168	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	63.9	1.65e-9	NR	MBI5544626.1	2026735	g11905	i0	61	0.931818181818182	41	16	46.6	0	260	138	409	449	MBI5544626.1 choice-of-anchor D domain-containing protein [Deltaproteobacteria bacterium]	diamond	246	63.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
9571611	9571611	PRJNA674048_P_NODE_23628_length_181_cov_1.409091_g23425_i0	PRJNA674048	23628	181	1.409091	2.55045471	Labilithrix luteola	1391654	Bacteria	Bacteria	250	5.08e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g23425	i0	91.667	136.303867403315	180	15	99	0	2	181	3942544	3942365	Labilithrix luteola strain DSM 27648, complete genome	blastn	24671	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10094489	10094489	PRJNA674048_P_NODE_12968_length_252_cov_8.596059_g12765_i0	PRJNA674048	12968	252	8.596059	21.66206868	Stigmatella	40	Bacteria	Bacteria	388	1.5299999999999998e-103	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g12765	i0	94.466	250.916666666667	253	13	100	1	1	252	513	765	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	63231	388	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
10847138	10847138	PRJNA674048_P_NODE_17369_length_213_cov_1.707317_g17166_i0	PRJNA674048	17369	213	1.707317	3.63658521	Myxococcales bacterium	2026763	Bacteria	Bacteria	204	4.8899999999999997e-48	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g17166	i0	90	88.3380281690141	160	13	74	3	56	213	1310429	1310271	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	18816	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10847191	10847191	PRJNA674048_P_NODE_23689_length_180_cov_4.206107_g23486_i0	PRJNA674048	23689	180	4.206107	7.5709926	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	204	3.98e-48	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g23486	i0	87.293	138.455555555556	181	19	100	3	1	180	8616616	8616793	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	24922	204	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13397243	13397243	PRJNA674048_P_NODE_27471_length_168_cov_1.747899_g27268_i0	PRJNA674048	27471	168	1.747899	2.93647032	Pendulispora albinea	2741071	Bacteria	Bacteria	226	7.859999999999997e-55	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g27268	i0	91.071	264.369047619048	168	14	100	1	1	168	3590583	3590417	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	44414	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
14672237	14672237	PRJNA674048_P_NODE_712_length_1332_cov_14.078722_g627_i0	PRJNA674048	712	1332	14.078722	187.52857704	Pendulispora rubella	2741070	Bacteria	Bacteria	1587	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g627	i0	90.848	140.301051051051	1191	99	89	8	145	1332	7290056	7288873	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	186881	1587	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
16468725	16468725	PRJNA674048_P_NODE_12553_length_257_cov_4.572115_g12350_i0	PRJNA674048	12553	257	4.572115	11.75033555	Archangiaceae	39	Bacteria	Bacteria	348	2.6600000000000004e-91	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g12350	i0	92.245	239.081712062257	245	19	95	0	3	247	590	346	S.aurantiaca 23S rRNA gene	blastn	61444	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
20292522	20292522	PRJNA674048_P_NODE_29096_length_166_cov_1.769231_g28893_i0	PRJNA674048	29096	166	1.769231	2.93692346	root	1	Root_unresolved	Root_unresolved	150	4.79e-32	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g28893	i0	83.333	140.451807228916	168	22	100	5	1	166	3690303	3690466	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	23315	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21045679	21045679	PRJNA674048_P_NODE_27697_length_168_cov_0.873950_g27494_i0	PRJNA674048	27697	168	0.87395	1.468236	Labilithrix luteola	1391654	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27494	i0	90.909	79.2083333333333	165	15	98	0	4	168	183965	184129	Labilithrix luteola strain DSM 27648, complete genome	blastn	13307	222	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22320537	22320537	PRJNA674048_P_NODE_9398_length_309_cov_3.400000_g9195_i0	PRJNA674048	9398	309	3.4	10.506	Labilithrix luteola	1391654	Bacteria	Bacteria	538	1.8199999999999993e-148	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9195	i0	98.058	177.032362459547	309	6	100	0	1	309	3944267	3943959	Labilithrix luteola strain DSM 27648, complete genome	blastn	54703	538	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24869230	24869230	PRJNA674048_P_NODE_1420_length_987_cov_12.591684_g1303_i0	PRJNA674048	1420	987	12.591684	124.27992108	Labilithrix luteola	1391654	Bacteria	Bacteria	1182	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1303	i0	88.708	147.758865248227	983	91	98	17	17	987	7089987	7090961	Labilithrix luteola strain DSM 27648, complete genome	blastn	145838	1182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
27156535	27156535	PRJNA674048_P_NODE_32942_length_162_cov_0.920354_g32739_i0	PRJNA674048	32942	162	0.920354	1.49097348	Myxococcia	32015	Bacteria	Bacteria	105	1.32e-24	NR	MBK8214522.1	2026763	g32739	i0	90.6	2.94444444444444	53	5	98.1	0	3	161	56	108	MBK8214522.1 cytochrome-c oxidase, cbb3-type subunit I [Myxococcales bacterium]	diamond	477	105	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27315105	27315105	PRJNA674048_P_NODE_28083_length_168_cov_0.873950_g27880_i0	PRJNA674048	28083	168	0.87395	1.468236	Myxococcia	32015	Bacteria	Bacteria	83.2	7.28e-17	NR	MBK6461654.1	2026763	g27880	i0	86.7	4.01785714285714	45	6	80.4	0	3	137	499	543	MBK6461654.1 VWA domain-containing protein [Myxococcales bacterium]	diamond	675	83.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27682352	27682352	PRJNA674048_P_NODE_22204_length_187_cov_1.130435_g22001_i0	PRJNA674048	22204	187	1.130435	2.11391345	Myxococcales bacterium	2026763	Bacteria	Bacteria	57.4	1.22e-7	NR	MBR58503.1	2026763	g22001	i0	46.6	2.71122994652406	58	31	93	0	177	4	49	106	MBR58503.1 hypothetical protein [Myxococcales bacterium]	diamond	507	57.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28566017	28566017	PRJNA674048_P_NODE_29327_length_166_cov_0.888889_g29124_i0	PRJNA674048	29327	166	0.888889	1.47555574	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	41.6	0.0339	NR	MBI5016073.1	2026735	g29124	i0	50	0.795180722891566	44	22	79.5	0	153	22	1	44	MBI5016073.1 IS30 family transposase [Deltaproteobacteria bacterium]	diamond	132	41.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29418433	29418433	PRJNA674048_P_NODE_29529_length_166_cov_0.888889_g29326_i0	PRJNA674048	29529	166	0.888889	1.47555574	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	46.6	3.84e-4	NR	MCP4668401.1	2026735	g29326	i0	47.3	0.993975903614458	55	24	99.4	2	166	2	65	114	MCP4668401.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	165	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30030583	30030583	PRJNA674048_P_NODE_23151_length_183_cov_1.164179_g22948_i0	PRJNA674048	23151	183	1.164179	2.13044757	Myxococcia	32015	Bacteria	Bacteria	62.4	1.91e-9	NR	WP_120582518.1	83461	g22948	i0	70	3.29508196721311	40	12	65.6	0	5	124	135	174	WP_120582518.1 MULTISPECIES: FG-GAP-like repeat-containing protein [Corallococcus]	diamond	603	62.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus
30681838	30681838	PRJNA674048_P_NODE_28873_length_167_cov_0.881356_g28670_i0	PRJNA674048	28873	167	0.881356	1.47186452	Myxococcales bacterium	2026763	Bacteria	Bacteria	70.1	1.44e-12	NR	MBK6460594.1	2026763	g28670	i0	67.9	1.0059880239521	56	16	98.8	2	3	167	154	208	MBK6460594.1 hypothetical protein [Myxococcales bacterium]	diamond	168	70.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31420908	31420908	PRJNA674048_P_NODE_28056_length_168_cov_0.873950_g27853_i0	PRJNA674048	28056	168	0.87395	1.468236	Pseudomonadati	3379134	Bacteria	Bacteria	60.1	1.06e-8	NR	MBM4286409.1	2026735	g27853	i0	55.4	3.01785714285714	56	21	92.9	1	168	13	518	573	MBM4286409.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium]	diamond	507	60.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31598959	31598959	PRJNA674048_P_NODE_24916_length_176_cov_1.417323_g24713_i0	PRJNA674048	24916	176	1.4173230000000001	2.49448848	Myxococcales bacterium	2026763	Bacteria	Bacteria	67	4.17e-11	NR	MBL91504.1	2026763	g24713	i0	70	0.681818181818182	40	12	68.2	0	8	127	1	40	MBL91504.1 hypothetical protein [Myxococcales bacterium]	diamond	120	67	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31642158	31642158	PRJNA674048_P_NODE_20156_length_196_cov_2.122449_g19953_i0	PRJNA674048	20156	196	2.122449	4.16000004	Bacteria	2	Bacteria	Bacteria	50.4	3.89e-5	NR	TMA37635.1	2026735	g19953	i0	62.2	1.10204081632653	37	14	56.6	0	2	112	318	354	TMA37635.1 MAG: DNRLRE domain-containing protein [Deltaproteobacteria bacterium]	diamond	216	50.8	0.992125984251969	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31820045	31820045	PRJNA674048_P_NODE_26557_length_170_cov_1.595041_g26354_i0	PRJNA674048	26557	170	1.595041	2.7115697	Myxococcales bacterium	2026763	Bacteria	Bacteria	43.9	0.00176	NR	MBL9112786.1	2026763	g26354	i0	88.5	0.917647058823529	26	3	45.9	0	78	1	1	26	MBL9112786.1 50S ribosomal protein L1 [Myxococcales bacterium]	diamond	156	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31926980	31926980	PRJNA674048_P_NODE_32717_length_162_cov_0.920354_g32514_i0	PRJNA674048	32717	162	0.920354	1.49097348	Myxococcia	32015	Bacteria	Bacteria	89	8.54e-21	NR	MBX3227242.1	1971228	g32514	i0	80.8	9.62962962962963	52	10	96.3	0	162	7	5	56	MBX3227242.1 50S ribosomal protein L9 [Labilithrix sp.]	diamond	1560	89.4	0.995525727069351	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
32326808	32326808	PRJNA674048_P_NODE_29499_length_166_cov_0.888889_g29296_i0	PRJNA674048	29499	166	0.888889	1.47555574	Anaeromyxobacter terrae	2925406	Bacteria	Bacteria	62.8	8.18e-10	NR	WP_279426582.1	2925406	g29296	i0	48.1	0.975903614457831	54	28	97.6	0	1	162	123	176	WP_279426582.1 glycosyltransferase family 2 protein [Anaeromyxobacter terrae]	diamond	162	62.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter terrae
32389685	32389685	PRJNA674048_P_NODE_30679_length_164_cov_1.582609_g30476_i0	PRJNA674048	30679	164	1.582609	2.59547876	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	49.7	1.83e-5	NR	MBM4265247.1	2026735	g30476	i0	51.9	1.90243902439024	52	18	95.1	3	160	5	98	142	MBM4265247.1 nuclear transport factor 2 family protein [Deltaproteobacteria bacterium]	diamond	312	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32642159	32642159	PRJNA674048_P_NODE_29660_length_166_cov_0.888889_g29457_i0	PRJNA674048	29660	166	0.888889	1.47555574	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	62.8	1.08e-9	NR	MCH9687017.1	2026735	g29457	i0	60.4	1.82530120481928	48	19	86.7	0	164	21	405	452	MCH9687017.1 protein kinase [Deltaproteobacteria bacterium]	diamond	303	62.8	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);;