metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392433	392433	PRJNA340009_P_NODE_60981_length_168_cov_1.453782_g60674_i0	PRJNA340009	60981	168	1.453782	2.44235376	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	291	2.75e-74	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g60674	i0	98.204	278.333333333333	167	1	99	2	2	168	1745	1581	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	46760	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
392443	392443	PRJNA340009_P_NODE_61641_length_167_cov_1.703390_g61334_i0	PRJNA340009	61641	167	1.70339	2.8446613	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	150	4.83e-32	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g61334	i0	83.333	0.970059880239521	162	27	97	0	6	167	1504986	1505147	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	162	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
1666655	1666655	PRJNA340009_P_NODE_27922_length_234_cov_1.929730_g27615_i0	PRJNA340009	27922	234	1.92973	4.5155682	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g27615	i0	100	0.11965811965812	28	0	12	0	158	185	1383633	1383606	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
1666702	1666702	PRJNA340009_P_NODE_32102_length_221_cov_1.127907_g31795_i0	PRJNA340009	32102	221	1.127907	2.49267447	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	176	1.1099999999999999e-39	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g31795	i0	82.547	55.2217194570136	212	26	94	9	5	211	2749769	2749974	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	12204	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1667026	1667026	PRJNA340009_P_NODE_62202_length_167_cov_0.864407_g61895_i0	PRJNA340009	62202	167	0.864407	1.44355969	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	102	1.37e-17	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g61895	i0	83.486	3.02994011976048	109	18	65	0	42	150	6319503	6319611	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	506	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
1667121	1667121	PRJNA340009_P_NODE_70802_length_163_cov_1.754386_g70495_i0	PRJNA340009	70802	163	1.754386	2.85964918	Luteolibacter sp.	1962973	Bacteria	Bacteria	226	7.559999999999997e-55	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g70495	i0	94.521	188.760736196319	146	8	90	0	7	152	1010069	1009924	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	30768	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
2345286	2345286	PRJNA340009_P_NODE_19522_length_272_cov_84.784753_g19215_i0	PRJNA340009	19522	272	84.784753	230.61452816	Prosthecobacter	48463	Bacteria	Bacteria	278	3.78e-70	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g19215	i0	91.176	245.992647058824	204	18	93	0	68	271	2193	2396	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	66910	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
2345481	2345481	PRJNA340009_P_NODE_58802_length_171_cov_1.327869_g58495_i0	PRJNA340009	58802	171	1.327869	2.27065599	Verrucomicrobiota	74201	Bacteria	Bacteria	80.5	6.57e-11	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g58495	i0	97.826	1.50877192982456	46	1	27	0	126	171	1235151	1235106	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	258	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4219256	4219256	PRJNA340009_P_NODE_24804_length_246_cov_4.522843_g24497_i0	PRJNA340009	24804	246	4.522843	11.12619378	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	279	9.36e-71	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g24497	i0	89.593	162.731707317073	221	21	89	1	18	236	5152376	5152596	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	40032	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4219471	4219471	PRJNA340009_P_NODE_42724_length_196_cov_0.782313_g42417_i0	PRJNA340009	42724	196	0.782313	1.53333348	Chthoniobacter flavus	191863	Bacteria	Bacteria	289	1.1899999999999998e-73	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g42417	i0	93.333	185.44387755102	195	13	99	0	1	195	532	338	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	36347	289	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
4219638	4219638	PRJNA340009_P_NODE_58604_length_171_cov_1.672131_g58297_i0	PRJNA340009	58604	171	1.672131	2.85934401	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	97.1	6.52e-16	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g58297	i0	77.457	1.01169590643275	173	31	99	7	2	171	2197852	2198019	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	173	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
5496179	5496179	PRJNA340009_P_NODE_73945_length_162_cov_0.902655_g73638_i0	PRJNA340009	73945	162	0.902655	1.4623011	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	204	3.52e-48	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g73638	i0	90.789	45.2962962962963	152	14	94	0	1	152	15441	15592	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	7338	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
8045722	8045722	PRJNA340009_P_NODE_65287_length_166_cov_0.871795_g64980_i0	PRJNA340009	65287	166	0.871795	1.4471797	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	226	7.739999999999998e-55	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g64980	i0	92.949	12.2409638554217	156	10	94	1	1	156	278426	278272	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2032	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9320116	9320116	PRJNA340009_P_NODE_32968_length_218_cov_3.118343_g32661_i0	PRJNA340009	32968	218	3.118343	6.79798774	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	359	1.01e-94	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g32661	i0	96.744	274.811926605505	215	7	99	0	4	218	2052	2266	Luteolibacter sp. SL250 chromosome	blastn	59909	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
11870797	11870797	PRJNA340009_P_NODE_39390_length_202_cov_6.359477_g39083_i0	PRJNA340009	39390	202	6.359477	12.84614354	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	124	3.669999999999999e-24	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g39083	i0	85.593	0.584158415841584	118	17	58	0	66	183	2345523	2345640	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	118	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
11871074	11871074	PRJNA340009_P_NODE_63230_length_167_cov_0.864407_g62923_i0	PRJNA340009	63230	167	0.864407	1.44355969	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	147	6.25e-31	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g62923	i0	86.466	1.74850299401198	133	18	80	0	29	161	103401	103533	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	292	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
13145991	13145991	PRJNA340009_P_NODE_57531_length_172_cov_3.317073_g57224_i0	PRJNA340009	57531	172	3.317073	5.70536556	Verrucomicrobium spinosum	2736	Bacteria	Bacteria	139	1.08e-28	NTclustered	gi\|12583973\|gb\|AF245377.1\|	240016	g57224	i0	81.765	274.877906976744	170	28	97	3	6	172	2724	2555	Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence	blastn	47279	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
14421171	14421171	PRJNA340009_P_NODE_61452_length_167_cov_1.966102_g61145_i0	PRJNA340009	61452	167	1.966102	3.28339034	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g61145	i0	95.122	252.155688622754	164	8	98	0	4	167	2218598	2218435	Luteolibacter sp. LG18 DNA, complete genome	blastn	42110	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
14421307	14421307	PRJNA340009_P_NODE_73192_length_162_cov_1.805310_g72885_i0	PRJNA340009	73192	162	1.80531	2.9246022	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g72885	i0	90.798	156.259259259259	163	14	100	1	1	162	3411085	3411247	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	25314	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
15695108	15695108	PRJNA340009_P_NODE_66893_length_165_cov_0.879310_g66586_i0	PRJNA340009	66893	165	0.87931	1.4508615	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g66586	i0	92.727	2	165	12	100	0	1	165	518125	518289	Lacunisphaera limnophila strain IG16b, complete genome	blastn	330	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
15695207	15695207	PRJNA340009_P_NODE_76353_length_161_cov_0.910714_g76046_i0	PRJNA340009	76353	161	0.910714	1.46624954	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	91.6	2.83e-14	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g76046	i0	84.211	1.16149068322981	95	13	58	2	1	94	6545897	6545804	Opitutaceae bacterium TAV5, complete genome	blastn	187	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
19517964	19517964	PRJNA340009_P_NODE_36656_length_208_cov_52.949686_g36349_i0	PRJNA340009	36656	208	52.949686	110.13534688	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	213	7.9e-51	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g36349	i0	85.096	7.0625	208	31	100	0	1	208	1902834	1903041	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	1469	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
19518241	19518241	PRJNA340009_P_NODE_62096_length_167_cov_0.864407_g61789_i0	PRJNA340009	62096	167	0.864407	1.44355969	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	117	4.900000000000001e-22	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g61789	i0	80.38	0.946107784431138	158	28	93	3	12	167	675318	675162	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	158	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
20793344	20793344	PRJNA340009_P_NODE_20037_length_269_cov_28.904545_g19730_i0	PRJNA340009	20037	269	28.904545	77.75322605	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	241	4.900000000000001e-59	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g19730	i0	92.899	115.981412639405	169	6	61	5	95	259	1316512	1316678	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	31199	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22068724	22068724	PRJNA340009_P_NODE_46498_length_189_cov_1.307143_g46191_i0	PRJNA340009	46498	189	1.307143	2.47050027	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	204	4.2299999999999997e-48	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g46191	i0	87.027	1.95238095238095	185	19	96	3	8	189	2954183	2954001	Lacunisphaera limnophila strain IG16b, complete genome	blastn	369	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
22069047	22069047	PRJNA340009_P_NODE_74738_length_162_cov_0.902655_g74431_i0	PRJNA340009	74738	162	0.902655	1.4623011	Horticoccus luteus	2862869	Bacteria	Bacteria	165	1.66e-36	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g74431	i0	86.184	0.938271604938272	152	21	94	0	1	152	2249289	2249440	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	152	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
23343981	23343981	PRJNA340009_P_NODE_27779_length_234_cov_6.897297_g27472_i0	PRJNA340009	27779	234	6.897297	16.13967498	Akkermansia muciniphila	239935	Bacteria	Bacteria	167	7.1699999999999995e-37	NTclustered	gi\|2623923984\|gb\|CP115935.1\|	239935	g27472	i0	82.888	73.6538461538462	187	30	79	2	49	234	1133528	1133343	Akkermansia muciniphila strain SDLYAKK8 chromosome, complete genome	blastn	17235	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24618480	24618480	PRJNA340009_P_NODE_53120_length_178_cov_90.527132_g52813_i0	PRJNA340009	53120	178	90.527132	161.13829496	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	122	1.13e-23	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g52813	i0	100	19.3820224719101	66	0	37	0	30	95	3049018	3048953	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	3450	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
24618529	24618529	PRJNA340009_P_NODE_58040_length_172_cov_1.349593_g57733_i0	PRJNA340009	58040	172	1.349593	2.32129996	Akkermansia sp. AE01SA01	3115151	Bacteria	Bacteria	307	2.79e-79	NTclustered	gi\|2669347435\|gb\|CP143890.1\|	3115151	g57733	i0	98.837	2	172	2	100	0	1	172	1761166	1760995	Akkermansia sp. AE01SA01 chromosome, complete genome	blastn	344	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. AE01SA01

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