metadata: contig_metadata: 28 rows where bioproject = "PRJNA1159911" and tax

28 rows where bioproject = "PRJNA1159911" 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
308762	308762	PRJNA1159911_P_NODE_91601_length_248_cov_0.880000_g91059_i0	PRJNA1159911	91601	248	0.88	2.1824	Peniophora sp. 213 OA-2013	1321910	Fungi	Fungi	459	1.13e-124	NTclustered	gi\|480327002\|gb\|JX507725.1\|	1321910	g91059	i0	100	106.08064516129	248	0	100	0	1	248	1608	1361	Peniophora sp. 213 OA-2013 large subunit ribosomal RNA gene, partial sequence	blastn	26308	459	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. 213 OA-2013
1582459	1582459	PRJNA1159911_P_NODE_43042_length_382_cov_14.009709_g42500_i0	PRJNA1159911	43042	382	14.009709	53.51708838	Austropuccinia psidii	181123	Fungi	Fungi	157	3.259999999999999e-47	NR	MBW0489473.1	1389203	g42500	i0	85.7	2.73298429319372	84	12	66	0	353	102	1	84	MBW0489473.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	1044	157	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii
2313300	2313300	PRJNA1159911_P_NODE_82842_length_257_cov_4.907609_g82300_i0	PRJNA1159911	82842	257	4.907609	12.61255513	Eukaryota	2759	Fungi	Fungi	73.1	1.79e-8	NTclustered	gi\|62946930\|gb\|AY207256.1\|	230811	g82300	i0	76.821	5.95330739299611	151	21	57	12	75	220	1092	951	Mycena renati voucher GLM 45979 28S large subunit ribosomal RNA gene, partial sequence	blastn	1530	73.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena renati
6686668	6686668	PRJNA1159911_P_NODE_90986_length_248_cov_0.880000_g90444_i0	PRJNA1159911	90986	248	0.88	2.1824	Malassezia restricta	76775	Fungi	Fungi	442	1.1399999999999995e-119	NTclustered	gi\|1546638111\|ref\|XM_027630697.1\|	76775	g90444	i0	98.79	1	248	3	100	0	1	248	1378	1131	Malassezia restricta glycoside hydrolase family 55 protein (MRET_4070), partial mRNA	blastn	248	442	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
9235132	9235132	PRJNA1159911_P_NODE_100968_length_241_cov_0.916667_g100426_i0	PRJNA1159911	100968	241	0.916667	2.20916747	Malassezia restricta	76775	Fungi	Fungi	435	1.84e-117	NTclustered	gi\|1546637933\|ref\|XM_027630608.1\|	76775	g100426	i0	99.17	1	241	2	100	0	1	241	312	552	Malassezia restricta U3 small nucleolar RNA-associated protein 22 (MRET_3981), partial mRNA	blastn	241	435	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
10512063	10512063	PRJNA1159911_P_NODE_69929_length_284_cov_1.165877_g69387_i0	PRJNA1159911	69929	284	1.165877	3.31109068	Sphaerobolus stellatus SS14	990650	Fungi	Fungi	91.3	1.51e-19	NR	KIJ38911.1	990650	g69387	i0	45.2	1.09859154929577	104	39	90.8	2	19	276	68	171	KIJ38911.1 hypothetical protein M422DRAFT_32976 [Sphaerobolus stellatus SS14]	diamond	312	91.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Geastrales	Sphaerobolaceae	Sphaerobolus	Sphaerobolus stellatus
10512443	10512443	PRJNA1159911_P_NODE_88009_length_250_cov_1.587571_g87467_i0	PRJNA1159911	88009	250	1.587571	3.9689275	Melampsora laricis-populina	203908	Fungi	Fungi	63.9	1.05e-5	NTclustered	gi\|599373494\|ref\|XM_007407322.1\|	747676	g87467	i0	100	0.136	34	0	14	0	52	85	1073	1040	Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_95778), partial mRNA	blastn	34	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora laricis-populina
11786856	11786856	PRJNA1159911_P_NODE_64150_length_298_cov_1.715556_g63608_i0	PRJNA1159911	64150	298	1.715556	5.11235688	Agaricomycetes	155619	Fungi	Fungi	114	4.9600000000000006e-27	NR	TFK42018.1	68775	g63608	i0	68.6	17.1946308724832	86	27	86.6	0	260	3	61	146	TFK42018.1 carbamoyl-phosphate synthase L chain, ATP binding domain-containing protein [Crucibulum laeve]	diamond	5124	114	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Crucibulum	Crucibulum laeve
15611668	15611668	PRJNA1159911_P_NODE_98073_length_243_cov_0.905882_g97531_i0	PRJNA1159911	98073	243	0.905882	2.20129326	Malassezia restricta	76775	Fungi	Fungi	427	3.11e-115	NTclustered	gi\|1546631191\|ref\|XM_027627256.1\|	76775	g97531	i0	98.354	2.95473251028807	243	4	100	0	1	243	2895	2653	Malassezia restricta phospholipid-translocating ATPase (MRET_0629), partial mRNA	blastn	718	427	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
17615673	17615673	PRJNA1159911_P_NODE_47314_length_359_cov_2.923077_g46772_i0	PRJNA1159911	47314	359	2.923077	10.49384643	Opisthokonta	33154	Fungi	Fungi	75	7.26e-9	NTclustered	gi\|331244326\|ref\|XM_003334756.1\|	418459	g46772	i0	85.333	10.6908077994429	75	8	30	2	90	161	91	165	Puccinia graminis f. sp. tritici CRL 75-36-700-3 uncharacterized protein (PGTG_16145), partial mRNA	blastn	3838	75	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia graminis
18158843	18158843	PRJNA1159911_P_NODE_100695_length_241_cov_1.363095_g100153_i0	PRJNA1159911	100695	241	1.363095	3.28505895	Malassezia globosa	76773	Fungi	Fungi	418	1.8599999999999995e-112	NTclustered	gi\|164656478\|ref\|XM_001729315.1\|	425265	g100153	i0	97.925	27.8257261410788	241	5	100	0	1	241	1748	1508	Malassezia globosa CBS 7966 uncharacterized protein (MGL_3402), partial mRNA	blastn	6706	418	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
18159303	18159303	PRJNA1159911_P_NODE_33455_length_456_cov_1.203655_g32914_i0	PRJNA1159911	33455	456	1.203655	5.4886668	Tilletiopsis washingtonensis	58919	Fungi	Fungi	52.8	0.044	NTclustered	gi\|1423583676\|ref\|XM_025745408.1\|	58919	g32914	i0	100	0.0614035087719298	28	0	6	0	100	127	1469	1496	Tilletiopsis washingtonensis hypothetical protein (FA09DRAFT_361849), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
20708778	20708778	PRJNA1159911_P_NODE_24397_length_567_cov_3.089069_g23861_i0	PRJNA1159911	24397	567	3.089069	17.51502123	Omphalotus japonicus	72119	Fungi	Fungi	56.5	0.004	NTclustered	gi\|1863134264\|ref\|NC_049125.1\|	72119	g23861	i0	100	0.111111111111111	30	0	5	0	12	41	73619	73648	Omphalotus japonicus mitochondrion, complete genome	blastn	63	56.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Omphalotus	Omphalotus japonicus
20710281	20710281	PRJNA1159911_P_NODE_98057_length_243_cov_0.905882_g97515_i0	PRJNA1159911	98057	243	0.905882	2.20129326	Cryptococcus amylolentus	104669	Fungi	Fungi	110	1.28e-19	NTclustered	gi\|1101785212\|ref\|XM_019135588.1\|	1295533	g97515	i0	85.185	4.04938271604938	108	15	44	1	22	128	3929	3822	Cryptococcus amylolentus CBS 6039 hypothetical protein (L202_02070), mRNA	blastn	984	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus amylolentus
23259640	23259640	PRJNA1159911_P_NODE_26699_length_532_cov_3.797386_g26160_i0	PRJNA1159911	26699	532	3.797386	20.20209352	Kwoniella shivajii	564305	Fungi	Fungi	56.5	0.004	NTclustered	gi\|2670920768\|ref\|XM_062935553.1\|	564305	g26160	i0	100	0.056390977443609	30	0	6	0	358	387	2449	2478	Kwoniella shivajii uncharacterized protein (IL334_003827), partial mRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella shivajii
24534492	24534492	PRJNA1159911_P_NODE_7780_length_1216_cov_21.427822_g7430_i0	PRJNA1159911	7780	1216	21.427822	260.56231552	Opisthokonta	33154	Fungi	Fungi	362	5.64e-120	NR	CED82942.1	264483	g7430	i0	65.6	22.4013157894737	311	105	76.7	1	37	969	29	337	CED82942.1 G protein beta subunit-like protein [Phaffia rhodozyma]	diamond	27240	364	0.994505494505495	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
26775009	26775009	PRJNA1159911_P_NODE_104881_length_204_cov_4.442748_g104339_i0	PRJNA1159911	104881	204	4.442748	9.06320592	Opisthokonta	33154	Fungi	Fungi	138	4.15e-38	NR	KAF9487340.1	5323	g104339	i0	97.1	345.970588235294	68	2	100	0	1	204	86	153	KAF9487340.1 AAA-domain-containing protein [Pleurotus eryngii]	diamond	70578	139	0.992805755395683	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus eryngii
27988033	27988033	PRJNA1159911_P_NODE_83185_length_257_cov_1.614130_g82643_i0	PRJNA1159911	83185	257	1.61413	4.1483141	Laccaria amethystina LaAM-	89243	Fungi	Fungi	53.5	5.2e-7	NR	KIJ97987.1	1095629	g82643	i0	50	1.19066147859922	66	32	75.9	1	11	205	10	75	KIJ97987.1 hypothetical protein K443DRAFT_681124, partial [Laccaria amethystina LaAM-08-1]	diamond	306	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hydnangiaceae	Laccaria	Laccaria amethystina
28808568	28808568	PRJNA1159911_P_NODE_99828_length_242_cov_0.911243_g99286_i0	PRJNA1159911	99828	242	0.911243	2.20520806	Serpula lacrymans var. lacrymans S7.9	578457	Fungi	Fungi	65.9	2.63e-10	NR	XP_007317510.1	578457	g99286	i0	85.7	1.30165289256198	35	5	43.4	0	1	105	335	369	XP_007317510.1 uncharacterized protein SERLADRAFT_348456 [Serpula lacrymans var. lacrymans S7.9]	diamond	315	65.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Serpulaceae	Serpula	Serpula lacrymans
28828059	28828059	PRJNA1159911_P_NODE_93728_length_246_cov_0.890173_g93186_i0	PRJNA1159911	93728	246	0.890173	2.18982558	Suillus	5379	Fungi	Fungi	64.3	3.28e-10	NR	XP_041245179.1	48586	g93186	i0	43.1	8.20731707317073	72	34	79.3	2	197	3	85	156	XP_041245179.1 uncharacterized protein DFJ58DRAFT_876203 [Suillus subalutaceus]	diamond	2019	64.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus subalutaceus
29093219	29093219	PRJNA1159911_P_NODE_85368_length_253_cov_1.744444_g84826_i0	PRJNA1159911	85368	253	1.744444	4.41344332	Jaapia argillacea MUCL 336	202697	Fungi	Fungi	43.5	0.00568	NR	KDQ55826.1	933084	g84826	i0	35	0.711462450592885	60	39	71.1	0	242	63	8	67	KDQ55826.1 hypothetical protein JAAARDRAFT_330681 [Jaapia argillacea MUCL 33604]	diamond	180	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Jaapiales	Jaapiaceae	Jaapia	Jaapia argillacea
29617205	29617205	PRJNA1159911_P_NODE_35050_length_441_cov_2.918478_g34508_i0	PRJNA1159911	35050	441	2.918478	12.87048798	Agaricales	5338	Fungi	Fungi	50.1	6.36e-4	NR	KAF8803922.1	171480	g34508	i0	37.9	1.46938775510204	58	36	39.5	0	315	142	95	152	KAF8803922.1 HMG-box [Phlegmacium glaucopus]	diamond	648	50.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Cortinariaceae	Phlegmacium	Phlegmacium glaucopus
30419871	30419871	PRJNA1159911_P_NODE_50333_length_346_cov_0.992674_g49791_i0	PRJNA1159911	50333	346	0.992674	3.43465204	Malassezia sp. CBS 17886	3031751	Fungi	Fungi	61.2	3.95e-8	NR	WFD29787.1	3031751	g49791	i0	42	0.763005780346821	88	51	76.3	0	73	336	309	396	WFD29787.1 hypothetical protein MSPP1_000800 [Malassezia sp. CBS 17886]	diamond	264	61.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sp. CBS 17886
32019570	32019570	PRJNA1159911_P_NODE_77518_length_267_cov_2.618557_g76976_i0	PRJNA1159911	77518	267	2.618557	6.99154719	Agaricales	5338	Fungi	Fungi	69.3	3.03e-13	NR	KAF9073185.1	206335	g76976	i0	54.9	2.8988764044943802	51	23	57.3	0	6	158	1	51	KAF9073185.1 hypothetical protein BDP27DRAFT_1319019 [Rhodocollybia butyracea]	diamond	774	69.7	0.994261119081779	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Rhodocollybia	Rhodocollybia butyracea
32190136	32190136	PRJNA1159911_P_NODE_93618_length_246_cov_1.254335_g93076_i0	PRJNA1159911	93618	246	1.254335	3.0856641	Sphagnurus paluster	117069	Fungi	Fungi	95.9	2.01e-21	NR	KAG5634805.1	117069	g93076	i0	73.7	1.40243902439024	57	15	69.5	0	5	175	285	341	KAG5634805.1 hypothetical protein H0H81_000716 [Sphagnurus paluster]	diamond	345	95.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Sphagnurus	Sphagnurus paluster
32380017	32380017	PRJNA1159911_P_NODE_75119_length_272_cov_1.924623_g74577_i0	PRJNA1159911	75119	272	1.924623	5.23497456	Dendrothele bispora CBS 962.96	1314807	Fungi	Fungi	43.1	0.0385	NR	THU93876.1	1314807	g74577	i0	38.1	0.694852941176471	63	36	69.5	2	191	3	222	281	THU93876.1 kinase-like protein [Dendrothele bispora CBS 962.96]	diamond	189	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales		Dendrothele	Dendrothele bispora
32758651	32758651	PRJNA1159911_P_NODE_76240_length_270_cov_1.553299_g75698_i0	PRJNA1159911	76240	270	1.553299	4.1939073	Coprinellus aureogranulatus	752674	Fungi	Fungi	43.1	0.0369	NR	KAJ3545387.1	752674	g75698	i0	56.4	0.433333333333333	39	17	43.3	0	1	117	348	386	KAJ3545387.1 hypothetical protein NMY22_g2464 [Coprinellus aureogranulatus]	diamond	117	43.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinellus	Coprinellus aureogranulatus
32777776	32777776	PRJNA1159911_P_NODE_72060_length_279_cov_1.165049_g71518_i0	PRJNA1159911	72060	279	1.165049	3.25048671	Fungi	4751	Fungi	Fungi	104	9.49e-27	NR	XP_017991365.1	77020	g71518	i0	60.3	3.9247311827957	73	29	78.5	0	220	2	15	87	XP_017991365.1 60s ribosomal protein l33-a-like protein [Malassezia pachydermatis]	diamond	1095	104	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis

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