metadata: contig_metadata: 11 rows where bioproject = "PRJNA785164", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA785164", tax_kingdom = "Pseudomonadati" 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
4594532	4594532	PRJNA785164_P_NODE_42624_length_276_cov_1.399015_g42159_i0	PRJNA785164	42624	276	1.399015	3.8612814	Bacteria	2	Bacteria	Bacteria	95.5	3.26e-21	NR	WP_014454505.1	46355	g42159	i0	53.8	26.945652173913	78	36	84.8	0	273	40	233	310	WP_014454505.1 type I-F CRISPR-associated endonuclease Cas1f [Spirochaeta africana]	diamond	7437	96.3	0.991692627206646	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae	Spirochaeta	Spirochaeta africana
5869964	5869964	PRJNA785164_P_NODE_51265_length_251_cov_0.865169_g50800_i0	PRJNA785164	51265	251	0.865169	2.17157419	Leptospira mgodei	3235172	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g50800	i0	98.805	1	251	3	100	0	1	251	2600082	2600332	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	251	448	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
7145018	7145018	PRJNA785164_P_NODE_54606_length_248_cov_0.880000_g54141_i0	PRJNA785164	54606	248	0.88	2.1824	Leptospira mgodei	3235172	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g54141	i0	99.597	1	248	1	100	0	1	248	3507865	3507618	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	248	453	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
12246292	12246292	PRJNA785164_P_NODE_58450_length_244_cov_0.900585_g57985_i0	PRJNA785164	58450	244	0.900585	2.1974274	Leptospira mgodei	3235172	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g57985	i0	100	6.83606557377049	244	0	100	0	1	244	479236	479479	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	1668	451	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
14794712	14794712	PRJNA785164_P_NODE_36372_length_300_cov_1.017621_g35907_i0	PRJNA785164	36372	300	1.017621	3.052863	Leptospira mgodei	3235172	Bacteria	Bacteria	488	1.7899999999999996e-133	NTclustered	gi\|2777195838\|gb\|CP162139.1\|	3235172	g35907	i0	96	1.09333333333333	300	12	100	0	1	300	1411621	1411322	Leptospira mgodei strain WS4.C2 chromosome 1, complete sequence	blastn	328	488	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira mgodei
18617801	18617801	PRJNA785164_P_NODE_40855_length_282_cov_1.473684_g40390_i0	PRJNA785164	40855	282	1.473684	4.15578888	Leptospira inadai	29506	Bacteria	Bacteria	159	5.24e-43	NR	WP_010409524.1	29506	g40390	i0	83.9	2.97872340425532	93	15	98.9	0	1	279	205	297	WP_010409524.1 PAS domain S-box protein [Leptospira inadai]	diamond	840	159	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira inadai
26832189	26832189	PRJNA785164_P_NODE_42501_length_276_cov_2.206897_g42036_i0	PRJNA785164	42501	276	2.206897	6.09103572	Leptospira	171	Bacteria	Bacteria	162	9.47e-50	NR	WP_015678929.1	171	g42036	i0	91.2	0.989130434782609	91	8	98.9	0	274	2	22	112	WP_015678929.1 MULTISPECIES: type II toxin-antitoxin system HicB family antitoxin [Leptospira]	diamond	273	162	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira
27433142	27433142	PRJNA785164_P_NODE_40743_length_282_cov_2.315789_g40278_i0	PRJNA785164	40743	282	2.315789	6.53052498	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	72.4	1.24e-13	NR	MDA3808945.1	1898206	g40278	i0	41.6	1.78723404255319	77	43	80.9	2	256	29	29	104	MDA3808945.1 single-stranded DNA-binding protein [Spirochaetaceae bacterium]	diamond	504	72.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
29737542	29737542	PRJNA785164_P_NODE_42370_length_277_cov_1.215686_g41905_i0	PRJNA785164	42370	277	1.215686	3.36745022	Spirochaetia bacterium	2053615	Bacteria	Bacteria	107	4.2e-27	NR	NBU98840.1	2053615	g41905	i0	64.7	0.92057761732852	85	29	92.1	1	257	3	90	173	NBU98840.1 hypothetical protein [Spirochaetia bacterium]	diamond	255	107	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
30906949	30906949	PRJNA785164_P_NODE_22054_length_402_cov_1.796353_g21589_i0	PRJNA785164	22054	402	1.796353	7.22133906	Spirochaetota bacterium	2202144	Bacteria	Bacteria	61.6	3.49e-8	NR	TXG80644.1	2202144	g21589	i0	55.1	0.365671641791045	49	22	36.6	0	24	170	44	92	TXG80644.1 MAG: hypothetical protein E6R13_07740 [Spirochaetota bacterium]	diamond	147	61.6	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32866271	32866271	PRJNA785164_P_NODE_52720_length_250_cov_0.870056_g52255_i0	PRJNA785164	52720	250	0.870056	2.17514	Treponema sp.	166	Bacteria	Bacteria	64.7	5.37e-10	NR	MCL1927952.1	166	g52255	i0	53.4	3.156	58	26	68.4	1	174	4	194	251	MCL1927952.1 IS481 family transposase [Treponema sp.]	diamond	789	64.7	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.

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