metadata: contig_metadata: 8 rows where bioproject = "PRJNA1034994", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA1034994", 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
3558175	3558175	PRJNA1034994_P_NODE_4583_length_273_cov_2.305000_g4499_i0	PRJNA1034994	4583	273	2.305	6.29265	Treponema	157	Bacteria	Bacteria	499	7.45e-137	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g4499	i0	99.634	182.139194139194	273	1	100	0	1	273	2078249	2077977	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	49724	499	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
4835602	4835602	PRJNA1034994_P_NODE_3324_length_289_cov_1.314815_g3240_i0	PRJNA1034994	3324	289	1.314815	3.79981535	Treponema	157	Bacteria	Bacteria	490	4.78e-134	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g3240	i0	97.232	193.494809688581	289	8	100	0	1	289	1679582	1679294	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	55920	490	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
18020122	18020122	PRJNA1034994_P_NODE_7175_length_249_cov_2.431818_g7091_i0	PRJNA1034994	7175	249	2.431818	6.05522682	Treponema bryantii	163	Bacteria	Bacteria	353	5.52e-93	NTclustered	gi\|2581915939\|dbj\|AP025286.1\|	163	g7091	i0	92.4	150.273092369478	250	16	100	3	1	249	704162	703915	Treponema bryantii JCM 32280 DNA, complete genome	blastn	37418	353	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema bryantii
19294029	19294029	PRJNA1034994_P_NODE_1236_length_462_cov_1.974293_g1152_i0	PRJNA1034994	1236	462	1.974293	9.12123366	Treponema parvum	138851	Bacteria	Bacteria	484	3.73e-132	NTclustered	gi\|2023447176\|gb\|CP054142.1\|	138851	g1152	i0	86.682	194.705627705628	443	51	95	8	25	462	452995	452556	Treponema parvum strain ATCC 700770 chromosome, complete genome	blastn	89954	484	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema parvum
23120413	23120413	PRJNA1034994_P_NODE_1639_length_396_cov_1.851393_g1555_i0	PRJNA1034994	1639	396	1.851393	7.33151628	Treponema sp.	166	Bacteria	Bacteria	508	1.87e-139	NTclustered	gi\|2189480979\|gb\|CP091737.1\|	166	g1555	i0	89.924	205.335858585859	397	37	100	3	1	396	1474479	1474873	MAG: Treponema sp. isolate nC27_bin.160.fa chromosome	blastn	81313	508	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
29940544	29940544	PRJNA1034994_P_NODE_9931_length_242_cov_0.911243_g9847_i0	PRJNA1034994	9931	242	0.911243	2.20520806	Treponemataceae bacterium	2854022	Bacteria	Bacteria	76.3	1.03e-14	NR	HOT63295.1	2854022	g9847	i0	79.5	0.545454545454545	44	9	54.5	0	242	111	183	226	HOT63295.1 50S ribosomal protein L1 [Treponemataceae bacterium]	diamond	132	76.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
31203732	31203732	PRJNA1034994_P_NODE_8335_length_246_cov_1.323699_g8251_i0	PRJNA1034994	8335	246	1.323699	3.25629954	Candidatus Treponema faecavium	2838769	Bacteria	Bacteria	113	6.67e-28	NR	HIW35625.1	2838769	g8251	i0	70.4	2.96341463414634	81	22	98.8	1	245	3	66	144	HIW35625.1 polyprenyl synthetase family protein [Candidatus Treponema faecavium]	diamond	729	113	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Candidatus Treponema faecavium
32311699	32311699	PRJNA1034994_P_NODE_7999_length_247_cov_0.885057_g7915_i0	PRJNA1034994	7999	247	0.885057	2.18609079	Treponema lecithinolyticum	53418	Bacteria	Bacteria	80.5	1.76e-15	NR	WP_385987346.1	53418	g7915	i0	100	0.425101214574899	35	0	42.5	0	107	3	1	35	WP_385987346.1 electron transport complex subunit RsxC [Treponema lecithinolyticum]	diamond	105	80.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema lecithinolyticum

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