metadata: contig_metadata: 12 rows where bioproject = "PRJNA352610", tax_kingdom = "Fungi" and tax

12 rows where bioproject = "PRJNA352610", tax_kingdom = "Fungi" 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
27169387	27169387	PRJNA352610_P_NODE_5602_length_459_cov_1.196891_g5541_i0	PRJNA352610	5602	459	1.196891	5.49372969	Rhizopus delemar	936053	Fungi	Fungi	48.1	0.00359	NR	KAG1055460.1	936053	g5541	i0	32	1.79738562091503	75	49	47.7	1	437	219	23	97	KAG1055460.1 hypothetical protein G6F43_002580 [Rhizopus delemar]	diamond	825	48.5	0.991752577319588	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
29001527	29001527	PRJNA352610_P_NODE_3168_length_568_cov_2.682828_g3107_i0	PRJNA352610	3168	568	2.682828	15.23846304	Rhizomucor pusillus	4840	Fungi	Fungi	78.2	3.7e-13	NR	XP_069237176.1	4840	g3107	i0	34.9	1.25704225352113	126	77	66.5	3	497	120	13	133	XP_069237176.1 uncharacterized protein VTP01DRAFT_2400 [Rhizomucor pusillus]	diamond	714	78.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
29270724	29270724	PRJNA352610_P_NODE_31569_length_241_cov_1.351190_g31508_i0	PRJNA352610	31569	241	1.35119	3.2563679	root	1	Root_unresolved	Root_unresolved	62.8	3.27e-9	NR	KAG0043057.1	979690	g31508	i0	42.4	4.40663900414938	66	38	82.2	0	202	5	1311	1376	KAG0043057.1 hypothetical protein BGZ83_011888, partial [Gryganskiella cystojenkinii]	diamond	1062	62.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gryganskiella	Gryganskiella cystojenkinii
29807550	29807550	PRJNA352610_P_NODE_13111_length_332_cov_1.826255_g13050_i0	PRJNA352610	13111	332	1.826255	6.0631666	Fungi	4751	Fungi	Fungi	64.7	1.92e-9	NR	XP_069237176.1	4840	g13050	i0	34	1.68975903614458	97	60	87.7	2	1	291	36	128	XP_069237176.1 uncharacterized protein VTP01DRAFT_2400 [Rhizomucor pusillus]	diamond	561	65.1	0.993855606758833	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
29980040	29980040	PRJNA352610_P_NODE_9991_length_369_cov_1.033784_g9930_i0	PRJNA352610	9991	369	1.033784	3.81466296	Geosiphon pyriformis	50956	Fungi	Fungi	84	5.52e-16	NR	KAG9294608.1	50956	g9930	i0	37.8	1.91869918699187	119	69	93.5	2	14	358	61	178	KAG9294608.1 hypothetical protein G9A89_008087 [Geosiphon pyriformis]	diamond	708	84	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Geosiphonaceae	Geosiphon	Geosiphon pyriformis
30028894	30028894	PRJNA352610_P_NODE_26191_length_249_cov_1.750000_g26130_i0	PRJNA352610	26191	249	1.75	4.3575	Fungi	4751	Fungi	Fungi	57.4	1.42e-7	NR	CAG8465833.1	60492	g26130	i0	39.7	4.36144578313253	68	40	80.7	1	211	11	82	149	CAG8465833.1 9155_t:CDS:2 [Racocetra fulgida]	diamond	1086	57.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Racocetra	Racocetra fulgida
30597345	30597345	PRJNA352610_P_NODE_12853_length_335_cov_1.324427_g12792_i0	PRJNA352610	12853	335	1.324427	4.43683045	Lichtheimia	688353	Fungi	Fungi	90.9	1.29e-18	NR	CDS03064.1	688394	g12792	i0	50	3.50149253731343	78	39	69.9	0	67	300	2	79	CDS03064.1 hypothetical protein LRAMOSA00466 [Lichtheimia ramosa]	diamond	1173	90.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ramosa
30706627	30706627	PRJNA352610_P_NODE_9654_length_374_cov_1.013289_g9593_i0	PRJNA352610	9654	374	1.013289	3.78970086	Cetraspora pellucida	1433469	Fungi	Fungi	81.3	2.57e-15	NR	CAG8616391.1	1433469	g9593	i0	32.7	0.786096256684492	98	63	78.6	1	373	80	218	312	CAG8616391.1 6992_t:CDS:2 [Cetraspora pellucida]	diamond	294	81.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Cetraspora	Cetraspora pellucida
30896433	30896433	PRJNA352610_P_NODE_31194_length_242_cov_0.911243_g31133_i0	PRJNA352610	31194	242	0.911243	2.20520806	Lunasporangiospora selenospora	979761	Fungi	Fungi	65.5	3.42e-10	NR	KAF9579975.1	979761	g31133	i0	58.3	1.20247933884298	48	20	59.5	0	148	5	3	50	KAF9579975.1 tubulin alpha 1 [Lunasporangiospora selenospora]	diamond	291	65.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lunasporangiospora	Lunasporangiospora selenospora
31134289	31134289	PRJNA352610_P_NODE_30895_length_242_cov_1.183432_g30834_i0	PRJNA352610	30895	242	1.183432	2.86390544	root	1	Root_unresolved	Root_unresolved	45.1	0.00564	NR	KAF8977401.1	979712	g30834	i0	51.2	2.72727272727273	43	21	53.3	0	11	139	69	111	KAF8977401.1 palmitoyltransferase akr1 [Entomortierella lignicola]	diamond	660	45.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Entomortierella	Entomortierella lignicola
32003029	32003029	PRJNA352610_P_NODE_12678_length_337_cov_1.117424_g12617_i0	PRJNA352610	12678	337	1.117424	3.76571888	Glomus cerebriforme	658196	Fungi	Fungi	63.9	3.84e-9	NR	RIA95722.1	658196	g12617	i0	35.5	0.979228486646884	110	66	97.9	2	7	336	116	220	RIA95722.1 P-loop containing nucleoside triphosphate hydrolase protein [Glomus cerebriforme]	diamond	330	63.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Glomus	Glomus cerebriforme
32115266	32115266	PRJNA352610_P_NODE_4498_length_501_cov_0.813084_g4437_i0	PRJNA352610	4498	501	0.813084	4.07355084	Fungi	4751	Fungi	Fungi	142	3.34e-39	NR	KAI8597479.1	979620	g4437	i0	56.7	5.91017964071856	141	53	83.8	5	500	81	66	199	KAI8597479.1 putative calmodulin [Dissophora ornata]	diamond	2961	142	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Dissophora	Dissophora ornata

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