metadata: contig_metadata: 11 rows where bioproject = "PRJNA690234", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA690234", 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
670165	670165	PRJNA690234_P_NODE_22521_length_267_cov_2.139175_g22154_i0	PRJNA690234	22521	267	2.139175	5.71159725	Rhizopus delemar	936053	Fungi	Fungi	291	4.76e-74	NTclustered	gi\|2797462587\|ref\|XM_067662381.1\|	246409	g22154	i0	100	0.857677902621723	157	0	86	0	1	157	177	333	Rhizopus delemar RA 99-880 uncharacterized protein (RO3G_07791), partial mRNA	blastn	229	291	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
1178857	1178857	PRJNA690234_P_NODE_29801_length_245_cov_0.906977_g29434_i0	PRJNA690234	29801	245	0.906977	2.22209365	root	1	Root_unresolved	Root_unresolved	150	1.9599999999999993e-43	NR	KAL0080976.1	4837	g29434	i0	88	398.314285714286	75	9	91.8	0	21	245	63	137	KAL0080976.1 P-loop containing nucleoside triphosphate hydrolase protein [Phycomyces blakesleeanus]	diamond	97587	151	0.993377483443709	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
6282900	6282900	PRJNA690234_P_NODE_9745_length_409_cov_1.544643_g9379_i0	PRJNA690234	9745	409	1.544643	6.31758987	Mucor saturninus	64648	Fungi	Fungi	134	3.75e-37	NR	KAG2205431.1	64648	g9379	i0	81.9	21.4327628361858	72	13	52.8	0	193	408	41	112	KAG2205431.1 hypothetical protein INT47_007216 [Mucor saturninus]	diamond	8766	134	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor saturninus
10874525	10874525	PRJNA690234_P_NODE_8089_length_451_cov_1.748677_g7723_i0	PRJNA690234	8089	451	1.748677	7.88653327	Opisthokonta	33154	Fungi	Fungi	232	1.05e-71	NR	ORY93484.1	13706	g7723	i0	74.7	111.718403547672	150	38	99.8	0	450	1	73	222	ORY93484.1 RuvB-like 1 [Syncephalastrum racemosum]	diamond	50385	234	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum
13424254	13424254	PRJNA690234_P_NODE_5031_length_582_cov_2.117878_g4669_i0	PRJNA690234	5031	582	2.117878	12.32604996	Mucoromycota	1913637	Fungi	Fungi	248	1.66e-78	NR	XP_051434240.1	101096	g4669	i0	59.6	51.1288659793814	193	77	99	1	4	579	19	211	XP_051434240.1 casein kinase II subunit alpha [Gilbertella persicaria]	diamond	29757	248	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Gilbertella	Gilbertella persicaria
21072488	21072488	PRJNA690234_P_NODE_18197_length_297_cov_1.616071_g17830_i0	PRJNA690234	18197	297	1.616071	4.79973087	Opisthokonta	33154	Fungi	Fungi	137	3.79e-39	NR	SAM04040.1	4829	g17830	i0	75.3	37.4646464646465	81	20	81.8	0	3	245	67	147	SAM04040.1 hypothetical protein [Absidia glauca]	diamond	11127	137	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
27820520	27820520	PRJNA690234_P_NODE_8104_length_451_cov_1.365079_g7738_i0	PRJNA690234	8104	451	1.365079	6.15650629	Opisthokonta	33154	Fungi	Fungi	90.1	9.81e-18	NR	XP_069237795.1	4840	g7738	i0	46	5.05543237250554	100	54	66.5	0	150	449	293	392	XP_069237795.1 uncharacterized protein VTP01DRAFT_2292 [Rhizomucor pusillus]	diamond	2280	90.5	0.995580110497237	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus
30556120	30556120	PRJNA690234_P_NODE_10893_length_386_cov_1.076677_g10527_i0	PRJNA690234	10893	386	1.076677	4.15597322	Acaulospora morrowiae	94023	Fungi	Fungi	89	1.26e-17	NR	CAG8554240.1	94023	g10527	i0	51.2	0.66839378238342	86	39	66.8	1	7	264	121	203	CAG8554240.1 18674_t:CDS:10 [Acaulospora morrowiae]	diamond	258	89	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Acaulosporaceae	Acaulospora	Acaulospora morrowiae
31915674	31915674	PRJNA690234_P_NODE_4157_length_645_cov_2.666084_g3802_i0	PRJNA690234	4157	645	2.666084	17.1962418	Rhizophagus sp. MUCL 43196	1803374	Fungi	Fungi	46.2	0.0359	NR	RGB29650.1	1803374	g3802	i0	34.3	0.46046511627907	99	51	45.1	4	362	72	24	110	RGB29650.1 hypothetical protein C1646_672286 [Rhizophagus diaphanus] [Rhizophagus sp. MUCL 43196]	diamond	297	46.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus sp. MUCL 43196
32042284	32042284	PRJNA690234_P_NODE_18678_length_293_cov_1.418182_g18311_i0	PRJNA690234	18678	293	1.418182	4.15527326	Phycomyces blakesleeanus NRRL 1555(-)	763407	Fungi	Fungi	85.1	4.22e-17	NR	XP_018295146.1	763407	g18311	i0	59.7	2.80546075085324	67	27	68.6	0	201	1	54	120	XP_018295146.1 hypothetical protein PHYBLDRAFT_40396 [Phycomyces blakesleeanus NRRL 1555(-)]	diamond	822	85.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
32748920	32748920	PRJNA690234_P_NODE_8180_length_448_cov_6.728000_g7814_i0	PRJNA690234	8180	448	6.728	30.14144	Fungi	4751	Fungi	Fungi	133	1.91e-36	NR	XP_069242933.1	4840	g7814	i0	48.4	91.8415178571429	128	66	85.7	0	28	411	48	175	XP_069242933.1 uncharacterized protein VTP01DRAFT_6560 [Rhizomucor pusillus]	diamond	41145	134	0.992537313432836	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Rhizomucor	Rhizomucor pusillus

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