metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25537848	25537848	PRJNA1233465b_S_NODE_221137_length_200_cov_4.271523_g219452_i0	PRJNA1233465	221137	200	4.271523	8.543046	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g219452	i0	100	0.145	29	0	15	0	94	122	483848	483876	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25544692	25544692	PRJNA1233465d_S_NODE_74201_length_206_cov_1.624204_g73090_i0	PRJNA1233465	74201	206	1.624204	3.34586024	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	198	2.19e-46	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g73090	i0	89.677	10.9223300970874	155	16	75	0	20	174	855541	855387	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	2250	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
25557349	25557349	PRJNA1233465f_S_NODE_24329_length_430_cov_1.230971_g22079_i0	PRJNA1233465	24329	430	1.230971	5.2931753	Opitutus terrae PB9	107709	Bacteria	Bacteria	540	7.26e-149	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g22079	i0	93.629	8.35116279069767	361	23	84	0	16	376	333590	333230	Opitutus terrae PB90-1, complete genome	blastn	3591	540	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
25560604	25560604	PRJNA1233465f_S_NODE_76073_length_268_cov_2.173516_g73793_i0	PRJNA1233465	76073	268	2.173516	5.82502288	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	115	3.0900000000000003e-21	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g73793	i0	84.483	7.8544776119403	116	18	43	0	86	201	4279922	4279807	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	2105	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25619793	25619793	PRJNA1233465b_S_NODE_189425_length_214_cov_1.630303_g187740_i0	PRJNA1233465	189425	214	1.630303	3.48884842	Pseudomonadati	3379134	Bacteria	Bacteria	128	3.04e-25	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g187740	i0	97.333	67.5841121495327	75	2	35	0	1	75	182997	182923	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	14463	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25682521	25682521	PRJNA1233465e_S_NODE_124858_length_176_cov_1.464567_g123548_i0	PRJNA1233465	124858	176	1.464567	2.57763792	Opitutus terrae PB9	107709	Bacteria	Bacteria	254	3.79e-63	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g123548	i0	92.614	8.32386363636364	176	13	100	0	1	176	333509	333334	Opitutus terrae PB90-1, complete genome	blastn	1465	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
25690075	25690075	PRJNA1233465f_S_NODE_164602_length_193_cov_1.062500_g162322_i0	PRJNA1233465	164602	193	1.0625	2.050625	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	135	1.6100000000000002e-27	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g162322	i0	83.221	4.71502590673575	149	23	77	2	18	165	447173	447026	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	910	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
25697572	25697572	PRJNA1233465f_S_NODE_95826_length_243_cov_2.639175_g93546_i0	PRJNA1233465	95826	243	2.639175	6.41319525	Luteolibacter luteus	2728835	Bacteria	Bacteria	95.3	3.59e-15	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g93546	i0	93.846	59.9135802469136	65	0	25	4	1	61	3802675	3802739	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	14559	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
25755062	25755062	PRJNA1233465a_S_NODE_238418_length_163_cov_0.894737_g237144_i0	PRJNA1233465	238418	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g237144	i0	84.354	9.65644171779141	147	21	90	2	2	147	1777372	1777227	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1574	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
25825750	25825750	PRJNA1233465f_S_NODE_153195_length_199_cov_1.020000_g150915_i0	PRJNA1233465	153195	199	1.02	2.0298	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	255	1.23e-63	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g150915	i0	89.95	43.8743718592965	199	18	99	2	1	198	1027823	1028020	Lacunisphaera limnophila strain IG16b, complete genome	blastn	8731	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
25947036	25947036	PRJNA1233465b_S_NODE_288732_length_178_cov_1.511628_g287047_i0	PRJNA1233465	288732	178	1.511628	2.69069784	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	141	3.12e-29	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g287047	i0	82.609	0.904494382022472	161	26	90	2	1	160	3428695	3428536	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	161	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
25950241	25950241	PRJNA1233465d_S_NODE_130124_length_165_cov_2.551724_g129013_i0	PRJNA1233465	130124	165	2.551724	4.2103446	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	126	8.02e-25	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g129013	i0	80.982	1.42424242424242	163	27	98	4	1	161	3562433	3562273	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	235	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25957854	25957854	PRJNA1233465e_S_NODE_56740_length_244_cov_1.856410_g55430_i0	PRJNA1233465	56740	244	1.85641	4.5296404	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	115	2.77e-21	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g55430	i0	84.483	8.67213114754098	116	18	48	0	90	205	4279807	4279922	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	2116	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25966761	25966761	PRJNA1233465f_S_NODE_266388_length_161_cov_1.366071_g264108_i0	PRJNA1233465	266388	161	1.366071	2.19937431	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	100	4.71e-17	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g264108	i0	83.81	31.1304347826087	105	17	65	0	37	141	4686529	4686633	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	5012	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
26030303	26030303	PRJNA1233465e_S_NODE_130060_length_173_cov_1.629032_g128750_i0	PRJNA1233465	130060	173	1.629032	2.81822536	Pseudomonadati	3379134	Bacteria	Bacteria	137	3.8999999999999995e-28	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g128750	i0	82.278	16.7630057803468	158	28	91	0	1	158	1886596	1886753	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	2900	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
26077168	26077168	PRJNA1233465a_S_NODE_201309_length_173_cov_1.064516_g200035_i0	PRJNA1233465	201309	173	1.064516	1.84161268	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g200035	i0	86.275	36.0520231213873	102	14	59	0	42	143	2162138	2162239	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	6237	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
26092264	26092264	PRJNA1233465e_S_NODE_163901_length_161_cov_1.732143_g162591_i0	PRJNA1233465	163901	161	1.732143	2.78875023	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	76.8	7.94e-10	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g162591	i0	85.333	0.46583850931677	75	9	46	2	82	155	3845829	3845756	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	75	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26094323	26094323	PRJNA1233465e_S_NODE_70261_length_223_cov_1.465517_g68951_i0	PRJNA1233465	70261	223	1.465517	3.26810291	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	268	1.81e-67	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g68951	i0	88.393	42.3452914798206	224	24	100	2	1	223	1028045	1027823	Lacunisphaera limnophila strain IG16b, complete genome	blastn	9443	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
26167733	26167733	PRJNA1233465f_S_NODE_20693_length_459_cov_47.534146_g18465_i0	PRJNA1233465	20693	459	47.534146	218.18173014	Pseudomonadati	3379134	Bacteria	Bacteria	106	3.37e-18	NTclustered	gi\|310755504\|gb\|HQ213394.1\|	296825	g18465	i0	100	31.8671023965142	57	0	12	0	1	57	447	503	Uncultured Opitutus sp. clone 3_O10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	14627	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	uncultured Opitutus sp.
26212428	26212428	PRJNA1233465a_S_NODE_160062_length_190_cov_1.695035_g158788_i0	PRJNA1233465	160062	190	1.695035	3.2205665	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	159	9.349999999999999e-35	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g158788	i0	82.682	1.93684210526316	179	31	94	0	10	188	3428861	3428683	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	368	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
26216465	26216465	PRJNA1233465a_S_NODE_88782_length_240_cov_1.335079_g87508_i0	PRJNA1233465	88782	240	1.335079	3.2041896	Fontisphaera persica	2974023	Bacteria	Bacteria	366	6.79e-97	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g87508	i0	95.259	197.820833333333	232	10	97	1	9	240	3861725	3861955	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	47477	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
26230020	26230020	PRJNA1233465e_S_NODE_53238_length_251_cov_1.009901_g51928_i0	PRJNA1233465	53238	251	1.009901	2.53485151	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.18e-104	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g51928	i0	95.161	1.98804780876494	248	12	99	0	1	248	2003674	2003921	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	499	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26233592	26233592	PRJNA1233465f_S_NODE_140206_length_206_cov_2.777070_g137926_i0	PRJNA1233465	140206	206	2.77707	5.7207642	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	191	3.66e-44	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g137926	i0	88.961	7.71359223300971	154	17	75	0	21	174	855540	855387	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	1589	191	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
26240013	26240013	PRJNA1233465f_S_NODE_47118_length_329_cov_2.214286_g44838_i0	PRJNA1233465	47118	329	2.214286	7.28500094	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	507	5.5e-139	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g44838	i0	94.512	1.93617021276596	328	18	99	0	2	329	2003959	2003632	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	637	507	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26240719	26240719	PRJNA1233465f_S_NODE_64590_length_287_cov_2.693277_g62310_i0	PRJNA1233465	64590	287	2.693277	7.72970499	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	342	1.4099999999999996e-89	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g62310	i0	88.612	1.94425087108014	281	32	98	0	3	283	221617	221337	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	558	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26355767	26355767	PRJNA1233465b_S_NODE_348575_length_164_cov_2.156522_g346890_i0	PRJNA1233465	348575	164	2.156522	3.53669608	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g346890	i0	82.424	74.5792682926829	165	25	99	3	2	164	198817	198979	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	12231	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
26489460	26489460	PRJNA1233465b_S_NODE_149472_length_236_cov_1.598930_g147787_i0	PRJNA1233465	149472	236	1.59893	3.7734748	Fontisphaera persica	2974023	Bacteria	Bacteria	357	4.01e-94	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g147787	i0	94.093	248.021186440678	237	11	100	3	1	236	3861668	3861902	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	58533	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
26492236	26492236	PRJNA1233465b_S_NODE_363088_length_162_cov_1.380531_g361403_i0	PRJNA1233465	363088	162	1.380531	2.23646022	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	172	9.92e-39	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g361403	i0	86.538	57.5185185185185	156	21	96	0	7	162	1724286	1724441	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	9318	172	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
26505804	26505804	PRJNA1233465f_S_NODE_141216_length_206_cov_0.974522_g138936_i0	PRJNA1233465	141216	206	0.974522	2.00751532	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g138936	i0	97.368	50.8883495145631	38	1	18	0	68	105	3195342	3195305	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	10483	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
26509520	26509520	PRJNA1233465f_S_NODE_230664_length_167_cov_3.144068_g228384_i0	PRJNA1233465	230664	167	3.144068	5.25059356	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	67.6	5e-7	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g228384	i0	85.938	0.383233532934132	64	7	38	2	9	71	3845767	3845829	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	64	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium

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