metadata: contig_metadata: 14 rows where bioproject = "PRJNA1215813", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJNA1215813", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"

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
11810394	11810394	PRJNA1215813_P_NODE_1490_length_606_cov_1.786116_g1413_i0	PRJNA1215813	1490	606	1.786116	10.82386296	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	318	4.17e-105	NR	MCL4419852.1	2052139	g1413	i0	78.1	0.995049504950495	201	44	99.5	0	605	3	195	395	MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium]	diamond	603	318	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
26755978	26755978	PRJNA1215813_P_NODE_11721_length_245_cov_0.906977_g11641_i0	PRJNA1215813	11721	245	0.906977	2.22209365	Candidatus Rifleibacterium amylolyticum	2760816	Bacteria	Bacteria	69.3	1.69e-11	NR	KAF1080548.1	2760816	g11641	i0	43.3	0.820408163265306	67	38	82	0	239	39	1675	1741	KAF1080548.1 MAG: hypothetical protein GQF41_2958 [Candidatus Rifleibacterium amylolyticum]	diamond	201	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Rifleibacteriota				Candidatus Rifleibacterium	Candidatus Rifleibacterium amylolyticum
26914424	26914424	PRJNA1215813_P_NODE_3762_length_393_cov_0.915625_g3682_i0	PRJNA1215813	3762	393	0.915625	3.59840625	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	105	1.7199999999999995e-23	NR	HWX21912.1	2838779	g3682	i0	46.9	0.99236641221374	130	64	96.2	2	390	13	505	633	HWX21912.1 HYR domain-containing protein [Candidatus Binatia bacterium]	diamond	390	105	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
27799416	27799416	PRJNA1215813_P_NODE_3904_length_386_cov_1.047923_g3824_i0	PRJNA1215813	3904	386	1.047923	4.04498278	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	127	1.1e-32	NR	MBX7246701.1	2315423	g3824	i0	54.7	4.07253886010363	106	46	82.4	1	321	4	2	105	MBX7246701.1 NAD(P)-dependent alcohol dehydrogenase [Candidatus Sumerlaeaceae bacterium]	diamond	1572	127	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium
27893861	27893861	PRJNA1215813_P_NODE_8005_length_277_cov_2.122549_g7925_i0	PRJNA1215813	8005	277	2.122549	5.87946073	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	109	1.54e-25	NR	MCX7719145.1	2315423	g7925	i0	61.4	0.89891696750902494	83	29	86.6	1	1	240	234	316	MCX7719145.1 fibronectin type III domain-containing protein [Candidatus Sumerlaeaceae bacterium]	diamond	249	109	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium
28083311	28083311	PRJNA1215813_P_NODE_9285_length_253_cov_0.866667_g9205_i0	PRJNA1215813	9285	253	0.866667	2.19266751	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	87.8	5.77e-18	NR	MFC1714387.1	2026781	g9205	i0	53.5	1.0197628458498	86	38	99.6	1	1	252	288	373	MFC1714387.1 S8 family serine peptidase [Candidatus Poribacteria bacterium]	diamond	258	87.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
28209516	28209516	PRJNA1215813_P_NODE_7026_length_295_cov_1.121622_g6946_i0	PRJNA1215813	7026	295	1.121622	3.3087849	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	158	3.5799999999999993e-43	NR	MCL4419431.1	2052139	g6946	i0	79.6	1.99322033898305	98	19	98.6	1	4	294	489	586	MCL4419431.1 hypothetical protein [Patescibacteria group bacterium]	diamond	588	158	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
28967634	28967634	PRJNA1215813_P_NODE_428_length_1012_cov_2.610224_g378_i0	PRJNA1215813	428	1012	2.610224	26.41546688	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	192	6.97e-52	NR	MBY0276389.1	2838779	g378	i0	40.3	4.99209486166008	320	159	90.1	9	921	10	36	339	MBY0276389.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	5052	192	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
29220215	29220215	PRJNA1215813_P_NODE_709_length_825_cov_3.252660_g645_i0	PRJNA1215813	709	825	3.25266	26.834445	Candidatus Sumerlaeaceae bacterium	2315423	Bacteria	Bacteria	326	3.319999999999999e-107	NR	MBX7246531.1	2315423	g645	i0	55.1	10.9636363636364	274	121	99.6	1	825	4	117	388	MBX7246531.1 elongation factor Tu [Candidatus Sumerlaeaceae bacterium]	diamond	9045	326	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae		Candidatus Sumerlaeaceae bacterium
29914926	29914926	PRJNA1215813_P_NODE_3831_length_389_cov_0.987342_g3751_i0	PRJNA1215813	3831	389	0.987342	3.84076038	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	112	1.18e-26	NR	MFN2376773.1	2838779	g3751	i0	51.6	0.956298200514139	124	52	91	5	8	361	24	145	MFN2376773.1 hypothetical protein [Candidatus Binatia bacterium]	diamond	372	112	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
30957553	30957553	PRJNA1215813_P_NODE_9774_length_252_cov_0.871508_g9694_i0	PRJNA1215813	9774	252	0.871508	2.19620016	Parcubacteria group bacterium	2026774	Bacteria	Bacteria	52.4	1.67e-5	NR	MFH0780169.1	2026774	g9694	i0	39	0.702380952380952	59	35	70.2	1	192	16	39	96	MFH0780169.1 LamG-like jellyroll fold domain-containing protein [Parcubacteria group bacterium]	diamond	177	52.4	1	Bacteria	Bacteria candidate phyla						Parcubacteria group bacterium
31779319	31779319	PRJNA1215813_P_NODE_1577_length_591_cov_2.283784_g1500_i0	PRJNA1215813	1577	591	2.283784	13.49716344	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	148	4.91e-41	NR	MET0151620.1	2838779	g1500	i0	47.1	1.91370558375635	187	93	91.9	3	563	21	8	194	MET0151620.1 glutathione S-transferase [Candidatus Binatia bacterium]	diamond	1131	148	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
32159295	32159295	PRJNA1215813_P_NODE_10158_length_250_cov_0.881356_g10078_i0	PRJNA1215813	10158	250	0.881356	2.20339	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	43.5	0.0196	NR	MCA9324640.1	2026720	g10078	i0	41	0.732	61	35	72	1	186	7	56	116	MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	183	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32903929	32903929	PRJNA1215813_P_NODE_10460_length_249_cov_0.886364_g10380_i0	PRJNA1215813	10460	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	120	6.549999999999998e-30	NR	MBS1986333.1	2030827	g10380	i0	67.9	1.87951807228916	78	25	94	0	3	236	112	189	MBS1986333.1 hypothetical protein [Candidatus Dependentiae bacterium]	diamond	468	120	1	Bacteria	Bacteria candidate phyla						Candidatus Babelota 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);;