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

31 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
749049	749049	PRJNA773247_P_NODE_37301_length_202_cov_5.364341_g37217_i0	PRJNA773247	37301	202	5.364341	10.83596882	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	222	1.27e-53	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g37217	i0	87.245	92.7326732673267	196	23	97	2	8	202	4667806	4668000	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	18732	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2024656	2024656	PRJNA773247_P_NODE_15262_length_380_cov_1.768730_g15178_i0	PRJNA773247	15262	380	1.76873	6.721174	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	222	2.61e-53	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g15178	i0	83.761	1.64473684210526	234	38	62	0	147	380	4301783	4302016	Luteolibacter sp. SL250 chromosome	blastn	625	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2024692	2024692	PRJNA773247_P_NODE_17522_length_348_cov_4.272727_g17438_i0	PRJNA773247	17522	348	4.272727	14.86908996	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	268	3.01e-67	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g17438	i0	86.29	2.47988505747126	248	32	71	2	10	256	2899766	2900012	Luteolibacter sp. SL250 chromosome	blastn	863	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2024871	2024871	PRJNA773247_P_NODE_29282_length_255_cov_5.967033_g29198_i0	PRJNA773247	29282	255	5.967033	15.21593415	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	270	5.88e-68	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g29198	i0	86.29	2.0156862745098	248	34	97	0	5	252	4253889	4254136	Luteolibacter sp. SL250 chromosome	blastn	514	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2024910	2024910	PRJNA773247_P_NODE_32382_length_246_cov_1.780347_g32298_i0	PRJNA773247	32382	246	1.780347	4.37965362	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	316	7.14e-82	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g32298	i0	89.837	2.98373983739837	246	25	100	0	1	246	2998620	2998375	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	734	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
3299866	3299866	PRJNA773247_P_NODE_12983_length_421_cov_1.344828_g12900_i0	PRJNA773247	12983	421	1.344828	5.66172588	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	392	2.1e-104	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g12900	i0	83.532	0.995249406175772	419	69	99	0	3	421	3189528	3189946	Luteolibacter sp. Populi chromosome, complete genome	blastn	419	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
3300093	3300093	PRJNA773247_P_NODE_29103_length_256_cov_6.704918_g29019_i0	PRJNA773247	29103	256	6.704918	17.16459008	Opitutus terrae	107709	Bacteria	Bacteria	185	2.2e-42	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g29019	i0	80.321	1.23828125	249	45	96	4	1	247	3126910	3127156	Opitutus terrae PB90-1, complete genome	blastn	317	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
3300115	3300115	PRJNA773247_P_NODE_30483_length_251_cov_0.865169_g30399_i0	PRJNA773247	30483	251	0.865169	2.17157419	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	119	2.21e-22	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g30399	i0	75.494	1.00796812749004	253	57	100	5	1	251	5339235	5338986	Opitutaceae bacterium TAV5, complete genome	blastn	253	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
4577277	4577277	PRJNA773247_P_NODE_36264_length_229_cov_3.141026_g36180_i0	PRJNA773247	36264	229	3.141026	7.19294954	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	215	2.46e-51	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g36180	i0	84.279	1	229	27	98	9	4	227	1797505	1797281	Luteolibacter sp. SL250 chromosome	blastn	229	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
5852223	5852223	PRJNA773247_P_NODE_11925_length_444_cov_10.808625_g11842_i0	PRJNA773247	11925	444	10.808625	47.990295	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	137	1.1500000000000002e-27	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g11842	i0	93.478	1.6463963963964	92	6	21	0	238	329	3585085	3584994	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	731	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
9677344	9677344	PRJNA773247_P_NODE_24268_length_285_cov_6.150943_g24184_i0	PRJNA773247	24268	285	6.150943	17.53018755	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	99	3.33e-16	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g24184	i0	84.158	0.354385964912281	101	16	35	0	9	109	7411673	7411573	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	101	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
9677422	9677422	PRJNA773247_P_NODE_2948_length_1139_cov_62.032833_g2889_i0	PRJNA773247	2948	1139	62.032833	706.55396787	Luteolibacter luteus	2728835	Bacteria	Bacteria	424	2.13e-113	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g2889	i0	76.645	0.964003511852502	775	175	68	6	346	1117	3620507	3621278	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	1098	424	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
10952766	10952766	PRJNA773247_P_NODE_1169_length_1798_cov_2.977971_g1143_i0	PRJNA773247	1169	1798	2.977971	53.54391858	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	699	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g1143	i0	76.72	0.902113459399333	1323	267	75	34	50	1357	3371399	3372695	Luteolibacter sp. SL250 chromosome	blastn	1622	699	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10953216	10953216	PRJNA773247_P_NODE_7089_length_626_cov_30.441230_g7006_i0	PRJNA773247	7089	626	30.44123	190.5620998	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	804	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g7006	i0	90.129	3.48402555910543	618	61	99	0	9	626	432552	431935	Luteolibacter sp. SL250 chromosome	blastn	2181	804	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
13502435	13502435	PRJNA773247_P_NODE_14851_length_386_cov_7.386581_g14767_i0	PRJNA773247	14851	386	7.386581	28.51220266	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	279	1.55e-70	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g14767	i0	80.376	3.59585492227979	372	69	96	4	11	380	2309300	2308931	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	1388	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
13502472	13502472	PRJNA773247_P_NODE_17211_length_352_cov_1.455197_g17127_i0	PRJNA773247	17211	352	1.455197	5.12229344	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	309	1.7900000000000002e-79	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g17127	i0	89.328	9.77556818181818	253	17	73	8	1	253	826218	826460	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	3441	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
14777616	14777616	PRJNA773247_P_NODE_19832_length_322_cov_9.353414_g19748_i0	PRJNA773247	19832	322	9.353414	30.11799308	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	326	1.61e-84	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g19748	i0	85.397	4.75465838509317	315	44	98	2	1	314	1794338	1794651	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1531	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
16051235	16051235	PRJNA773247_P_NODE_10773_length_474_cov_17.301746_g10690_i0	PRJNA773247	10773	474	17.301746	82.01027604	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	202	4.3299999999999997e-47	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10690	i0	84.211	1.93459915611814	209	31	44	2	1	208	3736580	3736373	Luteolibacter sp. SL250 chromosome	blastn	917	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
17327315	17327315	PRJNA773247_P_NODE_31574_length_248_cov_1.051429_g31490_i0	PRJNA773247	31574	248	1.051429	2.60754392	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	174	4.59e-39	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g31490	i0	80.085	7.39112903225806	236	45	95	2	7	241	1039572	1039338	Luteolibacter sp. LG18 DNA, complete genome	blastn	1833	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
21151416	21151416	PRJNA773247_P_NODE_2197_length_1347_cov_11.448980_g2150_i0	PRJNA773247	2197	1347	11.44898	154.2177606	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	800	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2150	i0	79.91	5.38827023014105	1105	211	82	11	104	1201	1696497	1695397	Luteolibacter sp. SL250 chromosome	blastn	7258	800	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
21151621	21151621	PRJNA773247_P_NODE_3837_length_961_cov_13.692568_g3770_i0	PRJNA773247	3837	961	13.692568	131.58557848	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	547	1.02e-150	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g3770	i0	77.57	10.8844953173777	963	178	98	28	1	939	2659525	2660473	Luteolibacter sp. SL250 chromosome	blastn	10460	547	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22426155	22426155	PRJNA773247_P_NODE_21738_length_305_cov_1.237069_g21654_i0	PRJNA773247	21738	305	1.237069	3.77306045	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	272	1.9999999999999993e-68	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g21654	i0	83.737	3.62295081967213	289	46	94	1	18	305	1227866	1228154	Luteolibacter sp. SL250 chromosome	blastn	1105	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22426204	22426204	PRJNA773247_P_NODE_2558_length_1241_cov_2.373288_g2506_i0	PRJNA773247	2558	1241	2.373288	29.45250408	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	556	2.1999999999999995e-153	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g2506	i0	86.8	1.09186140209508	500	64	40	2	741	1239	1800834	1801332	Luteolibacter sp. SL250 chromosome	blastn	1355	556	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22426221	22426221	PRJNA773247_P_NODE_27138_length_267_cov_2.664948_g27054_i0	PRJNA773247	27138	267	2.664948	7.11541116	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	222	1.76e-53	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g27054	i0	81.852	1.64794007490637	270	43	100	6	1	267	3491697	3491963	Lacunisphaera limnophila strain IG16b, complete genome	blastn	440	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
23701652	23701652	PRJNA773247_P_NODE_11479_length_455_cov_6.916230_g11396_i0	PRJNA773247	11479	455	6.91623	31.4688465	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	113	2e-20	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11396	i0	83.065	2.24615384615385	124	21	27	0	1	124	55452	55575	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1022	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23701690	23701690	PRJNA773247_P_NODE_13619_length_408_cov_4.107463_g13535_i0	PRJNA773247	13619	408	4.107463	16.75844904	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	279	1.65e-70	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g13535	i0	81.711	1.66666666666667	339	58	83	3	61	397	976098	975762	Luteolibacter sp. LG18 DNA, complete genome	blastn	680	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23701882	23701882	PRJNA773247_P_NODE_27859_length_263_cov_2.626316_g27775_i0	PRJNA773247	27859	263	2.626316	6.90721108	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	320	5.96e-83	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g27775	i0	88.889	46.787072243346	261	27	99	2	2	261	3175419	3175678	Luteolibacter sp. SL250 chromosome	blastn	12305	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
23702034	23702034	PRJNA773247_P_NODE_4979_length_801_cov_16.877747_g4904_i0	PRJNA773247	4979	801	16.877747	135.19075347	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	525	3.939999999999999e-144	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g4904	i0	80	0.923845193508115	740	125	91	18	3	732	594190	594916	Luteolibacter sp. SL250 chromosome	blastn	740	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
23702087	23702087	PRJNA773247_P_NODE_7359_length_610_cov_23.832402_g7276_i0	PRJNA773247	7359	610	23.832402	145.3776522	Luteolibacter luteus	2728835	Bacteria	Bacteria	592	2.88e-164	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g7276	i0	84.564	4.93606557377049	596	92	98	0	8	603	4596169	4595574	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	3011	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
23702096	23702096	PRJNA773247_P_NODE_779_length_2137_cov_9.338663_g764_i0	PRJNA773247	779	2137	9.338663	199.56722831	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1173	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g764	i0	81.767	3.10294805802527	1415	247	66	11	611	2019	1248096	1246687	Luteolibacter sp. SL250 chromosome	blastn	6631	1173	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24975345	24975345	PRJNA773247_P_NODE_12860_length_423_cov_11.231429_g12777_i0	PRJNA773247	12860	423	11.231429	47.50894467	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	215	4.91e-51	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g12777	i0	87.234	4.76832151300236	188	24	44	0	137	324	2852527	2852714	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	2017	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134

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