metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1115053" 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
20630096	20630096	PRJNA1115053_S_NODE_61837_length_311_cov_4.723881_g60020_i0	PRJNA1115053	61837	311	4.723881	14.69126991	Basidiomycota	5204	Fungi	Fungi	89.7	2.04e-18	NR	PPQ90753.1	93625	g60020	i0	82.4	6.88745980707395	51	9	49.2	0	2	154	401	451	PPQ90753.1 hypothetical protein CVT25_010142 [Psilocybe cyanescens]	diamond	2142	90.5	0.991160220994475	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cyanescens
23177193	23177193	PRJNA1115053_S_NODE_203899_length_192_cov_1.932886_g202082_i0	PRJNA1115053	203899	192	1.932886	3.71114112	Basidiomycota	5204	Fungi	Fungi	125	2.66e-34	NR	ORY22388.1	71784	g202082	i0	88.9	18.703125	63	7	98.4	0	191	3	142	204	ORY22388.1 putative manganese superoxide dismutase [Naematelia encephala]	diamond	3591	126	0.992063492063492	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
27510512	27510512	PRJNA1115053_S_NODE_321703_length_156_cov_1.274336_g319886_i0	PRJNA1115053	321703	156	1.274336	1.98796416	Mycena chlorophos	658473	Fungi	Fungi	42.7	0.0114	NR	GAT48379.1	658473	g319886	i0	52.9	1.30769230769231	34	16	65.4	0	53	154	146	179	GAT48379.1 predicted protein [Mycena chlorophos]	diamond	204	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena chlorophos
27542017	27542017	PRJNA1115053_S_NODE_155364_length_216_cov_1.942197_g153547_i0	PRJNA1115053	155364	216	1.942197	4.19514552	Earliella scabrosa	2478900	Fungi	Fungi	41.6	0.0227	NR	KAI0740424.1	2478900	g153547	i0	37.7	0.736111111111111	53	33	73.6	0	28	186	11	63	KAI0740424.1 hypothetical protein C8Q76DRAFT_608305, partial [Earliella scabrosa]	diamond	159	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Earliella	Earliella scabrosa
28773214	28773214	PRJNA1115053_S_NODE_103927_length_255_cov_2.108491_g102110_i0	PRJNA1115053	103927	255	2.108491	5.37665205	Jaapia argillacea MUCL 336	202697	Fungi	Fungi	42.7	0.0433	NR	KDQ56957.1	933084	g102110	i0	44.4	0.423529411764706	36	20	42.4	0	119	226	320	355	KDQ56957.1 hypothetical protein JAAARDRAFT_194146 [Jaapia argillacea MUCL 33604]	diamond	108	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Jaapiales	Jaapiaceae	Jaapia	Jaapia argillacea
28868069	28868069	PRJNA1115053_S_NODE_294148_length_163_cov_1.158333_g292331_i0	PRJNA1115053	294148	163	1.158333	1.88808279	Fibroporia radiculosa	599839	Fungi	Fungi	42	0.0233	NR	XP_012179749.1	599839	g292331	i0	45	0.736196319018405	40	22	73.6	0	158	39	236	275	XP_012179749.1 uncharacterized protein FIBRA_02499 [Fibroporia radiculosa]	diamond	120	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Fibroporiaceae	Fibroporia	Fibroporia radiculosa
28931267	28931267	PRJNA1115053_S_NODE_155868_length_216_cov_1.387283_g154051_i0	PRJNA1115053	155868	216	1.387283	2.99653128	Lactifluus volemus	71967	Fungi	Fungi	42.4	0.0357	NR	KAH9967749.1	71967	g154051	i0	43.8	0.666666666666667	48	25	65.3	2	167	27	160	206	KAH9967749.1 hypothetical protein BGW80DRAFT_1462090 [Lactifluus volemus]	diamond	144	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactifluus	Lactifluus volemus
29206642	29206642	PRJNA1115053_S_NODE_97009_length_262_cov_2.283105_g95192_i0	PRJNA1115053	97009	262	2.283105	5.9817351	Basidiomycota	5204	Fungi	Fungi	91.7	2.8e-19	NR	CED83685.1	264483	g95192	i0	51.7	1.99236641221374	87	41	98.5	1	3	260	518	604	CED83685.1 heat shock protein 70 [Phaffia rhodozyma]	diamond	522	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
30321325	30321325	PRJNA1115053_S_NODE_198512_length_194_cov_3.748344_g196695_i0	PRJNA1115053	198512	194	3.748344	7.27178736	Paxillus rubicundulus Ve	463315	Fungi	Fungi	42	0.0154	NR	KIK76553.1	930991	g196695	i0	45.3	0.819587628865979	53	25	82	1	190	32	46	94	KIK76553.1 hypothetical protein PAXRUDRAFT_422829 [Paxillus rubicundulus Ve08.2h10]	diamond	159	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Paxillaceae	Paxillus	Paxillus rubicundulus
30447325	30447325	PRJNA1115053_S_NODE_193893_length_196_cov_3.274510_g192076_i0	PRJNA1115053	193893	196	3.27451	6.4180396	Schizopora paradoxa	27342	Fungi	Fungi	42.7	0.0196	NR	KLO12460.1	27342	g192076	i0	38.9	0.826530612244898	54	29	82.7	1	170	9	315	364	KLO12460.1 hypothetical protein SCHPADRAFT_905091 [Schizopora paradoxa]	diamond	162	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Schizoporaceae	Schizopora	Schizopora paradoxa
30921275	30921275	PRJNA1115053_S_NODE_95234_length_264_cov_2.389140_g93417_i0	PRJNA1115053	95234	264	2.38914	6.3073296	Armillaria mellea	47429	Fungi	Fungi	42.7	0.0478	NR	KAK0184000.1	47429	g93417	i0	32.9	0.863636363636364	76	49	84.1	1	38	259	348	423	KAK0184000.1 P-loop containing nucleoside triphosphate hydrolase protein [Armillaria mellea]	diamond	228	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria mellea
31110481	31110481	PRJNA1115053_S_NODE_207315_length_191_cov_1.263514_g205498_i0	PRJNA1115053	207315	191	1.263514	2.41331174	Pleurotus pulmonarius	28995	Fungi	Fungi	41.6	0.0484	NR	KAF4596760.1	28995	g205498	i0	43.1	0.801047120418848	51	27	77	1	7	153	508	558	KAF4596760.1 hypothetical protein EYR38_008151 [Pleurotus pulmonarius]	diamond	153	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius
31585201	31585201	PRJNA1115053_S_NODE_120836_length_240_cov_1.989848_g119019_i0	PRJNA1115053	120836	240	1.989848	4.7756352	Cryptococcus depauperatus	5208	Fungi	Fungi	72.4	1.28e-12	NR	ACZ80693.1	5208	g119019	i0	47.1	2.475	70	35	86.3	2	232	26	325	393	ACZ80693.1 putative retrotransposon nucleocapsid protein [Cryptococcus depauperatus]	diamond	594	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus depauperatus
32186178	32186178	PRJNA1115053_S_NODE_310578_length_158_cov_3.773913_g308761_i0	PRJNA1115053	310578	158	3.773913	5.96278254	Panus rudis PR-1116 ss-1	1314784	Fungi	Fungi	46.2	7.02e-4	NR	KAI0080733.1	1314784	g308761	i0	37.7	1.00632911392405	53	31	96.8	1	153	1	391	443	KAI0080733.1 WD40 repeat-like protein [Panus rudis PR-1116 ss-1]	diamond	159	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Panaceae	Panus	Panus rudis
32723253	32723253	PRJNA1115053_S_NODE_261760_length_172_cov_1.248062_g259943_i0	PRJNA1115053	261760	172	1.248062	2.14666664	Laccaria amethystina LaAM-	89243	Fungi	Fungi	42.7	0.014	NR	KIJ96833.1	1095629	g259943	i0	44.8	1.01162790697674	58	23	95.9	2	3	167	301	352	KIJ96833.1 hypothetical protein K443DRAFT_10330 [Laccaria amethystina LaAM-08-1]	diamond	174	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hydnangiaceae	Laccaria	Laccaria amethystina

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