metadata: contig_metadata: 30 rows where bioproject = "PRJNA316313", tax_kingdom = "Pseudomonadati" and tax

30 rows where bioproject = "PRJNA316313", tax_kingdom = "Pseudomonadati" 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
386305	386305	PRJNA316313_P_NODE_156801_length_187_cov_4.420000_g155415_i0	PRJNA316313	156801	187	4.42	8.2654	Nitratidesulfovibrio sp. HK-II	2009266	Bacteria	Bacteria	93.5	9.43e-15	NTclustered	gi\|2791413552\|dbj\|AP036014.1\|	2009266	g155415	i0	89.189	3.5668449197861	74	8	40	0	3	76	2030826	2030753	Nitratidesulfovibrio sp. HK-II DNA, complete genome	blastn	667	93.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio sp. HK-II
387936	387936	PRJNA316313_P_NODE_438641_length_151_cov_4.000000_g437255_i0	PRJNA316313	438641	151	4	6.04	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	62.1	2.05e-5	NTclustered	gi\|2893358418\|emb\|OZ220710.1\|	2202153	g437255	i0	94.872	0.443708609271523	39	2	26	0	108	146	101462	101424	MAG: Thermodesulfobacteriota bacterium isolate dce1034a-8f23-488c-aa07-39e6c80a0035 genome assembly, chromosome: 1	blastn	67	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
1067554	1067554	PRJNA316313_P_NODE_190681_length_187_cov_3.593333_g189295_i0	PRJNA316313	190681	187	3.593333	6.71953271	Desulfovibrio	872	Bacteria	Bacteria	102	1.57e-17	NTclustered	gi\|1894914451\|emb\|LT984798.1\|	631220	g189295	i0	90.789	1.2192513368984	76	7	41	0	112	187	2913897	2913972	Desulfovibrio sp. G11 isolate G11PacBio genome assembly, chromosome: 1	blastn	228	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. G11
2936701	2936701	PRJNA316313_P_NODE_128823_length_187_cov_8.833333_g127437_i0	PRJNA316313	128823	187	8.833333	16.51833271	Desulfomicrobium orale	132132	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|987456218\|gb\|CP014230.1\|	888061	g127437	i0	100	0.812834224598931	76	0	81	0	112	187	321371	321446	Desulfomicrobium orale DSM 12838 chromosome, complete genome	blastn	152	141	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium orale
2938851	2938851	PRJNA316313_P_NODE_485243_length_150_cov_5.097345_g483857_i0	PRJNA316313	485243	150	5.097345	7.6460175	Geomonas paludis	2740185	Bacteria	Bacteria	87.9	3.35e-13	NTclustered	gi\|2233265061\|gb\|CP096574.1\|	2740185	g483857	i0	88	0.5	75	7	49	2	77	150	4280349	4280276	Geomonas paludis strain RG22 chromosome, complete genome	blastn	75	87.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas paludis
3619274	3619274	PRJNA316313_P_NODE_507683_length_150_cov_2.884956_g506297_i0	PRJNA316313	507683	150	2.884956	4.327434	Pseudomonadati	3379134	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2045533567\|gb\|CP074693.1\|	35554	g506297	i0	100	55.12	150	0	100	0	1	150	81591	81442	Geobacter sulfurreducens strain YM35 chromosome, complete genome	blastn	8268	278	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sulfurreducens
8040951	8040951	PRJNA316313_P_NODE_389747_length_155_cov_4.406780_g388361_i0	PRJNA316313	389747	155	4.40678	6.830509	Citrifermentans bemidjiense	225194	Bacteria	Bacteria	110	7.46e-20	NTclustered	gi\|197085762\|gb\|CP001124.1\|	404380	g388361	i0	89.655	52.1548387096774	87	8	56	1	69	155	2088963	2089048	Geobacter bemidjiensis Bem, complete genome	blastn	8084	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bemidjiense
9315157	9315157	PRJNA316313_P_NODE_310348_length_187_cov_2.360000_g308962_i0	PRJNA316313	310348	187	2.36	4.4132	Pseudodesulfovibrio portus	231439	Bacteria	Bacteria	60.2	9.57e-5	NTclustered	gi\|2296712847\|dbj\|AP026708.1\|	231439	g308962	i0	100	0.171122994652406	32	0	17	0	117	148	2164233	2164202	Pseudodesulfovibrio portus JCM 14722 DNA, complete genome	blastn	32	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio portus
9315403	9315403	PRJNA316313_P_NODE_349488_length_179_cov_2.746479_g348102_i0	PRJNA316313	349488	179	2.746479	4.91619741	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	100	5.34e-17	NTclustered	gi\|2556892445\|gb\|CP129479.1\|	2202153	g348102	i0	85.714	323.860335195531	98	10	56	4	40	135	1898904	1898999	MAG: Thermodesulfobacteriota bacterium isolate cMAG.17 chromosome, complete genome	blastn	57971	100	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
11864926	11864926	PRJNA316313_P_NODE_151890_length_187_cov_4.606667_g150504_i0	PRJNA316313	151890	187	4.606667	8.61446729	Megalodesulfovibrio gigas	879	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|544197442\|gb\|CP006585.1\|	1121448	g150504	i0	100	0.155080213903743	29	0	16	0	137	165	2725983	2725955	Desulfovibrio gigas DSM 1382 = ATCC 19364 genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Megalodesulfovibrio	Megalodesulfovibrio gigas
15689343	15689343	PRJNA316313_P_NODE_22593_length_355_cov_10.553459_g21224_i0	PRJNA316313	22593	355	10.553459	37.46477945	Geobacter sp. SVR	2495594	Bacteria	Bacteria	219	3.13e-52	NTclustered	gi\|1976315905\|dbj\|AP024469.1\|	2495594	g21224	i0	82.308	67.3211267605634	260	38	72	8	87	342	3337298	3337553	Geobacter sp. SVR DNA, complete genome	blastn	23899	219	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp. SVR
15690624	15690624	PRJNA316313_P_NODE_439913_length_151_cov_3.956140_g438527_i0	PRJNA316313	439913	151	3.95614	5.9737714	Desulfovibrio piger	901	Bacteria	Bacteria	60.2	7.36e-5	NTclustered	gi\|1102127722\|emb\|LT630450.1\|	901	g438527	i0	94.737	0.251655629139073	38	2	25	0	12	49	1348438	1348401	Desulfovibrio piger isolate FI11049 genome assembly, chromosome: I	blastn	38	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio piger
18238559	18238559	PRJNA316313_P_NODE_274435_length_187_cov_2.593333_g273049_i0	PRJNA316313	274435	187	2.593333	4.84953271	Desulfovibrio ferrophilus	241368	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1352279194\|dbj\|AP017378.1\|	241368	g273049	i0	100	0.149732620320856	28	0	15	0	34	61	592829	592802	Desulfovibrio ferrophilus DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio ferrophilus
22064281	22064281	PRJNA316313_P_NODE_424718_length_151_cov_4.649123_g423332_i0	PRJNA316313	424718	151	4.649123	7.02017573	Desulfomicrobium sp. ZS1	2952228	Bacteria	Bacteria	62.1	2.05e-5	NTclustered	gi\|2269306666\|gb\|CP100351.1\|	2952228	g423332	i0	92.857	0.278145695364238	42	3	28	0	33	74	3719120	3719079	Desulfomicrobium sp. ZS1 chromosome, complete genome	blastn	42	62.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium sp. ZS1
26870733	26870733	PRJNA316313_P_NODE_210621_length_187_cov_3.286667_g209235_i0	PRJNA316313	210621	187	3.286667	6.14606729	Pseudomonadati	3379134	Bacteria	Bacteria	93.2	1.13e-20	NR	WP_198015318.1	42252	g209235	i0	79	7.9572192513369	62	5	99.5	1	186	1	221	274	WP_198015318.1 polysaccharide biosynthesis/export family protein [Nitratidesulfovibrio termitidis]	diamond	1488	93.6	0.995726495726496	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio termitidis
27801205	27801205	PRJNA316313_P_NODE_392684_length_154_cov_2.452991_g391298_i0	PRJNA316313	392684	154	2.452991	3.77760614	Desulfurivibrio sp. C	2093369	Bacteria	Bacteria	86.3	4.9e-18	NR	WP_395493285.1	3374371	g391298	i0	87.8	1.92857142857143	49	6	95.5	0	3	149	792	840	WP_395493285.1 ATP-binding protein [Desulfurivibrio sp. C05AmB]	diamond	297	86.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio sp. C05AmB
28937803	28937803	PRJNA316313_P_NODE_202788_length_187_cov_3.413333_g201402_i0	PRJNA316313	202788	187	3.413333	6.38293271	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	53.1	3.73e-6	NR	MDD3474045.1	2052184	g201402	i0	92	0.401069518716578	25	2	40.1	0	75	1	5	29	MDD3474045.1 glycosyltransferase family 1 protein [Syntrophaceae bacterium]	diamond	75	53.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
29302397	29302397	PRJNA316313_P_NODE_316429_length_187_cov_2.293333_g315043_i0	PRJNA316313	316429	187	2.293333	4.28853271	Bacteria	2	Bacteria	Bacteria	48.5	1.62e-4	NR	HAJ25753.1	48412	g315043	i0	96	8.21390374331551	25	1	40.1	0	187	113	216	240	HAJ25753.1 nucleotide sugar dehydrogenase [Syntrophus sp. (in: bacteria)]	diamond	1536	48.9	0.991820040899796	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus sp. (in: bacteria)
29631998	29631998	PRJNA316313_P_NODE_251130_length_187_cov_2.840000_g249744_i0	PRJNA316313	251130	187	2.84	5.3108	Desulfovibrio sp. 6_1_46AFAA	665942	Bacteria	Bacteria	52.4	7.05e-6	NR	WP_009302255.1	665942	g249744	i0	42.9	2.18181818181818	77	28	97.9	1	184	2	338	414	WP_009302255.1 Ig-like domain-containing protein, partial [Desulfovibrio sp. 6_1_46AFAA]	diamond	408	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp. 6_1_46AFAA
29632046	29632046	PRJNA316313_P_NODE_498970_length_150_cov_3.469027_g497584_i0	PRJNA316313	498970	150	3.469027	5.2035405	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	88.2	1.03e-18	NR	MDD3471670.1	2052184	g497584	i0	84.9	1.06	53	5	100	1	150	1	335	387	MDD3471670.1 asparagine synthase (glutamine-hydrolyzing) [Syntrophaceae bacterium]	diamond	159	88.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
29790082	29790082	PRJNA316313_P_NODE_446691_length_151_cov_3.728070_g445305_i0	PRJNA316313	446691	151	3.72807	5.6293857	Deferrisoma camini	1035120	Bacteria	Bacteria	45.4	0.00119	NR	WP_084319572.1	1035120	g445305	i0	56.7	1.8476821192053	30	13	59.6	0	91	2	22	51	WP_084319572.1 TIR domain-containing protein [Deferrisoma camini]	diamond	279	45.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Deferrisomatia	Deferrisomatales	Deferrisomataceae	Deferrisoma	Deferrisoma camini
29979751	29979751	PRJNA316313_P_NODE_424151_length_151_cov_4.684211_g422765_i0	PRJNA316313	424151	151	4.684211	7.07315861	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	56.2	1.77e-7	NR	MEW5914430.1	2202153	g422765	i0	59.3	1.0728476821192101	54	18	99.3	2	150	1	152	205	MEW5914430.1 SAM-dependent methyltransferase [Thermodesulfobacteriota bacterium]	diamond	162	56.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30154827	30154827	PRJNA316313_P_NODE_62272_length_242_cov_2.921951_g60886_i0	PRJNA316313	62272	242	2.921951	7.07112142	Pseudomonadati	3379134	Bacteria	Bacteria	134	2.55e-34	NR	WP_374290838.1	876	g60886	i0	82.5	5.9504132231405	80	14	99.2	0	1	240	328	407	WP_374290838.1 ATP-binding protein [Desulfovibrio desulfuricans]	diamond	1440	135	0.992592592592593	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio desulfuricans
30485369	30485369	PRJNA316313_P_NODE_82213_length_220_cov_3.469945_g80827_i0	PRJNA316313	82213	220	3.469945	7.633879	Desulfurivibrio sp. C	2093369	Bacteria	Bacteria	128	1.73e-32	NR	WP_395493285.1	3374371	g80827	i0	83.3	1.93636363636364	72	12	98.2	0	3	218	716	787	WP_395493285.1 ATP-binding protein [Desulfurivibrio sp. C05AmB]	diamond	426	128	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio sp. C05AmB
30516871	30516871	PRJNA316313_P_NODE_39993_length_282_cov_3.200000_g38611_i0	PRJNA316313	39993	282	3.2	9.024	Desulfobotulus mexicanus	2586642	Bacteria	Bacteria	51.6	3.87e-5	NR	WP_342774313.1	2586642	g38611	i0	96	3.19148936170213	25	1	26.6	0	207	281	1	25	WP_342774313.1 glucose-1-phosphate thymidylyltransferase RfbA [Desulfobotulus mexicanus]	diamond	900	51.6	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobotulus	Desulfobotulus mexicanus
30643067	30643067	PRJNA316313_P_NODE_157173_length_187_cov_4.406667_g155787_i0	PRJNA316313	157173	187	4.406667	8.24046729	Desulfovibrio	872	Bacteria	Bacteria	47.8	2.94e-4	NR	WP_195840930.1	872	g155787	i0	83.3	0.385026737967914	24	4	38.5	0	114	185	489	512	WP_195840930.1 MULTISPECIES: sigma 54-interacting transcriptional regulator [Desulfovibrio]	diamond	72	47.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio
30864309	30864309	PRJNA316313_P_NODE_343654_length_182_cov_4.572414_g342268_i0	PRJNA316313	343654	182	4.572414	8.32179348	Candidatus Adiutrix sp.	2872164	Bacteria	Bacteria	48.9	1.09e-4	NR	MDR1045021.1	2872164	g342268	i0	50.9	0.873626373626374	53	26	87.4	0	166	8	15	67	MDR1045021.1 tetratricopeptide repeat protein [Candidatus Adiutrix sp.]	diamond	159	48.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Candidatus Adiutricales	Candidatus Adiutricaceae	Candidatus Adiutrix	Candidatus Adiutrix sp.
30896133	30896133	PRJNA316313_P_NODE_176634_length_187_cov_3.866667_g175248_i0	PRJNA316313	176634	187	3.866667	7.23066729	Geobacter sp.	46610	Bacteria	Bacteria	46.2	9.71e-4	NR	MFA6823724.1	46610	g175248	i0	95.8	0.385026737967914	24	1	38.5	0	114	185	24	47	MFA6823724.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Geobacter sp.]	diamond	72	46.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter sp.
30959259	30959259	PRJNA316313_P_NODE_333134_length_186_cov_3.255034_g331748_i0	PRJNA316313	333134	186	3.255034	6.05436324	Syntrophaceae bacterium	2052184	Bacteria	Bacteria	47.4	4.17e-4	NR	MDD3472921.1	2052184	g331748	i0	76	0.806451612903226	25	6	40.3	0	186	112	119	143	MDD3472921.1 DUF6178 family protein [Syntrophaceae bacterium]	diamond	150	47.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae		Syntrophaceae bacterium
32824160	32824160	PRJNA316313_P_NODE_213420_length_187_cov_3.240000_g212034_i0	PRJNA316313	213420	187	3.24	6.0588	Desulfobaccales bacterium	3064668	Bacteria	Bacteria	43.1	0.0133	NR	MFA5110773.1	3064668	g212034	i0	41	0.978609625668449	61	30	88.2	1	1	165	44	104	MFA5110773.1 hypothetical protein [Desulfobaccales bacterium]	diamond	183	43.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales			Desulfobaccales 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);;