metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA795983" 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
2055938	2055938	PRJNA795983_S_NODE_19242_length_311_cov_2.340336_g19117_i0	PRJNA795983	19242	311	2.340336	7.27844496	Typhula micans	359127	Fungi	Fungi	569	6.489999999999998e-158	NTclustered	gi\|1190246168\|gb\|KY224102.1\|	359127	g19117	i0	99.678	100.360128617363	311	1	100	0	1	311	614	304	Typhula micans voucher IO.14.165 (S, UPS) large subunit ribosomal RNA gene, partial sequence	blastn	31212	569	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Typhulaceae	Typhula	Typhula micans
3331356	3331356	PRJNA795983_S_NODE_43123_length_241_cov_0.916667_g42998_i0	PRJNA795983	43123	241	0.916667	2.20916747	Malassezia restricta	76775	Fungi	Fungi	431	2.38e-116	NTclustered	gi\|1546630381\|ref\|XM_027626851.1\|	76775	g42998	i0	99.163	0.991701244813278	239	2	99	0	1	239	1197	1435	Malassezia restricta cytochrome c oxidase subunit 15 (MRET_0224), partial mRNA	blastn	239	431	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
5883663	5883663	PRJNA795983_S_NODE_29525_length_269_cov_1.571429_g29400_i0	PRJNA795983	29525	269	1.571429	4.22714401	Coprinopsis cinerea	5346	Fungi	Fungi	143	1.42e-29	NTclustered	gi\|299753254\|ref\|XM_001833107.2\|	240176	g29400	i0	79.602	11.7806691449814	201	39	91	2	22	221	635	834	Coprinopsis cinerea okayama7#130 methionine adenosyltransferase (CC1G_01221), mRNA	blastn	3169	143	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinopsis	Coprinopsis cinerea
7158371	7158371	PRJNA795983_S_NODE_15666_length_333_cov_1.011538_g15541_i0	PRJNA795983	15666	333	1.011538	3.36842154	Lentinus tigrinus	5365	Fungi	Fungi	231	3.76e-56	NTclustered	gi\|2797443665\|ref\|XM_067681507.1\|	1328758	g15541	i0	80.195	80.5315315315315	308	61	92	0	11	318	441	134	Lentinus tigrinus ALCF2SS1-7 uncharacterized protein (L226DRAFT_538487), mRNA	blastn	26817	231	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lentinus	Lentinus tigrinus
7158402	7158402	PRJNA795983_S_NODE_18946_length_313_cov_1.316667_g18821_i0	PRJNA795983	18946	313	1.316667	4.12116771	Tilletiopsis washingtonensis	58919	Fungi	Fungi	132	3.66e-26	NTclustered	gi\|1423578269\|ref\|XM_025742440.1\|	58919	g18821	i0	87.611	2.09904153354633	113	14	36	0	79	191	946	1058	Tilletiopsis washingtonensis mitochondrial carrier (FA09DRAFT_330048), mRNA	blastn	657	132	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
7158647	7158647	PRJNA795983_S_NODE_41126_length_243_cov_1.658824_g41001_i0	PRJNA795983	41126	243	1.658824	4.03094232	Kwoniella pini	453459	Fungi	Fungi	239	1.57e-58	NTclustered	gi\|1101824693\|ref\|XM_019153085.1\|	1296096	g41001	i0	84.426	43.3086419753086	244	36	100	2	1	243	161	403	Kwoniella pini CBS 10737 histone H3 (I206_103689), partial mRNA	blastn	10524	239	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella pini
8433305	8433305	PRJNA795983_S_NODE_37547_length_248_cov_1.737143_g37422_i0	PRJNA795983	37547	248	1.737143	4.30811464	Kwoniella dendrophila	4975	Fungi	Fungi	171	5.94e-38	NTclustered	gi\|2752974703\|ref\|XM_066215994.1\|	1295534	g37422	i0	80.909	55.3266129032258	220	38	88	4	31	248	250	467	Kwoniella dendrophila CBS 6074 peptidyl-prolyl cis-trans isomerase (L201_000191), partial mRNA	blastn	13721	171	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella dendrophila
8433362	8433362	PRJNA795983_S_NODE_44187_length_231_cov_2.518987_g44062_i0	PRJNA795983	44187	231	2.518987	5.81885997	Dacryopinax primogenitus	1858805	Fungi	Fungi	196	9.01e-46	NTclustered	gi\|2028544392\|ref\|XM_040772159.1\|	1858805	g44062	i0	83.41	16.1168831168831	217	31	94	4	3	218	200	412	Dacryopinax primogenitus ribosomal protein S2 (DACRYDRAFT_20949), mRNA	blastn	3723	196	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Dacrymycetes	Dacrymycetales	Dacrymycetaceae	Dacryopinax	Dacryopinax primogenitus
9708177	9708177	PRJNA795983_S_NODE_12068_length_363_cov_2.393103_g11943_i0	PRJNA795983	12068	363	2.393103	8.68696389	Apiotrichum porosum	105984	Fungi	Fungi	217	1.15e-51	NTclustered	gi\|1607527352\|ref\|XM_028624905.1\|	105984	g11943	i0	82.591	69.6170798898072	247	41	68	2	41	286	1747	1992	Apiotrichum porosum uncharacterized protein (EHS24_009635), partial mRNA	blastn	25271	217	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Apiotrichum	Apiotrichum porosum
9708214	9708214	PRJNA795983_S_NODE_16228_length_329_cov_1.195312_g16103_i0	PRJNA795983	16228	329	1.195312	3.93257648	Pseudomicrostroma glucosiphilum	1684307	Fungi	Fungi	350	9.8e-92	NTclustered	gi\|1418629297\|ref\|XM_025491784.1\|	1684307	g16103	i0	86.834	95.6443768996961	319	35	96	5	1	317	926	613	Pseudomicrostroma glucosiphilum ATP synthase F1, beta subunit (BCV69DRAFT_280904), mRNA	blastn	31467	350	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Pseudomicrostroma	Pseudomicrostroma glucosiphilum
9708441	9708441	PRJNA795983_S_NODE_39868_length_245_cov_0.895349_g39743_i0	PRJNA795983	39868	245	0.895349	2.19360505	Coprinopsis cinerea	5346	Fungi	Fungi	52.8	0.022	NTclustered	gi\|299749499\|ref\|XM_001836097.2\|	240176	g39743	i0	100	0.114285714285714	28	0	11	0	99	126	1172	1145	Coprinopsis cinerea okayama7#130 hypothetical protein (CC1G_10930), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinopsis	Coprinopsis cinerea
11420387	11420387	PRJNA795983_S_NODE_29289_length_270_cov_1.421320_g29164_i0	PRJNA795983	29289	270	1.42132	3.837564	Fungi	4751	Fungi	Fungi	209	1.3900000000000001e-49	NTclustered	gi\|2234846081\|ref\|XM_047889590.1\|	181762	g29164	i0	81.928	87.1185185185185	249	43	92	2	2	249	1186	1433	Psilocybe cubensis uncharacterized protein (JR316_0003820), partial mRNA	blastn	23522	211	0.990521327014218	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cubensis
12259720	12259720	PRJNA795983_S_NODE_40570_length_244_cov_0.900585_g40445_i0	PRJNA795983	40570	244	0.900585	2.1974274	Malassezia sympodialis	76777	Fungi	Fungi	171	5.82e-38	NTclustered	gi\|1092928383\|ref\|XM_018883719.1\|	1230383	g40445	i0	80.435	8.74590163934426	230	39	93	6	18	244	1067	841	Malassezia sympodialis ATCC 42132 uncharacterized protein (MSY001_1895), partial mRNA	blastn	2134	171	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis
13970450	13970450	PRJNA795983_S_NODE_26471_length_279_cov_8.407767_g26346_i0	PRJNA795983	26471	279	8.407767	23.45766993	Opisthokonta	33154	Fungi	Fungi	110	1.5e-19	NTclustered	gi\|52631077\|gb\|AY745727.1\|	4997	g26346	i0	79.755	52.2759856630824	163	24	58	7	118	279	1104	1258	Bensingtonia yuccicola isolate AFTOL-ID 857 25S large subunit ribosomal RNA gene, partial sequence	blastn	14585	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricostilbomycetes	Agaricostilbales	Kondoaceae	Kondoa	Kondoa yuccicola
14808600	14808600	PRJNA795983_S_NODE_19772_length_308_cov_4.859574_g19647_i0	PRJNA795983	19772	308	4.859574	14.96748792	Cryptococcus neoformans	5207	Fungi	Fungi	259	1.5800000000000002e-64	NTclustered	gi\|799318120\|ref\|XM_012191959.1\|	235443	g19647	i0	83.513	83.2077922077922	279	44	90	2	1	278	447	170	Cryptococcus neoformans var. grubii H99 peptidyl-prolyl cis-trans isomerase (CNAG_03627), mRNA	blastn	25628	259	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus neoformans
17358438	17358438	PRJNA795983_S_NODE_25394_length_283_cov_2.971429_g25269_i0	PRJNA795983	25394	283	2.971429	8.40914407	Malassezia restricta	76775	Fungi	Fungi	514	2.77e-141	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g25269	i0	99.298	75.0424028268551	285	0	100	1	1	283	3001	3285	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	21237	514	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
19907097	19907097	PRJNA795983_S_NODE_7996_length_421_cov_2.396552_g7871_i0	PRJNA795983	7996	421	2.396552	10.08948392	Melampsora laricis-populina	203908	Fungi	Fungi	63.9	1.87e-5	NTclustered	gi\|599371785\|ref\|XM_007407025.1\|	747676	g7871	i0	91.304	0.109263657957245	46	4	11	0	153	198	839	884	Melampsora larici-populina 98AG31 uncharacterized protein (MELLADRAFT_71205), mRNA	blastn	46	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora laricis-populina
23732910	23732910	PRJNA795983_S_NODE_25159_length_284_cov_3.701422_g25034_i0	PRJNA795983	25159	284	3.701422	10.51203848	Pseudomicrostroma glucosiphilum	1684307	Fungi	Fungi	158	5.4e-34	NTclustered	gi\|1418633411\|ref\|XM_025492511.1\|	1684307	g25034	i0	78.077	80.4894366197183	260	49	90	8	29	284	1338	1083	Pseudomicrostroma glucosiphilum putative translation elongation factor eEF-1 alpha chain (BCV69DRAFT_282886), mRNA	blastn	22859	158	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Pseudomicrostroma	Pseudomicrostroma glucosiphilum
23733041	23733041	PRJNA795983_S_NODE_40819_length_244_cov_0.900585_g40694_i0	PRJNA795983	40819	244	0.900585	2.1974274	Malassezia restricta	76775	Fungi	Fungi	300	7.12e-77	NTclustered	gi\|1546632602\|ref\|XM_027627961.1\|	76775	g40694	i0	94.792	0.786885245901639	192	10	79	0	53	244	1	192	Malassezia restricta 5-oxoprolinase (ATP-hydrolyzing) (MRET_1334), partial mRNA	blastn	192	300	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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