metadata: contig_metadata: 11 rows where bioproject = "PRJNA951412" and tax

11 rows where bioproject = "PRJNA951412" 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
10191521	10191521	PRJNA951412_P_NODE_6208_length_246_cov_0.901734_g6123_i0	PRJNA951412	6208	246	0.901734	2.21826564	Botrimarina	2795782	Bacteria	Bacteria	285	2.01e-72	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g6123	i0	88.235	2.05691056910569	238	28	97	0	1	238	2133335	2133572	Planctomycetes bacterium K2D chromosome, complete genome	blastn	506	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
11138431	11138431	PRJNA951412_P_NODE_2209_length_315_cov_1.115702_g2124_i0	PRJNA951412	2209	315	1.115702	3.5144613	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	58.4	6.34e-4	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g2124	i0	100	3.01269841269841	31	0	10	0	58	88	2594584	2594554	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	949	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
16237627	16237627	PRJNA951412_P_NODE_3813_length_258_cov_1.254054_g3728_i0	PRJNA951412	3813	258	1.254054	3.23545932	Neorhodopirellula lusitana	445327	Bacteria	Bacteria	134	4.49e-36	NR	WP_404308400.1	445327	g3728	i0	70.6	2.98837209302326	85	24	97.7	1	3	254	115	199	WP_404308400.1 NADPH-dependent aldehyde reductase Ahr [Neorhodopirellula lusitana]	diamond	771	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana
18786569	18786569	PRJNA951412_P_NODE_5975_length_247_cov_0.890805_g5890_i0	PRJNA951412	5975	247	0.890805	2.20028835	Terrimicrobiaceae bacterium	2832348	Bacteria	Bacteria	97.4	2.09e-21	NR	MDD5199418.1	2832348	g5890	i0	75.4	1.62753036437247	65	16	78.9	0	51	245	56	120	MDD5199418.1 M48 family metallopeptidase [Terrimicrobiaceae bacterium]	diamond	402	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae		Terrimicrobiaceae bacterium
18786577	18786577	PRJNA951412_P_NODE_6695_length_245_cov_0.906977_g6610_i0	PRJNA951412	6695	245	0.906977	2.22209365	Verrucomicrobiaceae	203557	Bacteria	Bacteria	145	2.14e-38	NR	WP_200269199.1	454153	g6610	i0	90.1	12.869387755102	81	8	99.2	0	243	1	715	795	WP_200269199.1 proline dehydrogenase family protein [Luteolibacter pohnpeiensis]	diamond	3153	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
25160949	25160949	PRJNA951412_P_NODE_4780_length_250_cov_1.480226_g4695_i0	PRJNA951412	4780	250	1.480226	3.700565	uncultured Terrimicrobium sp.	1758082	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2518609723\|gb\|OR128325.1\|	1758082	g4695	i0	100	99.888	250	0	100	0	1	250	290	41	Uncultured Terrimicrobium sp. clone 748a464ea190c92309074b4379e01e2e 16S ribosomal RNA gene, partial sequence	blastn	24972	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	uncultured Terrimicrobium sp.
26708720	26708720	PRJNA951412_P_NODE_7601_length_243_cov_0.905882_g7516_i0	PRJNA951412	7601	243	0.905882	2.20129326	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	126	3.6899999999999996e-32	NR	MCA8985066.1	2026779	g7516	i0	100	0.703703703703704	57	0	70.4	0	3	173	414	470	MCA8985066.1 methyltransferase domain-containing protein [Planctomycetaceae bacterium]	diamond	171	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26835851	26835851	PRJNA951412_P_NODE_7701_length_242_cov_0.923077_g7616_i0	PRJNA951412	7701	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	82	2.16e-16	NR	MBX7106043.1	2052164	g7616	i0	51.3	0.991735537190083	80	37	99.2	1	3	242	185	262	MBX7106043.1 HNH endonuclease [Gemmataceae bacterium]	diamond	240	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29520264	29520264	PRJNA951412_P_NODE_2090_length_323_cov_1.116000_g2005_i0	PRJNA951412	2090	323	1.116	3.60468	Planctomycetota bacterium	2026780	Bacteria	Bacteria	124	3.0299999999999997e-30	NR	MEC9373988.1	2026780	g2005	i0	57.7	6.52941176470588	104	44	96.6	0	10	321	657	760	MEC9373988.1 alanine--tRNA ligase [Planctomycetota bacterium]	diamond	2109	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32340229	32340229	PRJNA951412_P_NODE_5579_length_248_cov_0.891429_g5494_i0	PRJNA951412	5579	248	0.891429	2.21074392	Pseudomonadati	3379134	Bacteria	Bacteria	126	6.52e-33	NR	MFO0847386.1	2052164	g5494	i0	69.5	1.98387096774194	82	25	99.2	0	1	246	165	246	MFO0847386.1 fatty acid desaturase [Gemmataceae bacterium]	diamond	492	127	0.992125984251969	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32365286	32365286	PRJNA951412_P_NODE_6479_length_246_cov_0.890173_g6394_i0	PRJNA951412	6479	246	0.890173	2.18982558	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	52.8	1.09e-5	NR	HEV3164829.1	2691532	g6394	i0	39.3	1.02439024390244	84	46	98.8	2	2	244	330	411	HEV3164829.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	252	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae 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);;