metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax

10 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_phylum = "Planctomycetota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
17914127	17914127	PRJEB48218_S_NODE_26555_length_166_cov_2.744526_g25593_i0	PRJEB48218	26555	166	2.744526	4.55591316	Bacteria	2	Bacteria	Bacteria	94.7	3.59e-21	NR	MEK6257670.1	2026780	g25593	i0	94.3	2.87349397590361	53	3	95.8	0	2	160	95	147	MEK6257670.1 exodeoxyribonuclease VII large subunit [Planctomycetota bacterium]	diamond	477	95.1	0.995793901156677	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27254660	27254660	PRJEB48218_S_NODE_22503_length_190_cov_3.372671_g21541_i0	PRJEB48218	22503	190	3.372671	6.4080749	Planctomycetota bacterium	2026780	Bacteria	Bacteria	119	1.58e-30	NR	MCE9553751.1	2026780	g21541	i0	93.5	0.978947368421053	62	4	97.9	0	3	188	112	173	MCE9553751.1 sigma-54 dependent transcriptional regulator [Planctomycetota bacterium]	diamond	186	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29054770	29054770	PRJEB48218_S_NODE_27508_length_162_cov_2.308271_g26546_i0	PRJEB48218	27508	162	2.308271	3.73939902	Pirellulales bacterium	2715253	Bacteria	Bacteria	46.6	5.52e-4	NR	MEX2307082.1	2715253	g26546	i0	57.5	0.740740740740741	40	17	74.1	0	4	123	339	378	MEX2307082.1 PEP-CTERM sorting domain-containing protein [Pirellulales bacterium]	diamond	120	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
30381449	30381449	PRJEB48218_S_NODE_8493_length_321_cov_3.294521_g7531_i0	PRJEB48218	8493	321	3.294521	10.57541241	Gemmata obscuriglobus	114	Bacteria	Bacteria	161	1.12e-45	NR	WP_010033463.1	114	g7531	i0	65.7	0.953271028037383	102	35	95.3	0	14	319	74	175	WP_010033463.1 hypothetical protein [Gemmata obscuriglobus]	diamond	306	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
30728560	30728560	PRJEB48218_S_NODE_24734_length_175_cov_3.095890_g23772_i0	PRJEB48218	24734	175	3.09589	5.4178075	Planctomycetota bacterium	2026780	Bacteria	Bacteria	62	2.41e-9	NR	MBU6222020.1	2026780	g23772	i0	75	0.891428571428571	52	13	89.1	0	4	159	415	466	MBU6222020.1 autotransporter-associated beta strand repeat-containing protein [Planctomycetota bacterium]	diamond	156	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31550697	31550697	PRJEB48218_S_NODE_24436_length_177_cov_2.722973_g23474_i0	PRJEB48218	24436	177	2.722973	4.81966221	Planctomycetota bacterium	2026780	Bacteria	Bacteria	91.7	4.32e-20	NR	MCY2985091.1	2026780	g23474	i0	78.8	1.76271186440678	52	11	88.1	0	170	15	191	242	MCY2985091.1 TIGR03364 family FAD-dependent oxidoreductase [Planctomycetota bacterium]	diamond	312	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31645197	31645197	PRJEB48218_S_NODE_18377_length_221_cov_3.479167_g17415_i0	PRJEB48218	18377	221	3.479167	7.68895907	Planctomycetota bacterium	2026780	Bacteria	Bacteria	76.6	1.78e-14	NR	MBA2480602.1	2026780	g17415	i0	59.7	1.83257918552036	67	23	88.2	2	1	195	49	113	MBA2480602.1 hypothetical protein [Planctomycetota bacterium]	diamond	405	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31771824	31771824	PRJEB48218_S_NODE_25337_length_172_cov_2.405594_g24375_i0	PRJEB48218	25337	172	2.405594	4.13762168	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	78.2	1.34e-15	NR	MDP1797376.1	2026779	g24375	i0	72	0.872093023255814	50	14	87.2	0	23	172	55	104	MDP1797376.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	150	78.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32563115	32563115	PRJEB48218_S_NODE_24939_length_174_cov_2.731034_g23977_i0	PRJEB48218	24939	174	2.731034	4.7519991600000004	Gemmataceae bacterium	2052164	Bacteria	Bacteria	53.5	7.47e-8	NR	MEO2089317.1	2052164	g23977	i0	60	0.603448275862069	35	14	60.3	0	169	65	13	47	MEO2089317.1 hypothetical protein [Gemmataceae bacterium]	diamond	105	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32846191	32846191	PRJEB48218_S_NODE_26980_length_164_cov_3.014815_g26018_i0	PRJEB48218	26980	164	3.014815	4.9442966	Gemmata obscuriglobus	114	Bacteria	Bacteria	62	1.95e-9	NR	WP_010033463.1	114	g26018	i0	58.2	1.00609756097561	55	22	98.8	1	163	2	170	224	WP_010033463.1 hypothetical protein [Gemmata obscuriglobus]	diamond	165	62	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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