metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA788929" 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
8867242	8867242	PRJNA788929_P_NODE_13967_length_455_cov_65.659686_g13309_i0	PRJNA788929	13967	455	65.659686	298.7515713	Lichtheimia hyalospora FSU 1	420593	Fungi	Fungi	123	1.87e-33	NR	KAI7884401.1	1314789	g13309	i0	69.5	1.62197802197802	82	25	54.1	0	392	147	1	82	KAI7884401.1 putative acyl-coA-binding protein [Lichtheimia hyalospora FSU 10163]	diamond	738	123	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia hyalospora
14798004	14798004	PRJNA788929_P_NODE_3312_length_1137_cov_22.437030_g2904_i0	PRJNA788929	3312	1137	22.43703	255.1090311	Blakeslea trispora	4850	Fungi	Fungi	65.9	1.14e-7	NR	KAI8343816.1	4850	g2904	i0	25.6	1.02374670184697	195	123	49.9	5	876	310	6	184	KAI8343816.1 kinase-like domain-containing protein [Blakeslea trispora]	diamond	1164	65.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Blakeslea	Blakeslea trispora
16072203	16072203	PRJNA788929_P_NODE_6553_length_745_cov_42.848214_g5932_i0	PRJNA788929	6553	745	42.848214	319.2191943	Fungi	4751	Fungi	Fungi	374	5.69e-127	NR	KAG9301733.1	50956	g5932	i0	71.6	30.8214765100671	236	67	95	0	2	709	117	352	KAG9301733.1 hypothetical protein G9A89_003279 [Geosiphon pyriformis]	diamond	22962	374	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
26904831	26904831	PRJNA788929_P_NODE_8301_length_640_cov_54.768959_g7654_i0	PRJNA788929	8301	640	54.768959	350.5213376	Mucorales	4827	Fungi	Fungi	80.5	6.51e-14	NR	KAF1798820.1	29924	g7654	i0	28.3	2.38125	127	90	59.1	1	609	232	8	134	KAF1798820.1 C2 domain-containing protein [Mucor lusitanicus]	diamond	1524	80.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor lusitanicus
27085371	27085371	PRJNA788929_P_NODE_22102_length_345_cov_47.525735_g21441_i0	PRJNA788929	22102	345	47.525735	163.96378575	Calcarisporiella thermophila	911321	Fungi	Fungi	57.8	6.36e-7	NR	XP_069252591.1	911321	g21441	i0	45.6	0.495652173913044	57	30	48.7	1	335	168	446	502	XP_069252591.1 uncharacterized protein VTP21DRAFT_11041 [Calcarisporiella thermophila]	diamond	171	57.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
28095995	28095995	PRJNA788929_P_NODE_18105_length_388_cov_16.269841_g17445_i0	PRJNA788929	18105	388	16.269841	63.12698308	Funneliformis mosseae	27381	Fungi	Fungi	58.5	1.92e-8	NR	CAG8456823.1	27381	g17445	i0	42.6	0.471649484536082	61	35	47.2	0	259	77	20	80	CAG8456823.1 11423_t:CDS:2 [Funneliformis mosseae]	diamond	183	58.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Funneliformis	Funneliformis mosseae
29359019	29359019	PRJNA788929_P_NODE_22109_length_345_cov_30.047794_g21448_i0	PRJNA788929	22109	345	30.047794	103.6648893	Syncephalastrum racemosum	13706	Fungi	Fungi	101	5.47e-25	NR	ORZ02435.1	13706	g21448	i0	56.4	2.66086956521739	78	34	67.8	0	302	69	1	78	ORZ02435.1 cytochrome b5 [Syncephalastrum racemosum]	diamond	918	101	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
30116777	30116777	PRJNA788929_P_NODE_2232_length_1409_cov_41.976048_g1947_i0	PRJNA788929	2232	1409	41.976048	591.44251632	Glomus cerebriforme	658196	Fungi	Fungi	73.9	2.27e-10	NR	RIA88837.1	658196	g1947	i0	31.7	0.396025550035486	186	105	36	6	664	1170	59	239	RIA88837.1 hypothetical protein C1645_825714 [Glomus cerebriforme]	diamond	558	73.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
30179951	30179951	PRJNA788929_P_NODE_10432_length_550_cov_29.538784_g9779_i0	PRJNA788929	10432	550	29.538784	162.463312	Lichtheimia ramosa	688394	Fungi	Fungi	152	1.04e-43	NR	CDS11815.1	688394	g9779	i0	53.4	5.06181818181818	131	61	71.5	0	56	448	5	135	CDS11815.1 hypothetical protein LRAMOSA11459 [Lichtheimia ramosa]	diamond	2784	152	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ramosa
30275147	30275147	PRJNA788929_P_NODE_36272_length_257_cov_4.869565_g35611_i0	PRJNA788929	36272	257	4.869565	12.51478205	Apophysomyces ossiformis	679940	Fungi	Fungi	69.3	1.97e-11	NR	KAF7730393.1	679940	g35611	i0	52.4	2.18287937743191	63	20	70	2	201	22	17	72	KAF7730393.1 hypothetical protein EC973_002199 [Apophysomyces ossiformis]	diamond	561	69.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Apophysomyces	Apophysomyces ossiformis
31295211	31295211	PRJNA788929_P_NODE_3075_length_1188_cov_60.626906_g2683_i0	PRJNA788929	3075	1188	60.626906	720.24764328	Fungi	4751	Fungi	Fungi	123	8.15e-28	NR	KAG2196449.1	97098	g2683	i0	28.1	4.44949494949495	320	224	79.5	4	1123	179	24	342	KAG2196449.1 hypothetical protein INT46_011826 [Mucor plumbeus]	diamond	5286	124	0.991935483870968	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor plumbeus
31602470	31602470	PRJNA788929_P_NODE_10516_length_547_cov_46.253165_g9863_i0	PRJNA788929	10516	547	46.253165	253.00481255	Umbelopsis isabellina	91625	Fungi	Fungi	68.2	9.74e-10	NR	KAG2181349.1	91625	g9863	i0	29.8	1.36014625228519	121	84	66.4	1	509	147	62	181	KAG2181349.1 hypothetical protein INT43_008932 [Umbelopsis isabellina]	diamond	744	68.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
31791877	31791877	PRJNA788929_P_NODE_3857_length_1047_cov_34.814168_g3389_i0	PRJNA788929	3857	1047	34.814168	364.50433896	Entomortierella parvispora	205924	Fungi	Fungi	254	2.69e-78	NR	GJJ77692.1	205924	g3389	i0	47.1	0.98567335243553	344	155	92.3	7	975	10	1	339	GJJ77692.1 26S proteasome regulatory subunit N10 [Entomortierella parvispora]	diamond	1032	254	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Entomortierella	Entomortierella parvispora
31855291	31855291	PRJNA788929_P_NODE_45497_length_226_cov_18.006536_g44836_i0	PRJNA788929	45497	226	18.006536	40.69477136	Gongronella butleri	101105	Fungi	Fungi	41.6	0.0485	NR	KAI8070007.1	101105	g44836	i0	58.5	0.544247787610619	41	13	53.1	2	24	143	111	148	KAI8070007.1 ubiquitin-related domain-containing protein [Gongronella butleri]	diamond	123	41.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri

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