metadata: contig_metadata: 11 rows where bioproject = "PRJNA1040136" and tax

11 rows where bioproject = "PRJNA1040136" and tax_kingdom = "Fungi"

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
6547781	6547781	PRJNA1040136_S_NODE_2506_length_246_cov_0.890173_g2503_i0	PRJNA1040136	2506	246	0.890173	2.18982558	Agaricomycetes	155619	Fungi	Fungi	93.6	4.85e-20	NR	XP_007385161.1	741275	g2503	i0	71.4	2.30487804878049	63	18	76.8	0	245	57	577	639	XP_007385161.1 succinate dehydrogenase [Punctularia strigosozonata HHB-11173 SS5]	diamond	567	94.4	0.991525423728813	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Corticiales	Punctulariaceae	Punctularia	Punctularia strigosozonata
7822344	7822344	PRJNA1040136_S_NODE_1287_length_298_cov_3.702222_g1284_i0	PRJNA1040136	1287	298	3.702222	11.03262156	Rhizophagus irregularis DAOM 197198w	1432141	Fungi	Fungi	73.2	8.55e-15	NR	EXX72692.1	1432141	g1284	i0	71.2	1.22818791946309	52	15	52.3	0	296	141	1	52	EXX72692.1 ribosomal 60S subunit protein L29 [Rhizophagus irregularis DAOM 197198w]	diamond	366	73.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus irregularis
14198340	14198340	PRJNA1040136_S_NODE_1452_length_288_cov_2.009302_g1449_i0	PRJNA1040136	1452	288	2.009302	5.78678976	Mycotypha africana	64632	Fungi	Fungi	73.1	2.05e-8	NTclustered	gi\|2432566343\|ref\|XM_053075701.1\|	64632	g1449	i0	85.714	3.86805555555556	70	8	24	2	171	239	919	851	Mycotypha africana ribosomal protein L6, alpha-beta domain-containing protein (BDF20DRAFT_540539), mRNA	blastn	1114	73.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mycotyphaceae	Mycotypha	Mycotypha africana
14198347	14198347	PRJNA1040136_S_NODE_772_length_347_cov_1.791971_g769_i0	PRJNA1040136	772	347	1.791971	6.21813937	Rhodonia placenta	104341	Fungi	Fungi	54.7	0.009	NTclustered	gi\|1372293348\|ref\|XM_024487651.1\|	670580	g769	i0	100	0.0835734870317003	29	0	8	0	297	325	122	150	Postia placenta MAD-698-R-SB12 hypothetical protein (POSPLADRAFT_1161136), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Adustoporiaceae	Rhodonia	Rhodonia placenta
16746717	16746717	PRJNA1040136_S_NODE_1214_length_303_cov_1.682609_g1211_i0	PRJNA1040136	1214	303	1.682609	5.09830527	Cordyceps militaris	73501	Fungi	Fungi	104	7.68e-18	NTclustered	gi\|573975827\|ref\|XM_006665796.1\|	983644	g1211	i0	92.958	0.234323432343234	71	5	23	0	64	134	1	71	Cordyceps militaris CM01 uncharacterized protein (CCM_00636), partial mRNA	blastn	71	104	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Cordyceps	Cordyceps militaris
21846684	21846684	PRJNA1040136_S_NODE_2198_length_254_cov_1.690608_g2195_i0	PRJNA1040136	2198	254	1.6906080000000001	4.29414432	Opisthokonta	33154	Fungi	Fungi	87	1.11e-17	NR	KAJ3204786.1	109932	g2195	i0	64.1	3.56692913385827	78	26	89.8	1	2	229	45	122	KAJ3204786.1 60S ribosomal protein L34 [Entophlyctis luteolus]	diamond	906	87.8	0.990888382687927	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
22684974	22684974	PRJNA1040136_S_NODE_278_length_471_cov_2.384422_g275_i0	PRJNA1040136	278	471	2.384422	11.23062762	root	1	Root_unresolved	Root_unresolved	870	0	NTclustered	gi\|822603163\|emb\|LN831877.1\|	4932	g275	i0	100	74.5626326963907	471	0	100	0	1	471	535	1005	Saccharomyces cerevisiae YPL248C/GAL4 gene for transcription factor, strain 6320-A7	blastn	35119	870	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
25234364	25234364	PRJNA1040136_S_NODE_760_length_349_cov_1.782609_g757_i0	PRJNA1040136	760	349	1.782609	6.22130541	Pichiomycetes	3239874	Fungi	Fungi	113	1.49e-20	NTclustered	gi\|126132391\|ref\|XM_001382684.1\|	322104	g757	i0	89.773	16.8424068767908	88	9	25	0	94	181	360	447	Scheffersomyces stipitis CBS 6054 40S ribosomal protein S14 (RSP14), mRNA	blastn	5878	113	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces stipitis
29182782	29182782	PRJNA1040136_S_NODE_1349_length_295_cov_1.581081_g1346_i0	PRJNA1040136	1349	295	1.581081	4.66418895	Pilaira anomala	64641	Fungi	Fungi	104	2.52e-26	NR	KAI9348827.1	64641	g1346	i0	71.2	0.671186440677966	66	19	67.1	0	1	198	58	123	KAI9348827.1 profilin [Pilaira anomala]	diamond	198	104	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Mucoraceae	Pilaira	Pilaira anomala
31299092	31299092	PRJNA1040136_S_NODE_775_length_347_cov_1.124088_g772_i0	PRJNA1040136	775	347	1.124088	3.90058536	Meyerozyma sp. JA9	2028340	Fungi	Fungi	53.5	3.53e-6	NR	RLV83189.1	2028340	g772	i0	54	0.873198847262248	50	23	43.2	0	11	160	85	134	RLV83189.1 60S ribosomal protein L14-B [Meyerozyma sp. JA9]	diamond	303	53.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma sp. JA9
31860249	31860249	PRJNA1040136_S_NODE_1837_length_269_cov_1.040816_g1834_i0	PRJNA1040136	1837	269	1.040816	2.79979504	Chytriomycetaceae	1352827	Fungi	Fungi	65.1	6.56e-10	NR	KAJ3025000.1	2723227	g1834	i0	78.8	2.91078066914498	33	7	36.8	0	2	100	382	414	KAJ3025000.1 hypothetical protein HDU68_007572 [Siphonaria sp. JEL0065]	diamond	783	65.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Siphonaria	Siphonaria sp. JEL0065

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