metadata: contig_metadata: 8 rows where bioproject = "PRJNA1115053" and tax

8 rows where bioproject = "PRJNA1115053" 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_family	tax_species
10433296	10433296	PRJNA1115053_S_NODE_92929_length_267_cov_1.473214_g91112_i0	PRJNA1115053	92929	267	1.473214	3.93348138	Candidatus Colwellbacteria bacterium	2750074	Bacteria	Bacteria	153	2.0299999999999994e-42	NR	MBI2012861.1	2750074	g91112	i0	100	2.84269662921348	77	0	86.5	0	35	265	344	420	MBI2012861.1 replicative DNA helicase [Candidatus Colwellbacteria bacterium]	diamond	759	153	1	Bacteria	Bacteria candidate phyla	Candidatus Colwelliibacteriota			Candidatus Colwellbacteria bacterium
18074286	18074286	PRJNA1115053_S_NODE_112735_length_247_cov_1.647059_g110918_i0	PRJNA1115053	112735	247	1.647059	4.06823573	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g110918	i0	98.23	31.6396761133603	226	4	91	0	4	229	217655	217430	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	7815	396	1	Bacteria	Bacteria candidate phyla				Candidatus Dependentiae bacterium Noda2021
23177715	23177715	PRJNA1115053_S_NODE_226559_length_183_cov_2.442857_g224742_i0	PRJNA1115053	226559	183	2.442857	4.47042831	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	298	1.81e-76	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g224742	i0	99.39	241.79781420765	164	1	90	0	20	183	219029	218866	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	44249	298	1	Bacteria	Bacteria candidate phyla				Candidatus Dependentiae bacterium Noda2021
28047115	28047115	PRJNA1115053_S_NODE_62465_length_310_cov_3.056180_g60648_i0	PRJNA1115053	62465	310	3.05618	9.474158	Candidatus Aerophobetes bacterium	2030807	Bacteria	Bacteria	50.4	1.47e-4	NR	TET12057.1	2030807	g60648	i0	42.9	1.25806451612903	63	36	61	0	309	121	181	243	TET12057.1 MAG: ATPase [Candidatus Aerophobetes bacterium]	diamond	390	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Aerophobota			Candidatus Aerophobota bacterium
28804682	28804682	PRJNA1115053_S_NODE_201308_length_193_cov_2.220000_g199491_i0	PRJNA1115053	201308	193	2.22	4.2846	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	43.1	0.0141	NR	MBP7635256.1	2818468	g199491	i0	37.1	1.92746113989637	62	24	76.2	3	151	5	269	328	MBP7635256.1 hypothetical protein [Candidatus Ozemobacteraceae bacterium]	diamond	372	43.1	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria	Candidatus Ozemobacteraceae	Candidatus Ozemobacteraceae bacterium
29837842	29837842	PRJNA1115053_S_NODE_80391_length_282_cov_2.552301_g78574_i0	PRJNA1115053	80391	282	2.552301	7.19748882	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0287	NR	HWC03882.1	2072417	g78574	i0	37.7	1.12765957446809	53	29	52.1	2	106	252	166	218	HWC03882.1 DUF2182 domain-containing protein [Candidatus Methylomirabilota bacterium]	diamond	318	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota			Candidatus Methylomirabilota bacterium
31743007	31743007	PRJNA1115053_S_NODE_135917_length_229_cov_1.032258_g134100_i0	PRJNA1115053	135917	229	1.032258	2.36387082	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	42	0.0494	NR	MEK7195682.1	2052139	g134100	i0	46.3	0.537117903930131	41	21	53.7	1	146	24	157	196	MEK7195682.1 class I tRNA ligase family protein [Patescibacteria group bacterium]	diamond	123	42	1	Bacteria	Bacteria candidate phyla				Patescibacteria group bacterium
31987169	31987169	PRJNA1115053_S_NODE_349638_length_151_cov_1.333333_g347821_i0	PRJNA1115053	349638	151	1.333333	2.01333283	Bacteria	2	Bacteria	Bacteria	63.9	1.44e-10	NR	KKQ40605.1	1618463	g347821	i0	74.4	1.70860927152318	43	11	85.4	0	1	129	159	201	KKQ40605.1 MAG: hypothetical protein US59_C0051G0004 [Candidatus Levybacteria bacterium GW2011_GWB1_37_8]	diamond	258	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota			Candidatus Levybacteria bacterium GW2011_GWB1_37_8

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