metadata: contig_metadata: 20 rows where bioproject = "PRJNA631119", tax_kingdom = "Pseudomonadati" and tax

20 rows where bioproject = "PRJNA631119", tax_kingdom = "Pseudomonadati" 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
6981649	6981649	PRJNA631119_P_NODE_2306_length_705_cov_3.311709_g2199_i0	PRJNA631119	2306	705	3.311709	23.34754845	Borreliella lusitaniae	100177	Bacteria	Bacteria	60.2	4.21e-4	NTclustered	gi\|2537426705\|gb\|CP124047.1\|	100177	g2199	i0	97.143	0.148936170212766	35	1	5	0	665	699	17381	17347	Borreliella lusitaniae strain PotiB2 plasmid cp26, complete sequence	blastn	105	60.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Borreliaceae	Borreliella	Borreliella lusitaniae
8256494	8256494	PRJNA631119_P_NODE_8827_length_402_cov_1.288754_g8709_i0	PRJNA631119	8827	402	1.288754	5.18079108	Bacteria	2	Bacteria	Bacteria	215	2.84e-65	NR	WP_014804737.1	29510	g8709	i0	79.4	38.9925373134328	131	26	97.8	1	398	6	15	144	WP_014804737.1 adenosylhomocysteinase [Turneriella parva]	diamond	15675	217	0.990783410138249	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
12630849	12630849	PRJNA631119_P_NODE_11990_length_358_cov_1.080702_g11872_i0	PRJNA631119	11990	358	1.080702	3.86891316	Leptospira sp. 96542	3034711	Bacteria	Bacteria	53.5	2.12e-5	NR	MDF3821153.1	3034711	g11872	i0	43.1	0.603351955307263	72	40	59.5	1	353	141	71	142	MDF3821153.1 cyclic nucleotide-binding domain-containing protein [Leptospira sp. 96542]	diamond	216	53.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. 96542
13357376	13357376	PRJNA631119_P_NODE_16671_length_317_cov_1.733607_g16553_i0	PRJNA631119	16671	317	1.733607	5.49553419	Treponema putidum	221027	Bacteria	Bacteria	63.9	1.37e-5	NTclustered	gi\|2277015157\|gb\|CP038803.1\|	221027	g16553	i0	100	19.3753943217666	34	0	11	0	250	283	872615	872648	Treponema putidum strain OMZ 846 chromosome, complete genome	blastn	6142	63.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
26840570	26840570	PRJNA631119_P_NODE_481_length_1293_cov_5.321311_g441_i0	PRJNA631119	481	1293	5.321311	68.80455123	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	73.9	9.86e-11	NR	MDR2632347.1	166	g441	i0	28.6	1.31090487238979	189	119	41.1	6	1250	720	80	264	MDR2632347.1 CAP domain-containing protein [Treponema sp.]	diamond	1695	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27302239	27302239	PRJNA631119_P_NODE_11023_length_369_cov_1.689189_g10905_i0	PRJNA631119	11023	369	1.689189	6.23310741	Spirochaetota bacterium	2202144	Bacteria	Bacteria	129	1.37e-32	NR	MCX8122552.1	2202144	g10905	i0	57	3.76422764227642	114	47	92.7	1	2	343	129	240	MCX8122552.1 IMP dehydrogenase [Spirochaetota bacterium]	diamond	1389	129	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27441351	27441351	PRJNA631119_P_NODE_28443_length_259_cov_1.655914_g28325_i0	PRJNA631119	28443	259	1.655914	4.28881726	Pseudomonadati	3379134	Bacteria	Bacteria	82	4.63e-16	NR	WP_207766284.1	409998	g28325	i0	43.4	3.74131274131274	83	47	96.1	0	256	8	152	234	WP_207766284.1 TauD/TfdA family dioxygenase [Leptospira wolffii]	diamond	969	82	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolffii
27491753	27491753	PRJNA631119_P_NODE_28503_length_259_cov_1.634409_g28385_i0	PRJNA631119	28503	259	1.634409	4.23311931	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.1	0.0322	NR	MDY6969106.1	2202144	g28385	i0	34.7	0.833976833976834	72	36	73	2	202	14	237	306	MDY6969106.1 hypothetical protein [Spirochaetota bacterium]	diamond	216	43.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28154925	28154925	PRJNA631119_P_NODE_26485_length_267_cov_1.556701_g26367_i0	PRJNA631119	26485	267	1.556701	4.15639167	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	58.2	4.36e-8	NR	MBL8035659.1	2026757	g26367	i0	44.9	1.58426966292135	69	36	77.5	1	216	10	2	68	MBL8035659.1 SET domain-containing protein [Leptospiraceae bacterium]	diamond	423	58.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28565182	28565182	PRJNA631119_P_NODE_28827_length_258_cov_1.248649_g28709_i0	PRJNA631119	28827	258	1.248649	3.22151442	Leptospira sp.	178	Bacteria	Bacteria	144	8.59e-42	NR	MCC5815248.1	178	g28709	i0	77.4	8.81395348837209	84	19	97.7	0	256	5	29	112	MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.]	diamond	2274	144	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
28723141	28723141	PRJNA631119_P_NODE_27507_length_263_cov_1.457895_g27389_i0	PRJNA631119	27507	263	1.457895	3.83426385	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	93.2	2.93e-20	NR	MCB1175814.1	2026757	g27389	i0	48	0.855513307984791	75	38	85.6	1	37	261	96	169	MCB1175814.1 SET domain-containing protein [Leptospiraceae bacterium]	diamond	225	93.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29102020	29102020	PRJNA631119_P_NODE_19088_length_302_cov_1.340611_g18970_i0	PRJNA631119	19088	302	1.340611	4.04864522	Leptospira perolatii	2023191	Bacteria	Bacteria	93.2	4.33e-20	NR	WP_100712408.1	2023191	g18970	i0	54.2	1.63907284768212	83	38	82.5	0	2	250	256	338	WP_100712408.1 quinone oxidoreductase family protein [Leptospira perolatii]	diamond	495	93.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira perolatii
29177791	29177791	PRJNA631119_P_NODE_32549_length_249_cov_0.875000_g32431_i0	PRJNA631119	32549	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	51.2	3.93e-5	NR	MDR2718101.1	166	g32431	i0	48.6	4.42168674698795	37	19	44.6	0	5	115	52	88	MDR2718101.1 tetratricopeptide repeat protein [Treponema sp.]	diamond	1101	51.6	0.992248062015504	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29291366	29291366	PRJNA631119_P_NODE_24309_length_276_cov_2.054187_g24191_i0	PRJNA631119	24309	276	2.054187	5.66955612	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.9	0.00797	NR	MBN1500261.1	2202144	g24191	i0	68	0.271739130434783	25	8	27.2	0	26	100	29	53	MBN1500261.1 hypothetical protein [Spirochaetota bacterium]	diamond	75	43.9	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29493407	29493407	PRJNA631119_P_NODE_36490_length_244_cov_0.900585_g36372_i0	PRJNA631119	36490	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	95.9	7.49e-21	NR	WP_000377871.1	173	g36372	i0	55.6	9.87295081967213	81	36	99.6	0	243	1	79	159	WP_000377871.1 elongation factor G [Leptospira interrogans]	diamond	2409	95.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira interrogans
30017806	30017806	PRJNA631119_P_NODE_31231_length_251_cov_0.865169_g31113_i0	PRJNA631119	31231	251	0.865169	2.17157419	Treponema sp.	166	Bacteria	Bacteria	47.4	9.71e-4	NR	WP_407426243.1	166	g31113	i0	39.1	2.89243027888446	64	37	76.5	1	47	238	647	708	WP_407426243.1 penicillin-binding protein 1A [Treponema sp.]	diamond	726	47.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30080721	30080721	PRJNA631119_P_NODE_39552_length_241_cov_0.916667_g39434_i0	PRJNA631119	39552	241	0.916667	2.20916747	Treponema phagedenis	162	Bacteria	Bacteria	41.2	0.0236	NR	QSI00030.1	162	g39434	i0	33.3	0.634854771784232	51	30	58.5	1	166	26	17	67	QSI00030.1 hypothetical protein DWQ65_08130 [Treponema phagedenis]	diamond	153	41.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
31313221	31313221	PRJNA631119_P_NODE_7535_length_427_cov_2.980226_g7417_i0	PRJNA631119	7535	427	2.980226	12.72556502	Spirochaetes bacterium GWB1_59_5	1802176	Bacteria	Bacteria	58.2	3.85e-7	NR	OHD18884.1	1802176	g7417	i0	37.3	0.82903981264637	118	64	75.9	2	407	84	14	131	OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5]	diamond	354	58.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWB1_59_5
31503183	31503183	PRJNA631119_P_NODE_38716_length_242_cov_0.911243_g38598_i0	PRJNA631119	38716	242	0.911243	2.20520806	Leptospira mgodei	3235172	Bacteria	Bacteria	42.4	0.0458	NR	XDD52962.1	3235172	g38598	i0	36.5	0.91735537190082606	74	44	88	1	22	234	47	120	XDD52962.1 hypothetical protein AB3N62_10760 [Leptospira mgodei]	diamond	222	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
31926711	31926711	PRJNA631119_P_NODE_13877_length_339_cov_1.533835_g13759_i0	PRJNA631119	13877	339	1.533835	5.19970065	Pseudomonadati	3379134	Bacteria	Bacteria	72.8	3.13e-12	NR	OHD37219.1	1802184	g13759	i0	53.6	1.8141592920354	69	32	61.1	0	4	210	393	461	OHD37219.1 MAG: hypothetical protein A2Y30_07035 [Spirochaetes bacterium GWE1_32_154]	diamond	615	72.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetes bacterium GWE1_32_154

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