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

6 rows where analysis = "diamond", bioproject = "PRJEB20058" 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_genus	tax_species
25655450	25655450	PRJEB20058_P_NODE_35610_length_705_cov_2.349379_g33028_i0	PRJEB20058	35610	705	2.349379	16.56312195	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	295	1.0399999999999999e-95	NR	MFU8802832.1	2740543	g33028	i0	72.2	0.825531914893617	194	54	82.6	0	23	604	63	256	MFU8802832.1 phosphopentomutase [Bradymonadaceae bacterium]	diamond	582	295	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
25794793	25794793	PRJEB20058_P_NODE_98555_length_411_cov_1.097143_g95749_i0	PRJEB20058	98555	411	1.097143	4.50925773	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	120	6.26e-29	NR	MBA2660728.1	2946527	g95749	i0	84.1	0.503649635036496	69	11	50.4	0	188	394	5	73	MBA2660728.1 asparagine--tRNA ligase [Lujinxingiaceae bacterium]	diamond	207	120	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
26428945	26428945	PRJEB20058_P_NODE_156791_length_304_cov_2.773663_g153968_i0	PRJEB20058	156791	304	2.773663	8.43193552	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	95.1	1.36e-20	NR	PKN57304.1	2013741	g153968	i0	60.8	1.56907894736842	79	30	78	1	43	279	2	79	PKN57304.1 MAG: hypothetical protein CVU56_11720 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	477	95.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32944951	32944951	PRJEB20058_P_NODE_154730_length_307_cov_2.048780_g151907_i0	PRJEB20058	154730	307	2.04878	6.2897546	Persicimonas caeni	2292766	Bacteria	Bacteria	65.1	3.51e-10	NR	WP_141197294.1	2292766	g151907	i0	82.8	0.283387622149837	29	5	28.3	0	219	305	168	196	WP_141197294.1 hypothetical protein [Persicimonas caeni]	diamond	87	65.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
33008294	33008294	PRJEB20058_P_NODE_173259_length_283_cov_13.513514_g170436_i0	PRJEB20058	173259	283	13.513514	38.24324462	Bdellovibrionota	3018035	Bacteria	Bacteria	48.9	2.49e-4	NR	PIR23413.1	1973974	g170436	i0	55.3	0.985865724381625	47	19	49.8	1	281	141	160	204	PIR23413.1 MAG: hypothetical protein COV44_02920 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16]	diamond	279	48.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16
33042368	33042368	PRJEB20058_P_NODE_112212_length_380_cov_2.965517_g109399_i0	PRJEB20058	112212	380	2.965517	11.2689646	Myxococcota	2818505	Bacteria	Bacteria	45.4	0.0171	NR	KPJ58989.1	1703397	g109399	i0	37.1	4.05789473684211	62	38	48.9	1	20	205	320	380	KPJ58989.1 MAG: hypothetical protein AMJ42_02355 [Deltaproteobacteria bacterium DG_8]	diamond	1542	45.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium DG_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);;