metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJEB75227" and tax

16 rows where analysis = "diamond", bioproject = "PRJEB75227" 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
7788000	7788000	PRJEB75227_P_NODE_10387_length_246_cov_0.901734_g10216_i0	PRJEB75227	10387	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	160	6.22e-49	NR	MBM4057529.1	2026780	g10216	i0	96.3	2.97560975609756	82	3	100	0	1	246	38	119	MBM4057529.1 hypothetical protein [Planctomycetota bacterium]	diamond	732	160	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
23087426	23087426	PRJEB75227_P_NODE_1899_length_565_cov_1.184959_g1728_i0	PRJEB75227	1899	565	1.184959	6.69501835	Planctomycetota	203682	Bacteria	Bacteria	254	2.26e-81	NR	WP_404308400.1	445327	g1728	i0	60.4	8.98938053097345	187	73	98.8	1	559	2	7	193	WP_404308400.1 NADPH-dependent aldehyde reductase Ahr [Neorhodopirellula lusitana]	diamond	5079	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana
26781109	26781109	PRJEB75227_P_NODE_10801_length_245_cov_0.906977_g10630_i0	PRJEB75227	10801	245	0.906977	2.22209365	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	125	3.22e-32	NR	HZO83750.1	2499141	g10630	i0	100	0.783673469387755	64	0	78.4	0	245	54	321	384	HZO83750.1 tetratricopeptide repeat protein [Verrucomicrobiia bacterium]	diamond	192	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26812720	26812720	PRJEB75227_P_NODE_6941_length_273_cov_1.170000_g6770_i0	PRJEB75227	6941	273	1.17	3.1941	Aporhodopirellula aestuarii	2950107	Bacteria	Bacteria	44.3	0.0151	NR	WP_250929998.1	2950107	g6770	i0	59.5	0.406593406593407	37	14	39.6	1	121	14	13	49	WP_250929998.1 serine/threonine-protein kinase [Aporhodopirellula aestuarii]	diamond	111	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aporhodopirellula	Aporhodopirellula aestuarii
27192074	27192074	PRJEB75227_P_NODE_10362_length_246_cov_0.901734_g10191_i0	PRJEB75227	10362	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	73.2	6.65e-13	NR	MCX7933684.1	2026780	g10191	i0	43.2	0.902439024390244	74	42	90.2	0	241	20	105	178	MCX7933684.1 hypothetical protein [Planctomycetota bacterium]	diamond	222	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27287037	27287037	PRJEB75227_P_NODE_8303_length_253_cov_0.866667_g8132_i0	PRJEB75227	8303	253	0.866667	2.19266751	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	135	1.27e-36	NR	NBR86461.1	2026799	g8132	i0	97.1	0.806324110671937	68	2	80.6	0	206	3	12	79	NBR86461.1 ketoacyl-ACP synthase III [Verrucomicrobiota bacterium]	diamond	204	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27350528	27350528	PRJEB75227_P_NODE_1263_length_715_cov_1.456386_g1099_i0	PRJEB75227	1263	715	1.456386	10.4131599	Candidatus Brocadiales bacterium	2760054	Bacteria	Bacteria	124	3.4399999999999997e-32	NR	MBC8550552.1	2760054	g1099	i0	46.2	1.64895104895105	130	68	54.1	2	58	444	1	129	MBC8550552.1 hemin receptor [Candidatus Brocadiales bacterium]	diamond	1179	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales			Candidatus Brocadiales bacterium
27634613	27634613	PRJEB75227_P_NODE_3744_length_371_cov_1.238255_g3573_i0	PRJEB75227	3744	371	1.238255	4.59392605	Gemmata sp.	1914242	Bacteria	Bacteria	45.4	0.0171	NR	HSQ54477.1	1914242	g3573	i0	35.6	1.09973045822102	87	48	63.9	3	371	135	503	589	HSQ54477.1 hypothetical protein [Gemmata sp.]	diamond	408	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
28013548	28013548	PRJEB75227_P_NODE_5065_length_312_cov_0.857741_g4894_i0	PRJEB75227	5065	312	0.857741	2.67615192	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	45.1	0.00964	NR	MDB5296377.1	2052180	g4894	i0	38.9	0.692307692307692	72	43	69.2	1	78	293	49	119	MDB5296377.1 hypothetical protein [Phycisphaerales bacterium]	diamond	216	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28581847	28581847	PRJEB75227_P_NODE_6147_length_285_cov_1.193396_g5976_i0	PRJEB75227	6147	285	1.193396	3.4011786	Opitutia bacterium	2026771	Bacteria	Bacteria	53.1	1.29e-5	NR	MBI2518388.1	2026771	g5976	i0	57.7	0.547368421052632	52	19	53.7	2	133	285	6	55	MBI2518388.1 hypothetical protein [Opitutia bacterium]	diamond	156	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
28708136	28708136	PRJEB75227_P_NODE_10447_length_246_cov_0.901734_g10276_i0	PRJEB75227	10447	246	0.901734	2.21826564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	3.85e-7	NR	MEM9365902.1	2026780	g10276	i0	39.1	1.54878048780488	64	39	78	0	209	18	12	75	MEM9365902.1 hypothetical protein [Planctomycetota bacterium]	diamond	381	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30887290	30887290	PRJEB75227_P_NODE_8294_length_253_cov_0.866667_g8123_i0	PRJEB75227	8294	253	0.866667	2.19266751	Opitutaceae bacterium	2006848	Bacteria	Bacteria	120	7.989999999999999e-30	NR	MBL9187044.1	2006848	g8123	i0	66.3	3.93675889328063	83	28	98.4	0	251	3	169	251	MBL9187044.1 sulfatase-like hydrolase/transferase [Opitutaceae bacterium]	diamond	996	120	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
30950651	30950651	PRJEB75227_P_NODE_10314_length_246_cov_0.901734_g10143_i0	PRJEB75227	10314	246	0.901734	2.21826564	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94.4	3.410000000000001e-21	NR	RYD69104.1	2026800	g10143	i0	60	0.975609756097561	80	30	97.6	1	6	245	1	78	RYD69104.1 MAG: MFS transporter, partial [Verrucomicrobiaceae bacterium]	diamond	240	94.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
31393169	31393169	PRJEB75227_P_NODE_7636_length_261_cov_1.659574_g7465_i0	PRJEB75227	7636	261	1.659574	4.33148814	Paludisphaera soli	2712865	Bacteria	Bacteria	91.7	7.46e-20	NR	WP_165250268.1	2712865	g7465	i0	65.2	0.758620689655172	66	23	75.9	0	259	62	256	321	WP_165250268.1 calcium/sodium antiporter [Paludisphaera soli]	diamond	198	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera soli
31804038	31804038	PRJEB75227_P_NODE_11157_length_244_cov_0.912281_g10986_i0	PRJEB75227	11157	244	0.912281	2.22596564	Planctomycetota bacterium	2026780	Bacteria	Bacteria	83.6	1.05e-18	NR	MEK6623031.1	2026780	g10986	i0	93	1.05737704918033	43	3	52.9	0	129	1	1	43	MEK6623031.1 STAS domain-containing protein [Planctomycetota bacterium]	diamond	258	83.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32563799	32563799	PRJEB75227_P_NODE_7459_length_264_cov_1.581152_g7288_i0	PRJEB75227	7459	264	1.581152	4.17424128	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	75.1	1.99e-13	NR	MCE2726174.1	2026779	g7288	i0	46	0.988636363636364	87	46	98.9	1	263	3	1490	1575	MCE2726174.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	261	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;