metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Verrucomicrobiota"

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
617953	617953	PRJNA642647_P_NODE_1561_length_278_cov_2.937759_g1511_i0	PRJNA642647	1561	278	2.937759	8.16697002	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	401	2.2099999999999994e-107	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g1511	i0	92.806	280.086330935252	278	18	100	1	1	278	1771	1496	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	77864	401	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
617956	617956	PRJNA642647_P_NODE_2041_length_241_cov_5.921569_g1991_i0	PRJNA642647	2041	241	5.921569	14.27098129	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	327	3.22e-85	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g1991	i0	91.322	302.780082987552	242	18	100	3	1	241	2279	2518	Luteolibacter sp. SL250 chromosome	blastn	72970	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
617983	617983	PRJNA642647_P_NODE_5241_length_166_cov_1.193798_g5191_i0	PRJNA642647	5241	166	1.193798	1.98170468	Fontisphaera persica	2974023	Bacteria	Bacteria	196	6.069999999999999e-46	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g5191	i0	88.485	4.68674698795181	165	16	98	3	1	163	3861539	3861376	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	778	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
1894214	1894214	PRJNA642647_P_NODE_4182_length_176_cov_4.611511_g4132_i0	PRJNA642647	4182	176	4.611511	8.11625936	Akkermansia muciniphila	239935	Bacteria	Bacteria	163	6.570000000000001e-36	NTclustered	gi\|2446175557\|gb\|CP117954.1\|	239935	g4132	i0	84.756	274.534090909091	164	23	93	2	1	163	1629485	1629323	Akkermansia muciniphila strain OB21 FAA NB 28 chromosome, complete genome	blastn	48318	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3168831	3168831	PRJNA642647_P_NODE_4703_length_168_cov_2.549618_g4653_i0	PRJNA642647	4703	168	2.549618	4.28335824	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	237	3.63e-58	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g4653	i0	92.683	113.511904761905	164	12	98	0	4	167	28554	28391	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	19070	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5721507	5721507	PRJNA642647_P_NODE_2325_length_226_cov_1.269841_g2275_i0	PRJNA642647	2325	226	1.269841	2.86984066	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	318	1.8e-82	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g2275	i0	92.444	80.4203539823009	225	13	99	4	4	226	27544	27322	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	18175	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6996527	6996527	PRJNA642647_P_NODE_1546_length_280_cov_1.576132_g1496_i0	PRJNA642647	1546	280	1.576132	4.4131696	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	222	1.86e-53	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g1496	i0	83.673	72.9892857142857	245	31	87	7	33	275	3450177	3450414	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	20437	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
6996543	6996543	PRJNA642647_P_NODE_2966_length_203_cov_2.674699_g2916_i0	PRJNA642647	2966	203	2.674699	5.42963897	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	259	9.71e-65	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g2916	i0	90	43.9852216748768	200	20	99	0	1	200	2389	2190	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	8929	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
6996546	6996546	PRJNA642647_P_NODE_306_length_642_cov_3.290909_g262_i0	PRJNA642647	306	642	3.290909	21.12763578	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1014	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g262	i0	95.305	248.725856697819	639	30	99	0	4	642	881	1519	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	159682	1014	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6996570	6996570	PRJNA642647_P_NODE_5586_length_161_cov_1.338710_g5536_i0	PRJNA642647	5586	161	1.33871	2.1553231	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	191	2.72e-44	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g5536	i0	88.608	10.7515527950311	158	16	98	2	1	157	1028	872	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	1731	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
8271318	8271318	PRJNA642647_P_NODE_787_length_397_cov_3.202778_g737_i0	PRJNA642647	787	397	3.202778	12.71502866	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	270	9.64e-68	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g737	i0	82.524	198.382871536524	309	52	78	2	4	312	1143	1449	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	78758	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
9546562	9546562	PRJNA642647_P_NODE_2368_length_224_cov_2.422460_g2318_i0	PRJNA642647	2368	224	2.42246	5.4263104	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	254	5.08e-63	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g2318	i0	87.281	214.660714285714	228	21	99	8	4	224	3833522	3833296	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	48084	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10822189	10822189	PRJNA642647_P_NODE_1149_length_330_cov_2.054608_g1099_i0	PRJNA642647	1149	330	2.054608	6.7802064	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	377	4.51e-100	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1099	i0	87.692	124.660606060606	325	38	98	2	4	327	1316341	1316018	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	41138	377	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11361964	11361964	PRJNA642647_P_NODE_3929_length_181_cov_2.270833_g3879_i0	PRJNA642647	3929	181	2.270833	4.11020773	Akkermansia	239934	Bacteria	Bacteria	246	6.57e-61	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g3879	i0	91.573	289.138121546961	178	15	98	0	4	181	360768	360591	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	52334	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
12097449	12097449	PRJNA642647_P_NODE_790_length_396_cov_7.495822_g740_i0	PRJNA642647	790	396	7.495822	29.68345512	Pedosphaera parvula	1032527	Bacteria	Bacteria	385	3.29e-102	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g740	i0	85.87	141.608585858586	368	44	93	4	30	396	1526	1886	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	56077	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
13372015	13372015	PRJNA642647_P_NODE_3131_length_198_cov_6.627329_g3081_i0	PRJNA642647	3131	198	6.627329	13.12211142	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g3081	i0	96.41	250.151515151515	195	7	98	0	1	195	3992083	3991889	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	49530	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
13372057	13372057	PRJNA642647_P_NODE_991_length_354_cov_7.347003_g941_i0	PRJNA642647	991	354	7.347003	26.00839062	Opitutus sp. VeSm13	134636	Bacteria	Bacteria	588	2.0599999999999994e-163	NTclustered	gi\|1872157\|emb\|X99392.1\|	134636	g941	i0	97.391	97.4632768361582	345	9	97	0	1	345	564	220	Opitutus sp. VeSm13 16S rRNA gene, strain VeSm13	blastn	34502	588	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeSm13
13912531	13912531	PRJNA642647_P_NODE_1111_length_335_cov_2.151007_g1061_i0	PRJNA642647	1111	335	2.151007	7.20587345	Opitutaceae	134623	Bacteria	Bacteria	529	1.1999999999999997e-145	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g1061	i0	95.21	45.6	334	16	99	0	2	335	2496851	2497184	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	15276	529	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
14646881	14646881	PRJNA642647_P_NODE_1092_length_339_cov_3.281457_g1042_i0	PRJNA642647	1092	339	3.281457	11.12413923	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	566	9.249999999999999e-157	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g1042	i0	97.024	70.6165191740413	336	10	99	0	4	339	2498310	2498645	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	23939	566	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
14646883	14646883	PRJNA642647_P_NODE_1292_length_307_cov_9.222222_g1242_i0	PRJNA642647	1292	307	9.222222	28.31222154	Prosthecobacter debontii	48467	Bacteria	Bacteria	473	5.159999999999999e-129	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g1242	i0	98.155	218.661237785016	271	5	88	0	37	307	4799	4529	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	67129	473	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
14646884	14646884	PRJNA642647_P_NODE_1312_length_305_cov_3.272388_g1262_i0	PRJNA642647	1312	305	3.272388	9.9807834	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	366	8.94e-97	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g1262	i0	88.562	151.888524590164	306	29	99	6	2	302	3833290	3833594	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	46326	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14646937	14646937	PRJNA642647_P_NODE_6532_length_151_cov_2.087719_g6482_i0	PRJNA642647	6532	151	2.087719	3.15245569	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	172	9.07e-39	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g6482	i0	92.5	130.192052980132	120	9	79	0	6	125	189	308	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	19659	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
17195933	17195933	PRJNA642647_P_NODE_3134_length_198_cov_4.347826_g3084_i0	PRJNA642647	3134	198	4.347826	8.60869548	Candidatus Methylacidiphilum infernorum	511746	Bacteria	Bacteria	134	5.9600000000000006e-27	NTclustered	gi\|1999105499\|gb\|CP065956.1\|	511746	g3084	i0	80.328	276.424242424242	183	30	91	4	13	193	2044071	2043893	Candidatus Methylacidiphilum infernorum strain IT5 chromosome, complete genome	blastn	54732	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Candidatus Methylacidiphilum infernorum
18470265	18470265	PRJNA642647_P_NODE_975_length_358_cov_4.180685_g925_i0	PRJNA642647	975	358	4.180685	14.9668523	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	514	3.5999999999999996e-141	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g925	i0	92.958	101.567039106145	355	22	98	3	1	352	535	181	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	36361	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
21020395	21020395	PRJNA642647_P_NODE_4337_length_174_cov_1.116788_g4287_i0	PRJNA642647	4337	174	1.116788	1.94321112	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	178	2.31e-40	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g4287	i0	85.294	234.551724137931	170	25	98	0	2	171	787	618	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	40812	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
22295062	22295062	PRJNA642647_P_NODE_2458_length_220_cov_2.551913_g2408_i0	PRJNA642647	2458	220	2.551913	5.6142086	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	2.2200000000000005e-91	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g2408	i0	97.087	137.495454545455	206	6	94	0	1	206	914901	915106	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	30249	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24110452	24110452	PRJNA642647_P_NODE_5479_length_162_cov_2.592000_g5429_i0	PRJNA642647	5479	162	2.592	4.19904	Akkermansia	239934	Bacteria	Bacteria	169	1.28e-37	NTclustered	gi\|183579827\|emb\|AM905424.1\|	239935	g5429	i0	87.671	236.277777777778	146	16	90	2	1	145	1094	950	Akkermansia muciniphila 23S rRNA gene, strain CIP107961	blastn	38277	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24844345	24844345	PRJNA642647_P_NODE_5960_length_156_cov_1.865546_g5910_i0	PRJNA642647	5960	156	1.865546	2.91025176	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	132	1.6e-26	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g5910	i0	84.058	1.76923076923077	138	21	88	1	17	154	1391471	1391607	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	276	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482

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