metadata: contig_metadata: 12 rows where bioproject = "PRJNA1174234", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA1174234", 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
4868971	4868971	PRJNA1174234_P_NODE_10504_length_425_cov_2.375000_g10308_i0	PRJNA1174234	10504	425	2.375	10.09375	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	115	1.98e-29	NR	HNO24933.1	2026757	g10308	i0	72.3	1.42588235294118	83	23	58.6	0	424	176	65	147	HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium]	diamond	606	115	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
23268239	23268239	PRJNA1174234_P_NODE_11759_length_402_cov_1.158055_g11563_i0	PRJNA1174234	11759	402	1.158055	4.6553811	Pseudomonadati	3379134	Bacteria	Bacteria	210	2.97e-67	NR	MCC5815248.1	178	g11563	i0	73.1	25.9477611940299	134	35	100	1	1	402	13	145	MCC5815248.1 glycine dehydrogenase (aminomethyl-transferring) [Leptospira sp.]	diamond	10431	210	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
26787446	26787446	PRJNA1174234_P_NODE_11781_length_401_cov_1.945122_g11585_i0	PRJNA1174234	11781	401	1.945122	7.79993922	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	68.2	2.25e-12	NR	MCB1177358.1	2026757	g11585	i0	49.1	0.42643391521197	57	27	42.6	1	201	371	2	56	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	171	68.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
27103605	27103605	PRJNA1174234_P_NODE_12142_length_395_cov_1.847826_g11946_i0	PRJNA1174234	12142	395	1.847826	7.2989127	Leptospirales bacterium	2604146	Bacteria	Bacteria	42	0.0268	NR	MCL1911952.1	2604146	g11946	i0	61.5	0.19746835443038	26	10	19.7	0	394	317	25	50	MCL1911952.1 hypothetical protein [Leptospirales bacterium]	diamond	78	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales bacterium
27230117	27230117	PRJNA1174234_P_NODE_14923_length_357_cov_1.084507_g14727_i0	PRJNA1174234	14923	357	1.084507	3.87168999	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	57.8	1.72e-8	NR	MCB1177358.1	2026757	g14727	i0	50	0.420168067226891	50	23	42	1	153	4	2	49	MCB1177358.1 hypothetical protein [Leptospiraceae bacterium]	diamond	150	57.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
28366893	28366893	PRJNA1174234_P_NODE_24346_length_279_cov_1.121359_g24150_i0	PRJNA1174234	24346	279	1.121359	3.12859161	Spirochaetales bacterium	2026792	Bacteria	Bacteria	92	1.82e-20	NR	MBN2874962.1	2026792	g24150	i0	50	1.97849462365591	92	46	98.9	0	279	4	104	195	MBN2874962.1 CAP domain-containing protein [Spirochaetales bacterium]	diamond	552	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
28935445	28935445	PRJNA1174234_P_NODE_25448_length_272_cov_1.477387_g25252_i0	PRJNA1174234	25448	272	1.477387	4.01849264	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	43.1	0.0334	NR	MCK9190766.1	2791017	g25252	i0	39.6	1.05882352941176	48	29	52.9	0	147	4	38	85	MCK9190766.1 SIMPL domain-containing protein [Sphaerochaetaceae bacterium]	diamond	288	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
28967094	28967094	PRJNA1174234_P_NODE_3308_length_724_cov_1.075269_g3130_i0	PRJNA1174234	3308	724	1.075269	7.78494756	Spirochaetota bacterium	2202144	Bacteria	Bacteria	222	8.24e-68	NR	MEM7179955.1	2202144	g3130	i0	55.7	4.16022099447514	201	86	82	1	3	596	133	333	MEM7179955.1 SDR family NAD(P)-dependent oxidoreductase [Spirochaetota bacterium]	diamond	3012	222	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29125110	29125110	PRJNA1174234_P_NODE_26089_length_268_cov_1.620513_g25893_i0	PRJNA1174234	26089	268	1.620513	4.34297484	Leptospira wolbachii	29511	Bacteria	Bacteria	49.7	1.71e-4	NR	WP_015680362.1	29511	g25893	i0	45.5	0.985074626865672	44	24	49.3	0	260	129	382	425	WP_015680362.1 ankyrin repeat domain-containing protein [Leptospira wolbachii]	diamond	264	49.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira wolbachii
29914399	29914399	PRJNA1174234_P_NODE_34211_length_243_cov_0.905882_g34015_i0	PRJNA1174234	34211	243	0.905882	2.20129326	Leptospira semungkisensis	2484985	Bacteria	Bacteria	43.1	0.0197	NR	TGK01118.1	2484985	g34015	i0	53.7	0.506172839506173	41	15	50.6	1	189	67	5	41	TGK01118.1 hypothetical protein EHO59_12910 [Leptospira semungkisensis]	diamond	123	43.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira semungkisensis
30072086	30072086	PRJNA1174234_P_NODE_732_length_1274_cov_1.802664_g649_i0	PRJNA1174234	732	1274	1.802664	22.96593936	Treponema sp.	166	Bacteria	Bacteria	67.8	1.07e-8	NR	MEE0352004.1	166	g649	i0	38	0.744113029827316	158	88	37.2	7	730	257	91	238	MEE0352004.1 CAP domain-containing protein [Treponema sp.]	diamond	948	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32884656	32884656	PRJNA1174234_P_NODE_26100_length_268_cov_1.579487_g25904_i0	PRJNA1174234	26100	268	1.579487	4.23302516	Treponemataceae bacterium	2854022	Bacteria	Bacteria	44.3	0.0102	NR	MCQ2593847.1	2854022	g25904	i0	60	1.14179104477612	30	12	33.6	0	91	2	51	80	MCQ2593847.1 HD domain-containing protein [Treponemataceae bacterium]	diamond	306	44.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae 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);;