metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
377523	377523	PRJNA312107_P_NODE_14861_length_189_cov_2.721429_g14695_i0	PRJNA312107	14861	189	2.721429	5.14350081	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	268	1.4799999999999997e-67	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g14695	i0	92.632	202.502645502645	190	9	100	3	1	189	1315347	1315532	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	38273	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1652446	1652446	PRJNA312107_P_NODE_4262_length_341_cov_1.630137_g4096_i0	PRJNA312107	4262	341	1.630137	5.55876717	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	424	5.93e-114	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g4096	i0	92.359	119.545454545455	301	17	87	4	45	341	1316740	1316442	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	40765	424	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2928153	2928153	PRJNA312107_P_NODE_11423_length_214_cov_3.951515_g11257_i0	PRJNA312107	11423	214	3.951515	8.4562421	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	318	1.68e-82	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g11257	i0	93.458	322.14953271028	214	14	100	0	1	214	1315881	1316094	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	68940	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2928177	2928177	PRJNA312107_P_NODE_16023_length_183_cov_1.126866_g15857_i0	PRJNA312107	16023	183	1.126866	2.06216478	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	292	8.44e-75	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g15857	i0	95.604	267.928961748634	182	8	99	0	2	183	2355	2174	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	49031	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4204719	4204719	PRJNA312107_P_NODE_10804_length_220_cov_1.479532_g10638_i0	PRJNA312107	10804	220	1.479532	3.2549704	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	324	3.7399999999999997e-84	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10638	i0	93.182	111.677272727273	220	15	100	0	1	220	1316845	1317064	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	24569	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4204756	4204756	PRJNA312107_P_NODE_17984_length_172_cov_0.975610_g17818_i0	PRJNA312107	17984	172	0.97561	1.6780492	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	244	2.22e-60	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g17818	i0	92.442	187.720930232558	172	12	100	1	1	172	558676	558506	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	32288	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4204757	4204757	PRJNA312107_P_NODE_18284_length_170_cov_1.719008_g18118_i0	PRJNA312107	18284	170	1.719008	2.9223136	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	169	1.35e-37	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g18118	i0	88.489	166.464705882353	139	16	82	0	32	170	1207	1069	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	28299	169	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
6755216	6755216	PRJNA312107_P_NODE_14946_length_189_cov_1.164286_g14780_i0	PRJNA312107	14946	189	1.164286	2.20050054	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	305	1.13e-78	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g14780	i0	95.767	428.904761904762	189	8	100	0	1	189	27241	27429	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	81063	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
6755321	6755321	PRJNA312107_P_NODE_2866_length_413_cov_1.953297_g2700_i0	PRJNA312107	2866	413	1.953297	8.06711661	uncultured Opitutales bacterium	592834	Bacteria	Bacteria	580	4.09e-161	NTclustered	gi\|2557661280\|gb\|OR396774.1\|	592834	g2700	i0	92.048	101.489104116223	415	30	100	3	1	413	1518	1105	Uncultured Opitutales bacterium clone Md513_unbinned&&k119_619290 16S ribosomal RNA gene, partial sequence	blastn	41915	580	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			uncultured Opitutales bacterium
8030917	8030917	PRJNA312107_P_NODE_9067_length_238_cov_1.534392_g8901_i0	PRJNA312107	9067	238	1.534392	3.65185296	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	396	8.5699999999999955e-106	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g8901	i0	96.639	242.731092436975	238	8	100	0	1	238	3991851	3992088	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	57770	396	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
9991783	9991783	PRJNA312107_P_NODE_16888_length_178_cov_1.054264_g16722_i0	PRJNA312107	16888	178	1.054264	1.87658992	Bacteria	2	Bacteria	Bacteria	307	2.91e-79	NTclustered	gi\|1498416\|gb\|U62845.1\|UEU62845	50837	g16722	i0	97.753	99.5955056179775	178	4	100	0	1	178	527	350	Unidentified eubacterium RB24 16S ribosomal RNA gene, partial sequence	blastn	17728	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			unidentified eubacterium RB24
9991813	9991813	PRJNA312107_P_NODE_9068_length_238_cov_1.513228_g8902_i0	PRJNA312107	9068	238	1.513228	3.60148264	Prosthecobacter	48463	Bacteria	Bacteria	302	1.92e-77	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g8902	i0	95.263	283.752100840336	190	9	80	0	49	238	2753	2564	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	67533	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
10581609	10581609	PRJNA312107_P_NODE_6429_length_280_cov_2.173160_g6263_i0	PRJNA312107	6429	280	2.17316	6.084848	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	375	1.3499999999999995e-99	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6263	i0	91.367	108.914285714286	278	19	98	3	7	280	1052	776	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	30496	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11856302	11856302	PRJNA312107_P_NODE_5770_length_295_cov_1.784553_g5604_i0	PRJNA312107	5770	295	1.784553	5.26443135	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	420	6.52e-113	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g5604	i0	96.109	217.189830508475	257	10	87	0	1	257	1240	984	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	64071	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
14406543	14406543	PRJNA312107_P_NODE_2212_length_467_cov_1.313397_g2046_i0	PRJNA312107	2212	467	1.313397	6.13356399	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	641	2.12e-179	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g2046	i0	91.974	98.3854389721627	461	32	98	5	9	467	5153088	5152631	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	45946	641	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16954880	16954880	PRJNA312107_P_NODE_10594_length_222_cov_1.312139_g10428_i0	PRJNA312107	10594	222	1.312139	2.91294858	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	316	6.319999999999998e-82	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g10428	i0	95.897	93.554054054054	195	8	88	0	28	222	16128	16322	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	20769	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
16954910	16954910	PRJNA312107_P_NODE_17014_length_177_cov_1.460938_g16848_i0	PRJNA312107	17014	177	1.460938	2.58586026	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	311	2.23e-80	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g16848	i0	98.305	109.152542372881	177	3	100	0	1	177	26358	26182	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	19320	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18229239	18229239	PRJNA312107_P_NODE_13355_length_200_cov_1.006623_g13189_i0	PRJNA312107	13355	200	1.006623	2.013246	Luteolibacter sp.	1962973	Bacteria	Bacteria	239	1.24e-58	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g13189	i0	90.96	168.815	177	16	89	0	1	177	1011049	1010873	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	33763	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
19503542	19503542	PRJNA312107_P_NODE_15856_length_184_cov_0.770370_g15690_i0	PRJNA312107	15856	184	0.77037	1.4174808	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	259	8.61e-65	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g15690	i0	92.737	238.923913043478	179	13	97	0	6	184	2743	2565	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	43962	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
19503545	19503545	PRJNA312107_P_NODE_16276_length_181_cov_2.022727_g16110_i0	PRJNA312107	16276	181	2.022727	3.66113587	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	320	3.82e-83	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g16110	i0	98.883	39.0386740331492	179	2	99	0	1	179	2180	2358	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	7066	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
19503550	19503550	PRJNA312107_P_NODE_17976_length_172_cov_1.024390_g17810_i0	PRJNA312107	17976	172	1.02439	1.7619508	Fontisphaera persica	2974023	Bacteria	Bacteria	222	1.04e-53	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g17810	i0	90.23	20.0290697674419	174	11	100	6	1	172	3861679	3861848	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	3445	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
22054192	22054192	PRJNA312107_P_NODE_26078_length_162_cov_0.920354_g25912_i0	PRJNA312107	26078	162	0.920354	1.49097348	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	171	3.57e-38	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g25912	i0	85.802	3.46913580246914	162	22	100	1	1	162	556959	557119	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	562	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22740422	22740422	PRJNA312107_P_NODE_3578_length_370_cov_1.934579_g3412_i0	PRJNA312107	3578	370	1.934579	7.1579423	Verrucomicrobiota	74201	Bacteria	Bacteria	604	2.149999999999999e-168	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g3412	i0	96.703	99.1945945945946	364	10	98	2	1	363	2145	1783	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	36702	610	0.99016393442623	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
24603612	24603612	PRJNA312107_P_NODE_17000_length_177_cov_1.585938_g16834_i0	PRJNA312107	17000	177	1.585938	2.80711026	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	104	4.07e-18	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g16834	i0	82.759	1.59887005649718	116	20	66	0	4	119	189073	188958	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	283	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25289738	25289738	PRJNA312107_P_NODE_14360_length_192_cov_3.132867_g14194_i0	PRJNA312107	14360	192	3.132867	6.01510464	Prosthecobacter	48463	Bacteria	Bacteria	331	1.9e-86	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g14194	i0	97.917	278.598958333333	192	2	100	2	1	192	1578	1767	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	53491	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii

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