metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax_phylum = "Basidiomycota"

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
7868254	7868254	PRJNA1111082_P_NODE_9947_length_257_cov_3.516304_g9902_i0	PRJNA1111082	9947	257	3.516304	9.03690128	Basidiomycota	5204	Fungi	Fungi	62.4	4.57e-9	NR	KAE8227519.1	43049	g9902	i0	65.5	3.61867704280156	55	18	64.2	1	8	172	285	338	KAE8227519.1 hypothetical protein CF319_g16 [Tilletia indica]	diamond	930	62.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Tilletiales	Tilletiaceae	Tilletia	Tilletia indica
27352499	27352499	PRJNA1111082_P_NODE_8443_length_279_cov_2.286408_g8398_i0	PRJNA1111082	8443	279	2.286408	6.37907832	Heliocybe sulcata	5364	Fungi	Fungi	49.7	1.9e-4	NR	TFK45384.1	5364	g8398	i0	47.4	0.612903225806452	57	24	59.1	2	114	278	6	58	TFK45384.1 hypothetical protein OE88DRAFT_1221083 [Heliocybe sulcata]	diamond	171	49.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Gloeophyllales	Gloeophyllaceae	Heliocybe	Heliocybe sulcata
27731487	27731487	PRJNA1111082_P_NODE_6264_length_319_cov_1.573171_g6219_i0	PRJNA1111082	6264	319	1.573171	5.01841549	Peniophora sp. CONT	1314672	Fungi	Fungi	173	1.1599999999999999e-47	NR	KZV67749.1	1314672	g6219	i0	98.8	0.799373040752351	85	1	79.9	0	281	27	1557	1641	KZV67749.1 hypothetical protein PENSPDRAFT_687890 [Peniophora sp. CONT]	diamond	255	173	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CONT
28236095	28236095	PRJNA1111082_P_NODE_12406_length_243_cov_0.917647_g12361_i0	PRJNA1111082	12406	243	0.917647	2.22988221	Malassezia restricta	76775	Fungi	Fungi	119	1.18e-29	NR	XP_027486185.1	76775	g12361	i0	83.8	0.839506172839506	68	11	84	0	235	32	356	423	XP_027486185.1 uncharacterized protein MRET_3416 [Malassezia restricta]	diamond	204	119	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
29593657	29593657	PRJNA1111082_P_NODE_4790_length_360_cov_1.327526_g4745_i0	PRJNA1111082	4790	360	1.327526	4.7790936	Phaffia rhodozyma	264483	Fungi	Fungi	109	6.82e-25	NR	CED85345.1	264483	g4745	i0	84.6	4.33333333333333	65	9	53.3	1	163	354	921	985	CED85345.1 endoplasmic reticulum ca-transporting p-type atpase [Phaffia rhodozyma]	diamond	1560	109	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
29625144	29625144	PRJNA1111082_P_NODE_2410_length_483_cov_6.585366_g2365_i0	PRJNA1111082	2410	483	6.585366	31.80731778	Tulasnella sp. 417	2600225	Fungi	Fungi	94.7	3.94e-19	NR	KAG8926805.1	2600225	g2365	i0	56.6	0.956521739130435	76	33	47.2	0	459	232	1135	1210	KAG8926805.1 hypothetical protein FRC01_008347 [Tulasnella sp. 417]	diamond	462	94.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417
31331667	31331667	PRJNA1111082_P_NODE_8476_length_279_cov_1.184466_g8431_i0	PRJNA1111082	8476	279	1.184466	3.30466014	Malassezia sympodialis ATCC 42132	1230383	Fungi	Fungi	72.4	2.24e-12	NR	SHO76163.1	1230383	g8431	i0	46.2	0.978494623655914	91	41	97.8	1	279	7	1255	1337	SHO76163.1 Uncharacterized protein MSYG_0498 [Malassezia sympodialis ATCC 42132]	diamond	273	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis

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