metadata: contig_metadata: 9 rows where bioproject = "PRJNA928559" and tax

9 rows where bioproject = "PRJNA928559" 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
2178105	2178105	PRJNA928559_P_NODE_163022_length_274_cov_3.781095_g161453_i0	PRJNA928559	163022	274	3.781095	10.3602003	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	396	1.0099999999999997e-105	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g161453	i0	92.754	402.569343065693	276	16	100	4	1	274	178160	177887	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	110304	396	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
7280834	7280834	PRJNA928559_P_NODE_161706_length_276_cov_1.226601_g160137_i0	PRJNA928559	161706	276	1.226601	3.38541876	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	220	6.57e-53	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g160137	i0	81.227	169.253623188406	277	48	100	4	1	276	964575	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	46714	220	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8556063	8556063	PRJNA928559_P_NODE_192307_length_251_cov_1.269663_g190738_i0	PRJNA928559	192307	251	1.269663	3.18685413	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	255	1.62e-63	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g190738	i0	87.783	30.4541832669323	221	23	87	4	1	219	384332	384114	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	7644	255	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8905989	8905989	PRJNA928559_P_NODE_67327_length_427_cov_4.395480_g65758_i0	PRJNA928559	67327	427	4.39548	18.7686996	Bacteria	2	Bacteria	Bacteria	525	2.0199999999999998e-144	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g65758	i0	88.837	94.536299765808	430	45	100	3	1	427	176084	176513	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	40367	525	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9830710	9830710	PRJNA928559_P_NODE_171448_length_267_cov_0.979381_g169879_i0	PRJNA928559	171448	267	0.979381	2.61494727	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	122	1.8399999999999998e-23	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g169879	i0	88.571	2.94007490636704	105	7	39	4	1	103	136573	136674	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	785	122	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12381941	12381941	PRJNA928559_P_NODE_163030_length_274_cov_3.611940_g161461_i0	PRJNA928559	163030	274	3.61194	9.8967156	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	473	4.53e-129	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g161461	i0	97.81	56.9671532846715	274	6	100	0	1	274	964575	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	15609	473	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18754731	18754731	PRJNA928559_P_NODE_189475_length_252_cov_1.743017_g187906_i0	PRJNA928559	189475	252	1.743017	4.39240284	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	344	3.37e-90	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g187906	i0	91.27	236.873015873016	252	22	100	0	1	252	383829	383578	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	59692	344	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23854605	23854605	PRJNA928559_P_NODE_130639_length_310_cov_6.835443_g129070_i0	PRJNA928559	130639	310	6.835443	21.1898733	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	267	9.5e-67	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g129070	i0	83.502	83.2096774193548	297	37	94	10	19	310	246904	247193	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	25795	267	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
27720239	27720239	PRJNA928559_P_NODE_123284_length_320_cov_2.680162_g121715_i0	PRJNA928559	123284	320	2.680162	8.5765184	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	68.6	4.97e-12	NR	HCC06445.1	2052152	g121715	i0	43.4	0.99375	106	54	93.8	4	317	18	33	138	HCC06445.1 hypothetical protein [Candidatus Nomurabacteria bacterium]	diamond	318	68.6	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);;