metadata: contig_metadata: 10 rows where bioproject = "PRJNA1132896" and tax

10 rows where bioproject = "PRJNA1132896" 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
11235108	11235108	PRJNA1132896_P_NODE_1809_length_399_cov_1.855828_g1718_i0	PRJNA1132896	1809	399	1.855828	7.40475372	Gracilinema	2951106	Bacteria	Bacteria	721	0	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g1718	i0	99.248	190.593984962406	399	3	100	0	1	399	1064	666	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	76047	721	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
21433650	21433650	PRJNA1132896_P_NODE_2077_length_376_cov_1.016502_g1986_i0	PRJNA1132896	2077	376	1.016502	3.82204752	Gracilinema	2951106	Bacteria	Bacteria	606	6.089999999999998e-169	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g1986	i0	95.756	193.412234042553	377	15	100	1	1	376	638	262	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	72723	606	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
25258102	25258102	PRJNA1132896_P_NODE_9340_length_244_cov_0.894737_g9249_i0	PRJNA1132896	9340	244	0.894737	2.18315828	Gracilinema	2951106	Bacteria	Bacteria	313	9.139999999999999e-81	NTclustered	gi\|470488994\|ref\|NR_076899.1\|	215591	g9249	i0	90.083	57.3606557377049	242	23	99	1	1	241	360	119	Treponema caldarium strain H1 23S ribosomal RNA, complete sequence	blastn	13996	313	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Breznakiellaceae	Gracilinema	Gracilinema caldarium
27038689	27038689	PRJNA1132896_P_NODE_10322_length_241_cov_0.916667_g10231_i0	PRJNA1132896	10322	241	0.916667	2.20916747	Spirochaetia bacterium	2053615	Bacteria	Bacteria	57.8	7.98e-8	NR	HKJ86546.1	2053615	g10231	i0	44.6	0.697095435684647	56	31	69.7	0	10	177	39	94	HKJ86546.1 hypothetical protein [Spirochaetia bacterium]	diamond	168	57.8	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
27765506	27765506	PRJNA1132896_P_NODE_8604_length_246_cov_0.890173_g8513_i0	PRJNA1132896	8604	246	0.890173	2.18982558	Spirochaetia bacterium	2053615	Bacteria	Bacteria	110	2.3e-29	NR	HKJ86548.1	2053615	g8513	i0	71.3	2.92682926829268	80	23	97.6	0	6	245	27	106	HKJ86548.1 hypothetical protein [Spirochaetia bacterium]	diamond	720	110	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29407078	29407078	PRJNA1132896_P_NODE_8049_length_247_cov_1.706897_g7958_i0	PRJNA1132896	8049	247	1.706897	4.21603559	Spirochaetia bacterium	2053615	Bacteria	Bacteria	119	5.63e-30	NR	MDX9958178.1	2053615	g7958	i0	68.3	0.995951417004049	82	26	99.6	0	246	1	88	169	MDX9958178.1 LacI family DNA-binding transcriptional regulator [Spirochaetia bacterium]	diamond	246	119	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
29469990	29469990	PRJNA1132896_P_NODE_3710_length_295_cov_3.671171_g3619_i0	PRJNA1132896	3710	295	3.671171	10.82995445	Spirochaetales bacterium	2026792	Bacteria	Bacteria	89.4	2.86e-18	NR	MCD6123447.1	2026792	g3619	i0	83.3	0.488135593220339	48	8	48.8	0	151	294	474	521	MCD6123447.1 hypothetical protein [Spirochaetales bacterium]	diamond	144	89.4	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales			Spirochaetales bacterium
29553923	29553923	PRJNA1132896_P_NODE_2710_length_337_cov_0.878788_g2619_i0	PRJNA1132896	2710	337	0.878788	2.96151556	root	1	Root_unresolved	Root_unresolved	106	3.65e-27	NR	HKJ86548.1	2053615	g2619	i0	86.9	1.08605341246291	61	8	54.3	0	184	2	1	61	HKJ86548.1 hypothetical protein [Spirochaetia bacterium]	diamond	366	106	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
31271075	31271075	PRJNA1132896_P_NODE_4375_length_284_cov_0.834123_g4284_i0	PRJNA1132896	4375	284	0.834123	2.36890932	Spirochaetia bacterium	2053615	Bacteria	Bacteria	124	1.65e-33	NR	HKJ86546.1	2053615	g4284	i0	64.2	1.00352112676056	95	33	99.3	1	283	2	45	139	HKJ86546.1 hypothetical protein [Spirochaetia bacterium]	diamond	285	124	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia bacterium
32030301	32030301	PRJNA1132896_P_NODE_6378_length_255_cov_1.967033_g6287_i0	PRJNA1132896	6378	255	1.967033	5.01593415	Spirochaetia bacterium	2053615	Bacteria	Bacteria	48.5	3.08e-4	NR	HKJ86547.1	2053615	g6287	i0	38.6	0.823529411764706	70	40	80	2	15	218	170	238	HKJ86547.1 helix-turn-helix transcriptional regulator [Spirochaetia bacterium]	diamond	210	48.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia				Spirochaetia 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);;