metadata: contig_metadata: 9 rows where bioproject = "PRJNA493244", tax_clade = "Bacteria candidate phyla" and tax

9 rows where bioproject = "PRJNA493244", 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
5559437	5559437	PRJNA493244_P_NODE_1523105_length_237_cov_6.460227_g1499980_i0	PRJNA493244	1523105	237	6.460227	15.31073799	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	355	1.45e-93	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1499980	i0	96.296	48.2278481012658	216	8	91	0	22	237	964849	964634	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	11430	355	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23408193	23408193	PRJNA493244_P_NODE_1549219_length_231_cov_20.635294_g1526094_i0	PRJNA493244	1549219	231	20.635294	47.66752914	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	324	3.96e-84	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1526094	i0	94.712	72.987012987013	208	11	90	0	1	208	964641	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	16860	324	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27202696	27202696	PRJNA493244_P_NODE_1726502_length_201_cov_0.914286_g1703377_i0	PRJNA493244	1726502	201	0.914286	1.83771486	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	123	4.8099999999999996e-32	NR	MDR3298209.1	2052152	g1703377	i0	81.8	0.985074626865672	66	12	98.5	0	1	198	48	113	MDR3298209.1 phospho-N-acetylmuramoyl-pentapeptide-transferase [Candidatus Nomurabacteria bacterium]	diamond	198	123	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
29034609	29034609	PRJNA493244_P_NODE_1274728_length_304_cov_5.629630_g1251604_i0	PRJNA493244	1274728	304	5.62963	17.1140752	Candidatus Nomurabacteria bacterium RIFCSPLOWO2_	2052152	Bacteria	Bacteria	43.9	0.032	NR	OGI87241.1	1801765	g1251604	i0	42.6	0.463815789473684	47	25	44.4	1	279	145	4252	4298	OGI87241.1 MAG: hypothetical protein A2995_00995 [Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_33_24]	diamond	141	43.9	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPLOWO2_01_FULL_33_24
29286874	29286874	PRJNA493244_P_NODE_990949_length_411_cov_1.828571_g967870_i0	PRJNA493244	990949	411	1.828571	7.51542681	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	183	9.05e-56	NR	MDR3298167.1	2052152	g967870	i0	68.6	2	137	43	100	0	1	411	49	185	MDR3298167.1 response regulator transcription factor [Candidatus Nomurabacteria bacterium]	diamond	822	183	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
30250622	30250622	PRJNA493244_P_NODE_1065472_length_379_cov_2.408805_g1042355_i0	PRJNA493244	1065472	379	2.408805	9.12937095	Bacteria	2	Bacteria	Bacteria	188	2.2699999999999994e-54	NR	MDR3297960.1	2052152	g1042355	i0	75.2	6.70448548812665	121	30	95.8	0	3	365	46	166	MDR3297960.1 GspE/PulE family protein [Candidatus Nomurabacteria bacterium]	diamond	2541	188	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
31024417	31024417	PRJNA493244_P_NODE_869415_length_469_cov_3.379902_g846514_i0	PRJNA493244	869415	469	3.379902	15.85174038	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_	2052152	Bacteria	Bacteria	254	3.03e-76	NR	OGI60317.1	1801731	g846514	i0	84.5	1.81663113006397	142	22	90.8	0	43	468	609	750	OGI60317.1 MAG: ribonucleoside-diphosphate reductase subunit alpha [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_25]	diamond	852	254	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_37_25
32794337	32794337	PRJNA493244_P_NODE_1198420_length_329_cov_3.369403_g1175296_i0	PRJNA493244	1198420	329	3.369403	11.08533587	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	160	4.42e-48	NR	USN96019.1	2052152	g1175296	i0	85.3	0.930091185410334	102	15	93	0	327	22	29	130	USN96019.1 MAG: 50S ribosomal protein L17 [Candidatus Nomurabacteria bacterium]	diamond	306	160	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32904858	32904858	PRJNA493244_P_NODE_1596600_length_221_cov_1.625000_g1573475_i0	PRJNA493244	1596600	221	1.625	3.59125	Bacteria	2	Bacteria	Bacteria	103	4.66e-24	NR	MCC6198662.1	2052152	g1573475	i0	72.6	2.97285067873303	73	20	99.1	0	221	3	15	87	MCC6198662.1 ribonucleotide-diphosphate reductase subunit beta [Candidatus Nomurabacteria bacterium]	diamond	657	103	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);;