metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
3095163	3095163	PRJNA560029_S_NODE_36163_length_236_cov_2.361963_g35939_i0	PRJNA560029	36163	236	2.361963	5.57423268	root	1	Root_unresolved	Root_unresolved	99.8	2.1899999999999998e-25	NR	MBP5251327.1	166	g35939	i0	81.8	2.83474576271186	55	9	69.9	1	2	166	29	82	MBP5251327.1 class II fructose-bisphosphate aldolase [Treponema sp.]	diamond	669	99.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
27300250	27300250	PRJNA560029_S_NODE_9563_length_371_cov_3.070470_g9339_i0	PRJNA560029	9563	371	3.07047	11.3914437	Spirochaetia bacterium	2053615	Bacteria	Bacteria	154	5.079999999999999e-43	NR	HTH14612.1	2053615	g9339	i0	73.8	3.33153638814016	103	27	83.3	0	2	310	81	183	HTH14612.1 beta-ketoacyl-ACP synthase III [Spirochaetia bacterium]	diamond	1236	154	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27900059	27900059	PRJNA560029_S_NODE_6805_length_403_cov_2.021212_g6581_i0	PRJNA560029	6805	403	2.021212	8.14548436	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	54.7	1.37e-5	NR	MFP4179618.1	1898206	g6581	i0	49.2	0.439205955334988	59	28	43.9	1	381	205	480	536	MFP4179618.1 tryptophanase [Spirochaetaceae bacterium]	diamond	177	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
27995037	27995037	PRJNA560029_S_NODE_2105_length_583_cov_3.413725_g1887_i0	PRJNA560029	2105	583	3.413725	19.90201675	Brachyspira alvinipulli	84379	Bacteria	Bacteria	177	1.7e-52	NR	WP_051436841.1	84379	g1887	i0	50.3	0.93138936535163	181	85	93.1	1	579	37	24	199	WP_051436841.1 PH domain-containing protein [Brachyspira alvinipulli]	diamond	543	177	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira alvinipulli
28040615	28040615	PRJNA560029_S_NODE_37665_length_211_cov_4.413043_g37441_i0	PRJNA560029	37665	211	4.413043	9.31152073	Bacteria	2	Bacteria	Bacteria	43.1	0.00538	NR	HBG65297.1	166	g37441	i0	59.3	2.33175355450237	27	11	38.4	0	2	82	83	109	HBG65297.1 hypothetical protein [Treponema sp.]	diamond	492	43.5	0.990804597701149	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28153029	28153029	PRJNA560029_S_NODE_9825_length_368_cov_8.335593_g9601_i0	PRJNA560029	9825	368	8.335593	30.67498224	Spirochaeta lutea	1480694	Bacteria	Bacteria	82.4	4.96e-17	NR	WP_052078626.1	1480694	g9601	i0	44.8	0.709239130434783	87	48	70.9	0	366	106	71	157	WP_052078626.1 Dps family protein [Spirochaeta lutea]	diamond	261	82.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta lutea
29366723	29366723	PRJNA560029_S_NODE_35809_length_239_cov_2.572289_g35585_i0	PRJNA560029	35809	239	2.572289	6.14777071	Bacteria	2	Bacteria	Bacteria	95.5	5.069999999999999e-23	NR	WP_147735636.1	29522	g35585	i0	55.3	2.84937238493724	76	34	95.4	0	239	12	13	88	WP_147735636.1 PTS sugar transporter subunit IIA [Brachyspira aalborgi]	diamond	681	95.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira aalborgi
29777001	29777001	PRJNA560029_S_NODE_19051_length_307_cov_4.435897_g18827_i0	PRJNA560029	19051	307	4.435897	13.61820379	Bacteria	2	Bacteria	Bacteria	91.3	4.5e-20	NR	MEE1165608.1	166	g18827	i0	45.5	7.7785016286645	99	53	96.7	1	2	298	110	207	MEE1165608.1 response regulator transcription factor [Treponema sp.]	diamond	2388	91.7	0.995637949836423	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
30615987	30615987	PRJNA560029_S_NODE_14673_length_333_cov_1.350000_g14449_i0	PRJNA560029	14673	333	1.35	4.4955	Spirochaetales bacterium	2026792	Bacteria	Bacteria	54.7	6.19e-6	NR	MCK4541614.1	2026792	g14449	i0	45.6	1.10810810810811	57	29	49.5	1	304	140	324	380	MCK4541614.1 iron-containing alcohol dehydrogenase [Spirochaetales bacterium]	diamond	369	54.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
31564601	31564601	PRJNA560029_S_NODE_27796_length_267_cov_4.391753_g27572_i0	PRJNA560029	27796	267	4.391753	11.72598051	Treponema sp. CETP13	1908540	Bacteria	Bacteria	158	2.37e-45	NR	OJF76429.1	1908540	g27572	i0	90.9	2.96629213483146	88	8	98.9	0	267	4	230	317	OJF76429.1 MAG: cell filamentation protein Fic [Treponema sp. CETP13]	diamond	792	158	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. CETP13

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