metadata: contig_metadata: 10 rows where bioproject = "PRJNA738523", tax_phylum = "Myxococcota" and tax

10 rows where bioproject = "PRJNA738523", 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
27178716	27178716	PRJNA738523_P_NODE_9422_length_260_cov_2.406417_g9351_i0	PRJNA738523	9422	260	2.406417	6.2566842	Sandaracinaceae bacterium	2510337	Bacteria	Bacteria	70.5	5.14e-12	NR	MBK6580248.1	2510337	g9351	i0	41.9	1.98461538461538	86	44	99.2	2	259	2	168	247	MBK6580248.1 alpha/beta hydrolase [Sandaracinaceae bacterium]	diamond	516	70.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
27368888	27368888	PRJNA738523_P_NODE_12943_length_247_cov_0.885057_g12872_i0	PRJNA738523	12943	247	0.885057	2.18609079	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	53.9	3.05e-6	NR	MBI2394649.1	2026735	g12872	i0	40.7	0.983805668016194	81	48	98.4	0	1	243	127	207	MBI2394649.1 FAD-dependent oxidoreductase [Deltaproteobacteria bacterium]	diamond	243	53.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28989258	28989258	PRJNA738523_P_NODE_13628_length_246_cov_0.878613_g13557_i0	PRJNA738523	13628	246	0.878613	2.16138798	Bacteria	2	Bacteria	Bacteria	56.6	4.93e-7	NR	TNE43084.1	2026735	g13557	i0	45.5	1.82926829268293	77	36	93.9	3	232	2	696	766	TNE43084.1 MAG: hypothetical protein EP343_34320 [Deltaproteobacteria bacterium]	diamond	450	56.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29799654	29799654	PRJNA738523_P_NODE_13771_length_245_cov_0.895349_g13700_i0	PRJNA738523	13771	245	0.895349	2.19360505	Myxococcales bacterium	2026763	Bacteria	Bacteria	67.4	7.34e-11	NR	MSP92211.1	2026763	g13700	i0	76.1	0.563265306122449	46	11	56.3	0	244	107	364	409	MSP92211.1 phosphoglycerate dehydrogenase [Myxococcales bacterium]	diamond	138	67.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30368877	30368877	PRJNA738523_P_NODE_12932_length_247_cov_0.885057_g12861_i0	PRJNA738523	12932	247	0.885057	2.18609079	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	144	9.279999999999999e-41	NR	HBZ69257.1	2026735	g12861	i0	81.6	1.84615384615385	76	14	92.3	0	247	20	128	203	HBZ69257.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	456	144	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30441922	30441922	PRJNA738523_P_NODE_11253_length_250_cov_0.870056_g11182_i0	PRJNA738523	11253	250	0.870056	2.17514	Myxococcia	32015	Bacteria	Bacteria	72.4	1.46e-12	NR	MCA9595275.1	2026763	g11182	i0	45.1	3.924	82	45	98.4	0	2	247	122	203	MCA9595275.1 HDOD domain-containing protein [Myxococcales bacterium]	diamond	981	72.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31095052	31095052	PRJNA738523_P_NODE_14555_length_244_cov_0.900585_g14484_i0	PRJNA738523	14555	244	0.900585	2.1974274	Myxococcota bacterium	2818507	Bacteria	Bacteria	80.9	2.37e-16	NR	MEM1008579.1	2818507	g14484	i0	50	0.983606557377049	80	39	98.4	1	242	3	97	175	MEM1008579.1 NAD-glutamate dehydrogenase domain-containing protein [Myxococcota bacterium]	diamond	240	80.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31157965	31157965	PRJNA738523_P_NODE_14335_length_244_cov_0.900585_g14264_i0	PRJNA738523	14335	244	0.900585	2.1974274	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	124	7.279999999999998e-35	NR	MAJ48576.1	2026735	g14264	i0	80.5	6.44262295081967	77	15	94.7	0	242	12	29	105	MAJ48576.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	1572	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31569697	31569697	PRJNA738523_P_NODE_12596_length_247_cov_1.396552_g12525_i0	PRJNA738523	12596	247	1.396552	3.44948344	Paraliomyxa miuraensis	376150	Bacteria	Bacteria	43.9	0.0134	NR	WP_266215623.1	376150	g12525	i0	40.4	0.631578947368421	52	31	63.2	0	171	16	188	239	WP_266215623.1 hypothetical protein [Paraliomyxa miuraensis]	diamond	156	43.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales		Paraliomyxa	Paraliomyxa miuraensis
32865157	32865157	PRJNA738523_P_NODE_780_length_694_cov_2.136876_g716_i0	PRJNA738523	780	694	2.136876	14.82991944	Myxococcota bacterium	2818507	Bacteria	Bacteria	152	2.98e-38	NR	MEL7367944.1	2818507	g716	i0	40.7	0.881844380403458	204	93	88.2	7	55	666	588	763	MEL7367944.1 hypothetical protein [Myxococcota bacterium]	diamond	612	152	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;