metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA597223" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA597223" 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
22817816	22817816	PRJNA597223_P_NODE_13018_length_471_cov_2.461009_g11264_i0	PRJNA597223	13018	471	2.461009	11.59135239	Leptospira weilii	28184	Bacteria	Bacteria	266	5.149999999999999e-89	NR	WP_155722658.1	28184	g11264	i0	87.1	4.45859872611465	140	18	89.2	0	48	467	1	140	WP_155722658.1 catalase, partial [Leptospira weilii]	diamond	2100	266	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira weilii
28311652	28311652	PRJNA597223_P_NODE_86366_length_151_cov_3.094828_g84520_i0	PRJNA597223	86366	151	3.094828	4.67319028	Treponema sp.	166	Bacteria	Bacteria	70.1	2.39e-12	NR	MEL3906214.1	166	g84520	i0	70	0.993377483443709	50	13	95.4	1	8	151	275	324	MEL3906214.1 AAA family ATPase [Treponema sp.]	diamond	150	70.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.
28722118	28722118	PRJNA597223_P_NODE_53527_length_190_cov_2.793548_g51681_i0	PRJNA597223	53527	190	2.793548	5.3077412	Treponema socranskii	53419	Bacteria	Bacteria	42.4	0.0236	NR	WP_021330526.1	53419	g51681	i0	87.5	0.378947368421053	24	3	37.9	0	73	2	22	45	WP_021330526.1 hypothetical protein [Treponema socranskii]	diamond	72	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
28753570	28753570	PRJNA597223_P_NODE_84887_length_153_cov_0.923729_g83041_i0	PRJNA597223	84887	153	0.923729	1.41330537	Spirochaetia bacterium	2053615	Bacteria	Bacteria	45.4	2.04e-4	NR	NCB03411.1	2053615	g83041	i0	52.5	0.784313725490196	40	19	78.4	0	123	4	1	40	NCB03411.1 hypothetical protein [Spirochaetia bacterium]	diamond	120	45.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29258522	29258522	PRJNA597223_P_NODE_86089_length_151_cov_4.318966_g84243_i0	PRJNA597223	86089	151	4.318966	6.52163866	Thiospirochaeta perfilievii	252967	Bacteria	Bacteria	58.5	2.35e-8	NR	WP_342781933.1	252967	g84243	i0	52.1	2.78145695364238	71	9	91.4	1	9	146	192	262	WP_342781933.1 IS3 family transposase [Thiospirochaeta perfilievii]	diamond	420	58.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Thiospirochaeta	Thiospirochaeta perfilievii
29732170	29732170	PRJNA597223_P_NODE_54890_length_189_cov_2.350649_g53044_i0	PRJNA597223	54890	189	2.350649	4.44272661	Treponema lecithinolyticum	53418	Bacteria	Bacteria	52.4	7.01e-6	NR	WP_040848258.1	53418	g53044	i0	100	0.380952380952381	24	0	38.1	0	3	74	257	280	WP_040848258.1 hypothetical protein [Treponema lecithinolyticum]	diamond	72	52.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema lecithinolyticum
31438598	31438598	PRJNA597223_P_NODE_64596_length_180_cov_1.531034_g62750_i0	PRJNA597223	64596	180	1.531034	2.7558612	Spirochaetota bacterium	2202144	Bacteria	Bacteria	112	5.1e-28	NR	TXG82032.1	2202144	g62750	i0	93.3	1	60	4	100	0	180	1	130	189	TXG82032.1 MAG: hypothetical protein E6R13_05540 [Spirochaetota bacterium]	diamond	180	112	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31723273	31723273	PRJNA597223_P_NODE_52957_length_191_cov_2.365385_g51111_i0	PRJNA597223	52957	191	2.365385	4.51788535	Treponema socranskii	53419	Bacteria	Bacteria	42.4	0.0255	NR	WP_021329944.1	53419	g51111	i0	87	0.738219895287958	23	3	36.1	0	9	77	106	128	WP_021329944.1 ComEC/Rec2 family competence protein [Treponema socranskii]	diamond	141	42.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii

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