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

14 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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_species
26595036	26595036	PRJNA1120771_S_NODE_27361_length_230_cov_3.256684_g26961_i0	PRJNA1120771	27361	230	3.256684	7.4903732	Planctomycetota bacterium	2026780	Bacteria	Bacteria	104	5.63e-26	NR	MDA0834088.1	2026780	g26961	i0	56.6	3.93913043478261	76	33	99.1	0	3	230	106	181	MDA0834088.1 TIGR00730 family Rossman fold protein [Planctomycetota bacterium]	diamond	906	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27354754	27354754	PRJNA1120771_S_NODE_27103_length_231_cov_1.845745_g26703_i0	PRJNA1120771	27103	231	1.845745	4.26367095	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	70.1	2.25e-12	NR	MBA3722841.1	2052176	g26703	i0	87.5	0.831168831168831	32	4	41.6	0	230	135	205	236	MBA3722841.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	192	70.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydiaceae bacterium
28428207	28428207	PRJNA1120771_S_NODE_31466_length_217_cov_4.000000_g31066_i0	PRJNA1120771	31466	217	4	8.68	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.8	4.51e-4	NR	MCA9253257.1	2052180	g31066	i0	56.4	2.15668202764977	39	17	53.9	0	216	100	410	448	MCA9253257.1 tryptophanase [Phycisphaerales bacterium]	diamond	468	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
28712378	28712378	PRJNA1120771_S_NODE_34127_length_210_cov_2.604790_g33727_i0	PRJNA1120771	34127	210	2.60479	5.470059	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.00953	NR	MCC7013265.1	2026780	g33727	i0	38.3	0.671428571428571	47	24	60	1	41	166	753	799	MCC7013265.1 HEAT repeat domain-containing protein [Planctomycetota bacterium]	diamond	141	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29186108	29186108	PRJNA1120771_S_NODE_21289_length_255_cov_1.372642_g20889_i0	PRJNA1120771	21289	255	1.372642	3.5002371	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	52.8	1.25e-5	NR	MEI6343602.1	2026799	g20889	i0	38.8	0.788235294117647	67	34	70.6	1	24	203	595	661	MEI6343602.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	201	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
29553844	29553844	PRJNA1120771_S_NODE_20790_length_257_cov_3.093458_g20390_i0	PRJNA1120771	20790	257	3.093458	7.95018706	Bacteria	2	Bacteria	Bacteria	55.8	2.99e-7	NR	MBM3953160.1	2026780	g20390	i0	42.2	1.51750972762646	64	35	74.7	1	256	65	93	154	MBM3953160.1 acyl-CoA thioesterase [Planctomycetota bacterium]	diamond	390	55.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
29659095	29659095	PRJNA1120771_S_NODE_14110_length_297_cov_1.964567_g13710_i0	PRJNA1120771	14110	297	1.964567	5.83476399	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	78.2	2.28e-14	NR	MBV8532608.1	2026799	g13710	i0	47.6	3.42424242424242	82	40	82.8	2	293	48	380	458	MBV8532608.1 UTP--glucose-1-phosphate uridylyltransferase [Verrucomicrobiota bacterium]	diamond	1017	78.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
30153848	30153848	PRJNA1120771_S_NODE_10152_length_334_cov_2.089347_g9752_i0	PRJNA1120771	10152	334	2.089347	6.97841898	PVC group	1783257	Bacteria	Bacteria	45.1	0.0126	NR	MCE9581882.1	2026780	g9752	i0	34.4	1.36526946107784	93	53	83.5	3	326	48	154	238	MCE9581882.1 hypothetical protein [Planctomycetota bacterium]	diamond	456	45.4	0.993392070484582	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31302413	31302413	PRJNA1120771_S_NODE_5775_length_408_cov_2.131507_g5375_i0	PRJNA1120771	5775	408	2.131507	8.69654856	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	61.2	8.1e-8	NR	MBI2948831.1	2026799	g5375	i0	38.2	0.654411764705882	89	55	65.4	0	1	267	664	752	MBI2948831.1 choice-of-anchor D domain-containing protein [Verrucomicrobiota bacterium]	diamond	267	61.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31618693	31618693	PRJNA1120771_S_NODE_20676_length_258_cov_1.195349_g20276_i0	PRJNA1120771	20676	258	1.195349	3.08400042	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0431	NR	MEP6662696.1	2026799	g20276	i0	65.2	0.267441860465116	23	8	26.7	0	90	158	191	213	MEP6662696.1 amino acid permease [Verrucomicrobiota bacterium]	diamond	69	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
31797524	31797524	PRJNA1120771_S_NODE_35997_length_204_cov_2.863354_g35597_i0	PRJNA1120771	35997	204	2.863354	5.84124216	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	1.4e-6	NR	OGV62924.1	1798578	g35597	i0	59.2	4.76470588235294	49	17	70.6	3	195	52	655	701	OGV62924.1 MAG: hypothetical protein A2283_01740 [Lentisphaerae bacterium RIFOXYA12_FULL_48_11]	diamond	972	55.1	0.992740471869329	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium RIFOXYA12_FULL_48_11
32398997	32398997	PRJNA1120771_S_NODE_10139_length_334_cov_2.666667_g9739_i0	PRJNA1120771	10139	334	2.666667	8.90666778	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.00848	NR	MDZ4829327.1	2026778	g9739	i0	57.1	1.3562874251497	35	15	31.4	0	16	120	231	265	MDZ4829327.1 S1/P1 nuclease [Phycisphaerae bacterium]	diamond	453	46.2	0.991341991341991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
32409737	32409737	PRJNA1120771_S_NODE_31219_length_218_cov_1.988571_g30819_i0	PRJNA1120771	31219	218	1.988571	4.33508478	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	44.7	0.00568	NR	MBL0870027.1	2052180	g30819	i0	31.9	0.94954128440367	69	46	95	1	211	5	85	152	MBL0870027.1 DUF2339 domain-containing protein [Phycisphaerales bacterium]	diamond	207	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
32568089	32568089	PRJNA1120771_S_NODE_7239_length_376_cov_4.180180_g6839_i0	PRJNA1120771	7239	376	4.18018	15.7174768	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	128	3.3299999999999993e-34	NR	MBY0307717.1	2052180	g6839	i0	76	1.42021276595745	75	18	59.8	0	13	237	154	228	MBY0307717.1 S10 family peptidase [Phycisphaerales bacterium]	diamond	534	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales 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);;