metadata: contig_metadata: 5 rows where bioproject = "PRJNA1136505" and tax

5 rows where bioproject = "PRJNA1136505" 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
27533359	27533359	PRJNA1136505_P_NODE_29623_length_714_cov_1.687988_g22904_i0	PRJNA1136505	29623	714	1.687988	12.05223432	Desulfobacterales	213118	Bacteria	Bacteria	102	2.0499999999999999e-23	NR	AOY56883.1	897	g22904	i0	40.3	2.27731092436975	144	74	60.1	3	714	286	1	133	AOY56883.1 conserved uncharacterized protein [Desulfococcus multivorans]	diamond	1626	102	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfococcaceae	Desulfococcus	Desulfococcus multivorans
28080968	28080968	PRJNA1136505_P_NODE_59925_length_389_cov_1.879747_g53065_i0	PRJNA1136505	59925	389	1.879747	7.31221583	Candidatus Electrothrix scaldis	3082418	Bacteria	Bacteria	95.1	9.14e-20	NR	WPD24418.1	3082418	g53065	i0	36.4	1.01799485861183	132	79	97.9	2	8	388	161	292	WPD24418.1 MAG: S8 family serine peptidase [Candidatus Electrothrix scaldis]	diamond	396	95.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Candidatus Electrothrix	Candidatus Electrothrix scaldis
30892013	30892013	PRJNA1136505_P_NODE_36074_length_584_cov_2.052838_g29254_i0	PRJNA1136505	36074	584	2.052838	11.98857392	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	62.8	2.84e-8	NR	MFA6011965.1	2049433	g29254	i0	34.1	0.929794520547945	88	57	44.7	1	582	322	116	203	MFA6011965.1 peroxiredoxin-like family protein [Desulfobacteraceae bacterium]	diamond	543	62.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
31081533	31081533	PRJNA1136505_P_NODE_59575_length_391_cov_1.286164_g52715_i0	PRJNA1136505	59575	391	1.286164	5.02890124	Candidatus Desulfofervidus auxilii	1621989	Bacteria	Bacteria	59.7	1.37e-8	NR	HDD44396.1	1621989	g52715	i0	36.6	1.47314578005115	93	53	70.6	2	390	115	14	101	HDD44396.1 Hpt domain-containing protein [Candidatus Desulfofervidus auxilii]	diamond	576	59.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Desulfofervidia	Candidatus Desulfofervidales	Candidatus Desulfofervidaceae	Candidatus Desulfofervidus	Candidatus Desulfofervidus auxilii
31144165	31144165	PRJNA1136505_P_NODE_55075_length_413_cov_1.132353_g48215_i0	PRJNA1136505	55075	413	1.132353	4.67661789	Desulfobacteraceae bacterium IS3	1934248	Bacteria	Bacteria	94.7	5.98e-20	NR	OQX11095.1	1934248	g48215	i0	40.6	0.966101694915254	133	67	89.3	4	406	38	51	181	OQX11095.1 MAG: hypothetical protein BWK80_45090, partial [Desulfobacteraceae bacterium IS3]	diamond	399	94.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium IS3

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