metadata: contig_metadata: 9 rows where bioproject = "PRJNA685060", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA685060", 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
10870161	10870161	PRJNA685060_P_NODE_15889_length_245_cov_0.895349_g15799_i0	PRJNA685060	15889	245	0.895349	2.19360505	Lichtheimia ornata	688661	Fungi	Fungi	56.5	0.002	NTclustered	gi\|2553573551\|ref\|XM_058485423.1\|	688661	g15799	i0	94.595	3.28979591836735	37	0	14	2	182	216	82	118	Lichtheimia ornata uncharacterized protein (O0I10_005378), partial mRNA	blastn	806	56.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
12145524	12145524	PRJNA685060_P_NODE_3650_length_512_cov_2.166287_g3560_i0	PRJNA685060	3650	512	2.166287	11.09138944	Lobosporangium transversale	64571	Fungi	Fungi	60.2	3e-4	NTclustered	gi\|1227136130\|ref\|XM_022023699.1\|	64571	g3560	i0	100	6.390625	32	0	6	0	302	333	320	289	Lobosporangium transversale hypothetical protein (BCR41DRAFT_350907), mRNA	blastn	3272	60.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Lobosporangium	Lobosporangium transversale
17244177	17244177	PRJNA685060_P_NODE_8134_length_333_cov_1.392308_g8044_i0	PRJNA685060	8134	333	1.392308	4.63638564	Halteromyces radiatus	101107	Fungi	Fungi	231	3.76e-56	NTclustered	gi\|2323758168\|ref\|XM_051548927.1\|	101107	g8044	i0	83.534	21.3183183183183	249	39	74	2	66	313	275	28	Halteromyces radiatus rac protein (BX664DRAFT_380874), mRNA	blastn	7099	231	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
27050669	27050669	PRJNA685060_P_NODE_2482_length_628_cov_1.360360_g2393_i0	PRJNA685060	2482	628	1.36036	8.5430608	Helicostylum pulchrum	562976	Fungi	Fungi	66.6	6.71e-9	NR	GAA5806006.1	562976	g2393	i0	40.2	0.535031847133758	112	59	53.5	3	604	269	1	104	GAA5806006.1 hypothetical protein HPULCUR_011534 [Helicostylum pulchrum]	diamond	336	66.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Helicostylum	Helicostylum pulchrum
27851778	27851778	PRJNA685060_P_NODE_12484_length_262_cov_1.465608_g12394_i0	PRJNA685060	12484	262	1.465608	3.83989296	Rhizophagus	295919	Fungi	Fungi	62	3.15e-9	NR	GBC08139.1	94130	g12394	i0	34.8	5.00381679389313	69	44	77.9	1	229	26	109	177	GBC08139.1 hypothetical protein RclHR1_07920014 [Rhizophagus clarus]	diamond	1311	62	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
30240218	30240218	PRJNA685060_P_NODE_12732_length_258_cov_2.362162_g12642_i0	PRJNA685060	12732	258	2.362162	6.09437796	Calcarisporiella thermophila	911321	Fungi	Fungi	47	0.00144	NR	XP_069247853.1	911321	g12642	i0	40.4	0.604651162790698	52	31	60.5	0	44	199	91	142	XP_069247853.1 uncharacterized protein VTP21DRAFT_5772 [Calcarisporiella thermophila]	diamond	156	47	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota		Calcarisporiellales	Calcarisporiellaceae	Calcarisporiella	Calcarisporiella thermophila
30840542	30840542	PRJNA685060_P_NODE_6214_length_383_cov_1.974194_g6124_i0	PRJNA685060	6214	383	1.974194	7.56116302	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	43.1	0.044	NR	EXX62412.1	1432141	g6124	i0	30.2	1.56657963446475	96	63	72.1	2	73	348	39	134	EXX62412.1 hypothetical protein RirG_162000 [Rhizophagus irregularis DAOM 197198w]	diamond	600	43.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
30903781	30903781	PRJNA685060_P_NODE_8354_length_329_cov_1.136719_g8264_i0	PRJNA685060	8354	329	1.136719	3.73980551	Gamsiella multidivaricata	101098	Fungi	Fungi	57.4	7.31e-7	NR	KAG0362196.1	101098	g8264	i0	42.3	1.27659574468085	71	36	64.7	1	329	117	80	145	KAG0362196.1 hypothetical protein BGZ54_008717 [Gamsiella multidivaricata]	diamond	420	57.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
31093254	31093254	PRJNA685060_P_NODE_12215_length_266_cov_1.062176_g12125_i0	PRJNA685060	12215	266	1.062176	2.82538816	Cunninghamella echinulata	76405	Fungi	Fungi	65.9	3.33e-10	NR	KAI9303194.1	76405	g12125	i0	72.5	1.62406015037594	40	11	45.1	0	146	265	1	40	KAI9303194.1 tyrosyl-tRNA synthetase [Cunninghamella echinulata]	diamond	432	65.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata

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