metadata: contig_metadata: 15 rows where bioproject = "PRJNA839281", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA839281", tax_clade = "PVC group" and tax_superkingdom = "Bacteria"

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
829746	829746	PRJNA839281_S_NODE_27921_length_166_cov_1.239316_g27652_i0	PRJNA839281	27921	166	1.239316	2.05726456	Pseudomonadati	3379134	Bacteria	Bacteria	104	5.37e-26	NR	PIQ82090.1	1974750	g27652	i0	87	1.95180722891566	54	7	97.6	0	163	2	19	72	PIQ82090.1 MAG: hypothetical protein COV76_05600 [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_64_10]	diamond	324	105	0.990476190476191	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_64_10
3380352	3380352	PRJNA839281_S_NODE_14263_length_213_cov_1.554878_g13994_i0	PRJNA839281	14263	213	1.554878	3.31189014	Neorhodopirellula lusitana	445327	Bacteria	Bacteria	103	1.11e-24	NR	WP_404308400.1	445327	g13994	i0	64.8	1	71	24	98.6	1	4	213	106	176	WP_404308400.1 NADPH-dependent aldehyde reductase Ahr [Neorhodopirellula lusitana]	diamond	213	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula lusitana
3380697	3380697	PRJNA839281_S_NODE_38743_length_156_cov_5.140187_g38474_i0	PRJNA839281	38743	156	5.140187	8.01869172	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	62.1	2.13e-5	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g38474	i0	91.111	0.288461538461538	45	4	29	0	19	63	1370618	1370662	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	45	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
4658175	4658175	PRJNA839281_S_NODE_30824_length_165_cov_0.879310_g30555_i0	PRJNA839281	30824	165	0.87931	1.4508615	Tautonia marina	2653855	Bacteria	Bacteria	103	3.66e-24	NR	WP_201750339.1	2653855	g30555	i0	92.7	1	55	4	100	0	1	165	249	303	WP_201750339.1 efflux RND transporter permease subunit [Tautonia marina]	diamond	165	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia marina
19956279	19956279	PRJNA839281_S_NODE_36836_length_161_cov_0.910714_g36567_i0	PRJNA839281	36836	161	0.910714	1.46624954	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	198	1.6199999999999999e-46	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g36567	i0	88.889	35.8074534161491	162	17	100	1	1	161	9886777	9886616	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	5765	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26706217	26706217	PRJNA839281_S_NODE_15361_length_207_cov_0.962025_g15092_i0	PRJNA839281	15361	207	0.962025	1.99139175	Planctomycetota bacterium	2026780	Bacteria	Bacteria	64.7	3.46e-11	NR	MBM4055472.1	2026780	g15092	i0	54.5	4.89855072463768	55	25	79.7	0	9	173	45	99	MBM4055472.1 hemin receptor [Planctomycetota bacterium]	diamond	1014	64.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27884393	27884393	PRJNA839281_S_NODE_8025_length_282_cov_1.901288_g7756_i0	PRJNA839281	8025	282	1.901288	5.36163216	Pseudomonadati	3379134	Bacteria	Bacteria	134	5.079999999999998e-35	NR	NUQ35036.1	2026779	g7756	i0	78.3	12.3617021276596	83	18	88.3	0	282	34	399	481	NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium]	diamond	3486	135	0.992592592592593	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28539250	28539250	PRJNA839281_S_NODE_8747_length_269_cov_1.977273_g8478_i0	PRJNA839281	8747	269	1.977273	5.31886437	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	44.7	0.0105	NR	NUN94410.1	2499141	g8478	i0	41.8	0.613382899628253	55	29	58	1	164	9	410	464	NUN94410.1 (E)-4-hydroxy-3-methylbut-2-enyl-diphosphate synthase [Verrucomicrobiia bacterium]	diamond	165	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
28602256	28602256	PRJNA839281_S_NODE_27407_length_167_cov_0.864407_g27138_i0	PRJNA839281	27407	167	0.864407	1.44355969	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.7	0.0135	NR	MEY4246360.1	2026799	g27138	i0	44.9	0.880239520958084	49	26	88	1	10	156	619	666	MEY4246360.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	147	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29328274	29328274	PRJNA839281_S_NODE_12509_length_226_cov_1.152542_g12240_i0	PRJNA839281	12509	226	1.152542	2.60474492	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	118	2.86e-29	NR	HUK83902.1	2499141	g12240	i0	72	3.95575221238938	75	21	99.6	0	225	1	304	378	HUK83902.1 putrescine aminotransferase [Verrucomicrobiia bacterium]	diamond	894	118	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29359997	29359997	PRJNA839281_S_NODE_36049_length_162_cov_0.902655_g35780_i0	PRJNA839281	36049	162	0.902655	1.4623011	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	74.3	5.97e-16	NR	MBK7998698.1	2026799	g35780	i0	97.4	0.722222222222222	39	1	72.2	0	119	3	1	39	MBK7998698.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	117	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30063033	30063033	PRJNA839281_S_NODE_33431_length_163_cov_0.894737_g33162_i0	PRJNA839281	33431	163	0.894737	1.45842131	Planctomycetia	203683	Bacteria	Bacteria	77.4	3.1e-15	NR	TVS19381.1	2026779	g33162	i0	57.4	6.95705521472393	54	23	99.4	0	163	2	83	136	TVS19381.1 MAG: dihydroorotate dehydrogenase electron transfer subunit [Planctomycetaceae bacterium]	diamond	1134	77.8	0.994858611825193	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30528546	30528546	PRJNA839281_S_NODE_16333_length_202_cov_0.993464_g16064_i0	PRJNA839281	16333	202	0.993464	2.00679728	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	45.4	0.00243	NR	MBW7905979.1	2026778	g16064	i0	39.6	1.42574257425743	48	29	71.3	0	199	56	83	130	MBW7905979.1 alpha/beta fold hydrolase [Phycisphaerae bacterium]	diamond	288	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31413548	31413548	PRJNA839281_S_NODE_9456_length_258_cov_1.655502_g9187_i0	PRJNA839281	9456	258	1.655502	4.27119516	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	130	1.8899999999999998e-34	NR	MBK7404499.1	2052180	g9187	i0	67.1	2.95348837209302	85	28	98.8	0	257	3	35	119	MBK7404499.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium]	diamond	762	130	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32552728	32552728	PRJNA839281_S_NODE_26319_length_167_cov_1.296610_g26050_i0	PRJNA839281	26319	167	1.29661	2.1653387	Singulisphaera sp.	1906241	Bacteria	Bacteria	44.3	0.00378	NR	MEJ7637766.1	1906241	g26050	i0	52.5	0.718562874251497	40	18	71.9	1	126	7	147	185	MEJ7637766.1 sigma factor [Singulisphaera sp.]	diamond	120	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp.

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);;