metadata: contig_metadata: 29 rows where bioproject = "PRJNA826497" and tax

29 rows where bioproject = "PRJNA826497" 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
4648987	4648987	PRJNA826497_S_NODE_12724_length_174_cov_3.340426_g12684_i0	PRJNA826497	12724	174	3.340426	5.81234124	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	152	1.4e-32	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12684	i0	89.831	17.4080459770115	118	12	68	0	57	174	7051489	7051606	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	3029	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
12299822	12299822	PRJNA826497_S_NODE_15090_length_165_cov_1.924242_g15050_i0	PRJNA826497	15090	165	1.924242	3.1749993	Humisphaera borealis	2807512	Bacteria	Bacteria	71.3	3.81e-8	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g15050	i0	97.561	1.12727272727273	41	1	25	0	3	43	5064068	5064108	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	186	71.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24179850	24179850	PRJNA826497_S_NODE_12279_length_176_cov_2.993007_g12239_i0	PRJNA826497	12279	176	2.993007	5.26769232	Planctomycetota	203682	Bacteria	Bacteria	89.8	1.13e-13	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g12239	i0	82.692	33.3920454545455	104	15	59	2	4	106	1658	1557	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	5877	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
25046946	25046946	PRJNA826497_S_NODE_17060_length_158_cov_10.176000_g17020_i0	PRJNA826497	17060	158	10.176	16.07808	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	63.9	6.03e-6	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g17020	i0	95.122	0.259493670886076	41	1	26	1	106	146	910986	910947	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
26642804	26642804	PRJNA826497_S_NODE_13201_length_172_cov_3.661871_g13161_i0	PRJNA826497	13201	172	3.661871	6.29841812	Chlamydiota bacterium	2081524	Bacteria	Bacteria	67.8	1.27e-11	NR	MEI8300531.1	2081524	g13161	i0	57.4	2.82558139534884	54	23	94.2	0	7	168	195	248	MEI8300531.1 hypothetical protein [Chlamydiota bacterium]	diamond	486	67.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
26927912	26927912	PRJNA826497_S_NODE_11842_length_178_cov_2.765517_g11802_i0	PRJNA826497	11842	178	2.765517	4.92262026	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	53.9	1.8e-6	NR	HVT27655.1	2691534	g11802	i0	52	0.842696629213483	50	23	84.3	1	151	2	364	412	HVT27655.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	150	53.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
27054542	27054542	PRJNA826497_S_NODE_4222_length_237_cov_5.612745_g4182_i0	PRJNA826497	4222	237	5.612745	13.30220565	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	144	4.96e-39	NR	MBX7065911.1	2052178	g4182	i0	90.1	4.49367088607595	71	7	89.9	0	224	12	360	430	MBX7065911.1 hemolysin family protein [Parachlamydiales bacterium]	diamond	1065	144	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
27442640	27442640	PRJNA826497_S_NODE_8583_length_196_cov_2.116564_g8543_i0	PRJNA826497	8583	196	2.116564	4.14846544	Bacteria	2	Bacteria	Bacteria	87	1.66e-18	NR	OGN64859.1	1797605	g8543	i0	59.4	1.95918367346939	64	26	98	0	194	3	246	309	OGN64859.1 MAG: methionyl-tRNA formyltransferase [Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9]	diamond	384	87.4	0.995423340961098	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_12_FULL_49_9
27939005	27939005	PRJNA826497_S_NODE_9605_length_189_cov_9.012821_g9565_i0	PRJNA826497	9605	189	9.012821	17.03423169	Maioricimonas sp. JB049	3342842	Bacteria	Bacteria	49.7	6.22e-5	NR	MFG0334810.1	3342842	g9565	i0	72.2	1.0952380952381	36	10	57.1	0	188	81	239	274	MFG0334810.1 Ty1/Copia family ribonuclease HI [Maioricimonas sp. JB049]	diamond	207	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas sp. JB049
28452876	28452876	PRJNA826497_S_NODE_12346_length_176_cov_1.293706_g12306_i0	PRJNA826497	12346	176	1.293706	2.27692256	root	1	Root_unresolved	Root_unresolved	57.4	1.03e-7	NR	MCA9408411.1	2035772	g12306	i0	48.4	6.15340909090909	62	27	97.2	1	1	171	394	455	MCA9408411.1 thioredoxin family protein [Candidatus Omnitrophota bacterium]	diamond	1083	57.8	0.993079584775087	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28665205	28665205	PRJNA826497_S_NODE_16567_length_160_cov_2.582677_g16527_i0	PRJNA826497	16567	160	2.582677	4.1322832	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	72.4	4.14e-15	NR	HVT27668.1	2691534	g16527	i0	77.1	0.9	48	10	90	1	17	160	1	47	HVT27668.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	144	72.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
29801657	29801657	PRJNA826497_S_NODE_12091_length_177_cov_2.034722_g12051_i0	PRJNA826497	12091	177	2.034722	3.60145794	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	106	3.44e-25	NR	MBI3307219.1	2035772	g12051	i0	87.7	0.966101694915254	57	7	96.6	0	175	5	240	296	MBI3307219.1 B12-binding domain-containing radical SAM protein [Candidatus Omnitrophota bacterium]	diamond	171	106	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
29801666	29801666	PRJNA826497_S_NODE_6891_length_208_cov_5.440000_g6851_i0	PRJNA826497	6891	208	5.44	11.3152	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	92.4	6.2e-20	NR	MBP7074583.1	2047756	g6851	i0	69.1	0.980769230769231	68	21	98.1	0	206	3	224	291	MBP7074583.1 efflux transporter outer membrane subunit [Rhabdochlamydiaceae bacterium]	diamond	204	92.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30023057	30023057	PRJNA826497_S_NODE_12571_length_175_cov_1.669014_g12531_i0	PRJNA826497	12571	175	1.669014	2.9207745	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	48.1	1.78e-4	NR	HEX4840242.1	2047756	g12531	i0	42.9	0.84	49	28	84	0	174	28	144	192	HEX4840242.1 MC/SLC25 family protein [Rhabdochlamydiaceae bacterium]	diamond	147	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
30094552	30094552	PRJNA826497_S_NODE_14592_length_166_cov_8.902256_g14552_i0	PRJNA826497	14592	166	8.902256	14.77774496	Bacteria	2	Bacteria	Bacteria	96.3	4.79e-22	NR	OGN55585.1	1797598	g14552	i0	76.4	3.97590361445783	55	13	99.4	0	165	1	87	141	OGN55585.1 MAG: hypothetical protein A2796_04455 [Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39]	diamond	660	97.1	0.991761071060762	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39
30117536	30117536	PRJNA826497_S_NODE_11792_length_178_cov_4.206897_g11752_i0	PRJNA826497	11792	178	4.206897	7.48827666	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84.7	1.59e-19	NR	MCB1087017.1	2499141	g11752	i0	64.8	1.80337078651685	54	19	91	0	2	163	55	108	MCB1087017.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	321	84.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30117543	30117543	PRJNA826497_S_NODE_9372_length_191_cov_2.708861_g9332_i0	PRJNA826497	9372	191	2.708861	5.17392451	Opitutus sp.	1913982	Bacteria	Bacteria	60.5	1.05e-8	NR	HVU25758.1	1913982	g9332	i0	54.2	0.926701570680628	59	26	92.7	1	191	15	525	582	HVU25758.1 hypothetical protein [Opitutus sp.]	diamond	177	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
30496930	30496930	PRJNA826497_S_NODE_11653_length_179_cov_2.212329_g11613_i0	PRJNA826497	11653	179	2.212329	3.96006891	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	91.7	9.18e-20	NR	HVT27657.1	2691534	g11613	i0	81	0.972067039106145	58	11	97.2	0	5	178	36	93	HVT27657.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	174	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30591547	30591547	PRJNA826497_S_NODE_14693_length_166_cov_3.669173_g14653_i0	PRJNA826497	14693	166	3.669173	6.09082718	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	57.8	6.32e-8	NR	HVT27655.1	2691534	g14653	i0	60	0.993975903614458	55	21	97.6	1	164	3	419	473	HVT27655.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	165	57.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
30844453	30844453	PRJNA826497_S_NODE_8954_length_193_cov_7.925000_g8914_i0	PRJNA826497	8954	193	7.925	15.29525	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	40.4	0.0489	NR	HEY2342399.1	2811408	g8914	i0	51.6	0.481865284974093	31	15	48.2	0	189	97	41	71	HEY2342399.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	93	40.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
31263833	31263833	PRJNA826497_S_NODE_17915_length_156_cov_2.617886_g17875_i0	PRJNA826497	17915	156	2.617886	4.08390216	Pseudomonadati	3379134	Bacteria	Bacteria	85.1	4.12e-18	NR	OGW97560.1	1801839	g17875	i0	74	1.92307692307692	50	13	96.2	0	4	153	44	93	OGW97560.1 MAG: hypothetical protein A2Z81_09725 [Omnitrophica WOR_2 bacterium GWA2_45_18]	diamond	300	85.1	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Omnitrophica WOR_2 bacterium GWA2_45_18
31286638	31286638	PRJNA826497_S_NODE_13035_length_173_cov_1.835714_g12995_i0	PRJNA826497	13035	173	1.835714	3.17578522	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	42	0.00401	NR	HVT27675.1	2691534	g12995	i0	42	0.867052023121387	50	27	83.2	1	172	29	19	68	HVT27675.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	150	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
31381801	31381801	PRJNA826497_S_NODE_1296_length_317_cov_5.123239_g1256_i0	PRJNA826497	1296	317	5.123239	16.24066763	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	95.1	3.62e-20	NR	HVT27660.1	2691534	g1256	i0	82.4	0.482649842271293	51	9	48.3	0	154	2	1	51	HVT27660.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	153	95.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
31603182	31603182	PRJNA826497_S_NODE_4556_length_233_cov_3.190000_g4516_i0	PRJNA826497	4556	233	3.19	7.4327	Chlamydiia bacterium	2052156	Bacteria	Bacteria	57.4	2.18e-7	NR	MBI3508849.1	2052156	g4516	i0	43.4	0.978540772532189	76	40	94	1	1	219	118	193	MBI3508849.1 TIGR04372 family glycosyltransferase [Chlamydiia bacterium]	diamond	228	57.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
31856054	31856054	PRJNA826497_S_NODE_5877_length_217_cov_12.179348_g5837_i0	PRJNA826497	5877	217	12.179348	26.42918516	Chlamydia ibidis	1405396	Bacteria	Bacteria	42.7	0.00197	NR	EPP34933.1	1405396	g5837	i0	69.2	0.359447004608295	26	8	35.9	0	216	139	5	30	EPP34933.1 hypothetical protein CP10139811_1159, partial [Chlamydia ibidis]	diamond	78	42.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
31887684	31887684	PRJNA826497_S_NODE_277_length_487_cov_12.837004_g239_i0	PRJNA826497	277	487	12.837004	62.51620948	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	59.7	1.14e-7	NR	MCX5657803.1	2035772	g239	i0	36.2	0.579055441478439	94	58	57.9	1	199	480	21	112	MCX5657803.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	282	59.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32394087	32394087	PRJNA826497_S_NODE_1879_length_289_cov_4.539062_g1839_i0	PRJNA826497	1879	289	4.539062	13.11788918	Akkermansia sp.	1872421	Bacteria	Bacteria	53.5	1.03e-5	NR	MBR5876151.1	1872421	g1839	i0	50	0.685121107266436	66	28	63.3	2	284	102	1042	1107	MBR5876151.1 ankyrin repeat domain-containing protein [Akkermansia sp.]	diamond	198	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
32552508	32552508	PRJNA826497_S_NODE_17879_length_156_cov_3.243902_g17839_i0	PRJNA826497	17879	156	3.243902	5.06048712	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.1	0.0018	NR	HHI79518.1	2026780	g17839	i0	42.3	1	52	30	100	0	156	1	702	753	HHI79518.1 hypothetical protein [Planctomycetota bacterium]	diamond	156	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32646371	32646371	PRJNA826497_S_NODE_4860_length_229_cov_2.045918_g4820_i0	PRJNA826497	4860	229	2.045918	4.68515222	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	129	3.41e-35	NR	HVT27661.1	2691534	g4820	i0	82.7	0.982532751091703	75	13	98.3	0	227	3	18	92	HVT27661.1 hypothetical protein [Lacipirellulaceae bacterium]	diamond	225	129	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae 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);;