metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1034994" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1034994" and tax_clade = "PVC group"

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
18020115	18020115	PRJNA1034994_P_NODE_6375_length_253_cov_2.444444_g6291_i0	PRJNA1034994	6375	253	2.444444	6.18444332	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	158	6.17e-44	NR	MDZ4687866.1	2026779	g6291	i0	87.8	0.972332015810277	82	10	97.2	0	4	249	86	167	MDZ4687866.1 arylsulfatase [Planctomycetaceae bacterium]	diamond	246	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26774051	26774051	PRJNA1034994_P_NODE_9481_length_243_cov_0.905882_g9397_i0	PRJNA1034994	9481	243	0.905882	2.20129326	Planctomycetia	203683	Bacteria	Bacteria	139	2.11e-37	NR	MBL9092141.1	2026779	g9397	i0	86.1	3.92592592592593	79	11	97.5	0	239	3	188	266	MBL9092141.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Planctomycetaceae bacterium]	diamond	954	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26908579	26908579	PRJNA1034994_P_NODE_4242_length_278_cov_1.219512_g4158_i0	PRJNA1034994	4242	278	1.219512	3.39024336	Pirellulales bacterium	2715253	Bacteria	Bacteria	157	1.5899999999999996e-43	NR	HEX4130324.1	2715253	g4158	i0	78	2.9568345323741	91	20	98.2	0	278	6	346	436	HEX4130324.1 family 16 glycoside hydrolase [Pirellulales bacterium]	diamond	822	157	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27035132	27035132	PRJNA1034994_P_NODE_4382_length_276_cov_1.492611_g4298_i0	PRJNA1034994	4382	276	1.492611	4.11960636	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	140	1.13e-36	NR	MBL9093521.1	2026779	g4298	i0	79.3	1	92	18	98.9	1	273	1	234	325	MBL9093521.1 pilus assembly protein N-terminal domain-containing protein [Planctomycetaceae bacterium]	diamond	276	140	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
27319735	27319735	PRJNA1034994_P_NODE_4843_length_270_cov_2.258883_g4759_i0	PRJNA1034994	4843	270	2.258883	6.0989841	Akkermansia sp.	1872421	Bacteria	Bacteria	114	4.86e-30	NR	MBR3944625.1	1872421	g4759	i0	98.2	1.22222222222222	55	1	61.1	0	4	168	106	160	MBR3944625.1 hypothetical protein [Akkermansia sp.]	diamond	330	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
27446249	27446249	PRJNA1034994_P_NODE_3343_length_289_cov_1.111111_g3259_i0	PRJNA1034994	3343	289	1.111111	3.21111079	Pirellulales bacterium	2715253	Bacteria	Bacteria	52	3.68e-5	NR	MBN2217511.1	2715253	g3259	i0	42.9	0.653979238754325	63	36	65.4	0	26	214	135	197	MBN2217511.1 hypothetical protein [Pirellulales bacterium]	diamond	189	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27817076	27817076	PRJNA1034994_P_NODE_7504_length_249_cov_0.875000_g7420_i0	PRJNA1034994	7504	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	84.3	3.67e-17	NR	TDJ55487.1	2026780	g7420	i0	62.9	2.24096385542169	62	23	74.7	0	1	186	38	99	TDJ55487.1 MAG: phytoene/squalene synthase family protein [Planctomycetota bacterium]	diamond	558	84.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28898230	28898230	PRJNA1034994_P_NODE_3888_length_282_cov_1.473684_g3804_i0	PRJNA1034994	3888	282	1.473684	4.15578888	Planctomycetales bacterium	2053591	Bacteria	Bacteria	124	1.07e-30	NR	MCA9232188.1	2053591	g3804	i0	60.2	0.98936170212766	93	36	98.9	1	282	4	71	162	MCA9232188.1 hypothetical protein [Planctomycetales bacterium]	diamond	279	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29340545	29340545	PRJNA1034994_P_NODE_8009_length_247_cov_0.885057_g7925_i0	PRJNA1034994	8009	247	0.885057	2.18609079	Planctomycetales bacterium	2053591	Bacteria	Bacteria	53.1	8.3e-6	NR	MFN0054048.1	2053591	g7925	i0	50	0.607287449392713	50	21	60.7	1	151	2	164	209	MFN0054048.1 zf-HC2 domain-containing protein [Planctomycetales bacterium]	diamond	150	53.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
29403609	29403609	PRJNA1034994_P_NODE_3669_length_285_cov_1.202830_g3585_i0	PRJNA1034994	3669	285	1.20283	3.4280655	Pirellulales bacterium	2715253	Bacteria	Bacteria	66.6	1.52e-10	NR	HEX3869457.1	2715253	g3585	i0	73.7	0.4	38	10	40	0	121	8	1	38	HEX3869457.1 hypothetical protein [Pirellulales bacterium]	diamond	114	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
31046498	31046498	PRJNA1034994_P_NODE_8535_length_246_cov_0.890173_g8451_i0	PRJNA1034994	8535	246	0.890173	2.18982558	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	119	7.91e-33	NR	QDT71552.1	2528024	g8451	i0	76.5	2.96341463414634	81	19	98.8	0	245	3	5	85	QDT71552.1 Transposase [Lacipirellula limnantheis]	diamond	729	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
31203733	31203733	PRJNA1034994_P_NODE_9055_length_244_cov_0.900585_g8971_i0	PRJNA1034994	9055	244	0.900585	2.1974274	Anatilimnocola floriformis	2948575	Bacteria	Bacteria	71.6	1.32e-12	NR	WP_254509295.1	2948575	g8971	i0	61.7	0.577868852459016	47	18	57.8	0	5	145	241	287	WP_254509295.1 RNA polymerase sigma factor SigJ [Anatilimnocola floriformis]	diamond	141	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola floriformis
31227660	31227660	PRJNA1034994_P_NODE_7035_length_250_cov_0.870056_g6951_i0	PRJNA1034994	7035	250	0.870056	2.17514	Anatilimnocola	2807414	Bacteria	Bacteria	105	3.27e-24	NR	MBS0208814.1	2026780	g6951	i0	59.8	3.912	82	33	98.4	0	248	3	378	459	MBS0208814.1 S9 family peptidase [Planctomycetota bacterium]	diamond	978	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31765467	31765467	PRJNA1034994_P_NODE_9997_length_241_cov_2.505952_g9913_i0	PRJNA1034994	9997	241	2.505952	6.03934432	Bacteria	2	Bacteria	Bacteria	106	1.05e-25	NR	MCE9605887.1	2052181	g9913	i0	68.4	1.96680497925311	79	25	98.3	0	239	3	24	102	MCE9605887.1 ABC transporter permease subunit [Planctomycetia bacterium]	diamond	474	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;