metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1193541" 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
320604	320604	PRJNA1193541_P_NODE_11261_length_262_cov_1.386243_g11123_i0	PRJNA1193541	11261	262	1.386243	3.63195666	Hypocreales	5125	Fungi	Fungi	149	1.3899999999999996e-42	NR	KAK0392783.1	5046	g11123	i0	82.8	9.9618320610687	87	15	99.6	0	2	262	171	257	KAK0392783.1 hypothetical protein NLU13_2278 [Sarocladium strictum]	diamond	2610	149	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
320620	320620	PRJNA1193541_P_NODE_12161_length_251_cov_0.865169_g12023_i0	PRJNA1193541	12161	251	0.865169	2.17157419	Quaeritorhiza haematococci	2654861	Fungi	Fungi	125	2.94e-31	NR	KAJ3067755.1	2654861	g12023	i0	68.7	2.97609561752988	83	26	99.2	0	1	249	568	650	KAJ3067755.1 hypothetical protein HK102_007343, partial [Quaeritorhiza haematococci]	diamond	747	125	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci
23272737	23272737	PRJNA1193541_P_NODE_11659_length_256_cov_1.573770_g11521_i0	PRJNA1193541	11659	256	1.57377	4.0288512	Microdochium bolleyi	196109	Fungi	Fungi	147	5.37e-39	NR	KXJ87112.1	196109	g11521	i0	94.8	1.8046875	77	4	90.2	0	25	255	245	321	KXJ87112.1 male sterility protein [Microdochium bolleyi]	diamond	462	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Microdochiaceae	Microdochium	Microdochium bolleyi
27956832	27956832	PRJNA1193541_P_NODE_14205_length_244_cov_0.900585_g14067_i0	PRJNA1193541	14205	244	0.900585	2.1974274	Rhizophagus clarus	94130	Fungi	Fungi	57.8	1.88e-7	NR	GES76762.1	94130	g14067	i0	46.6	2.80327868852459	58	29	71.3	1	243	70	352	407	GES76762.1 concanavalin A-like lectin/glucanase domain-containing protein [Rhizophagus clarus]	diamond	684	57.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Glomerales	Glomeraceae	Rhizophagus	Rhizophagus clarus
28808957	28808957	PRJNA1193541_P_NODE_14568_length_243_cov_0.905882_g14430_i0	PRJNA1193541	14568	243	0.905882	2.20129326	Peniophora sp. CONT	1314672	Fungi	Fungi	93.6	3.09e-20	NR	KZV71638.1	1314672	g14430	i0	91.5	1.16049382716049	47	4	58	0	176	36	186	232	KZV71638.1 mRNA capping enzyme [Peniophora sp. CONT]	diamond	282	93.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CONT
29314481	29314481	PRJNA1193541_P_NODE_10989_length_266_cov_1.269430_g10851_i0	PRJNA1193541	10989	266	1.26943	3.3766838	Batrachochytrium dendrobatidis JAM81	684364	Fungi	Fungi	59.7	5.34e-8	NR	XP_006676247.1	684364	g10851	i0	37.7	0.868421052631579	77	44	82.3	2	34	252	34	110	XP_006676247.1 uncharacterized protein BATDEDRAFT_84588 [Batrachochytrium dendrobatidis JAM81]	diamond	231	59.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis
31039559	31039559	PRJNA1193541_P_NODE_14135_length_244_cov_0.900585_g13997_i0	PRJNA1193541	14135	244	0.900585	2.1974274	Opisthokonta	33154	Fungi	Fungi	83.2	5.65e-17	NR	KAI8356685.1	4850	g13997	i0	41.8	7.83196721311475	79	46	97.1	0	238	2	144	222	KAI8356685.1 guanine-1-methyltransferase-domain-containing protein [Blakeslea trispora]	diamond	1911	84	0.990476190476191	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Choanephoraceae	Blakeslea	Blakeslea trispora
31177926	31177926	PRJNA1193541_P_NODE_14715_length_242_cov_0.911243_g14577_i0	PRJNA1193541	14715	242	0.911243	2.20520806	Smittium culicis	133412	Fungi	Fungi	97.4	1.6400000000000002e-21	NR	OMJ27964.1	133412	g14577	i0	57.3	4.56198347107438	75	32	93	0	1	225	395	469	OMJ27964.1 Aminopeptidase [Smittium culicis]	diamond	1104	97.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
31589544	31589544	PRJNA1193541_P_NODE_13596_length_246_cov_0.890173_g13458_i0	PRJNA1193541	13596	246	0.890173	2.18982558	Fusarium proliferatum	948311	Fungi	Fungi	91.7	2.85e-20	NR	ABS29332.1	948311	g13458	i0	61.3	1.82926829268293	75	29	91.5	0	3	227	140	214	ABS29332.1 DNA polymerase, partial [Fusarium proliferatum]	diamond	450	91.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium proliferatum
32063791	32063791	PRJNA1193541_P_NODE_11378_length_260_cov_1.812834_g11240_i0	PRJNA1193541	11378	260	1.812834	4.7133684	Westerdykella ornata	318751	Fungi	Fungi	43.5	0.0242	NR	XP_033656339.1	318751	g11240	i0	30.7	0.865384615384615	75	43	86.5	1	15	239	441	506	XP_033656339.1 rhomboid-domain-containing protein [Westerdykella ornata]	diamond	225	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Sporormiaceae	Westerdykella	Westerdykella ornata
32759029	32759029	PRJNA1193541_P_NODE_14240_length_244_cov_0.900585_g14102_i0	PRJNA1193541	14240	244	0.900585	2.1974274	Golovinomyces cichoracearum	62708	Fungi	Fungi	133	3.78e-37	NR	RKF56651.1	62708	g14102	i0	97.1	0.848360655737705	69	2	84.8	0	2	208	123	191	RKF56651.1 hypothetical protein GcM3_194009 [Golovinomyces cichoracearum]	diamond	207	133	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Golovinomyces	Golovinomyces cichoracearum

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