metadata: contig_metadata: 16 rows where bioproject = "PRJNA1126661", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA1126661", 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
1556747	1556747	PRJNA1126661_P_NODE_15142_length_326_cov_5.019763_g14613_i0	PRJNA1126661	15142	326	5.019763	16.36442738	Leptospira	171	Bacteria	Bacteria	160	2.07e-44	NR	WP_002973468.1	293075	g14613	i0	46.9	8.92638036809816	194	17	99.4	1	3	326	155	348	WP_002973468.1 glycogen/starch synthase [Leptospira terpstrae]	diamond	2910	160	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira terpstrae
2832986	2832986	PRJNA1126661_P_NODE_30543_length_326_cov_1.802372_g30014_i0	PRJNA1126661	30543	326	1.802372	5.87573272	Leptospira mgodei	3235172	Bacteria	Bacteria	268	2.7999999999999998e-67	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g30014	i0	98.675	0.46319018404908	151	2	46	0	1	151	2518928	2518778	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	151	268	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
4109287	4109287	PRJNA1126661_P_NODE_28264_length_326_cov_2.822134_g27735_i0	PRJNA1126661	28264	326	2.822134	9.20015684	Leptospira cinconiae	3235173	Bacteria	Bacteria	279	1.29e-70	NTclustered	gi\|2777192084\|gb\|CP162137.1\|	3235173	g27735	i0	100	0.926380368098159	151	0	93	0	176	326	2881758	2881608	Leptospira cinconiae strain WS58.C1 chromosome 1, complete sequence	blastn	302	279	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira cinconiae
9959032	9959032	PRJNA1126661_P_NODE_30948_length_325_cov_5.638889_g30419_i0	PRJNA1126661	30948	325	5.638889	18.32638925	Treponema	157	Bacteria	Bacteria	272	2.1499999999999996e-68	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g30419	i0	99.333	12.0123076923077	150	1	92	0	1	150	1801015	1800866	Treponema medium strain T19 chromosome, complete genome	blastn	3904	272	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
20683825	20683825	PRJNA1126661_P_NODE_35857_length_301_cov_5.548246_g35328_i0	PRJNA1126661	35857	301	5.548246	16.70022046	Leptospira mgodei	3235172	Bacteria	Bacteria	283	9.12e-72	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g35328	i0	100	1.00996677740864	153	0	100	0	149	301	3184908	3184756	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	304	283	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
23983293	23983293	PRJNA1126661_P_NODE_43539_length_300_cov_4.718062_g43010_i0	PRJNA1126661	43539	300	4.718062	14.154186	Leptospira	171	Bacteria	Bacteria	279	1.18e-70	NTclustered	gi\|2330606\|emb\|Z98588.1\|	172	g43010	i0	100	93.1633333333333	151	0	100	0	1	151	261	411	Leptospira biflexa 16S ribosomal RNA, mutant 3/1994	blastn	27949	279	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira biflexa
24508702	24508702	PRJNA1126661_P_NODE_67820_length_259_cov_1.677419_g67290_i0	PRJNA1126661	67820	259	1.677419	4.34451521	Leptospira mgodei	3235172	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g67290	i0	98.842	2.15057915057915	259	3	100	0	1	259	1923003	1922745	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	557	462	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
27038672	27038672	PRJNA1126661_P_NODE_58362_length_281_cov_5.432692_g57833_i0	PRJNA1126661	58362	281	5.432692	15.26586452	Treponema sp.	166	Bacteria	Bacteria	95.5	1.69e-20	NR	MFC2329616.1	166	g57833	i0	94.1	0.544483985765125	51	3	54.4	0	155	3	1	51	MFC2329616.1 cytidylyltransferase domain-containing protein [Treponema sp.]	diamond	153	95.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27280764	27280764	PRJNA1126661_P_NODE_24643_length_326_cov_3.256917_g24114_i0	PRJNA1126661	24643	326	3.256917	10.61754942	Bacteria	2	Bacteria	Bacteria	63.5	1.03e-9	NR	NCB03570.1	2053615	g24114	i0	65.9	1.95092024539877	41	14	37.7	0	299	177	14	54	NCB03570.1 serine/threonine protein phosphatase [Spirochaetia bacterium]	diamond	636	63.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27954748	27954748	PRJNA1126661_P_NODE_31565_length_324_cov_4.792829_g31036_i0	PRJNA1126661	31565	324	4.792829	15.52876596	Leptospira vanthielii serovar Holland str. Waz Holland = ATCC 7	293085	Bacteria	Bacteria	100	3.88e-22	NR	EMY68376.1	1218591	g31036	i0	100	0.907407407407407	49	0	45.4	0	324	178	405	453	EMY68376.1 polysaccharide biosynthesis protein [Leptospira vanthielii serovar Holland str. Waz Holland = ATCC 700522]	diamond	294	100	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira vanthielii
28523151	28523151	PRJNA1126661_P_NODE_21307_length_326_cov_3.699605_g20778_i0	PRJNA1126661	21307	326	3.699605	12.0607123	Spirochaetota bacterium	2202144	Bacteria	Bacteria	102	8.459999999999999e-23	NR	MBP7737994.1	2202144	g20778	i0	100	0.460122699386503	50	0	46	0	326	177	243	292	MBP7737994.1 hypothetical protein [Spirochaetota bacterium]	diamond	150	102	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28617925	28617925	PRJNA1126661_P_NODE_39707_length_301_cov_3.526316_g39178_i0	PRJNA1126661	39707	301	3.526316	10.61421116	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	98.2	2.5200000000000004e-21	NR	MBP9164612.1	2026757	g39178	i0	94.2	3.10963455149502	52	3	51.8	0	301	146	247	298	MBP9164612.1 efflux RND transporter permease subunit [Leptospiraceae bacterium]	diamond	936	98.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28933564	28933564	PRJNA1126661_P_NODE_3248_length_494_cov_8.750594_g2733_i0	PRJNA1126661	3248	494	8.750594	43.22793436	Spirochaetota bacterium	2202144	Bacteria	Bacteria	94.7	1.81e-20	NR	MDY6969782.1	2202144	g2733	i0	31.1	3.97165991902834	212	30	59.5	3	32	325	1	210	MDY6969782.1 DNA adenine methylase [Spirochaetota bacterium]	diamond	1962	94.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30986745	30986745	PRJNA1126661_P_NODE_61814_length_273_cov_6.195000_g61284_i0	PRJNA1126661	61814	273	6.195	16.91235	Treponema sp.	166	Bacteria	Bacteria	65.1	7.53e-10	NR	MFC2330313.1	166	g61284	i0	48.4	1	91	45	97.8	2	268	2	915	1005	MFC2330313.1 FlgD immunoglobulin-like domain containing protein [Treponema sp.]	diamond	273	65.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31081476	31081476	PRJNA1126661_P_NODE_48215_length_298_cov_3.173333_g47686_i0	PRJNA1126661	48215	298	3.173333	9.45653234	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	73.9	8.02e-13	NR	HMV41673.1	2026757	g47686	i0	66	1.76174496644295	50	17	50.3	0	1	150	852	901	HMV41673.1 ATP-binding protein [Leptospiraceae bacterium]	diamond	525	73.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
32536634	32536634	PRJNA1126661_P_NODE_82299_length_216_cov_5.874126_g81769_i0	PRJNA1126661	82299	216	5.874126	12.68811216	Spirochaetales bacterium	2026792	Bacteria	Bacteria	92	1.5600000000000002e-21	NR	MDC7223341.1	2026792	g81769	i0	65.6	0.888888888888889	64	22	88.9	0	2	193	81	144	MDC7223341.1 GNAT family N-acetyltransferase [Spirochaetales bacterium]	diamond	192	92	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);;