metadata: contig_metadata: 24 rows where bioproject = "PRJNA630877", tax_clade = "PVC group" and tax

24 rows where bioproject = "PRJNA630877", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
2427005	2427005	PRJNA630877_S_NODE_88042_length_262_cov_1.429864_g68905_i0	PRJNA630877	88042	262	1.429864	3.74624368	Bremerella	2714594	Bacteria	Bacteria	60.2	1.43e-4	NTclustered	gi\|1712647354\|gb\|CP036289.1\|	2527984	g68905	i0	97.143	0.267175572519084	35	1	13	0	172	206	2032779	2032745	Bremerella volcania strain Pan97 chromosome, complete genome	blastn	70	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella volcania
8256278	8256278	PRJNA630877_S_NODE_64327_length_397_cov_2.176966_g45195_i0	PRJNA630877	64327	397	2.176966	8.64255502	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	381	4.269999999999999e-101	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g45195	i0	91.429	85.3098236775819	280	20	70	4	1	277	2002730	2003008	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	33868	381	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10080216	10080216	PRJNA630877_S_NODE_67948_length_367_cov_2.230061_g48811_i0	PRJNA630877	67948	367	2.230061	8.18432387	Limnoglobus	2731450	Bacteria	Bacteria	446	1.3699999999999999e-120	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g48811	i0	89.167	186.264305177112	360	36	98	3	1	358	2002291	2002649	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	68359	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10807301	10807301	PRJNA630877_S_NODE_142649_length_164_cov_2.861789_g123512_i0	PRJNA630877	142649	164	2.861789	4.69333396	Urbifossiella limnaea	2528023	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g123512	i0	93.902	164.69512195122	164	10	100	0	1	164	2019281	2019118	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	27010	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13905674	13905674	PRJNA630877_S_NODE_107291_length_211_cov_2.505882_g88154_i0	PRJNA630877	107291	211	2.505882	5.28741102	Limnoglobus	2731450	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g88154	i0	93.365	211.047393364929	211	14	100	0	1	211	3456689	3456479	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	44531	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
17729609	17729609	PRJNA630877_S_NODE_141854_length_165_cov_1.774194_g122717_i0	PRJNA630877	141854	165	1.774194	2.9274201	Gemmataceae	1914233	Bacteria	Bacteria	263	5.86e-66	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g122717	i0	97.403	113.866666666667	154	4	93	0	1	154	1837	1990	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	18788	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21005527	21005527	PRJNA630877_S_NODE_84237_length_276_cov_1.680851_g65100_i0	PRJNA630877	84237	276	1.680851	4.63914876	Urbifossiella limnaea	2528023	Bacteria	Bacteria	342	1.3399999999999999e-89	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g65100	i0	88.968	60.5978260869565	281	26	100	3	1	276	2020028	2020308	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	16725	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21553691	21553691	PRJNA630877_S_NODE_140857_length_166_cov_1.680000_g121720_i0	PRJNA630877	140857	166	1.68	2.7888	Gemmata	113	Bacteria	Bacteria	305	9.67e-79	NTclustered	gi\|307591227\|gb\|GQ889438.1\|	886811	g121720	i0	100	98.3975903614458	165	0	99	0	2	166	583	747	Gemmata sp. Io3-3 16S ribosomal RNA gene, partial sequence	blastn	16334	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. Io3-3
22280230	22280230	PRJNA630877_S_NODE_148558_length_159_cov_1.864407_g129421_i0	PRJNA630877	148558	159	1.864407	2.96440713	Gemmataceae bacterium	2052164	Bacteria	Bacteria	122	9.889999999999999e-24	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g129421	i0	80.864	51.3207547169811	162	25	100	6	1	159	320222	320380	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	8160	122	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22829183	22829183	PRJNA630877_S_NODE_124398_length_184_cov_1.846154_g105261_i0	PRJNA630877	124398	184	1.846154	3.39692336	Limnoglobus	2731450	Bacteria	Bacteria	207	3.16e-49	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g105261	i0	87.097	139.652173913043	186	20	100	3	1	184	2002300	2002117	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	25696	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
26891274	26891274	PRJNA630877_S_NODE_122841_length_186_cov_2.027586_g103704_i0	PRJNA630877	122841	186	2.027586	3.77130996	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.025	NR	MEM7164993.1	2026780	g103704	i0	45.7	0.741935483870968	46	23	71	1	28	159	52	97	MEM7164993.1 hypothetical protein [Planctomycetota bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
26954109	26954109	PRJNA630877_S_NODE_126162_length_182_cov_1.510638_g107025_i0	PRJNA630877	126162	182	1.510638	2.74936116	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.7	0.0163	NR	MEI7702286.1	2052181	g107025	i0	48.8	0.675824175824176	41	20	65.9	1	128	9	54	94	MEI7702286.1 TerC family protein [Planctomycetia bacterium]	diamond	123	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
27017552	27017552	PRJNA630877_S_NODE_85142_length_272_cov_2.393939_g66005_i0	PRJNA630877	85142	272	2.393939	6.51151408	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0111	NR	HUW32127.1	2026780	g66005	i0	37.9	0.727941176470588	66	35	68.4	2	33	218	6	69	HUW32127.1 hypothetical protein [Planctomycetota bacterium]	diamond	198	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28154903	28154903	PRJNA630877_S_NODE_120845_length_189_cov_1.358108_g101708_i0	PRJNA630877	120845	189	1.358108	2.56682412	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0263	NR	MFC1766865.1	2026780	g101708	i0	34.8	0.73015873015873	46	28	73	1	23	160	46	89	MFC1766865.1 tyrosine-type recombinase/integrase [Planctomycetota bacterium]	diamond	138	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28407352	28407352	PRJNA630877_S_NODE_101566_length_223_cov_2.950549_g82429_i0	PRJNA630877	101566	223	2.950549	6.57972427	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	42.4	0.0371	NR	MFB3890659.1	2026778	g82429	i0	40.6	0.860986547085202	64	29	80.7	2	209	30	222	280	MFB3890659.1 uroporphyrinogen decarboxylase family protein [Phycisphaerae bacterium]	diamond	192	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29165320	29165320	PRJNA630877_S_NODE_122289_length_187_cov_1.506849_g103152_i0	PRJNA630877	122289	187	1.506849	2.81780763	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	41.6	0.0456	NR	HEV2293353.1	2876886	g103152	i0	39.3	0.898395721925134	56	34	89.8	0	4	171	171	226	HEV2293353.1 integron integrase [Tepidisphaeraceae bacterium]	diamond	168	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
29430021	29430021	PRJNA630877_S_NODE_107129_length_212_cov_1.216374_g87992_i0	PRJNA630877	107129	212	1.216374	2.57871288	Planctomycetia	203683	Bacteria	Bacteria	42.7	0.024	NR	HEV8067191.1	2026779	g87992	i0	33.9	2.34905660377358	59	39	83.5	0	191	15	5	63	HEV8067191.1 ABC transporter ATP-binding protein [Planctomycetaceae bacterium]	diamond	498	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29575318	29575318	PRJNA630877_S_NODE_92370_length_248_cov_1.376812_g73233_i0	PRJNA630877	92370	248	1.376812	3.41449376	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	42.7	0.0367	NR	MEZ6091620.1	2699754	g73233	i0	35.2	0.653225806451613	54	28	58.1	2	14	157	175	227	MEZ6091620.1 hypothetical protein [Pirellulaceae bacterium]	diamond	162	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
30554636	30554636	PRJNA630877_S_NODE_91133_length_252_cov_0.952607_g71996_i0	PRJNA630877	91133	252	0.952607	2.40056964	Phycisphaerae bacterium SM23_33	1703412	Bacteria	Bacteria	45.8	0.00329	NR	KPK84483.1	1703412	g71996	i0	32.1	0.964285714285714	81	37	75	3	224	36	303	383	KPK84483.1 MAG: hypothetical protein AMJ81_05380 [Phycisphaerae bacterium SM23_33]	diamond	243	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium SM23_33
30680953	30680953	PRJNA630877_S_NODE_95453_length_239_cov_1.333333_g76316_i0	PRJNA630877	95453	239	1.333333	3.18666587	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.6	0.00152	NR	MEO1715707.1	2026780	g76316	i0	34.7	0.903765690376569	72	46	89.1	1	6	218	288	359	MEO1715707.1 hypothetical protein [Planctomycetota bacterium]	diamond	216	46.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31028927	31028927	PRJNA630877_S_NODE_70515_length_348_cov_2.778502_g51378_i0	PRJNA630877	70515	348	2.778502	9.66918696	Planctomycetota bacterium	2026780	Bacteria	Bacteria	46.2	0.00678	NR	MCB9832231.1	2026780	g51378	i0	50.8	0.560344827586207	65	21	56	3	292	98	116	169	MCB9832231.1 hypothetical protein [Planctomycetota bacterium]	diamond	195	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32040769	32040769	PRJNA630877_S_NODE_49378_length_581_cov_2.151852_g30881_i0	PRJNA630877	49378	581	2.151852	12.50226012	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47	0.0199	NR	MEY4176768.1	2026780	g30881	i0	40	0.309810671256454	60	30	31	2	356	177	174	227	MEY4176768.1 hypothetical protein [Planctomycetota bacterium]	diamond	180	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32452341	32452341	PRJNA630877_S_NODE_62819_length_410_cov_3.837398_g43688_i0	PRJNA630877	62819	410	3.837398	15.7333318	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	45.8	0.00837	NR	MEZ6137792.1	2699754	g43688	i0	34.3	0.51219512195122	70	41	51.2	1	395	186	34	98	MEZ6137792.1 DinB family protein [Pirellulaceae bacterium]	diamond	210	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32798777	32798777	PRJNA630877_S_NODE_126220_length_182_cov_1.269504_g107083_i0	PRJNA630877	126220	182	1.269504	2.31049728	Neorhodopirellula pilleata	2714738	Bacteria	Bacteria	41.6	0.0421	NR	WP_231602722.1	2714738	g107083	i0	43.8	0.527472527472527	32	18	52.7	0	144	49	235	266	WP_231602722.1 sigma-54 interaction domain-containing protein [Neorhodopirellula pilleata]	diamond	96	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Neorhodopirellula	Neorhodopirellula pilleata

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