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

21 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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
313417	313417	PRJNA1166865_P_NODE_62961_length_279_cov_1.189320_g62720_i0	PRJNA1166865	62961	279	1.18932	3.3182028	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	488	1.6499999999999999e-133	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g62720	i0	98.208	107.663082437276	279	5	100	0	1	279	5152946	5152668	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	30038	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
313865	313865	PRJNA1166865_P_NODE_82341_length_247_cov_2.017241_g82100_i0	PRJNA1166865	82341	247	2.017241	4.98258527	Fontisphaera persica	2974023	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g82100	i0	93.145	154.740890688259	248	9	99	6	1	246	3861874	3861633	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	38221	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
3590096	3590096	PRJNA1166865_P_NODE_60703_length_284_cov_1.383886_g60462_i0	PRJNA1166865	60703	284	1.383886	3.93023624	Chthoniobacter	295577	Bacteria	Bacteria	503	6.02e-138	NTclustered	gi\|229576237\|gb\|FJ822630.1\|	156588	g60462	i0	98.592	99.9788732394366	284	4	100	0	1	284	757	474	Uncultured Verrucomicrobia bacterium clone 17Lo 16S ribosomal RNA gene, partial sequence	blastn	28394	503	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4139991	4139991	PRJNA1166865_P_NODE_53144_length_303_cov_1.339130_g52903_i0	PRJNA1166865	53144	303	1.33913	4.0575639	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	488	1.8199999999999993e-133	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g52903	i0	95.71	127.927392739274	303	13	100	0	1	303	2556816	2557118	Lacunisphaera limnophila strain IG16b, complete genome	blastn	38762	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
5416533	5416533	PRJNA1166865_P_NODE_65485_length_273_cov_1.500000_g65244_i0	PRJNA1166865	65485	273	1.5	4.095	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	311	3.75e-80	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g65244	i0	87.179	1	273	35	100	0	1	273	3667085	3666813	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	273	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
5416788	5416788	PRJNA1166865_P_NODE_76125_length_251_cov_0.865169_g75884_i0	PRJNA1166865	76125	251	0.865169	2.17157419	Opitutus terrae	107709	Bacteria	Bacteria	187	5.98e-43	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g75884	i0	83.251	1.33864541832669	203	34	81	0	48	250	5732378	5732176	Opitutus terrae PB90-1, complete genome	blastn	336	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
6690502	6690502	PRJNA1166865_P_NODE_31066_length_387_cov_0.955414_g30825_i0	PRJNA1166865	31066	387	0.955414	3.69745218	Pedosphaera parvula	1032527	Bacteria	Bacteria	464	4.01e-126	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g30825	i0	88.773	76.594315245478	383	38	98	5	1	380	1304	924	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	29642	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
6691776	6691776	PRJNA1166865_P_NODE_83006_length_247_cov_0.885057_g82765_i0	PRJNA1166865	83006	247	0.885057	2.18609079	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	272	1.5699999999999999e-68	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g82765	i0	86.585	18.1133603238866	246	33	99	0	1	246	3938723	3938478	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	4474	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9241580	9241580	PRJNA1166865_P_NODE_72708_length_256_cov_1.530055_g72467_i0	PRJNA1166865	72708	256	1.530055	3.9169408	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	152	2.2299999999999998e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g72467	i0	78.113	3.88671875	265	41	98	12	1	252	3344487	3344747	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	995	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9967723	9967723	PRJNA1166865_P_NODE_58648_length_289_cov_1.134259_g58407_i0	PRJNA1166865	58648	289	1.134259	3.27800851	Opitutus	178440	Bacteria	Bacteria	435	2.27e-117	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g58407	i0	93.772	191.062283737024	289	18	100	0	1	289	1539	1251	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	55217	435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
11242919	11242919	PRJNA1166865_P_NODE_70589_length_261_cov_1.494681_g70348_i0	PRJNA1166865	70589	261	1.494681	3.90111741	Opitutia	414999	Bacteria	Bacteria	217	7.979999999999999e-52	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g70348	i0	84.793	66.9425287356322	217	31	83	2	11	226	971712	971927	Ereboglobus luteus strain Ho45, complete genome	blastn	17472	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
11792756	11792756	PRJNA1166865_P_NODE_95250_length_241_cov_0.916667_g95009_i0	PRJNA1166865	95250	241	0.916667	2.20916747	Horticoccus luteus	2862869	Bacteria	Bacteria	243	1.2e-59	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g95009	i0	85.408	0.966804979253112	233	34	97	0	3	235	4224933	4225165	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	233	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
13067241	13067241	PRJNA1166865_P_NODE_72551_length_256_cov_1.989071_g72310_i0	PRJNA1166865	72551	256	1.989071	5.09202176	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	252	2.14e-62	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g72310	i0	84.825	1.94921875	257	31	98	8	6	256	1683472	1683218	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	499	252	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13067345	13067345	PRJNA1166865_P_NODE_77271_length_250_cov_0.870056_g77030_i0	PRJNA1166865	77271	250	0.870056	2.17514	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	363	9.209999999999997e-96	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g77030	i0	92.8	133.764	250	18	100	0	1	250	5154076	5153827	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33441	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13067430	13067430	PRJNA1166865_P_NODE_81051_length_248_cov_0.880000_g80810_i0	PRJNA1166865	81051	248	0.88	2.1824	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	113	1.01e-20	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g80810	i0	86.538	2.12096774193548	104	12	42	2	1	103	3833087	3833189	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	526	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19439978	19439978	PRJNA1166865_P_NODE_90536_length_243_cov_0.905882_g90295_i0	PRJNA1166865	90536	243	0.905882	2.20129326	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g90295	i0	100	0.242798353909465	30	0	12	0	94	123	1386723	1386694	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	59	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20715133	20715133	PRJNA1166865_P_NODE_80017_length_249_cov_0.875000_g79776_i0	PRJNA1166865	80017	249	0.875	2.17875	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	272	1.5899999999999998e-68	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g79776	i0	86.508	4.59839357429719	252	28	100	4	1	249	832203	831955	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1145	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
21990401	21990401	PRJNA1166865_P_NODE_77198_length_250_cov_0.870056_g76957_i0	PRJNA1166865	77198	250	0.870056	2.17514	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	158	4.66e-34	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g76957	i0	80.275	0.872	218	35	85	6	1	213	987921	987707	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	218	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21990604	21990604	PRJNA1166865_P_NODE_86558_length_245_cov_0.895349_g86317_i0	PRJNA1166865	86558	245	0.895349	2.19360505	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	204	5.77e-48	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g86317	i0	81.928	1.64081632653061	249	37	100	7	1	245	2236926	2237170	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	402	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21990656	21990656	PRJNA1166865_P_NODE_88718_length_244_cov_0.900585_g88477_i0	PRJNA1166865	88718	244	0.900585	2.1974274	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	185	2.0799999999999994e-42	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g88477	i0	85.714	1.14344262295082	175	25	72	0	46	220	5918174	5918000	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	279	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
22716485	22716485	PRJNA1166865_P_NODE_35358_length_364_cov_1.924399_g35117_i0	PRJNA1166865	35358	364	1.924399	7.00481236	Akkermansia	239934	Bacteria	Bacteria	233	1.15e-56	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g35117	i0	78.889	93.4862637362637	360	64	97	8	1	354	2971566	2971919	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	34029	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis

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