metadata: contig_metadata: 24 rows where bioproject = "PRJNA613025" and tax

24 rows where bioproject = "PRJNA613025" 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
3142575	3142575	PRJNA613025_S_NODE_2043_length_1344_cov_6.298069_g1276_i1	PRJNA613025	2043	1344	6.298069	84.64604736	Fontisphaera persica	2974023	Bacteria	Bacteria	1410	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g1276	i1	85.672	225.723214285714	1361	169	100	23	1	1344	3861087	3862438	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	303372	1410	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
3143048	3143048	PRJNA613025_S_NODE_7923_length_480_cov_1.935035_g7771_i0	PRJNA613025	7923	480	1.935035	9.288168	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	255	3.32e-63	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g7771	i0	77.855	1.5	429	83	88	11	58	480	1237378	1237800	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	720	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
5695135	5695135	PRJNA613025_S_NODE_13665_length_303_cov_1.153543_g13511_i0	PRJNA613025	13665	303	1.153543	3.49523529	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	206	2.05e-48	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g13511	i0	80.137	2.43894389438944	292	45	95	13	16	303	3143362	3143080	Lacunisphaera limnophila strain IG16b, complete genome	blastn	739	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
6969884	6969884	PRJNA613025_S_NODE_12566_length_325_cov_41.413043_g12412_i0	PRJNA613025	12566	325	41.413043	134.59238975	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	577	4.069999999999999e-160	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g12412	i0	98.765	98.7723076923077	324	4	99	0	2	325	366	43	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	32101	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6970025	6970025	PRJNA613025_S_NODE_17606_length_243_cov_2.355670_g17452_i0	PRJNA613025	17606	243	2.35567	5.7242781	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	265	2.58e-66	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g17452	i0	86.611	24.4485596707819	239	32	98	0	5	243	3990748	3990510	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	5941	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
6970058	6970058	PRJNA613025_S_NODE_18666_length_232_cov_1.655738_g18512_i0	PRJNA613025	18666	232	1.655738	3.84131216	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	228	3.209999999999999e-55	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g18512	i0	88.601	1.66810344827586	193	15	82	5	8	197	1683339	1683151	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	387	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8244723	8244723	PRJNA613025_S_NODE_17487_length_244_cov_3.102564_g17333_i0	PRJNA613025	17487	244	3.102564	7.57025616	Fontisphaera persica	2974023	Bacteria	Bacteria	274	4.31e-69	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g17333	i0	87.045	71.9016393442623	247	27	100	3	1	244	3861780	3861536	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	17544	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
15894497	15894497	PRJNA613025_S_NODE_13753_length_301_cov_1.329365_g13599_i0	PRJNA613025	13753	301	1.329365	4.00138865	Horticoccus luteus	2862869	Bacteria	Bacteria	353	6.86e-93	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g13599	i0	95.475	144.757475083056	221	10	73	0	81	301	540889	541109	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	43572	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
15894872	15894872	PRJNA613025_S_NODE_29993_length_167_cov_1.296610_g29839_i0	PRJNA613025	29993	167	1.29661	2.1653387	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	198	1.7e-46	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g29839	i0	88.024	96.874251497006	167	20	100	0	1	167	1317620	1317786	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	16178	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17169576	17169576	PRJNA613025_S_NODE_19514_length_224_cov_2.011429_g19360_i0	PRJNA613025	19514	224	2.011429	4.50560096	Pedosphaera parvula	1032527	Bacteria	Bacteria	159	1.14e-34	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g19360	i0	81.068	14.5357142857143	206	33	91	6	4	207	493	292	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	3256	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17169663	17169663	PRJNA613025_S_NODE_23354_length_197_cov_2.027027_g23200_i0	PRJNA613025	23354	197	2.027027	3.99324319	Fontisphaera persica	2974023	Bacteria	Bacteria	161	2.7199999999999997e-35	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g23200	i0	81.91	3.45177664974619	199	28	99	7	1	195	3862387	3862193	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	680	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
18443720	18443720	PRJNA613025_S_NODE_18535_length_233_cov_2.076087_g18381_i0	PRJNA613025	18535	233	2.076087	4.83728271	Fontisphaera persica	2974023	Bacteria	Bacteria	281	2.44e-71	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g18381	i0	88.511	70.9098712446352	235	23	100	4	1	233	3863064	3863296	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	16522	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
18443741	18443741	PRJNA613025_S_NODE_19515_length_224_cov_1.994286_g19361_i0	PRJNA613025	19515	224	1.994286	4.46720064	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	305	1.38e-78	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g19361	i0	93.659	267.25	205	12	92	1	20	224	5637618	5637821	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	59864	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
22268895	22268895	PRJNA613025_S_NODE_21258_length_210_cov_2.658385_g21104_i0	PRJNA613025	21258	210	2.658385	5.5826085	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	342	9.769999999999999e-90	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g21104	i0	96.172	41.1571428571429	209	8	99	0	1	209	3557106	3557314	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	8643	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22269190	22269190	PRJNA613025_S_NODE_34038_length_160_cov_3.684685_g33884_i0	PRJNA613025	34038	160	3.684685	5.895496	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	147	5.919999999999999e-31	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g33884	i0	83.23	20.96875	161	26	100	1	1	160	2577571	2577411	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	3355	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
23543991	23543991	PRJNA613025_S_NODE_12439_length_328_cov_2.537634_g12285_i0	PRJNA613025	12439	328	2.537634	8.32343952	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	568	2.4799999999999995e-157	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g12285	i0	97.866	143.567073170732	328	7	100	0	1	328	3557843	3557516	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	47090	568	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23544585	23544585	PRJNA613025_S_NODE_5879_length_608_cov_3.908766_g5732_i0	PRJNA613025	5879	608	3.908766	23.76529728	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1096	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g5732	i0	99.178	101.998355263158	608	5	100	0	1	608	3556527	3557134	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	62015	1096	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
26763750	26763750	PRJNA613025_S_NODE_30701_length_166_cov_0.871795_g30547_i0	PRJNA613025	30701	166	0.871795	1.4471797	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	48.9	6.37e-6	NR	PYJ85085.1	2026799	g30547	i0	63.2	0.686746987951807	38	14	68.7	0	153	40	28	65	PYJ85085.1 MAG: hypothetical protein DME22_10395 [Verrucomicrobiota bacterium]	diamond	114	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27238257	27238257	PRJNA613025_S_NODE_14423_length_288_cov_10.133891_g14269_i0	PRJNA613025	14423	288	10.133891	29.18560608	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0164	NR	MEI6341235.1	2026799	g14269	i0	46	0.520833333333333	50	25	50	1	110	253	109	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	150	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28280209	28280209	PRJNA613025_S_NODE_12346_length_330_cov_26.078292_g12192_i0	PRJNA613025	12346	330	26.078292	86.0583636	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0255	NR	MEI6341235.1	2026799	g12192	i0	41.4	0.527272727272727	58	32	50.9	1	91	258	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28722549	28722549	PRJNA613025_S_NODE_11567_length_349_cov_29.053333_g11413_i0	PRJNA613025	11567	349	29.053333	101.39613217	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.0157	NR	MEI6341235.1	2026799	g11413	i0	39.7	0.498567335243553	58	33	48.1	1	110	277	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28911588	28911588	PRJNA613025_S_NODE_11568_length_349_cov_25.446667_g11414_i0	PRJNA613025	11568	349	25.446667	88.80886783	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00432	NR	MEI6341235.1	2026799	g11414	i0	33.7	0.713467048710602	83	46	63.6	2	56	277	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29196205	29196205	PRJNA613025_S_NODE_11569_length_349_cov_24.186667_g11415_i0	PRJNA613025	11569	349	24.186667	84.41146783	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00432	NR	MEI6341235.1	2026799	g11415	i0	34.9	0.713467048710602	83	45	63.6	2	56	277	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30996591	30996591	PRJNA613025_S_NODE_11474_length_351_cov_25.784768_g11320_i0	PRJNA613025	11474	351	25.784768	90.50453568	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0308	NR	MEI6341235.1	2026799	g11320	i0	41.4	0.495726495726496	58	32	47.9	1	112	279	109	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	174	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;