metadata: contig_metadata: 31 rows where bioproject = "PRJEB83101", tax_kingdom = "Pseudomonadati" and tax

31 rows where bioproject = "PRJEB83101", 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
142570	142570	PRJEB83101_P_NODE_66121_length_252_cov_2.692737_g65816_i0	PRJEB83101	66121	252	2.692737	6.78569724	Archangium violaceum	83451	Bacteria	Bacteria	69.4	2.27e-7	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g65816	i0	91.837	0.353174603174603	49	4	19	0	38	86	472842	472890	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	89	69.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
1417358	1417358	PRJEB83101_P_NODE_72222_length_249_cov_0.886364_g71917_i0	PRJEB83101	72222	249	0.886364	2.20704636	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	102	2.9e-23	NR	HVJ21365.1	2268199	g71917	i0	64.2	0.975903614457831	81	29	97.6	0	6	248	420	500	HVJ21365.1 DUF4340 domain-containing protein [Polyangiaceae bacterium]	diamond	243	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
2692553	2692553	PRJEB83101_P_NODE_62363_length_256_cov_2.256831_g62058_i0	PRJEB83101	62363	256	2.256831	5.77748736	Myxococcia	32015	Bacteria	Bacteria	118	7.07e-30	NR	MDB4977522.1	2484252	g62058	i0	65.5	4.9453125	84	29	98.4	0	2	253	73	156	MDB4977522.1 hypothetical protein [Myxococcaceae bacterium]	diamond	1266	119	0.991596638655462	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
2693175	2693175	PRJEB83101_P_NODE_86083_length_242_cov_0.923077_g85778_i0	PRJEB83101	86083	242	0.923077	2.23384634	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	129	2.49e-34	NR	MEO8705946.1	2212474	g85778	i0	86.3	0.991735537190083	80	11	99.2	0	241	2	60	139	MEO8705946.1 FAD-binding protein [Kofleriaceae bacterium]	diamond	240	129	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
3968163	3968163	PRJEB83101_P_NODE_45464_length_284_cov_1.473934_g45159_i0	PRJEB83101	45464	284	1.473934	4.18597256	Archangium violaceum	83451	Bacteria	Bacteria	475	1.3099999999999999e-129	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g45159	i0	97.153	3.21830985915493	281	8	99	0	1	281	10813485	10813765	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	914	475	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
3968740	3968740	PRJEB83101_P_NODE_65864_length_253_cov_0.866667_g65559_i0	PRJEB83101	65864	253	0.866667	2.19266751	Myxococcia	32015	Bacteria	Bacteria	118	1.01e-28	NR	MBL9026633.1	2026763	g65559	i0	73.8	1.99209486166008	84	22	99.6	0	252	1	354	437	MBL9026633.1 hypothetical protein [Myxococcales bacterium]	diamond	504	119	0.991596638655462	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
5244648	5244648	PRJEB83101_P_NODE_45065_length_285_cov_1.188679_g44760_i0	PRJEB83101	45065	285	1.188679	3.38773515	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	152	2.26e-42	NR	MBI2375122.1	2026735	g44760	i0	80	1	95	19	100	0	1	285	40	134	MBI2375122.1 AAA family ATPase [Deltaproteobacteria bacterium]	diamond	285	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
12896703	12896703	PRJEB83101_P_NODE_89471_length_231_cov_2.626582_g89166_i0	PRJEB83101	89471	231	2.626582	6.06740442	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g89166	i0	100	0.121212121212121	28	0	12	0	62	89	11765760	11765787	Sorangium cellulosum 'So ce 56' complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14170623	14170623	PRJEB83101_P_NODE_50712_length_275_cov_1.262376_g50407_i0	PRJEB83101	50712	275	1.262376	3.471534	Cystobacter fuscus	43	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g50407	i0	95.273	63.5781818181818	275	13	100	0	1	275	2346309	2346035	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	17484	436	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
14171334	14171334	PRJEB83101_P_NODE_77072_length_247_cov_0.896552_g76767_i0	PRJEB83101	77072	247	0.896552	2.21448344	Myxococcota bacterium	2818507	Bacteria	Bacteria	114	3.13e-27	NR	MEQ1568451.1	2818507	g76767	i0	71.1	1.0080971659919	83	23	99.6	1	1	246	471	553	MEQ1568451.1 ABC-F family ATP-binding cassette domain-containing protein [Myxococcota bacterium]	diamond	249	114	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
15444520	15444520	PRJEB83101_P_NODE_42293_length_290_cov_1.437788_g41988_i0	PRJEB83101	42293	290	1.437788	4.1695852	Archangium gephyra	48	Bacteria	Bacteria	497	2.8699999999999993e-136	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g41988	i0	97.586	1	290	7	100	0	1	290	1591295	1591006	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	290	497	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
22675144	22675144	PRJEB83101_P_NODE_84278_length_243_cov_0.917647_g83973_i0	PRJEB83101	84278	243	0.917647	2.22988221	Archangiaceae	39	Bacteria	Bacteria	315	2.5299999999999998e-81	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g83973	i0	90.377	98.0946502057613	239	23	98	0	4	242	7399215	7398977	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	23837	315	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
24368145	24368145	PRJEB83101_P_NODE_58380_length_262_cov_2.386243_g58075_i0	PRJEB83101	58380	262	2.386243	6.25195666	Sandaracinus sp.	2024858	Bacteria	Bacteria	89.4	6.42e-19	NR	MFO0684571.1	2024858	g58075	i0	54.7	0.984732824427481	86	39	98.5	0	261	4	172	257	MFO0684571.1 LysR family transcriptional regulator [Sandaracinus sp.]	diamond	258	89.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus sp.
27382111	27382111	PRJEB83101_P_NODE_66503_length_252_cov_1.564246_g66198_i0	PRJEB83101	66503	252	1.564246	3.94189992	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	60.5	2.49e-8	NR	MBK6685592.1	2026735	g66198	i0	40.7	0.964285714285714	81	48	96.4	0	4	246	785	865	MBK6685592.1 VCBS repeat-containing protein [Deltaproteobacteria bacterium]	diamond	243	60.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27469528	27469528	PRJEB83101_P_NODE_71523_length_249_cov_2.477273_g71218_i0	PRJEB83101	71523	249	2.477273	6.16840977	Myxococcia	32015	Bacteria	Bacteria	133	3.65e-34	NR	MBX3209149.1	1971228	g71218	i0	81.9	3	83	15	100	0	1	249	62	144	MBX3209149.1 primosomal protein N' [Labilithrix sp.]	diamond	747	133	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
28265885	28265885	PRJEB83101_P_NODE_71526_length_249_cov_2.471591_g71221_i0	PRJEB83101	71526	249	2.471591	6.15426159	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	141	3.7e-39	NR	MDB4973105.1	2484252	g71221	i0	80.5	0.987951807228916	82	16	98.8	0	3	248	159	240	MDB4973105.1 hypothetical protein [Myxococcaceae bacterium]	diamond	246	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28297589	28297589	PRJEB83101_P_NODE_78126_length_246_cov_0.901734_g77821_i0	PRJEB83101	78126	246	0.901734	2.21826564	Chondromyces sp.	3069217	Bacteria	Bacteria	155	8.5e-42	NR	HZG72972.1	3069217	g77821	i0	96.3	0.98780487804878	81	3	98.8	0	244	2	405	485	HZG72972.1 type ISP restriction/modification enzyme [Chondromyces sp.]	diamond	243	155	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces sp.
29055584	29055584	PRJEB83101_P_NODE_84148_length_243_cov_0.917647_g83843_i0	PRJEB83101	84148	243	0.917647	2.22988221	Polyangia bacterium	3058050	Bacteria	Bacteria	114	1.97e-27	NR	HVZ71386.1	3058050	g83843	i0	65.4	1	81	27	98.8	1	241	2	459	539	HVZ71386.1 YbhB/YbcL family Raf kinase inhibitor-like protein [Polyangia bacterium]	diamond	243	114	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
29686604	29686604	PRJEB83101_P_NODE_50530_length_275_cov_1.544554_g50225_i0	PRJEB83101	50530	275	1.544554	4.2475235	Myxococcota bacterium	2818507	Bacteria	Bacteria	157	2.1199999999999998e-42	NR	MEZ0310394.1	2818507	g50225	i0	97.8	1.98545454545455	91	2	99.3	0	274	2	496	586	MEZ0310394.1 methyl-accepting chemotaxis protein [Myxococcota bacterium]	diamond	546	157	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30034443	30034443	PRJEB83101_P_NODE_80711_length_245_cov_0.906977_g80406_i0	PRJEB83101	80711	245	0.906977	2.22209365	Myxococcus vastator	2709664	Bacteria	Bacteria	87.4	5.31e-20	NR	WP_163787394.1	2709664	g80406	i0	54.4	0.96734693877551	79	36	96.7	0	242	6	12	90	WP_163787394.1 DUF1206 domain-containing protein, partial [Myxococcus vastator]	diamond	237	87.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus vastator
30065815	30065815	PRJEB83101_P_NODE_81552_length_244_cov_1.444444_g81247_i0	PRJEB83101	81552	244	1.444444	3.52444336	Polyangia bacterium	3058050	Bacteria	Bacteria	85.9	2.18e-17	NR	HXU83206.1	3058050	g81247	i0	47.4	0.934426229508197	76	40	93.4	0	15	242	403	478	HXU83206.1 hypothetical protein [Polyangia bacterium]	diamond	228	85.9	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30500935	30500935	PRJEB83101_P_NODE_79533_length_245_cov_1.587209_g79228_i0	PRJEB83101	79533	245	1.587209	3.88866205	Pseudomonadati	3379134	Bacteria	Bacteria	79	5.11e-15	NR	MEJ7728252.1	2268199	g79228	i0	55.6	1.98367346938776	81	36	99.2	0	243	1	51	131	MEJ7728252.1 hypothetical protein [Polyangiaceae bacterium]	diamond	486	79.3	0.996216897856242	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30532458	30532458	PRJEB83101_P_NODE_56553_length_265_cov_1.864583_g56248_i0	PRJEB83101	56553	265	1.864583	4.94114495	Myxococcia	32015	Bacteria	Bacteria	118	1.33e-28	NR	MDB4945315.1	1971228	g56248	i0	77	1.96981132075472	87	20	98.5	0	3	263	274	360	MDB4945315.1 Endoglucanase [Labilithrix sp.]	diamond	522	118	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
31006421	31006421	PRJEB83101_P_NODE_55174_length_267_cov_2.335052_g54869_i0	PRJEB83101	55174	267	2.335052	6.23458884	root	1	Root_unresolved	Root_unresolved	52.4	1.27e-6	NR	MBM4387686.1	2026735	g54869	i0	48.9	2.68539325842697	47	24	52.8	0	148	8	2	48	MBM4387686.1 DUF167 domain-containing protein [Deltaproteobacteria bacterium]	diamond	717	52.8	0.992424242424242	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31361655	31361655	PRJEB83101_P_NODE_56936_length_265_cov_0.958333_g56631_i0	PRJEB83101	56936	265	0.958333	2.53958245	Polyangiales bacterium	3034171	Bacteria	Bacteria	117	3.09e-29	NR	HET8937020.1	3034171	g56631	i0	67.1	1.93584905660377	85	28	96.2	0	255	1	25	109	HET8937020.1 aldo/keto reductase [Polyangiales bacterium]	diamond	513	117	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
31583097	31583097	PRJEB83101_P_NODE_85356_length_242_cov_1.562130_g85051_i0	PRJEB83101	85356	242	1.56213	3.7803546	Myxococcales bacterium	2026763	Bacteria	Bacteria	43.9	0.0136	NR	HUB08610.1	2026763	g85051	i0	44.3	0.867768595041322	70	31	76.9	2	23	208	226	295	HUB08610.1 hypothetical protein [Myxococcales bacterium]	diamond	210	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31835744	31835744	PRJEB83101_P_NODE_70017_length_250_cov_1.581921_g69712_i0	PRJEB83101	70017	250	1.581921	3.9548025	Myxococcales bacterium	2026763	Bacteria	Bacteria	76.6	1.19e-14	NR	MEO1912525.1	2026763	g69712	i0	48.1	0.948	79	41	94.8	0	250	14	138	216	MEO1912525.1 crotonase/enoyl-CoA hydratase family protein [Myxococcales bacterium]	diamond	237	76.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31962467	31962467	PRJEB83101_P_NODE_73878_length_248_cov_1.520000_g73573_i0	PRJEB83101	73878	248	1.52	3.7696	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	154	2.03e-45	NR	NOU26402.1	2268199	g73573	i0	96.3	0.991935483870968	82	3	99.2	0	248	3	18	99	NOU26402.1 TetR/AcrR family transcriptional regulator [Polyangiaceae bacterium]	diamond	246	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32303514	32303514	PRJEB83101_P_NODE_73119_length_249_cov_0.886364_g72814_i0	PRJEB83101	73119	249	0.886364	2.20704636	Myxococcia	32015	Bacteria	Bacteria	81.3	8.64e-16	NR	MDP2273429.1	1872627	g72814	i0	58.7	4.72289156626506	75	30	90.4	1	1	225	235	308	MDP2273429.1 hypothetical protein [Archangium sp.]	diamond	1176	81.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
32342454	32342454	PRJEB83101_P_NODE_70539_length_250_cov_0.881356_g70234_i0	PRJEB83101	70539	250	0.881356	2.20339	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	79	5.11e-15	NR	MCC6808878.1	2026735	g70234	i0	53.1	1.872	81	37	96	1	5	244	268	348	MCC6808878.1 AI-2E family transporter [Deltaproteobacteria bacterium]	diamond	468	79	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32405582	32405582	PRJEB83101_P_NODE_83499_length_243_cov_1.447059_g83194_i0	PRJEB83101	83499	243	1.447059	3.51635337	Polyangiales bacterium	3034171	Bacteria	Bacteria	135	2.8799999999999997e-35	NR	HTU59559.1	3034171	g83194	i0	83.8	0.987654320987654	80	13	98.8	0	241	2	268	347	HTU59559.1 hypothetical protein [Polyangiales bacterium]	diamond	240	135	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales 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);;