metadata: contig_metadata: 10 rows where bioproject = "PRJNA414036" and tax

10 rows where bioproject = "PRJNA414036" 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
418802	418802	PRJNA414036_P_NODE_6221_length_494_cov_34.403050_g1439_i1	PRJNA414036	6221	494	34.40305	169.951067	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	592	2.3e-164	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i1	95.902	96.5141700404858	366	13	74	2	121	485	964086	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	47678	592	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
4245882	4245882	PRJNA414036_P_NODE_6224_length_494_cov_25.751634_g5113_i0	PRJNA414036	6224	494	25.751634	127.21307196	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	606	8.209999999999996e-169	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g5113	i0	88.866	196.323886639676	494	34	96	6	9	481	962292	962785	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	96984	606	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8072124	8072124	PRJNA414036_P_NODE_7607_length_469_cov_36.262673_g1439_i2	PRJNA414036	7607	469	36.262673	170.07193637	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	665	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i2	94.131	120.912579957356	443	16	94	4	20	460	964156	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	56708	665	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8072134	8072134	PRJNA414036_P_NODE_7987_length_463_cov_36.707944_g1439_i3	PRJNA414036	7987	463	36.707944	169.95778072	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	656	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i3	94.226	114.032397408207	433	19	92	4	27	454	964153	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	52797	656	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9346808	9346808	PRJNA414036_P_NODE_16108_length_370_cov_47.510448_g1439_i8	PRJNA414036	16108	370	47.510448	175.7886576	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	551	2.839999999999999e-152	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i8	94.915	114.543243243243	354	15	95	3	10	361	964074	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	42381	551	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9346822	9346822	PRJNA414036_P_NODE_1808_length_648_cov_52.412724_g1439_i0	PRJNA414036	1808	648	52.412724	339.63445152	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	440	1.1799999999999996e-118	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i0	96.283	88.7376543209877	269	8	84	2	10	277	964086	963819	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	57502	440	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
11897701	11897701	PRJNA414036_P_NODE_8610_length_454_cov_37.747017_g1439_i5	PRJNA414036	8610	454	37.747017	171.37145718	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	592	2.1e-164	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i5	95.902	105.017621145374	366	13	80	2	81	445	964086	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	47678	592	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
13172590	13172590	PRJNA414036_P_NODE_8611_length_454_cov_37.525060_g1439_i6	PRJNA414036	8611	454	37.52506	170.3637724	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	592	2.1e-164	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i6	95.902	105.017621145374	366	13	80	2	81	445	964086	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	47678	592	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
15721515	15721515	PRJNA414036_P_NODE_8313_length_458_cov_36.988180_g1439_i4	PRJNA414036	8313	458	36.98818	169.4058644	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	662	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i4	94.266	118.727074235808	436	19	94	4	19	449	964156	963722	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	54377	662	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18270251	18270251	PRJNA414036_P_NODE_10955_length_423_cov_40.930412_g1439_i7	PRJNA414036	10955	423	40.930412	173.13564276	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	601	3.2299999999999998e-167	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1439	i7	93.366	116.309692671395	407	25	96	2	10	415	964086	963681	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	49199	601	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);;