metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA734348" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
3270410	3270410	PRJNA734348_P_NODE_89103_length_253_cov_1.444444_g88405_i0	PRJNA734348	89103	253	1.444444	3.65444332	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	300	7.43e-77	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g88405	i0	88.095	4.64426877470356	252	30	99	0	1	252	6346764	6346513	Opitutaceae bacterium TAV5, complete genome	blastn	1175	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
5822327	5822327	PRJNA734348_P_NODE_69345_length_270_cov_2.131980_g68647_i0	PRJNA734348	69345	270	2.13198	5.756346	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	233	8.229999999999999e-57	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g68647	i0	82.222	14.4296296296296	270	48	100	0	1	270	2108199	2107930	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3896	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7095412	7095412	PRJNA734348_P_NODE_100406_length_249_cov_0.875000_g99708_i0	PRJNA734348	100406	249	0.875	2.17875	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	261	3.44e-65	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g99708	i0	85.542	1	249	36	100	0	1	249	284352	284600	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	249	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
7096791	7096791	PRJNA734348_P_NODE_36326_length_323_cov_24.328000_g35630_i0	PRJNA734348	36326	323	24.328	78.57944	Pedosphaera parvula	1032527	Bacteria	Bacteria	379	1.22e-100	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g35630	i0	89.286	106.882352941176	308	25	94	8	19	323	316	14	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	34523	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7096805	7096805	PRJNA734348_P_NODE_36966_length_321_cov_1.822581_g36270_i0	PRJNA734348	36966	321	1.822581	5.85048501	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	364	3.4099999999999992e-96	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g36270	i0	88.141	81.607476635514	312	30	96	7	1	308	3833132	3833440	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	26196	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7574859	7574859	PRJNA734348_P_NODE_137286_length_236_cov_3.030675_g136588_i0	PRJNA734348	137286	236	3.030675	7.152393	Bacteria	2	Bacteria	Bacteria	292	1.15e-74	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g136588	i0	89.362	65.2669491525424	235	22	99	3	2	236	3831475	3831244	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	15403	294	0.993197278911565	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8370870	8370870	PRJNA734348_P_NODE_148827_length_203_cov_4.600000_g148129_i0	PRJNA734348	148827	203	4.6	9.338	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	128	2.86e-25	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g148129	i0	100	62.1182266009852	69	0	34	0	1	69	1966058	1965990	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	12610	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
10125362	10125362	PRJNA734348_P_NODE_102568_length_248_cov_1.880000_g101870_i0	PRJNA734348	102568	248	1.88	4.6624	Bacteria	2	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g101870	i0	90.361	322.322580645161	249	22	100	2	1	248	27514	27267	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	79936	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10920782	10920782	PRJNA734348_P_NODE_106549_length_247_cov_1.770115_g105851_i0	PRJNA734348	106549	247	1.770115	4.37218405	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g105851	i0	85.217	90.587044534413	230	34	93	0	4	233	61690	61461	Opitutaceae bacterium TAV5, complete genome	blastn	22375	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
10920818	10920818	PRJNA734348_P_NODE_108809_length_247_cov_0.885057_g108111_i0	PRJNA734348	108809	247	0.885057	2.18609079	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	150	7.7e-32	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g108111	i0	79.63	0.874493927125506	216	39	86	5	9	221	5203851	5203638	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	216	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12197213	12197213	PRJNA734348_P_NODE_25390_length_388_cov_1.974603_g24695_i0	PRJNA734348	25390	388	1.974603	7.66145964	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	267	1.22e-66	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g24695	i0	80.052	174.247422680412	381	58	96	18	4	376	2162614	2162244	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	67608	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
12198679	12198679	PRJNA734348_P_NODE_99810_length_249_cov_0.875000_g99112_i0	PRJNA734348	99810	249	0.875	2.17875	Akkermansia muciniphila	239935	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|1805953094\|gb\|CP029699.1\|	239935	g99112	i0	99.587	97.1767068273092	242	1	97	0	8	249	498747	498506	Akkermansia muciniphila strain EB-AMDK-25 chromosome, complete genome	blastn	24197	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
13471945	13471945	PRJNA734348_P_NODE_36871_length_321_cov_3.641129_g36175_i0	PRJNA734348	36871	321	3.641129	11.68802409	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	307	5.82e-79	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g36175	i0	84.356	207.364485981308	326	38	99	11	3	321	2161876	2161557	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	66564	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
14745907	14745907	PRJNA734348_P_NODE_113812_length_245_cov_6.017442_g113114_i0	PRJNA734348	113812	245	6.017442	14.7427329	Coraliomargarita sp.	2024828	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|1275509842\|gb\|MG438537.1\|	2024828	g113114	i0	99.59	99.5918367346939	244	1	99	0	1	244	518	761	Coraliomargarita sp. strain BN_1951 16S ribosomal RNA gene, partial sequence	blastn	24400	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita sp.
14748037	14748037	PRJNA734348_P_NODE_89272_length_253_cov_1.272222_g88574_i0	PRJNA734348	89272	253	1.272222	3.21872166	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	187	6.0299999999999984e-43	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g88574	i0	82.192	34.7509881422925	219	37	86	2	1	218	5133772	5133989	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	8792	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16020090	16020090	PRJNA734348_P_NODE_145133_length_223_cov_6.853333_g144435_i0	PRJNA734348	145133	223	6.853333	15.28293259	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	285	1.7899999999999998e-72	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g144435	i0	96.512	71.3273542600897	172	6	77	0	26	197	2577349	2577520	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	15906	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
16020864	16020864	PRJNA734348_P_NODE_43653_length_305_cov_1.327586_g42956_i0	PRJNA734348	43653	305	1.327586	4.0491373	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	553	6.39e-153	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g42956	i0	99.344	288.849180327869	305	2	100	0	1	305	1321068	1321372	Luteolibacter sp. Populi chromosome, complete genome	blastn	88099	553	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
16021460	16021460	PRJNA734348_P_NODE_75653_length_264_cov_2.230366_g74955_i0	PRJNA734348	75653	264	2.230366	5.88816624	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	58.4	5.18e-4	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g74955	i0	90.698	0.162878787878788	43	4	16	0	31	73	6904911	6904869	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	43	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
16021581	16021581	PRJNA734348_P_NODE_81973_length_259_cov_1.424731_g81275_i0	PRJNA734348	81973	259	1.424731	3.69005329	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	75	5.03e-9	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g81275	i0	94	0.50965250965251	50	2	19	1	211	259	623359	623310	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	132	75	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
16021616	16021616	PRJNA734348_P_NODE_83753_length_257_cov_2.211957_g83055_i0	PRJNA734348	83753	257	2.211957	5.68472949	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	318	2.09e-82	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g83055	i0	97.826	401.420233463035	184	4	72	0	74	257	2498975	2498792	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	103165	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
17295159	17295159	PRJNA734348_P_NODE_121594_length_244_cov_0.900585_g120896_i0	PRJNA734348	121594	244	0.900585	2.1974274	Opitutales bacterium	2026772	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2891482114\|emb\|OZ219848.1\|	2026772	g120896	i0	100	0.114754098360656	28	0	11	0	209	236	258886	258913	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 7	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
19844579	19844579	PRJNA734348_P_NODE_15476_length_539_cov_1.811159_g14793_i0	PRJNA734348	15476	539	1.811159	9.76214701	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	843	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g14793	i0	94.972	118.365491651206	537	27	99	0	1	537	17185	16649	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	63799	843	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
19844804	19844804	PRJNA734348_P_NODE_24876_length_393_cov_0.962500_g24181_i0	PRJNA734348	24876	393	0.9625	3.782625	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	520	8.569999999999998e-143	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g24181	i0	90.633	214.913486005089	395	32	100	5	1	393	2217945	2217554	Luteolibacter sp. LG18 DNA, complete genome	blastn	84461	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
19845086	19845086	PRJNA734348_P_NODE_37876_length_317_cov_9.118852_g37180_i0	PRJNA734348	37876	317	9.118852	28.90676084	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	558	1.44e-154	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g37180	i0	98.423	112.353312302839	317	5	100	0	1	317	2497068	2497384	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	35616	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
21121304	21121304	PRJNA734348_P_NODE_69397_length_270_cov_2.025381_g68699_i0	PRJNA734348	69397	270	2.025381	5.4685287	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	206	1.7999999999999998e-48	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g68699	i0	81.176	2.72222222222222	255	48	94	0	16	270	3403	3657	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	735	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22394673	22394673	PRJNA734348_P_NODE_124498_length_243_cov_0.905882_g123800_i0	PRJNA734348	124498	243	0.905882	2.20129326	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	187	5.7499999999999985e-43	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g123800	i0	81.739	0.946502057613169	230	36	93	6	1	227	3873033	3872807	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	230	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22395038	22395038	PRJNA734348_P_NODE_145398_length_221_cov_7.905405_g144700_i0	PRJNA734348	145398	221	7.905405	17.47094505	uncultured Ruficoccus sp.	2175960	Bacteria	Bacteria	226	1.0899999999999999e-54	NTclustered	gi\|2907625921\|emb\|OZ223481.1\|	2175960	g144700	i0	87.692	216.185520361991	195	23	88	1	8	202	741064	741257	MAG: uncultured Ruficoccus sp. isolate b2a3d85c-2e17-47e2-9e32-7ac6437316b9 genome assembly, chromosome: 10	blastn	47777	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	uncultured Ruficoccus sp.
22395503	22395503	PRJNA734348_P_NODE_31938_length_344_cov_2.239852_g31242_i0	PRJNA734348	31938	344	2.239852	7.70509088	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	540	5.699999999999998e-149	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g31242	i0	95.058	77.796511627907	344	15	99	2	2	344	16340	16682	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	26762	540	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22396122	22396122	PRJNA734348_P_NODE_6578_length_1001_cov_7.658405_g1002_i2	PRJNA734348	6578	1001	7.658405	76.66063405	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1282	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1002	i2	89.921	150.055944055944	1012	79	100	19	1	1001	1316280	1315281	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	150206	1282	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22396447	22396447	PRJNA734348_P_NODE_84198_length_257_cov_1.554348_g83500_i0	PRJNA734348	84198	257	1.554348	3.99467436	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	121	6.319999999999999e-23	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g83500	i0	75.875	1	257	50	96	12	1	248	2495404	2495151	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	257	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
24945040	24945040	PRJNA734348_P_NODE_61400_length_278_cov_1.682927_g60703_i0	PRJNA734348	61400	278	1.682927	4.67853706	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	492	1.27e-134	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g60703	i0	98.561	191.025179856115	278	4	100	0	1	278	727	450	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	53105	492	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis

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