metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA816047" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA816047" 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
25600170	25600170	PRJNA816047b_S_NODE_53809_length_240_cov_26412.227545_g51497_i0	PRJNA816047	53809	240	26412.227545	63389.346108	Pseudomonadati	3379134	Bacteria	Bacteria	83.2	1.82e-16	NR	MDR1618050.1	166	g51497	i0	84.1	1.975	44	7	55	0	3	134	98	141	MDR1618050.1 hypothetical protein [Treponema sp.]	diamond	474	84	0.990476190476191	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
32938436	32938436	PRJNA816047a_S_NODE_63425_length_266_cov_2.378238_g60765_i0	PRJNA816047	63425	266	2.378238	6.32611308	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	172	2.94e-53	NR	WP_187149558.1	1580831	g60765	i0	98.8	0.958646616541353	85	1	95.9	0	258	4	21	105	WP_187149558.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	255	172	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
32956481	32956481	PRJNA816047d_S_NODE_60218_length_291_cov_1.172269_g58383_i0	PRJNA816047	60218	291	1.172269	3.41130279	Treponemataceae bacterium	2854022	Bacteria	Bacteria	133	4.1600000000000003e-36	NR	MCQ2579224.1	2854022	g58383	i0	62.8	0.969072164948454	94	35	96.9	0	8	289	66	159	MCQ2579224.1 glucosamine-6-phosphate deaminase [Treponemataceae bacterium]	diamond	282	133	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae		Treponemataceae bacterium
33006991	33006991	PRJNA816047b_S_NODE_38891_length_273_cov_2.500000_g36579_i0	PRJNA816047	38891	273	2.5	6.825	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	169	7.23e-52	NR	WP_187152238.1	1580831	g36579	i0	92.1	0.978021978021978	89	7	97.8	0	3	269	43	131	WP_187152238.1 alginate export family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	267	169	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
33040879	33040879	PRJNA816047a_S_NODE_56956_length_280_cov_2.608696_g54296_i0	PRJNA816047	56956	280	2.608696	7.3043488	Treponema endosymbiont of Eucomonympha sp.	1580831	Bacteria	Bacteria	141	8.29e-41	NR	WP_228378758.1	1580831	g54296	i0	94.6	0.792857142857143	74	4	79.3	0	227	6	1	74	WP_228378758.1 DoxX family protein, partial [Treponema endosymbiont of Eucomonympha sp.]	diamond	222	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema endosymbiont of Eucomonympha sp.
33041248	33041248	PRJNA816047d_S_NODE_106132_length_247_cov_2.005155_g104297_i0	PRJNA816047	106132	247	2.005155	4.95273285	Treponema sp.	166	Bacteria	Bacteria	53.5	5.01e-6	NR	MCR5766223.1	166	g104297	i0	57.9	0.923076923076923	38	16	46.2	0	247	134	216	253	MCR5766223.1 glucosamine-6-phosphate deaminase [Treponema sp.]	diamond	228	53.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
33044638	33044638	PRJNA816047d_S_NODE_64580_length_283_cov_2.334783_g62745_i0	PRJNA816047	64580	283	2.334783	6.60743589	Bacteria	2	Bacteria	Bacteria	152	2.29e-40	NR	MBS7294969.1	166	g62745	i0	80.5	22.5795053003534	87	17	92.2	0	281	21	488	574	MBS7294969.1 GIY-YIG nuclease family protein [Treponema sp.]	diamond	6390	152	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
33058051	33058051	PRJNA816047a_S_NODE_8805_length_684_cov_5.689034_g6311_i0	PRJNA816047	8805	684	5.689034	38.91299256	Spirochaetia bacterium	2053615	Bacteria	Bacteria	193	9.73e-60	NR	MFO7729640.1	2053615	g6311	i0	95.1	0.451754385964912	103	3	45.2	1	473	165	1	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	309	193	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
33126354	33126354	PRJNA816047b_S_NODE_13687_length_419_cov_8.445087_g11379_i0	PRJNA816047	13687	419	8.445087	35.38491453	Spirochaetia bacterium	2053615	Bacteria	Bacteria	165	4.79e-50	NR	MFO7729640.1	2053615	g11379	i0	97.6	0.608591885441527	85	0	60.9	1	417	163	19	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	255	165	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
33143077	33143077	PRJNA816047a_S_NODE_24807_length_409_cov_5.699405_g22150_i0	PRJNA816047	24807	409	5.699405	23.31056645	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	62.4	3.23e-8	NR	MDR2490364.1	1898206	g22150	i0	47.8	1.01222493887531	69	35	50.6	1	20	226	481	548	MDR2490364.1 ankyrin repeat domain-containing protein [Spirochaetaceae bacterium]	diamond	414	62.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
33143522	33143522	PRJNA816047b_S_NODE_56079_length_229_cov_3.211538_g53767_i0	PRJNA816047	56079	229	3.211538	7.35442202	Spirochaetia bacterium	2053615	Bacteria	Bacteria	67	2.44e-12	NR	MFO7729640.1	2053615	g53767	i0	62.5	0.62882096069869	48	18	62.9	0	227	84	54	101	MFO7729640.1 hypothetical protein [Spirochaetia bacterium]	diamond	144	67	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
33144091	33144091	PRJNA816047d_S_NODE_69007_length_276_cov_1.215247_g67172_i0	PRJNA816047	69007	276	1.215247	3.35408172	Spirochaetales bacterium	2026792	Bacteria	Bacteria	110	1.09e-25	NR	MDD7200396.1	2026792	g67172	i0	72.5	3	69	19	75	0	209	3	55	123	MDD7200396.1 family 43 glycosylhydrolase [Spirochaetales bacterium]	diamond	828	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
33178008	33178008	PRJNA816047d_S_NODE_18456_length_517_cov_3.331897_g16684_i0	PRJNA816047	18456	517	3.331897	17.22590749	Brachyspira pilosicoli	52584	Bacteria	Bacteria	53.9	6.87e-5	NR	WP_335762822.1	52584	g16684	i0	39.1	0.911025145067698	92	54	53.4	1	483	208	449	538	WP_335762822.1 ankyrin repeat domain-containing protein [Brachyspira pilosicoli]	diamond	471	53.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira pilosicoli
33181231	33181231	PRJNA816047d_S_NODE_56936_length_297_cov_1.368852_g55101_i0	PRJNA816047	56936	297	1.368852	4.06549044	root	1	Root_unresolved	Root_unresolved	45.4	0.00787	NR	WP_242004730.1	29522	g55101	i0	37.3	1.13131313131313	51	32	51.5	0	3	155	397	447	WP_242004730.1 Eco57I restriction-modification methylase domain-containing protein [Brachyspira aalborgi]	diamond	336	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira aalborgi

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