metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJDB4941" and tax

6 rows where analysis = "diamond", bioproject = "PRJDB4941" and tax_clade = "delta/epsilon subdivisions"

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_species
2560400	2560400	PRJDB4941_P_NODE_39843_length_163_cov_0.912281_g39075_i0	PRJDB4941	39843	163	0.912281	1.48701803	Bacteria	2	Bacteria	Bacteria	99	1.09e-22	NR	PKN54516.1	2013741	g39075	i0	79.6	32.760736196319	54	11	99.4	0	1	162	227	280	PKN54516.1 MAG: glutamate-1-semialdehyde-2,1-aminomutase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	5340	99.8	0.991983967935872	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
27279522	27279522	PRJDB4941_P_NODE_23703_length_207_cov_1.784810_g22935_i0	PRJDB4941	23703	207	1.78481	3.6945567	Acidobacteriota	57723	Bacteria	Bacteria	81.6	3.05e-16	NR	PKN54132.1	2013741	g22935	i0	57.6	1.94202898550725	66	28	95.7	0	3	200	79	144	PKN54132.1 MAG: S-adenosylmethionine tRNA ribosyltransferase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	402	81.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
27437643	27437643	PRJDB4941_P_NODE_2743_length_971_cov_4.543384_g2098_i0	PRJDB4941	2743	971	4.543384	44.11625864	Acidobacteriota	57723	Bacteria	Bacteria	76.3	1.8e-11	NR	OGP13602.1	1797808	g2098	i0	29.7	1.98352214212152	158	105	48.5	3	486	956	6	158	OGP13602.1 MAG: hypothetical protein A2052_09100 [Deltaproteobacteria bacterium GWA2_54_12]	diamond	1926	77	0.990909090909091	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium GWA2_54_12
28289735	28289735	PRJDB4941_P_NODE_29366_length_184_cov_1.540741_g28598_i0	PRJDB4941	29366	184	1.540741	2.83496344	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	4.53e-16	NR	CAB1084234.1	334747	g28598	i0	61.7	7.84239130434783	60	23	97.8	0	181	2	500	559	CAB1084234.1 Undecaprenyl-phosphate alpha-N-acetylglucosaminyl 1-phosphate transferase (EC [Olavius algarvensis Delta 1 endosymbiont]	diamond	1443	81.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Olavius algarvensis Delta 1 endosymbiont
28573990	28573990	PRJDB4941_P_NODE_23827_length_206_cov_2.738854_g23059_i0	PRJDB4941	23827	206	2.738854	5.64203924	Bacteria	2	Bacteria	Bacteria	50.8	3.18e-5	NR	MFU8803527.1	2740543	g23059	i0	42.6	2.46116504854369	68	36	94.7	1	1	195	460	527	MFU8803527.1 SWIM zinc finger family protein [Bradymonadaceae bacterium]	diamond	507	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonadaceae bacterium
32119027	32119027	PRJDB4941_P_NODE_21018_length_222_cov_2.034682_g20250_i0	PRJDB4941	21018	222	2.034682	4.51699404	Olavius sp. associated proteobacterium Delta 1	698986	Bacteria	Bacteria	97.8	5.44e-22	NR	CAB1063192.1	698986	g20250	i0	60.3	2.97297297297297	73	29	98.6	0	219	1	312	384	CAB1063192.1 hypothetical protein D1BOALGB6SA_7975 [Olavius sp. associated proteobacterium Delta 1]	diamond	660	97.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Olavius sp. associated proteobacterium Delta 1

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