metadata: contig_metadata: 17 rows where bioproject = "PRJNA561138", tax_phylum = "Myxococcota" and tax

17 rows where bioproject = "PRJNA561138", 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
4372404	4372404	PRJNA561138_P_NODE_11424_length_383_cov_0.993548_g11229_i0	PRJNA561138	11424	383	0.993548	3.80528884	Myxococcales bacterium	2026763	Bacteria	Bacteria	185	1.4e-52	NR	MDH3211932.1	2026763	g11229	i0	66.1	0.994778067885117	127	43	99.5	0	2	382	63	189	MDH3211932.1 C-mannosyltransferase dpy-19 family protein [Myxococcales bacterium]	diamond	381	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
6922983	6922983	PRJNA561138_P_NODE_14766_length_341_cov_1.149254_g14571_i0	PRJNA561138	14766	341	1.149254	3.91895614	Polyangium aurulentum	2567896	Bacteria	Bacteria	143	1.86e-29	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g14571	i0	79.703	40.7595307917889	202	37	59	2	23	222	1536942	1537141	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	13899	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
13298987	13298987	PRJNA561138_P_NODE_10491_length_397_cov_0.950617_g10296_i0	PRJNA561138	10491	397	0.950617	3.77394949	Bacteria	2	Bacteria	Bacteria	132	3.12e-34	NR	MBW2191099.1	2026735	g10296	i0	74.1	4.89672544080604	81	21	61.2	0	391	149	273	353	MBW2191099.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	1944	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
13299248	13299248	PRJNA561138_P_NODE_5011_length_553_cov_1.122917_g4820_i0	PRJNA561138	5011	553	1.122917	6.20973101	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	278	7.84e-89	NR	MBW1749655.1	2026735	g4820	i0	69.4	4.96383363471971	183	56	99.3	0	3	551	164	346	MBW1749655.1 DUF1254 domain-containing protein [Deltaproteobacteria bacterium]	diamond	2745	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
18397006	18397006	PRJNA561138_P_NODE_27015_length_247_cov_0.885057_g26820_i0	PRJNA561138	27015	247	0.885057	2.18609079	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	169	2.1199999999999996e-37	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g26820	i0	79.752	73.5587044534413	242	41	96	7	4	241	438030	438267	Anaeromyxobacter oryzae DNA, complete genome	blastn	18169	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
20947181	20947181	PRJNA561138_P_NODE_17057_length_317_cov_1.057377_g16862_i0	PRJNA561138	17057	317	1.057377	3.35188509	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2108253172\|gb\|CP070689.1\|	2026735	g16862	i0	100	0.0883280757097792	28	0	9	0	123	150	119126	119153	MAG: Deltaproteobacteria bacterium isolate bin63 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
23497304	23497304	PRJNA561138_P_NODE_11519_length_382_cov_0.974110_g11324_i0	PRJNA561138	11519	382	0.97411	3.7211002	Minicystis rosea	888845	Bacteria	Bacteria	193	2.06e-44	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g11324	i0	77.049	20.5157068062827	366	64	93	17	18	373	9964998	9965353	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	7837	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
27047493	27047493	PRJNA561138_P_NODE_10762_length_392_cov_1.448276_g10567_i0	PRJNA561138	10762	392	1.448276	5.67724192	Myxococcota bacterium	2818507	Bacteria	Bacteria	93.6	1.33e-20	NR	MEE9282273.1	2818507	g10567	i0	41.1	1.66071428571429	107	62	81.1	1	320	3	4	110	MEE9282273.1 helix-turn-helix domain-containing protein [Myxococcota bacterium]	diamond	651	93.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30110624	30110624	PRJNA561138_P_NODE_15752_length_331_cov_0.895349_g15557_i0	PRJNA561138	15752	331	0.895349	2.96360519	Myxococcales bacterium	2026763	Bacteria	Bacteria	51.6	9.57e-6	NR	MBX2796124.1	2026763	g15557	i0	39.4	2.09365558912387	71	42	63.4	1	122	331	6	76	MBX2796124.1 hypothetical protein [Myxococcales bacterium]	diamond	693	51.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30110627	30110627	PRJNA561138_P_NODE_9092_length_419_cov_1.231214_g8897_i0	PRJNA561138	9092	419	1.231214	5.15878666	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	165	2.75e-44	NR	MBW2370958.1	2026735	g8897	i0	56.5	1.97613365155131	138	60	98.8	0	4	417	776	913	MBW2370958.1 PD-(D/E)XK nuclease family protein [Deltaproteobacteria bacterium]	diamond	828	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30187712	30187712	PRJNA561138_P_NODE_9412_length_413_cov_1.358824_g9217_i0	PRJNA561138	9412	413	1.358824	5.61194312	Pseudomonadati	3379134	Bacteria	Bacteria	136	4.97e-36	NR	MBW2393997.1	2026735	g9217	i0	43.8	2.95641646489104	137	75	99.5	1	1	411	58	192	MBW2393997.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	1221	137	0.992700729927007	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30932198	30932198	PRJNA561138_P_NODE_13034_length_362_cov_1.332180_g12839_i0	PRJNA561138	13034	362	1.33218	4.8224916	Myxococcota bacterium	2818507	Bacteria	Bacteria	229	1.28e-70	NR	MFT5684629.1	2818507	g12839	i0	95	3.97790055248619	120	6	99.4	0	3	362	85	204	MFT5684629.1 sodium/proline symporter [Myxococcota bacterium]	diamond	1440	229	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31248125	31248125	PRJNA561138_P_NODE_29675_length_242_cov_0.899408_g29480_i0	PRJNA561138	29675	242	0.899408	2.17656736	Myxococcota bacterium	2818507	Bacteria	Bacteria	91.3	3.35e-20	NR	MEM1009483.1	2818507	g29480	i0	54.5	0.954545454545455	77	31	95.5	1	8	238	89	161	MEM1009483.1 hypothetical protein [Myxococcota bacterium]	diamond	231	91.3	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31627636	31627636	PRJNA561138_P_NODE_29476_length_242_cov_0.911243_g29281_i0	PRJNA561138	29476	242	0.911243	2.20520806	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	54.7	2.11e-7	NR	MFO0665196.1	2268199	g29281	i0	75	1.35123966942149	36	9	44.6	0	1	108	67	102	MFO0665196.1 tetratricopeptide repeat protein [Polyangiaceae bacterium]	diamond	327	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32102221	32102221	PRJNA561138_P_NODE_8078_length_440_cov_0.831063_g7883_i0	PRJNA561138	8078	440	0.831063	3.6566772	Myxococcales bacterium	2026763	Bacteria	Bacteria	175	9.729999999999999e-53	NR	MCB9521737.1	2026763	g7883	i0	75.7	0.756818181818182	111	27	75.7	0	108	440	1	111	MCB9521737.1 TetR/AcrR family transcriptional regulator [Myxococcales bacterium]	diamond	333	175	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32243051	32243051	PRJNA561138_P_NODE_14518_length_344_cov_1.114391_g14323_i0	PRJNA561138	14518	344	1.114391	3.83350504	Pseudomonadati	3379134	Bacteria	Bacteria	182	1.66e-52	NR	MCA9638316.1	2026763	g14323	i0	78.9	3.88953488372093	114	24	99.4	0	344	3	257	370	MCA9638316.1 SulP family inorganic anion transporter [Myxococcales bacterium]	diamond	1338	182	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32545453	32545453	PRJNA561138_P_NODE_17479_length_313_cov_0.962500_g17284_i0	PRJNA561138	17479	313	0.9625	3.012625	Myxococcus sp.	1929279	Bacteria	Bacteria	50.1	2.27e-4	NR	HZI16333.1	1929279	g17284	i0	33.7	0.996805111821086	104	66	98.7	3	2	310	327	428	HZI16333.1 peptidoglycan DD-metalloendopeptidase family protein [Myxococcus sp.]	diamond	312	50.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus 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);;