metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA724039" and tax_phylum = "Thermodesulfobacteriota"

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
2469478	2469478	PRJNA724039_S_NODE_17922_length_151_cov_1.350877_g17715_i0	PRJNA724039	17922	151	1.350877	2.03982427	uncultured Desulfuromonas sp.	181013	Bacteria	Bacteria	80.5	5.26e-16	NR	WP_321530311.1	181013	g17715	i0	71.4	4.66887417218543	49	14	97.4	0	2	148	371	419	WP_321530311.1 response regulator [uncultured Desulfuromonas sp.]	diamond	705	80.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	uncultured Desulfuromonas sp.
27052330	27052330	PRJNA724039_S_NODE_17682_length_152_cov_1.330435_g17475_i0	PRJNA724039	17682	152	1.330435	2.0222612	Thermodesulfobacteriota bacterium	2202153	Bacteria	Bacteria	78.2	2.88e-15	NR	MEW6490368.1	2202153	g17475	i0	73.5	1.91447368421053	49	13	96.7	0	4	150	335	383	MEW6490368.1 phage tail sheath C-terminal domain-containing protein [Thermodesulfobacteriota bacterium]	diamond	291	78.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota					Thermodesulfobacteriota bacterium
30715665	30715665	PRJNA724039_S_NODE_854_length_987_cov_2.287368_g729_i0	PRJNA724039	854	987	2.287368	22.57632216	Desulfuromonas thiophila	57664	Bacteria	Bacteria	336	4.75e-109	NR	WP_282755566.1	57664	g729	i0	91.5	0.571428571428571	188	16	57.1	0	987	424	303	490	WP_282755566.1 serine/threonine-protein kinase [Desulfuromonas thiophila]	diamond	564	336	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas thiophila
31474432	31474432	PRJNA724039_S_NODE_5196_length_307_cov_1.840741_g4989_i0	PRJNA724039	5196	307	1.840741	5.65107487	uncultured Desulfovibrio sp.	167968	Bacteria	Bacteria	110	2.21e-28	NR	WP_298034769.1	167968	g4989	i0	53.5	2.96091205211726	101	45	97.7	2	6	305	34	133	WP_298034769.1 phage major tail tube protein [uncultured Desulfovibrio sp.]	diamond	909	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Desulfovibrio	uncultured Desulfovibrio sp.
31948661	31948661	PRJNA724039_S_NODE_10777_length_197_cov_1.206250_g10570_i0	PRJNA724039	10777	197	1.20625	2.3763125	Desulfobulbus sp. F5	1885339	Bacteria	Bacteria	108	1.79e-28	NR	MCW5206203.1	2821763	g10570	i0	72.6	1.90355329949239	62	17	94.4	0	1	186	64	125	MCW5206203.1 hypothetical protein [Desulfobulbus sp. F5]	diamond	375	108	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfobulbus	Desulfobulbus sp. F5

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