metadata: contig_metadata: 31 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax

31 rows where analysis = "diamond", bioproject = "PRJNA917598" 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_species
12731160	12731160	PRJNA917598_P_NODE_88290_length_246_cov_0.890173_g87346_i0	PRJNA917598	88290	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	150	4.09e-41	NR	MBL6922653.1	2562705	g87346	i0	85.2	7.90243902439024	81	12	98.8	0	2	244	42	122	MBL6922653.1 adenosylhomocysteinase [Akkermansiaceae bacterium]	diamond	1944	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansiaceae bacterium
16199742	16199742	PRJNA917598_P_NODE_74213_length_263_cov_1.357895_g73269_i0	PRJNA917598	74213	263	1.357895	3.57126385	Planctomycetota bacterium	2026780	Bacteria	Bacteria	119	1.39e-30	NR	MFO0945694.1	2026780	g73269	i0	70.1	2.95437262357414	87	19	99.2	1	261	1	177	256	MFO0945694.1 methylisocitrate lyase [Planctomycetota bacterium]	diamond	777	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
20023889	20023889	PRJNA917598_P_NODE_92396_length_243_cov_0.905882_g91452_i0	PRJNA917598	92396	243	0.905882	2.20129326	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	115	1.02e-29	NR	MBC7771797.1	2052180	g91452	i0	73.8	0.987654320987654	80	21	98.8	0	3	242	59	138	MBC7771797.1 hypothetical protein [Phycisphaerales bacterium]	diamond	240	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
26866655	26866655	PRJNA917598_P_NODE_68501_length_275_cov_1.420792_g67557_i0	PRJNA917598	68501	275	1.420792	3.907178	Pirellulales bacterium	2715253	Bacteria	Bacteria	45.8	7.78e-4	NR	HEX4130268.1	2715253	g67557	i0	46.7	0.490909090909091	45	18	42.5	1	250	134	33	77	HEX4130268.1 hypothetical protein [Pirellulales bacterium]	diamond	135	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales		Pirellulales bacterium
26866669	26866669	PRJNA917598_P_NODE_82881_length_249_cov_0.875000_g81937_i0	PRJNA917598	82881	249	0.875	2.17875	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.6	1.12e-7	NR	PYJ10251.1	2026799	g81937	i0	38.2	1.89156626506024	76	47	91.6	0	17	244	56	131	PYJ10251.1 MAG: hypothetical protein DMF06_07005 [Verrucomicrobiota bacterium]	diamond	471	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
26968566	26968566	PRJNA917598_P_NODE_83102_length_249_cov_0.875000_g82158_i0	PRJNA917598	83102	249	0.875	2.17875	PVC group	1783257	Bacteria	Bacteria	97.1	3.17e-21	NR	HMN42288.1	2052180	g82158	i0	49.4	2.92771084337349	81	41	97.6	0	2	244	1372	1452	HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium]	diamond	729	97.4	0.996919917864476	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
27031827	27031827	PRJNA917598_P_NODE_59782_length_292_cov_1.050228_g58838_i0	PRJNA917598	59782	292	1.050228	3.06666576	Bacteria	2	Bacteria	Bacteria	147	1.15e-38	NR	MEO6034374.1	2026799	g58838	i0	67.7	4.86986301369863	96	31	98.6	0	3	290	795	890	MEO6034374.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1422	148	0.993243243243243	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
27372663	27372663	PRJNA917598_P_NODE_90043_length_245_cov_0.895349_g89099_i0	PRJNA917598	90043	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	66.6	1.35e-10	NR	MFO0845157.1	2052164	g89099	i0	43.8	1.95918367346939	80	39	98	2	2	241	188	261	MFO0845157.1 Ig-like domain-containing protein [Gemmataceae bacterium]	diamond	480	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
27467190	27467190	PRJNA917598_P_NODE_95163_length_241_cov_0.916667_g94219_i0	PRJNA917598	95163	241	0.916667	2.20916747	Gemmataceae bacterium	2052164	Bacteria	Bacteria	115	4e-29	NR	MFO0849139.1	2052164	g94219	i0	71.6	1.00829875518672	81	22	99.6	1	240	1	9	89	MFO0849139.1 DUF1573 domain-containing protein [Gemmataceae bacterium]	diamond	243	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
27593539	27593539	PRJNA917598_P_NODE_80084_length_251_cov_0.865169_g79140_i0	PRJNA917598	80084	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0172	NR	MDA0667963.1	2026780	g79140	i0	41.3	0.752988047808765	63	35	75.3	2	44	232	124	184	MDA0667963.1 hypothetical protein [Planctomycetota bacterium]	diamond	189	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
27782968	27782968	PRJNA917598_P_NODE_7844_length_858_cov_2.873885_g7022_i0	PRJNA917598	7844	858	2.873885	24.6579333	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	96.7	1.23e-19	NR	MBU4343239.1	2035772	g7022	i0	28.3	3.53496503496504	244	130	79.7	9	123	806	14	228	MBU4343239.1 autotransporter outer membrane beta-barrel domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	3033	96.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
27877476	27877476	PRJNA917598_P_NODE_48005_length_331_cov_1.193798_g47061_i0	PRJNA917598	48005	331	1.193798	3.95147138	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	209	2.78e-61	NR	MDR2757484.1	2026779	g47061	i0	94.5	2.99093655589124	110	6	99.7	0	1	330	439	548	MDR2757484.1 Z1 domain-containing protein [Planctomycetaceae bacterium]	diamond	990	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
28098447	28098447	PRJNA917598_P_NODE_60825_length_289_cov_2.004630_g59881_i0	PRJNA917598	60825	289	2.00463	5.7933807	Planctomycetota bacterium	2026780	Bacteria	Bacteria	44.3	0.0187	NR	RMG10585.1	2026780	g59881	i0	35.3	0.882352941176471	85	55	88.2	0	267	13	105	189	RMG10585.1 MAG: FHA domain-containing protein [Planctomycetota bacterium]	diamond	255	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
28445988	28445988	PRJNA917598_P_NODE_66346_length_279_cov_1.446602_g65402_i0	PRJNA917598	66346	279	1.446602	4.03601958	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	139	5.72e-36	NR	MAJ47049.1	2026779	g65402	i0	78.3	0.989247311827957	92	20	98.9	0	278	3	138	229	MAJ47049.1 isocitrate dehydrogenase (NADP(+)) [Planctomycetaceae bacterium]	diamond	276	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
28642738	28642738	PRJNA917598_P_NODE_72387_length_267_cov_1.314433_g71443_i0	PRJNA917598	72387	267	1.314433	3.50953611	Pseudomonadati	3379134	Bacteria	Bacteria	42.7	0.0461	NR	HLP84092.1	2052180	g71443	i0	76	0.629213483146067	25	6	28.1	0	166	92	11	35	HLP84092.1 PA2169 family four-helix-bundle protein [Phycisphaerales bacterium]	diamond	168	43.1	0.990719257540603	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
28856166	28856166	PRJNA917598_P_NODE_84788_length_248_cov_0.880000_g83844_i0	PRJNA917598	84788	248	0.88	2.1824	Pirellulales bacterium	2715253	Bacteria	Bacteria	66.6	8.94e-11	NR	MBN2580801.1	2715253	g83844	i0	42	3.82258064516129	81	47	98	0	243	1	77	157	MBN2580801.1 prephenate dehydrogenase [Pirellulales bacterium]	diamond	948	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales		Pirellulales bacterium
29045885	29045885	PRJNA917598_P_NODE_93168_length_243_cov_0.905882_g92224_i0	PRJNA917598	93168	243	0.905882	2.20129326	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	139	5.3e-36	NR	MCO6457054.1	2699754	g92224	i0	81.7	8.91358024691358	82	13	98.8	1	3	242	706	787	MCO6457054.1 site-specific DNA-methyltransferase [Pirellulaceae bacterium]	diamond	2166	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellulaceae bacterium
29424439	29424439	PRJNA917598_P_NODE_3229_length_1391_cov_1.602428_g2682_i0	PRJNA917598	3229	1391	1.602428	22.28977348	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	114	1.08e-22	NR	MCX6897038.1	2026799	g2682	i0	34.5	0.474478792235802	220	124	43.8	5	1390	782	500	716	MCX6897038.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	660	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
29495084	29495084	PRJNA917598_P_NODE_84650_length_248_cov_0.880000_g83706_i0	PRJNA917598	84650	248	0.88	2.1824	Gimesia	1649453	Bacteria	Bacteria	53.5	3.37e-6	NR	HAW28021.1	2026779	g83706	i0	47.4	3.3508064516129	57	29	67.7	1	247	80	145	201	HAW28021.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	831	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
29582198	29582198	PRJNA917598_P_NODE_95590_length_241_cov_0.916667_g94646_i0	PRJNA917598	95590	241	0.916667	2.20916747	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0251	NR	MDX2114362.1	2026780	g94646	i0	45.9	0.460580912863071	37	20	46.1	0	49	159	13	49	MDX2114362.1 hypothetical protein [Planctomycetota bacterium]	diamond	111	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
30435627	30435627	PRJNA917598_P_NODE_23713_length_476_cov_0.888337_g22771_i0	PRJNA917598	23713	476	0.888337	4.22848412	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	82	6.59e-17	NR	MDO8302513.1	2813034	g22771	i0	48.9	0.554621848739496	88	38	51.1	1	3	245	9	96	MDO8302513.1 hypothetical protein [Sedimentisphaerales bacterium]	diamond	264	82	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales		Sedimentisphaerales bacterium
30435644	30435644	PRJNA917598_P_NODE_49553_length_326_cov_0.913043_g48609_i0	PRJNA917598	49553	326	0.913043	2.97652018	Planctomycetota bacterium	2026780	Bacteria	Bacteria	50.8	1.38e-4	NR	MDA0839622.1	2026780	g48609	i0	32.7	0.901840490797546	98	64	88.3	2	1	288	432	529	MDA0839622.1 heparinase II/III family protein [Planctomycetota bacterium]	diamond	294	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
30498603	30498603	PRJNA917598_P_NODE_55733_length_305_cov_1.112069_g54789_i0	PRJNA917598	55733	305	1.112069	3.39181045	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	137	9.38e-38	NR	HEX3355465.1	2876886	g54789	i0	62.4	0.99344262295082	101	38	99.3	0	1	303	114	214	HEX3355465.1 potassium channel family protein [Tepidisphaeraceae bacterium]	diamond	303	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Tepidisphaeraceae bacterium
30593255	30593255	PRJNA917598_P_NODE_48993_length_328_cov_0.780392_g48049_i0	PRJNA917598	48993	328	0.780392	2.55968576	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	169	2.71e-52	NR	MCG3176942.1	2035772	g48049	i0	96.5	0.786585365853659	86	3	78.7	0	327	70	12	97	MCG3176942.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	258	169	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota				Candidatus Omnitrophota bacterium
30624870	30624870	PRJNA917598_P_NODE_95273_length_241_cov_0.916667_g94329_i0	PRJNA917598	95273	241	0.916667	2.20916747	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	51.2	3.61e-5	NR	MBC7772181.1	2052180	g94329	i0	69	0.360995850622407	29	9	36.1	0	2	88	314	342	MBC7772181.1 ligase-associated DNA damage response exonuclease [Phycisphaerales bacterium]	diamond	87	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales		Phycisphaerales bacterium
30687995	30687995	PRJNA917598_P_NODE_3573_length_1318_cov_2.285141_g3000_i0	PRJNA917598	3573	1318	2.285141	30.11815838	Planctomycetes bacterium B3_Pla	2012488	Bacteria	Bacteria	297	1.67e-93	NR	TKJ32797.1	2012488	g3000	i0	42.3	0.871775417298938	383	208	85.8	4	1237	107	3	378	TKJ32797.1 MAG: hypothetical protein CEE38_22190 [Planctomycetes bacterium B3_Pla]	diamond	1149	297	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetes bacterium B3_Pla
30719692	30719692	PRJNA917598_P_NODE_76014_length_259_cov_1.241935_g75070_i0	PRJNA917598	76014	259	1.241935	3.21661165	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	53.1	3.41e-6	NR	HEY3931881.1	2499141	g75070	i0	28.6	2.93050193050193	84	60	97.3	0	6	257	11	94	HEY3931881.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	759	53.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia			Verrucomicrobiia bacterium
31864971	31864971	PRJNA917598_P_NODE_77057_length_256_cov_2.103825_g76113_i0	PRJNA917598	77057	256	2.103825	5.385792	Bacteria	2	Bacteria	Bacteria	177	6.41e-53	NR	MCB9876769.1	2026780	g76113	i0	97.6	187.265625	85	2	99.6	0	256	2	138	222	MCB9876769.1 SDR family oxidoreductase [Planctomycetota bacterium]	diamond	47940	178	0.99438202247191	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31896773	31896773	PRJNA917598_P_NODE_86297_length_247_cov_0.885057_g85353_i0	PRJNA917598	86297	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	3.06e-6	NR	MCX6894423.1	2026799	g85353	i0	43.1	1.36032388663968	58	30	66.8	1	246	82	16	73	MCX6894423.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	336	54.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Verrucomicrobiota bacterium
32205984	32205984	PRJNA917598_P_NODE_61458_length_288_cov_1.432558_g60514_i0	PRJNA917598	61458	288	1.432558	4.12576704	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	78.6	2.01e-15	NR	MDB5336266.1	2026779	g60514	i0	94.4	0.5625	54	3	56.3	0	286	125	65	118	MDB5336266.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	162	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomycetaceae bacterium
32648132	32648132	PRJNA917598_P_NODE_30060_length_420_cov_1.109510_g29116_i0	PRJNA917598	30060	420	1.10951	4.659942	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	52	1.14e-4	NR	MBN2064340.1	2813034	g29116	i0	35.5	2.87142857142857	76	47	52.9	1	232	11	107	182	MBN2064340.1 serine/threonine protein kinase [Sedimentisphaerales bacterium]	diamond	1206	52	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales		Sedimentisphaerales 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);;