metadata: contig_metadata: 15 rows where bioproject = "PRJNA608660", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJNA608660", 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
1146947	1146947	PRJNA608660_P_NODE_19401_length_322_cov_2.761905_g19045_i0	PRJNA608660	19401	322	2.761905	8.8933341	Treponema	157	Bacteria	Bacteria	313	1.26e-80	NTclustered	gi\|1826584172\|gb\|MT257116.1\|	162155	g19045	i0	90.041	91.4813664596273	241	24	75	0	16	256	484	244	Uncultured Treponema sp. clone CH43 23S ribosomal RNA gene, partial sequence	blastn	29457	313	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
3135473	3135473	PRJNA608660_P_NODE_21143_length_304_cov_1.345098_g20787_i0	PRJNA608660	21143	304	1.345098	4.08909792	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	130	3.3e-36	NR	MCK9601264.1	1972642	g20787	i0	95.4	0.641447368421053	65	3	64.1	0	17	211	28	92	MCK9601264.1 hypothetical protein [Sphaerochaeta sp.]	diamond	195	130	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
6963226	6963226	PRJNA608660_P_NODE_9906_length_474_cov_2.298824_g9561_i0	PRJNA608660	9906	474	2.298824	10.89642576	Treponema parvum	138851	Bacteria	Bacteria	453	1.08e-122	NTclustered	gi\|2023444933\|gb\|CP054257.1\|	138851	g9561	i0	85.65	188.065400843882	446	47	92	13	11	447	1518103	1517666	Treponema parvum strain ATCC 700773 chromosome, complete genome	blastn	89143	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
7524669	7524669	PRJNA608660_P_NODE_12786_length_414_cov_2.723542_g12438_i0	PRJNA608660	12786	414	2.723542	11.27546388	Treponema	157	Bacteria	Bacteria	568	3.199999999999999e-157	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g12438	i0	92.5	190.352657004831	400	25	96	4	2	400	884	1279	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	78806	573	0.991273996509599	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
8237766	8237766	PRJNA608660_P_NODE_29347_length_239_cov_3.694737_g28991_i0	PRJNA608660	29347	239	3.694737	8.83042143	Treponema parvum	138851	Bacteria	Bacteria	278	3.2600000000000004e-70	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g28991	i0	91.919	168.573221757322	198	16	83	0	12	209	454664	454861	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	40289	278	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
10788817	10788817	PRJNA608660_P_NODE_17389_length_345_cov_8.476351_g17034_i0	PRJNA608660	17389	345	8.476351	29.24341095	Leptospira kobayashii	1917830	Bacteria	Bacteria	593	4.3299999999999987e-165	NTclustered	gi\|2091879162\|dbj\|AP025028.1\|	1917830	g17034	i0	99.691	162.066666666667	324	1	94	0	11	334	677511	677834	Leptospira kobayashii E30 DNA, chromosome 1, complete genome	blastn	55913	593	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kobayashii
10789078	10789078	PRJNA608660_P_NODE_4809_length_659_cov_2.013115_g4515_i0	PRJNA608660	4809	659	2.013115	13.26642785	Treponema sp. Marseille-Q4132	2766701	Bacteria	Bacteria	915	0	NTclustered	gi\|1897717435\|gb\|CP060591.1\|	2766701	g4515	i0	94.683	126.754172989378	583	21	100	1	1	573	2591734	2591152	Treponema sp. Marseille-Q4132 chromosome	blastn	83531	915	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q4132
13338839	13338839	PRJNA608660_P_NODE_33091_length_218_cov_2.461538_g32735_i0	PRJNA608660	33091	218	2.461538	5.36615284	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	150	6.64e-32	NTclustered	gi\|2621786047\|emb\|OY782505.1\|	2791017	g32735	i0	82.022	4.35321100917431	178	30	81	2	13	189	1039134	1039310	MAG: Sphaerochaetaceae bacterium isolate dbdf49c1-f841-4570-9102-cd3a9ce64f89 genome assembly, chromosome: 1	blastn	949	150	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
17724888	17724888	PRJNA608660_P_NODE_37874_length_196_cov_2.714286_g37518_i0	PRJNA608660	37874	196	2.714286	5.32000056	Treponema	157	Bacteria	Bacteria	183	5.76e-42	NTclustered	gi\|1928027651\|gb\|CP061839.1\|	409322	g37518	i0	85.556	11.9438775510204	180	21	90	4	13	189	387882	388059	Treponema pedis strain KS1 chromosome, complete genome	blastn	2341	183	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema pedis
22261727	22261727	PRJNA608660_P_NODE_24518_length_273_cov_2.683036_g24162_i0	PRJNA608660	24518	273	2.683036	7.32468828	Treponema refringens	174922	Bacteria	Bacteria	311	3.75e-80	NTclustered	gi\|16518978\|gb\|AF426101.1\|AF426101	174922	g24162	i0	100	97.8424908424908	168	0	81	0	106	273	1	168	Treponema refringens 16S ribosomal RNA gene, partial sequence	blastn	26711	311	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema refringens
26921925	26921925	PRJNA608660_P_NODE_1482_length_989_cov_17.611702_g1318_i0	PRJNA608660	1482	989	17.611702	174.17973278	Leptospira wolbachii	29511	Bacteria	Bacteria	329	2.3599999999999994e-110	NR	WP_015682231.1	29511	g1318	i0	96.5	0.51567239635996	170	6	51.6	0	525	16	10	179	WP_015682231.1 hypothetical protein [Leptospira wolbachii]	diamond	510	329	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolbachii
26921927	26921927	PRJNA608660_P_NODE_45322_length_169_cov_2.650000_g44965_i0	PRJNA608660	45322	169	2.65	4.4785	Spirochaetota bacterium	2202144	Bacteria	Bacteria	51.6	9.73e-6	NR	MCL1992853.1	2202144	g44965	i0	44.4	0.958579881656805	54	30	95.9	0	1	162	222	275	MCL1992853.1 UbiA family prenyltransferase [Spirochaetota bacterium]	diamond	162	51.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27174726	27174726	PRJNA608660_P_NODE_51102_length_152_cov_2.019417_g50745_i0	PRJNA608660	51102	152	2.019417	3.06951384	Leptospira sanjuanensis	2879643	Bacteria	Bacteria	40.4	0.0346	NR	WP_238731722.1	2879643	g50745	i0	47.4	0.75	38	20	75	0	35	148	80	117	WP_238731722.1 LBF_4227 family protein [Leptospira sanjuanensis]	diamond	114	40.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sanjuanensis
27869650	27869650	PRJNA608660_P_NODE_42925_length_177_cov_2.437500_g42568_i0	PRJNA608660	42925	177	2.4375	4.314375	Treponema sp.	166	Bacteria	Bacteria	80.5	7.46e-16	NR	MFC2329926.1	166	g42568	i0	92.5	0.677966101694915	40	3	67.8	0	56	175	403	442	MFC2329926.1 glycogen/starch/alpha-glucan phosphorylase [Treponema sp.]	diamond	120	80.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29132900	29132900	PRJNA608660_P_NODE_48969_length_163_cov_1.368421_g48612_i0	PRJNA608660	48969	163	1.368421	2.23052623	Spirochaetota bacterium	2202144	Bacteria	Bacteria	41.2	0.0446	NR	MEW5814881.1	2202144	g48612	i0	37.5	0.736196319018405	40	25	73.6	0	38	157	57	96	MEW5814881.1 sugar ABC transporter permease [Spirochaetota bacterium]	diamond	120	41.2	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;