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

19 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
4168679	4168679	PRJNA1237347_P_NODE_353564_length_301_cov_1.706140_g346991_i0	PRJNA1237347	353564	301	1.70614	5.1354814	Desulfovibrio aminophilus	81425	Bacteria	Bacteria	89.8	2.13e-13	NTclustered	gi\|2908463109\|gb\|CP168306.1\|	81425	g346991	i0	87.179	1.36544850498339	78	10	26	0	18	95	2226962	2227039	MAG: Desulfovibrio aminophilus isolate Co chromosome, complete genome	blastn	411	89.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio aminophilus
6718799	6718799	PRJNA1237347_P_NODE_325726_length_317_cov_1.639344_g319153_i0	PRJNA1237347	325726	317	1.639344	5.19672048	Desulfovibrio piger	901	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g319153	i0	100	0.0914826498422713	29	0	9	0	32	60	1271257	1271229	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
6720615	6720615	PRJNA1237347_P_NODE_417906_length_272_cov_1.547739_g411333_i0	PRJNA1237347	417906	272	1.547739	4.20985008	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	195	3.92e-45	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g411333	i0	79.927	121.139705882353	274	47	99	7	1	270	886799	886530	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	32950	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
7996177	7996177	PRJNA1237347_P_NODE_417847_length_272_cov_1.547739_g411274_i0	PRJNA1237347	417847	272	1.547739	4.20985008	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	217	8.359999999999999e-52	NTclustered	gi\|2891482193\|emb\|OZ219926.1\|	2202153	g411274	i0	83.843	20.0294117647059	229	36	84	1	43	271	774851	774624	MAG: Thermodesulfobacteriota bacterium isolate 21442c6b-cc68-4f82-8039-a5361455a999 genome assembly, chromosome: 3	blastn	5448	217	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
10544625	10544625	PRJNA1237347_P_NODE_303589_length_331_cov_2.701550_g297016_i0	PRJNA1237347	303589	331	2.70155	8.9421305	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	71.3	8.61e-8	NTclustered	gi\|2621780237\|emb\|OY776524.1\|	2044940	g297016	i0	100	0.229607250755287	38	0	11	0	242	279	3058448	3058411	MAG: Desulfobacterales bacterium isolate 4b92870f-ba81-4c82-9d98-8a89c3612312 genome assembly, chromosome: 1	blastn	76	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
13090013	13090013	PRJNA1237347_P_NODE_104551_length_662_cov_2.327674_g98120_i0	PRJNA1237347	104551	662	2.327674	15.40920188	Pelobacter propionicus	29543	Bacteria	Bacteria	569	1.4699999999999994e-157	NTclustered	gi\|118501159\|gb\|CP000482.1\|	338966	g98120	i0	82.542	113.791540785498	653	108	98	6	4	653	1995079	1994430	Pelobacter propionicus DSM 2379, complete genome	blastn	75330	569	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Pelobacter	Pelobacter propionicus
13095490	13095490	PRJNA1237347_P_NODE_359911_length_298_cov_1.222222_g353338_i0	PRJNA1237347	359911	298	1.222222	3.64222156	Syntrophus buswellii	43774	Bacteria	Bacteria	357	5.24e-94	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g353338	i0	88.294	38.9093959731544	299	33	100	2	1	298	3206961	3207258	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	11595	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
14368334	14368334	PRJNA1237347_P_NODE_238912_length_385_cov_244.669872_g232339_i0	PRJNA1237347	238912	385	244.669872	941.9790072	Taurinivorans muris	2787751	Bacteria	Bacteria	73.1	2.82e-8	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g232339	i0	85.915	3.26233766233766	71	6	18	4	317	385	1446448	1446516	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	1256	73.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
14372269	14372269	PRJNA1237347_P_NODE_439072_length_263_cov_2.915789_g432499_i0	PRJNA1237347	439072	263	2.915789	7.66852507	Desulfomicrobium orale	132132	Bacteria	Bacteria	60.2	1.43e-4	NTclustered	gi\|987456218\|gb\|CP014230.1\|	888061	g432499	i0	92.857	2.1787072243346	42	2	16	1	1	41	2252709	2252750	Desulfomicrobium orale DSM 12838 chromosome, complete genome	blastn	573	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium orale
16918133	16918133	PRJNA1237347_P_NODE_325414_length_317_cov_2.122951_g318841_i0	PRJNA1237347	325414	317	2.122951	6.72975467	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	110	1.74e-19	NTclustered	gi\|2381092847\|gb\|CP113000.1\|	2202153	g318841	i0	95.588	23.018927444795	68	3	21	0	1	68	2562996	2563063	MAG: Thermodesulfobacteriota bacterium isolate ORM2a chromosome, complete genome	blastn	7297	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
16920907	16920907	PRJNA1237347_P_NODE_466914_length_253_cov_0.827778_g460341_i0	PRJNA1237347	466914	253	0.827778	2.09427834	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	86.1	2.26e-12	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g460341	i0	74.468	2.34782608695652	235	42	90	15	24	250	1925796	1925572	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	594	86.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
19465658	19465658	PRJNA1237347_P_NODE_252356_length_372_cov_2.551839_g245783_i0	PRJNA1237347	252356	372	2.551839	9.49284108	Desulfoferula mesophila	3058419	Bacteria	Bacteria	60.2	2.11e-4	NTclustered	gi\|2619692108\|dbj\|AP028679.1\|	3058419	g245783	i0	94.872	0.104838709677419	39	1	10	1	69	107	2970162	2970199	Desulfoferula mesophila 12FAK DNA, complete genome	blastn	39	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfoferula	Desulfoferula mesophila
19471082	19471082	PRJNA1237347_P_NODE_536056_length_243_cov_0.905882_g529483_i0	PRJNA1237347	536056	243	0.905882	2.20129326	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g529483	i0	100	1	243	0	100	0	1	243	2133418	2133176	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	243	449	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
20744677	20744677	PRJNA1237347_P_NODE_436157_length_265_cov_1.187500_g429584_i0	PRJNA1237347	436157	265	1.1875	3.146875	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	67.6	8.65e-7	NTclustered	gi\|2893358420\|emb\|OZ220712.1\|	2202153	g429584	i0	97.5	55.1811320754717	40	0	23	1	172	210	2505478	2505517	MAG: Thermodesulfobacteriota bacterium isolate 564989d4-0a31-48dd-8468-51938819ad86 genome assembly, chromosome: 1	blastn	14623	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
22018429	22018429	PRJNA1237347_P_NODE_35678_length_1291_cov_3.157635_g31732_i0	PRJNA1237347	35678	1291	3.157635	40.76506785	Geobacter pickeringii	345632	Bacteria	Bacteria	540	2.3099999999999995e-148	NTclustered	gi\|747129828\|gb\|CP009788.1\|	345632	g31732	i0	75.733	509.85050348567	1228	214	91	67	9	1182	2446669	2445472	Geobacter pickeringii strain G13, complete genome	blastn	658217	540	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
22022014	22022014	PRJNA1237347_P_NODE_550558_length_241_cov_1.833333_g543985_i0	PRJNA1237347	550558	241	1.833333	4.41833253	Thermodesulfatator indicus	171695	Bacteria	Bacteria	169	2.0599999999999997e-37	NTclustered	gi\|335358205\|gb\|CP002683.1\|	667014	g543985	i0	83.422	33.5103734439834	187	26	76	4	1	184	1535525	1535341	Thermodesulfatator indicus DSM 15286, complete genome	blastn	8076	169	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Thermodesulfobacteria	Thermodesulfobacteriales	Thermodesulfatatoraceae	Thermodesulfatator	Thermodesulfatator indicus
23294532	23294532	PRJNA1237347_P_NODE_381219_length_288_cov_0.902326_g374646_i0	PRJNA1237347	381219	288	0.902326	2.59869888	Geoalkalibacter subterraneus	483547	Bacteria	Bacteria	75	5.69e-9	NTclustered	gi\|749207097\|gb\|CP010311.1\|	483547	g374646	i0	88.525	0.211805555555556	61	7	21	0	220	280	261872	261932	Geoalkalibacter subterraneus strain Red1, complete genome	blastn	61	75	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geoalkalibacteraceae	Geoalkalibacter	Geoalkalibacter subterraneus
23297229	23297229	PRJNA1237347_P_NODE_524779_length_245_cov_0.877907_g518206_i0	PRJNA1237347	524779	245	0.877907	2.15087215	Thermodesulfomicrobium sp. WS	3004129	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2416254156\|dbj\|AP027130.1\|	3004129	g518206	i0	99.592	2.77959183673469	245	1	100	0	1	245	927487	927243	Thermodesulfomicrobium sp. WS DNA, complete genome	blastn	681	448	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Thermodesulfomicrobium	Thermodesulfomicrobium sp. WS
24569123	24569123	PRJNA1237347_P_NODE_421980_length_270_cov_2.736041_g415407_i0	PRJNA1237347	421980	270	2.736041	7.3873107	Desulfobulbus oralis	1986146	Bacteria	Bacteria	63.9	1.14e-5	NTclustered	gi\|1343450889\|gb\|CP021255.1\|	1986146	g415407	i0	80.208	0.796296296296296	96	9	66	3	104	194	1109135	1109045	Desulfobulbus oralis strain HOT041/ORNL chromosome, complete genome	blastn	215	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus oralis

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