metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA494251" and tax_phylum = "Fidelibacterota"

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_clade	tax_kingdom	tax_phylum	tax_species
26792157	26792157	PRJNA494251_P_NODE_16761_length_341_cov_1.723881_g16448_i0	PRJNA494251	16761	341	1.723881	5.87843421	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	85.9	2.9e-17	NR	MEE8478661.1	2026760	g16448	i0	43.8	1.94428152492669	112	51	91.5	3	312	1	10	117	MEE8478661.1 UV DNA damage repair endonuclease UvsE [Fidelibacterota bacterium]	diamond	663	85.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
26982021	26982021	PRJNA494251_P_NODE_342_length_1668_cov_5.596238_g270_i0	PRJNA494251	342	1668	5.596238	93.34524984	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	431	6.639999999999998e-143	NR	MCJ7802186.1	2026760	g270	i0	47.8	0.830935251798561	462	216	79.9	9	49	1380	25	479	MCJ7802186.1 S10 family peptidase [Fidelibacterota bacterium]	diamond	1386	431	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27266587	27266587	PRJNA494251_P_NODE_28823_length_276_cov_1.517241_g28509_i0	PRJNA494251	28823	276	1.517241	4.18758516	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	72.4	1.34e-13	NR	MDP6339978.1	2026760	g28509	i0	43.8	0.793478260869565	73	40	79.3	1	58	276	10	81	MDP6339978.1 peroxiredoxin [Fidelibacterota bacterium]	diamond	219	72.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29413646	29413646	PRJNA494251_P_NODE_35469_length_254_cov_3.292818_g35155_i0	PRJNA494251	35469	254	3.292818	8.36375772	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	119	1.28e-30	NR	MBC8344958.1	2026760	g35155	i0	75.3	6.89763779527559	73	18	86.2	0	221	3	2	74	MBC8344958.1 pyridoxal-phosphate dependent enzyme [Fidelibacterota bacterium]	diamond	1752	119	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30361724	30361724	PRJNA494251_P_NODE_20732_length_313_cov_1.520833_g20418_i0	PRJNA494251	20732	313	1.520833	4.76020729	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	64.3	7.9e-11	NR	MAJ45178.1	2026760	g20418	i0	44.6	1.86900958466454	65	34	62.3	1	117	311	4	66	MAJ45178.1 hypothetical protein [Fidelibacterota bacterium]	diamond	585	64.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32036830	32036830	PRJNA494251_P_NODE_4638_length_589_cov_2.635659_g4344_i0	PRJNA494251	4638	589	2.635659	15.52403151	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	180	1.11e-51	NR	MDK2976985.1	2026760	g4344	i0	53.1	5.87266553480475	196	79	96.3	7	581	15	175	364	MDK2976985.1 aminomethyltransferase [Fidelibacterota bacterium]	diamond	3459	180	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota 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);;