metadata: contig_metadata: 7 rows where bioproject = "PRJNA980587" and tax

7 rows where bioproject = "PRJNA980587" 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
25496111	25496111	PRJNA980587_P_NODE_88960_length_245_cov_0.889535_g88167_i0	PRJNA980587	88960	245	0.889535	2.17936075	Treponema	157	Bacteria	Bacteria	171	5.85e-38	NTclustered	gi\|2265141765\|gb\|CP051199.1\|	2563664	g88167	i0	79.424	5.06938775510204	243	48	99	2	2	243	1591012	1591253	Treponema sp. OMZ 788 chromosome, complete genome	blastn	1242	171	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 788
28200704	28200704	PRJNA980587_P_NODE_64126_length_283_cov_1.461905_g63333_i0	PRJNA980587	64126	283	1.461905	4.13719115	Bacteria	2	Bacteria	Bacteria	58.9	9.82e-8	NR	OJF76583.1	1908540	g63333	i0	35.6	1.92932862190813	90	58	95.4	0	2	271	173	262	OJF76583.1 MAG: 5'-nucleotidase [Treponema sp. CETP13]	diamond	546	58.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. CETP13
28321064	28321064	PRJNA980587_P_NODE_95346_length_241_cov_0.916667_g94553_i0	PRJNA980587	95346	241	0.916667	2.20916747	Spirochaetota bacterium	2202144	Bacteria	Bacteria	84	8.95e-17	NR	MBN2161005.1	2202144	g94553	i0	50.7	0.933609958506224	75	37	93.4	0	240	16	323	397	MBN2161005.1 ATP-binding protein [Spirochaetota bacterium]	diamond	225	84	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
28390341	28390341	PRJNA980587_P_NODE_82746_length_248_cov_1.760000_g81953_i0	PRJNA980587	82746	248	1.76	4.3648	Leptospira	171	Bacteria	Bacteria	81.6	7.95e-16	NR	HMW05084.1	2026757	g81953	i0	50.6	4.99596774193548	83	40	99.2	1	2	247	580	662	HMW05084.1 putative Ig domain-containing protein [Leptospiraceae bacterium]	diamond	1239	82.4	0.990291262135922	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
29678475	29678475	PRJNA980587_P_NODE_91730_length_243_cov_0.905882_g90937_i0	PRJNA980587	91730	243	0.905882	2.20129326	Spirochaetaceae bacterium	1898206	Bacteria	Bacteria	43.9	0.0123	NR	TVR03740.1	1898206	g90937	i0	41.3	0.925925925925926	75	34	81.5	3	33	230	17	90	TVR03740.1 MAG: TVP38/TMEM64 family protein [Spirochaetaceae bacterium]	diamond	225	43.9	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Spirochaetaceae		Spirochaetaceae bacterium
30468810	30468810	PRJNA980587_P_NODE_81273_length_249_cov_1.642045_g80480_i0	PRJNA980587	81273	249	1.642045	4.08869205	Spirochaetota bacterium	2202144	Bacteria	Bacteria	74.7	1.85e-13	NR	NBF38870.1	2202144	g80480	i0	54.2	3.02409638554217	83	30	97.6	3	2	244	235	311	NBF38870.1 phosphoglycerate kinase [Spirochaetota bacterium]	diamond	753	74.7	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31290009	31290009	PRJNA980587_P_NODE_68895_length_272_cov_1.472362_g68102_i0	PRJNA980587	68895	272	1.472362	4.00482464	Leptospirales bacterium	2604146	Bacteria	Bacteria	56.6	5.55e-7	NR	MBX7059927.1	2604146	g68102	i0	36.9	1.64338235294118	84	53	92.6	0	271	20	200	283	MBX7059927.1 ankyrin repeat domain-containing protein [Leptospirales bacterium]	diamond	447	56.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales			Leptospirales 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);;