metadata: contig_metadata: 25 rows where bioproject = "PRJNA416866" and tax

25 rows where bioproject = "PRJNA416866" 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
4246684	4246684	PRJNA416866_P_NODE_10484_length_206_cov_0.882759_g10340_i0	PRJNA416866	10484	206	0.882759	1.81848354	Planctomycetia	203683	Bacteria	Bacteria	105	1.34e-26	NR	MEE3180495.1	2026780	g10340	i0	80.3	6.56796116504854	61	12	88.8	0	22	204	19	79	MEE3180495.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1353	106	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
4246701	4246701	PRJNA416866_P_NODE_264_length_1354_cov_6.601701_g205_i0	PRJNA416866	264	1354	6.601701	89.38703154	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	289	1.86e-90	NR	RYD71398.1	2026800	g205	i0	44.8	0.786558345642541	355	183	77.3	6	1261	215	14	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	1065	289	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
6797408	6797408	PRJNA416866_P_NODE_11426_length_202_cov_1.361702_g11282_i0	PRJNA416866	11426	202	1.361702	2.75063804	Aureliella sp.	2795609	Bacteria	Bacteria	115	5.13e-28	NR	MFN3191721.1	2795609	g11282	i0	81.5	1.93069306930693	65	12	96.5	0	197	3	499	563	MFN3191721.1 NADP-dependent isocitrate dehydrogenase [Aureliella sp.]	diamond	390	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
15111479	15111479	PRJNA416866_P_NODE_252_length_1378_cov_6.574032_g196_i0	PRJNA416866	252	1378	6.574032	90.59016096	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	434	1.6399999999999995e-147	NR	RYD65414.1	2026800	g196	i0	76.3	0.61611030478955	283	65	61.6	1	318	1166	56	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	849	434	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
16997082	16997082	PRJNA416866_P_NODE_6094_length_264_cov_1.261084_g5950_i0	PRJNA416866	6094	264	1.261084	3.32926176	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	69.4	2.39e-7	NTclustered	gi\|2621705864\|emb\|OY763926.1\|	2813034	g5950	i0	95.349	4.83333333333333	43	2	16	0	7	49	2551960	2552002	MAG: Sedimentisphaerales bacterium isolate 7f5c64f7-1a0d-4936-834e-775057159072 genome assembly, chromosome: 1	blastn	1276	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
22760718	22760718	PRJNA416866_P_NODE_3398_length_363_cov_1.576159_g3255_i0	PRJNA416866	3398	363	1.576159	5.72145717	Verrucomicrobiales	48461	Bacteria	Bacteria	166	9.569999999999999e-48	NR	WP_347441213.1	2109375	g3255	i0	67.2	12.3884297520661	119	39	98.3	0	361	5	169	287	WP_347441213.1 NADPH-dependent aldehyde reductase Ahr [Rubritalea sp.]	diamond	4497	167	0.994011976047904	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea sp.
26854338	26854338	PRJNA416866_P_NODE_6701_length_251_cov_1.473684_g6557_i0	PRJNA416866	6701	251	1.473684	3.69894684	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94.7	2.06e-20	NR	RYD77759.1	2026800	g6557	i0	60.2	0.99203187250996006	83	33	99.2	0	3	251	162	244	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	249	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27123491	27123491	PRJNA416866_P_NODE_3442_length_361_cov_1.440000_g3299_i0	PRJNA416866	3442	361	1.44	5.1984	PVC group	1783257	Bacteria	Bacteria	63.2	3.17e-9	NR	MCK4859712.1	2035772	g3299	i0	62.5	1.66204986149584	40	15	33.2	0	325	206	2	41	MCK4859712.1 adenylate kinase [Candidatus Omnitrophota bacterium]	diamond	600	63.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
27138372	27138372	PRJNA416866_P_NODE_2862_length_400_cov_1.138643_g2719_i0	PRJNA416866	2862	400	1.138643	4.554572	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	50.8	4.83e-5	NR	MBO5694326.1	2053569	g2719	i0	62.2	0.57	37	14	27.8	0	400	290	4	40	MBO5694326.1 sel1 repeat family protein [Lentisphaeria bacterium]	diamond	228	50.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27170173	27170173	PRJNA416866_P_NODE_4682_length_304_cov_1.950617_g4538_i0	PRJNA416866	4682	304	1.950617	5.92987568	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	103	3.94e-24	NR	RYD81270.1	2026800	g4538	i0	78.9	0.5625	57	12	56.3	0	132	302	179	235	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	171	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27581040	27581040	PRJNA416866_P_NODE_9464_length_209_cov_0.864865_g9320_i0	PRJNA416866	9464	209	0.864865	1.80756785	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0175	NR	MBR3921640.1	2212473	g9320	i0	41	1.67942583732057	39	22	56	1	200	84	231	268	MBR3921640.1 beta-galactosidase [Kiritimatiellia bacterium]	diamond	351	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27896734	27896734	PRJNA416866_P_NODE_9605_length_209_cov_0.864865_g9461_i0	PRJNA416866	9605	209	0.864865	1.80756785	Gemmataceae bacterium	2052164	Bacteria	Bacteria	50.1	6.22e-5	NR	HEX5270779.1	2052164	g9461	i0	47.7	0.631578947368421	44	23	63.2	0	206	75	617	660	HEX5270779.1 hypothetical protein [Gemmataceae bacterium]	diamond	132	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29254309	29254309	PRJNA416866_P_NODE_5729_length_273_cov_1.547170_g5585_i0	PRJNA416866	5729	273	1.54717	4.2237741	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.6	0.00123	NR	MCX6904291.1	2026799	g5585	i0	44.1	0.648351648351648	59	33	64.8	0	94	270	53	111	MCX6904291.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	177	46.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29349321	29349321	PRJNA416866_P_NODE_10329_length_206_cov_0.882759_g10185_i0	PRJNA416866	10329	206	0.882759	1.81848354	Chlamydiales bacterium	2047757	Bacteria	Bacteria	84.3	1.72e-17	NR	MDB2614324.1	2047757	g10185	i0	55.2	0.975728155339806	67	30	97.6	0	206	6	167	233	MDB2614324.1 FAD-binding oxidoreductase [Chlamydiales bacterium]	diamond	201	84.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31276205	31276205	PRJNA416866_P_NODE_7075_length_244_cov_1.398907_g6931_i0	PRJNA416866	7075	244	1.398907	3.41333308	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42	0.0455	NR	MFM8642726.1	2052180	g6931	i0	45.2	1.0327868852459	42	23	51.6	0	126	1	78	119	MFM8642726.1 hypothetical protein [Phycisphaerales bacterium]	diamond	252	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31339463	31339463	PRJNA416866_P_NODE_10896_length_204_cov_0.895105_g10752_i0	PRJNA416866	10896	204	0.895105	1.8260142	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0399	NR	MFM8415446.1	2026780	g10752	i0	43.1	0.75	51	23	70.6	2	157	14	185	232	MFM8415446.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31529471	31529471	PRJNA416866_P_NODE_3736_length_344_cov_0.897527_g3593_i0	PRJNA416866	3736	344	0.897527	3.08749288	Chlamydiales bacterium	2047757	Bacteria	Bacteria	78.2	1.96e-14	NR	MDB2614324.1	2047757	g3593	i0	43.8	0.697674418604651	80	45	69.8	0	336	97	188	267	MDB2614324.1 FAD-binding oxidoreductase [Chlamydiales bacterium]	diamond	240	78.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31655664	31655664	PRJNA416866_P_NODE_9897_length_208_cov_0.870748_g9753_i0	PRJNA416866	9897	208	0.870748	1.81115584	Opitutales bacterium	2026772	Bacteria	Bacteria	91.7	1.02e-20	NR	MBN2068425.1	2026772	g9753	i0	62.1	0.951923076923077	66	25	95.2	0	5	202	131	196	MBN2068425.1 hypothetical protein [Opitutales bacterium]	diamond	198	91.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
31782188	31782188	PRJNA416866_P_NODE_5717_length_273_cov_2.971698_g5573_i0	PRJNA416866	5717	273	2.971698	8.11273554	Akkermansia muciniphila	239935	Bacteria	Bacteria	82	6.19e-18	NR	WP_102713290.1	239935	g5573	i0	53.6	2.96703296703297	69	32	75.8	0	209	3	2	70	WP_102713290.1 RNA recognition motif domain-containing protein [Akkermansia muciniphila]	diamond	810	82	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
31877080	31877080	PRJNA416866_P_NODE_11097_length_203_cov_1.802817_g10953_i0	PRJNA416866	11097	203	1.802817	3.65971851	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	101	5.2599999999999997e-23	NR	RYD77759.1	2026800	g10953	i0	77.6	0.990147783251232	67	15	99	0	1	201	478	544	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	201	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32098706	32098706	PRJNA416866_P_NODE_5458_length_280_cov_1.168950_g5314_i0	PRJNA416866	5458	280	1.16895	3.27306	Chlamydiia bacterium	2052156	Bacteria	Bacteria	43.5	0.0182	NR	MBI3900844.1	2052156	g5314	i0	33.3	0.739285714285714	69	46	73.9	0	240	34	18	86	MBI3900844.1 hypothetical protein [Chlamydiia bacterium]	diamond	207	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
32257301	32257301	PRJNA416866_P_NODE_7058_length_244_cov_1.890710_g6914_i0	PRJNA416866	7058	244	1.89071	4.6133324	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	146	5.07e-43	NR	RYD73503.1	2026800	g6914	i0	84	1.99180327868852	81	13	99.6	0	243	1	1	81	RYD73503.1 MAG: fructose-bisphosphate aldolase class I, partial [Verrucomicrobiaceae bacterium]	diamond	486	146	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32541967	32541967	PRJNA416866_P_NODE_8979_length_214_cov_2.091503_g8835_i0	PRJNA416866	8979	214	2.091503	4.47581642	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	49.7	6.15e-6	NR	MCP4254449.1	2268189	g8835	i0	82.1	0.785046728971963	28	5	39.3	0	1	84	28	55	MCP4254449.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	168	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
32747302	32747302	PRJNA416866_P_NODE_11840_length_201_cov_0.914286_g11696_i0	PRJNA416866	11840	201	0.914286	1.83771486	Bacteria	2	Bacteria	Bacteria	43.5	0.00763	NR	MAE66251.1	2026777	g11696	i0	51.7	1.73134328358209	29	14	43.3	0	2	88	53	81	MAE66251.1 cytidine deaminase [Phycisphaeraceae bacterium]	diamond	348	43.9	0.990888382687927	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
32856636	32856636	PRJNA416866_P_NODE_4820_length_299_cov_1.613445_g4676_i0	PRJNA416866	4820	299	1.613445	4.82420055	Parachlamydia sp.	2052048	Bacteria	Bacteria	64.3	1.85e-9	NR	MCE5316308.1	2052048	g4676	i0	38.9	0.903010033444816	90	55	90.3	0	5	274	469	558	MCE5316308.1 ankyrin repeat domain-containing protein [Parachlamydia sp.]	diamond	270	64.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia 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);;