metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1002816" 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
152945	152945	PRJNA1002816_P_NODE_20541_length_242_cov_0.911243_g20381_i0	PRJNA1002816	20541	242	0.911243	2.20520806	Rhizoctonia sp. AG-Bo	1384209	Fungi	Fungi	374	4.1e-99	NTclustered	gi\|530408112\|gb\|JX989024.1\|	1384209	g20381	i0	99.038	96.8842975206612	208	2	86	0	35	242	449	242	Rhizoctonia sp. AG-Bo isolate SIR-2 28S ribosomal RNA gene, partial sequence	blastn	23446	374	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia sp. AG-Bo
152953	152953	PRJNA1002816_P_NODE_20801_length_241_cov_0.916667_g20641_i0	PRJNA1002816	20801	241	0.916667	2.20916747	Rhizoctonia solani	456999	Fungi	Fungi	220	5.62e-53	NTclustered	gi\|2086747592\|ref\|XM_043324341.1\|	456999	g20641	i0	84.862	3.60165975103734	218	33	90	0	2	219	218	1	Rhizoctonia solani glutamine synthetase (RhiXN_04524), partial mRNA	blastn	868	220	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
1000855	1000855	PRJNA1002816_P_NODE_14261_length_289_cov_1.425926_g14101_i0	PRJNA1002816	14261	289	1.425926	4.12092614	Fungi	4751	Fungi	Fungi	193	1.51e-44	NTclustered	gi\|2234767215\|ref\|XM_048021320.1\|	378194	g14101	i0	84.264	57.7716262975779	197	31	68	0	47	243	237	41	Epithele typhae 60S ribosomal protein L27a (BXZ73DRAFT_55311), partial mRNA	blastn	16696	193	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Epitheliaceae	Epithele	Epithele typhae
2703128	2703128	PRJNA1002816_P_NODE_18823_length_247_cov_0.885057_g18663_i0	PRJNA1002816	18823	247	0.885057	2.18609079	Pleurotus ostreatus	5322	Fungi	Fungi	230	9.61e-56	NTclustered	gi\|1919721441\|ref\|XM_036776929.1\|	5322	g18663	i0	83.401	11.6315789473684	247	41	100	0	1	247	2778	3024	Pleurotus ostreatus uncharacterized protein (PC9H_007398), partial mRNA	blastn	2873	230	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus ostreatus
3979156	3979156	PRJNA1002816_P_NODE_11464_length_328_cov_1.207843_g11304_i0	PRJNA1002816	11464	328	1.207843	3.96172504	Rhizoctonia solani	456999	Fungi	Fungi	468	2.59e-127	NTclustered	gi\|2428481418\|gb\|ON042753.1\|	456999	g11304	i0	92.378	99.594512195122	328	25	100	0	1	328	977	650	Rhizoctonia solani isolate CR1_19004 translation elongation factor 1-alpha (tef1) gene, partial cds	blastn	32667	468	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
7805477	7805477	PRJNA1002816_P_NODE_19827_length_244_cov_0.900585_g19667_i0	PRJNA1002816	19827	244	0.900585	2.1974274	Mycena indigotica	2126181	Fungi	Fungi	244	3.3799999999999997e-60	NTclustered	gi\|1929803590\|ref\|XM_037367098.1\|	2126181	g19667	i0	85	14.8893442622951	240	36	98	0	3	242	2473	2712	Mycena indigotica Autophagy-related protein (MIND_01051400), partial mRNA	blastn	3633	244	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena indigotica
9080401	9080401	PRJNA1002816_P_NODE_20408_length_242_cov_0.911243_g20248_i0	PRJNA1002816	20408	242	0.911243	2.20520806	Rhizoctonia solani	456999	Fungi	Fungi	305	1.52e-78	NTclustered	gi\|2086753559\|ref\|XM_043320575.1\|	456999	g20248	i0	90.171	91.2190082644628	234	23	97	0	9	242	401	168	Rhizoctonia solani ribosomal S13/S15 N-terminal domain (RhiXN_00756), partial mRNA	blastn	22075	305	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
9080407	9080407	PRJNA1002816_P_NODE_20648_length_242_cov_0.881657_g20488_i0	PRJNA1002816	20648	242	0.881657	2.13360994	Lentinus tigrinus	5365	Fungi	Fungi	222	1.57e-53	NTclustered	gi\|2797376204\|ref\|XM_067676716.1\|	1328758	g20488	i0	85.99	81.9090909090909	207	29	86	0	24	230	1125	1331	Lentinus tigrinus ALCF2SS1-7 alpha1 tubulin (L226DRAFT_476604), mRNA	blastn	19822	222	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lentinus	Lentinus tigrinus
9928878	9928878	PRJNA1002816_P_NODE_17008_length_256_cov_1.612022_g16848_i0	PRJNA1002816	17008	256	1.612022	4.12677632	root	1	Root_unresolved	Root_unresolved	54.7	0.006	NTclustered	gi\|1423573848\|ref\|XM_025745160.1\|	58919	g16848	i0	100	0.2265625	29	0	11	0	135	163	587	559	Tilletiopsis washingtonensis AAA-domain-containing protein (FA09DRAFT_359765), mRNA	blastn	58	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
11631619	11631619	PRJNA1002816_P_NODE_8970_length_375_cov_1.261589_g8810_i0	PRJNA1002816	8970	375	1.261589	4.73095875	Stereum hirsutum	40492	Fungi	Fungi	396	1.43e-105	NTclustered	gi\|597907329\|ref\|XM_007300902.1\|	721885	g8810	i0	90.132	79.872	304	30	81	0	70	373	80	383	Stereum hirsutum FP-91666 SS1 GTP-binding nuclear protein RAN (STEHIDRAFT_118951), mRNA	blastn	29952	396	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
12906622	12906622	PRJNA1002816_P_NODE_19151_length_246_cov_0.890173_g18991_i0	PRJNA1002816	19151	246	0.890173	2.18982558	Vanrija pseudolonga	143232	Fungi	Fungi	60.2	1.33e-4	NTclustered	gi\|2669720926\|ref\|XM_062767357.1\|	143232	g18991	i0	100	1.02032520325203	32	0	13	0	109	140	211	180	Vanrija pseudolonga Pre-mRNA-splicing factor CWC25 (CWC25), mRNA	blastn	251	60.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
12906631	12906631	PRJNA1002816_P_NODE_19631_length_245_cov_0.895349_g19471_i0	PRJNA1002816	19631	245	0.895349	2.19360505	Rhizoctonia solani	456999	Fungi	Fungi	254	5.65e-63	NTclustered	gi\|2086759043\|ref\|XM_043329495.1\|	456999	g19471	i0	86.842	7.33061224489796	228	29	93	1	3	230	982	1208	Rhizoctonia solani calnexin (RhiXN_09679), partial mRNA	blastn	1796	254	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
15455418	15455418	PRJNA1002816_P_NODE_11633_length_325_cov_1.436508_g11473_i0	PRJNA1002816	11633	325	1.436508	4.668651	Rhizoctonia solani	456999	Fungi	Fungi	259	1.68e-64	NTclustered	gi\|2086767385\|ref\|XM_043331739.1\|	456999	g11473	i0	85.098	36.4215384615385	255	37	78	1	2	256	329	76	Rhizoctonia solani heat shock protein HSP70 family protein (RhiXN_11924), partial mRNA	blastn	11837	259	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
21403003	21403003	PRJNA1002816_P_NODE_20557_length_242_cov_0.911243_g20397_i0	PRJNA1002816	20557	242	0.911243	2.20520806	Basidiomycota	5204	Fungi	Fungi	165	2.68e-36	NTclustered	gi\|2432183463\|ref\|XM_053087979.1\|	4972	g20397	i0	79.424	21.1280991735537	243	42	99	8	1	239	2221	2459	Dioszegia hungarica chitin synthase 3 (MKK02DRAFT_30135), partial mRNA	blastn	5113	165	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
21829557	21829557	PRJNA1002816_P_NODE_10518_length_344_cov_1.136531_g10358_i0	PRJNA1002816	10518	344	1.136531	3.90966664	Pisolithus orientalis	936130	Fungi	Fungi	187	8.55e-43	NTclustered	gi\|2325040059\|ref\|XM_051743998.1\|	936130	g10358	i0	78.405	75.4476744186046	301	56	86	7	48	344	149	444	Pisolithus orientalis ribosomal protein L3-domain-containing protein (F5J12DRAFT_793974), mRNA	blastn	25954	187	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Pisolithaceae	Pisolithus	Pisolithus orientalis
23105017	23105017	PRJNA1002816_P_NODE_13839_length_295_cov_1.040541_g13679_i0	PRJNA1002816	13839	295	1.040541	3.06959595	Wallemia mellicola	1708541	Fungi	Fungi	180	1.2e-40	NTclustered	gi\|588263024\|ref\|XM_006960594.1\|	671144	g13679	i0	78.467	20.0474576271186	274	59	93	0	22	295	175	448	Wallemia mellicola CBS 633.66 hypothetical protein partial mRNA	blastn	5914	180	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia mellicola
23105318	23105318	PRJNA1002816_P_NODE_9679_length_359_cov_2.737762_g9519_i0	PRJNA1002816	9679	359	2.737762	9.82856558	Pseudozyma flocculosa	84751	Fungi	Fungi	272	2.4e-68	NTclustered	gi\|630959971\|ref\|XM_007878203.1\|	1277687	g9519	i0	81.763	59.7019498607242	329	56	91	4	28	354	22	348	Pseudozyma flocculosa PF-1 calmodulin (PFL1_00701), partial mRNA	blastn	21433	272	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
24378832	24378832	PRJNA1002816_P_NODE_1660_length_877_cov_5.584577_g1531_i0	PRJNA1002816	1660	877	5.584577	48.97674029	Tilletiopsis washingtonensis	58919	Fungi	Fungi	394	1.28e-104	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g1531	i0	80	19.2280501710376	540	102	61	6	237	773	591	55	Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA	blastn	16863	394	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis

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