metadata: contig_metadata: 16 rows where bioproject = "PRJNA1073183", tax_phylum = "Myxococcota" and tax

16 rows where bioproject = "PRJNA1073183", 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
6565179	6565179	PRJNA1073183_P_NODE_23546_length_269_cov_1.178571_g23451_i0	PRJNA1073183	23546	269	1.178571	3.17035599	Archangium sp.	1872627	Bacteria	Bacteria	121	3.06e-30	NR	HEY0880548.1	1872627	g23451	i0	65.9	13.7620817843866	88	30	98.1	0	267	4	115	202	HEY0880548.1 SDR family NAD(P)-dependent oxidoreductase [Archangium sp.]	diamond	3702	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
15489712	15489712	PRJNA1073183_P_NODE_15793_length_328_cov_2.709804_g15698_i0	PRJNA1073183	15793	328	2.709804	8.88815712	Myxococcota bacterium	2818507	Bacteria	Bacteria	183	9.300000000000001e-57	NR	MEM9488366.1	2818507	g15698	i0	90.4	8.5609756097561	94	9	86	0	46	327	9	102	MEM9488366.1 peptidylprolyl isomerase [Myxococcota bacterium]	diamond	2808	183	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27659357	27659357	PRJNA1073183_P_NODE_28584_length_248_cov_1.760000_g28489_i0	PRJNA1073183	28584	248	1.76	4.3648	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0214	NR	PZR07722.1	48	g28489	i0	77.3	4.82661290322581	22	5	26.6	0	242	177	771	792	PZR07722.1 MAG: hypothetical protein DI536_26815 [Archangium gephyra]	diamond	1197	43.9	0.990888382687927	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
27667798	27667798	PRJNA1073183_P_NODE_30424_length_246_cov_0.890173_g30329_i0	PRJNA1073183	30424	246	0.890173	2.18982558	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	101	2.64e-23	NR	MBX7098050.1	2484252	g30329	i0	64.2	0.98780487804878	81	29	98.8	0	245	3	157	237	MBX7098050.1 acetyl-CoA C-acetyltransferase [Myxococcaceae bacterium]	diamond	243	101	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27762619	27762619	PRJNA1073183_P_NODE_23524_length_269_cov_1.346939_g23429_i0	PRJNA1073183	23524	269	1.346939	3.62326591	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	75.9	1.09e-13	NR	HOO39298.1	2026735	g23429	i0	40.9	3.91449814126394	88	50	98.1	1	1	264	351	436	HOO39298.1 acetyl-CoA acetyltransferase [Deltaproteobacteria bacterium]	diamond	1053	75.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28330612	28330612	PRJNA1073183_P_NODE_13146_length_357_cov_1.683099_g13051_i0	PRJNA1073183	13146	357	1.683099	6.00866343	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	80.5	8.47e-15	NR	MBP1730777.1	2026735	g13051	i0	46.8	1.05882352941176	126	56	99.2	4	354	1	467	589	MBP1730777.1 putative peptidase, domain repeat-containing [Deltaproteobacteria bacterium]	diamond	378	80.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28804063	28804063	PRJNA1073183_P_NODE_9328_length_419_cov_2.210983_g9234_i0	PRJNA1073183	9328	419	2.210983	9.26401877	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	160	1.13e-46	NR	MBI5468643.1	2026735	g9234	i0	56.9	4.90453460620525	137	58	97.4	1	12	419	1	137	MBI5468643.1 NAD(P)H:quinone oxidoreductase [Deltaproteobacteria bacterium]	diamond	2055	160	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28835836	28835836	PRJNA1073183_P_NODE_24428_length_263_cov_1.621053_g24333_i0	PRJNA1073183	24428	263	1.621053	4.26336939	Myxococcales bacterium	2026763	Bacteria	Bacteria	59.7	1.06e-8	NR	MCA9657307.1	2026763	g24333	i0	43.6	0.627376425855513	55	31	62.7	0	257	93	109	163	MCA9657307.1 SET domain-containing protein-lysine N-methyltransferase [Myxococcales bacterium]	diamond	165	59.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29088557	29088557	PRJNA1073183_P_NODE_27068_length_250_cov_1.361582_g26973_i0	PRJNA1073183	27068	250	1.361582	3.403955	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	94	1.22e-20	NR	MCZ6714053.1	2026735	g26973	i0	48.8	2.856	80	41	96	0	3	242	145	224	MCZ6714053.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium]	diamond	714	94	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29269212	29269212	PRJNA1073183_P_NODE_31869_length_244_cov_0.900585_g31774_i0	PRJNA1073183	31869	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	110	5.53e-26	NR	WP_045119223.1	80816	g31774	i0	64.2	5.96311475409836	81	29	99.6	0	244	2	535	615	WP_045119223.1 S9 family peptidase [Haliangium ochraceum]	diamond	1455	111	0.990990990990991	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
29395750	29395750	PRJNA1073183_P_NODE_24349_length_264_cov_1.209424_g24254_i0	PRJNA1073183	24349	264	1.209424	3.19287936	Pseudomonadati	3379134	Bacteria	Bacteria	107	2.18e-26	NR	MDC0056435.1	2026735	g24254	i0	54.5	14.875	88	40	100	0	264	1	33	120	MDC0056435.1 peptidase dimerization domain-containing protein [Deltaproteobacteria bacterium]	diamond	3927	108	0.990740740740741	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29467017	29467017	PRJNA1073183_P_NODE_31710_length_244_cov_1.350877_g31615_i0	PRJNA1073183	31710	244	1.350877	3.29613988	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	46.6	0.00159	NR	MBM4280126.1	2026735	g31615	i0	48.3	0.737704918032787	60	29	71.3	1	177	4	199	258	MBM4280126.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	180	46.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30027448	30027448	PRJNA1073183_P_NODE_28911_length_248_cov_0.880000_g28816_i0	PRJNA1073183	28911	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	47.4	4.49e-4	NR	MDO8446330.1	2026735	g28816	i0	36.8	2.6491935483871	68	42	82.3	1	216	13	86	152	MDO8446330.1 GAF domain-containing protein [Deltaproteobacteria bacterium]	diamond	657	47.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30067330	30067330	PRJNA1073183_P_NODE_31172_length_245_cov_0.895349_g31077_i0	PRJNA1073183	31172	245	0.895349	2.19360505	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	159	8.17e-45	NR	MFO0674363.1	2268199	g31077	i0	90.1	24.7959183673469	81	8	99.2	0	244	2	71	151	MFO0674363.1 NADP-dependent isocitrate dehydrogenase [Polyangiaceae bacterium]	diamond	6075	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30848794	30848794	PRJNA1073183_P_NODE_32334_length_244_cov_0.900585_g32239_i0	PRJNA1073183	32334	244	0.900585	2.1974274	Bacteria	2	Bacteria	Bacteria	79	6.59e-15	NR	MBW2725789.1	2026735	g32239	i0	52.1	2.7172131147541	73	32	87.3	2	1	213	244	315	MBW2725789.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	663	79	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32217173	32217173	PRJNA1073183_P_NODE_8818_length_430_cov_1.397759_g8724_i0	PRJNA1073183	8818	430	1.397759	6.0103637	Corallococcus sp. Z5C1	1898750	Bacteria	Bacteria	169	2.1e-48	NR	WP_143908615.1	2596829	g8724	i0	52.4	7.92558139534884	143	66	99.8	1	430	2	216	356	WP_143908615.1 M35 family metallo-endopeptidase [Corallococcus sp. Z5C101001]	diamond	3408	169	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. Z5C101001

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