metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Spirochaetota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25631102	25631102	PRJNA737474g_S_NODE_336145_length_249_cov_1.113636_g334851_i0	PRJNA737474	336145	249	1.113636	2.77295364	Bacteria	2	Bacteria	Bacteria	62.1	3.74e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g334851	i0	100	0.397590361445783	33	0	13	0	30	62	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25712055	25712055	PRJNA737474e_S_NODE_4306_length_511_cov_1.694064_g3430_i0	PRJNA737474	4306	511	1.694064	8.65666704	Leptospira sp. severe_	178	Bacteria	Bacteria	444	7.06e-120	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g3430	i0	84.444	9.40900195694716	450	70	88	0	62	511	216614	216165	Leptospira sp. severe_002 chromosome 1	blastn	4808	444	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
25765555	25765555	PRJNA737474f_S_NODE_289914_length_240_cov_110.544910_g289236_i0	PRJNA737474	289914	240	110.54491	265.307784	root	1	Root_unresolved	Root_unresolved	67.6	7.71e-7	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g289236	i0	100	24.6416666666667	36	0	15	0	150	185	20766	20801	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	5914	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25765677	25765677	PRJNA737474f_S_NODE_365202_length_210_cov_3573.861314_g364524_i0	PRJNA737474	365202	210	3573.861314	7505.1087594	Bacteria	2	Bacteria	Bacteria	67.6	6.58e-7	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g364524	i0	100	3.38571428571429	36	0	17	0	144	179	20766	20801	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	711	67.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25767405	25767405	PRJNA737474g_S_NODE_330738_length_250_cov_0.864407_g329444_i0	PRJNA737474	330738	250	0.864407	2.1610175	Pseudomonadati	3379134	Bacteria	Bacteria	65.8	2.91e-6	NTclustered	gi\|2592016017\|gb\|CP117912.1\|	29519	g329444	i0	100	0.552	35	0	14	0	201	235	20766	20800	Borreliella garinii strain NG-Z6 plasmid lp17	blastn	138	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25767915	25767915	PRJNA737474g_S_NODE_465586_length_235_cov_3.320988_g464292_i0	PRJNA737474	465586	235	3.320988	7.8043218	Bacteria	2	Bacteria	Bacteria	62.1	3.5e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g464292	i0	100	0.451063829787234	33	0	14	0	186	218	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	106	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25859678	25859678	PRJNA737474g_S_NODE_405067_length_243_cov_1044.882353_g403773_i0	PRJNA737474	405067	243	1044.882353	2539.06411779	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	73.1	1.68e-8	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g403773	i0	95.652	176.156378600823	46	1	19	1	30	75	31	75	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42806	73.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
25860603	25860603	PRJNA737474g_S_NODE_494891_length_229_cov_864.262821_g493597_i0	PRJNA737474	494891	229	864.262821	1979.16186009	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	4.36e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g493597	i0	95.745	187.07423580786	47	1	21	1	154	200	76	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42840	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
25901391	25901391	PRJNA737474f_S_NODE_256427_length_244_cov_0.923977_g255749_i0	PRJNA737474	256427	244	0.923977	2.25450388	Bacteria	2	Bacteria	Bacteria	62.1	3.66e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g255749	i0	100	0.405737704918033	33	0	14	0	15	47	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25901410	25901410	PRJNA737474f_S_NODE_269739_length_243_cov_0.788235_g269061_i0	PRJNA737474	269739	243	0.788235	1.91541105	Bacteria	2	Bacteria	Bacteria	62.1	3.64e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g269061	i0	100	0.423868312757202	33	0	14	0	24	56	868464	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	103	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
25903401	25903401	PRJNA737474g_S_NODE_356643_length_247_cov_3.827586_g355349_i0	PRJNA737474	356643	247	3.827586	9.45413742	Borrelia	138	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2668652688\|gb\|CP129313.1\|	142	g355349	i0	100	0.226720647773279	28	0	11	0	185	212	11682	11655	Borrelia turicatae strain BTCAM1 plasmid lp32, complete sequence	blastn	56	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borrelia	Borrelia turicatae
25997355	25997355	PRJNA737474g_S_NODE_589900_length_206_cov_47.180451_g588606_i0	PRJNA737474	589900	206	47.180451	97.19172906	Borreliella garinii	29519	Bacteria	Bacteria	65.8	2.31e-6	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g588606	i0	100	0.62621359223301	35	0	17	0	24	58	868464	868498	Borreliella garinii strain 17-54Z3 chromosome	blastn	129	65.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26175803	26175803	PRJNA737474g_S_NODE_346829_length_248_cov_1.200000_g345535_i0	PRJNA737474	346829	248	1.2	2.976	Bacteria	2	Bacteria	Bacteria	62.1	3.73e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g345535	i0	100	0.399193548387097	33	0	13	0	197	229	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	99	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26268367	26268367	PRJNA737474g_S_NODE_430734_length_241_cov_824.166667_g429440_i0	PRJNA737474	430734	241	824.166667	1986.24166747	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	4.63e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g429440	i0	97.674	176.44398340249	43	1	18	0	166	208	76	34	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42523	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26269583	26269583	PRJNA737474g_S_NODE_580630_length_208_cov_10476.925926_g579336_i0	PRJNA737474	580630	208	10476.925926	21792.00592608	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	76.8	1.08e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g579336	i0	95.833	206.548076923077	48	1	23	1	130	177	77	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	42962	76.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26312244	26312244	PRJNA737474g_S_NODE_572958_length_211_cov_5.000000_g571664_i0	PRJNA737474	572958	211	5	10.55	Bacteria	2	Bacteria	Bacteria	63.9	8.56e-6	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g571664	i0	100	0.483412322274882	34	0	16	0	17	50	868463	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	102	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26448002	26448002	PRJNA737474g_S_NODE_41247_length_446_cov_12.394102_g39957_i0	PRJNA737474	41247	446	12.394102	55.27769492	Bacteria	2	Bacteria	Bacteria	62.1	7.17e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g39957	i0	100	0.291479820627803	33	0	7	0	412	444	868496	868464	Borreliella garinii strain 17-54Z3 chromosome	blastn	130	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26529692	26529692	PRJNA737474f_S_NODE_134304_length_273_cov_1.985000_g133626_i0	PRJNA737474	134304	273	1.985	5.41905	Leptospira sp. severe_	178	Bacteria	Bacteria	255	1.7800000000000001e-63	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g133626	i0	85.656	40.8461538461538	244	33	89	2	14	256	18030	18272	Leptospira sp. severe_002 chromosome 1	blastn	11151	255	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
26533474	26533474	PRJNA737474f_S_NODE_63640_length_321_cov_2.435484_g62962_i0	PRJNA737474	63640	321	2.435484	7.81790364	Leptospira noguchii	28182	Bacteria	Bacteria	119	2.93e-22	NTclustered	gi\|2218393545\|gb\|CP091953.1\|	28182	g62962	i0	83.077	1.21495327102804	130	22	40	0	74	203	3910566	3910437	Leptospira noguchii strain IP1605021 chromosome 1, complete sequence	blastn	390	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira noguchii
26541554	26541554	PRJNA737474g_S_NODE_582248_length_208_cov_1048.725926_g580954_i0	PRJNA737474	582248	208	1048.725926	2181.34992608	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	75	3.89e-9	NTclustered	gi\|2166239570\|dbj\|LC662868.1\|	1898206	g580954	i0	95.745	206.903846153846	47	1	23	1	133	179	76	31	Spirochaetaceae bacterium ARSSAG-00002195 DNA, putative prophage region, clone: 00002195_pp3	blastn	43036	75	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
26583432	26583432	PRJNA737474g_S_NODE_297736_length_254_cov_1.000000_g296442_i0	PRJNA737474	297736	254	1	2.54	Bacteria	2	Bacteria	Bacteria	63.9	1.07e-5	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g296442	i0	100	0.767716535433071	34	0	13	0	29	62	868463	868496	Borreliella garinii strain 17-54Z3 chromosome	blastn	195	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii
26583718	26583718	PRJNA737474g_S_NODE_358176_length_247_cov_1.287356_g356882_i0	PRJNA737474	358176	247	1.287356	3.17976932	Bacteria	2	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2592017114\|gb\|CP117894.1\|	29519	g356882	i0	100	0.340080971659919	28	0	11	0	220	247	868496	868469	Borreliella garinii strain 17-54Z3 chromosome	blastn	84	52.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella garinii

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);;