metadata: contig_metadata: 17 rows where bioproject = "PRJNA1118794", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA1118794", 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
6609077	6609077	PRJNA1118794_P_NODE_6886_length_535_cov_2.331169_g6147_i0	PRJNA1118794	6886	535	2.331169	12.47175415	Oceanidesulfovibrio marinus	370038	Bacteria	Bacteria	298	6.11e-76	NTclustered	gi\|1841667704\|gb\|CP039543.1\|	370038	g6147	i0	77.248	65.3233644859813	545	101	100	20	1	535	1175187	1174656	Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome	blastn	34948	298	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Oceanidesulfovibrio	Oceanidesulfovibrio marinus
10433866	10433866	PRJNA1118794_P_NODE_17609_length_354_cov_2.024911_g16859_i0	PRJNA1118794	17609	354	2.024911	7.16818494	Desulfolithobacter dissulfuricans	2795293	Bacteria	Bacteria	95.3	5.49e-15	NTclustered	gi\|2304357171\|dbj\|AP024233.1\|	2795293	g16859	i0	74.167	1.88135593220339	240	56	68	5	109	347	1925825	1925591	Desulfobulbaceae bacterium GF1 GF1 DNA, complete genome	blastn	666	95.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfolithobacter	Desulfolithobacter dissulfuricans
14259289	14259289	PRJNA1118794_P_NODE_10432_length_438_cov_1.126027_g9684_i0	PRJNA1118794	10432	438	1.1260269999999999	4.93199826	root	1	Root_unresolved	Root_unresolved	238	7.11e-74	NR	WP_011340756.1	19	g9684	i0	81.1	68.9041095890411	143	27	97.9	0	10	438	321	463	WP_011340756.1 NADP-dependent isocitrate dehydrogenase [Syntrophotalea carbinolica]	diamond	30180	240	0.991666666666667	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Syntrophotaleaceae	Syntrophotalea	Syntrophotalea carbinolica
14260075	14260075	PRJNA1118794_P_NODE_72592_length_241_cov_0.916667_g71842_i0	PRJNA1118794	72592	241	0.916667	2.20916747	Desulfosediminicola ganghwensis	2569540	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1861338669\|gb\|CP050699.1\|	2569540	g71842	i0	100	0.116182572614108	28	0	12	0	159	186	584552	584525	Desulfosediminicola ganghwensis strain IMCC35004 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfosediminicola	Desulfosediminicola ganghwensis
16807807	16807807	PRJNA1118794_P_NODE_39174_length_270_cov_2.918782_g38424_i0	PRJNA1118794	39174	270	2.918782	7.8807114	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	139	3.03e-36	NR	MCU0563454.1	2044940	g38424	i0	86.4	0.977777777777778	88	12	97.8	0	6	269	367	454	MCU0563454.1 TRAP transporter fused permease subunit [Desulfobacterales bacterium]	diamond	264	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
21907715	21907715	PRJNA1118794_P_NODE_45858_length_256_cov_1.683060_g45108_i0	PRJNA1118794	45858	256	1.68306	4.3086336	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	213	1.01e-50	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g45108	i0	82.353	258.7109375	255	36	98	9	3	253	487786	488035	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	66230	213	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
28204841	28204841	PRJNA1118794_P_NODE_26506_length_307_cov_1.307692_g25756_i0	PRJNA1118794	26506	307	1.307692	4.01461444	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	49.7	2.75e-5	NR	MEE9215753.1	2202153	g25756	i0	35.4	1.20195439739414	65	42	63.5	0	90	284	24	88	MEE9215753.1 hypothetical protein [Thermodesulfobacteriota bacterium]	diamond	369	49.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
28362828	28362828	PRJNA1118794_P_NODE_67926_length_243_cov_0.905882_g67176_i0	PRJNA1118794	67926	243	0.905882	2.20129326	Solidesulfovibrio magneticus RS-1	573370	Bacteria	Bacteria	70.5	1.28e-13	NR	BAH74434.1	573370	g67176	i0	56.7	0.740740740740741	60	26	74.1	0	45	224	40	99	BAH74434.1 hypothetical protein DMR_09430 [Solidesulfovibrio magneticus RS-1]	diamond	180	70.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Solidesulfovibrio	Solidesulfovibrio magneticus
28732923	28732923	PRJNA1118794_P_NODE_47787_length_252_cov_1.720670_g47037_i0	PRJNA1118794	47787	252	1.72067	4.3360884	Pseudomonadati	3379134	Bacteria	Bacteria	97.4	4.72e-22	NR	MEW6272298.1	2202153	g47037	i0	54.3	3.83333333333333	81	37	96.4	0	250	8	2	82	MEW6272298.1 GDP-mannose 4,6-dehydratase [Thermodesulfobacteriota bacterium]	diamond	966	97.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30130898	30130898	PRJNA1118794_P_NODE_52232_length_250_cov_0.870056_g51482_i0	PRJNA1118794	52232	250	0.870056	2.17514	Desulfotignum phosphitoxidans	190898	Bacteria	Bacteria	45.1	7.85e-4	NR	WP_006967463.1	190898	g51482	i0	36.9	1.212	65	41	78	0	241	47	14	78	WP_006967463.1 hypothetical protein [Desulfotignum phosphitoxidans]	diamond	303	45.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfotignum	Desulfotignum phosphitoxidans
30415928	30415928	PRJNA1118794_P_NODE_16173_length_366_cov_0.982935_g15423_i0	PRJNA1118794	16173	366	0.982935	3.5975421	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	50.4	1.73e-4	NR	GJM17643.1	2202153	g15423	i0	39.3	0.459016393442623	56	33	45.1	1	199	363	133	188	GJM17643.1 MAG: hypothetical protein DHS20C13_29700 [Thermodesulfobacteriota bacterium]	diamond	168	50.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30731513	30731513	PRJNA1118794_P_NODE_53374_length_249_cov_0.875000_g52624_i0	PRJNA1118794	53374	249	0.875	2.17875	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	89.4	1.55e-18	NR	HAO22905.1	2049433	g52624	i0	47.6	0.987951807228916	82	43	98.8	0	2	247	276	357	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	246	89.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
30731528	30731528	PRJNA1118794_P_NODE_7754_length_505_cov_1.113426_g7011_i0	PRJNA1118794	7754	505	1.113426	5.6228013	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	155	7.979999999999998e-41	NR	HAO22905.1	2049433	g7011	i0	40.5	0.998019801980198	168	99	99.8	1	2	505	280	446	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	504	155	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
30984488	30984488	PRJNA1118794_P_NODE_11434_length_421_cov_2.034483_g10686_i0	PRJNA1118794	11434	421	2.034483	8.56517343	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	131	1.3399999999999998e-32	NR	HAO22905.1	2049433	g10686	i0	44.8	0.954869358669834	134	73	95.5	1	3	404	121	253	HAO22905.1 hypothetical protein [Desulfobacteraceae bacterium]	diamond	402	131	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
30984527	30984527	PRJNA1118794_P_NODE_66474_length_244_cov_0.900585_g65724_i0	PRJNA1118794	66474	244	0.900585	2.1974274	Desulfuromonadales bacterium C	2099678	Bacteria	Bacteria	57.8	1.95e-7	NR	OEU72918.1	1869308	g65724	i0	37	0.995901639344262	81	51	99.6	0	244	2	862	942	OEU72918.1 MAG: hypothetical protein BA864_15470 [Desulfuromonadales bacterium C00003093]	diamond	243	57.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales			Desulfuromonadales bacterium C00003093
31386432	31386432	PRJNA1118794_P_NODE_44356_length_259_cov_1.655914_g43606_i0	PRJNA1118794	44356	259	1.655914	4.28881726	Bacteria	2	Bacteria	Bacteria	71.6	3.04e-12	NR	MBI5568953.1	2358	g43606	i0	59.6	5.14285714285714	57	23	66	0	1	171	499	555	MBI5568953.1 long-chain fatty acid--CoA ligase [Desulfomonile tiedjei]	diamond	1332	72	0.994444444444444	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
32597429	32597429	PRJNA1118794_P_NODE_56480_length_248_cov_0.880000_g55730_i0	PRJNA1118794	56480	248	0.88	2.1824	Desulfovibrio sp.	885	Bacteria	Bacteria	42.7	0.0378	NR	MBA4356805.1	885	g55730	i0	41.1	0.67741935483871	56	28	64.1	3	188	30	107	160	MBA4356805.1 hypothetical protein [Desulfovibrio sp.]	diamond	168	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	Desulfovibrio sp.

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