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

10 rows where bioproject = "PRJNA938397", 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
2531667	2531667	PRJNA938397_S_NODE_10902_length_324_cov_90.425087_g10661_i0	PRJNA938397	10902	324	90.425087	292.97728188	Mucorales	4827	Fungi	Fungi	174	6.23e-39	NTclustered	gi\|2724932641\|ref\|XM_064824717.1\|	708070	g10661	i0	80.435	47.3641975308642	230	43	71	2	82	310	295	67	Mucor velutinosus uncharacterized protein (ATC70_005429), partial mRNA	blastn	15346	174	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Mucor	Mucor velutinosus
26644903	26644903	PRJNA938397_S_NODE_33341_length_191_cov_2.837662_g33100_i0	PRJNA938397	33341	191	2.837662	5.41993442	Circinella minor	1195481	Fungi	Fungi	64.7	3.33e-10	NR	KAG2225944.1	1195481	g33100	i0	59.3	2.52879581151832	54	22	84.8	0	8	169	615	668	KAG2225944.1 hypothetical protein INT45_006640 [Circinella minor]	diamond	483	64.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Circinella	Circinella minor
27727408	27727408	PRJNA938397_S_NODE_6364_length_393_cov_15.081461_g6127_i0	PRJNA938397	6364	393	15.081461	59.27014173	Mucorales	4827	Fungi	Fungi	100	8.73e-25	NR	XP_051418384.1	64574	g6127	i0	54.6	1.48091603053435	97	44	74	0	4	294	4	100	XP_051418384.1 transmembrane protein 14C-like protein [Radiomyces spectabilis]	diamond	582	100	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Radiomycetaceae	Radiomyces	Radiomyces spectabilis
27751786	27751786	PRJNA938397_S_NODE_23004_length_230_cov_8.746114_g22763_i0	PRJNA938397	23004	230	8.746114	20.1160622	Haplosporangium bisporale	1897645	Fungi	Fungi	54.3	6.36e-7	NR	KAF8952241.1	1897645	g22763	i0	63.2	4.98260869565217	38	14	49.6	0	10	123	112	149	KAF8952241.1 hypothetical protein BGZ52_007251 [Haplosporangium bisporale]	diamond	1146	54.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Haplosporangium	Haplosporangium bisporale
28067275	28067275	PRJNA938397_S_NODE_17845_length_261_cov_5.325893_g17604_i0	PRJNA938397	17845	261	5.325893	13.90058073	Benjaminiella poitrasii	64631	Fungi	Fungi	78.6	9.2e-15	NR	KAI9486550.1	64631	g17604	i0	54.7	7.86206896551724	75	33	85.1	1	4	225	295	369	KAI9486550.1 MAG: hypothetical protein EXX96DRAFT_593127 [Benjaminiella poitrasii]	diamond	2052	78.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Benjaminiella	Benjaminiella poitrasii
28642828	28642828	PRJNA938397_S_NODE_39807_length_174_cov_4.138686_g39566_i0	PRJNA938397	39807	174	4.138686	7.20131364	Mucorales	4827	Fungi	Fungi	42.4	0.02	NR	KAI8060266.1	101105	g39566	i0	71.4	6.27586206896552	28	8	48.3	0	5	88	482	509	KAI8060266.1 hypothetical protein BC940DRAFT_312411 [Gongronella butleri]	diamond	1092	42.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri
30088108	30088108	PRJNA938397_S_NODE_22572_length_232_cov_11.476923_g22331_i0	PRJNA938397	22572	232	11.476923	26.62646136	Mycotypha africana	64632	Fungi	Fungi	64.3	1.93e-11	NR	XP_052935482.1	64632	g22331	i0	46.4	6.12931034482759	56	30	72.4	0	213	46	20	75	XP_052935482.1 Tim10/DDP family zinc finger-domain-containing protein, partial [Mycotypha africana]	diamond	1422	64.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
30625177	30625177	PRJNA938397_S_NODE_7553_length_372_cov_11.982090_g7312_i0	PRJNA938397	7553	372	11.98209	44.5733748	Ambispora leptoticha	144679	Fungi	Fungi	52	7.24e-5	NR	CAG8625438.1	144679	g7312	i0	38.6	1.23387096774194	83	43	60.5	2	365	141	207	289	CAG8625438.1 1940_t:CDS:2 [Ambispora leptoticha]	diamond	459	52	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora leptoticha
30853480	30853480	PRJNA938397_S_NODE_34274_length_188_cov_5.304636_g34033_i0	PRJNA938397	34274	188	5.304636	9.97271568	Opisthokonta	33154	Fungi	Fungi	89.7	2.33e-19	NR	KAG2186299.1	91625	g34033	i0	67.9	1.78723404255319	56	18	89.4	0	186	19	309	364	KAG2186299.1 hypothetical protein INT43_002737 [Umbelopsis isabellina]	diamond	336	90.1	0.995560488346282	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
31738561	31738561	PRJNA938397_S_NODE_49957_length_155_cov_2.338983_g49716_i0	PRJNA938397	49957	155	2.338983	3.62542365	Eukaryota	2759	Fungi	Fungi	40.8	0.0426	NR	XP_069234948.1	4840	g49716	i0	68.2	1.87741935483871	22	7	42.6	0	145	80	77	98	XP_069234948.1 uncharacterized protein VTP01DRAFT_5904 [Rhizomucor pusillus]	diamond	291	41.2	0.990291262135922	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);;