metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA773778" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA773778" 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
2026754	2026754	PRJNA773778_S_NODE_16902_length_350_cov_4.317690_g16752_i0	PRJNA773778	16902	350	4.31769	15.111915	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	623	5.589999999999999e-174	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g16752	i0	98.857	7.26571428571429	350	3	100	1	1	350	502376	502724	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	2543	623	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
2026910	2026910	PRJNA773778_S_NODE_24102_length_307_cov_1.615385_g23952_i0	PRJNA773778	24102	307	1.615385	4.95923195	Desulfococcus multivorans	897	Bacteria	Bacteria	568	2.3e-157	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g23952	i0	100	46.5537459283388	307	0	100	0	1	307	2686699	2687005	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	14292	568	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
3301907	3301907	PRJNA773778_S_NODE_16363_length_355_cov_1.365248_g16213_i0	PRJNA773778	16363	355	1.365248	4.8466304	Syntrophobacter fumaroxidans	119484	Bacteria	Bacteria	108	7.07e-19	NTclustered	gi\|116696516\|gb\|CP000478.1\|	335543	g16213	i0	87.234	0.264788732394366	94	12	26	0	58	151	4908631	4908538	Syntrophobacter fumaroxidans MPOB, complete genome	blastn	94	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
3302318	3302318	PRJNA773778_S_NODE_35103_length_266_cov_1.186528_g34953_i0	PRJNA773778	35103	266	1.186528	3.15616448	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	475	1.2199999999999997e-129	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g34953	i0	98.872	4.68421052631579	266	3	100	0	1	266	2002165	2002430	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	1246	475	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
4579274	4579274	PRJNA773778_S_NODE_29384_length_285_cov_1.429245_g29234_i0	PRJNA773778	29384	285	1.429245	4.07334825	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	255	1.87e-63	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g29234	i0	85.49	16.4666666666667	255	26	87	7	39	285	2976150	2976401	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	4693	255	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
9679755	9679755	PRJNA773778_S_NODE_37428_length_259_cov_1.129032_g37278_i0	PRJNA773778	37428	259	1.129032	2.92419288	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	398	2.6299999999999997e-106	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g37278	i0	94.275	54.7606177606178	262	12	100	1	1	259	2247736	2247475	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	14183	398	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
10954977	10954977	PRJNA773778_S_NODE_18549_length_338_cov_10.841509_g18399_i0	PRJNA773778	18549	338	10.841509	36.64430042	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	492	1.59e-134	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g18399	i0	92.92	6.1094674556213	339	22	100	2	1	338	2702372	2702709	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	2065	492	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
13504836	13504836	PRJNA773778_S_NODE_28731_length_288_cov_1.069767_g28581_i0	PRJNA773778	28731	288	1.069767	3.08092896	Solidesulfovibrio carbinolicus	296842	Bacteria	Bacteria	427	3.7899999999999997e-115	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g28581	i0	93.426	4.07638888888889	289	17	100	2	1	288	375193	375480	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	1174	427	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
14779976	14779976	PRJNA773778_S_NODE_34292_length_268_cov_2.579487_g34142_i0	PRJNA773778	34292	268	2.579487	6.91302516	Desulfococcus multivorans	897	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|84616844\|emb\|CT009609.1\|	897	g34142	i0	100	13.7350746268657	268	0	100	0	1	268	25372	25639	Desulfococcus multivorans vrl island	blastn	3681	496	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
14780277	14780277	PRJNA773778_S_NODE_47032_length_242_cov_3.224852_g46882_i0	PRJNA773778	47032	242	3.224852	7.80414184	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g46882	i0	100	86.9421487603306	242	0	100	0	1	242	2370769	2370528	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	21040	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
16054036	16054036	PRJNA773778_S_NODE_46133_length_244_cov_0.900585_g45983_i0	PRJNA773778	46133	244	0.900585	2.1974274	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g45983	i0	96.721	77.8934426229508	244	8	100	0	1	244	2721926	2722169	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	19006	407	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
19877772	19877772	PRJNA773778_S_NODE_23816_length_308_cov_9.604255_g23666_i0	PRJNA773778	23816	308	9.604255	29.5811054	Desulfovibrio mangrovi	2976983	Bacteria	Bacteria	132	3.59e-26	NTclustered	gi\|2330538096\|gb\|CP104208.1\|	2976983	g23666	i0	80	6.3474025974026	185	31	59	6	1	181	1165178	1165360	Desulfovibrio mangrovi strain FT415 chromosome, complete genome	blastn	1955	132	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio mangrovi
21153493	21153493	PRJNA773778_S_NODE_22137_length_317_cov_2.372951_g21987_i0	PRJNA773778	22137	317	2.372951	7.52225467	Desulforhabdus sp. DDT	449293	Bacteria	Bacteria	348	3.3800000000000003e-91	NTclustered	gi\|151302336\|gb\|EF442951.1\|	449293	g21987	i0	86.817	47.6719242902208	311	41	98	0	7	317	976	666	Desulforhabdus sp. DDT AprB (aprB) and AprA (aprA) genes, partial cds	blastn	15112	348	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus sp. DDT
21609359	21609359	PRJNA773778_S_NODE_17837_length_343_cov_4.574074_g17687_i0	PRJNA773778	17837	343	4.574074	15.68907382	Solidesulfovibrio	2910984	Bacteria	Bacteria	431	3.569999999999999e-116	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g17687	i0	89.504	71.4110787172012	343	32	100	3	1	343	2536627	2536965	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	24494	431	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
22428621	22428621	PRJNA773778_S_NODE_38278_length_256_cov_1.502732_g38128_i0	PRJNA773778	38278	256	1.502732	3.84699392	Pseudodesulfovibrio sp. zrk46	2725288	Bacteria	Bacteria	119	2.26e-22	NTclustered	gi\|1832582227\|gb\|CP051216.1\|	2725288	g38128	i0	84.746	0.93359375	118	18	46	0	139	256	3705967	3705850	Pseudodesulfovibrio sp. zrk46 chromosome, complete genome	blastn	239	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sp. zrk46
23703767	23703767	PRJNA773778_S_NODE_17839_length_343_cov_4.403704_g17689_i0	PRJNA773778	17839	343	4.403704	15.10470472	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	529	1.2299999999999994e-145	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g17689	i0	94.493	65.2215743440233	345	16	99	2	2	343	2370869	2370525	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	22371	529	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
23703791	23703791	PRJNA773778_S_NODE_19179_length_334_cov_1.597701_g19029_i0	PRJNA773778	19179	334	1.597701	5.33632134	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	612	1.15e-170	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g19029	i0	99.701	20.5958083832335	334	1	100	0	1	334	663285	663618	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	6879	612	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
24977426	24977426	PRJNA773778_S_NODE_15660_length_361_cov_4.413194_g15510_i0	PRJNA773778	15660	361	4.413194	15.93163034	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	409	1.76e-109	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g15510	i0	93.19	54.3573407202216	279	18	77	1	28	306	335665	335388	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	19623	409	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
24977474	24977474	PRJNA773778_S_NODE_18100_length_341_cov_11.761194_g17950_i0	PRJNA773778	18100	341	11.761194	40.10567154	uncultured Syntrophobacter sp.	281272	Bacteria	Bacteria	241	6.41e-59	NTclustered	gi\|2621703986\|emb\|OY762941.1\|	281272	g17950	i0	79.592	17.7683284457478	343	64	100	6	1	341	306056	306394	MAG: uncultured Syntrophobacter sp. isolate 8beb1b32-fcc7-4ae2-b8e9-2f20d438afad genome assembly, chromosome: 1	blastn	6059	241	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	uncultured Syntrophobacter sp.
24977488	24977488	PRJNA773778_S_NODE_18860_length_336_cov_5.387833_g18710_i0	PRJNA773778	18860	336	5.387833	18.10311888	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	538	2e-148	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g18710	i0	95.536	4.62797619047619	336	15	100	0	1	336	2002132	2002467	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	1555	538	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens
24977755	24977755	PRJNA773778_S_NODE_3100_length_644_cov_1.360771_g2955_i0	PRJNA773778	3100	644	1.360771	8.76336524	Desulforhabdus sp. BKA11	449292	Bacteria	Bacteria	702	0	NTclustered	gi\|151302333\|gb\|EF442950.1\|	449292	g2955	i0	86.378	33.054347826087	646	84	100	4	1	644	1569	926	Desulforhabdus sp. BKA11 AprB (aprB) and AprA (aprA) genes, partial cds	blastn	21287	702	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus sp. BKA11

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