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

14 rows where analysis = "blastn", bioproject = "PRJNA641707" 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
613109	613109	PRJNA641707_P_NODE_202981_length_197_cov_3.533784_g200318_i0	PRJNA641707	202981	197	3.533784	6.96155448	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	154	4.55e-33	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g200318	i0	82.682	191.979695431472	179	26	89	4	21	196	386227	386051	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	37820	154	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
6990328	6990328	PRJNA641707_P_NODE_148666_length_238_cov_10.222222_g146003_i0	PRJNA641707	148666	238	10.222222	24.32888836	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	76.8	1.27e-9	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g146003	i0	81.132	2.52521008403361	106	10	41	7	139	236	983403	983506	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	601	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
6995197	6995197	PRJNA641707_P_NODE_51026_length_301_cov_21.329365_g48368_i0	PRJNA641707	51026	301	21.329365	64.20138865	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	191	5.69e-44	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g48368	i0	78.808	29.6478405315615	302	51	98	12	4	298	963113	963408	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	8924	191	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9543197	9543197	PRJNA641707_P_NODE_270768_length_174_cov_2.880000_g268105_i0	PRJNA641707	270768	174	2.88	5.0112	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	215	1.76e-51	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g268105	i0	90.244	11.9195402298851	164	16	94	0	7	170	178160	177997	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	2074	215	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
10816875	10816875	PRJNA641707_P_NODE_183989_length_199_cov_11.726667_g181326_i0	PRJNA641707	183989	199	11.726667	23.33606733	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	176	9.82e-40	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g181326	i0	84.153	2.76381909547739	183	27	91	2	4	185	125872	126053	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	550	176	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12090826	12090826	PRJNA641707_P_NODE_128490_length_244_cov_7.733333_g125827_i0	PRJNA641707	128490	244	7.733333	18.86933252	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	185	2.0799999999999994e-42	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g125827	i0	96.429	64.7827868852459	112	4	85	0	4	115	429583	429694	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	15807	185	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12094570	12094570	PRJNA641707_P_NODE_29070_length_401_cov_20.301136_g26464_i0	PRJNA641707	29070	401	20.301136	81.40755536	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	359	2.02e-94	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g26464	i0	92.742	195.613466334165	248	18	62	0	1	248	176726	176973	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	78441	359	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17189608	17189608	PRJNA641707_P_NODE_138234_length_242_cov_6.564767_g135571_i0	PRJNA641707	138234	242	6.564767	15.88673614	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	148	2.6999999999999997e-31	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g135571	i0	94.737	75.4504132231405	95	5	39	0	4	98	247124	247030	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	18259	148	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
22291666	22291666	PRJNA641707_P_NODE_267598_length_175_cov_4.650794_g264935_i0	PRJNA641707	267598	175	4.650794	8.1388895	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	226	8.209999999999999e-55	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g264935	i0	90.588	111.222857142857	170	16	97	0	1	170	176321	176490	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	19464	226	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
22294376	22294376	PRJNA641707_P_NODE_81058_length_246_cov_7.913706_g78395_i0	PRJNA641707	81058	246	7.913706	19.46771676	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	263	9.430000000000001e-66	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g78395	i0	86.307	98.890243902439	241	33	98	0	2	242	961685	961925	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	24327	263	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
22294508	22294508	PRJNA641707_P_NODE_86778_length_246_cov_6.340102_g84115_i0	PRJNA641707	86778	246	6.340102	15.59665092	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	159	1.27e-34	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g84115	i0	95.05	3.26829268292683	101	5	41	0	1	101	493620	493520	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	804	159	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23563475	23563475	PRJNA641707_P_NODE_10219_length_671_cov_12.739550_g8202_i0	PRJNA641707	10219	671	12.73955	85.4823805	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	359	3.52e-94	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g8202	i0	92.742	52.317436661699	248	18	37	0	315	562	176973	176726	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	35105	359	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23568472	23568472	PRJNA641707_P_NODE_318039_length_158_cov_9.458716_g315376_i0	PRJNA641707	318039	158	9.458716	14.94477128	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	169	1.24e-37	NTclustered	gi\|2258874820\|gb\|CP060231.1\|	2052152	g315376	i0	87.013	35.8291139240506	154	14	96	4	8	158	176257	176107	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-36 chromosome	blastn	5661	169	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23568532	23568532	PRJNA641707_P_NODE_321159_length_157_cov_6.629630_g318496_i0	PRJNA641707	321159	157	6.62963	10.4085191	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g318496	i0	100	0.178343949044586	28	0	18	0	110	137	358316	358343	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	28	52.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);;