metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA982106" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA982106" 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
964060	964060	PRJNA982106_P_NODE_6881_length_369_cov_0.932432_g6641_i0	PRJNA982106	6881	369	0.932432	3.44067408	Desulfovibrio piger	901	Bacteria	Bacteria	654	0	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g6641	i0	98.645	15.0975609756098	369	5	100	0	1	369	1822003	1821635	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	5571	654	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
2238955	2238955	PRJNA982106_P_NODE_13502_length_295_cov_1.040541_g13262_i0	PRJNA982106	13502	295	1.040541	3.06959595	Desulfovibrio piger	901	Bacteria	Bacteria	510	3.76e-140	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g13262	i0	97.959	1.78305084745763	294	6	99	0	2	295	2154004	2154297	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	526	510	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
2239214	2239214	PRJNA982106_P_NODE_26202_length_246_cov_0.890173_g25962_i0	PRJNA982106	26202	246	0.890173	2.18982558	Desulfovibrio piger	901	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g25962	i0	98.78	2.58536585365854	246	3	100	0	1	246	318494	318249	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	636	438	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
3514347	3514347	PRJNA982106_P_NODE_21283_length_251_cov_0.865169_g21043_i0	PRJNA982106	21283	251	0.865169	2.17157419	Desulfovibrio piger	901	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g21043	i0	98.805	14.7051792828685	251	3	100	0	1	251	2409506	2409256	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	3691	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
4792180	4792180	PRJNA982106_P_NODE_8624_length_343_cov_0.937037_g8384_i0	PRJNA982106	8624	343	0.937037	3.21403691	Desulfovibrio piger	901	Bacteria	Bacteria	612	1.19e-170	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g8384	i0	98.834	1.46064139941691	343	4	100	0	1	343	2239427	2239769	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	501	612	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
6067069	6067069	PRJNA982106_P_NODE_19545_length_256_cov_1.262295_g19305_i0	PRJNA982106	19545	256	1.262295	3.2314752	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	292	1.26e-74	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g19305	i0	87.952	8.46484375	249	28	97	2	1	248	1810901	1810654	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	2167	292	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
6067266	6067266	PRJNA982106_P_NODE_29865_length_243_cov_0.905882_g29625_i0	PRJNA982106	29865	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g29625	i0	98.765	1.53086419753086	243	3	100	0	1	243	1060316	1060074	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	372	433	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
9892121	9892121	PRJNA982106_P_NODE_32348_length_241_cov_0.916667_g32108_i0	PRJNA982106	32348	241	0.916667	2.20916747	Desulfovibrio piger	901	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g32108	i0	99.585	66.0290456431535	241	1	100	0	1	241	1763548	1763308	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	15913	440	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
11167336	11167336	PRJNA982106_P_NODE_29989_length_243_cov_0.905882_g29749_i0	PRJNA982106	29989	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g29749	i0	99.588	28.6172839506173	243	1	100	0	1	243	688309	688551	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	6954	444	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
12442965	12442965	PRJNA982106_P_NODE_23190_length_249_cov_0.875000_g22950_i0	PRJNA982106	23190	249	0.875	2.17875	Desulfovibrio piger	901	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g22950	i0	100	2.82329317269076	249	0	100	0	1	249	973519	973271	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	703	460	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
12443013	12443013	PRJNA982106_P_NODE_25710_length_247_cov_0.885057_g25470_i0	PRJNA982106	25710	247	0.885057	2.18609079	Geotalea uraniireducens	351604	Bacteria	Bacteria	147	9.96e-31	NTclustered	gi\|2425841343\|dbj\|AP027151.1\|	351604	g25470	i0	77.689	22.6356275303644	251	49	99	7	2	247	1244478	1244726	Geotalea uraniireducens NIT-SL11 DNA, complete genome	blastn	5591	147	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
14991528	14991528	PRJNA982106_P_NODE_10112_length_326_cov_0.913043_g9872_i0	PRJNA982106	10112	326	0.913043	2.97652018	Desulfovibrio piger	901	Bacteria	Bacteria	586	6.79e-163	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g9872	i0	99.083	139.739263803681	327	2	100	1	1	326	535222	534896	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	45555	586	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14991692	14991692	PRJNA982106_P_NODE_20792_length_251_cov_0.865169_g20552_i0	PRJNA982106	20792	251	0.865169	2.17157419	Desulfovibrio piger	901	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g20552	i0	98.008	1.98804780876494	251	5	100	0	1	251	2457497	2457747	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	499	436	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
14991729	14991729	PRJNA982106_P_NODE_22492_length_250_cov_0.870056_g22252_i0	PRJNA982106	22492	250	0.870056	2.17514	Desulfovibrio piger	901	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g22252	i0	99.6	6.456	250	1	100	0	1	250	2437586	2437337	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	1614	457	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
17541843	17541843	PRJNA982106_P_NODE_29674_length_243_cov_0.905882_g29434_i0	PRJNA982106	29674	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g29434	i0	99.588	9.86831275720165	243	1	100	0	1	243	1435494	1435736	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	2398	444	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
17541985	17541985	PRJNA982106_P_NODE_8454_length_345_cov_0.970588_g8214_i0	PRJNA982106	8454	345	0.970588	3.3485286	Desulfovibrio piger	901	Bacteria	Bacteria	610	4.29e-170	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g8214	i0	98.551	2	345	5	100	0	1	345	417126	417470	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	690	610	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
17542013	17542013	PRJNA982106_P_NODE_9694_length_330_cov_1.031128_g9454_i0	PRJNA982106	9694	330	1.031128	3.4027224	Desulfovibrio piger	901	Bacteria	Bacteria	604	1.8999999999999996e-168	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g9454	i0	99.697	26.9060606060606	330	1	100	0	1	330	1387019	1386690	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	8879	604	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
18815639	18815639	PRJNA982106_P_NODE_26615_length_246_cov_0.890173_g26375_i0	PRJNA982106	26615	246	0.890173	2.18982558	Desulfovibrio piger	901	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g26375	i0	100	4.15447154471545	246	0	100	0	1	246	430623	430378	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	1022	455	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
18815748	18815748	PRJNA982106_P_NODE_32355_length_241_cov_0.916667_g32115_i0	PRJNA982106	32355	241	0.916667	2.20916747	Desulfovibrio piger	901	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g32115	i0	99.167	2.11203319502075	240	2	99	0	2	241	712564	712325	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	509	433	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
22641014	22641014	PRJNA982106_P_NODE_28138_length_245_cov_0.895349_g27898_i0	PRJNA982106	28138	245	0.895349	2.19360505	Desulfovibrio piger	901	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g27898	i0	97.959	1	245	5	100	0	1	245	86003	86247	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	245	425	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
22641030	22641030	PRJNA982106_P_NODE_29358_length_244_cov_0.900585_g29118_i0	PRJNA982106	29358	244	0.900585	2.1974274	Desulfovibrio piger	901	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g29118	i0	99.18	2	244	2	100	0	1	244	893406	893163	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	488	440	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
22641034	22641034	PRJNA982106_P_NODE_29578_length_243_cov_0.905882_g29338_i0	PRJNA982106	29578	243	0.905882	2.20129326	Desulfovibrio piger	901	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g29338	i0	100	1.97942386831276	243	0	100	0	1	243	2672422	2672664	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	481	449	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
25190011	25190011	PRJNA982106_P_NODE_22080_length_250_cov_0.870056_g21840_i0	PRJNA982106	22080	250	0.870056	2.17514	Desulfovibrio piger	901	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g21840	i0	100	30.124	250	0	100	0	1	250	688833	688584	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	7531	462	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
25190152	25190152	PRJNA982106_P_NODE_28520_length_244_cov_0.900585_g28280_i0	PRJNA982106	28520	244	0.900585	2.1974274	Desulfovibrio piger	901	Bacteria	Bacteria	176	1.25e-39	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g28280	i0	80.889	9.04918032786885	225	41	92	2	1	224	2446591	2446814	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	2208	176	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
25190329	25190329	PRJNA982106_P_NODE_9720_length_330_cov_0.867704_g9480_i0	PRJNA982106	9720	330	0.867704	2.8634232	Desulfovibrio piger	901	Bacteria	Bacteria	289	2.1799999999999996e-73	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g9480	i0	98.765	13.330303030303	162	2	49	0	1	162	2979123	2979284	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	4399	289	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger

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