metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
836760	836760	PRJNA849172_P_NODE_58401_length_283_cov_2.038095_g58041_i0	PRJNA849172	58401	283	2.038095	5.76780885	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	512	9.97e-141	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g58041	i0	99.293	1	283	2	100	0	1	283	2649871	2649589	Luteolibacter sp. SL250 chromosome	blastn	283	512	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
837489	837489	PRJNA849172_P_NODE_82281_length_257_cov_7.271739_g81921_i0	PRJNA849172	82281	257	7.271739	18.68836923	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	254	5.970000000000001e-63	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g81921	i0	86.325	0.910505836575875	234	31	91	1	25	257	2414029	2413796	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	234	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
3386214	3386214	PRJNA849172_P_NODE_15763_length_525_cov_9.314159_g15404_i0	PRJNA849172	15763	525	9.314159	48.89933475	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	942	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g15404	i0	99.049	4.27809523809524	526	4	100	1	1	525	3395916	3395391	Luteolibacter sp. SL250 chromosome	blastn	2246	942	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
4663651	4663651	PRJNA849172_P_NODE_14084_length_560_cov_2.726899_g13725_i0	PRJNA849172	14084	560	2.726899	15.2706344	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	983	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g13725	i0	98.393	253.348214285714	560	8	100	1	1	560	1262	704	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	141875	983	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
5938213	5938213	PRJNA849172_P_NODE_133545_length_216_cov_4.440559_g133185_i0	PRJNA849172	133545	216	4.440559	9.59160744	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	206	1.3799999999999998e-48	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g133185	i0	83.871	97.212962962963	217	33	100	2	1	216	2448294	2448079	Luteolibacter sp. SL250 chromosome	blastn	20998	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7215524	7215524	PRJNA849172_P_NODE_79226_length_260_cov_3.866310_g78866_i0	PRJNA849172	79226	260	3.86631	10.052406	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	206	1.7199999999999998e-48	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g78866	i0	82.231	1.83076923076923	242	39	92	4	1	240	3601896	3601657	Luteolibacter sp. Populi chromosome, complete genome	blastn	476	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
8488520	8488520	PRJNA849172_P_NODE_2227_length_1469_cov_18.004298_g2062_i0	PRJNA849172	2227	1469	18.004298	264.48313762	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1570	0	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g2062	i0	87.527	196.74540503744	1371	155	93	15	109	1469	2364709	2366073	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	289019	1570	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9762820	9762820	PRJNA849172_P_NODE_125208_length_228_cov_2.012903_g124848_i0	PRJNA849172	125208	228	2.012903	4.5894188400000004	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	405	1.35e-108	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g124848	i0	98.684	1	228	3	100	0	1	228	1048490	1048717	Luteolibacter sp. SL250 chromosome	blastn	228	405	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
11038308	11038308	PRJNA849172_P_NODE_119309_length_232_cov_4.691824_g118949_i0	PRJNA849172	119309	232	4.691824	10.88503168	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	313	8.62e-81	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g118949	i0	90.948	1	232	21	100	0	1	232	2930749	2930980	Lacunisphaera limnophila strain IG16b, complete genome	blastn	232	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
11039726	11039726	PRJNA849172_P_NODE_33309_length_356_cov_1.653710_g32950_i0	PRJNA849172	33309	356	1.65371	5.8872076	Methylacidiphilum caldifontis	2795386	Bacteria	Bacteria	318	3.01e-82	NTclustered	gi\|1999107441\|gb\|CP065957.1\|	2795386	g32950	i0	86.926	107.707865168539	283	37	79	0	72	354	841089	840807	Methylacidiphilum caldifontis strain IT6 chromosome, complete genome	blastn	38344	318	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Methylacidiphilum caldifontis
12316143	12316143	PRJNA849172_P_NODE_65290_length_275_cov_1.212871_g64930_i0	PRJNA849172	65290	275	1.212871	3.33539525	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	497	2.7e-136	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g64930	i0	99.273	5.52	275	2	100	0	1	275	4253738	4253464	Luteolibacter sp. SL250 chromosome	blastn	1518	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
12711909	12711909	PRJNA849172_P_NODE_2190_length_1480_cov_28.129353_g1864_i1	PRJNA849172	2190	1480	28.129353	416.3144244	Verrucomicrobiota	74201	Bacteria	Bacteria	1960	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g1864	i1	91.649	154.700675675676	1425	105	96	12	1	1417	913	2331	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	228957	1960	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
13587807	13587807	PRJNA849172_P_NODE_102871_length_245_cov_0.895349_g102511_i0	PRJNA849172	102871	245	0.895349	2.19360505	Coraliomargarita algicola	3092156	Bacteria	Bacteria	62.1	3.67e-5	NTclustered	gi\|2623481368\|gb\|CP138858.1\|	3092156	g102511	i0	100	0.13469387755102	33	0	13	0	1	33	4398708	4398676	Coraliomargarita algicola strain J2-16 chromosome, complete genome	blastn	33	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita algicola
13588298	13588298	PRJNA849172_P_NODE_119531_length_232_cov_3.729560_g119171_i0	PRJNA849172	119531	232	3.72956	8.6525792	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	198	2.52e-46	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g119171	i0	84.804	51.5	204	24	87	4	29	230	3433910	3433712	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	11948	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
13591383	13591383	PRJNA849172_P_NODE_88231_length_253_cov_0.866667_g87871_i0	PRJNA849172	88231	253	0.866667	2.19266751	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	161	3.6599999999999995e-35	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g87871	i0	85.093	0.636363636363636	161	21	63	3	13	172	658092	657934	Lacunisphaera limnophila strain IG16b, complete genome	blastn	161	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
13591665	13591665	PRJNA849172_P_NODE_98211_length_247_cov_1.793103_g97851_i0	PRJNA849172	98211	247	1.793103	4.42896441	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g97851	i0	87.5	0.680161943319838	168	19	68	2	78	245	3152616	3152781	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	168	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
17413166	17413166	PRJNA849172_P_NODE_132474_length_217_cov_6.652778_g132114_i0	PRJNA849172	132474	217	6.652778	14.43652826	Actomonas aquatica	2866162	Bacteria	Bacteria	198	2.3299999999999997e-46	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g132114	i0	85.638	82.9953917050691	188	27	87	0	14	201	1594631	1594818	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	18010	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica
18685478	18685478	PRJNA849172_P_NODE_104055_length_244_cov_1.824561_g103695_i0	PRJNA849172	104055	244	1.824561	4.45192884	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	416	6.769999999999999e-112	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g103695	i0	97.531	5.32786885245902	243	6	99	0	1	243	170586	170828	Luteolibacter sp. SL250 chromosome	blastn	1300	416	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
19963250	19963250	PRJNA849172_P_NODE_59376_length_282_cov_1.401914_g59016_i0	PRJNA849172	59376	282	1.401914	3.95339748	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	95.3	4.26e-15	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g59016	i0	86.364	0.312056737588652	88	10	31	1	195	282	4519810	4519895	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	88	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
19964124	19964124	PRJNA849172_P_NODE_88776_length_252_cov_3.156425_g88416_i0	PRJNA849172	88776	252	3.156425	7.954191	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	272	1.6099999999999999e-68	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g88416	i0	86.111	7.83333333333333	252	35	100	0	1	252	5821389	5821138	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	1974	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
20358704	20358704	PRJNA849172_P_NODE_2016_length_1540_cov_33.134288_g1864_i0	PRJNA849172	2016	1540	33.134288	510.2680352	Verrucomicrobiota	74201	Bacteria	Bacteria	2036	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g1864	i0	92.469	126.595454545455	1434	92	93	14	1	1427	913	2337	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	194957	2047	0.994626282364436	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
21237510	21237510	PRJNA849172_P_NODE_15017_length_540_cov_2.601713_g14658_i0	PRJNA849172	15017	540	2.601713	14.0492502	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	854	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g14658	i0	95.833	154.672222222222	528	22	98	0	1	528	3557083	3557610	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	83523	854	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21238767	21238767	PRJNA849172_P_NODE_55437_length_287_cov_1.883178_g55077_i0	PRJNA849172	55437	287	1.883178	5.40472086	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	514	2.82e-141	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g55077	i0	98.955	1.11498257839721	287	3	100	0	1	287	1700094	1699808	Luteolibacter sp. SL250 chromosome	blastn	320	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
21239473	21239473	PRJNA849172_P_NODE_79417_length_260_cov_2.919786_g79057_i0	PRJNA849172	79417	260	2.919786	7.5914436	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	130	1.06e-25	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g79057	i0	96.25	51.2423076923077	80	2	31	1	25	104	673659	673581	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	13323	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23786602	23786602	PRJNA849172_P_NODE_108399_length_242_cov_1.414201_g108039_i0	PRJNA849172	108399	242	1.414201	3.42236642	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	254	5.57e-63	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g108039	i0	89.552	2.00413223140496	201	19	83	2	1	200	1757582	1757781	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	485	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1

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