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

29 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax_phylum = "Thermodesulfobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
948135	948135	PRJNA976345_P_NODE_184981_length_154_cov_1.521008_g183373_i0	PRJNA976345	184981	154	1.521008	2.34235232	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	230	5.439999999999998e-56	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g183373	i0	98.462	3.61688311688312	130	2	100	0	25	154	498614	498743	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	557	230	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
948151	948151	PRJNA976345_P_NODE_187461_length_153_cov_1.974576_g185853_i0	PRJNA976345	187461	153	1.974576	3.02110128	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	54.7	0.003	NTclustered	gi\|2621702214\|emb\|OY760196.1\|	3065857	g185853	i0	100	0.379084967320261	29	0	19	0	65	93	818247	818219	MAG: Geopsychrobacteraceae bacterium isolate 3ac22823-4ae2-415b-96ed-595fc0828211 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
948366	948366	PRJNA976345_P_NODE_31341_length_302_cov_2.404494_g29735_i0	PRJNA976345	31341	302	2.404494	7.26157188	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	361	4.109999999999999e-95	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g29735	i0	89.474	4.36092715231788	285	30	94	0	18	302	2780257	2780541	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	1317	361	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
948725	948725	PRJNA976345_P_NODE_67041_length_220_cov_1.718919_g65433_i0	PRJNA976345	67041	220	1.718919	3.7816218	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	372	1.32e-98	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g65433	i0	97.26	7.67272727272727	219	6	99	0	2	220	3350706	3350924	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	1688	372	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
2223186	2223186	PRJNA976345_P_NODE_135582_length_173_cov_1.152174_g133974_i0	PRJNA976345	135582	173	1.152174	1.99326102	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	209	8.15e-50	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g133974	i0	88.439	1	173	20	100	0	1	173	2118655	2118827	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	173	209	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
2223537	2223537	PRJNA976345_P_NODE_199382_length_150_cov_1.382609_g197774_i0	PRJNA976345	199382	150	1.382609	2.0739135	Desulfovibrio sp. 86	2666132	Bacteria	Bacteria	211	1.9e-50	NTclustered	gi\|1862956133\|emb\|LR738849.1\|	2666132	g197774	i0	92	10.2266666666667	150	12	100	0	1	150	770246	770395	Desulfovibrio sp. 86 genome assembly, chromosome: DESU86	blastn	1534	211	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 86
4777246	4777246	PRJNA976345_P_NODE_99324_length_190_cov_2.161290_g97716_i0	PRJNA976345	99324	190	2.16129	4.106451	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	182	2e-41	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g97716	i0	83.962	1.11578947368421	212	10	99	6	1	188	319084	318873	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	212	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
6051062	6051062	PRJNA976345_P_NODE_142105_length_170_cov_1.170370_g140497_i0	PRJNA976345	142105	170	1.17037	1.989629	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g140497	i0	98.235	2.00588235294118	170	3	100	0	1	170	1043323	1043154	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	341	298	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
7326251	7326251	PRJNA976345_P_NODE_32146_length_299_cov_1.787879_g30540_i0	PRJNA976345	32146	299	1.787879	5.34575821	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	420	6.62e-113	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g30540	i0	91.973	2.99665551839465	299	24	100	0	1	299	1542831	1543129	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	896	420	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
8601611	8601611	PRJNA976345_P_NODE_61107_length_228_cov_1.642487_g59499_i0	PRJNA976345	61107	228	1.642487	3.74487036	Pseudodesulfovibrio profundus	57320	Bacteria	Bacteria	388	1.3599999999999998e-103	NTclustered	gi\|1248817418\|emb\|LT907975.1\|	57320	g59499	i0	97.368	22.0175438596491	228	6	100	0	1	228	464334	464107	Desulfovibrio profundus strain 500-1 genome assembly, chromosome: DPRO	blastn	5020	388	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio profundus
9875729	9875729	PRJNA976345_P_NODE_100748_length_189_cov_2.175325_g99140_i0	PRJNA976345	100748	189	2.175325	4.11136425	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	134	5.630000000000001e-27	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g99140	i0	98.667	1.64021164021164	75	1	85	0	115	189	834956	835030	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	310	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
11152312	11152312	PRJNA976345_P_NODE_69829_length_216_cov_4.856354_g68221_i0	PRJNA976345	69829	216	4.856354	10.48972464	Desulfohalobium retbaense	45663	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|257796365\|gb\|CP001734.1\|	485915	g68221	i0	96.875	0.148148148148148	32	1	15	0	175	206	2376077	2376046	Desulfohalobium retbaense DSM 5692, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfohalobium	Desulfohalobium retbaense
11152467	11152467	PRJNA976345_P_NODE_88329_length_198_cov_3.104294_g86721_i0	PRJNA976345	88329	198	3.104294	6.14650212	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	156	1.27e-33	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g86721	i0	94.949	2.94444444444444	99	5	98	0	100	198	936041	935943	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	583	156	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
11471025	11471025	PRJNA976345_P_NODE_198249_length_150_cov_1.886957_g196641_i0	PRJNA976345	198249	150	1.886957	2.8304355	Desulfovibrio	872	Bacteria	Bacteria	148	1.51e-31	NTclustered	gi\|1894914451\|emb\|LT984798.1\|	631220	g196641	i0	88.525	5.46666666666667	122	14	81	0	24	145	1064701	1064822	Desulfovibrio sp. G11 isolate G11PacBio genome assembly, chromosome: 1	blastn	820	148	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. G11
12427450	12427450	PRJNA976345_P_NODE_200390_length_150_cov_0.982609_g198782_i0	PRJNA976345	200390	150	0.982609	1.4739135	Desulfovibrio sp. 86	2666132	Bacteria	Bacteria	158	2.5199999999999998e-34	NTclustered	gi\|1862956133\|emb\|LR738849.1\|	2666132	g198782	i0	85.811	7.11333333333333	148	21	99	0	1	148	2380147	2380000	Desulfovibrio sp. 86 genome assembly, chromosome: DESU86	blastn	1067	158	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 86
12427712	12427712	PRJNA976345_P_NODE_40390_length_271_cov_1.648305_g38782_i0	PRJNA976345	40390	271	1.648305	4.46690655	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	405	1.66e-108	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g38782	i0	93.704	9.96678966789668	270	17	99	0	2	271	2933340	2933609	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	2701	405	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
13701458	13701458	PRJNA976345_P_NODE_13231_length_470_cov_2.259770_g11661_i0	PRJNA976345	13231	470	2.25977	10.620919	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	675	0	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g11661	i0	92.553	4.06808510638298	470	35	100	0	1	470	1940281	1939812	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	1912	675	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
13701611	13701611	PRJNA976345_P_NODE_155271_length_164_cov_1.798450_g153663_i0	PRJNA976345	155271	164	1.79845	2.949458	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	169	1.3000000000000001e-37	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g153663	i0	86.452	0.945121951219512	155	19	94	2	11	164	966699	966546	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	155	169	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
14975808	14975808	PRJNA976345_P_NODE_150212_length_166_cov_1.824427_g148604_i0	PRJNA976345	150212	166	1.824427	3.02854882	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	239	9.94e-59	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g148604	i0	92.727	1.98795180722892	165	12	99	0	2	166	3152192	3152356	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	330	239	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
14975884	14975884	PRJNA976345_P_NODE_161892_length_162_cov_0.874016_g160284_i0	PRJNA976345	161892	162	0.874016	1.41590592	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	278	2.04e-70	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g160284	i0	97.531	3	162	4	100	0	1	162	145773	145934	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	486	278	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
17526369	17526369	PRJNA976345_P_NODE_26414_length_328_cov_1.907850_g24811_i0	PRJNA976345	26414	328	1.90785	6.257748	Desulfoluna limicola	2810562	Bacteria	Bacteria	100	1.09e-16	NTclustered	gi\|2158810072\|dbj\|AP024488.1\|	2810562	g24811	i0	85	0.640243902439024	100	13	30	2	227	325	3367013	3366915	Desulfoluna sp. ASN36 ASN36 DNA, complete genome	blastn	210	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfolunaceae	Desulfoluna	Desulfoluna limicola
17527007	17527007	PRJNA976345_P_NODE_91954_length_196_cov_0.931677_g90346_i0	PRJNA976345	91954	196	0.931677	1.82608692	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	307	3.2800000000000005e-79	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g90346	i0	94.898	3.14285714285714	196	10	100	0	1	196	3138300	3138495	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	616	307	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
18799572	18799572	PRJNA976345_P_NODE_132995_length_174_cov_1.525180_g131387_i0	PRJNA976345	132995	174	1.52518	2.6538132	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	283	4.769999999999999e-72	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g131387	i0	95.977	5.66091954022988	174	7	100	0	1	174	927858	928031	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	985	283	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
20074761	20074761	PRJNA976345_P_NODE_191476_length_152_cov_1.692308_g189868_i0	PRJNA976345	191476	152	1.692308	2.57230816	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	182	1.52e-41	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g189868	i0	88.158	1.45394736842105	152	18	100	0	1	152	2382888	2383039	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	221	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
20075524	20075524	PRJNA976345_P_NODE_91256_length_196_cov_2.018634_g89648_i0	PRJNA976345	91256	196	2.018634	3.95652264	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	294	2.55e-75	NTclustered	gi\|1621566608\|gb\|CP036295.1\|	876	g89648	i0	94.271	7.80102040816327	192	11	98	0	1	192	2098612	2098803	Desulfovibrio desulfuricans strain IC1 chromosome, complete genome	blastn	1529	294	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
23900369	23900369	PRJNA976345_P_NODE_140819_length_170_cov_2.170370_g139211_i0	PRJNA976345	140819	170	2.17037	3.689629	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	270	3.61e-68	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g139211	i0	95.294	2.98235294117647	170	8	100	0	1	170	1858116	1857947	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	507	270	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
23900415	23900415	PRJNA976345_P_NODE_148759_length_167_cov_1.212121_g147151_i0	PRJNA976345	148759	167	1.212121	2.02424207	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	298	1.63e-76	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g147151	i0	98.802	4	167	2	100	0	1	167	1536342	1536508	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	668	298	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
23901110	23901110	PRJNA976345_P_NODE_47879_length_252_cov_1.534562_g46271_i0	PRJNA976345	47879	252	1.534562	3.86709624	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g46271	i0	97.222	3	252	7	100	0	1	252	92281	92030	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	756	427	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
25174339	25174339	PRJNA976345_P_NODE_24660_length_339_cov_1.713816_g23057_i0	PRJNA976345	24660	339	1.713816	5.80983624	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	582	9.179999999999996e-162	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g23057	i0	97.64	8.94690265486726	339	8	100	0	1	339	468623	468285	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	3033	582	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans

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