metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
8418336	8418336	PRJNA784298_P_NODE_11307_length_372_cov_2.765886_g11106_i0	PRJNA784298	11307	372	2.765886	10.28909592	Pleomorphochaeta sp.	1920505	Bacteria	Bacteria	92	6.78e-20	NR	MDC7243806.1	1920505	g11106	i0	55.8	3.10483870967742	77	34	62.1	0	231	1	2	78	MDC7243806.1 Fe-S cluster assembly ATPase SufC [Pleomorphochaeta sp.]	diamond	1155	92	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Pleomorphochaeta	Pleomorphochaeta sp.
9693667	9693667	PRJNA784298_P_NODE_18788_length_285_cov_2.127358_g18587_i0	PRJNA784298	18788	285	2.127358	6.0629703	Spirochaetota bacterium	2202144	Bacteria	Bacteria	161	1.27e-44	NR	MDY6933431.1	2202144	g18587	i0	76.6	1.97894736842105	94	22	98.9	0	284	3	84	177	MDY6933431.1 site-specific DNA-methyltransferase [Spirochaetota bacterium]	diamond	564	161	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27315982	27315982	PRJNA784298_P_NODE_19863_length_277_cov_1.887255_g19662_i0	PRJNA784298	19863	277	1.887255	5.22769635	Pseudomonadati	3379134	Bacteria	Bacteria	57.8	1.77e-7	NR	WP_021958633.1	29522	g19662	i0	75.8	3.99638989169675	33	8	35.7	0	273	175	209	241	WP_021958633.1 Bax inhibitor-1/YccA family membrane protein [Brachyspira aalborgi]	diamond	1107	58.2	0.993127147766323	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira aalborgi
28010722	28010722	PRJNA784298_P_NODE_18785_length_285_cov_2.169811_g18584_i0	PRJNA784298	18785	285	2.169811	6.18396135	Pseudomonadati	3379134	Bacteria	Bacteria	112	2.75e-26	NR	HOJ50042.1	2202144	g18584	i0	55.3	8.89473684210526	94	42	98.9	0	4	285	391	484	HOJ50042.1 elongation factor G [Spirochaetota bacterium]	diamond	2535	112	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28831309	28831309	PRJNA784298_P_NODE_18948_length_284_cov_1.554502_g18747_i0	PRJNA784298	18948	284	1.554502	4.41478568	Pseudomonadati	3379134	Bacteria	Bacteria	94	6.09e-20	NR	WP_002770917.1	183	g18747	i0	48.9	4.75352112676056	94	48	99.3	0	282	1	537	630	WP_002770917.1 ATP-binding protein [Leptonema illini]	diamond	1350	94	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptonema	Leptonema illini
29769255	29769255	PRJNA784298_P_NODE_3871_length_647_cov_3.132404_g3674_i0	PRJNA784298	3871	647	3.132404	20.26665388	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	227	1.13e-72	NR	MCB1176084.1	2026757	g3674	i0	68.8	0.714064914992272	154	48	71.4	0	26	487	1	154	MCB1176084.1 hypothetical protein [Leptospiraceae bacterium]	diamond	462	227	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29927439	29927439	PRJNA784298_P_NODE_2511_length_804_cov_3.314637_g2328_i0	PRJNA784298	2511	804	3.314637	26.64968148	Sphaerochaeta sp.	1972642	Bacteria	Bacteria	85.9	5.03e-15	NR	MFA5699261.1	1972642	g2328	i0	30.5	0.794776119402985	213	132	79.1	8	638	3	5	202	MFA5699261.1 hypothetical protein [Sphaerochaeta sp.]	diamond	639	85.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Sphaerochaetaceae	Sphaerochaeta	Sphaerochaeta sp.
31199931	31199931	PRJNA784298_P_NODE_14095_length_332_cov_2.351351_g13894_i0	PRJNA784298	14095	332	2.351351	7.80648532	Pseudomonadati	3379134	Bacteria	Bacteria	163	3.0699999999999997e-48	NR	MCB1176082.1	2026757	g13894	i0	70.6	1.96987951807229	109	32	98.5	0	332	6	73	181	MCB1176082.1 hypothetical protein [Leptospiraceae bacterium]	diamond	654	164	0.99390243902439	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31602399	31602399	PRJNA784298_P_NODE_12856_length_348_cov_1.680000_g12655_i0	PRJNA784298	12856	348	1.68	5.8464	Leptospira	171	Bacteria	Bacteria	78.6	6.96e-16	NR	WP_026131249.1	171	g12655	i0	41.4	0.75	87	51	75	0	348	88	40	126	WP_026131249.1 MULTISPECIES: DUF6258 family protein [Leptospira]	diamond	261	78.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira

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