metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA385396" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA385396" 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
4234109	4234109	PRJNA385396_P_NODE_2804_length_454_cov_1.089239_g2712_i0	PRJNA385396	2804	454	1.089239	4.94514506	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	64.7	4.06e-9	NR	MEO9234664.1	2268199	g2712	i0	48.5	1.34801762114537	66	32	42.3	1	232	423	28	93	MEO9234664.1 hypothetical protein [Polyangiaceae bacterium]	diamond	612	64.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
19532935	19532935	PRJNA385396_P_NODE_4756_length_371_cov_1.003356_g4664_i0	PRJNA385396	4756	371	1.003356	3.72245076	Pseudomonadati	3379134	Bacteria	Bacteria	59.3	2.67e-7	NR	MBI5506042.1	2026735	g4664	i0	41.3	3.88140161725067	121	61	95.4	4	370	17	2272	2385	MBI5506042.1 DUF11 domain-containing protein [Deltaproteobacteria bacterium]	diamond	1440	59.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
24028300	24028300	PRJNA385396_P_NODE_7159_length_323_cov_0.888000_g7067_i0	PRJNA385396	7159	323	0.888	2.86824	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	193	2.0099999999999997e-57	NR	MBI3759687.1	2026735	g7067	i0	91.5	2.95356037151703	106	9	98.5	0	321	4	260	365	MBI3759687.1 TolC family protein [Deltaproteobacteria bacterium]	diamond	954	193	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27075204	27075204	PRJNA385396_P_NODE_19782_length_243_cov_0.905882_g19690_i0	PRJNA385396	19782	243	0.905882	2.20129326	Myxococcales bacterium	2026763	Bacteria	Bacteria	53.1	1.66e-6	NR	MEO1912235.1	2026763	g19690	i0	56.1	1.62962962962963	66	28	81.5	1	35	232	56	120	MEO1912235.1 DUF4202 family protein [Myxococcales bacterium]	diamond	396	53.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28418730	28418730	PRJNA385396_P_NODE_12406_length_259_cov_1.489247_g12314_i0	PRJNA385396	12406	259	1.489247	3.85714973	Bacteria	2	Bacteria	Bacteria	56.6	4.72e-7	NR	TVR04301.1	2026735	g12314	i0	42.9	2.83783783783784	77	44	89.2	0	6	236	148	224	TVR04301.1 MAG: SDR family NAD(P)-dependent oxidoreductase [Deltaproteobacteria bacterium]	diamond	735	57	0.992982456140351	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28464956	28464956	PRJNA385396_P_NODE_19946_length_243_cov_0.905882_g19854_i0	PRJNA385396	19946	243	0.905882	2.20129326	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	54.3	3e-6	NR	HEY6176146.1	2212474	g19854	i0	77.4	0.382716049382716	31	7	38.3	0	146	238	3	33	HEY6176146.1 sigma-54 dependent transcriptional regulator [Kofleriaceae bacterium]	diamond	93	54.3	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28496518	28496518	PRJNA385396_P_NODE_18247_length_245_cov_0.895349_g18155_i0	PRJNA385396	18247	245	0.895349	2.19360505	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	150	1.2899999999999997e-42	NR	HWA77766.1	2268199	g18155	i0	86.4	1.98367346938776	81	11	99.2	0	243	1	121	201	HWA77766.1 UDP-glucose 4-epimerase GalE [Polyangiaceae bacterium]	diamond	486	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
29001977	29001977	PRJNA385396_P_NODE_8728_length_300_cov_2.709251_g8636_i0	PRJNA385396	8728	300	2.709251	8.127753	Sorangium cellulosum	56	Bacteria	Bacteria	52.4	3e-5	NR	WP_159396632.1	56	g8636	i0	42.9	1.6	77	38	71	1	12	224	643	719	WP_159396632.1 MXAN_6577-like cysteine-rich protein [Sorangium cellulosum]	diamond	480	52.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
29601192	29601192	PRJNA385396_P_NODE_13290_length_251_cov_1.297753_g13198_i0	PRJNA385396	13290	251	1.297753	3.25736003	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.7	0.0415	NR	HMC33073.1	2026763	g13198	i0	36.1	0.99203187250996006	83	41	86.1	3	20	235	121	202	HMC33073.1 hypothetical protein [Myxococcales bacterium]	diamond	249	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30296854	30296854	PRJNA385396_P_NODE_4152_length_388_cov_3.022222_g4060_i0	PRJNA385396	4152	388	3.022222	11.72622136	Myxococcota bacterium	2818507	Bacteria	Bacteria	50.4	2.85e-5	NR	MDJ0761680.1	2818507	g4060	i0	51.2	0.332474226804124	43	21	33.2	0	139	11	41	83	MDJ0761680.1 hypothetical protein [Myxococcota bacterium]	diamond	129	50.4	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30770471	30770471	PRJNA385396_P_NODE_17014_length_247_cov_0.885057_g16922_i0	PRJNA385396	17014	247	0.885057	2.18609079	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	115	7.49e-28	NR	HUQ06442.1	2212474	g16922	i0	98.1	0.65587044534413	54	1	65.6	0	247	86	863	916	HUQ06442.1 tetratricopeptide repeat protein [Kofleriaceae bacterium]	diamond	162	115	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31402610	31402610	PRJNA385396_P_NODE_6616_length_331_cov_1.193798_g6524_i0	PRJNA385396	6616	331	1.193798	3.95147138	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.7	0.0226	NR	MBI2394944.1	2026735	g6524	i0	30.8	2.16616314199396	117	68	95.2	4	330	16	846	961	MBI2394944.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	717	44.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31687024	31687024	PRJNA385396_P_NODE_3857_length_399_cov_0.944785_g3765_i0	PRJNA385396	3857	399	0.944785	3.76969215	Myxococcales bacterium	2026763	Bacteria	Bacteria	188	9.819999999999998e-56	NR	MDH5675607.1	2026763	g3765	i0	71	1.96240601503759	131	37	98.5	1	2	394	8	137	MDH5675607.1 acetyl-CoA C-acetyltransferase [Myxococcales bacterium]	diamond	783	188	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32288575	32288575	PRJNA385396_P_NODE_20579_length_242_cov_0.911243_g20487_i0	PRJNA385396	20579	242	0.911243	2.20520806	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	60.5	2.06e-8	NR	HWA75240.1	2268199	g20487	i0	38	0.979338842975207	79	40	93	2	240	16	266	339	HWA75240.1 serine/threonine-protein kinase [Polyangiaceae bacterium]	diamond	237	60.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32414921	32414921	PRJNA385396_P_NODE_10519_length_279_cov_1.233010_g10427_i0	PRJNA385396	10519	279	1.23301	3.4400979	Archangium sp.	1872627	Bacteria	Bacteria	57.8	3.03e-7	NR	MDP1826071.1	1872627	g10427	i0	42.9	0.903225806451613	84	43	86	4	40	279	163	245	MDP1826071.1 hypothetical protein [Archangium sp.]	diamond	252	57.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium 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);;