metadata: contig_metadata: 8 rows where bioproject = "PRJNA944406", tax_clade = "Bacteria candidate phyla" and tax

8 rows where bioproject = "PRJNA944406", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Nomuraibacteriota"

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_species
924891	924891	PRJNA944406_P_NODE_7481_length_459_cov_3.606218_g6525_i0	PRJNA944406	7481	459	3.606218	16.55254062	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	725	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g6525	i0	95.207	97.7167755991285	459	20	99	2	2	459	966560	966103	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	44852	725	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9852122	9852122	PRJNA944406_P_NODE_104988_length_242_cov_0.911243_g104029_i0	PRJNA944406	104988	242	0.911243	2.20520806	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	305	1.52e-78	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g104029	i0	89.873	182.078512396694	237	24	98	0	6	242	431997	431761	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	44063	305	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12403424	12403424	PRJNA944406_P_NODE_18490_length_305_cov_2.758621_g17531_i0	PRJNA944406	18490	305	2.758621	8.41379405	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	444	4.01e-120	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g17531	i0	93.137	60.9803278688525	306	16	100	5	1	305	963046	963347	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	18599	444	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17502827	17502827	PRJNA944406_P_NODE_47054_length_266_cov_1.393782_g46095_i0	PRJNA944406	47054	266	1.393782	3.70746012	Bacteria	2	Bacteria	Bacteria	171	7.929999999999999e-48	NR	MDB5254895.1	2052152	g46095	i0	98.9	47.6390977443609	88	1	99.2	0	265	2	237	324	MDB5254895.1 ftsH [Candidatus Nomurabacteria bacterium]	diamond	12672	171	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17503032	17503032	PRJNA944406_P_NODE_65914_length_251_cov_0.865169_g64955_i0	PRJNA944406	65914	251	0.865169	2.17157419	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	268	2.07e-67	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g64955	i0	86.166	111.302788844622	253	30	99	4	2	251	126550	126800	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	27937	268	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
25150395	25150395	PRJNA944406_P_NODE_111040_length_237_cov_2.542683_g110081_i0	PRJNA944406	111040	237	2.542683	6.02615871	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	370	5.17e-98	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g110081	i0	96.035	12.2236286919831	227	9	96	0	11	237	249336	249110	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	2897	370	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28572816	28572816	PRJNA944406_P_NODE_78707_length_248_cov_0.880000_g77748_i0	PRJNA944406	78707	248	0.88	2.1824	Candidatus Nomurabacteria bacterium GW2	2052152	Bacteria	Bacteria	140	3.72e-37	NR	KKP23909.1	1618771	g77748	i0	86.6	0.991935483870968	82	11	99.2	0	247	2	189	270	KKP23909.1 MAG: hypothetical protein UR10_C0003G0006 [Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133]	diamond	246	140	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133
32396553	32396553	PRJNA944406_P_NODE_17579_length_310_cov_2.983122_g16620_i0	PRJNA944406	17579	310	2.983122	9.2476782	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	177	2.07e-50	NR	MCB9823018.1	2052152	g16620	i0	75.2	1.13225806451613	117	15	99.7	1	2	310	145	261	MCB9823018.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	351	177	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;