metadata: contig_metadata: 23 rows where bioproject = "PRJNA572587", tax_phylum = "Spirochaetota" and tax

23 rows where bioproject = "PRJNA572587", 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
3109595	3109595	PRJNA572587_P_NODE_15143_length_296_cov_3.850202_g14815_i0	PRJNA572587	15143	296	3.850202	11.39659792	Spirochaetales	136	Bacteria	Bacteria	68.6	3.77e-11	NR	MDR2029697.1	166	g14815	i0	57.9	4.62162162162162	57	24	57.8	0	209	39	13	69	MDR2029697.1 transcriptional regulator [Treponema sp.]	diamond	1368	68.9	0.995645863570392	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
3687424	3687424	PRJNA572587_P_NODE_4963_length_570_cov_61.527831_g4649_i0	PRJNA572587	4963	570	61.527831	350.7086367	Treponema	157	Bacteria	Bacteria	556	9.77e-154	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g4649	i0	85.478	188.056140350877	544	68	95	10	24	564	1283793	1284328	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	107192	556	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4964079	4964079	PRJNA572587_P_NODE_30684_length_200_cov_21.132450_g30356_i0	PRJNA572587	30684	200	21.13245	42.2649	Treponema	157	Bacteria	Bacteria	320	4.31e-83	NTclustered	gi\|2277017610\|gb\|CP038804.1\|	221027	g30356	i0	97.838	121.5	185	4	93	0	16	200	2088151	2087967	Treponema putidum strain OMZ 835 chromosome, complete genome	blastn	24300	320	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
6239507	6239507	PRJNA572587_P_NODE_24005_length_229_cov_81.088889_g23677_i0	PRJNA572587	24005	229	81.088889	185.69355581	Treponema	157	Bacteria	Bacteria	292	1.11e-74	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g23677	i0	93.069	189.270742358079	202	11	87	3	21	220	1012726	1012926	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	43343	292	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
6936858	6936858	PRJNA572587_P_NODE_18106_length_267_cov_19.701835_g17778_i0	PRJNA572587	18106	267	19.701835	52.60389945	Treponema medium	58231	Bacteria	Bacteria	416	7.519999999999998e-112	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g17778	i0	97.531	177.228464419476	243	6	91	0	3	245	1014394	1014152	Treponema medium strain T19 chromosome, complete genome	blastn	47320	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
9487166	9487166	PRJNA572587_P_NODE_19688_length_255_cov_135.966019_g19360_i0	PRJNA572587	19688	255	135.966019	346.71334845	Treponema medium	58231	Bacteria	Bacteria	237	5.96e-58	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g19360	i0	85.776	80.9803921568627	232	23	89	8	5	232	1012926	1012701	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	20650	237	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
12037954	12037954	PRJNA572587_P_NODE_26450_length_217_cov_20.672619_g26122_i0	PRJNA572587	26450	217	20.672619	44.85958323	Treponema medium	58231	Bacteria	Bacteria	206	1.3899999999999998e-48	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g26122	i0	90.385	3.32258064516129	156	15	72	0	24	179	2636970	2636815	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	721	206	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
14587596	14587596	PRJNA572587_P_NODE_20712_length_248_cov_20.894472_g20384_i0	PRJNA572587	20712	248	20.894472	51.81829056	Treponema vincentii	69710	Bacteria	Bacteria	363	9.119999999999997e-96	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g20384	i0	96.38	12.3548387096774	221	7	89	1	6	226	792517	792298	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	3064	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
15861846	15861846	PRJNA572587_P_NODE_7053_length_461_cov_15.031553_g6729_i0	PRJNA572587	7053	461	15.031553	69.29545933	Treponema denticola	158	Bacteria	Bacteria	667	0	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g6729	i0	95.673	15.9132321041215	416	17	90	1	23	437	1148700	1148285	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	7336	667	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
16438571	16438571	PRJNA572587_P_NODE_18933_length_261_cov_20.150943_g18605_i0	PRJNA572587	18933	261	20.150943	52.59396123	Treponema	157	Bacteria	Bacteria	285	2.16e-72	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g18605	i0	88.793	129.210727969349	232	26	89	0	1	232	543	312	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	33724	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
18987292	18987292	PRJNA572587_P_NODE_23235_length_234_cov_3.145946_g22907_i0	PRJNA572587	23235	234	3.145946	7.36151364	Treponema	157	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g22907	i0	80.319	155.021367521368	188	34	79	3	2	187	219	33	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	36275	139	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
24785424	24785424	PRJNA572587_P_NODE_9140_length_397_cov_1.347701_g8813_i0	PRJNA572587	9140	397	1.347701	5.35037297	Treponema denticola	158	Bacteria	Bacteria	671	0	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g8813	i0	98.936	4.02770780856423	376	3	95	1	22	397	631249	630875	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	1599	671	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25362354	25362354	PRJNA572587_P_NODE_34120_length_189_cov_9.135714_g33792_i0	PRJNA572587	34120	189	9.135714	17.26649946	Treponema	157	Bacteria	Bacteria	281	1.9e-71	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g33792	i0	97.006	111.089947089947	167	5	88	0	1	167	2223047	2223213	Treponema denticola strain OKA3 chromosome, complete genome	blastn	20996	281	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
26730938	26730938	PRJNA572587_P_NODE_35681_length_184_cov_14.488889_g35353_i0	PRJNA572587	35681	184	14.488889	26.65955576	Spirochaetia bacterium	2053615	Bacteria	Bacteria	74.3	1.15e-13	NR	MDA3939218.1	2053615	g35353	i0	75.6	2.18478260869565	45	11	73.4	0	9	143	410	454	MDA3939218.1 sodium:proton antiporter [Spirochaetia bacterium]	diamond	402	74.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
26826504	26826504	PRJNA572587_P_NODE_34341_length_188_cov_23.812950_g34013_i0	PRJNA572587	34341	188	23.81295	44.768346	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	43.9	0.00319	NR	MCK9600682.1	1972642	g34013	i0	59.4	0.51063829787234	32	13	51.1	0	84	179	1	32	MCK9600682.1 DUF3168 domain-containing protein [Sphaerochaeta sp.]	diamond	96	43.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
27648338	27648338	PRJNA572587_P_NODE_13664_length_313_cov_15.060606_g13336_i0	PRJNA572587	13664	313	15.060606	47.13969678	Spirochaetota bacterium	2202144	Bacteria	Bacteria	91.3	7.93e-22	NR	HPJ34846.1	2202144	g13336	i0	90.9	1.26517571884984	44	4	42.2	0	152	21	1	44	HPJ34846.1 cold shock domain-containing protein [Spirochaetota bacterium]	diamond	396	91.3	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27963887	27963887	PRJNA572587_P_NODE_5905_length_511_cov_40.880952_g5584_i0	PRJNA572587	5905	511	40.880952	208.90166472	Spirochaetota bacterium	2202144	Bacteria	Bacteria	126	4.309999999999999e-31	NR	HPJ42336.1	2202144	g5584	i0	84.8	0.463796477495108	79	12	46.4	0	225	461	83	161	HPJ42336.1 HEAT repeat domain-containing protein [Spirochaetota bacterium]	diamond	237	126	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28090133	28090133	PRJNA572587_P_NODE_20685_length_248_cov_35.643216_g20357_i0	PRJNA572587	20685	248	35.643216	88.39517568	Spirochaetota bacterium	2202144	Bacteria	Bacteria	130	1.02e-35	NR	HOP30983.1	2202144	g20357	i0	83.8	0.82258064516129	68	11	82.3	0	23	226	135	202	HOP30983.1 hypothetical protein [Spirochaetota bacterium]	diamond	204	130	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28184687	28184687	PRJNA572587_P_NODE_4246_length_624_cov_56.483478_g3948_i0	PRJNA572587	4246	624	56.483478	352.45690272	Treponema vincentii	69710	Bacteria	Bacteria	187	1.24e-50	NR	WP_162662065.1	69710	g3948	i0	65.8	0.745192307692308	155	53	74.5	0	12	476	579	733	WP_162662065.1 toxin TcdB middle/N-terminal domain-containing protein [Treponema vincentii]	diamond	465	187	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
28690340	28690340	PRJNA572587_P_NODE_15267_length_294_cov_52.922449_g14939_i0	PRJNA572587	15267	294	52.922449	155.59200006	Treponema primitia	88058	Bacteria	Bacteria	46.2	0.0043	NR	WP_015709302.1	88058	g14939	i0	32.5	0.785714285714286	77	52	78.6	0	258	28	646	722	WP_015709302.1 AAA family ATPase [Treponema primitia]	diamond	231	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema primitia
29069173	29069173	PRJNA572587_P_NODE_32728_length_193_cov_36.284722_g32400_i0	PRJNA572587	32728	193	36.284722	70.02951346	Spirochaetota bacterium	2202144	Bacteria	Bacteria	94.7	1.39e-22	NR	HOP30361.1	2202144	g32400	i0	82.7	0.808290155440414	52	9	80.8	0	160	5	28	79	HOP30361.1 hypothetical protein [Spirochaetota bacterium]	diamond	156	94.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29100660	29100660	PRJNA572587_P_NODE_5888_length_512_cov_40.207343_g5567_i0	PRJNA572587	5888	512	40.207343	205.86159616	Spirochaetota bacterium	2202144	Bacteria	Bacteria	122	2.08e-29	NR	HPR36013.1	2202144	g5567	i0	67.9	0.4921875	84	27	49.2	0	280	29	1	84	HPR36013.1 FapA family protein [Spirochaetota bacterium]	diamond	252	122	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32891962	32891962	PRJNA572587_P_NODE_13880_length_310_cov_39.371648_g13552_i0	PRJNA572587	13880	310	39.371648	122.0521088	Spirochaetota bacterium	2202144	Bacteria	Bacteria	89	4.73e-18	NR	HOP29902.1	2202144	g13552	i0	80.9	0.454838709677419	47	9	45.5	0	33	173	719	765	HOP29902.1 transglycosylase SLT domain-containing protein [Spirochaetota bacterium]	diamond	141	89	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);;