metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB80557" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB80557" 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
26876328	26876328	PRJEB80557_S_NODE_30661_length_175_cov_1.238095_g30265_i0	PRJEB80557	30661	175	1.238095	2.16666625	Candidatus Anderseniibacteriota bacterium	2053502	Bacteria	Bacteria	42.4	0.021	NR	HLC49670.1	2053502	g30265	i0	32	0.857142857142857	50	34	85.7	0	151	2	673	722	HLC49670.1 type I DNA topoisomerase [Candidatus Andersenbacteria bacterium]	diamond	150	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Anderseniibacteriota					Candidatus Anderseniibacteriota bacterium
26932060	26932060	PRJEB80557_S_NODE_12082_length_266_cov_0.926267_g11686_i0	PRJEB80557	12082	266	0.926267	2.46387022	Bacteria	2	Bacteria	Bacteria	75.9	1.07e-13	NR	HRF28207.1	2026720	g11686	i0	90.7	11.6390977443609	43	4	48.5	0	264	136	335	377	HRF28207.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saccharibacteria bacterium]	diamond	3096	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26939150	26939150	PRJEB80557_S_NODE_22042_length_203_cov_1.675325_g21646_i0	PRJEB80557	22042	203	1.675325	3.40090975	Candidatus Caldipriscus sp.	2831945	Bacteria	Bacteria	43.1	0.00426	NR	MCC6012566.1	2831945	g21646	i0	42.2	1.33004926108374	45	25	65	1	4	135	60	104	MCC6012566.1 co-chaperone GroES [Candidatus Caldipriscus sp.]	diamond	270	43.1	1	Bacteria	Bacteria candidate phyla	Candidatus Caldipriscota				Candidatus Caldipriscus	Candidatus Caldipriscus sp.
27097401	27097401	PRJEB80557_S_NODE_22702_length_200_cov_2.264901_g22306_i0	PRJEB80557	22702	200	2.264901	4.529802	Candidatus Elulimicrobium humile	2802965	Bacteria	Bacteria	56.2	1.04e-7	NR	NBP55845.1	2802965	g22306	i0	58.1	1.2	43	18	64.5	0	25	153	5	47	NBP55845.1 hypothetical protein [Candidatus Elulimicrobium humile]	diamond	240	56.2	1	Bacteria	Bacteria candidate phyla	Candidatus Elulimicrobiota	Candidatus Elulimicrobia	Candidatus Elulimicrobiales	Candidatus Elulimicrobiaceae	Candidatus Elulimicrobium	Candidatus Elulimicrobium humile
27216371	27216371	PRJEB80557_S_NODE_29202_length_179_cov_1.353846_g28806_i0	PRJEB80557	29202	179	1.353846	2.42338434	Bacteria	2	Bacteria	Bacteria	85.1	1.53e-17	NR	HRH93288.1	2053688	g28806	i0	69	4.86033519553073	58	18	97.2	0	6	179	298	355	HRH93288.1 M23 family metallopeptidase [Candidatus Peribacteria bacterium]	diamond	870	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
27318853	27318853	PRJEB80557_S_NODE_10503_length_283_cov_1.435897_g10107_i0	PRJEB80557	10503	283	1.435897	4.06358851	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	151	6.16e-42	NR	MDD3035446.1	2830836	g10107	i0	81.9	1.99293286219081	94	17	99.6	0	283	2	238	331	MDD3035446.1 cysteine desulfurase NifS [Candidatus Saccharimonadaceae bacterium]	diamond	564	151	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
28865881	28865881	PRJEB80557_S_NODE_36608_length_163_cov_0.912281_g36212_i0	PRJEB80557	36608	163	0.912281	1.48701803	Candidatus Bipolaricaulota bacterium	2306012	Bacteria	Bacteria	60.1	8.86e-9	NR	MFC2081719.1	2306012	g36212	i0	50.9	8.74233128834356	53	26	97.5	0	160	2	73	125	MFC2081719.1 LacI family DNA-binding transcriptional regulator [Candidatus Bipolaricaulota bacterium]	diamond	1425	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					Candidatus Bipolaricaulota bacterium
29521657	29521657	PRJEB80557_S_NODE_11910_length_267_cov_2.206422_g11514_i0	PRJEB80557	11910	267	2.206422	5.89114674	Bacteria	2	Bacteria	Bacteria	69.3	2.14e-11	NR	HLB50564.1	2052139	g11514	i0	47.8	6.7752808988764	67	35	75.3	0	253	53	218	284	HLB50564.1 ATP-binding protein [Patescibacteria group bacterium]	diamond	1809	69.3	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
29584539	29584539	PRJEB80557_S_NODE_31350_length_173_cov_1.653226_g30954_i0	PRJEB80557	31350	173	1.653226	2.86008098	Pseudomonadati	3379134	Bacteria	Bacteria	65.1	1.61e-10	NR	MBI1798522.1	2212470	g30954	i0	68.2	11.8092485549133	44	14	76.3	0	137	6	123	166	MBI1798522.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Eiseniibacteriota bacterium]	diamond	2043	65.5	0.993893129770992	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
30097328	30097328	PRJEB80557_S_NODE_19452_length_215_cov_1.566265_g19056_i0	PRJEB80557	19452	215	1.566265	3.36746975	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	52.4	9.52e-6	NR	TAH35462.1	2026720	g19056	i0	54.3	0.641860465116279	46	21	64.2	0	5	142	262	307	TAH35462.1 MAG: methionyl-tRNA formyltransferase [Candidatus Saccharibacteria bacterium]	diamond	138	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30223747	30223747	PRJEB80557_S_NODE_12932_length_258_cov_1.712919_g12536_i0	PRJEB80557	12932	258	1.712919	4.4193310200000004	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	62.4	2.11e-10	NR	HEY5588847.1	2053589	g12536	i0	38.7	0.872093023255814	75	46	87.2	0	244	20	9	83	HEY5588847.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	225	62.4	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota bacterium
31139713	31139713	PRJEB80557_S_NODE_5515_length_370_cov_1.856698_g5119_i0	PRJEB80557	5515	370	1.856698	6.8697826	Candidatus Saccharibacteria bacterium 32-5	1970481	Bacteria	Bacteria	199	1.2999999999999999e-58	NR	OYX53357.1	1970481	g5119	i0	83.3	0.972972972972973	120	20	97.3	0	368	9	413	532	OYX53357.1 MAG: hypothetical protein B7Y92_03170 [Candidatus Saccharibacteria bacterium 32-50-13]	diamond	360	199	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-13
31891839	31891839	PRJEB80557_S_NODE_35497_length_165_cov_0.870690_g35101_i0	PRJEB80557	35497	165	0.87069	1.4366385	Bacteria	2	Bacteria	Bacteria	80.1	8.11e-16	NR	HWR40932.1	2052139	g35101	i0	74.1	3.92727272727273	54	14	98.2	0	163	2	212	265	HWR40932.1 HAMP domain-containing sensor histidine kinase [Patescibacteria group bacterium]	diamond	648	80.1	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
32405492	32405492	PRJEB80557_S_NODE_11859_length_268_cov_1.278539_g11463_i0	PRJEB80557	11859	268	1.278539	3.42648452	Candidatus Chazhemtobacterium aquaticus	2715735	Bacteria	Bacteria	58.2	1.96e-7	NR	WP_161931994.1	2715735	g11463	i0	38.8	0.895522388059702	80	43	82.8	2	17	238	765	844	WP_161931994.1 DNA polymerase III subunit alpha [Candidatus Chazhemtobacterium aquaticus]	diamond	240	58.2	1	Bacteria	Bacteria candidate phyla				Candidatus Chazhemtobacteraceae	Candidatus Chazhemtobacterium	Candidatus Chazhemtobacterium aquaticus
32878460	32878460	PRJEB80557_S_NODE_6900_length_337_cov_2.013889_g6504_i0	PRJEB80557	6900	337	2.013889	6.78680593	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	121	2.4799999999999996e-29	NR	MBP9771420.1	2053589	g6504	i0	59.6	0.881305637982196	99	40	88.1	0	319	23	409	507	MBP9771420.1 hypothetical protein [Candidatus Paceibacterota bacterium]	diamond	297	121	1	Bacteria	Bacteria candidate phyla	Minisyncoccota					Minisyncoccota 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);;