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

28 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
721402	721402	PRJNA741997_P_NODE_32421_length_383_cov_0.945161_g31301_i0	PRJNA741997	32421	383	0.945161	3.61996663	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	69.4	3.63e-7	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g31301	i0	85.938	0.16710182767624	64	9	17	0	1	64	1418454	1418391	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	64	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
721540	721540	PRJNA741997_P_NODE_55841_length_287_cov_1.439252_g54721_i0	PRJNA741997	55841	287	1.439252	4.13065324	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	374	4.989999999999998e-99	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g54721	i0	90.378	98.5226480836237	291	19	99	5	1	286	1316001	1316287	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	28276	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
721584	721584	PRJNA741997_P_NODE_63061_length_271_cov_1.186869_g61941_i0	PRJNA741997	63061	271	1.186869	3.21641499	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	130	1.12e-25	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g61941	i0	95.122	0.302583025830258	82	4	30	0	188	269	3523272	3523191	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	82	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
721608	721608	PRJNA741997_P_NODE_67841_length_260_cov_1.213904_g66721_i0	PRJNA741997	67841	260	1.213904	3.1561504	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	285	2.15e-72	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g66721	i0	86.957	155.892307692308	253	33	97	0	1	253	342887	343139	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	40532	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
721631	721631	PRJNA741997_P_NODE_70721_length_253_cov_1.038889_g69601_i0	PRJNA741997	70721	253	1.038889	2.62838917	Opitutus terrae	107709	Bacteria	Bacteria	303	5.74e-78	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g69601	i0	88.8	2.92885375494071	250	25	99	2	4	253	4393470	4393716	Opitutus terrae PB90-1, complete genome	blastn	741	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
3272781	3272781	PRJNA741997_P_NODE_36803_length_358_cov_1.231579_g35683_i0	PRJNA741997	36803	358	1.231579	4.40905282	Pedosphaera parvula	1032527	Bacteria	Bacteria	351	2.99e-92	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g35683	i0	84.573	76.7653631284916	363	46	100	7	1	358	1719	1362	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	27482	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3272899	3272899	PRJNA741997_P_NODE_57703_length_283_cov_1.223810_g56583_i0	PRJNA741997	57703	283	1.22381	3.4633823	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	230	1.1199999999999998e-55	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g56583	i0	81.404	1.00706713780919	285	50	100	3	1	283	4561378	4561661	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	285	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7100039	7100039	PRJNA741997_P_NODE_22126_length_481_cov_1.745098_g21008_i0	PRJNA741997	22126	481	1.745098	8.39392138	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	776	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g21008	i0	96.017	119.087318087318	477	19	99	0	1	477	3557830	3557354	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	57281	776	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7100279	7100279	PRJNA741997_P_NODE_62846_length_271_cov_1.595960_g61726_i0	PRJNA741997	62846	271	1.59596	4.3250516	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	268	2.2699999999999994e-67	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g61726	i0	84.838	2.76014760147601	277	30	100	10	1	271	1683303	1683033	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	748	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8374850	8374850	PRJNA741997_P_NODE_55687_length_287_cov_2.116822_g54567_i0	PRJNA741997	55687	287	2.116822	6.07527914	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	309	1.4300000000000002e-79	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g54567	i0	86.833	79.0348432055749	281	32	97	5	4	282	1315222	1314945	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	22683	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8375002	8375002	PRJNA741997_P_NODE_76967_length_248_cov_1.017143_g75847_i0	PRJNA741997	76967	248	1.017143	2.52251464	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	392	1.1599999999999999e-104	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g75847	i0	95.181	218.899193548387	249	10	99	2	1	247	17162	16914	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	54287	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10925420	10925420	PRJNA741997_P_NODE_51129_length_301_cov_1.350877_g50009_i0	PRJNA741997	51129	301	1.350877	4.06613977	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	536	6.34e-148	NTclustered	gi\|2021776877\|gb\|MW858385.1\|	156588	g50009	i0	99.324	96.8172757475083	296	2	98	0	1	296	296	1	Uncultured Verrucomicrobia bacterium clone Chel7-1-18 16S ribosomal RNA gene, partial sequence	blastn	29142	536	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12201033	12201033	PRJNA741997_P_NODE_73650_length_250_cov_0.870056_g72530_i0	PRJNA741997	73650	250	0.870056	2.17514	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	416	6.969999999999998e-112	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g72530	i0	97.154	225.636	246	7	98	0	1	246	2744	2499	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	56409	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
13475303	13475303	PRJNA741997_P_NODE_41171_length_338_cov_2.513208_g40051_i0	PRJNA741997	41171	338	2.513208	8.49464304	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g40051	i0	100	0.0887573964497041	30	0	9	0	294	323	4146681	4146652	Lacunisphaera limnophila strain IG16b, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
14750384	14750384	PRJNA741997_P_NODE_39812_length_344_cov_1.110701_g38692_i0	PRJNA741997	39812	344	1.110701	3.82081144	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	228	5.039999999999998e-55	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g38692	i0	80.952	8.83720930232558	294	50	85	6	51	341	3019067	3019357	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3040	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
16024078	16024078	PRJNA741997_P_NODE_47513_length_314_cov_1.278008_g46393_i0	PRJNA741997	47513	314	1.278008	4.01294512	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	254	7.5e-63	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g46393	i0	86.134	70.0891719745223	238	29	75	2	14	249	2387873	2388108	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	22008	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
16024155	16024155	PRJNA741997_P_NODE_61133_length_275_cov_1.524752_g60013_i0	PRJNA741997	61133	275	1.524752	4.193068	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	313	1.05e-80	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g60013	i0	87.143	27.6618181818182	280	31	100	5	1	275	1315750	1315471	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	7607	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17299366	17299366	PRJNA741997_P_NODE_10954_length_762_cov_1.933237_g9937_i0	PRJNA741997	10954	762	1.933237	14.73126594	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1286	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g9937	i0	97.233	105.576115485564	759	21	99	0	1	759	3556542	3557300	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	80449	1286	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
17299702	17299702	PRJNA741997_P_NODE_62154_length_273_cov_1.255000_g61034_i0	PRJNA741997	62154	273	1.255	3.42615	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	322	1.73e-83	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g61034	i0	88.043	93.3919413919414	276	27	100	5	1	273	1658513	1658241	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	25496	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
17299863	17299863	PRJNA741997_P_NODE_89374_length_241_cov_0.916667_g88254_i0	PRJNA741997	89374	241	0.916667	2.20916747	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	215	2.61e-51	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g88254	i0	83.7	1.32780082987552	227	37	94	0	1	227	3205289	3205515	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	320	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
18573242	18573242	PRJNA741997_P_NODE_53915_length_292_cov_1.054795_g52795_i0	PRJNA741997	53915	292	1.054795	3.0800014	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	477	3.77e-130	NTclustered	gi\|544315378\|gb\|KF318288.1\|	156588	g52795	i0	96.233	114	292	10	100	1	1	292	1295	1005	Uncultured Verrucomicrobia bacterium clone ATW049 16S ribosomal RNA gene, partial sequence	blastn	33288	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
21124223	21124223	PRJNA741997_P_NODE_76697_length_248_cov_1.760000_g75577_i0	PRJNA741997	76697	248	1.76	4.3648	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	311	3.35e-80	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g75577	i0	89.431	29.1008064516129	246	26	99	0	3	248	2966783	2967028	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7217	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
21124296	21124296	PRJNA741997_P_NODE_86297_length_243_cov_0.905882_g85177_i0	PRJNA741997	86297	243	0.905882	2.20129326	Pedosphaera parvula	1032527	Bacteria	Bacteria	281	2.57e-71	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g85177	i0	88.235	84.7530864197531	238	25	98	3	7	243	350	115	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	20595	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
21600334	21600334	PRJNA741997_P_NODE_65577_length_265_cov_1.369792_g64457_i0	PRJNA741997	65577	265	1.369792	3.6299488	Nibricoccus	2576890	Bacteria	Bacteria	200	8.17e-47	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g64457	i0	80.934	93.1018867924528	257	45	96	4	11	265	2497639	2497893	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	24672	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
22398948	22398948	PRJNA741997_P_NODE_46938_length_316_cov_1.267490_g45818_i0	PRJNA741997	46938	316	1.26749	4.0052684	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	544	3.999999999999999e-150	NTclustered	gi\|2754040292\|dbj\|LC785839.1\|	2026799	g45818	i0	97.785	100.04746835443	316	6	100	1	1	316	315	1	Verrucomicrobiota bacterium AR-R57HN gene for 16S rRNA, partial sequence	blastn	31615	544	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
22398962	22398962	PRJNA741997_P_NODE_50038_length_305_cov_1.646552_g48918_i0	PRJNA741997	50038	305	1.646552	5.0219836	Pedosphaera parvula	1032527	Bacteria	Bacteria	348	3.2400000000000003e-91	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g48918	i0	87.879	118.373770491803	297	34	97	2	7	303	231	525	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	36104	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
22399203	22399203	PRJNA741997_P_NODE_86518_length_243_cov_0.905882_g85398_i0	PRJNA741997	86518	243	0.905882	2.20129326	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	257	4.32e-64	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g85398	i0	85.95	4.06584362139918	242	32	99	2	3	243	2020440	2020680	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	988	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
24947989	24947989	PRJNA741997_P_NODE_51260_length_301_cov_1.008772_g50140_i0	PRJNA741997	51260	301	1.008772	3.03640372	Pedosphaera parvula	1032527	Bacteria	Bacteria	420	6.67e-113	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g50140	i0	91.803	215.514950166113	305	19	100	5	1	301	1018	716	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	64870	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula

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