metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
8296574	8296574	PRJNA674050_P_NODE_1187_length_617_cov_1.659926_g991_i0	PRJNA674050	1187	617	1.659926	10.24174342	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	265	1.9699999999999998e-82	NR	MBX6334820.1	2026720	g991	i0	65.9	0.9967585089141	205	68	99.7	2	3	617	279	481	MBX6334820.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	615	265	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18496198	18496198	PRJNA674050_P_NODE_27515_length_249_cov_0.880682_g27312_i0	PRJNA674050	27515	249	0.880682	2.19289818	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	135	1.6399999999999998e-35	NR	MBP9762773.1	2052139	g27312	i0	87.8	3.92771084337349	82	10	98.8	0	2	247	216	297	MBP9762773.1 ABC-F family ATP-binding cassette domain-containing protein [Patescibacteria group bacterium]	diamond	978	135	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
27366519	27366519	PRJNA674050_P_NODE_24923_length_251_cov_0.865169_g24720_i0	PRJNA674050	24923	251	0.865169	2.17157419	Candidatus Staskawiczbacteria bacterium	2053617	Bacteria	Bacteria	146	1.27e-38	NR	MCX6720718.1	2053617	g24720	i0	79.5	0.99203187250996006	83	17	99.2	0	2	250	459	541	MCX6720718.1 WecB/TagA/CpsF family glycosyltransferase [Candidatus Staskawiczbacteria bacterium]	diamond	249	146	1	Bacteria	Bacteria candidate phyla	Candidatus Staskawicziibacteriota					Candidatus Staskawiczbacteria bacterium
27714006	27714006	PRJNA674050_P_NODE_10824_length_295_cov_0.923423_g10621_i0	PRJNA674050	10824	295	0.923423	2.72409785	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	146	2.17e-40	NR	NBP59355.1	2802965	g10621	i0	74.5	0.996610169491525	98	24	99.7	1	294	1	21	117	NBP59355.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	294	146	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
28408248	28408248	PRJNA674050_P_NODE_3046_length_405_cov_1.277108_g2843_i0	PRJNA674050	3046	405	1.277108	5.1722874	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	121	4.1e-29	NR	MFA6992485.1	2044595	g2843	i0	50.4	0.97037037037037	131	62	97	2	403	11	198	325	MFA6992485.1 LAGLIDADG family homing endonuclease [Candidatus Altimarinota bacterium]	diamond	393	121	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
29860603	29860603	PRJNA674050_P_NODE_20331_length_257_cov_2.119565_g20128_i0	PRJNA674050	20331	257	2.119565	5.44728205	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	90.9	5.22e-19	NR	MBX6334148.1	2026720	g20128	i0	70.5	0.712062256809339	61	16	71.2	1	21	203	1126	1184	MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	183	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30093486	30093486	PRJNA674050_P_NODE_7432_length_320_cov_3.331984_g7229_i0	PRJNA674050	7432	320	3.331984	10.6623488	root	1	Root_unresolved	Root_unresolved	117	4.29e-28	NR	MBX6334148.1	2026720	g7229	i0	60.4	1.9875	106	42	99.4	0	2	319	192	297	MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	636	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31377486	31377486	PRJNA674050_P_NODE_2336_length_446_cov_3.029491_g2133_i0	PRJNA674050	2336	446	3.029491	13.51152986	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94	4.75e-19	NR	MBX6334148.1	2026720	g2133	i0	42.1	1.02242152466368	152	84	99.6	1	445	2	28	179	MBX6334148.1 DEAD/DEAH box helicase family protein [Candidatus Saccharibacteria bacterium]	diamond	456	94	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31452700	31452700	PRJNA674050_P_NODE_40076_length_242_cov_0.905325_g39873_i0	PRJNA674050	40076	242	0.905325	2.1908865	Bacteria	2	Bacteria	Bacteria	93.2	2.31e-20	NR	HIG52872.1	2099671	g39873	i0	68.4	1.62396694214876	57	18	70.7	0	240	70	294	350	HIG52872.1 hypothetical protein [Candidatus Handelsmanbacteria bacterium]	diamond	393	93.6	0.995726495726496	Bacteria	Bacteria candidate phyla	Candidatus Handelsmaniibacteriota					Candidatus Handelsmanbacteria bacterium
31820055	31820055	PRJNA674050_P_NODE_4797_length_354_cov_2.686833_g4594_i0	PRJNA674050	4797	354	2.686833	9.51138882	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	80.5	7.57e-15	NR	MFA6992485.1	2044595	g4594	i0	43.1	0.983050847457627	116	62	96.6	4	343	2	2	115	MFA6992485.1 LAGLIDADG family homing endonuclease [Candidatus Altimarinota bacterium]	diamond	348	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
32358331	32358331	PRJNA674050_P_NODE_35939_length_244_cov_0.906433_g35736_i0	PRJNA674050	35939	244	0.906433	2.21169652	Candidatus Sungiibacteriota bacterium	2750080	Bacteria	Bacteria	94.7	6.92e-21	NR	MBI2055902.1	2750080	g35736	i0	59	0.959016393442623	78	32	95.9	0	6	239	33	110	MBI2055902.1 glycosyltransferase [Candidatus Sungiibacteriota bacterium]	diamond	234	94.7	1	Bacteria	Bacteria candidate phyla	Candidatus Sungiibacteriota					Candidatus Sungiibacteriota bacterium

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