metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA529241" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA529241" 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
499705	499705	PRJNA529241_P_NODE_271101_length_173_cov_3.992647_g268779_i0	PRJNA529241	271101	173	3.992647	6.90727931	Desulfosarcina ovata	83564	Bacteria	Bacteria	67.6	5.19e-7	NTclustered	gi\|1774952549\|dbj\|AP021879.1\|	2752305	g268779	i0	97.5	4.87861271676301	40	0	23	1	117	155	7176364	7176325	Desulfosarcina ovata subsp. ovata oXyS1 DNA, complete genome	blastn	844	67.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	Desulfosarcina ovata
1776316	1776316	PRJNA529241_P_NODE_439402_length_160_cov_6.081301_g437080_i0	PRJNA529241	439402	160	6.081301	9.7300816	Desulfovibrio piger	901	Bacteria	Bacteria	193	7.489999999999999e-45	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g437080	i0	88.608	98.8	158	18	99	0	3	160	1559750	1559907	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	15808	193	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
2391663	2391663	PRJNA529241_P_NODE_486922_length_151_cov_6.070175_g484600_i0	PRJNA529241	486922	151	6.070175	9.16596425	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	143	7.11e-30	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g484600	i0	98.75	4.10596026490066	80	1	100	0	72	151	3373875	3373954	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	620	143	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
3049974	3049974	PRJNA529241_P_NODE_179043_length_173_cov_9.705882_g176721_i0	PRJNA529241	179043	173	9.705882	16.79117586	Geotalea uraniireducens	351604	Bacteria	Bacteria	71.3	4.01e-8	NTclustered	gi\|146395585\|gb\|CP000698.1\|	351605	g176721	i0	86.154	3.73988439306358	65	9	38	0	9	73	5093815	5093879	Geobacter uraniireducens Rf4, complete genome	blastn	647	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geotalea	Geotalea uraniireducens
3050098	3050098	PRJNA529241_P_NODE_193163_length_173_cov_6.727941_g190841_i0	PRJNA529241	193163	173	6.727941	11.63933793	uncultured Desulfobacter sp.	240139	Bacteria	Bacteria	71.3	4.01e-8	NTclustered	gi\|2621700914\|emb\|OY759748.1\|	240139	g190841	i0	84.507	1.07514450867052	71	11	41	0	100	170	4470454	4470524	MAG: uncultured Desulfobacter sp. isolate d0620cd2-44ed-4ad5-9930-dc425a2a51ce genome assembly, chromosome: 1	blastn	186	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	uncultured Desulfobacter sp.
4325052	4325052	PRJNA529241_P_NODE_108364_length_211_cov_2.419540_g106042_i0	PRJNA529241	108364	211	2.41954	5.1052294	Desulfolutivibrio sulfodismutans	63561	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|1863422180\|gb\|CP045504.1\|	1121464	g106042	i0	100	0.132701421800948	28	0	13	0	172	199	3705034	3705007	Desulfolutivibrio sulfodismutans DSM 3696 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfolutivibrio	Desulfolutivibrio sulfodismutans
6219333	6219333	PRJNA529241_P_NODE_379365_length_173_cov_2.588235_g377043_i0	PRJNA529241	379365	173	2.588235	4.47764655	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	130	6.53e-26	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g377043	i0	97.368	0.878612716763006	76	2	44	0	98	173	2823427	2823502	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	152	130	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
6878211	6878211	PRJNA529241_P_NODE_387286_length_173_cov_2.470588_g384964_i0	PRJNA529241	387286	173	2.470588	4.27411724	Desulfovibrio sp. 86	2666132	Bacteria	Bacteria	99	1.84e-16	NTclustered	gi\|1862956133\|emb\|LR738849.1\|	2666132	g384964	i0	90.541	0.427745664739884	74	7	43	0	1	74	374052	374125	Desulfovibrio sp. 86 genome assembly, chromosome: DESU86	blastn	74	99	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 86
8152946	8152946	PRJNA529241_P_NODE_311627_length_173_cov_3.367647_g309305_i0	PRJNA529241	311627	173	3.367647	5.82602931	Desulfovibrio desulfuricans	876	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2022650692\|gb\|CP072608.1\|	876	g309305	i0	100	6.94797687861272	76	0	88	0	1	76	793692	793767	Desulfovibrio desulfuricans strain L4 chromosome, complete genome	blastn	1202	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
8153381	8153381	PRJNA529241_P_NODE_369207_length_173_cov_2.676471_g366885_i0	PRJNA529241	369207	173	2.676471	4.63029483	Desulfovibrio piger	901	Bacteria	Bacteria	82.4	1.85e-11	NTclustered	gi\|2548467271\|emb\|OX636706.1\|	901	g366885	i0	86.486	18.7225433526012	74	10	43	0	100	173	860198	860271	Desulfovibrio piger isolate DSM32187 genome assembly, chromosome: 1	blastn	3239	82.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
11318830	11318830	PRJNA529241_P_NODE_368449_length_173_cov_2.683824_g366127_i0	PRJNA529241	368449	173	2.683824	4.64301552	Candidatus Thermofonsia Clade 3	2364209	Bacteria	Bacteria	99	1.84e-16	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g366127	i0	91.667	54.9132947976879	72	4	43	2	99	169	2552800	2552730	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	9500	100	0.99	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
11978319	11978319	PRJNA529241_P_NODE_255970_length_173_cov_4.301471_g253648_i0	PRJNA529241	255970	173	4.301471	7.44154483	Solidesulfovibrio magneticus	184917	Bacteria	Bacteria	128	2.35e-25	NTclustered	gi\|239794502\|dbj\|AP010904.1\|	573370	g253648	i0	97.333	1.30057803468208	75	2	87	0	98	172	1914619	1914545	Desulfovibrio magneticus RS-1 DNA, complete genome	blastn	225	128	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
12594458	12594458	PRJNA529241_P_NODE_312610_length_173_cov_3.352941_g310288_i0	PRJNA529241	312610	173	3.352941	5.80058793	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g310288	i0	100	14.1329479768786	76	0	87	0	1	76	763329	763254	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	2445	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
13253457	13253457	PRJNA529241_P_NODE_266971_length_173_cov_4.080882_g264649_i0	PRJNA529241	266971	173	4.080882	7.05992586	Geobacter sulfurreducens	35554	Bacteria	Bacteria	174	2.97e-39	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g264649	i0	83.851	10.757225433526	161	19	93	2	13	173	872277	872124	Geobacter sulfurreducens strain AM-1 genome	blastn	1861	174	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
13869448	13869448	PRJNA529241_P_NODE_346391_length_173_cov_2.911765_g344069_i0	PRJNA529241	346391	173	2.911765	5.03735345	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g344069	i0	100	3.51445086705202	76	0	88	0	1	76	2721072	2721147	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	608	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
16417971	16417971	PRJNA529241_P_NODE_247533_length_173_cov_4.485294_g245211_i0	PRJNA529241	247533	173	4.485294	7.75955862	Desulfovibrio	872	Bacteria	Bacteria	139	1.08e-28	NTclustered	gi\|1894914451\|emb\|LT984798.1\|	631220	g245211	i0	100	2.15606936416185	75	0	43	0	99	173	1400293	1400367	Desulfovibrio sp. G11 isolate G11PacBio genome assembly, chromosome: 1	blastn	373	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. G11
17694321	17694321	PRJNA529241_P_NODE_534774_length_151_cov_3.368421_g532452_i0	PRJNA529241	534774	151	3.368421	5.08631571	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	119	1.2e-22	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g532452	i0	94.737	4.02649006622517	76	4	100	0	76	151	2287301	2287226	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	608	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
19626519	19626519	PRJNA529241_P_NODE_388176_length_173_cov_2.455882_g385854_i0	PRJNA529241	388176	173	2.455882	4.24867586	Desulfomicrobium orale	132132	Bacteria	Bacteria	195	2.28e-45	NTclustered	gi\|987456218\|gb\|CP014230.1\|	888061	g385854	i0	87.283	1	173	7	100	1	1	173	567591	567434	Desulfomicrobium orale DSM 12838 chromosome, complete genome	blastn	173	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium orale
20901834	20901834	PRJNA529241_P_NODE_272057_length_173_cov_3.977941_g269735_i0	PRJNA529241	272057	173	3.977941	6.88183793	Geomonas oryzisoli	2847992	Bacteria	Bacteria	87.9	3.98e-13	NTclustered	gi\|2056214585\|gb\|CP076723.1\|	2847992	g269735	i0	91.935	29.6994219653179	62	5	36	0	7	68	4757002	4756941	Geomonas oryzisoli strain RG10 chromosome, complete genome	blastn	5138	87.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas oryzisoli
22176137	22176137	PRJNA529241_P_NODE_237658_length_173_cov_4.750000_g235336_i0	PRJNA529241	237658	173	4.75	8.2175	uncultured Desulfospira sp.	232702	Bacteria	Bacteria	71.3	4.01e-8	NTclustered	gi\|2621704103\|emb\|OY761554.1\|	232702	g235336	i0	88.136	1.02312138728324	59	7	34	0	17	75	1488097	1488039	MAG: uncultured Desulfospira sp. isolate 5198f45b-3c99-4a6a-ad95-b1a64aaf42d9 genome assembly, chromosome: 1	blastn	177	71.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfospira	uncultured Desulfospira sp.
24068532	24068532	PRJNA529241_P_NODE_585999_length_150_cov_2.991150_g583677_i0	PRJNA529241	585999	150	2.99115	4.486725	Nitratidesulfovibrio	2802295	Bacteria	Bacteria	239	8.74e-59	NTclustered	gi\|2431399063\|gb\|CP116248.1\|	881	g583677	i0	94.904	4.18666666666667	157	1	100	1	1	150	10651	10495	Nitratidesulfovibrio vulgaris strain L2 plasmid pDsulf-L2-1, complete sequence	blastn	628	239	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
24726628	24726628	PRJNA529241_P_NODE_405200_length_172_cov_3.325926_g402878_i0	PRJNA529241	405200	172	3.325926	5.72059272	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g402878	i0	96.97	0.686046511627907	33	1	19	0	117	149	6219857	6219825	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	118	56.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
25342818	25342818	PRJNA529241_P_NODE_544160_length_151_cov_3.096491_g541838_i0	PRJNA529241	544160	151	3.096491	4.67570141	Pseudomonadati	3379134	Bacteria	Bacteria	130	5.53e-26	NTclustered	gi\|779731694\|gb\|CP010430.1\|	35554	g541838	i0	97.368	5.96688741721854	76	2	50	0	1	76	882448	882523	Geobacter sulfurreducens strain AM-1 genome	blastn	901	130	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens

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