metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1174234" 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
26945479	26945479	PRJNA1174234_P_NODE_18082_length_324_cov_1.227092_g17886_i0	PRJNA1174234	18082	324	1.227092	3.97577808	Candidatus Babelota bacterium	2030827	Bacteria	Bacteria	74.3	7.83e-13	NR	MBM3886438.1	2030827	g17886	i0	33.3	0.972222222222222	105	68	97.2	2	321	7	229	331	MBM3886438.1 hypothetical protein [Candidatus Dependentiae bacterium]	diamond	315	74.3	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota bacterium
27261937	27261937	PRJNA1174234_P_NODE_30643_length_249_cov_0.875000_g30447_i0	PRJNA1174234	30643	249	0.875	2.17875	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.5	0.02	NR	MDD5769376.1	2044595	g30447	i0	45	0.72289156626506	60	29	67.5	3	218	51	182	241	MDD5769376.1 methionyl-tRNA formyltransferase [Candidatus Altimarinota bacterium]	diamond	180	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
27356805	27356805	PRJNA1174234_P_NODE_31423_length_247_cov_1.327586_g31227_i0	PRJNA1174234	31423	247	1.327586	3.27913742	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	43.5	0.0195	NR	HIQ57716.1	2044595	g31227	i0	52.6	1.38461538461538	38	18	46.2	0	6	119	272	309	HIQ57716.1 ABC-F family ATP-binding cassette domain-containing protein [Candidatus Altimarinota bacterium]	diamond	342	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
27577697	27577697	PRJNA1174234_P_NODE_3644_length_693_cov_1.679032_g3464_i0	PRJNA1174234	3644	693	1.679032	11.63569176	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	278	3.77e-91	NR	NBP56350.1	2802965	g3464	i0	64.4	3.79220779220779	219	78	94.8	0	30	686	30	248	NBP56350.1 GTP cyclohydrolase I [Candidatus Elulimicrobium humile]	diamond	2628	278	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
27609352	27609352	PRJNA1174234_P_NODE_22544_length_290_cov_2.009217_g22348_i0	PRJNA1174234	22544	290	2.009217	5.8267293	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	43.9	0.024	NR	GIW69046.1	2762014	g22348	i0	31	0.9	87	50	79.7	3	237	7	149	235	GIW69046.1 MAG: hypothetical protein KatS3mg100_540 [Candidatus Parcubacteria bacterium]	diamond	261	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria					Candidatus Parcubacteria bacterium
27861717	27861717	PRJNA1174234_P_NODE_27965_length_257_cov_1.255435_g27769_i0	PRJNA1174234	27965	257	1.255435	3.22646795	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	160	1.94e-45	NR	MCL4419852.1	2052139	g27769	i0	89.4	0.992217898832685	85	9	99.2	0	257	3	78	162	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	255	160	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28967073	28967073	PRJNA1174234_P_NODE_19688_length_311_cov_1.268908_g19492_i0	PRJNA1174234	19688	311	1.268908	3.94630388	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	43.9	0.00847	NR	PYN73436.1	2053607	g19492	i0	44.1	1.13826366559486	59	29	53.1	2	88	252	33	91	PYN73436.1 MAG: hypothetical protein DMD97_20120 [Candidatus Rokuibacteriota bacterium]	diamond	354	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota					Candidatus Rokuibacteriota bacterium
29030319	29030319	PRJNA1174234_P_NODE_28828_length_252_cov_1.284916_g28632_i0	PRJNA1174234	28828	252	1.284916	3.23798832	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	43.9	0.0159	NR	MBU0648771.1	2052139	g28632	i0	40.4	0.55952380952381	47	28	56	0	142	2	114	160	MBU0648771.1 GspE/PulE family protein [Patescibacteria group bacterium]	diamond	141	43.9	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29471829	29471829	PRJNA1174234_P_NODE_2690_length_786_cov_2.582048_g2520_i0	PRJNA1174234	2690	786	2.582048	20.29489728	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	307	5.23e-100	NR	MCL4419852.1	2052139	g2520	i0	74	0.83587786259542	219	39	83.6	1	3	659	200	400	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	657	307	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30040575	30040575	PRJNA1174234_P_NODE_23231_length_286_cov_1.084507_g23035_i0	PRJNA1174234	23231	286	1.084507	3.10169002	Candidatus Dojkabacteria bacterium	2099670	Bacteria	Bacteria	44.3	0.0178	NR	MCK9416584.1	2099670	g23035	i0	46.8	0.493006993006993	47	25	49.3	0	284	144	961	1007	MCK9416584.1 ATP-binding protein [Candidatus Dojkabacteria bacterium]	diamond	141	44.3	1	Bacteria	Bacteria candidate phyla						Candidatus Dojkabacteria bacterium
30166805	30166805	PRJNA1174234_P_NODE_6412_length_539_cov_1.869099_g6216_i0	PRJNA1174234	6412	539	1.869099	10.07444361	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	59.3	1.17e-6	NR	MFQ5478664.1	2838779	g6216	i0	32	0.834879406307978	150	62	76.8	9	538	125	389	510	MFQ5478664.1 dockerin type I domain-containing protein [Candidatus Binatia bacterium]	diamond	450	59.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32664194	32664194	PRJNA1174234_P_NODE_2120_length_866_cov_2.266078_g1966_i0	PRJNA1174234	2120	866	2.266078	19.62423548	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	267	1.02e-81	NR	MCL4419431.1	2052139	g1966	i0	61.1	0.73094688221709	211	73	73.1	3	859	227	386	587	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	633	267	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32695778	32695778	PRJNA1174234_P_NODE_32880_length_245_cov_0.895349_g32684_i0	PRJNA1174234	32880	245	0.895349	2.19360505	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	48.5	4.89e-5	NR	MCK4765774.1	2052149	g32684	i0	54	1.29795918367347	50	19	61.2	1	243	94	46	91	MCK4765774.1 HU family DNA-binding protein [Candidatus Aminicenantes bacterium]	diamond	318	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
32727379	32727379	PRJNA1174234_P_NODE_12060_length_397_cov_1.123457_g11864_i0	PRJNA1174234	12060	397	1.123457	4.46012429	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	49.3	7.59e-4	NR	HRN71286.1	2026804	g11864	i0	34.1	1.54156171284635	88	51	61.2	3	247	5	1	88	HRN71286.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	612	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota					Candidatus Woesebacteria 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);;