metadata: contig_metadata: 18 rows where bioproject = "PRJNA911178" and tax

18 rows where bioproject = "PRJNA911178" 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
1249622	1249622	PRJNA911178_P_NODE_13081_length_926_cov_1.613130_g11236_i0	PRJNA911178	13081	926	1.61313	14.9375838	Turneriella	338321	Bacteria	Bacteria	1456	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g11236	i0	95.146	282.732181425486	927	38	99	7	4	926	5	928	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	261810	1456	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
3801803	3801803	PRJNA911178_P_NODE_168183_length_290_cov_1.345622_g165710_i0	PRJNA911178	168183	290	1.345622	3.9023038	Leptospira	171	Bacteria	Bacteria	512	1.02e-140	NTclustered	gi\|175127\|gb\|M88721.1\|LEPRR16SB	178	g165710	i0	99.291	100.265517241379	282	2	97	0	8	289	39	320	Leptospira sp. (turtle strain A-183) ribosomal RNA	blastn	29077	516	0.992248062015504	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
4720060	4720060	PRJNA911178_P_NODE_13404_length_914_cov_5.319857_g11539_i0	PRJNA911178	13404	914	5.319857	48.62349298	Spirochaetota bacterium	2202144	Bacteria	Bacteria	171	2.44e-37	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g11539	i0	84.27	26.417943107221	178	25	19	3	306	481	74373	74549	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	24146	171	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
7271147	7271147	PRJNA911178_P_NODE_302346_length_231_cov_2.177215_g299872_i0	PRJNA911178	302346	231	2.177215	5.02936665	Treponema sp. canine oral taxon 201	1151514	Bacteria	Bacteria	385	1.79e-102	NTclustered	gi\|373137863\|gb\|JQ298515.1\|	1151514	g299872	i0	96.957	93.3722943722944	230	5	99	2	1	230	228	1	Treponema sp. canine oral taxon 201 clone QB032 16S ribosomal RNA gene, partial sequence	blastn	21569	385	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. canine oral taxon 201
10178844	10178844	PRJNA911178_P_NODE_274308_length_244_cov_2.152047_g271834_i0	PRJNA911178	274308	244	2.152047	5.25099468	Treponema	157	Bacteria	Bacteria	398	2.4499999999999996e-106	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g271834	i0	96.667	192.270491803279	240	6	98	2	1	239	1014731	1014493	Treponema medium strain T19 chromosome, complete genome	blastn	46914	398	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
11454192	11454192	PRJNA911178_P_NODE_307209_length_213_cov_5.607143_g304735_i0	PRJNA911178	307209	213	5.607143	11.94321459	root	1	Root_unresolved	Root_unresolved	385	1.63e-102	NTclustered	gi\|387863582\|gb\|JQ988843.1\|	29510	g304735	i0	100	97.3286384976526	208	0	98	0	2	209	662	455	Turneriella parva strain Parva_DB61 16S ribosomal RNA gene, partial sequence	blastn	20731	385	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
14919941	14919941	PRJNA911178_P_NODE_187572_length_278_cov_7.546341_g185099_i0	PRJNA911178	187572	278	7.546341	20.97882798	Leptospira sp. severe_002	2838237	Bacteria	Bacteria	514	2.7199999999999996e-141	NTclustered	gi\|2120242214\|gb\|CP075692.1\|	2838237	g185099	i0	100	209.136690647482	278	0	100	0	1	278	257147	257424	Leptospira sp. severe_002 chromosome 1	blastn	58140	514	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp. severe_002
15277480	15277480	PRJNA911178_P_NODE_121512_length_333_cov_1.576923_g119040_i0	PRJNA911178	121512	333	1.576923	5.25115359	Brachyspira	29521	Bacteria	Bacteria	544	4.25e-150	NTclustered	gi\|470490176\|ref\|NR_076972.1\|	52584	g119040	i0	96.636	112.45045045045	327	11	98	0	1	327	1087	761	Brachyspira pilosicoli strain B2904 23S ribosomal RNA gene, complete sequence	blastn	37446	544	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
19101091	19101091	PRJNA911178_P_NODE_133395_length_320_cov_1.991903_g130922_i0	PRJNA911178	133395	320	1.991903	6.3740896	Treponema	157	Bacteria	Bacteria	564	3.12e-156	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g130922	i0	98.738	196.359375	317	4	99	0	1	317	1845799	1845483	Treponema medium strain T19 chromosome, complete genome	blastn	62835	569	0.991212653778559	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
19101774	19101774	PRJNA911178_P_NODE_279275_length_243_cov_2.641176_g276801_i0	PRJNA911178	279275	243	2.641176	6.41805768	Treponema	157	Bacteria	Bacteria	287	5.52e-73	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g276801	i0	88.211	131.843621399177	246	21	98	6	1	239	1662919	1663163	Treponema denticola strain OKA3 chromosome, complete genome	blastn	32038	287	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
20019221	20019221	PRJNA911178_P_NODE_260396_length_247_cov_0.890805_g257922_i0	PRJNA911178	260396	247	0.890805	2.20028835	Spirochaetota bacterium	2202144	Bacteria	Bacteria	86.1	2.2e-12	NTclustered	gi\|2621703426\|emb\|OY760686.1\|	2202144	g257922	i0	90.625	4.51417004048583	64	6	26	0	1	64	1157	1220	MAG: Spirochaetota bacterium isolate b615e79e-4617-45ea-95f9-f7a736470f88 genome assembly, chromosome: 1	blastn	1115	86.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
21295424	21295424	PRJNA911178_P_NODE_817_length_2809_cov_31.556652_g562_i1	PRJNA911178	817	2809	31.556652	886.42635468	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	1.68e-28	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g562	i1	81.461	5.57600569597722	178	30	6	3	666	841	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15663	143	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
22570578	22570578	PRJNA911178_P_NODE_798_length_2823_cov_32.713455_g562_i0	PRJNA911178	798	2823	32.713455	923.50083465	Spirochaetota bacterium	2202144	Bacteria	Bacteria	143	1.6899999999999999e-28	NTclustered	gi\|2649718696\|emb\|OZ001226.1\|	2202144	g562	i0	81.461	5.54835281615303	178	30	6	3	666	841	74549	74373	MAG: Spirochaetota bacterium isolate 8b34eeeb-0c33-43c6-8155-d1d64b2f6b4c genome assembly, chromosome: 19	blastn	15663	143	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28540665	28540665	PRJNA911178_P_NODE_308927_length_200_cov_4.338583_g306453_i0	PRJNA911178	308927	200	4.338583	8.677166	Spirochaetales bacterium	2026792	Bacteria	Bacteria	60.1	1.6e-8	NR	MBT89480.1	2026792	g306453	i0	39.5	1.14	76	35	97.5	1	197	3	391	466	MBT89480.1 Na+/glucose cotransporter [Spirochaetales bacterium]	diamond	228	60.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29361375	29361375	PRJNA911178_P_NODE_240909_length_251_cov_0.865169_g238435_i0	PRJNA911178	240909	251	0.865169	2.17157419	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	42.4	0.0458	NR	MCS6972185.1	2026757	g238435	i0	43.2	0.525896414342629	44	25	52.6	0	5	136	172	215	MCS6972185.1 CAP domain-containing protein [Leptospiraceae bacterium]	diamond	132	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
30751226	30751226	PRJNA911178_P_NODE_123594_length_331_cov_1.100775_g121122_i0	PRJNA911178	123594	331	1.100775	3.64356525	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	41.6	0.0387	NR	HMV44967.1	2026757	g121122	i0	40.4	0.471299093655589	52	27	45.3	2	186	37	25	74	HMV44967.1 hypothetical protein [Leptospiraceae bacterium]	diamond	156	41.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31573245	31573245	PRJNA911178_P_NODE_138536_length_315_cov_1.636364_g136063_i0	PRJNA911178	138536	315	1.636364	5.1545466	Leptospira kobayashii	1917830	Bacteria	Bacteria	74.3	6.4e-13	NR	WP_109019421.1	1917830	g136063	i0	50	1.80952380952381	58	29	55.2	0	134	307	33	90	WP_109019421.1 hypothetical protein [Leptospira kobayashii]	diamond	570	74.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira kobayashii
32079143	32079143	PRJNA911178_P_NODE_184678_length_280_cov_1.782609_g182205_i0	PRJNA911178	184678	280	1.782609	4.9913052	Spirochaetales bacterium	2026792	Bacteria	Bacteria	41.6	0.0388	NR	MFP4551403.1	2026792	g182205	i0	37.3	0.717857142857143	67	39	70.7	2	239	42	29	93	MFP4551403.1 TVP38/TMEM64 family protein [Spirochaetales bacterium]	diamond	201	41.6	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);;