metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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_species
1036990	1036990	PRJNA1151638_P_NODE_2761_length_302_cov_2.585153_g2694_i0	PRJNA1151638	2761	302	2.585153	7.80716206	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	132	1.7999999999999998e-33	NR	GMU74406.1	2026716	g2694	i0	64.3	24.3774834437086	98	34	96.4	1	1	291	600	697	GMU74406.1 MAG: chaperone protein ClpB [Candidatus Campbellbacteria bacterium]	diamond	7362	132	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota		Candidatus Campbellbacteria bacterium
26838375	26838375	PRJNA1151638_P_NODE_1821_length_350_cov_3.090253_g1754_i0	PRJNA1151638	1821	350	3.090253	10.8158855	Bacteria	2	Bacteria	Bacteria	100	1e-21	NR	OGZ27841.1	1801677	g1754	i0	46.2	7.44857142857143	106	57	90.9	0	29	346	3	108	OGZ27841.1 MAG: DNA polymerase III subunit alpha [Candidatus Nealsonbacteria bacterium RIFOXYB1_FULL_40_15]	diamond	2607	101	0.99009900990099	Bacteria	Bacteria candidate phyla	Candidatus Nealsoniibacteriota		Candidatus Nealsonbacteria bacterium RIFOXYB1_FULL_40_15
27091348	27091348	PRJNA1151638_P_NODE_2822_length_300_cov_1.515419_g2755_i0	PRJNA1151638	2822	300	1.515419	4.546257	Bacillati	1783272	Bacteria	Bacteria	59.7	1.43e-8	NR	MBR3329011.1	2026720	g2755	i0	43.8	1.96	64	34	62	1	20	205	1	64	MBR3329011.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	588	59.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
28366606	28366606	PRJNA1151638_P_NODE_6866_length_238_cov_2.521212_g6799_i0	PRJNA1151638	6866	238	2.521212	6.00048456	Candidatus Komeilibacteria bacterium	2053566	Bacteria	Bacteria	84.7	5.81e-17	NR	MBT4209827.1	2053566	g6799	i0	51.9	5.48319327731092	79	34	99.6	2	238	2	510	584	MBT4209827.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Candidatus Komeilibacteria bacterium]	diamond	1305	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Komeiliibacteriota		Candidatus Komeilibacteria bacterium
29692541	29692541	PRJNA1151638_P_NODE_5150_length_251_cov_0.876404_g5083_i0	PRJNA1151638	5150	251	0.876404	2.19977404	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	116	5.72e-28	NR	HMJ63990.1	2838779	g5083	i0	62.2	1.9601593625498	82	31	98	0	249	4	265	346	HMJ63990.1 PVC-type heme-binding CxxCH protein [Candidatus Binatia bacterium]	diamond	492	116	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia	Candidatus Binatia bacterium
31177468	31177468	PRJNA1151638_P_NODE_6595_length_242_cov_3.076923_g6528_i0	PRJNA1151638	6595	242	3.076923	7.44615366	Candidatus Uhrbacteria bacterium	2053634	Bacteria	Bacteria	55.8	8.89e-7	NR	MBI4239661.1	2053634	g6528	i0	43.6	1.94628099173554	78	44	96.7	0	236	3	438	515	MBI4239661.1 ATP-dependent chaperone ClpB [Candidatus Uhrbacteria bacterium]	diamond	471	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Uhriibacteriota		Candidatus Uhrbacteria 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);;