metadata: contig_metadata: 27 rows where bioproject = "PRJNA719595" and tax

27 rows where bioproject = "PRJNA719595" 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
5813063	5813063	PRJNA719595_P_NODE_7685_length_249_cov_0.886364_g7650_i0	PRJNA719595	7685	249	0.886364	2.20704636	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	126	8.94e-34	NR	HZJ15226.1	2811408	g7650	i0	79.3	0.987951807228916	82	17	98.8	0	247	2	123	204	HZJ15226.1 glutamate 5-kinase [Chthoniobacteraceae bacterium]	diamond	246	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
7088091	7088091	PRJNA719595_P_NODE_3346_length_340_cov_3.082397_g3311_i0	PRJNA719595	3346	340	3.082397	10.4801498	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	490	5.74e-134	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g3311	i0	93.598	165.064705882353	328	21	96	0	2	329	2582841	2582514	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	56122	490	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7088256	7088256	PRJNA719595_P_NODE_9086_length_243_cov_0.917647_g9051_i0	PRJNA719595	9086	243	0.917647	2.22988221	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	108	4.61e-19	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g9051	i0	91.139	0.325102880658436	79	7	33	0	43	121	4663750	4663672	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	79	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9637959	9637959	PRJNA719595_P_NODE_7048_length_251_cov_0.876404_g7013_i0	PRJNA719595	7048	251	0.876404	2.19977404	Humisphaera borealis	2807512	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g7013	i0	79.92	1.53386454183267	249	39	96	9	7	248	3783164	3783408	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	385	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
10121945	10121945	PRJNA719595_P_NODE_9308_length_242_cov_0.923077_g9273_i0	PRJNA719595	9308	242	0.923077	2.23384634	Bacteria	2	Bacteria	Bacteria	69.4	2.16e-7	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g9273	i0	100	395.54132231405	37	0	17	0	145	181	112989	112953	Ereboglobus luteus strain Ho45, complete genome	blastn	95721	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
13463245	13463245	PRJNA719595_P_NODE_9211_length_243_cov_0.917647_g9176_i0	PRJNA719595	9211	243	0.917647	2.22988221	Aquisphaera giovannonii	406548	Bacteria	Bacteria	261	3.34e-65	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g9176	i0	86.066	82.5390946502058	244	32	100	2	1	243	3440678	3440436	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	20057	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
16011995	16011995	PRJNA719595_P_NODE_6773_length_252_cov_0.871508_g6738_i0	PRJNA719595	6773	252	0.871508	2.19620016	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	228	3.5399999999999984e-55	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g6738	i0	83.004	1.00396825396825	253	41	100	2	1	252	3986251	3986000	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	253	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17287501	17287501	PRJNA719595_P_NODE_7574_length_249_cov_0.886364_g7539_i0	PRJNA719595	7574	249	0.886364	2.20704636	Phycisphaerae	666505	Bacteria	Bacteria	123	1.05e-31	NR	MDB5319606.1	2052180	g7539	i0	76.3	2.91566265060241	80	19	96.4	0	243	4	197	276	MDB5319606.1 Beta-hexosaminidase [Phycisphaerales bacterium]	diamond	726	124	0.991935483870968	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
18561309	18561309	PRJNA719595_P_NODE_6875_length_252_cov_0.871508_g6840_i0	PRJNA719595	6875	252	0.871508	2.19620016	Pirellulales bacterium	2715253	Bacteria	Bacteria	63.2	1.5e-10	NR	HEV3338919.1	2715253	g6840	i0	55.2	0.69047619047619	58	26	69	0	178	5	1	58	HEV3338919.1 hypothetical protein [Pirellulales bacterium]	diamond	174	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
23662492	23662492	PRJNA719595_P_NODE_6439_length_253_cov_0.866667_g6404_i0	PRJNA719595	6439	253	0.866667	2.19266751	Singulisphaera sp.	1906241	Bacteria	Bacteria	154	4.87e-43	NR	MEJ7639405.1	1906241	g6404	i0	97.6	0.984189723320158	83	2	98.4	0	3	251	118	200	MEJ7639405.1 serine/threonine-protein kinase [Singulisphaera sp.]	diamond	249	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp.
26894039	26894039	PRJNA719595_P_NODE_8621_length_245_cov_0.906977_g8586_i0	PRJNA719595	8621	245	0.906977	2.22209365	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	94	8.37e-21	NR	MDG2093943.1	2052180	g8586	i0	58.8	1.95918367346939	80	33	98	0	245	6	223	302	MDG2093943.1 ABC transporter ATP-binding protein [Phycisphaerales bacterium]	diamond	480	94	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27146403	27146403	PRJNA719595_P_NODE_9342_length_242_cov_0.923077_g9307_i0	PRJNA719595	9342	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	119	3.84e-30	NR	HKI31433.1	2052164	g9307	i0	67.1	1.95867768595041	79	26	97.9	0	238	2	59	137	HKI31433.1 glycosyltransferase family 4 protein [Gemmataceae bacterium]	diamond	474	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27273325	27273325	PRJNA719595_P_NODE_6423_length_253_cov_0.866667_g6388_i0	PRJNA719595	6423	253	0.866667	2.19266751	Humisphaera borealis	2807512	Bacteria	Bacteria	117	2.36e-28	NR	WP_206293489.1	2807512	g6388	i0	73.8	0.948616600790514	80	21	94.9	0	253	14	636	715	WP_206293489.1 S8 family serine peptidase [Humisphaera borealis]	diamond	240	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
27904640	27904640	PRJNA719595_P_NODE_9245_length_243_cov_0.882353_g9210_i0	PRJNA719595	9245	243	0.882353	2.14411779	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	101	5.830000000000001e-26	NR	MFO0888213.1	2691532	g9210	i0	82.3	0.765432098765432	62	11	76.5	0	2	187	16	77	MFO0888213.1 helix-turn-helix transcriptional regulator [Isosphaeraceae bacterium]	diamond	186	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
27999826	27999826	PRJNA719595_P_NODE_8225_length_247_cov_0.896552_g8190_i0	PRJNA719595	8225	247	0.896552	2.21448344	Pirellulales bacterium	2715253	Bacteria	Bacteria	51.2	3.87e-5	NR	MCC6494168.1	2715253	g8190	i0	53.7	0.497975708502024	41	19	49.8	0	239	117	349	389	MCC6494168.1 FG-GAP repeat protein [Pirellulales bacterium]	diamond	123	51.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
28062679	28062679	PRJNA719595_P_NODE_7645_length_249_cov_0.886364_g7610_i0	PRJNA719595	7645	249	0.886364	2.20704636	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	64.3	5.73e-11	NR	HSU66604.1	2876886	g7610	i0	60.9	3.19277108433735	64	25	77.1	0	53	244	11	74	HSU66604.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	795	64.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
28599686	28599686	PRJNA719595_P_NODE_7927_length_248_cov_0.891429_g7892_i0	PRJNA719595	7927	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	170	2.35e-50	NR	MEE2642961.1	2026780	g7892	i0	100	0.991935483870968	82	0	99.2	0	246	1	153	234	MEE2642961.1 ABC transporter permease subunit [Planctomycetota bacterium]	diamond	246	170	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28851913	28851913	PRJNA719595_P_NODE_8188_length_247_cov_0.896552_g8153_i0	PRJNA719595	8188	247	0.896552	2.21448344	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	47.4	8.72e-4	NR	MFO0951831.1	2691532	g8153	i0	72.4	0.704453441295547	29	7	34	1	114	31	263	291	MFO0951831.1 pyruvate dehydrogenase complex E1 component subunit beta [Isosphaeraceae bacterium]	diamond	174	47.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
28914966	28914966	PRJNA719595_P_NODE_6428_length_253_cov_0.866667_g6393_i0	PRJNA719595	6428	253	0.866667	2.19266751	uncultured Chthoniobacterales bacterium	1836801	Bacteria	Bacteria	136	1.7799999999999998e-37	NR	CAA9226802.1	1836801	g6393	i0	88	0.889328063241107	75	9	88.9	0	27	251	3	77	CAA9226802.1 MAG: hypothetical protein AVDCRST_MAG42-897 [uncultured Chthoniobacterales bacterium]	diamond	225	136	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			uncultured Chthoniobacterales bacterium
29199611	29199611	PRJNA719595_P_NODE_8949_length_244_cov_0.912281_g8914_i0	PRJNA719595	8949	244	0.912281	2.22596564	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	75.9	7.66e-14	NR	HWB06935.1	2026801	g8914	i0	51.9	0.971311475409836	79	38	97.1	0	242	6	347	425	HWB06935.1 DUF3987 domain-containing protein [Verrucomicrobiales bacterium]	diamond	237	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29325602	29325602	PRJNA719595_P_NODE_8409_length_246_cov_0.901734_g8374_i0	PRJNA719595	8409	246	0.901734	2.21826564	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	157	1.59e-44	NR	HCQ84632.1	2026801	g8374	i0	98.8	2	82	1	100	0	1	246	192	273	HCQ84632.1 DNA modification methylase [Verrucomicrobiales bacterium]	diamond	492	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29672703	29672703	PRJNA719595_P_NODE_7370_length_250_cov_0.881356_g7335_i0	PRJNA719595	7370	250	0.881356	2.20339	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	134	1.2499999999999999e-34	NR	MDB5322919.1	2052180	g7335	i0	75.9	3.912	83	16	99.6	1	1	249	322	400	MDB5322919.1 S-methyl-5-thioadenosine phosphorylase [Phycisphaerales bacterium]	diamond	978	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30273511	30273511	PRJNA719595_P_NODE_8852_length_244_cov_0.912281_g8817_i0	PRJNA719595	8852	244	0.912281	2.22596564	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	110	7.62e-26	NR	MCH2160789.1	2052180	g8817	i0	67.9	0.995901639344262	81	26	99.6	0	1	243	196	276	MCH2160789.1 tetratricopeptide repeat protein [Phycisphaerales bacterium]	diamond	243	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30525913	30525913	PRJNA719595_P_NODE_8953_length_244_cov_0.912281_g8918_i0	PRJNA719595	8953	244	0.912281	2.22596564	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	88.2	3.4e-18	NR	HSH39841.1	2201154	g8918	i0	76.7	0.737704918032787	60	14	73.8	0	64	243	1	60	HSH39841.1 NADH-quinone oxidoreductase subunit M [Chthoniobacterales bacterium]	diamond	180	88.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32233662	32233662	PRJNA719595_P_NODE_8238_length_247_cov_0.896552_g8203_i0	PRJNA719595	8238	247	0.896552	2.21448344	Pirellulales bacterium	2715253	Bacteria	Bacteria	97.4	2.14e-21	NR	HEX4149505.1	2715253	g8203	i0	59.8	0.995951417004049	82	32	98.4	1	3	245	67	148	HEX4149505.1 phosphoenolpyruvate--protein phosphotransferase [Pirellulales bacterium]	diamond	246	97.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32518407	32518407	PRJNA719595_P_NODE_9219_length_243_cov_0.917647_g9184_i0	PRJNA719595	9219	243	0.917647	2.22988221	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	144	2.939999999999999e-38	NR	HEX8678412.1	2201154	g9184	i0	93.8	0.987654320987654	80	5	98.8	0	2	241	399	478	HEX8678412.1 FlgO family outer membrane protein [Chthoniobacterales bacterium]	diamond	240	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32528842	32528842	PRJNA719595_P_NODE_4879_length_289_cov_1.129630_g4844_i0	PRJNA719595	4879	289	1.12963	3.2646307	Bacteria	2	Bacteria	Bacteria	47.4	5.22e-4	NR	MDR1190431.1	2026801	g4844	i0	33.8	2.58477508650519	71	42	68.5	1	2	199	68	138	MDR1190431.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	747	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales 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);;