metadata: contig_metadata: 11 rows where bioproject = "PRJNA857857", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA857857", 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
845444	845444	PRJNA857857_P_NODE_51341_length_241_cov_0.916667_g50892_i0	PRJNA857857	51341	241	0.916667	2.20916747	Treponema sp.	166	Bacteria	Bacteria	131	2.5599999999999996e-35	NR	MDR3146432.1	166	g50892	i0	83.1	2.87551867219917	77	13	95.9	0	2	232	165	241	MDR3146432.1 ABC transporter permease subunit [Treponema sp.]	diamond	693	131	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27276448	27276448	PRJNA857857_P_NODE_51063_length_241_cov_0.916667_g50614_i0	PRJNA857857	51063	241	0.916667	2.20916747	Candidatus Aphodenecus pullistercoris	2840669	Bacteria	Bacteria	61.6	9.47e-10	NR	MBO8442475.1	2840669	g50614	i0	70	0.49792531120332	40	12	49.8	0	3	122	104	143	MBO8442475.1 50S ribosomal protein L15 [Candidatus Aphodenecus pullistercoris]	diamond	120	61.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Candidatus Aphodenecus	Candidatus Aphodenecus pullistercoris
27632003	27632003	PRJNA857857_P_NODE_36244_length_252_cov_1.290503_g35795_i0	PRJNA857857	36244	252	1.290503	3.25206756	Bacteria	2	Bacteria	Bacteria	88.2	4.18e-18	NR	MBQ8777714.1	166	g35795	i0	54.9	20.202380952381	82	35	97.6	1	3	248	365	444	MBQ8777714.1 AAA family ATPase [Treponema sp.]	diamond	5091	88.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27750295	27750295	PRJNA857857_P_NODE_13044_length_436_cov_1.696970_g12599_i0	PRJNA857857	13044	436	1.69697	7.3987892	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	110	6.83e-26	NR	HQI18668.1	2026757	g12599	i0	53.4	0.708715596330275	103	41	66.1	2	55	342	36	138	HQI18668.1 hypothetical protein [Leptospiraceae bacterium]	diamond	309	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28034384	28034384	PRJNA857857_P_NODE_9345_length_511_cov_1.481735_g8908_i0	PRJNA857857	9345	511	1.481735	7.57166585	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	120	4.86e-29	NR	MBL0265350.1	2026757	g8908	i0	37.4	2.01369863013699	174	99	96.9	4	510	16	195	367	MBL0265350.1 alpha/beta hydrolase [Leptospiraceae bacterium]	diamond	1029	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29715516	29715516	PRJNA857857_P_NODE_48210_length_243_cov_0.905882_g47761_i0	PRJNA857857	48210	243	0.905882	2.20129326	Spirochaetales	136	Bacteria	Bacteria	115	7.38e-30	NR	WP_319756817.1	886478	g47761	i0	63.8	6.88888888888889	80	29	98.8	0	3	242	152	231	WP_319756817.1 copper homeostasis protein CutC [uncultured Sphaerochaeta sp.]	diamond	1674	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	uncultured Sphaerochaeta sp.
30276581	30276581	PRJNA857857_P_NODE_30072_length_282_cov_0.937799_g29623_i0	PRJNA857857	30072	282	0.937799	2.64459318	Leptospira wolffii	409998	Bacteria	Bacteria	62.4	4.21e-9	NR	WP_016546670.1	409998	g29623	i0	43.8	0.776595744680851	73	34	75.5	4	270	58	47	114	WP_016546670.1 acetoacetate decarboxylase family protein [Leptospira wolffii]	diamond	219	62.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolffii
31066387	31066387	PRJNA857857_P_NODE_23195_length_324_cov_1.920319_g22746_i0	PRJNA857857	23195	324	1.920319	6.22183356	Spirochaetales bacterium	2026792	Bacteria	Bacteria	56.6	1.03e-6	NR	MBN1834663.1	2026792	g22746	i0	28.3	0.981481481481482	106	68	98.1	2	3	320	182	279	MBN1834663.1 hypothetical protein [Spirochaetales bacterium]	diamond	318	56.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31295518	31295518	PRJNA857857_P_NODE_21655_length_336_cov_1.171103_g21206_i0	PRJNA857857	21655	336	1.171103	3.93490608	Pseudomonadati	3379134	Bacteria	Bacteria	144	3.43e-38	NR	MBN2534482.1	2026792	g21206	i0	63.4	3	112	41	100	0	336	1	161	272	MBN2534482.1 nicotinate phosphoribosyltransferase [Spirochaetales bacterium]	diamond	1008	145	0.993103448275862	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31382404	31382404	PRJNA857857_P_NODE_42796_length_247_cov_0.885057_g42347_i0	PRJNA857857	42796	247	0.885057	2.18609079	Candidatus Aphodenecus pullistercoris	2840669	Bacteria	Bacteria	173	5.89e-52	NR	MBO8442769.1	2840669	g42347	i0	100	0.995951417004049	82	0	99.6	0	2	247	81	162	MBO8442769.1 hypothetical protein [Candidatus Aphodenecus pullistercoris]	diamond	246	173	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales		Candidatus Aphodenecus	Candidatus Aphodenecus pullistercoris
32023147	32023147	PRJNA857857_P_NODE_17378_length_377_cov_0.838816_g16931_i0	PRJNA857857	17378	377	0.838816	3.16233632	FCB group	1783270	Bacteria	Bacteria	49.7	1.69e-4	NR	MFP4551293.1	2026792	g16931	i0	44.2	1.85411140583554	52	28	40.6	1	21	173	2	53	MFP4551293.1 phytanoyl-CoA dioxygenase family protein [Spirochaetales bacterium]	diamond	699	49.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales 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);;