metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA340009" 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
392341	392341	PRJNA340009_P_NODE_52481_length_179_cov_8.146154_g52174_i0	PRJNA340009	52481	179	8.146154	14.58161566	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	100	5.34e-17	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g52174	i0	81.022	69.6759776536313	137	17	74	7	1	133	386403	386534	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	12472	100	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
2942761	2942761	PRJNA340009_P_NODE_34363_length_214_cov_6.436364_g34056_i0	PRJNA340009	34363	214	6.436364	13.77381896	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	80.5	8.65e-11	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g34056	i0	92.727	6.10280373831776	55	4	26	0	1	55	469313	469259	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	1306	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8045776	8045776	PRJNA340009_P_NODE_70627_length_163_cov_1.789474_g70320_i0	PRJNA340009	70627	163	1.789474	2.91684262	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	110	7.95e-20	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g70320	i0	80.42	1.71165644171779	143	28	88	0	7	149	839346	839204	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	279	110	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
11870693	11870693	PRJNA340009_P_NODE_30750_length_224_cov_20.988571_g30443_i0	PRJNA340009	30750	224	20.988571	47.01439904	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	63.9	9.19e-6	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g30443	i0	81.481	0.486607142857143	81	11	35	4	5	83	248660	248738	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	109	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
11870946	11870946	PRJNA340009_P_NODE_51350_length_181_cov_3.053030_g51043_i0	PRJNA340009	51350	181	3.05303	5.5259843	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	110	9e-20	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g51043	i0	92.208	1.81767955801105	77	6	43	0	36	112	566	642	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	329	110	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
15694737	15694737	PRJNA340009_P_NODE_32533_length_219_cov_8.852941_g32226_i0	PRJNA340009	32533	219	8.852941	19.38794079	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	141	4.02e-29	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g32226	i0	80.628	1.00456621004566	191	30	85	6	32	218	785713	785900	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	220	141	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
15694871	15694871	PRJNA340009_P_NODE_45253_length_191_cov_1.387324_g44946_i0	PRJNA340009	45253	191	1.387324	2.64978884	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	110	9.61e-20	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g44946	i0	95.652	3.58638743455497	69	2	36	1	60	128	391793	391860	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	685	110	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
15694910	15694910	PRJNA340009_P_NODE_48153_length_186_cov_2.233577_g47846_i0	PRJNA340009	48153	186	2.233577	4.15445322	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g47846	i0	96.875	0.172043010752688	32	0	17	1	5	36	539014	539044	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	32	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
16969782	16969782	PRJNA340009_P_NODE_60394_length_168_cov_13.487395_g60087_i0	PRJNA340009	60394	168	13.487395	22.6588236	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	69.4	1.4e-7	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g60087	i0	100	0.44047619047619	37	0	22	0	8	44	550425	550389	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	74	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
20793430	20793430	PRJNA340009_P_NODE_26457_length_239_cov_39.178947_g26150_i0	PRJNA340009	26457	239	39.178947	93.63768333	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	62.1	3.57e-5	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g26150	i0	97.222	0.150627615062762	36	1	15	0	194	229	589225	589260	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	36	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23344269	23344269	PRJNA340009_P_NODE_53839_length_177_cov_14.265625_g53532_i0	PRJNA340009	53839	177	14.265625	25.25015625	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	113	6.7600000000000005e-21	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g53532	i0	91.463	0.463276836158192	82	7	46	0	79	160	72859	72940	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	82	113	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);;