metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax_phylum = "Mucoromycota"

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
545847	545847	PRJNA562549_P_NODE_7601_length_417_cov_1.216292_g7368_i0	PRJNA562549	7601	417	1.216292	5.07193764	Umbelopsis ramanniana	41833	Fungi	Fungi	449	1.2199999999999999e-121	NTclustered	gi\|2323695494\|ref\|XM_051584821.1\|	1314678	g7368	i0	86.091	462.841726618705	417	58	100	0	1	417	446	862	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_214084), mRNA	blastn	193005	449	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
1821415	1821415	PRJNA562549_P_NODE_25902_length_231_cov_1.458824_g25669_i0	PRJNA562549	25902	231	1.458824	3.36988344	Zychaea mexicana	64656	Fungi	Fungi	54.7	0.006	NTclustered	gi\|2432192896\|ref\|XM_053125513.1\|	64656	g25669	i0	100	0.125541125541126	29	0	13	0	57	85	1207	1179	Zychaea mexicana uncharacterized protein (BDB00DRAFT_851510), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Zychaea	Zychaea mexicana
8198677	8198677	PRJNA562549_P_NODE_31927_length_210_cov_1.308725_g31694_i0	PRJNA562549	31927	210	1.308725	2.7483225	Halteromyces radiatus	101107	Fungi	Fungi	243	1.02e-59	NTclustered	gi\|2323709937\|ref\|XM_051548792.1\|	101107	g31694	i0	87.619	79.3238095238095	210	24	99	2	1	209	1094	1302	Halteromyces radiatus V-type proton ATPase catalytic subunit A (BX664DRAFT_377787), mRNA	blastn	16658	243	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
8783708	8783708	PRJNA562549_P_NODE_18847_length_267_cov_2.339806_g18614_i0	PRJNA562549	18847	267	2.339806	6.24728202	Umbelopsis	64561	Fungi	Fungi	289	1.71e-73	NTclustered	gi\|1929279312\|gb\|MN879019.1\|	41833	g18614	i0	88.066	92.374531835206	243	29	91	0	24	266	597	355	Umbelopsis ramanniana strain AG elongation factor 1-alpha (EF1a) gene, complete cds	blastn	24664	291	0.993127147766323	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
9474323	9474323	PRJNA562549_P_NODE_26448_length_229_cov_1.154762_g26215_i0	PRJNA562549	26448	229	1.154762	2.64440498	Radiomyces spectabilis	64574	Fungi	Fungi	82.4	2.61e-11	NTclustered	gi\|2323725249\|ref\|XM_051568020.1\|	64574	g26215	i0	82.292	0.419213973799127	96	15	41	2	107	201	110	204	Radiomyces spectabilis DNA directed RNA polymerase (BYT42DRAFT_566782), mRNA	blastn	96	82.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis
9474421	9474421	PRJNA562549_P_NODE_38888_length_167_cov_4.320755_g38655_i0	PRJNA562549	38888	167	4.320755	7.21566085	Cokeromyces recurvatus	90255	Fungi	Fungi	128	2.26e-25	NTclustered	gi\|2324082777\|ref\|XM_051528989.1\|	90255	g38655	i0	82.759	11.0479041916168	145	23	86	2	5	148	70	213	Cokeromyces recurvatus nucleophile aminohydrolase (BX663DRAFT_519376), mRNA	blastn	1845	128	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
12024893	12024893	PRJNA562549_P_NODE_34030_length_206_cov_1.972414_g33797_i0	PRJNA562549	34030	206	1.972414	4.06317284	Lichtheimia ornata	688661	Fungi	Fungi	93.5	1.06e-14	NTclustered	gi\|2553581523\|ref\|XM_058486828.1\|	688661	g33797	i0	89.189	1.92233009708738	74	8	36	0	133	206	1131	1058	Lichtheimia ornata elongation factor 2 (O0I10_006803), partial mRNA	blastn	396	93.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
12024899	12024899	PRJNA562549_P_NODE_34570_length_205_cov_2.152778_g34337_i0	PRJNA562549	34570	205	2.152778	4.4131949	Umbelopsis ramanniana	41833	Fungi	Fungi	191	3.64e-44	NTclustered	gi\|2323683958\|ref\|XM_051593300.1\|	1314678	g34337	i0	83.744	69.2682926829268	203	31	99	2	1	202	929	1130	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_278731), partial mRNA	blastn	14200	191	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
12024912	12024912	PRJNA562549_P_NODE_35990_length_203_cov_0.915493_g35757_i0	PRJNA562549	35990	203	0.915493	1.85845079	Cokeromyces recurvatus	90255	Fungi	Fungi	137	4.75e-28	NTclustered	gi\|2324051285\|ref\|XM_051530577.1\|	90255	g35757	i0	89.72	13.8669950738916	107	11	53	0	33	139	249	143	Cokeromyces recurvatus 40S ribosomal protein S27 (BX663DRAFT_534595), mRNA	blastn	2815	137	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
14574637	14574637	PRJNA562549_P_NODE_12852_length_320_cov_1.972973_g12619_i0	PRJNA562549	12852	320	1.972973	6.3135136	Mucor mucedo	29922	Fungi	Fungi	178	4.749999999999999e-40	NTclustered	gi\|2324032010\|ref\|XM_051594527.1\|	29922	g12619	i0	83	46.540625	200	31	62	3	118	316	231	34	Mucor mucedo putative 60S ribosomal protein L27A (EV154DRAFT_236615), mRNA	blastn	14893	178	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
17123573	17123573	PRJNA562549_P_NODE_6534_length_451_cov_2.205128_g6301_i0	PRJNA562549	6534	451	2.205128	9.94512728	Mycotypha africana	64632	Fungi	Fungi	241	8.69e-59	NTclustered	gi\|2432570989\|ref\|XM_053081936.1\|	64632	g6301	i0	80.769	34.5077605321508	312	56	69	4	4	313	448	139	Mycotypha africana 40S ribosomal protein S5 (BDF20DRAFT_885445), partial mRNA	blastn	15563	241	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
18397587	18397587	PRJNA562549_P_NODE_17895_length_273_cov_3.004717_g17662_i0	PRJNA562549	17895	273	3.004717	8.20287741	Mucor mucedo	29922	Fungi	Fungi	200	8.459999999999999e-47	NTclustered	gi\|2324048348\|ref\|XM_051601164.1\|	29922	g17662	i0	80.46	18.9267399267399	261	51	96	0	9	269	296	36	Mucor mucedo 60S ribosomal protein L10-A (EV154DRAFT_505364), mRNA	blastn	5167	200	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor mucedo
20947846	20947846	PRJNA562549_P_NODE_2217_length_739_cov_3.297935_g2103_i0	PRJNA562549	2217	739	3.297935	24.37173965	Lichtheimia ornata	688661	Fungi	Fungi	475	3.7099999999999996e-129	NTclustered	gi\|2553601477\|ref\|XM_058490975.1\|	688661	g2103	i0	79.622	92.6535859269283	687	120	92	16	3	679	872	196	Lichtheimia ornata ADP,ATP carrier protein, mitochondrial (O0I10_011002), partial mRNA	blastn	68471	475	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
20947939	20947939	PRJNA562549_P_NODE_34417_length_206_cov_0.896552_g34184_i0	PRJNA562549	34417	206	0.896552	1.84689712	Rhizomucor pusillus	4840	Fungi	Fungi	148	2.2299999999999996e-31	NTclustered	gi\|2837716112\|ref\|XM_069385268.1\|	4840	g34184	i0	81.667	18.4708737864078	180	31	87	2	25	203	244	422	Rhizomucor pusillus uncharacterized protein (VTP01DRAFT_6374), partial mRNA	blastn	3805	148	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
22222750	22222750	PRJNA562549_P_NODE_21258_length_253_cov_1.250000_g21025_i0	PRJNA562549	21258	253	1.25	3.1625	Mucor velutinosus	708070	Fungi	Fungi	174	4.7e-39	NTclustered	gi\|2724947137\|ref\|XM_064831374.1\|	708070	g21025	i0	83.077	40.0474308300395	195	29	76	4	1	193	260	68	Mucor velutinosus SNF1-interacting protein (SIP5_3), partial mRNA	blastn	10132	174	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
22222769	22222769	PRJNA562549_P_NODE_23938_length_239_cov_2.971910_g23705_i0	PRJNA562549	23938	239	2.97191	7.1028649	Rhizophagus irregularis	588596	Fungi	Fungi	198	2.61e-46	NTclustered	gi\|2749802616\|ref\|XM_025309599.2\|	588596	g23705	i0	82.051	50.8995815899582	234	40	97	2	1	233	510	278	Rhizophagus irregularis 60S ribosomal protein uL16 (OCT59_006484), mRNA	blastn	12165	198	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
22222792	22222792	PRJNA562549_P_NODE_26978_length_227_cov_1.174699_g26745_i0	PRJNA562549	26978	227	1.174699	2.66656673	Lichtheimia ornata	688661	Fungi	Fungi	198	2.45e-46	NTclustered	gi\|2553562003\|ref\|XM_058483396.1\|	688661	g26745	i0	82.805	33.5462555066079	221	38	97	0	7	227	903	683	Lichtheimia ornata ATP synthase subunit alpha, mitochondrial (O0I10_003325), partial mRNA	blastn	7615	198	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
22222852	22222852	PRJNA562549_P_NODE_32778_length_209_cov_0.878378_g32545_i0	PRJNA562549	32778	209	0.878378	1.83581002	Mycotypha africana	64632	Fungi	Fungi	206	1.3299999999999998e-48	NTclustered	gi\|2432559510\|ref\|XM_053076877.1\|	64632	g32545	i0	88.304	94.822966507177	171	20	82	0	33	203	228	58	Mycotypha africana ubiquitin-60S ribosomal protein L40 (BDF20DRAFT_813442), partial mRNA	blastn	19818	206	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
22222911	22222911	PRJNA562549_P_NODE_5438_length_495_cov_3.274194_g5208_i0	PRJNA562549	5438	495	3.274194	16.2072603	Rhizopus arrhizus	64495	Fungi	Fungi	436	1.14e-117	NTclustered	gi\|2021117350\|gb\|MW160453.1\|	64495	g5208	i0	82.992	92.9171717171717	488	77	98	6	11	495	154	638	Rhizopus arrhizus isolate MRR-110 translation elongation factor (TEF) gene, partial cds	blastn	45994	436	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus arrhizus
25357247	25357247	PRJNA562549_P_NODE_38420_length_182_cov_4.347107_g38187_i0	PRJNA562549	38420	182	4.347107	7.91173474	Rhizopus	4842	Fungi	Fungi	117	5.41e-22	NTclustered	gi\|2797479583\|ref\|XM_067668854.1\|	246409	g38187	i0	83.465	17.4065934065934	127	20	69	1	39	164	21	147	Rhizopus delemar RA 99-880 60S ribosomal protein uL18 (RO3G_14270), partial mRNA	blastn	3168	117	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar

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