metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA330616" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA330616" 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
16967150	16967150	PRJNA330616_P_NODE_30874_length_162_cov_0.902655_g30465_i0	PRJNA330616	30874	162	0.902655	1.4623011	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	97.8	3.5700000000000003e-22	NR	MEN9361771.1	2026799	g30465	i0	86.5	0.962962962962963	52	7	96.3	0	161	6	122	173	MEN9361771.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	156	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
18241437	18241437	PRJNA330616_P_NODE_32475_length_161_cov_0.910714_g32066_i0	PRJNA330616	32475	161	0.910714	1.46624954	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	76.3	1.84e-14	NR	MBM3826354.1	2026799	g32066	i0	85.4	6.3167701863354	41	6	76.4	0	125	3	4	44	MBM3826354.1 PhoH family protein [Verrucomicrobiota bacterium]	diamond	1017	76.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27422465	27422465	PRJNA330616_P_NODE_24563_length_170_cov_1.685950_g24154_i0	PRJNA330616	24563	170	1.68595	2.866115	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.2	1.98e-14	NR	MCX5658594.1	2026780	g24154	i0	70.7	0.723529411764706	41	12	72.4	0	1	123	19	59	MCX5658594.1 hypothetical protein [Planctomycetota bacterium]	diamond	123	71.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27611826	27611826	PRJNA330616_P_NODE_28344_length_165_cov_0.879310_g27935_i0	PRJNA330616	28344	165	0.87931	1.4508615	Gemmataceae bacterium	2052164	Bacteria	Bacteria	48.5	1.07e-4	NR	MCI0681538.1	2052164	g27935	i0	55.6	1.72727272727273	45	20	81.8	0	25	159	178	222	MCI0681538.1 hypothetical protein [Gemmataceae bacterium]	diamond	285	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28242986	28242986	PRJNA330616_P_NODE_12586_length_233_cov_1.592391_g12177_i0	PRJNA330616	12586	233	1.592391	3.71027103	Planctomycetia bacterium	2052181	Bacteria	Bacteria	62.4	3.31e-9	NR	MDZ4778905.1	2052181	g12177	i0	46.2	1.00429184549356	78	41	99.1	1	231	1	142	219	MDZ4778905.1 hypothetical protein [Planctomycetia bacterium]	diamond	234	62.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
28432663	28432663	PRJNA330616_P_NODE_14626_length_218_cov_1.207101_g14217_i0	PRJNA330616	14626	218	1.207101	2.63148018	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	83.2	1.54e-16	NR	MFN7020731.1	2052180	g14217	i0	73.6	1.52752293577982	53	14	72.9	0	1	159	952	1004	MFN7020731.1 tandem-95 repeat protein [Phycisphaerales bacterium]	diamond	333	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28432668	28432668	PRJNA330616_P_NODE_19086_length_193_cov_1.062500_g18677_i0	PRJNA330616	19086	193	1.0625	2.050625	Rubripirellula amarantea	2527999	Bacteria	Bacteria	46.6	8.38e-4	NR	WP_146513878.1	2527999	g18677	i0	53.3	0.699481865284974	45	21	69.9	0	11	145	369	413	WP_146513878.1 Glu/Leu/Phe/Val family dehydrogenase [Rubripirellula amarantea]	diamond	135	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula amarantea
29253301	29253301	PRJNA330616_P_NODE_32589_length_161_cov_0.910714_g32180_i0	PRJNA330616	32589	161	0.910714	1.46624954	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	64.3	9.74e-12	NR	MBC7816662.1	2026779	g32180	i0	73.2	1.54658385093168	41	11	76.4	0	157	35	1	41	MBC7816662.1 GntR family transcriptional regulator [Planctomycetaceae bacterium]	diamond	249	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30281902	30281902	PRJNA330616_P_NODE_30832_length_162_cov_0.902655_g30423_i0	PRJNA330616	30832	162	0.902655	1.4623011	Bacteria	2	Bacteria	Bacteria	57.8	6.32e-8	NR	MBS0633223.1	2026799	g30423	i0	53.8	1.92592592592593	52	24	96.3	0	156	1	316	367	MBS0633223.1 response regulator [Verrucomicrobiota bacterium]	diamond	312	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30579882	30579882	PRJNA330616_P_NODE_31413_length_162_cov_0.902655_g31004_i0	PRJNA330616	31413	162	0.902655	1.4623011	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	98.6	2.28e-22	NR	HEX5222028.1	2499141	g31004	i0	94.3	0.981481481481482	53	3	98.1	0	160	2	329	381	HEX5222028.1 D-aminoacylase [Verrucomicrobiia bacterium]	diamond	159	98.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31749607	31749607	PRJNA330616_P_NODE_25997_length_167_cov_0.864407_g25588_i0	PRJNA330616	25997	167	0.864407	1.44355969	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	48.5	1.19e-4	NR	MEX2579202.1	2026801	g25588	i0	42.6	2.74850299401198	54	28	91.6	1	14	166	218	271	MEX2579202.1 M48 family metallopeptidase [Verrucomicrobiales bacterium]	diamond	459	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32066018	32066018	PRJNA330616_P_NODE_11138_length_248_cov_1.025126_g10729_i0	PRJNA330616	11138	248	1.025126	2.54231248	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.4	1.18e-5	NR	PYK27621.1	2026799	g10729	i0	61.1	0.810483870967742	36	14	43.5	0	119	12	1	36	PYK27621.1 MAG: hypothetical protein DME59_04320 [Verrucomicrobiota bacterium]	diamond	201	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32635057	32635057	PRJNA330616_P_NODE_26200_length_167_cov_0.864407_g25791_i0	PRJNA330616	26200	167	0.864407	1.44355969	Planctomycetota bacterium	2026780	Bacteria	Bacteria	51.6	9.53e-6	NR	TXT28242.1	2026780	g25791	i0	48.1	2.55089820359281	52	27	93.4	0	162	7	271	322	TXT28242.1 MAG: hypothetical protein FD138_2632 [Planctomycetota bacterium]	diamond	426	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;