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

5 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Basidiomycota"

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_class	tax_order	tax_family	tax_genus	tax_species
28037379	28037379	PRJNA998413_S_NODE_7305_length_245_cov_1.686813_g7274_i0	PRJNA998413	7305	245	1.686813	4.13269185	Armillaria solidipes	1076256	Fungi	Fungi	122	4.769999999999999e-31	NR	PBK65859.1	1076256	g7274	i0	100	1.9469387755102	53	0	64.9	0	1	159	332	384	PBK65859.1 hypothetical protein ARMSODRAFT_1006344 [Armillaria solidipes]	diamond	477	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria solidipes
28194946	28194946	PRJNA998413_S_NODE_10506_length_219_cov_1.288462_g10475_i0	PRJNA998413	10506	219	1.288462	2.82173178	Pilatotrama ljubarskyi	2735509	Fungi	Fungi	43.1	0.0063	NR	KAI0369038.1	2735509	g10475	i0	36.1	0.986301369863014	72	44	98.6	1	4	219	40	109	KAI0369038.1 hypothetical protein BV20DRAFT_423959 [Pilatotrama ljubarskyi]	diamond	216	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Pilatotrama	Pilatotrama ljubarskyi
28668879	28668879	PRJNA998413_S_NODE_12347_length_212_cov_0.899329_g12316_i0	PRJNA998413	12347	212	0.899329	1.90657748	Mycena sp. CBHHK59/15	1940295	Fungi	Fungi	43.5	0.0125	NR	KAJ6618920.1	1940295	g12316	i0	34.5	0.820754716981132	58	27	66.5	2	43	183	48	105	KAJ6618920.1 hypothetical protein B0H10DRAFT_1794488 [Mycena sp. CBHHK59/15]	diamond	174	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena sp. CBHHK59/15
30759154	30759154	PRJNA998413_S_NODE_12614_length_211_cov_1.148649_g12583_i0	PRJNA998413	12614	211	1.148649	2.42364939	Agaricomycetes	155619	Fungi	Fungi	73.9	2.25e-13	NR	KAJ8473137.1	34470	g12583	i0	100	4.83412322274881	34	0	48.3	0	1	102	380	413	KAJ8473137.1 hypothetical protein ONZ45_g16407 [Pleurotus djamor]	diamond	1020	73.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus djamor
31480514	31480514	PRJNA998413_S_NODE_10336_length_220_cov_1.280255_g10305_i0	PRJNA998413	10336	220	1.280255	2.816561	Infundibulicybe gibba	378275	Fungi	Fungi	122	2.86e-33	NR	KAF8888245.1	378275	g10305	i0	74	2.97272727272727	73	19	99.5	0	1	219	109	181	KAF8888245.1 CAP domain-containing protein [Infundibulicybe gibba]	diamond	654	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales		Infundibulicybe	Infundibulicybe gibba

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