metadata: contig_metadata: 14 rows where bioproject = "PRJNA798511", tax_phylum = "Thermodesulfobacteriota" and tax

14 rows where bioproject = "PRJNA798511", tax_phylum = "Thermodesulfobacteriota" and tax_superkingdom = "Bacteria"

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
2066900	2066900	PRJNA798511_P_NODE_8202_length_1786_cov_2.560420_g6187_i0	PRJNA798511	8202	1786	2.56042	45.7291012	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	216	2.72e-64	NR	MFO7802529.1	2821143	g6187	i0	100	0.171332586786114	102	0	17.1	0	1338	1643	1	102	MFO7802529.1 hypothetical protein [Desulfovermiculus sp.]	diamond	306	216	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
26958824	26958824	PRJNA798511_P_NODE_49562_length_359_cov_2.136364_g45296_i0	PRJNA798511	49562	359	2.136364	7.66954676	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	54.7	3.65e-7	NR	MFO7876311.1	2821143	g45296	i0	73.2	0.342618384401114	41	8	34.3	1	79	201	24	61	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	123	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
27559316	27559316	PRJNA798511_P_NODE_98364_length_244_cov_0.900585_g94098_i0	PRJNA798511	98364	244	0.900585	2.1974274	Syntrophorhabdaceae bacterium PtaU1.Bin	2660714	Bacteria	Bacteria	42.4	0.0485	NR	OPY62193.1	1811715	g94098	i0	34.6	0.959016393442623	78	45	93.4	2	12	239	284	357	OPY62193.1 MAG: putative metallophosphoesterase [Syntrophorhabdaceae bacterium PtaU1.Bin034]	diamond	234	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae bacterium PtaU1.Bin034
27663402	27663402	PRJNA798511_P_NODE_17544_length_917_cov_2.077014_g13823_i0	PRJNA798511	17544	917	2.077014	19.04621838	root	1	Root_unresolved	Root_unresolved	112	1.5699999999999994e-23	NR	RUM46947.1	2066021	g13823	i0	42	2.0381679389313	157	85	49.7	3	855	400	41	196	RUM46947.1 MAG: hypothetical protein DSY80_01375, partial [Desulfocapsa sp.]	diamond	1869	113	0.991150442477876	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sp.
28443729	28443729	PRJNA798511_P_NODE_76126_length_275_cov_1.405941_g71860_i0	PRJNA798511	76126	275	1.405941	3.86633775	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	50.4	6.93e-6	NR	MFO7876311.1	2821143	g71860	i0	92.6	0.294545454545455	27	2	29.5	0	167	87	24	50	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	81	50.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
28822133	28822133	PRJNA798511_P_NODE_50048_length_357_cov_1.183099_g45782_i0	PRJNA798511	50048	357	1.183099	4.22366343	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	44.3	0.0328	NR	MCP4682635.1	2044940	g45782	i0	38.9	0.605042016806723	72	30	48.7	3	323	150	130	201	MCP4682635.1 tRNA epoxyqueuosine(34) reductase QueG [Desulfobacterales bacterium]	diamond	216	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
29043609	29043609	PRJNA798511_P_NODE_19408_length_828_cov_2.421192_g15498_i0	PRJNA798511	19408	828	2.421192	20.04746976	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	47	0.00302	NR	MFO7876311.1	2821143	g15498	i0	84.6	0.0942028985507246	26	4	9.4	0	243	166	24	49	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	78	47	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
29138416	29138416	PRJNA798511_P_NODE_24469_length_653_cov_2.796552_g20295_i0	PRJNA798511	24469	653	2.796552	18.26148456	Desulfovermiculus sp.	2821143	Bacteria	Bacteria	53.1	1.06e-5	NR	MFO7876311.1	2821143	g20295	i0	96	0.114854517611026	25	1	11.5	0	181	107	24	48	MFO7876311.1 hypothetical protein [Desulfovermiculus sp.]	diamond	75	53.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfovermiculus	Desulfovermiculus sp.
29485220	29485220	PRJNA798511_P_NODE_58910_length_321_cov_1.552419_g54644_i0	PRJNA798511	58910	321	1.552419	4.98326499	Desulfocapsa sp.	2066021	Bacteria	Bacteria	52.4	3.74e-5	NR	RUM41879.1	2066021	g54644	i0	44	0.700934579439252	75	37	65.4	2	214	5	498	572	RUM41879.1 MAG: hypothetical protein DSY80_08180 [Desulfocapsa sp.]	diamond	225	52.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfocapsaceae	Desulfocapsa	Desulfocapsa sp.
29959147	29959147	PRJNA798511_P_NODE_69091_length_291_cov_3.279817_g64825_i0	PRJNA798511	69091	291	3.279817	9.54426747	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	53.9	2.92e-7	NR	MFO7816224.1	2448050	g64825	i0	63	0.474226804123711	46	15	45.4	1	279	148	2	47	MFO7816224.1 hypothetical protein [Desulfovibrionales bacterium]	diamond	138	53.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
30275412	30275412	PRJNA798511_P_NODE_98732_length_244_cov_0.900585_g94466_i0	PRJNA798511	98732	244	0.900585	2.1974274	Pseudodesulfovibrio sp.	2035812	Bacteria	Bacteria	42.7	0.0361	NR	WP_300139971.1	2035812	g94466	i0	41.4	0.713114754098361	58	31	68.9	2	206	39	225	281	WP_300139971.1 radical SAM/SPASM domain-containing protein [Pseudodesulfovibrio sp.]	diamond	174	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Pseudodesulfovibrio	Pseudodesulfovibrio sp.
31728957	31728957	PRJNA798511_P_NODE_105197_length_215_cov_4.260563_g100931_i0	PRJNA798511	105197	215	4.260563	9.16021045	Desulfovibrionaceae bacterium	2049043	Bacteria	Bacteria	42.4	0.0361	NR	MBQ7608481.1	2049043	g100931	i0	34.4	0.893023255813953	64	42	89.3	0	1	192	167	230	MBQ7608481.1 isoleucine--tRNA ligase [Desulfovibrionaceae bacterium]	diamond	192	42.4	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae		Desulfovibrionaceae bacterium
32108700	32108700	PRJNA798511_P_NODE_35098_length_470_cov_1.511335_g30839_i0	PRJNA798511	35098	470	1.511335	7.1032745	Desulfovibrionales bacterium	2448050	Bacteria	Bacteria	85.5	7.8e-19	NR	MFO7816224.1	2448050	g30839	i0	95.1	0.261702127659574	41	2	26.2	0	195	73	1	41	MFO7816224.1 hypothetical protein [Desulfovibrionales bacterium]	diamond	123	85.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales			Desulfovibrionales bacterium
32330571	32330571	PRJNA798511_P_NODE_92459_length_248_cov_0.880000_g88193_i0	PRJNA798511	92459	248	0.88	2.1824	Syntrophorhabdaceae bacterium	2660714	Bacteria	Bacteria	126	1.5099999999999999e-32	NR	HOJ70945.1	2660714	g88193	i0	68.8	3.89516129032258	80	25	96.8	0	241	2	228	307	HOJ70945.1 4-alpha-glucanotransferase [Syntrophorhabdaceae bacterium]	diamond	966	126	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophorhabdia	Syntrophorhabdales	Syntrophorhabdaceae		Syntrophorhabdaceae 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);;