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

8 rows where bioproject = "PRJNA438572" 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
13844610	13844610	PRJNA438572_P_NODE_3851_length_502_cov_2.361305_g3733_i0	PRJNA438572	3851	502	2.361305	11.8537511	Spirochaeta	146	Bacteria	Bacteria	580	5.0599999999999986e-161	NTclustered	gi\|507148391\|ref\|NR_103194.1\|	46355	g3733	i0	87.5	204.609561752988	504	61	100	2	1	502	1219	716	Spirochaeta africana strain Z-7692 23S ribosomal RNA gene, complete sequence	blastn	102714	580	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta africana
18286827	18286827	PRJNA438572_P_NODE_7195_length_376_cov_2.290429_g7076_i0	PRJNA438572	7195	376	2.290429	8.61201304	Salinispira pacifica	1307761	Bacteria	Bacteria	333	1.14e-86	NTclustered	gi\|565679415\|gb\|CP006939.1\|	1307761	g7076	i0	84.393	101.281914893617	346	47	92	3	1	346	385292	385630	Salinispira pacifica strain L21-RPul-D2, complete genome	blastn	38082	333	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Salinispira	Salinispira pacifica
22111661	22111661	PRJNA438572_P_NODE_21058_length_247_cov_0.896552_g20939_i0	PRJNA438572	21058	247	0.896552	2.21448344	Treponema vincentii	69710	Bacteria	Bacteria	257	4.41e-64	NTclustered	gi\|2034589463\|gb\|CP050497.1\|	69710	g20939	i0	85.425	7	247	36	100	0	1	247	2581868	2582114	Treponema vincentii strain OMZ 806 chromosome, complete genome	blastn	1729	257	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
27092307	27092307	PRJNA438572_P_NODE_12822_length_289_cov_0.879630_g12703_i0	PRJNA438572	12822	289	0.87963	2.5421307	Bacteria	2	Bacteria	Bacteria	79.7	9.770000000000001e-16	NR	MDD7201844.1	2026792	g12703	i0	43	1.94117647058824	93	53	96.5	0	1	279	39	131	MDD7201844.1 SIMPL domain-containing protein [Spirochaetales bacterium]	diamond	561	79.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
27234067	27234067	PRJNA438572_P_NODE_9763_length_327_cov_1.838583_g9644_i0	PRJNA438572	9763	327	1.838583	6.01216641	Rectinemataceae bacterium	3064674	Bacteria	Bacteria	46.2	0.00508	NR	MDP2816068.1	3064674	g9644	i0	37.6	0.853211009174312	93	46	81.7	3	5	271	10	94	MDP2816068.1 hypothetical protein [Rectinemataceae bacterium]	diamond	279	46.2	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Rectinemataceae		Rectinemataceae bacterium
28402442	28402442	PRJNA438572_P_NODE_2966_length_570_cov_1.096579_g2848_i0	PRJNA438572	2966	570	1.096579	6.2505003	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	45.8	0.0468	NR	MBK5201917.1	1898206	g2848	i0	49.1	0.278947368421053	53	22	27.9	1	432	274	148	195	MBK5201917.1 L-lactate dehydrogenase [Spirochaetaceae bacterium]	diamond	159	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29696582	29696582	PRJNA438572_P_NODE_20650_length_247_cov_1.810345_g20531_i0	PRJNA438572	20650	247	1.810345	4.47155215	Treponema sp.	166	Bacteria	Bacteria	45.8	0.00182	NR	MBD5443786.1	166	g20531	i0	54.8	1.23886639676113	31	14	37.7	0	121	29	121	151	MBD5443786.1 CAP domain-containing protein [Treponema sp.]	diamond	306	45.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
31972575	31972575	PRJNA438572_P_NODE_8978_length_340_cov_1.745318_g8859_i0	PRJNA438572	8978	340	1.745318	5.9340812	Leptospiraceae bacterium	2026757	Bacteria	Bacteria	74.3	6.14e-14	NR	HNO24933.1	2026757	g8859	i0	97.5	0.352941176470588	40	1	35.3	0	340	221	108	147	HNO24933.1 Hsp70 family protein [Leptospiraceae bacterium]	diamond	120	74.3	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae 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);;