metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
2094467	2094467	PRJNA814235_P_NODE_96202_length_203_cov_2.668675_g94807_i0	PRJNA814235	96202	203	2.668675	5.41741025	Geobacter metallireducens	28232	Bacteria	Bacteria	65.8	2.27e-6	NTclustered	gi\|78192483\|gb\|CP000148.1\|	269799	g94807	i0	90	0.492610837438424	50	5	25	0	18	67	356257	356306	Geobacter metallireducens GS-15, complete genome	blastn	100	65.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter metallireducens
4643851	4643851	PRJNA814235_P_NODE_116484_length_203_cov_1.897590_g115089_i0	PRJNA814235	116484	203	1.89759	3.8521077	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	69.4	1.76e-7	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g115089	i0	93.478	0.399014778325123	46	3	23	0	5	50	2423740	2423695	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	81	69.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
7194350	7194350	PRJNA814235_P_NODE_151466_length_173_cov_2.404412_g150071_i0	PRJNA814235	151466	173	2.404412	4.15963276	Desulfovibrio piger	901	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g150071	i0	100	172.508670520231	173	0	100	0	1	173	2038358	2038530	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	29844	320	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
7197091	7197091	PRJNA814235_P_NODE_99126_length_203_cov_2.487952_g97731_i0	PRJNA814235	99126	203	2.487952	5.05054256	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	73.1	1.36e-8	NTclustered	gi\|2621780237\|emb\|OY776524.1\|	2044940	g97731	i0	86.957	0.842364532019704	69	3	33	4	129	194	5477299	5477234	MAG: Desulfobacterales bacterium isolate 4b92870f-ba81-4c82-9d98-8a89c3612312 genome assembly, chromosome: 1	blastn	171	73.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
7605351	7605351	PRJNA814235_P_NODE_62626_length_240_cov_3.581281_g61232_i0	PRJNA814235	62626	240	3.581281	8.5950744	Pseudomonadati	3379134	Bacteria	Bacteria	204	5.63e-48	NTclustered	gi\|1976315905\|dbj\|AP024469.1\|	2495594	g61232	i0	94.656	26.1083333333333	131	7	55	0	1	131	3611439	3611309	Geobacter sp. SVR DNA, complete genome	blastn	6266	204	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR
8468093	8468093	PRJNA814235_P_NODE_103067_length_203_cov_2.307229_g101672_i0	PRJNA814235	103067	203	2.307229	4.68367487	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2622071907\|emb\|OY787459.1\|	2795000	g101672	i0	94.444	0.354679802955665	36	2	18	0	34	69	1891595	1891630	MAG: Maridesulfovibrio sp. isolate dd810cdf-0f79-41bc-9a6a-58a6cc26fc8d genome assembly, chromosome: 1	blastn	72	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
8468118	8468118	PRJNA814235_P_NODE_104987_length_203_cov_2.228916_g103592_i0	PRJNA814235	104987	203	2.228916	4.52469948	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	76.8	1.05e-9	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g103592	i0	91.071	1.83251231527094	56	5	28	0	21	76	3280600	3280545	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	372	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
11019169	11019169	PRJNA814235_P_NODE_117949_length_203_cov_1.843373_g116554_i0	PRJNA814235	117949	203	1.843373	3.74204719	Citrifermentans bemidjiense	225194	Bacteria	Bacteria	71.3	4.88e-8	NTclustered	gi\|197085762\|gb\|CP001124.1\|	404380	g116554	i0	95.455	1.97044334975369	44	2	22	0	33	76	1067571	1067614	Geobacter bemidjiensis Bem, complete genome	blastn	400	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bemidjiense
13571668	13571668	PRJNA814235_P_NODE_59351_length_247_cov_2.157143_g57957_i0	PRJNA814235	59351	247	2.157143	5.32814321	Desulfofustis limnaeus	2740163	Bacteria	Bacteria	89.8	1.7e-13	NTclustered	gi\|2211518257\|dbj\|AP025516.1\|	2740163	g57957	i0	83.333	0.388663967611336	96	16	39	0	22	117	3999436	3999341	Desulfobulbaceae bacterium PPLL DNA, complete genome	blastn	96	89.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfofustis	Desulfofustis limnaeus
14843230	14843230	PRJNA814235_P_NODE_101092_length_203_cov_2.397590_g99697_i0	PRJNA814235	101092	203	2.39759	4.8671077	Desulfococcus multivorans	897	Bacteria	Bacteria	63.9	8.17e-6	NTclustered	gi\|1092202713\|gb\|CP015381.1\|	897	g99697	i0	95	0.541871921182266	40	2	20	0	163	202	2108585	2108546	Desulfococcus multivorans strain DSM 2059 chromosome, complete genome	blastn	110	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
16118431	16118431	PRJNA814235_P_NODE_141353_length_182_cov_3.517241_g139958_i0	PRJNA814235	141353	182	3.517241	6.40137862	Desulfovibrio sp. 86	2666132	Bacteria	Bacteria	63.9	7.15e-6	NTclustered	gi\|1862956133\|emb\|LR738849.1\|	2666132	g139958	i0	90	0.274725274725275	50	3	27	1	79	128	1113124	1113077	Desulfovibrio sp. 86 genome assembly, chromosome: DESU86	blastn	50	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 86
16119501	16119501	PRJNA814235_P_NODE_187653_length_151_cov_3.368421_g186258_i0	PRJNA814235	187653	151	3.368421	5.08631571	Geobacter sulfurreducens	35554	Bacteria	Bacteria	76.8	7.31e-10	NTclustered	gi\|2045533567\|gb\|CP074693.1\|	35554	g186258	i0	87.692	1.79470198675497	65	8	43	0	1	65	1196364	1196428	Geobacter sulfurreducens strain YM35 chromosome, complete genome	blastn	271	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
16528476	16528476	PRJNA814235_P_NODE_132813_length_191_cov_12.532468_g131418_i0	PRJNA814235	132813	191	12.532468	23.93701388	Desulfovibrionaceae	194924	Bacteria	Bacteria	204	4.289999999999999e-48	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g131418	i0	85.938	162.549738219895	192	26	100	1	1	191	226062	226253	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	31047	204	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
17393502	17393502	PRJNA814235_P_NODE_103534_length_203_cov_2.289157_g102139_i0	PRJNA814235	103534	203	2.289157	4.64698871	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	108	3.72e-19	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g102139	i0	93.151	0.359605911330049	73	5	36	0	1	73	4467463	4467535	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	73	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
17393761	17393761	PRJNA814235_P_NODE_120514_length_203_cov_1.674699_g119119_i0	PRJNA814235	120514	203	1.674699	3.39963897	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	63.9	8.17e-6	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g119119	i0	87.5	2.88177339901478	56	5	27	2	137	191	1494978	1495032	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	585	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
18670068	18670068	PRJNA814235_P_NODE_85915_length_205_cov_2.089286_g84520_i0	PRJNA814235	85915	205	2.089286	4.2830363	Thermodesulfobacterium commune	1741	Bacteria	Bacteria	117	6.26e-22	NTclustered	gi\|668351138\|gb\|CP008796.1\|	289377	g84520	i0	80.769	6.40975609756098	156	24	74	4	7	158	1298342	1298495	Thermodesulfobacterium commune DSM 2178, complete genome	blastn	1314	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfobacteriaceae	Thermodesulfobacterium	Thermodesulfobacterium commune
19942085	19942085	PRJNA814235_P_NODE_123576_length_202_cov_2.000000_g122181_i0	PRJNA814235	123576	202	2	4.04	Desulfovibrio piger	901	Bacteria	Bacteria	76.8	1.04e-9	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g122181	i0	86.765	0.772277227722772	68	9	34	0	127	194	1396561	1396494	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	156	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
20352901	20352901	PRJNA814235_P_NODE_183676_length_151_cov_4.500000_g182281_i0	PRJNA814235	183676	151	4.5	6.795	Thermodesulfobacteriota	200940	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|451904998\|gb\|CP003985.1\|	1167006	g182281	i0	89.13	21.7152317880795	46	4	30	1	32	76	2355530	2355575	Desulfocapsa sulfexigens DSM 10523, complete genome	blastn	3279	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sulfexigens
21220978	21220978	PRJNA814235_P_NODE_97877_length_203_cov_2.554217_g96482_i0	PRJNA814235	97877	203	2.554217	5.18506051	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	76.8	1.05e-9	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g96482	i0	100	18.3645320197044	41	0	20	0	36	76	493521	493481	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	3728	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium

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