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

21 rows where analysis = "blastn", bioproject = "PRJNA688655" 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
667075	667075	PRJNA688655_P_NODE_10681_length_248_cov_0.880000_g10616_i0	PRJNA688655	10681	248	0.88	2.1824	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	163	9.93e-36	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g10616	i0	86.577	0.600806451612903	149	19	60	1	89	237	904856	904709	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	149	163	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
1943071	1943071	PRJNA688655_P_NODE_12362_length_246_cov_0.890173_g12297_i0	PRJNA688655	12362	246	0.890173	2.18982558	Desulfatiglandales bacterium	3024416	Bacteria	Bacteria	75	4.74e-9	NTclustered	gi\|2621702716\|emb\|OY759599.1\|	3024416	g12297	i0	85.915	0.455284552845528	71	9	28	1	168	237	7177847	7177777	MAG: Desulfatiglandales bacterium isolate ef928343-fb2c-4ac1-bd77-a4af7a033044 genome assembly, chromosome: 1	blastn	112	75	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfatiglandales			Desulfatiglandales bacterium
4495064	4495064	PRJNA688655_P_NODE_12144_length_246_cov_0.890173_g12079_i0	PRJNA688655	12144	246	0.890173	2.18982558	Desulfosarcina alkanivorans	571177	Bacteria	Bacteria	76.8	1.32e-9	NTclustered	gi\|1773409569\|dbj\|AP021874.1\|	571177	g12079	i0	88.889	5.01626016260163	63	5	25	2	13	73	1309869	1309931	Desulfosarcina alkanivorans PL12 DNA, complete genome	blastn	1234	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina alkanivorans
5770713	5770713	PRJNA688655_P_NODE_12145_length_246_cov_0.890173_g12080_i0	PRJNA688655	12145	246	0.890173	2.18982558	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	78.7	3.67e-10	NTclustered	gi\|2108083302\|gb\|CP070746.1\|	2044940	g12080	i0	88.235	16.5121951219512	68	4	27	4	18	83	2199314	2199379	MAG: Desulfobacterales bacterium isolate bin36 chromosome	blastn	4062	78.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
5770876	5770876	PRJNA688655_P_NODE_9405_length_249_cov_0.875000_g9340_i0	PRJNA688655	9405	249	0.875	2.17875	Syntrophales bacterium	2928017	Bacteria	Bacteria	102	2.21e-17	NTclustered	gi\|2621703594\|emb\|OY761459.1\|	2928017	g9340	i0	82.787	6.82730923694779	122	14	50	7	5	125	2133506	2133391	MAG: Syntrophales bacterium isolate c6a0f7f3-880d-44d6-9c5f-266f97196533 genome assembly, chromosome: 1	blastn	1700	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
10871140	10871140	PRJNA688655_P_NODE_12189_length_246_cov_0.890173_g12124_i0	PRJNA688655	12189	246	0.890173	2.18982558	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	78.7	3.67e-10	NTclustered	gi\|2621704922\|emb\|OY762209.1\|	2660714	g12124	i0	91.228	0.231707317073171	57	5	23	0	137	193	4700382	4700326	MAG: Syntrophorhabdaceae bacterium isolate b67c53bf-795e-48b1-b0c8-2f1cb1e3683a genome assembly, chromosome: 1	blastn	57	78.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium
12146608	12146608	PRJNA688655_P_NODE_8850_length_250_cov_0.870056_g8785_i0	PRJNA688655	8850	250	0.870056	2.17514	Syntrophobacter fumaroxidans	119484	Bacteria	Bacteria	195	3.55e-45	NTclustered	gi\|116696516\|gb\|CP000478.1\|	335543	g8785	i0	81.328	5.948	241	43	96	2	11	250	4323087	4322848	Syntrophobacter fumaroxidans MPOB, complete genome	blastn	1487	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Syntrophobacter	Syntrophobacter fumaroxidans
13421053	13421053	PRJNA688655_P_NODE_13571_length_244_cov_0.900585_g13506_i0	PRJNA688655	13571	244	0.900585	2.1974274	Pseudodesulfovibrio profundus	57320	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|1248817418\|emb\|LT907975.1\|	57320	g13506	i0	98.361	7.66393442622951	244	4	100	0	1	244	622521	622764	Desulfovibrio profundus strain 500-1 genome assembly, chromosome: DPRO	blastn	1870	429	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio profundus
13421105	13421105	PRJNA688655_P_NODE_16671_length_241_cov_0.916667_g16606_i0	PRJNA688655	16671	241	0.916667	2.20916747	Desulfoferula mesophila	3058419	Bacteria	Bacteria	217	7.269999999999999e-52	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g16606	i0	85.784	0.846473029045643	204	29	85	0	1	204	3199098	3199301	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	204	217	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
14696003	14696003	PRJNA688655_P_NODE_10092_length_248_cov_0.880000_g10027_i0	PRJNA688655	10092	248	0.88	2.1824	Desulfosarcina widdelii	947919	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|1773416083\|dbj\|AP021875.1\|	947919	g10027	i0	78.4	2.04435483870968	250	50	100	4	1	248	6585303	6585550	Desulfosarcina widdelii PP31 DNA, complete genome	blastn	507	159	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina widdelii
14696036	14696036	PRJNA688655_P_NODE_12832_length_245_cov_0.895349_g12767_i0	PRJNA688655	12832	245	0.895349	2.19360505	Syntrophus buswellii	43774	Bacteria	Bacteria	357	4.18e-94	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g12767	i0	93.033	20.9510204081633	244	17	99	0	2	245	146807	146564	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	5133	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
15969775	15969775	PRJNA688655_P_NODE_10793_length_248_cov_0.880000_g10728_i0	PRJNA688655	10793	248	0.88	2.1824	Geobacter sulfurreducens	35554	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2269487075\|gb\|CP072789.1\|	35554	g10728	i0	100	20	248	0	100	0	1	248	1887417	1887170	Geobacter sulfurreducens strain PL chromosome, complete genome	blastn	4960	459	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
15969795	15969795	PRJNA688655_P_NODE_12353_length_246_cov_0.890173_g12288_i0	PRJNA688655	12353	246	0.890173	2.18982558	Candidatus Electrothrix sp. GW3-4	3126740	Bacteria	Bacteria	195	3.49e-45	NTclustered	gi\|2706403704\|gb\|CP147990.1\|	3126740	g12288	i0	91.156	4.28861788617886	147	8	59	4	101	246	4030239	4030097	MAG: Candidatus Electrothrix sp. GW3-4 chromosome, complete genome	blastn	1055	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix sp. GW3-4
17245057	17245057	PRJNA688655_P_NODE_12734_length_245_cov_0.895349_g12669_i0	PRJNA688655	12734	245	0.895349	2.19360505	Smithellaceae bacterium	2964540	Bacteria	Bacteria	86.1	2.18e-12	NTclustered	gi\|2626216295\|emb\|OY821638.1\|	2964540	g12669	i0	97.959	1.08979591836735	49	1	20	0	117	165	2878291	2878243	MAG: Smithellaceae bacterium isolate 7d888188-1d27-4603-a379-950c855845c6 genome assembly, chromosome: 1	blastn	267	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
18519177	18519177	PRJNA688655_P_NODE_13075_length_245_cov_0.895349_g13010_i0	PRJNA688655	13075	245	0.895349	2.19360505	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	117	7.73e-22	NTclustered	gi\|2108215174\|gb\|CP070700.1\|	2049433	g13010	i0	91.667	9.59591836734694	84	7	35	0	99	182	2746896	2746979	MAG: Desulfobacteraceae bacterium isolate bin575 chromosome	blastn	2351	117	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
18519230	18519230	PRJNA688655_P_NODE_16795_length_241_cov_0.880952_g16730_i0	PRJNA688655	16795	241	0.880952	2.12309432	Smithellaceae bacterium	2964540	Bacteria	Bacteria	191	4.41e-44	NTclustered	gi\|2626214512\|emb\|OY820932.1\|	2964540	g16730	i0	80.913	1	241	46	100	0	1	241	156164	155924	MAG: Smithellaceae bacterium isolate 90efb5c7-b315-4df1-98b9-9b59cc098579 genome assembly, chromosome: 1	blastn	241	191	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae bacterium
21069639	21069639	PRJNA688655_P_NODE_6057_length_276_cov_1.137931_g5992_i0	PRJNA688655	6057	276	1.137931	3.14068956	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	213	1.1e-50	NTclustered	gi\|2108223025\|gb\|CP070697.1\|	2044940	g5992	i0	80.657	0.992753623188406	274	53	99	0	3	276	5133584	5133857	MAG: Desulfobacterales bacterium isolate bin589 chromosome	blastn	274	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
22344390	22344390	PRJNA688655_P_NODE_10338_length_248_cov_0.880000_g10273_i0	PRJNA688655	10338	248	0.88	2.1824	Pseudodesulfovibrio aespoeensis	182210	Bacteria	Bacteria	195	3.52e-45	NTclustered	gi\|316941978\|gb\|CP002431.1\|	643562	g10273	i0	83.099	18.9838709677419	213	36	86	0	1	213	1238873	1239085	Pseudodesulfovibrio aespoeensis Aspo-2 chromosome, complete genome	blastn	4708	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio aespoeensis
22344592	22344592	PRJNA688655_P_NODE_8838_length_250_cov_0.870056_g8773_i0	PRJNA688655	8838	250	0.870056	2.17514	Desulfonema magnum	45655	Bacteria	Bacteria	60.2	1.35e-4	NTclustered	gi\|2007135636\|gb\|CP061800.1\|	45655	g8773	i0	94.737	0.152	38	2	15	0	80	117	5323486	5323449	Desulfonema magnum strain 4be13 chromosome, complete genome	blastn	38	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfonema	Desulfonema magnum
22344604	22344604	PRJNA688655_P_NODE_9738_length_249_cov_0.875000_g9673_i0	PRJNA688655	9738	249	0.875	2.17875	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	233	7.5e-57	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g9673	i0	83.936	5.77911646586345	249	34	99	5	2	247	934704	934949	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	1439	233	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
22344607	22344607	PRJNA688655_P_NODE_9798_length_249_cov_0.875000_g9733_i0	PRJNA688655	9798	249	0.875	2.17875	Smithellaceae bacterium	2964540	Bacteria	Bacteria	243	1.25e-59	NTclustered	gi\|2626214512\|emb\|OY820932.1\|	2964540	g9733	i0	84.274	1.6425702811245	248	39	99	0	2	249	2070578	2070331	MAG: Smithellaceae bacterium isolate 90efb5c7-b315-4df1-98b9-9b59cc098579 genome assembly, chromosome: 1	blastn	409	243	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Smithellaceae		Smithellaceae 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);;