metadata: contig_metadata: 10 rows where bioproject = "PRJNA415856", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA415856", 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
16385857	16385857	PRJNA415856_P_NODE_26853_length_180_cov_1.183206_g26592_i0	PRJNA415856	26853	180	1.183206	2.1297708	Mucorales	4827	Fungi	Fungi	327	2.2699999999999996e-85	NTclustered	gi\|746818059\|gb\|KM527228.1\|	4843	g26592	i0	99.444	100	180	1	100	0	1	180	1114	935	Rhizopus microsporus var. chinensis isolate FJ-M-2 18S ribosomal RNA gene, partial sequence	blastn	18000	327	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
27440140	27440140	PRJNA415856_P_NODE_23283_length_187_cov_0.833333_g23022_i0	PRJNA415856	23283	187	0.833333	1.55833271	Fungi	4751	Fungi	Fungi	110	2.03e-27	NR	PKY49347.1	588596	g23022	i0	77	6.80213903743315	61	14	97.9	0	186	4	189	249	PKY49347.1 guanine nucleotide-binding protein, beta subunit [Rhizophagus irregularis]	diamond	1272	110	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
27850157	27850157	PRJNA415856_P_NODE_11924_length_254_cov_0.995122_g11663_i0	PRJNA415856	11924	254	0.995122	2.52760988	Entrophospora	27375	Fungi	Fungi	62.8	7.42e-10	NR	CAG8524434.1	984092	g11663	i0	58.3	1.7007874015748	48	20	56.7	0	254	111	48	95	CAG8524434.1 1261_t:CDS:2 [Entrophospora candida]	diamond	432	62.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora candida
29285944	29285944	PRJNA415856_P_NODE_13509_length_236_cov_2.171123_g13248_i0	PRJNA415856	13509	236	2.171123	5.12385028	Circinella minor	1195481	Fungi	Fungi	57.4	2.35e-7	NR	KAG2223992.1	1195481	g13248	i0	39	2.50423728813559	82	37	89	2	236	27	398	478	KAG2223992.1 hypothetical protein INT45_013449 [Circinella minor]	diamond	591	57.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Circinella	Circinella minor
30692446	30692446	PRJNA415856_P_NODE_34233_length_168_cov_1.285714_g33972_i0	PRJNA415856	34233	168	1.285714	2.15999952	Eukaryota	2759	Fungi	Fungi	102	1.36e-23	NR	CAG8786830.1	4874	g33972	i0	80.4	32	56	11	100	0	1	168	334	389	CAG8786830.1 15546_t:CDS:2, partial [Gigaspora margarita]	diamond	5376	102	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
31687393	31687393	PRJNA415856_P_NODE_20537_length_193_cov_1.770833_g20276_i0	PRJNA415856	20537	193	1.770833	3.41770769	Mortierella sp. GBA43	1896190	Fungi	Fungi	63.5	3.1e-10	NR	KAG0245583.1	1896190	g20276	i0	49.2	0.948186528497409	61	31	94.8	0	192	10	65	125	KAG0245583.1 hypothetical protein BGX31_007100 [Mortierella sp. GBA43]	diamond	183	63.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella sp. GBA43
31750571	31750571	PRJNA415856_P_NODE_38517_length_166_cov_0.871795_g38256_i0	PRJNA415856	38517	166	0.871795	1.4471797	Halteromyces radiatus	101107	Fungi	Fungi	61.6	2.76e-9	NR	XP_051400543.1	101107	g38256	i0	65.9	0.740963855421687	41	14	74.1	0	42	164	174	214	XP_051400543.1 replication factor-a protein 1 [Halteromyces radiatus]	diamond	123	61.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
32415268	32415268	PRJNA415856_P_NODE_50019_length_162_cov_0.902655_g49758_i0	PRJNA415856	50019	162	0.902655	1.4623011	Rhizopus delemar	936053	Fungi	Fungi	110	2.41e-26	NR	KAG1468282.1	936053	g49758	i0	92.6	2	54	4	100	0	162	1	272	325	KAG1468282.1 hypothetical protein G6F56_003920 [Rhizopus delemar]	diamond	324	110	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
32558602	32558602	PRJNA415856_P_NODE_6719_length_362_cov_1.817891_g6458_i0	PRJNA415856	6719	362	1.817891	6.58076542	Rhizopus	4842	Fungi	Fungi	54.7	9.22e-6	NR	CEG75764.1	58291	g6458	i0	58.5	1.69060773480663	41	15	34	1	1	123	363	401	CEG75764.1 hypothetical protein RMATCC62417_10756 [Rhizopus microsporus]	diamond	612	54.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
32667662	32667662	PRJNA415856_P_NODE_12280_length_249_cov_1.955000_g12019_i0	PRJNA415856	12280	249	1.955	4.8679500000000004	Ambispora leptoticha	144679	Fungi	Fungi	60.5	2.01e-8	NR	CAG8568407.1	144679	g12019	i0	50	0.698795180722892	58	29	69.9	0	244	71	263	320	CAG8568407.1 14142_t:CDS:2 [Ambispora leptoticha]	diamond	174	60.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora leptoticha

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