metadata: contig_metadata: 7 rows where bioproject = "PRJNA1067443", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1067443", 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
181334	181334	PRJNA1067443_P_NODE_10341_length_283_cov_1.466667_g10323_i0	PRJNA1067443	10341	283	1.466667	4.15066761	Desulfuromonadaceae bacterium GWC2_58_13	1801896	Bacteria	Bacteria	157	4.57e-43	NR	OHB32147.1	1801896	g10323	i0	74.5	0.996466431095406	94	24	99.6	0	283	2	215	308	OHB32147.1 MAG: hypothetical protein A2X84_03535 [Desulfuromonadaceae bacterium GWC2_58_13]	diamond	282	157	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae		Desulfuromonadaceae bacterium GWC2_58_13
12935165	12935165	PRJNA1067443_P_NODE_18051_length_248_cov_1.474286_g18033_i0	PRJNA1067443	18051	248	1.474286	3.65622928	Desulfobulbus propionicus	894	Bacteria	Bacteria	189	1.6399999999999996e-43	NTclustered	gi\|320120648\|gb\|CP002364.1\|	577650	g18033	i0	81.25	77.0604838709677	240	39	96	6	10	246	3333418	3333182	Desulfobulbus propionicus DSM 2032, complete genome	blastn	19111	189	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus propionicus
26687397	26687397	PRJNA1067443_P_NODE_9881_length_286_cov_1.446009_g9863_i0	PRJNA1067443	9881	286	1.446009	4.13558574	Syntrophobacterales bacterium	2282155	Bacteria	Bacteria	67	3.18e-11	NR	MCK9377193.1	2282155	g9863	i0	44.7	0.986013986013986	94	52	98.6	0	2	283	63	156	MCK9377193.1 ribonuclease HI family protein [Syntrophobacterales bacterium]	diamond	282	67	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales			Syntrophobacterales bacterium
29624641	29624641	PRJNA1067443_P_NODE_3090_length_413_cov_1.758824_g3072_i0	PRJNA1067443	3090	413	1.758824	7.26394312	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	134	3.08e-33	NR	MDY6822586.1	2202153	g3072	i0	50	1.99031476997579	136	61	98.1	2	1	405	924	1053	MDY6822586.1 DUF6531 domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	822	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30415196	30415196	PRJNA1067443_P_NODE_9313_length_290_cov_1.101382_g9295_i0	PRJNA1067443	9313	290	1.101382	3.1940078	Desulforhabdus sp.	2502061	Bacteria	Bacteria	195	1.12e-56	NR	MDY0042355.1	2502061	g9295	i0	97.9	0.993103448275862	96	2	99.3	0	290	3	388	483	MDY0042355.1 phosphoadenosine phosphosulfate reductase family protein [Desulforhabdus sp.]	diamond	288	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophobacteria	Syntrophobacterales	Syntrophobacteraceae	Desulforhabdus	Desulforhabdus sp.
31742295	31742295	PRJNA1067443_P_NODE_4417_length_371_cov_0.936242_g4399_i0	PRJNA1067443	4417	371	0.936242	3.47345782	Syntrophales bacterium	2928017	Bacteria	Bacteria	44.7	0.0205	NR	HOD28401.1	2928017	g4399	i0	45.5	0.444743935309973	55	29	44.5	1	355	191	73	126	HOD28401.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Syntrophales bacterium]	diamond	165	44.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales			Syntrophales bacterium
32375305	32375305	PRJNA1067443_P_NODE_19379_length_246_cov_0.890173_g19361_i0	PRJNA1067443	19379	246	0.890173	2.18982558	Desulfobacula sp.	2593537	Bacteria	Bacteria	78.2	1.3e-14	NR	NJM02841.1	2593537	g19361	i0	73.1	2.51219512195122	52	14	63.4	0	244	89	415	466	NJM02841.1 S8 family serine peptidase [Desulfobacula sp.]	diamond	618	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacula	Desulfobacula 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);;