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

8 rows where analysis = "diamond", bioproject = "PRJNA1120203" 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
23227710	23227710	PRJNA1120203_P_NODE_82079_length_250_cov_0.870056_g81063_i0	PRJNA1120203	82079	250	0.870056	2.17514	Pleurotus ostreatus	5322	Fungi	Fungi	129	2.96e-33	NR	KAJ8701091.1	5322	g81063	i0	100	0.72	60	0	72	0	2	181	441	500	KAJ8701091.1 hypothetical protein PTI98_004054 [Pleurotus ostreatus]	diamond	180	129	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus ostreatus
26911800	26911800	PRJNA1120203_P_NODE_81842_length_250_cov_0.870056_g80826_i0	PRJNA1120203	81842	250	0.870056	2.17514	Galerina marginata CBS 339.88	685588	Fungi	Fungi	122	8.359999999999999e-31	NR	KDR74261.1	685588	g80826	i0	65.1	1.992	83	29	99.6	0	250	2	203	285	KDR74261.1 hypothetical protein GALMADRAFT_573774 [Galerina marginata CBS 339.88]	diamond	498	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Galerina	Galerina marginata
28491322	28491322	PRJNA1120203_P_NODE_78467_length_251_cov_0.865169_g77451_i0	PRJNA1120203	78467	251	0.865169	2.17157419	Fomitiporia mediterranea MF3/22	694068	Fungi	Fungi	68.6	3.25e-11	NR	XP_007270574.1	694068	g77451	i0	47.6	1.87649402390438	82	42	98	1	246	1	49	129	XP_007270574.1 uncharacterized protein FOMMEDRAFT_128335 [Fomitiporia mediterranea MF3/22]	diamond	471	68.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Fomitiporia	Fomitiporia mediterranea
28733210	28733210	PRJNA1120203_P_NODE_102067_length_242_cov_0.911243_g101051_i0	PRJNA1120203	102067	242	0.911243	2.20520806	Agaricales	5338	Fungi	Fungi	75.1	7.76e-14	NR	KAF9458237.1	64659	g101051	i0	62.7	8.1198347107438	59	22	73.1	0	1	177	112	170	KAF9458237.1 NAD-binding protein [Collybia nuda]	diamond	1965	75.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Clitocybaceae	Collybia	Collybia nuda
29059675	29059675	PRJNA1120203_P_NODE_81548_length_250_cov_0.870056_g80532_i0	PRJNA1120203	81548	250	0.870056	2.17514	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	72.4	1.48e-12	NR	XP_066825912.1	1397322	g80532	i0	54.2	0.996	83	31	96	3	241	2	486	564	XP_066825912.1 uncharacterized protein P389DRAFT_5491 [Cystobasidium minutum MCA 4210]	diamond	249	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
31228236	31228236	PRJNA1120203_P_NODE_95195_length_245_cov_0.895349_g94179_i0	PRJNA1120203	95195	245	0.895349	2.19360505	Polyporales	5303	Fungi	Fungi	115	1.68e-28	NR	XP_027610552.1	139825	g94179	i0	70.4	4.95918367346939	81	24	99.2	0	1	243	137	217	XP_027610552.1 Aspartic protease [Sparassis crispa]	diamond	1215	115	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Sparassidaceae	Sparassis	Sparassis crispa
31302361	31302361	PRJNA1120203_P_NODE_100695_length_243_cov_0.905882_g99679_i0	PRJNA1120203	100695	243	0.905882	2.20129326	Mycena latifolia	1033247	Fungi	Fungi	61.2	1.08e-8	NR	KAJ7451068.1	1033247	g99679	i0	52.9	0.62962962962963	51	24	63	0	214	62	57	107	KAJ7451068.1 peptidase C13 family-domain-containing protein [Mycena latifolia]	diamond	153	61.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena latifolia
32568063	32568063	PRJNA1120203_P_NODE_75119_length_257_cov_1.260870_g74103_i0	PRJNA1120203	75119	257	1.26087	3.2404359	Pholiota molesta	2066989	Fungi	Fungi	72	3.93e-13	NR	KAF8204529.1	2066989	g74103	i0	70.2	1.09727626459144	47	14	54.9	0	116	256	159	205	KAF8204529.1 hypothetical protein BJ912DRAFT_938591 [Pholiota molesta]	diamond	282	72	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Pholiota	Pholiota molesta

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