metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA448207" 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
9366921	9366921	PRJNA448207_S_NODE_2868_length_272_cov_0.994975_g2857_i0	PRJNA448207	2868	272	0.994975	2.706332	Peniophora sp. CBMAI 1	1756134	Fungi	Fungi	99	9.2e-22	NR	VDC00940.1	718367	g2857	i0	59.8	4.35661764705882	97	30	97.1	2	264	1	162	258	VDC00940.1 unnamed protein product [Peniophora sp. CBMAI 1063]	diamond	1185	99	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CBMAI 1063
10642660	10642660	PRJNA448207_P_NODE_29429_length_246_cov_0.890173_g29266_i0	PRJNA448207	29429	246	0.890173	2.18982558	Punctularia strigosozonata HHB-11173 SS5	741275	Fungi	Fungi	122	3.65e-30	NR	XP_007382581.1	741275	g29266	i0	81.8	0.939024390243902	77	11	93.9	2	12	242	82	155	XP_007382581.1 DUF625-domain-containing protein [Punctularia strigosozonata HHB-11173 SS5]	diamond	231	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Corticiales	Punctulariaceae	Punctularia	Punctularia strigosozonata
27012724	27012724	PRJNA448207_P_NODE_28422_length_247_cov_0.885057_g28259_i0	PRJNA448207	28422	247	0.885057	2.18609079	Ganoderma sinense ZZ	36075	Fungi	Fungi	74.3	2.55e-13	NR	PIL35569.1	1077348	g28259	i0	56.1	0.995951417004049	82	33	99.6	2	246	1	26	104	PIL35569.1 hypothetical protein GSI_02297 [Ganoderma sinense ZZ0214-1]	diamond	246	74.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Ganoderma	Ganoderma sinense
27202290	27202290	PRJNA448207_P_NODE_27342_length_249_cov_0.875000_g27179_i0	PRJNA448207	27342	249	0.875	2.17875	Sporobolomyces koalae	500713	Fungi	Fungi	43.9	0.0159	NR	GAA5937187.1	500713	g27179	i0	44.6	0.891566265060241	74	22	75.9	3	56	244	778	843	GAA5937187.1 hypothetical protein JCM15063_002835 [Sporobolomyces koalae]	diamond	222	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces koalae
28212794	28212794	PRJNA448207_P_NODE_19166_length_294_cov_0.882353_g19003_i0	PRJNA448207	19166	294	0.882353	2.59411782	Mycena chlorophos	658473	Fungi	Fungi	53.9	8.08e-6	NR	KAF7302313.1	658473	g19003	i0	46.1	1.3469387755102	76	33	69.4	2	13	216	8	83	KAF7302313.1 Carboxylic ester hydrolase [Mycena chlorophos]	diamond	396	53.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena chlorophos
29239744	29239744	PRJNA448207_S_NODE_3149_length_260_cov_1.235294_g3138_i0	PRJNA448207	3149	260	1.235294	3.2117644	Tremellales	5234	Fungi	Fungi	56.6	5.78e-7	NR	XP_018261184.1	1296121	g3138	i0	43.8	8.97692307692308	73	41	84.2	0	40	258	216	288	XP_018261184.1 uncharacterized protein I303_107502 [Kwoniella dejecticola CBS 10117]	diamond	2334	56.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella dejecticola
30138869	30138869	PRJNA448207_S_NODE_3612_length_247_cov_1.327586_g3601_i0	PRJNA448207	3612	247	1.327586	3.27913742	Imleria badia	36058	Fungi	Fungi	54.7	2.24e-6	NR	KAF8554173.1	36058	g3601	i0	40.8	0.923076923076923	76	42	92.3	1	18	245	116	188	KAF8554173.1 UV excision repair protein Rad23 [Imleria badia]	diamond	228	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Imleria	Imleria badia
30155223	30155223	PRJNA448207_P_NODE_20052_length_287_cov_1.336449_g19889_i0	PRJNA448207	20052	287	1.336449	3.83560863	Fungi	4751	Fungi	Fungi	115	3e-30	NR	GAA5934379.1	29898	g19889	i0	61.5	5.60278745644599	91	35	95.1	0	11	283	52	142	GAA5934379.1 hypothetical protein JCM3775_000340 [Rhodotorula graminis]	diamond	1608	116	0.991379310344828	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula graminis
30771330	30771330	PRJNA448207_P_NODE_30794_length_244_cov_0.900585_g30631_i0	PRJNA448207	30794	244	0.900585	2.1974274	Naganishia liquefaciens	104408	Fungi	Fungi	136	2.7799999999999997e-37	NR	GHJ87809.1	104408	g30631	i0	92.5	0.983606557377049	80	6	98.4	0	1	240	194	273	GHJ87809.1 hypothetical protein NliqN6_4211 [Naganishia liquefaciens]	diamond	240	136	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens

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