metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA782235" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA782235" 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
763328	763328	PRJNA782235_P_NODE_21641_length_247_cov_0.885057_g21452_i0	PRJNA782235	21641	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	149	1.37e-39	NR	MBC7546307.1	2026720	g21452	i0	95.1	14.9392712550607	82	4	99.6	0	1	246	530	611	MBC7546307.1 DNA translocase FtsK 4TM domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	3690	149	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
16065890	16065890	PRJNA782235_P_NODE_28073_length_241_cov_0.916667_g27884_i0	PRJNA782235	28073	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	144	1.13e-38	NR	OJU88065.1	1895829	g27884	i0	88.6	2.95020746887967	79	9	98.3	0	241	5	171	249	OJU88065.1 MAG: hypothetical protein BGO17_03765 [Candidatus Saccharibacteria bacterium 49-20]	diamond	711	145	0.993103448275862	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
28569433	28569433	PRJNA782235_P_NODE_22707_length_246_cov_0.890173_g22518_i0	PRJNA782235	22707	246	0.890173	2.18982558	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	110	2.8e-26	NR	PID31564.1	2026720	g22518	i0	58.5	2.95121951219512	82	34	100	0	246	1	79	160	PID31564.1 MAG: hypothetical protein CR983_00585 [Candidatus Saccharibacteria bacterium]	diamond	726	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28853464	28853464	PRJNA782235_P_NODE_10088_length_289_cov_1.236111_g9899_i0	PRJNA782235	10088	289	1.236111	3.57236079	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	55.8	1.5e-6	NR	MEO5949122.1	1917697	g9899	i0	44.2	1.55709342560554	77	39	76.8	3	287	66	365	440	MEO5949122.1 DUF11 domain-containing protein [Candidatus Saccharimonas sp.]	diamond	450	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
32076751	32076751	PRJNA782235_P_NODE_12578_length_273_cov_1.290000_g12389_i0	PRJNA782235	12578	273	1.29	3.5217	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	76.6	6.53e-14	NR	MFC1713662.1	2026781	g12389	i0	48.9	1.95604395604396	90	44	98.9	1	3	272	866	953	MFC1713662.1 C10 family peptidase [Candidatus Poribacteria bacterium]	diamond	534	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
32488229	32488229	PRJNA782235_P_NODE_19639_length_248_cov_0.880000_g19450_i0	PRJNA782235	19639	248	0.88	2.1824	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	46.2	0.00215	NR	HMI09658.1	2973664	g19450	i0	50.9	0.641129032258065	53	22	64.1	2	161	3	3	51	HMI09658.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	159	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32834737	32834737	PRJNA782235_P_NODE_20880_length_247_cov_0.885057_g20691_i0	PRJNA782235	20880	247	0.885057	2.18609079	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	50.8	4.24e-6	NR	HTK39651.1	2052139	g20691	i0	56.1	0.497975708502024	41	18	49.8	0	29	151	38	78	HTK39651.1 hypothetical protein [Patescibacteria group bacterium]	diamond	123	50.8	1	Bacteria	Bacteria candidate phyla						Patescibacteria group 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);;