metadata: contig_metadata: 6 rows where bioproject = "PRJNA608894" and tax

6 rows where bioproject = "PRJNA608894" 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
28027754	28027754	PRJNA608894_P_NODE_20565_length_446_cov_3.262735_g20069_i0	PRJNA608894	20565	446	3.262735	14.5517981	Treponema sp.	166	Bacteria	Bacteria	67.8	1.54e-11	NR	MBR1613865.1	166	g20069	i0	47	3.10762331838565	66	35	44.4	0	2	199	39	104	MBR1613865.1 CAP domain-containing protein [Treponema sp.]	diamond	1386	67.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28438269	28438269	PRJNA608894_P_NODE_51546_length_249_cov_2.346591_g51047_i0	PRJNA608894	51546	249	2.346591	5.84301159	Leptospira ainlahdjerensis	2810033	Bacteria	Bacteria	72.8	1.04e-12	NR	WP_205281657.1	2810033	g51047	i0	46.3	0.987951807228916	82	40	98.8	1	3	248	580	657	WP_205281657.1 glycosyltransferase family 4 protein [Leptospira ainlahdjerensis]	diamond	246	72.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira ainlahdjerensis
29764042	29764042	PRJNA608894_P_NODE_32171_length_320_cov_1.372470_g31672_i0	PRJNA608894	32171	320	1.37247	4.391904	Spirochaetota bacterium	2202144	Bacteria	Bacteria	57.8	1.44e-7	NR	HNW27793.1	2202144	g31672	i0	32.4	0.95625	102	66	93.8	2	306	7	5	105	HNW27793.1 GyrI-like domain-containing protein [Spirochaetota bacterium]	diamond	306	57.8	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
30617135	30617135	PRJNA608894_P_NODE_56393_length_244_cov_3.894737_g55894_i0	PRJNA608894	56393	244	3.894737	9.50315828	Spirochaetota bacterium	2202144	Bacteria	Bacteria	94	1.8899999999999998e-20	NR	HPI22730.1	2202144	g55894	i0	63.1	0.799180327868853	65	24	79.9	0	8	202	337	401	HPI22730.1 homocysteine biosynthesis protein [Spirochaetota bacterium]	diamond	195	94	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32084750	32084750	PRJNA608894_P_NODE_45418_length_264_cov_2.015707_g44919_i0	PRJNA608894	45418	264	2.015707	5.32146648	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00669	NR	MBP9024321.1	2202144	g44919	i0	46.7	1.875	45	23	51.1	1	123	257	18	61	MBP9024321.1 hypothetical protein [Spirochaetota bacterium]	diamond	495	45.1	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32514910	32514910	PRJNA608894_P_NODE_6719_length_1103_cov_2.554369_g6341_i0	PRJNA608894	6719	1103	2.554369	28.17469007	Termitinemataceae bacterium	3022875	Bacteria	Bacteria	68.6	4.61e-9	NR	GMO38143.1	3022875	g6341	i0	28.5	0.783318223028105	144	91	38.9	3	1081	653	129	261	GMO38143.1 MAG: hypothetical protein Ta2F_14260 [Termitinemataceae bacterium]	diamond	864	68.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Termitinemataceae		Termitinemataceae 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);;