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

19 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
903162	903162	PRJNA928559_P_NODE_185541_length_254_cov_2.585635_g183972_i0	PRJNA928559	185541	254	2.585635	6.5675129	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	104	6.28e-18	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g183972	i0	85.294	1.60629921259843	102	13	40	2	154	254	4511004	4511104	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	408	104	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
2178368	2178368	PRJNA928559_P_NODE_179842_length_259_cov_1.860215_g178273_i0	PRJNA928559	179842	259	1.860215	4.81795685	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	106	1.79e-18	NTclustered	gi\|2621701778\|emb\|OY759308.1\|	2044940	g178273	i0	81.89	11.7065637065637	127	22	49	1	101	226	1124066	1123940	MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1	blastn	3032	106	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
2179393	2179393	PRJNA928559_P_NODE_45142_length_504_cov_7.262181_g43582_i0	PRJNA928559	45142	504	7.262181	36.60139224	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	198	5.98e-46	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g43582	i0	77.778	38.8134920634921	333	66	65	7	1	328	887032	886703	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	19562	198	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
4732409	4732409	PRJNA928559_P_NODE_37364_length_544_cov_4.341826_g35811_i0	PRJNA928559	37364	544	4.341826	23.61953344	Desulfarculia bacterium	3065862	Bacteria	Bacteria	231	6.399999999999999e-56	NTclustered	gi\|2621702698\|emb\|OY759590.1\|	3065862	g35811	i0	75.526	3781.6875	523	100	97	26	27	535	3845162	3844654	MAG: Desulfarculia bacterium isolate 49400898-fc5b-42b7-bef8-a303f8702bb8 genome assembly, chromosome: 1	blastn	2057238	231	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia				Desulfarculia bacterium
5081246	5081246	PRJNA928559_P_NODE_194024_length_250_cov_1.762712_g192455_i0	PRJNA928559	194024	250	1.762712	4.40678	Solidesulfovibrio	2910984	Bacteria	Bacteria	62.1	3.76e-5	NTclustered	gi\|1566432249\|gb\|CP026538.1\|	296842	g192455	i0	97.222	0.276	36	1	14	0	209	244	2634379	2634414	Solidesulfovibrio carbinolicus strain DSM 3852 chromosome, complete genome	blastn	69	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio carbinolicus
5081311	5081311	PRJNA928559_P_NODE_216004_length_241_cov_2.571429_g214435_i0	PRJNA928559	216004	241	2.571429	6.19714389	root	1	Root_unresolved	Root_unresolved	246	9.27e-61	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g214435	i0	85.714	227.51867219917	238	29	98	5	1	236	221457	221691	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	54832	246	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
7280368	7280368	PRJNA928559_P_NODE_129226_length_312_cov_2.761506_g127657_i0	PRJNA928559	129226	312	2.761506	8.61589872	Desulfoglaeba alkanexedens	361111	Bacteria	Bacteria	318	2.6e-82	NTclustered	gi\|1649181537\|gb\|CP040098.1\|	980445	g127657	i0	85.397	313.576923076923	315	36	99	9	1	310	1353901	1354210	Desulfoglaeba alkanexedens ALDC chromosome, complete genome	blastn	97836	318	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulfoglaeba	Desulfoglaeba alkanexedens
7630791	7630791	PRJNA928559_P_NODE_133326_length_307_cov_1.871795_g131757_i0	PRJNA928559	133326	307	1.871795	5.74641065	Geobacter	28231	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2499315885\|dbj\|AP028061.1\|	1260928	g131757	i0	100	0.188925081433225	29	0	9	0	270	298	3181832	3181860	Geobacter sulfurreducens subsp. ethanolicus OSK2A DNA, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
8555570	8555570	PRJNA928559_P_NODE_160787_length_277_cov_1.068627_g159218_i0	PRJNA928559	160787	277	1.068627	2.96009679	Desulfuromonas soudanensis	1603606	Bacteria	Bacteria	171	6.74e-38	NTclustered	gi\|924528553\|gb\|CP010802.1\|	1603606	g159218	i0	80.083	96.7689530685921	241	39	87	5	38	277	2966341	2966573	Desulfuromonas soudanensis strain WTL chromosome, complete genome	blastn	26805	171	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas soudanensis
11456397	11456397	PRJNA928559_P_NODE_114389_length_333_cov_2.757692_g112820_i0	PRJNA928559	114389	333	2.757692	9.18311436	Pseudomonadati	3379134	Bacteria	Bacteria	361	4.59e-95	NTclustered	gi\|2893358418\|emb\|OZ220710.1\|	2202153	g112820	i0	87.267	162.261261261261	322	33	95	8	17	333	2289039	2288721	MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1	blastn	54033	361	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
13657204	13657204	PRJNA928559_P_NODE_213871_length_242_cov_1.715976_g212302_i0	PRJNA928559	213871	242	1.715976	4.15266192	Desulfatibacillum aliphaticivorans	218208	Bacteria	Bacteria	95.3	3.57e-15	NTclustered	gi\|218759244\|gb\|CP001322.1\|	218208	g212302	i0	93.75	4.62809917355372	64	3	26	1	102	164	4327398	4327335	Desulfatibacillum aliphaticivorans strain AK-01, complete genome	blastn	1120	95.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfatibacillaceae	Desulfatibacillum	Desulfatibacillum aliphaticivorans
14006754	14006754	PRJNA928559_P_NODE_149351_length_288_cov_2.330233_g147782_i0	PRJNA928559	149351	288	2.330233	6.71107104	Pseudomonadati	3379134	Bacteria	Bacteria	91.6	5.65e-14	NTclustered	gi\|470477329\|ref\|NR_076377.1\|	58180	g147782	i0	100	38.2743055555556	49	0	17	0	240	288	1376	1424	Desulfovibrio alaskensis strain G20 23S ribosomal RNA gene, complete sequence	blastn	11023	91.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oleidesulfovibrio	Oleidesulfovibrio alaskensis
14932649	14932649	PRJNA928559_P_NODE_97972_length_360_cov_2.355401_g96403_i0	PRJNA928559	97972	360	2.355401	8.4794436	uncultured Desulfobulbus sp.	239745	Bacteria	Bacteria	67.6	1.22e-6	NTclustered	gi\|2621704320\|emb\|OY760916.1\|	239745	g96403	i0	100	0.883333333333333	36	0	10	0	1	36	4608696	4608661	MAG: uncultured Desulfobulbus sp. isolate 7a05128d-adad-4d17-beb6-ff3d102eb21b genome assembly, chromosome: 1	blastn	318	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	uncultured Desulfobulbus sp.
15281023	15281023	PRJNA928559_P_NODE_27272_length_621_cov_2.370438_g25758_i0	PRJNA928559	27272	621	2.370438	14.72041998	Pseudomonadati	3379134	Bacteria	Bacteria	244	9.47e-60	NTclustered	gi\|470486527\|ref\|NR_076763.1\|	453230	g25758	i0	74.488	63.2657004830918	635	128	99	30	4	621	2	619	Desulfarculus baarsii strain 2st14 23S ribosomal RNA gene, complete sequence	blastn	39288	244	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
21306714	21306714	PRJNA928559_P_NODE_92737_length_370_cov_1.542088_g91168_i0	PRJNA928559	92737	370	1.542088	5.7057256	uncultured Desulfospira sp.	232702	Bacteria	Bacteria	176	2e-39	NTclustered	gi\|2621704103\|emb\|OY761554.1\|	232702	g91168	i0	81.905	52.4459459459459	210	36	56	2	92	300	548750	548958	MAG: uncultured Desulfospira sp. isolate 5198f45b-3c99-4a6a-ad95-b1a64aaf42d9 genome assembly, chromosome: 1	blastn	19405	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfospira	uncultured Desulfospira sp.
22930808	22930808	PRJNA928559_P_NODE_22658_length_671_cov_4.321070_g21169_i0	PRJNA928559	22658	671	4.32107	28.9943797	Thermodesulfobacteriota	200940	Bacteria	Bacteria	206	4.85e-48	NTclustered	gi\|2814788371\|emb\|OY764894.2\|	201089	g21169	i0	81.061	145.932935916542	264	44	61	6	382	643	1379895	1380154	MAG: uncultured Desulfobacterium sp. isolate 35125921-b51f-40db-957b-bccbeeb29ead genome assembly, chromosome: 1	blastn	97921	207	0.995169082125604	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
23856910	23856910	PRJNA928559_P_NODE_89619_length_376_cov_1.788779_g88050_i0	PRJNA928559	89619	376	1.788779	6.72580904	Geoalkalibacter halelectricus	2847045	Bacteria	Bacteria	76.8	2.12e-9	NTclustered	gi\|2304895958\|gb\|CP092109.1\|	2847045	g88050	i0	84.81	11.281914893617	79	8	20	4	300	376	2754611	2754687	Geoalkalibacter halelectricus strain SAP-1 chromosome	blastn	4242	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
25128953	25128953	PRJNA928559_P_NODE_16780_length_766_cov_2.229437_g15375_i0	PRJNA928559	16780	766	2.229437	17.07748742	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	193	4.34e-44	NTclustered	gi\|2621704922\|emb\|OY762209.1\|	2660714	g15375	i0	72.8	95.4856396866841	625	148	80	19	1	612	3508418	3509033	MAG: Syntrophorhabdaceae bacterium isolate b67c53bf-795e-48b1-b0c8-2f1cb1e3683a genome assembly, chromosome: 1	blastn	73142	193	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
25129588	25129588	PRJNA928559_P_NODE_209980_length_244_cov_0.912281_g208411_i0	PRJNA928559	209980	244	0.912281	2.22596564	Desulfolutivibrio sulfoxidireducens	2773299	Bacteria	Bacteria	174	4.5e-39	NTclustered	gi\|1863429635\|gb\|CP045508.1\|	2773299	g208411	i0	87.097	71.7377049180328	155	18	63	2	6	159	3994214	3994367	Desulfolutivibrio sulfoxidireducens strain DSM 107105 chromosome, complete genome	blastn	17504	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfoxidireducens

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