metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA704949" 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
3247575	3247575	PRJNA704949_P_NODE_30283_length_1443_cov_9.578910_g21241_i0	PRJNA704949	30283	1443	9.57891	138.2236713	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	2034	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g21241	i0	92.469	90.2612612612613	1434	90	99	14	6	1429	964554	963129	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	130247	2034	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
5802324	5802324	PRJNA704949_P_NODE_546525_length_368_cov_1.815047_g531220_i0	PRJNA704949	546525	368	1.815047	6.67937296	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	446	1.3699999999999999e-120	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g531220	i0	88.859	122.497282608696	368	34	99	7	4	368	964550	964187	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	45079	446	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
7075071	7075071	PRJNA704949_P_NODE_303926_length_488_cov_1.993166_g289106_i0	PRJNA704949	303926	488	1.993166	9.72665008	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	145	7.63e-30	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g289106	i0	98.765	27.1823770491803	81	1	17	0	337	417	292139	292219	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	13265	145	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
7078012	7078012	PRJNA704949_P_NODE_62366_length_970_cov_2.233442_g51162_i0	PRJNA704949	62366	970	2.233442	21.6643874	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	1020	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g51162	i0	95.469	63.2587628865979	640	28	66	1	1	640	966692	966054	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	61361	1020	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
10892370	10892370	PRJNA704949_P_NODE_1284209_length_222_cov_2.150289_g1268872_i0	PRJNA704949	1284209	222	2.150289	4.77364158	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	106	1.49e-18	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1268872	i0	91.026	6.7972972972973	78	7	35	0	92	169	984605	984528	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	1509	106	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
14715540	14715540	PRJNA704949_P_NODE_1076052_length_249_cov_1.040000_g1060716_i0	PRJNA704949	1076052	249	1.04	2.5896	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	231	2.7e-56	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g1060716	i0	85.78	1.7389558232931701	218	31	88	0	20	237	204264	204047	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	433	231	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17271015	17271015	PRJNA704949_P_NODE_1895034_length_171_cov_1.278689_g1879695_i0	PRJNA704949	1895034	171	1.278689	2.18655819	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	122	1.0799999999999999e-23	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1879695	i0	91.209	0.532163742690059	91	6	53	2	76	165	216954	217043	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	91	122	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17274790	17274790	PRJNA704949_P_NODE_345634_length_460_cov_2.352798_g330666_i0	PRJNA704949	345634	460	2.352798	10.8228708	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	145	7.16e-30	NTclustered	gi\|2258876802\|gb\|CP060233.1\|	2052152	g330666	i0	100	34.75	78	0	17	0	281	358	105884	105961	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-42 chromosome, complete genome	blastn	15985	145	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17278135	17278135	PRJNA704949_P_NODE_708094_length_320_cov_1.309963_g692765_i0	PRJNA704949	708094	320	1.309963	4.1918816	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	289	2.1e-73	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g692765	i0	83.228	60.934375	316	51	98	2	6	320	348333	348647	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	19499	289	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
22373851	22373851	PRJNA704949_P_NODE_30318_length_1442_cov_8.299354_g21241_i1	PRJNA704949	30318	1442	8.299354	119.67668468	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	1971	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g21241	i1	91.707	90.495839112344	1435	98	99	17	15	1437	963129	964554	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	130495	1971	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23639649	23639649	PRJNA704949_P_NODE_1097499_length_246_cov_1.015228_g1082163_i0	PRJNA704949	1097499	246	1.015228	2.49746088	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	172	1.63e-38	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1082163	i0	83.069	0.768292682926829	189	32	77	0	1	189	547031	546843	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	189	172	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23645279	23645279	PRJNA704949_P_NODE_177559_length_616_cov_2.282187_g21241_i3	PRJNA704949	177559	616	2.282187	14.05827192	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	922	0	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g21241	i3	93.974	188.775974025974	614	30	99	6	6	616	964554	963945	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	116286	922	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23646910	23646910	PRJNA704949_P_NODE_1978839_length_168_cov_0.873950_g1963500_i0	PRJNA704949	1978839	168	0.87395	1.468236	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	126	8.2e-25	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1963500	i0	82.192	60.3690476190476	146	26	87	0	3	148	1078593	1078448	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	10142	126	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24918120	24918120	PRJNA704949_P_NODE_1720060_length_183_cov_1.940299_g1704721_i0	PRJNA704949	1720060	183	1.940299	3.55074717	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	65.8	2e-6	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1704721	i0	95.122	0.420765027322404	41	2	22	0	87	127	758130	758090	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	77	65.8	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);;