metadata: contig_metadata: 12 rows where bioproject = "PRJNA986481", tax_phylum = "Spirochaetota" and tax

12 rows where bioproject = "PRJNA986481", tax_phylum = "Spirochaetota" and tax_superkingdom = "Bacteria"

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
2248755	2248755	PRJNA986481_P_NODE_33362_length_283_cov_1.457265_g32837_i0	PRJNA986481	33362	283	1.457265	4.12405995	Treponema putidum	221027	Bacteria	Bacteria	78.7	4.31e-10	NTclustered	gi\|2277017610\|gb\|CP038804.1\|	221027	g32837	i0	92.727	12.4028268551237	55	3	19	1	148	201	805661	805607	Treponema putidum strain OMZ 835 chromosome, complete genome	blastn	3510	78.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
10200835	10200835	PRJNA986481_P_NODE_8388_length_562_cov_3.791423_g7879_i0	PRJNA986481	8388	562	3.791423	21.30779726	Pseudomonadati	3379134	Bacteria	Bacteria	101	3.13e-21	NR	MCL2190931.1	166	g7879	i0	40	1.50533807829181	135	79	72.1	1	8	412	468	600	MCL2190931.1 molecular chaperone DnaK [Treponema sp.]	diamond	846	102	0.990196078431373	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
22651077	22651077	PRJNA986481_P_NODE_63258_length_206_cov_2.165605_g62733_i0	PRJNA986481	63258	206	2.165605	4.4611463	Treponema saccharophilum	165	Bacteria	Bacteria	93.5	1.06e-14	NTclustered	gi\|2581918939\|dbj\|AP025288.1\|	165	g62733	i0	89.189	7.68446601941748	74	8	56	0	125	198	373822	373749	Treponema saccharophilum JCM 32279 DNA, complete genome	blastn	1583	93.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema saccharophilum
26804811	26804811	PRJNA986481_P_NODE_46401_length_256_cov_0.975845_g45876_i0	PRJNA986481	46401	256	0.975845	2.4981632	Spirochaetota bacterium	2202144	Bacteria	Bacteria	43.1	0.031	NR	MCI7536061.1	2202144	g45876	i0	33.3	0.87890625	75	50	87.9	0	252	28	282	356	MCI7536061.1 multidrug effflux MFS transporter [Spirochaetota bacterium]	diamond	225	43.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29363350	29363350	PRJNA986481_P_NODE_33309_length_283_cov_1.752137_g32784_i0	PRJNA986481	33309	283	1.752137	4.95854771	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	105	1.16e-26	NR	MBK8399036.1	2026757	g32784	i0	59.3	0.964664310954064	91	37	96.5	0	5	277	62	152	MBK8399036.1 N-acetyltransferase [Leptospiraceae bacterium]	diamond	273	105	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29811099	29811099	PRJNA986481_P_NODE_52971_length_249_cov_1.010000_g52446_i0	PRJNA986481	52971	249	1.01	2.5149	Pseudomonadati	3379134	Bacteria	Bacteria	133	3.3499999999999993e-34	NR	WP_021957761.1	29522	g52446	i0	74.4	41.2289156626506	82	21	98.8	0	247	2	96	177	WP_021957761.1 phosphoenolpyruvate carboxykinase (GTP) [Brachyspira aalborgi]	diamond	10266	134	0.992537313432836	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira aalborgi
30221855	30221855	PRJNA986481_P_NODE_43392_length_260_cov_0.957346_g42867_i0	PRJNA986481	43392	260	0.957346	2.4890996	Spirochaeta	146	Bacteria	Bacteria	145	2.78e-38	NR	MCA1753670.1	28185	g42867	i0	76.5	2.94230769230769	85	20	98.1	0	258	4	275	359	MCA1753670.1 NAD-glutamate dehydrogenase [Spirochaeta sp.]	diamond	765	145	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta sp.
30468985	30468985	PRJNA986481_P_NODE_35013_length_276_cov_1.696035_g34488_i0	PRJNA986481	35013	276	1.696035	4.6810566	Treponema sp.	166	Bacteria	Bacteria	53.5	8.86e-6	NR	MDA8425904.1	166	g34488	i0	51	0.554347826086957	51	25	55.4	0	274	122	869	919	MDA8425904.1 ankyrin repeat domain-containing protein [Treponema sp.]	diamond	153	53.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30506352	30506352	PRJNA986481_P_NODE_9413_length_532_cov_2.322981_g8894_i0	PRJNA986481	9413	532	2.322981	12.35825892	Bacteria	2	Bacteria	Bacteria	173	4.899999999999999e-47	NR	MBS7260511.1	166	g8894	i0	46.6	60.0958646616541	174	93	98.1	0	2	523	153	326	MBS7260511.1 glutamine synthetase III [Treponema sp.]	diamond	31971	174	0.994252873563218	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31069278	31069278	PRJNA986481_P_NODE_45595_length_257_cov_0.971154_g45070_i0	PRJNA986481	45595	257	0.971154	2.49586578	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	53.1	9.1e-6	NR	MCB1164785.1	2026757	g45070	i0	52.9	1.19066147859922	51	24	59.5	0	257	105	332	382	MCB1164785.1 2-dehydropantoate 2-reductase [Leptospiraceae bacterium]	diamond	306	53.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31353622	31353622	PRJNA986481_P_NODE_4516_length_737_cov_3.244186_g4099_i0	PRJNA986481	4516	737	3.244186	23.90965082	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	58.9	5.68e-6	NR	HMV43514.1	2026757	g4099	i0	41.8	0.32157394843962	79	37	28.5	2	601	392	399	477	HMV43514.1 protein kinase [Leptospiraceae bacterium]	diamond	237	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31353623	31353623	PRJNA986481_P_NODE_47276_length_255_cov_1.101942_g46751_i0	PRJNA986481	47276	255	1.101942	2.8099521	Treponema sp.	166	Bacteria	Bacteria	43.5	0.022	NR	MCL2722238.1	166	g46751	i0	34.8	1.18823529411765	66	42	76.5	1	205	11	3	68	MCL2722238.1 MBL fold metallo-hydrolase [Treponema sp.]	diamond	303	43.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.

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