metadata: contig_metadata: 7 rows where bioproject = "PRJNA1002570", tax_clade = "delta/epsilon subdivisions" and tax

7 rows where bioproject = "PRJNA1002570", tax_clade = "delta/epsilon subdivisions" 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_clade	tax_class	tax_genus	tax_species
27090285	27090285	PRJNA1002570_P_NODE_12662_length_336_cov_2.049430_g12467_i0	PRJNA1002570	12662	336	2.04943	6.8860848	Pseudomonadota	1224	Bacteria	Bacteria	81.6	2.32e-15	NR	OGR03275.1	1797903	g12467	i0	41.4	4.04464285714286	111	59	99.1	1	2	334	393	497	OGR03275.1 MAG: hypothetical protein A2520_04200 [Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23]	diamond	1359	81.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23
27540082	27540082	PRJNA1002570_P_NODE_8024_length_400_cov_2.327217_g7829_i0	PRJNA1002570	8024	400	2.327217	9.308868	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21	2013749	Bacteria	Bacteria	174	1.98e-51	NR	PKN28408.1	2013749	g7829	i0	68.1	3.63	119	38	89.3	0	359	3	1	119	PKN28408.1 MAG: Ku protein [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21]	diamond	1452	174	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-21
27824281	27824281	PRJNA1002570_P_NODE_19364_length_292_cov_2.182648_g19169_i0	PRJNA1002570	19364	292	2.182648	6.37333216	Candidatus Desulfacyla sp.	3080560	Bacteria	Bacteria	53.9	5.35e-6	NR	MFO7598548.1	3080560	g19169	i0	37	0.75	73	45	74	1	292	77	164	236	MFO7598548.1 6-phosphogluconolactonase [Candidatus Desulfacyla sp.]	diamond	219	53.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Candidatus Desulfacyla	Candidatus Desulfacyla sp.
29781685	29781685	PRJNA1002570_P_NODE_34951_length_253_cov_2.500000_g34756_i0	PRJNA1002570	34951	253	2.5	6.325	Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16	1797904	Bacteria	Bacteria	122	1.11e-30	NR	OGQ98092.1	1797904	g34756	i0	74.7	2.95256916996047	83	21	98.4	0	251	3	11	93	OGQ98092.1 MAG: phage resistance protein [Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16]	diamond	747	122	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16
30595542	30595542	PRJNA1002570_P_NODE_2133_length_748_cov_2.091852_g1953_i0	PRJNA1002570	2133	748	2.091852	15.64705296	Pseudomonadota	1224	Bacteria	Bacteria	393	1.4999999999999995e-131	NR	OGR03277.1	1797903	g1953	i0	79.5	8.82352941176471	249	51	99.9	0	748	2	50	298	OGR03277.1 MAG: secretion system protein E [Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23]	diamond	6600	396	0.992424242424242	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium RIFOXYD12_FULL_53_23
30792678	30792678	PRJNA1002570_P_NODE_44394_length_240_cov_2.928144_g44199_i0	PRJNA1002570	44394	240	2.928144	7.0275456	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8	2013758	Bacteria	Bacteria	112	5.75e-27	NR	PKN07928.1	2013758	g44199	i0	68.4	1.975	79	25	98.8	0	3	239	283	361	PKN07928.1 MAG: hypothetical protein CVU73_11045 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8]	diamond	474	112	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8
31385952	31385952	PRJNA1002570_P_NODE_40696_length_245_cov_1.505814_g40501_i0	PRJNA1002570	40696	245	1.505814	3.6892443	Candidatus Deferrimicrobiota	3031715	Bacteria	Bacteria	110	4.09e-26	NR	KRT73334.1	1640514	g40501	i0	66.7	2.97551020408163	81	27	99.2	0	1	243	151	231	KRT73334.1 MAG: SMC domain containing protein [Deltaproteobacteria bacterium CSP1-8]	diamond	729	111	0.990990990990991	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium CSP1-8

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