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

5 rows where bioproject = "PRJNA1144090", 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_order	tax_family	tax_genus	tax_species
5390046	5390046	PRJNA1144090_P_NODE_106165_length_247_cov_0.885057_g105630_i0	PRJNA1144090	106165	247	0.885057	2.18609079	Persicimonas caeni	2292766	Bacteria	Bacteria	96.3	4.38e-21	NR	WP_141197292.1	2292766	g105630	i0	58.5	5.97570850202429	82	31	99.6	1	2	247	96	174	WP_141197292.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Persicimonas caeni]	diamond	1476	96.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
30228438	30228438	PRJNA1144090_P_NODE_89692_length_265_cov_1.604167_g89157_i0	PRJNA1144090	89692	265	1.604167	4.25104255	uncultured delta proteobacterium	34034	Bacteria	Bacteria	88.2	1.22e-18	NR	SBW05873.1	34034	g89157	i0	50.6	2.95471698113208	87	41	98.5	2	5	265	151	235	SBW05873.1 2,3-dimethylmalate lyase [uncultured delta proteobacterium]	diamond	783	88.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
31450059	31450059	PRJNA1144090_P_NODE_70196_length_302_cov_1.344978_g69661_i0	PRJNA1144090	70196	302	1.344978	4.06183356	Bradymonadaceae	1779135	Bacteria	Bacteria	103	1.47e-23	NR	WP_111332768.1	1548548	g69661	i0	55.7	1.90728476821192	97	39	92.4	1	281	3	167	263	WP_111332768.1 FAD-dependent oxidoreductase [Bradymonas sediminis]	diamond	576	103	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
32473489	32473489	PRJNA1144090_P_NODE_22279_length_572_cov_2.078156_g21753_i0	PRJNA1144090	22279	572	2.078156	11.88705232	Persicimonas caeni	2292766	Bacteria	Bacteria	132	6.539999999999999e-32	NR	WP_141199594.1	2292766	g21753	i0	40.4	3.61363636363636	183	89	96	3	557	9	221	383	WP_141199594.1 arginine--tRNA ligase [Persicimonas caeni]	diamond	2067	132	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
32651415	32651415	PRJNA1144090_P_NODE_53540_length_348_cov_1.610909_g53005_i0	PRJNA1144090	53540	348	1.610909	5.60596332	Pseudomonadati	3379134	Bacteria	Bacteria	134	5.02e-35	NR	PKN54618.1	2013741	g53005	i0	56.1	13.8189655172414	114	48	96.6	1	3	338	219	332	PKN54618.1 MAG: peptide-methionine (S)-S-oxide reductase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	4809	135	0.992592592592593	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

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