metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA752278" 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
726881	726881	PRJNA752278_P_NODE_12941_length_414_cov_2.428152_g12738_i0	PRJNA752278	12941	414	2.428152	10.05254928	Desulfocurvibacter africanus	873	Bacteria	Bacteria	93.5	2.35e-14	NTclustered	gi\|367460290\|gb\|CP003221.1\|	690850	g12738	i0	83.019	0.538647342995169	106	15	25	3	293	397	1384353	1384250	Desulfocurvibacter africanus subsp. africanus str. Walvis Bay chromosome, complete genome	blastn	223	93.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfocurvibacter	Desulfocurvibacter africanus
727126	727126	PRJNA752278_P_NODE_24641_length_329_cov_2.351562_g24438_i0	PRJNA752278	24641	329	2.351562	7.73663898	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	230	1.3299999999999995e-55	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g24438	i0	93.548	0.96048632218845	155	9	47	1	130	284	1879034	1879187	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	316	230	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
727909	727909	PRJNA752278_P_NODE_66541_length_261_cov_2.484043_g66338_i0	PRJNA752278	66541	261	2.484043	6.48335223	Desulfovibrio piger	901	Bacteria	Bacteria	460	3.3399999999999995e-125	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g66338	i0	98.467	1.93869731800766	261	4	100	0	1	261	317179	316919	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	506	460	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
3278173	3278173	PRJNA752278_P_NODE_108683_length_232_cov_2.207547_g108480_i0	PRJNA752278	108683	232	2.207547	5.12150904	Geomonas subterranea	2847989	Bacteria	Bacteria	84.2	7.36e-12	NTclustered	gi\|2060227305\|gb\|CP077683.1\|	2847989	g108480	i0	97.917	21.7801724137931	48	1	21	0	185	232	2056574	2056621	Geomonas subterranea strain RG2 chromosome, complete genome	blastn	5053	84.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas subterranea
7106123	7106123	PRJNA752278_P_NODE_37306_length_289_cov_2.087963_g37103_i0	PRJNA752278	37306	289	2.087963	6.03421307	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	176	1.52e-39	NTclustered	gi\|2172810686\|gb\|CP077745.1\|	876	g37103	i0	97.115	4.00346020761246	104	3	36	0	186	289	1537879	1537776	Desulfovibrio desulfuricans strain Edelweiss chromosome, complete genome	blastn	1157	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
7578882	7578882	PRJNA752278_P_NODE_43626_length_283_cov_1.580952_g43423_i0	PRJNA752278	43626	283	1.580952	4.47409416	Desulfobacter	2289	Bacteria	Bacteria	512	9.97e-141	NTclustered	gi\|1583991466\|gb\|CP036313.1\|	2291	g43423	i0	99.296	258.201413427562	284	1	100	1	1	283	505215	504932	Desulfobacter hydrogenophilus strain AcRS1 chromosome	blastn	73071	512	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	Desulfobacter hydrogenophilus
8381250	8381250	PRJNA752278_P_NODE_66527_length_261_cov_2.590426_g66324_i0	PRJNA752278	66527	261	2.590426	6.76101186	Desulfovibrio sp. 86	2666132	Bacteria	Bacteria	189	1.7399999999999999e-43	NTclustered	gi\|1862956133\|emb\|LR738849.1\|	2666132	g66324	i0	81.048	5.6360153256705	248	37	93	7	19	261	2650868	2650626	Desulfovibrio sp. 86 genome assembly, chromosome: DESU86	blastn	1471	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 86
8381618	8381618	PRJNA752278_P_NODE_87987_length_247_cov_1.373563_g87784_i0	PRJNA752278	87987	247	1.373563	3.39270061	Geoalkalibacter halelectricus	2847045	Bacteria	Bacteria	185	2.11e-42	NTclustered	gi\|2304895958\|gb\|CP092109.1\|	2847045	g87784	i0	81.405	228.85020242915	242	32	96	11	1	237	1358830	1359063	Geoalkalibacter halelectricus strain SAP-1 chromosome	blastn	56526	185	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter halelectricus
10129744	10129744	PRJNA752278_P_NODE_65308_length_263_cov_1.021053_g65105_i0	PRJNA752278	65308	263	1.021053	2.68536939	Geobacter	28231	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g65105	i0	98.859	9	263	3	100	0	1	263	2267691	2267429	Geobacter sulfurreducens strain AM-1 genome	blastn	2367	470	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
13482341	13482341	PRJNA752278_P_NODE_96491_length_244_cov_0.900585_g96288_i0	PRJNA752278	96491	244	0.900585	2.1974274	uncultured Desulfobacterium sp.	201089	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2621713419\|emb\|OY771474.1\|	201089	g96288	i0	100	261.045081967213	244	0	100	0	1	244	1187433	1187190	MAG: uncultured Desulfobacterium sp. isolate 2c08e38e-77a0-468a-b8ca-c683eacf49f2 genome assembly, chromosome: 1	blastn	63695	451	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteriaceae	Desulfobacterium	uncultured Desulfobacterium sp.
14757043	14757043	PRJNA752278_P_NODE_77452_length_251_cov_1.528090_g77249_i0	PRJNA752278	77452	251	1.52809	3.8355059	uncultured Desulfobulbus sp.	239745	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|2621704989\|emb\|OY762276.1\|	239745	g77249	i0	97.61	365.278884462151	251	6	100	0	1	251	155825	155575	MAG: uncultured Desulfobulbus sp. isolate 57af8870-89a5-447c-908d-f2db64e05d28 genome assembly, chromosome: 1	blastn	91685	431	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	uncultured Desulfobulbus sp.
14757247	14757247	PRJNA752278_P_NODE_88252_length_247_cov_0.885057_g88049_i0	PRJNA752278	88252	247	0.885057	2.18609079	Oceanidesulfovibrio marinus	370038	Bacteria	Bacteria	183	7.59e-42	NTclustered	gi\|1841667704\|gb\|CP039543.1\|	370038	g88049	i0	81.778	32.3724696356275	225	35	90	5	6	227	4052488	4052267	Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome	blastn	7996	183	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oceanidesulfovibrio	Oceanidesulfovibrio marinus
16031074	16031074	PRJNA752278_P_NODE_95713_length_244_cov_1.637427_g95510_i0	PRJNA752278	95713	244	1.637427	3.99532188	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|2884834435\|gb\|CP176628.1\|	876	g95510	i0	96.311	3	244	9	100	0	1	244	2130447	2130204	Desulfovibrio desulfuricans strain SFAD67 chromosome, complete genome	blastn	732	401	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
24953345	24953345	PRJNA752278_P_NODE_109260_length_230_cov_2.414013_g109057_i0	PRJNA752278	109260	230	2.414013	5.5522299	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	422	1.36e-113	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g109057	i0	100	10.6217391304348	228	0	99	0	1	228	1902327	1902554	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	2443	422	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
24954771	24954771	PRJNA752278_P_NODE_81940_length_249_cov_2.482955_g81737_i0	PRJNA752278	81940	249	2.482955	6.18255795	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	71.3	6.22e-8	NTclustered	gi\|2621786209\|emb\|OY782667.1\|	2049043	g81737	i0	97.561	8.54216867469879	41	1	16	0	208	248	658408	658448	MAG: Desulfovibrionaceae bacterium isolate c63d6e66-0b86-4b38-bb75-751bde387f56 genome assembly, chromosome: 1	blastn	2127	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae 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);;