metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA641991" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA641991" 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
1158400	1158400	PRJNA641991_S_NODE_8081_length_196_cov_2.428571_g7962_i0	PRJNA641991	8081	196	2.428571	4.75999916	Opisthokonta	33154	Fungi	Fungi	123	3.26e-32	NR	TFK49141.1	5364	g7962	i0	87.7	8.8469387755102	65	8	99.5	0	1	195	171	235	TFK49141.1 fructose 1,6-bisphosphate aldolase [Heliocybe sulcata]	diamond	1734	123	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Gloeophyllales	Gloeophyllaceae	Heliocybe	Heliocybe sulcata
13371821	13371821	PRJNA641991_S_NODE_6411_length_217_cov_0.904762_g6292_i0	PRJNA641991	6411	217	0.904762	1.96333354	root	1	Root_unresolved	Root_unresolved	104	4.2400000000000006e-27	NR	KAL1661298.1	5334	g6292	i0	94.1	27.4285714285714	51	3	70.5	0	2	154	27	77	KAL1661298.1 cyclophilin-like domain-containing protein [Schizophyllum commune]	diamond	5952	104	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum commune
17195729	17195729	PRJNA641991_S_NODE_5034_length_240_cov_0.984293_g4915_i0	PRJNA641991	5034	240	0.984293	2.3623032	Naematelia encephala	71784	Fungi	Fungi	128	9.359999999999999e-34	NR	ORY34675.1	71784	g4915	i0	73.8	4	80	21	100	0	240	1	72	151	ORY34675.1 putative malate dehydrogenase [Naematelia encephala]	diamond	960	128	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
28313057	28313057	PRJNA641991_S_NODE_14386_length_162_cov_0.902655_g14267_i0	PRJNA641991	14386	162	0.902655	1.4623011	Ceratobasidium sp. AG-I	305860	Fungi	Fungi	52.4	4.85e-6	NR	KAF8603920.1	305860	g14267	i0	41.2	0.944444444444444	51	30	94.4	0	5	157	670	720	KAF8603920.1 hypothetical protein BDV93DRAFT_606297 [Ceratobasidium sp. AG-I]	diamond	153	52.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-I
29114685	29114685	PRJNA641991_S_NODE_11388_length_170_cov_1.685950_g11269_i0	PRJNA641991	11388	170	1.68595	2.866115	Fungi	4751	Fungi	Fungi	79.3	2.28e-16	NR	AFU72288.1	67730	g11269	i0	65.5	5.82352941176471	55	19	97.1	0	4	168	137	191	AFU72288.1 40S ribosomal protein S1, partial [Amanita strobiliformis]	diamond	990	80.1	0.990012484394507	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita strobiliformis
30807962	30807962	PRJNA641991_S_NODE_10934_length_173_cov_1.282258_g10815_i0	PRJNA641991	10934	173	1.282258	2.21830634	Rhizoctonia solani	456999	Fungi	Fungi	72.4	4.92e-13	NR	CAE7130941.1	456999	g10815	i0	59.6	5.93063583815029	57	21	98.8	1	3	173	213	267	CAE7130941.1 unnamed protein product [Rhizoctonia solani]	diamond	1026	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
31736924	31736924	PRJNA641991_S_NODE_10057_length_180_cov_0.885496_g9938_i0	PRJNA641991	10057	180	0.885496	1.5938928	Fungi	4751	Fungi	Fungi	93.6	6.400000000000001e-23	NR	XP_036631820.1	5322	g9938	i0	74.6	53.6833333333333	59	15	98.3	0	180	4	20	78	XP_036631820.1 60S ribosomal protein L30 [Pleurotus ostreatus]	diamond	9663	94.4	0.991525423728813	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus ostreatus
32433347	32433347	PRJNA641991_P_NODE_3059_length_172_cov_1.243902_g3018_i0	PRJNA641991	3059	172	1.243902	2.13951144	Exobasidiomycetes	452283	Fungi	Fungi	60.5	2.55e-9	NR	XP_025381449.1	215250	g3018	i0	63.5	3.6453488372093	52	17	90.7	1	16	171	1	50	XP_025381449.1 large subunit ribosomal protein L18e [Acaromyces ingoldii]	diamond	627	60.8	0.995065789473684	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Exobasidiales	Cryptobasidiaceae	Acaromyces	Acaromyces ingoldii

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