metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA492406" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA492406" 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
26727811	26727811	PRJNA492406_P_NODE_26761_length_251_cov_0.865169_g26462_i0	PRJNA492406	26761	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	53.5	8.93e-7	NR	NRA40340.1	2026780	g26462	i0	49	1.1593625498008	49	25	58.6	0	169	23	5	53	NRA40340.1 hypothetical protein [Planctomycetota bacterium]	diamond	291	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27187073	27187073	PRJNA492406_P_NODE_6022_length_488_cov_3.187952_g5723_i0	PRJNA492406	6022	488	3.187952	15.55720576	PVC group	1783257	Bacteria	Bacteria	65.9	1.18e-9	NR	NMA20665.1	1932692	g5723	i0	47.8	4.29713114754098	67	31	38.7	1	299	487	114	180	NMA20665.1 OmpA family protein [Lentisphaerota bacterium]	diamond	2097	66.2	0.995468277945619	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27392611	27392611	PRJNA492406_P_NODE_12343_length_355_cov_1.322695_g12044_i0	PRJNA492406	12343	355	1.322695	4.69556725	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	85.5	1.32e-16	NR	HYG84357.1	2499141	g12044	i0	46.5	1.07323943661972	127	45	88.7	5	39	353	225	350	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	381	85.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27455818	27455818	PRJNA492406_P_NODE_19463_length_286_cov_1.276995_g19164_i0	PRJNA492406	19463	286	1.276995	3.6522057	Chlamydiota bacterium	2081524	Bacteria	Bacteria	45.4	0.00604	NR	NGX31959.1	2081524	g19164	i0	58.6	1.3006993006993	29	12	30.4	0	23	109	2	30	NGX31959.1 hypothetical protein [Chlamydiota bacterium]	diamond	372	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27865952	27865952	PRJNA492406_P_NODE_19405_length_286_cov_1.474178_g19106_i0	PRJNA492406	19405	286	1.474178	4.21614908	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	68.2	2.87e-12	NR	MCS6770757.1	2212473	g19106	i0	53.4	0.608391608391608	58	26	60.8	1	280	107	64	120	MCS6770757.1 DUF3253 domain-containing protein [Kiritimatiellia bacterium]	diamond	174	68.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27897518	27897518	PRJNA492406_P_NODE_12885_length_349_cov_1.021739_g12586_i0	PRJNA492406	12885	349	1.021739	3.56586911	Pirellula sp.	117	Bacteria	Bacteria	67	3.97e-10	NR	MFN7894481.1	117	g12586	i0	34.8	1.7621776504298	92	59	78.2	1	335	63	643	734	MFN7894481.1 hypothetical protein [Pirellula sp.]	diamond	615	67	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
28308239	28308239	PRJNA492406_P_NODE_30266_length_244_cov_0.900585_g29967_i0	PRJNA492406	30266	244	0.900585	2.1974274	Candidatus Brocadiia bacterium	2517210	Bacteria	Bacteria	69.3	1.55e-11	NR	NUM34221.1	2517210	g29967	i0	49.2	0.799180327868853	65	33	79.9	0	197	3	392	456	NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium]	diamond	195	69.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia				Candidatus Brocadiia bacterium
28308243	28308243	PRJNA492406_P_NODE_32086_length_241_cov_0.916667_g31787_i0	PRJNA492406	32086	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.2	2.18e-9	NR	MBN2712670.1	2026780	g31787	i0	60	0.622406639004149	50	20	62.2	0	153	4	30	79	MBN2712670.1 ABC transporter substrate-binding protein [Planctomycetota bacterium]	diamond	150	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28339702	28339702	PRJNA492406_P_NODE_24326_length_262_cov_1.222222_g24027_i0	PRJNA492406	24326	262	1.222222	3.20222164	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	64.3	1.23e-9	NR	MCA9280974.1	2052180	g24027	i0	37.6	0.973282442748092	85	53	97.3	0	262	8	564	648	MCA9280974.1 AAA family ATPase [Phycisphaerales bacterium]	diamond	255	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28355600	28355600	PRJNA492406_P_NODE_14506_length_329_cov_1.542969_g14207_i0	PRJNA492406	14506	329	1.542969	5.07636801	Pseudomonadati	3379134	Bacteria	Bacteria	127	2.73e-33	NR	OGV51411.1	1798571	g14207	i0	66.7	3.00911854103343	81	27	73.9	0	325	83	221	301	OGV51411.1 MAG: methyltransferase [Lentisphaerae bacterium GWF2_44_16]	diamond	990	128	0.9921875	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_44_16
28907771	28907771	PRJNA492406_P_NODE_23368_length_267_cov_0.891753_g23069_i0	PRJNA492406	23368	267	0.891753	2.38098051	Chlamydiia bacterium	2052156	Bacteria	Bacteria	105	3.99e-25	NR	MCH9621550.1	2052156	g23069	i0	55.2	0.97752808988764	87	39	97.8	0	267	7	71	157	MCH9621550.1 hypothetical protein [Chlamydiia bacterium]	diamond	261	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
29129308	29129308	PRJNA492406_P_NODE_5349_length_518_cov_1.159551_g5054_i0	PRJNA492406	5349	518	1.159551	6.00647418	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	48.5	0.00583	NR	MCL4200996.1	2699754	g5054	i0	35.1	0.544401544401544	94	52	54.4	3	283	2	5850	5934	MCL4200996.1 choice-of-anchor L domain-containing protein [Pirellulaceae bacterium]	diamond	282	48.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
29145362	29145362	PRJNA492406_P_NODE_6889_length_460_cov_1.400517_g6590_i0	PRJNA492406	6889	460	1.400517	6.4423782	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.02e-15	NR	OGN62432.1	1797603	g6590	i0	32.3	4.00434782608696	161	96	99.8	4	2	460	79	234	OGN62432.1 MAG: hypothetical protein A3F09_04955 [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11]	diamond	1842	83.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_11
29302883	29302883	PRJNA492406_P_NODE_29849_length_245_cov_0.895349_g29550_i0	PRJNA492406	29849	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	81.3	1.03e-15	NR	MCB1107385.1	2052156	g29550	i0	43.8	3.61224489795918	73	41	89.4	0	237	19	62	134	MCB1107385.1 hypothetical protein [Chlamydiia bacterium]	diamond	885	81.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
29507852	29507852	PRJNA492406_P_NODE_16570_length_308_cov_0.961702_g16271_i0	PRJNA492406	16570	308	0.961702	2.96204216	Planctomycetota bacterium	2026780	Bacteria	Bacteria	105	5.85e-24	NR	MDA1267173.1	2026780	g16271	i0	51	9.75974025974026	102	49	98.4	1	303	1	176	277	MDA1267173.1 M20 family metallopeptidase [Planctomycetota bacterium]	diamond	3006	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30487235	30487235	PRJNA492406_P_NODE_22473_length_271_cov_1.555556_g22174_i0	PRJNA492406	22473	271	1.555556	4.21555676	Chlamydiales bacterium	2047757	Bacteria	Bacteria	202	7.07e-62	NR	MFI5344317.1	2047757	g22174	i0	94.4	0.996309963099631	90	5	99.6	0	2	271	170	259	MFI5344317.1 fatty acid desaturase [Chlamydiales bacterium]	diamond	270	202	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
30771670	30771670	PRJNA492406_P_NODE_19534_length_286_cov_0.957746_g19235_i0	PRJNA492406	19534	286	0.957746	2.73915356	Tepidisphaera sp.	2017440	Bacteria	Bacteria	70.1	3.05e-12	NR	MBI1191332.1	2017440	g19235	i0	82.6	0.482517482517482	46	8	48.3	0	146	283	1	46	MBI1191332.1 PEP-CTERM sorting domain-containing protein [Tepidisphaera sp.]	diamond	138	70.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaera	Tepidisphaera sp.
30929491	30929491	PRJNA492406_P_NODE_24694_length_260_cov_1.443850_g24395_i0	PRJNA492406	24694	260	1.44385	3.75401	Haloferula sargassicola	490096	Bacteria	Bacteria	85.9	1.96e-17	NR	WP_353568968.1	490096	g24395	i0	54.7	0.738461538461539	64	29	73.8	0	192	1	1	64	WP_353568968.1 radical SAM protein [Haloferula sargassicola]	diamond	192	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
31024346	31024346	PRJNA492406_P_NODE_32135_length_241_cov_0.916667_g31836_i0	PRJNA492406	32135	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	55.5	1.17e-6	NR	HEY3322248.1	2026780	g31836	i0	46.4	0.858921161825726	69	36	84.6	1	230	27	539	607	HEY3322248.1 PKD domain-containing protein [Planctomycetota bacterium]	diamond	207	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31419566	31419566	PRJNA492406_P_NODE_12076_length_358_cov_1.396491_g11777_i0	PRJNA492406	12076	358	1.396491	4.99943778	Pseudomonadati	3379134	Bacteria	Bacteria	191	2.5199999999999997e-56	NR	MBL9213920.1	2006848	g11777	i0	78	46.9944134078212	118	26	98.9	0	356	3	213	330	MBL9213920.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Opitutaceae bacterium]	diamond	16824	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31624985	31624985	PRJNA492406_P_NODE_15556_length_318_cov_1.257143_g15257_i0	PRJNA492406	15556	318	1.257143	3.99771474	Chlamydia sp. 32-24	1895742	Bacteria	Bacteria	82.8	9.53e-17	NR	OJU81588.1	1895742	g15257	i0	70.4	1	54	16	50.9	0	157	318	3	56	OJU81588.1 MAG: 50S ribosomal protein L1 [Chlamydia sp. 32-24]	diamond	318	82.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 32-24
31719900	31719900	PRJNA492406_P_NODE_11257_length_370_cov_0.976431_g10958_i0	PRJNA492406	11257	370	0.976431	3.6127947	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	56.2	2.99e-6	NR	MFA6185759.1	2026778	g10958	i0	34.8	0.559459459459459	69	43	55.9	1	217	11	39	105	MFA6185759.1 cellulase family glycosylhydrolase [Phycisphaerae bacterium]	diamond	207	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32605618	32605618	PRJNA492406_P_NODE_26700_length_251_cov_0.865169_g26401_i0	PRJNA492406	26700	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	152	2.97e-42	NR	MFN7587052.1	2026780	g26401	i0	92.8	0.99203187250996006	83	6	99.2	0	249	1	38	120	MFN7587052.1 porin [Planctomycetota bacterium]	diamond	249	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32668541	32668541	PRJNA492406_P_NODE_32040_length_241_cov_0.916667_g31741_i0	PRJNA492406	32040	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	6.46e-4	NR	MCI0586680.1	2026780	g31741	i0	44.3	2.35269709543568	61	33	74.7	1	195	16	124	184	MCI0586680.1 sigma 54-interacting transcriptional regulator [Planctomycetota bacterium]	diamond	567	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32810448	32810448	PRJNA492406_P_NODE_19180_length_287_cov_1.457944_g18881_i0	PRJNA492406	19180	287	1.457944	4.18429928	Pseudomonadati	3379134	Bacteria	Bacteria	117	1.12e-29	NR	WP_094414939.1	2023130	g18881	i0	56.8	5.50871080139373	95	39	97.2	1	9	287	35	129	WP_094414939.1 alpha/beta hydrolase [Rhodopirellula sp. MGV]	diamond	1581	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rhodopirellula	Rhodopirellula sp. MGV

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