metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Lloydiibacteriota"

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_species
26722154	26722154	PRJNA1148190_P_NODE_198981_length_377_cov_1.657895_g187811_i0	PRJNA1148190	198981	377	1.657895	6.25026415	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	166	2.44e-48	NR	OGZ09757.1	1798661	g187811	i0	62.6	1.97347480106101	123	46	97.9	0	3	371	88	210	OGZ09757.1 MAG: hypothetical protein A3D65_05525 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13]	diamond	744	166	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13
27817850	27817850	PRJNA1148190_P_NODE_269164_length_334_cov_0.888889_g257993_i0	PRJNA1148190	269164	334	0.888889	2.96888926	Bacteria	2	Bacteria	Bacteria	115	2.3e-27	NR	OGZ10579.1	1798661	g257993	i0	65.3	1.77844311377246	98	33	87.1	1	6	296	275	372	OGZ10579.1 MAG: hypothetical protein A3D65_05840 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13]	diamond	594	115	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13
27923739	27923739	PRJNA1148190_P_NODE_281405_length_328_cov_1.207843_g270234_i0	PRJNA1148190	281405	328	1.207843	3.96172504	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	93.2	2.55e-20	NR	OGZ06995.1	1798661	g270234	i0	42.2	0.996951219512195	109	63	99.7	0	2	328	11	119	OGZ06995.1 MAG: hypothetical protein A3D65_02275 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13]	diamond	327	93.2	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13
28986160	28986160	PRJNA1148190_P_NODE_34768_length_1141_cov_2.740637_g24696_i0	PRJNA1148190	34768	1141	2.740637	31.27066817	Bacteria	2	Bacteria	Bacteria	320	9.86e-105	NR	OGZ09757.1	1798661	g24696	i0	61.9	4.42769500438212	239	91	62.8	0	1	717	4	242	OGZ09757.1 MAG: hypothetical protein A3D65_05525 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13]	diamond	5052	323	0.990712074303406	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_02_FULL_50_13
29345087	29345087	PRJNA1148190_P_NODE_539869_length_259_cov_1.247312_g528696_i0	PRJNA1148190	539869	259	1.247312	3.23053808	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_	2750077	Bacteria	Bacteria	85.9	3.02e-17	NR	OGZ03682.1	1798657	g528696	i0	50.6	0.961389961389961	83	40	96.1	1	258	10	410	491	OGZ03682.1 MAG: ribonuclease R [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20]	diamond	249	85.9	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20
29376263	29376263	PRJNA1148190_P_NODE_345709_length_302_cov_1.344978_g334536_i0	PRJNA1148190	345709	302	1.344978	4.06183356	Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25	1798670	Bacteria	Bacteria	142	3.3e-40	NR	OGZ18132.1	1798670	g334536	i0	67	1.98675496688742	100	33	99.3	0	3	302	90	189	OGZ18132.1 MAG: hypothetical protein A2494_00450 [Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25]	diamond	600	142	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFOXYC12_FULL_46_25
29933455	29933455	PRJNA1148190_P_NODE_646651_length_248_cov_0.880000_g635478_i0	PRJNA1148190	646651	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	68.9	6.31e-12	NR	OGZ06379.1	1798658	g635478	i0	56.9	2.45564516129032	51	22	61.7	0	247	95	170	220	OGZ06379.1 MAG: uracil-DNA glycosylase [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22]	diamond	609	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_49_22
31418450	31418450	PRJNA1148190_P_NODE_763396_length_242_cov_0.911243_g752223_i0	PRJNA1148190	763396	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	81.6	9.37e-17	NR	OGZ04492.1	1798657	g752223	i0	67.9	2.87603305785124	53	17	65.7	0	160	2	6	58	OGZ04492.1 MAG: hypothetical protein A2648_01485 [Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20]	diamond	696	82.4	0.990291262135922	Bacteria	Bacteria candidate phyla	Candidatus Lloydiibacteriota	Candidatus Lloydbacteria bacterium RIFCSPHIGHO2_01_FULL_41_20

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