metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
389456	389456	PRJNA326068_P_NODE_4701_length_509_cov_99.620833_g3905_i0	PRJNA326068	4701	509	99.620833	507.07003997	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	544	6.74e-150	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g3905	i0	90.647	279.271119842829	417	28	81	11	1	413	963906	964315	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	142149	544	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
4216717	4216717	PRJNA326068_P_NODE_17544_length_189_cov_2.387500_g16581_i0	PRJNA326068	17544	189	2.3875	4.512375	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	279	6.83e-71	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g16581	i0	98.125	10.9100529100529	160	3	85	0	26	185	430236	430395	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	2062	279	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9317461	9317461	PRJNA326068_P_NODE_2748_length_663_cov_4.605678_g644_i1	PRJNA326068	2748	663	4.605678	30.53564514	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	505	4.22e-138	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g644	i1	86.164	286.666666666667	477	55	71	11	1	471	126788	126317	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	190060	505	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
10593133	10593133	PRJNA326068_P_NODE_19829_length_153_cov_2.822581_g18866_i0	PRJNA326068	19829	153	2.822581	4.31854893	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	222	9.029999999999999e-54	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g18866	i0	92.81	75.281045751634	153	11	100	0	1	153	429380	429228	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	11518	222	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
11868041	11868041	PRJNA326068_P_NODE_19830_length_153_cov_2.669355_g18867_i0	PRJNA326068	19830	153	2.669355	4.08411315	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	250	4.14e-62	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g18867	i0	100	39.4444444444444	135	0	88	0	1	135	494496	494362	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	6035	250	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
14418305	14418305	PRJNA326068_P_NODE_9432_length_331_cov_19.420530_g8476_i0	PRJNA326068	9432	331	19.42053	64.2819543	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	496	1.2e-135	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g8476	i0	94.19	254.861027190332	327	16	98	3	7	331	964231	963906	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	84359	496	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
16966818	16966818	PRJNA326068_P_NODE_8994_length_343_cov_1.824841_g8040_i0	PRJNA326068	8994	343	1.824841	6.25920463	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	499	9.64e-137	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g8040	i0	93.043	85.2448979591837	345	19	100	5	1	343	431199	431540	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	29239	499	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18241040	18241040	PRJNA326068_P_NODE_11775_length_276_cov_2.408907_g10813_i0	PRJNA326068	11775	276	2.408907	6.64858332	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	359	1.34e-94	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g10813	i0	92.43	8.40579710144928	251	19	91	0	16	266	430449	430699	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	2320	359	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
19515278	19515278	PRJNA326068_P_NODE_11276_length_286_cov_2.731518_g10314_i0	PRJNA326068	11276	286	2.731518	7.81214148	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	377	3.84e-100	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g10314	i0	90.559	252.800699300699	286	25	99	1	3	286	383770	384055	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	72301	377	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24615562	24615562	PRJNA326068_P_NODE_920_length_1059_cov_3.197087_g644_i0	PRJNA326068	920	1059	3.197087	33.85715133	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	839	0	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g644	i0	81.627	234.247403210576	1045	153	98	25	1	1034	126788	125772	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	248068	839	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);;