metadata: contig_metadata: 14 rows where bioproject = "PRJNA188516" and tax

14 rows where bioproject = "PRJNA188516" 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
6743482	6743482	PRJNA188516_P_NODE_3826_length_173_cov_1.258065_g3776_i0	PRJNA188516	3826	173	1.258065	2.17645245	Cokeromyces recurvatus	90255	Fungi	Fungi	119	1.4100000000000001e-22	NTclustered	gi\|2324052953\|ref\|XM_051525900.1\|	90255	g3776	i0	87.5	0.601156069364162	104	11	60	2	69	171	608	506	Cokeromyces recurvatus uncharacterized protein (BX663DRAFT_497341), partial mRNA	blastn	104	119	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Cokeromyces	Cokeromyces recurvatus
10569831	10569831	PRJNA188516_P_NODE_1549_length_290_cov_1.481328_g1499_i0	PRJNA188516	1549	290	1.481328	4.2958512	Rhizopus microsporus	58291	Fungi	Fungi	217	9e-52	NTclustered	gi\|1331189772\|ref\|XM_023607192.1\|	1340429	g1499	i0	84.977	19.8758620689655	213	32	73	0	1	213	209	421	Rhizopus microsporus ATCC 52813 uncharacterized protein (RHIMIDRAFT_211203), mRNA	blastn	5764	217	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus microsporus
14394906	14394906	PRJNA188516_P_NODE_4592_length_167_cov_0.881356_g4542_i0	PRJNA188516	4592	167	0.881356	1.47186452	Radiomyces spectabilis	64574	Fungi	Fungi	169	1.33e-37	NTclustered	gi\|2323733830\|ref\|XM_051572657.1\|	64574	g4542	i0	85.119	6.35329341317365	168	21	99	4	1	166	313	148	Radiomyces spectabilis ribosomal S17-domain-containing protein (BYT42DRAFT_645550), partial mRNA	blastn	1061	169	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis
19491829	19491829	PRJNA188516_P_NODE_5856_length_163_cov_0.912281_g5806_i0	PRJNA188516	5856	163	0.912281	1.48701803	Rhizophagus irregularis	588596	Fungi	Fungi	82.4	1.73e-11	NTclustered	gi\|2749812207\|ref\|XM_025310519.2\|	588596	g5806	i0	80.769	0.895705521472393	104	20	64	0	60	163	627	730	Rhizophagus irregularis uncharacterized protein (OCT59_013130), partial mRNA	blastn	146	82.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
26838822	26838822	PRJNA188516_P_NODE_6241_length_152_cov_2.019417_g6191_i0	PRJNA188516	6241	152	2.019417	3.06951384	Fungi	4751	Fungi	Fungi	58.5	3.77e-9	NR	RCH92629.1	4846	g6191	i0	61.4	11.5855263157895	44	17	86.8	0	136	5	4	47	RCH92629.1 40S ribosomal protein S19, partial [Rhizopus stolonifer]	diamond	1761	58.9	0.99320882852292	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
26852690	26852690	PRJNA188516_P_NODE_2701_length_208_cov_1.308176_g2651_i0	PRJNA188516	2701	208	1.308176	2.72100608	Umbelopsis ramanniana AG	1314678	Fungi	Fungi	48.5	6.36e-5	NR	XP_051448993.1	1314678	g2651	i0	45.5	0.634615384615385	44	24	63.5	0	141	10	77	120	XP_051448993.1 uncharacterized protein K450DRAFT_220940 [Umbelopsis ramanniana AG]	diamond	132	48.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
26978998	26978998	PRJNA188516_P_NODE_6122_length_162_cov_0.920354_g6072_i0	PRJNA188516	6122	162	0.920354	1.49097348	Bifiguratus adelaidae	1938954	Fungi	Fungi	73.9	1.27e-13	NR	OZJ03382.1	1938954	g6072	i0	68.5	1.92592592592593	54	17	100	0	1	162	3	56	OZJ03382.1 hypothetical protein BZG36_04486 [Bifiguratus adelaidae]	diamond	312	73.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales		Bifiguratus	Bifiguratus adelaidae
27376526	27376526	PRJNA188516_P_NODE_2843_length_203_cov_1.103896_g2793_i0	PRJNA188516	2843	203	1.103896	2.24090888	Eukaryota	2759	Fungi	Fungi	123	2.02e-33	NR	SAM07624.1	4829	g2793	i0	83.6	15.8423645320197	67	11	99	0	1	201	3	69	SAM07624.1 hypothetical protein [Absidia glauca]	diamond	3216	124	0.991935483870968	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
28432015	28432015	PRJNA188516_P_NODE_3666_length_177_cov_1.015625_g3616_i0	PRJNA188516	3666	177	1.015625	1.79765625	Diversispora epigaea	1348612	Fungi	Fungi	59.3	2.08e-8	NR	RHZ80632.1	1348612	g3616	i0	53.4	4.86440677966102	58	26	98.3	1	175	2	169	225	RHZ80632.1 hypothetical protein Glove_134g256 [Diversispora epigaea]	diamond	861	59.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora epigaea
28670891	28670891	PRJNA188516_P_NODE_1867_length_255_cov_2.019417_g1817_i0	PRJNA188516	1867	255	2.019417	5.14951335	Mucoraceae	34489	Fungi	Fungi	76.3	4.44e-15	NR	KAI9483561.1	64631	g1817	i0	60.6	12.0588235294118	66	25	77.6	1	58	255	51	115	KAI9483561.1 MAG: ribosomal protein L23/L15e core domain-containing protein, partial [Benjaminiella poitrasii]	diamond	3075	76.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Benjaminiella	Benjaminiella poitrasii
29807305	29807305	PRJNA188516_P_NODE_5711_length_163_cov_0.912281_g5661_i0	PRJNA188516	5711	163	0.912281	1.48701803	Eukaryota	2759	Fungi	Fungi	83.6	3.38e-17	NR	KAG0086219.1	979697	g5661	i0	71.7	16.5828220858896	53	15	97.5	0	161	3	285	337	KAG0086219.1 regulator of ime2 [Podila epicladia]	diamond	2703	83.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Podila	Podila epicladia
32192106	32192106	PRJNA188516_P_NODE_5758_length_163_cov_0.912281_g5708_i0	PRJNA188516	5758	163	0.912281	1.48701803	Mortierella sp. NVP85	1896193	Fungi	Fungi	75.5	3.16e-14	NR	KAF9355909.1	1896193	g5708	i0	65.3	3.79141104294479	49	17	90.2	0	17	163	192	240	KAF9355909.1 protein disulfide-isomerase precursor, partial [Mortierella sp. NVP85]	diamond	618	75.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella sp. NVP85
32558148	32558148	PRJNA188516_P_NODE_4579_length_167_cov_0.881356_g4529_i0	PRJNA188516	4579	167	0.881356	1.47186452	Fungi	4751	Fungi	Fungi	69.3	1.07e-12	NR	GES75909.1	94130	g4529	i0	61.2	3.48502994011976	49	19	88	0	156	10	1	49	GES75909.1 DUF962 domain protein [Rhizophagus clarus]	diamond	582	69.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
32854954	32854954	PRJNA188516_P_NODE_6080_length_162_cov_0.920354_g6030_i0	PRJNA188516	6080	162	0.920354	1.49097348	Modicella reniformis	1440133	Fungi	Fungi	52	6.22e-6	NR	KAF9937811.1	1440133	g6030	i0	63.8	4.33333333333333	47	17	87	0	20	160	77	123	KAF9937811.1 H(+)-transporting V0 sector ATPase subunit a [Modicella reniformis]	diamond	702	52	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Modicella	Modicella reniformis

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