metadata: contig_metadata: 24 rows where bioproject = "PRJNA724039", tax_kingdom = "Pseudomonadati" and tax

24 rows where bioproject = "PRJNA724039", 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
711071	711071	PRJNA724039_S_NODE_14861_length_165_cov_3.460938_g14654_i0	PRJNA724039	14861	165	3.460938	5.7105477	Labilithrix luteola	1391654	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14654	i0	93.21	119.824242424242	162	11	98	0	2	163	7915684	7915845	Labilithrix luteola strain DSM 27648, complete genome	blastn	19771	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1194121	1194121	PRJNA724039_S_NODE_14401_length_168_cov_2.076336_g14194_i0	PRJNA724039	14401	168	2.076336	3.48824448	Myxococcales	29	Bacteria	Bacteria	224	2.8299999999999995e-54	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g14194	i0	91.515	227.232142857143	165	10	96	4	6	167	452888	452725	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	38175	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
2469513	2469513	PRJNA724039_S_NODE_6842_length_258_cov_51.633484_g6635_i0	PRJNA724039	6842	258	51.633484	133.21438872	Polyangiaceae	49	Bacteria	Bacteria	364	2.6599999999999992e-96	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g6635	i0	92.248	166.600775193798	258	19	99	1	1	257	2443	2186	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	42983	366	0.994535519125683	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
3262381	3262381	PRJNA724039_S_NODE_14103_length_170_cov_1.954887_g13896_i0	PRJNA724039	14103	170	1.954887	3.3233079	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	70.1	3.13e-12	NR	HLK35136.1	2268199	g13896	i0	55.4	0.988235294117647	56	25	98.8	0	3	170	170	225	HLK35136.1 protein kinase [Polyangiaceae bacterium]	diamond	168	70.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
3745927	3745927	PRJNA724039_S_NODE_2263_length_500_cov_56.265659_g2065_i0	PRJNA724039	2263	500	56.265659	281.328295	Polyangiaceae	49	Bacteria	Bacteria	532	1.43e-146	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g2065	i0	86.29	120.088	496	60	98	8	10	500	1635	1143	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	60044	532	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4539465	4539465	PRJNA724039_S_NODE_1324_length_713_cov_17.535503_g1160_i0	PRJNA724039	1324	713	17.535503	125.02813639	Minicystis rosea	888845	Bacteria	Bacteria	774	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1160	i0	86.408	165.899018232819	721	82	99	14	4	713	769595	768880	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	118286	774	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
4539602	4539602	PRJNA724039_S_NODE_5344_length_301_cov_3.276515_g5137_i0	PRJNA724039	5344	301	3.276515	9.86231015	Myxococcus sp. SDU36	2831967	Bacteria	Bacteria	451	2.36e-122	NTclustered	gi\|2513984958\|gb\|CP077414.1\|	2831967	g5137	i0	93.688	285.166112956811	301	19	100	0	1	301	850750	850450	Myxococcus sp. SDU36 chromosome, complete genome	blastn	85835	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. SDU36
4539669	4539669	PRJNA724039_S_NODE_924_length_929_cov_18.765695_g795_i0	PRJNA724039	924	929	18.765695	174.33330655	Pendulispora rubella	2741070	Bacteria	Bacteria	1190	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g795	i0	89.892	160.653390742734	930	87	99	6	2	929	7289045	7289969	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	149247	1190	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
5022413	5022413	PRJNA724039_S_NODE_15824_length_160_cov_2.975610_g15617_i0	PRJNA724039	15824	160	2.97561	4.760976	Anaeromyxobacter	161492	Bacteria	Bacteria	185	1.2499999999999997e-42	NTclustered	gi\|470477744\|ref\|NR_076406.1\|	161493	g15617	i0	90.78	68.78125	141	10	86	3	23	160	657	517	Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence	blastn	11005	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
7571949	7571949	PRJNA724039_S_NODE_10306_length_202_cov_2.036364_g10099_i0	PRJNA724039	10306	202	2.036364	4.11345528	Myxococcales	29	Bacteria	Bacteria	263	7.46e-66	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g10099	i0	90.099	268.20297029703	202	20	100	0	1	202	1131	930	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	54177	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
7572028	7572028	PRJNA724039_S_NODE_4786_length_321_cov_5.225352_g4579_i0	PRJNA724039	4786	321	5.225352	16.77337992	Stigmatella	40	Bacteria	Bacteria	405	2.01e-108	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g4579	i0	89.474	210.317757009346	323	31	100	3	1	321	370	49	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	67512	405	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8364455	8364455	PRJNA724039_S_NODE_1847_length_572_cov_13.671028_g1655_i0	PRJNA724039	1847	572	13.671028	78.19828016	Pendulispora rubella	2741070	Bacteria	Bacteria	590	9.67e-164	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g1655	i0	86.817	233.95979020979	531	67	92	3	44	572	7289440	7289969	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	133825	590	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9639512	9639512	PRJNA724039_S_NODE_10468_length_200_cov_2.644172_g10261_i0	PRJNA724039	10468	200	2.644172	5.288344	Nannocystis punicea	2995304	Bacteria	Bacteria	185	1.64e-42	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g10261	i0	83.654	34.36	208	23	99	8	1	198	11216911	11216705	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	6872	185	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
13464833	13464833	PRJNA724039_S_NODE_11771_length_187_cov_7.946667_g11564_i0	PRJNA724039	11771	187	7.946667	14.86026729	Nannocystis sp.	1962667	Bacteria	Bacteria	241	3.18e-59	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g11564	i0	89.894	153.737967914439	188	17	100	2	1	187	597	411	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	28749	241	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
15222684	15222684	PRJNA724039_S_NODE_10432_length_200_cov_122.619632_g10225_i0	PRJNA724039	10432	200	122.619632	245.239264	Sorangium	39643	Bacteria	Bacteria	276	9.47e-70	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g10225	i0	91.5	194.57	200	17	100	0	1	200	3692069	3692268	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	38914	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18562791	18562791	PRJNA724039_S_NODE_1095_length_826_cov_15.024081_g952_i0	PRJNA724039	1095	826	15.024081	124.09890906	Stigmatella aurantiaca	41	Bacteria	Bacteria	1027	0	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g952	i0	89.264	236.8401937046	829	78	99	11	3	826	6866624	6867446	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	195630	1027	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
19045891	19045891	PRJNA724039_S_NODE_1115_length_819_cov_14.228900_g968_i0	PRJNA724039	1115	819	14.2289	116.534691	Sorangium	39643	Bacteria	Bacteria	795	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g968	i0	84.375	173.233211233211	832	106	100	22	1	819	11963828	11964648	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	141878	795	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20320651	20320651	PRJNA724039_S_NODE_8536_length_225_cov_21.723404_g8329_i0	PRJNA724039	8536	225	21.723404	48.877659	Myxococcales	29	Bacteria	Bacteria	377	2.91e-100	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g8329	i0	96.889	244.96	225	7	100	0	1	225	1143	919	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	55116	377	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22388711	22388711	PRJNA724039_S_NODE_9978_length_206_cov_2.266272_g9771_i0	PRJNA724039	9978	206	2.266272	4.66852032	Myxococcales bacterium	2026763	Bacteria	Bacteria	101	4.48e-25	NR	MBK7536114.1	2026763	g9771	i0	67.6	0.990291262135922	68	22	99	0	206	3	94	161	MBK7536114.1 HD domain-containing protein [Myxococcales bacterium]	diamond	204	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
23664103	23664103	PRJNA724039_S_NODE_11699_length_188_cov_2.052980_g11492_i0	PRJNA724039	11699	188	2.05298	3.8596024	Pendulispora albinea	2741071	Bacteria	Bacteria	156	1.19e-33	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g11492	i0	82.447	184.164893617021	188	24	97	7	1	183	7191592	7191409	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	34623	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
28094528	28094528	PRJNA724039_S_NODE_16305_length_158_cov_1.074380_g16098_i0	PRJNA724039	16305	158	1.07438	1.6975204	Stigmatella erecta	83460	Bacteria	Bacteria	50.4	2.18e-5	NR	WP_143076215.1	83460	g16098	i0	43.4	1.00632911392405	53	22	85.4	2	142	8	210	262	WP_143076215.1 hypothetical protein [Stigmatella erecta]	diamond	159	50.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella erecta
28883782	28883782	PRJNA724039_S_NODE_14968_length_165_cov_1.484375_g14761_i0	PRJNA724039	14968	165	1.484375	2.44921875	Archangium sp.	1872627	Bacteria	Bacteria	57.4	8.67e-8	NR	HYO74321.1	1872627	g14761	i0	54.9	2.74545454545455	51	23	92.7	0	2	154	231	281	HYO74321.1 AAA family ATPase [Archangium sp.]	diamond	453	57.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
30315854	30315854	PRJNA724039_S_NODE_15692_length_161_cov_1.629032_g15485_i0	PRJNA724039	15692	161	1.629032	2.62274152	Pseudomonadati	3379134	Bacteria	Bacteria	73.2	1.93e-14	NR	MBN1140530.1	2026735	g15485	i0	61.5	6.72670807453416	52	20	96.9	0	160	5	55	106	MBN1140530.1 F0F1 ATP synthase subunit alpha [Deltaproteobacteria bacterium]	diamond	1083	73.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31474434	31474434	PRJNA724039_S_NODE_7596_length_242_cov_2.492683_g7389_i0	PRJNA724039	7596	242	2.492683	6.03229286	Nannocystis sp.	1962667	Bacteria	Bacteria	82.4	8.1e-18	NR	MBK8261259.1	1962667	g7389	i0	61.2	1.67355371900826	67	26	83.1	0	6	206	80	146	MBK8261259.1 profilin [Nannocystis sp.]	diamond	405	82.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.

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