metadata: contig_metadata: 10 rows where bioproject = "PRJNA1031674", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA1031674", 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
5269695	5269695	PRJNA1031674_P_NODE_2965_length_456_cov_2.412533_g2755_i0	PRJNA1031674	2965	456	2.412533	11.00115048	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	396	1.77e-105	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g2755	i0	82.379	7.60964912280702	454	80	99	0	1	454	753539	753992	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	3470	396	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
6544665	6544665	PRJNA1031674_P_NODE_13366_length_282_cov_1.995215_g13155_i0	PRJNA1031674	13366	282	1.995215	5.6265063	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	250	8.589999999999999e-62	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g13155	i0	84.314	0.904255319148936	255	40	90	0	2	256	950432	950686	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	255	250	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
14195485	14195485	PRJNA1031674_P_NODE_7332_length_326_cov_0.913043_g7121_i0	PRJNA1031674	7332	326	0.913043	2.97652018	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	287	7.72e-73	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g7121	i0	83.178	6.58895705521472	321	46	98	6	5	322	568410	568725	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	2148	287	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
16743670	16743670	PRJNA1031674_P_NODE_23134_length_249_cov_1.301136_g22923_i0	PRJNA1031674	23134	249	1.301136	3.23982864	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	224	4.5099999999999996e-54	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g22923	i0	82.996	0.991967871485944	247	42	99	0	3	249	585892	586138	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	247	224	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18018409	18018409	PRJNA1031674_P_NODE_12275_length_286_cov_1.244131_g12064_i0	PRJNA1031674	12275	286	1.244131	3.55821466	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	230	1.1399999999999998e-55	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g12064	i0	81.588	7.25874125874126	277	51	97	0	10	286	751386	751110	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	2076	230	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
21843739	21843739	PRJNA1031674_P_NODE_4818_length_381_cov_1.337662_g4608_i0	PRJNA1031674	4818	381	1.337662	5.09649222	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	113	1.64e-20	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g4608	i0	95.775	13.3779527559055	71	1	18	2	1	69	1076555	1076625	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	5097	113	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24392918	24392918	PRJNA1031674_P_NODE_5400_length_365_cov_2.630137_g5190_i0	PRJNA1031674	5400	365	2.630137	9.60000005	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	307	6.7e-79	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g5190	i0	82.703	43.5068493150685	370	40	100	17	1	365	964718	965068	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	15880	307	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28519595	28519595	PRJNA1031674_P_NODE_9887_length_298_cov_1.368889_g9676_i0	PRJNA1031674	9887	298	1.368889	4.07928922	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	87	1.86e-17	NR	USN96678.1	2052152	g9676	i0	93.8	0.966442953020134	48	3	48.3	0	146	3	1	48	USN96678.1 MAG: MFS transporter [Candidatus Nomurabacteria bacterium]	diamond	288	87	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28961742	28961742	PRJNA1031674_P_NODE_4208_length_400_cov_1.837920_g3998_i0	PRJNA1031674	4208	400	1.83792	7.35168	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	85.1	3.26e-16	NR	USN96574.1	2052152	g3998	i0	36.8	1.9125	125	78	93.8	1	389	15	779	902	USN96574.1 MAG: M23 family metallopeptidase [Candidatus Nomurabacteria bacterium]	diamond	765	85.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
32533076	32533076	PRJNA1031674_P_NODE_3999_length_407_cov_1.571856_g3789_i0	PRJNA1031674	3999	407	1.571856	6.39745392	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	171	1.8e-49	NR	USN97016.1	2052152	g3789	i0	87.4	2.74938574938575	95	12	70	0	3	287	234	328	USN97016.1 MAG: carbohydrate kinase family protein [Candidatus Nomurabacteria bacterium]	diamond	1119	171	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);;