metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA415856" 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
28180761	28180761	PRJNA415856_P_NODE_36526_length_167_cov_0.864407_g36265_i0	PRJNA415856	36526	167	0.864407	1.44355969	Treponema sp. J25	2094121	Bacteria	Bacteria	66.2	5.3e-11	NR	WP_132781733.1	2094121	g36265	i0	88.2	0.610778443113772	34	4	61.1	0	103	2	1	34	WP_132781733.1 GDP-L-fucose synthase family protein [Treponema sp. J25]	diamond	102	66.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. J25
28387024	28387024	PRJNA415856_P_NODE_47766_length_163_cov_0.894737_g47505_i0	PRJNA415856	47766	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	65.5	1.02e-10	NR	MDR1318682.1	166	g47505	i0	60.4	1.96932515337423	53	21	97.5	0	160	2	240	292	MDR1318682.1 ABC transporter permease [Treponema sp.]	diamond	321	65.9	0.993930197268589	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28623182	28623182	PRJNA415856_P_NODE_26047_length_181_cov_1.810606_g25786_i0	PRJNA415856	26047	181	1.810606	3.27719686	Treponema sp.	166	Bacteria	Bacteria	69.3	2.72e-12	NR	MDD7451654.1	166	g25786	i0	57.7	0.861878453038674	52	21	84.5	1	2	154	180	231	MDD7451654.1 hypothetical protein [Treponema sp.]	diamond	156	69.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28812159	28812159	PRJNA415856_P_NODE_27248_length_179_cov_1.461538_g26987_i0	PRJNA415856	27248	179	1.461538	2.61615302	Treponema denticola	158	Bacteria	Bacteria	120	1.9799999999999996e-31	NR	WP_002669777.1	158	g26987	i0	94.9	0.988826815642458	59	3	98.9	0	1	177	223	281	WP_002669777.1 ABC transporter permease [Treponema denticola]	diamond	177	120	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
30423488	30423488	PRJNA415856_P_NODE_42193_length_165_cov_0.879310_g41932_i0	PRJNA415856	42193	165	0.87931	1.4508615	Treponema sp. OMZ 838	1539298	Bacteria	Bacteria	42	0.0148	NR	WP_044016175.1	1539298	g41932	i0	54.3	2.41818181818182	35	16	63.6	0	1	105	118	152	WP_044016175.1 hypothetical protein [Treponema sp. OMZ 838]	diamond	399	42	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 838
31261326	31261326	PRJNA415856_P_NODE_30275_length_174_cov_1.400000_g30014_i0	PRJNA415856	30275	174	1.4	2.436	Spirochaetales	136	Bacteria	Bacteria	112	4.17e-28	NR	WP_132781559.1	2094121	g30014	i0	94.7	1.96551724137931	57	3	98.3	0	172	2	28	84	WP_132781559.1 aspartate-semialdehyde dehydrogenase [Treponema sp. J25]	diamond	342	112	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. J25
31466239	31466239	PRJNA415856_P_NODE_46436_length_163_cov_0.894737_g46175_i0	PRJNA415856	46436	163	0.894737	1.45842131	Treponema sp. OMZ 9	166	Bacteria	Bacteria	61.2	3.53e-9	NR	WP_253824014.1	2563662	g46175	i0	64.8	0.993865030674847	54	19	99.4	0	163	2	286	339	WP_253824014.1 hypothetical protein [Treponema sp. OMZ 906]	diamond	162	61.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 906
31908891	31908891	PRJNA415856_P_NODE_38117_length_166_cov_0.871795_g37856_i0	PRJNA415856	38117	166	0.871795	1.4471797	Spirochaetota bacterium	2202144	Bacteria	Bacteria	41.2	0.0453	NR	MBN2547256.1	2202144	g37856	i0	42.9	1.73493975903614	49	24	88.6	1	18	164	147	191	MBN2547256.1 hypothetical protein [Spirochaetota bacterium]	diamond	288	41.2	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);;