metadata: contig_metadata: 22 rows where bioproject = "PRJNA1118794" and tax

22 rows where bioproject = "PRJNA1118794" 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
230429	230429	PRJNA1118794_P_NODE_19921_length_339_cov_1.496241_g19171_i0	PRJNA1118794	19921	339	1.496241	5.07225699	Spirochaeta aurantia	147	Bacteria	Bacteria	455	2.0900000000000003e-123	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g19171	i0	90.936	191.964601769911	342	26	100	5	1	339	3258	3597	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	65076	455	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
1505448	1505448	PRJNA1118794_P_NODE_38022_length_273_cov_1.370000_g37272_i0	PRJNA1118794	38022	273	1.37	3.7401	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	184	1.5199999999999995e-55	NR	MBL8032855.1	2026757	g37272	i0	97.8	1	91	2	100	0	1	273	89	179	MBL8032855.1 alpha-ketoacid dehydrogenase subunit beta [Leptospiraceae bacterium]	diamond	273	184	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
4057204	4057204	PRJNA1118794_P_NODE_16084_length_366_cov_2.614334_g15334_i0	PRJNA1118794	16084	366	2.614334	9.56846244	Spirochaeta aurantia	147	Bacteria	Bacteria	496	1.34e-135	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g15334	i0	91.257	224.967213114754	366	28	100	3	1	366	3124	3485	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	82338	496	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
6608530	6608530	PRJNA1118794_P_NODE_22306_length_326_cov_1.217391_g21556_i0	PRJNA1118794	22306	326	1.217391	3.96869466	Brachyspira intermedia	84377	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|343385146\|gb\|CP002874.1\|	1045858	g21556	i0	100	0.0889570552147239	29	0	9	0	77	105	1081224	1081196	Brachyspira intermedia PWS/A, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira intermedia
9158126	9158126	PRJNA1118794_P_NODE_12668_length_403_cov_2.012121_g11918_i0	PRJNA1118794	12668	403	2.012121	8.10884763	Sphaerochaetaceae bacterium	2791017	Bacteria	Bacteria	124	8.07e-24	NTclustered	gi\|2621785465\|emb\|OY781923.1\|	2791017	g11918	i0	91.304	82.7841191066997	92	6	23	2	223	313	114021	114111	MAG: Sphaerochaetaceae bacterium isolate 77f26d43-b2b0-4d0d-8c29-067165085957 genome assembly, chromosome: 1	blastn	33362	124	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae		Sphaerochaetaceae bacterium
9158396	9158396	PRJNA1118794_P_NODE_33188_length_284_cov_1.426540_g32438_i0	PRJNA1118794	33188	284	1.42654	4.0513736	Brachyspira pilosicoli	52584	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|404429427\|emb\|HE793032.1\|	1161918	g32438	i0	100	0.102112676056338	29	0	10	0	185	213	1162397	1162369	Brachyspira pilosicoli WesB complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
14259580	14259580	PRJNA1118794_P_NODE_30252_length_291_cov_2.825688_g29502_i0	PRJNA1118794	30252	291	2.825688	8.22275208	Spirochaeta aurantia	147	Bacteria	Bacteria	488	1.7299999999999995e-133	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g29502	i0	96.907	155.824742268041	291	9	100	0	1	291	4875	4585	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	45345	488	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
15052624	15052624	PRJNA1118794_P_NODE_50432_length_250_cov_1.903955_g49682_i0	PRJNA1118794	50432	250	1.903955	4.7598875	Treponema	157	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g49682	i0	98.4	185.584	250	4	100	0	1	250	2079204	2078955	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	46396	440	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
18876553	18876553	PRJNA1118794_P_NODE_13835_length_388_cov_2.260317_g13085_i0	PRJNA1118794	13835	388	2.260317	8.77002996	Turneriella	338321	Bacteria	Bacteria	634	2.8899999999999995e-177	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g13085	i0	96.134	675.113402061856	388	15	100	0	1	388	1533	1920	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	261944	634	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21426856	21426856	PRJNA1118794_P_NODE_10477_length_437_cov_1.250000_g9729_i0	PRJNA1118794	10477	437	1.25	5.4625	Turneriella	338321	Bacteria	Bacteria	763	0	NTclustered	gi\|470489162\|ref\|NR_076910.1\|	29510	g9729	i0	98.169	172.903890160183	437	8	100	0	1	437	642	206	Turneriella parva strain DSM 21527 23S ribosomal RNA gene, complete sequence	blastn	75559	763	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
21907567	21907567	PRJNA1118794_P_NODE_35558_length_278_cov_2.634146_g34808_i0	PRJNA1118794	35558	278	2.634146	7.32292588	Spirochaeta aurantia	147	Bacteria	Bacteria	387	6.179999999999998e-103	NTclustered	gi\|47779237\|gb\|AY599019.1\|	555314	g34808	i0	91.844	445.352517985611	282	15	99	8	1	277	2590	2312	Spirochaeta aurantia strain M1 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	123808	387	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta aurantia
27321022	27321022	PRJNA1118794_P_NODE_69823_length_242_cov_1.414201_g69073_i0	PRJNA1118794	69823	242	1.414201	3.42236642	Spirochaetales bacterium	2026792	Bacteria	Bacteria	160	2.88e-44	NR	MBN1616260.1	2026792	g69073	i0	98.8	0.991735537190083	80	1	99.2	0	2	241	26	105	MBN1616260.1 phenylalanine--tRNA ligase subunit beta [Spirochaetales bacterium]	diamond	240	160	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27343803	27343803	PRJNA1118794_P_NODE_51023_length_250_cov_0.870056_g50273_i0	PRJNA1118794	51023	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	4.69e-6	NR	WP_288959214.1	162155	g50273	i0	70.6	1.656	34	10	40.8	0	2	103	358	391	WP_288959214.1 caspase family protein [uncultured Treponema sp.]	diamond	414	53.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	uncultured Treponema sp.
27731757	27731757	PRJNA1118794_P_NODE_65804_length_244_cov_0.900585_g65054_i0	PRJNA1118794	65804	244	0.900585	2.1974274	Spirochaetota bacterium	2202144	Bacteria	Bacteria	52.8	8.64e-6	NR	NLV67628.1	2202144	g65054	i0	43.5	1.5	46	26	56.6	0	180	43	65	110	NLV67628.1 M15 family metallopeptidase [Spirochaetota bacterium]	diamond	366	52.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28457813	28457813	PRJNA1118794_P_NODE_67706_length_243_cov_0.905882_g66956_i0	PRJNA1118794	67706	243	0.905882	2.20129326	Treponema maltophilum	51160	Bacteria	Bacteria	138	7.93e-39	NR	WP_016526296.1	51160	g66956	i0	94	0.827160493827161	67	4	82.7	0	243	43	157	223	WP_016526296.1 hypothetical protein [Treponema maltophilum]	diamond	201	138	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
29057676	29057676	PRJNA1118794_P_NODE_53728_length_249_cov_0.875000_g52978_i0	PRJNA1118794	53728	249	0.875	2.17875	Treponema denticola	158	Bacteria	Bacteria	68.9	2.36e-11	NR	WP_002669708.1	158	g52978	i0	61.1	1.91566265060241	54	21	65.1	0	81	242	1	54	WP_002669708.1 preprotein translocase subunit SecA [Treponema denticola]	diamond	477	68.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
29175071	29175071	PRJNA1118794_P_NODE_55369_length_248_cov_1.320000_g54619_i0	PRJNA1118794	55369	248	1.32	3.2736	root	1	Root_unresolved	Root_unresolved	125	2.4999999999999998e-31	NR	WP_002703092.1	157	g54619	i0	72.8	215.129032258065	81	22	98	0	5	247	342	422	WP_002703092.1 MULTISPECIES: molecular chaperone DnaK [Treponema]	diamond	53352	126	0.992063492063492	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema
29499506	29499506	PRJNA1118794_P_NODE_31350_length_289_cov_0.879630_g30600_i0	PRJNA1118794	31350	289	0.87963	2.5421307	Turneriella sp.	2717305	Bacteria	Bacteria	187	2.39e-56	NR	MFO1470840.1	2717305	g30600	i0	97.9	0.996539792387543	96	2	99.7	0	2	289	6	101	MFO1470840.1 lipase secretion chaperone [Turneriella sp.]	diamond	288	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella sp.
30415959	30415959	PRJNA1118794_P_NODE_48693_length_251_cov_0.865169_g47943_i0	PRJNA1118794	48693	251	0.865169	2.17157419	Spirochaetota bacterium	2202144	Bacteria	Bacteria	181	4.289999999999999e-55	NR	TXG86145.1	2202144	g47943	i0	100	0.99203187250996006	83	0	99.2	0	3	251	54	136	TXG86145.1 MAG: hypothetical protein E6R13_00920 [Spirochaetota bacterium]	diamond	249	181	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31449654	31449654	PRJNA1118794_P_NODE_42856_length_262_cov_2.301587_g42106_i0	PRJNA1118794	42856	262	2.301587	6.03015794	Treponema	157	Bacteria	Bacteria	69.7	5.37e-12	NR	MBQ9205232.1	166	g42106	i0	49.3	5.50763358778626	67	34	76.7	0	259	59	179	245	MBQ9205232.1 CAP domain-containing protein [Treponema sp.]	diamond	1443	69.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32691660	32691660	PRJNA1118794_P_NODE_42760_length_263_cov_1.131579_g42010_i0	PRJNA1118794	42760	263	1.131579	2.97605277	Spirochaetota bacterium	2202144	Bacteria	Bacteria	87	9.18e-18	NR	MBP7585203.1	2202144	g42010	i0	54	0.992395437262357	87	32	99.2	1	1	261	307	385	MBP7585203.1 ATP-binding protein [Spirochaetota bacterium]	diamond	261	87	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32723335	32723335	PRJNA1118794_P_NODE_9040_length_469_cov_1.383838_g8292_i0	PRJNA1118794	9040	469	1.383838	6.49020022	Spirochaetota bacterium	2202144	Bacteria	Bacteria	45.4	0.0252	NR	MBN1531716.1	2202144	g8292	i0	45.1	0.326226012793177	51	24	32.6	2	3	155	58	104	MBN1531716.1 hypothetical protein [Spirochaetota bacterium]	diamond	153	45.4	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);;