metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
1749575	1749575	PRJNA493828_P_NODE_24122_length_273_cov_2.860000_g23703_i0	PRJNA493828	24122	273	2.86	7.8078	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	335	2.22e-87	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g23703	i0	91.429	230.128205128205	245	20	89	1	1	244	1320345	1320589	Luteolibacter sp. Populi chromosome, complete genome	blastn	62825	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
4301314	4301314	PRJNA493828_P_NODE_11924_length_335_cov_3.645038_g11505_i0	PRJNA493828	11924	335	3.645038	12.2108773	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	462	1.23e-125	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g11505	i0	92.835	229.522388059701	321	20	95	3	7	325	3412359	3412678	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	76890	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
4301407	4301407	PRJNA493828_P_NODE_17484_length_300_cov_2.281938_g17065_i0	PRJNA493828	17484	300	2.281938	6.845814	Actomonas aquatica	2866162	Bacteria	Bacteria	340	5.319999999999999e-89	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g17065	i0	92.766	239.036666666667	235	17	78	0	35	269	4455546	4455312	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	71711	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
4301500	4301500	PRJNA493828_P_NODE_22984_length_277_cov_1.784314_g22565_i0	PRJNA493828	22984	277	1.784314	4.94254978	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	457	4.62e-124	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g22565	i0	98.092	200.310469314079	262	5	95	0	15	276	913072	913333	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	55486	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4301522	4301522	PRJNA493828_P_NODE_23984_length_274_cov_1.273632_g23565_i0	PRJNA493828	23984	274	1.273632	3.48975168	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	340	4.7999999999999996e-89	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g23565	i0	90.625	186.784671532847	256	24	93	0	16	271	2748230	2748485	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	51179	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8127480	8127480	PRJNA493828_P_NODE_10687_length_351_cov_1.438849_g10268_i0	PRJNA493828	10687	351	1.438849	5.05035999	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	510	4.55e-140	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g10268	i0	92.877	99.1282051282051	351	25	100	0	1	351	2556751	2556401	Lacunisphaera limnophila strain IG16b, complete genome	blastn	34794	510	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
8127726	8127726	PRJNA493828_P_NODE_26867_length_265_cov_1.203125_g26448_i0	PRJNA493828	26867	265	1.203125	3.18828125	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	311	3.62e-80	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g26448	i0	88.672	13.811320754717	256	28	97	1	10	265	3991768	3992022	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	3660	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
8127744	8127744	PRJNA493828_P_NODE_27787_length_262_cov_1.867725_g27368_i0	PRJNA493828	27787	262	1.867725	4.8934395	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	346	9.789999999999999e-91	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g27368	i0	90.84	283.18320610687	262	19	99	4	2	262	4718831	4718574	Luteolibacter sp. SL250 chromosome	blastn	74194	346	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10678115	10678115	PRJNA493828_P_NODE_1709_length_815_cov_88.513477_g1397_i0	PRJNA493828	1709	815	88.513477	721.38483755	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1295	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g1397	i0	95.349	5.40368098159509	817	34	100	4	1	815	2998180	2997366	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	4404	1295	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
10678556	10678556	PRJNA493828_P_NODE_47449_length_202_cov_5.937984_g47030_i0	PRJNA493828	47449	202	5.937984	11.99472768	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	366	5.530000000000001e-97	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g47030	i0	99.502	408.366336633663	201	1	99	0	2	202	16839	16639	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	82490	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14503592	14503592	PRJNA493828_P_NODE_40812_length_237_cov_6.975610_g40393_i0	PRJNA493828	40812	237	6.97561	16.5321957	uncultured Verrucomicrobiaceae bacterium	257470	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|220682444\|gb\|FJ543051.1\|	257470	g40393	i0	99.578	100.552742616034	237	1	100	0	1	237	1399	1163	Uncultured Verrucomicrobiaceae bacterium clone B08-05F 16S ribosomal RNA gene, partial sequence	blastn	23831	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		uncultured Verrucomicrobiaceae bacterium
15777161	15777161	PRJNA493828_P_NODE_1793_length_793_cov_22.438889_g1397_i1	PRJNA493828	1793	793	22.438889	177.94038977	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1238	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g1397	i1	94.843	5.43253467843632	795	37	100	4	1	793	2998180	2997388	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	4308	1238	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
18958176	18958176	PRJNA493828_P_NODE_3355_length_584_cov_6.223092_g3000_i0	PRJNA493828	3355	584	6.223092	36.34285728	Opitutaceae	134623	Bacteria	Bacteria	736	0	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g3000	i0	89.384	100.864726027397	584	62	100	0	1	584	592	9	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	58905	736	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
19600448	19600448	PRJNA493828_P_NODE_17636_length_299_cov_1.380531_g17217_i0	PRJNA493828	17636	299	1.380531	4.12778769	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	394	4.01e-105	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g17217	i0	90.397	136.749163879599	302	25	100	4	1	299	3833590	3833290	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	40888	394	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19600573	19600573	PRJNA493828_P_NODE_26276_length_266_cov_4.082902_g25857_i0	PRJNA493828	26276	266	4.082902	10.86051932	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	460	3.41e-125	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g25857	i0	98.106	276.913533834586	264	5	99	0	1	264	2218705	2218442	Luteolibacter sp. LG18 DNA, complete genome	blastn	73659	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
21508367	21508367	PRJNA493828_P_NODE_16237_length_309_cov_6.207627_g15818_i0	PRJNA493828	16237	309	6.207627	19.18156743	Opitutus	178440	Bacteria	Bacteria	460	4.05e-125	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g15818	i0	93.569	76.0711974110032	311	16	100	3	1	309	705	1013	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	23506	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
21508379	21508379	PRJNA493828_P_NODE_16917_length_304_cov_4.887446_g16498_i0	PRJNA493828	16917	304	4.887446	14.85783584	Verrucomicrobiota	74201	Bacteria	Bacteria	274	5.55e-69	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g16498	i0	83.117	121.378289473684	308	44	99	8	1	303	5152540	5152844	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	36899	274	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23427253	23427253	PRJNA493828_P_NODE_36499_length_245_cov_0.895349_g36080_i0	PRJNA493828	36499	245	0.895349	2.19360505	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	228	3.4199999999999995e-55	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g36080	i0	85.366	20.4489795918367	246	6	100	12	1	245	875719	875503	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	5010	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23427478	23427478	PRJNA493828_P_NODE_8279_length_391_cov_2.374214_g7864_i0	PRJNA493828	8279	391	2.374214	9.28317674	Fontisphaera persica	2974023	Bacteria	Bacteria	497	3.99e-136	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g7864	i0	89.717	249.375959079284	389	40	99	0	1	389	3862128	3861740	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	97506	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
24058528	24058528	PRJNA493828_P_NODE_40699_length_238_cov_2.654545_g40280_i0	PRJNA493828	40699	238	2.654545	6.3178171	Akkermansia	239934	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g40280	i0	100	296	238	0	100	0	1	238	138160	137923	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	70448	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24700795	24700795	PRJNA493828_P_NODE_37880_length_243_cov_1.423529_g37461_i0	PRJNA493828	37880	243	1.423529	3.45917547	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g37461	i0	99.167	210.98353909465	240	2	99	0	1	240	2759	2520	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	51269	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2

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