metadata: contig_metadata: 8 rows where bioproject = "PRJNA1073712" and tax

8 rows where bioproject = "PRJNA1073712" 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
10390821	10390821	PRJNA1073712_P_NODE_11389_length_251_cov_0.865169_g11306_i0	PRJNA1073712	11389	251	0.865169	2.17157419	Treponema vincentii	69710	Bacteria	Bacteria	320	5.65e-83	NTclustered	gi\|2265113193\|gb\|CP051148.1\|	69710	g11306	i0	89.641	1	251	26	100	0	1	251	2231226	2231476	Treponema vincentii strain OMZ 861 chromosome, complete genome	blastn	251	320	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
26655642	26655642	PRJNA1073712_P_NODE_10001_length_262_cov_1.275132_g9918_i0	PRJNA1073712	10001	262	1.275132	3.34084584	Treponema maltophilum	51160	Bacteria	Bacteria	166	7.76e-51	NR	WP_051127868.1	51160	g9918	i0	94.3	0.99618320610687	87	5	99.6	0	2	262	2	88	WP_051127868.1 tetratricopeptide repeat protein [Treponema maltophilum]	diamond	261	166	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema maltophilum
26814330	26814330	PRJNA1073712_P_NODE_11521_length_251_cov_0.865169_g11438_i0	PRJNA1073712	11521	251	0.865169	2.17157419	Treponema phagedenis	162	Bacteria	Bacteria	68.9	1.85e-11	NR	WP_148879498.1	162	g11438	i0	52.4	1.51792828685259	63	29	74.1	1	66	251	2	64	WP_148879498.1 hypothetical protein [Treponema phagedenis]	diamond	381	68.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema phagedenis
27762629	27762629	PRJNA1073712_P_NODE_17004_length_241_cov_0.916667_g16921_i0	PRJNA1073712	17004	241	0.916667	2.20916747	Treponema sp.	166	Bacteria	Bacteria	119	5.8099999999999994e-30	NR	MBQ1970912.1	166	g16921	i0	79.8	6.12448132780083	84	11	98.3	2	239	3	15	97	MBQ1970912.1 extracellular solute-binding protein [Treponema sp.]	diamond	1476	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28172744	28172744	PRJNA1073712_P_NODE_7666_length_286_cov_1.352113_g7583_i0	PRJNA1073712	7666	286	1.352113	3.86704318	Treponema sp.	166	Bacteria	Bacteria	168	6.38e-48	NR	MCR5400845.1	166	g7583	i0	77.9	0.996503496503496	95	21	99.7	0	1	285	334	428	MCR5400845.1 threonine synthase [Treponema sp.]	diamond	285	168	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30161951	30161951	PRJNA1073712_P_NODE_12472_length_249_cov_0.875000_g12389_i0	PRJNA1073712	12472	249	0.875	2.17875	Treponema sp. Marseille-Q39	166	Bacteria	Bacteria	81.3	1.07e-15	NR	WP_255422478.1	2766703	g12389	i0	97.4	0.939759036144578	39	1	47	0	248	132	537	575	WP_255422478.1 InlB B-repeat-containing protein [Treponema sp. Marseille-Q3903]	diamond	234	81.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. Marseille-Q3903
31458007	31458007	PRJNA1073712_P_NODE_13456_length_247_cov_0.885057_g13373_i0	PRJNA1073712	13456	247	0.885057	2.18609079	Treponema sp.	166	Bacteria	Bacteria	158	3.78e-44	NR	MEL3905559.1	166	g13373	i0	92.6	0.983805668016194	81	6	98.4	0	245	3	205	285	MEL3905559.1 terminase family protein [Treponema sp.]	diamond	243	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32177153	32177153	PRJNA1073712_P_NODE_6678_length_300_cov_1.806167_g6595_i0	PRJNA1073712	6678	300	1.806167	5.418501	Bacteria	2	Bacteria	Bacteria	47.4	0.00179	NR	UKI52827.1	166	g6595	i0	36.2	4.91	69	40	68	3	216	13	508	573	UKI52827.1 MAG: CotH kinase family protein [Treponema sp.]	diamond	1473	47.8	0.99163179916318	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);;