metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax

12 rows where analysis = "diamond", bioproject = "PRJEB12366" 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
26709791	26709791	PRJEB12366_P_NODE_12181_length_211_cov_1.136364_g11991_i0	PRJEB12366	12181	211	1.136364	2.39772804	Fungi	4751	Fungi	Fungi	48.5	2.23e-4	NR	KAH7130356.1	256645	g11991	i0	38.8	4.81990521327014	67	41	95.3	0	8	208	328	394	KAH7130356.1 camp-dependent protein kinase A regulatory subunit [Dendryphion nanum]	diamond	1017	48.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Torulaceae	Dendryphion	Dendryphion nanum
26836969	26836969	PRJEB12366_P_NODE_18461_length_160_cov_0.952000_g18271_i0	PRJEB12366	18461	160	0.952	1.5232	Eukaryota	2759	Fungi	Fungi	67	3.04e-12	NR	KAJ1676418.1	68401	g18271	i0	62.3	11.49375	53	20	99.4	0	1	159	32	84	KAJ1676418.1 hypothetical protein EV182_008228, partial [Spiromyces aspiralis]	diamond	1839	67	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
28896138	28896138	PRJEB12366_P_NODE_10968_length_226_cov_1.047120_g10778_i0	PRJEB12366	10968	226	1.04712	2.3664912	Friedmanniomyces endolithicus	329885	Fungi	Fungi	65.1	2.01e-10	NR	KAK0360406.1	329885	g10778	i0	90.6	0.424778761061947	32	3	42.5	0	225	130	222	253	KAK0360406.1 hypothetical protein LTR94_027428, partial [Friedmanniomyces endolithicus]	diamond	96	65.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Friedmanniomyces	Friedmanniomyces endolithicus
29079481	29079481	PRJEB12366_P_NODE_16008_length_176_cov_1.702128_g15818_i0	PRJEB12366	16008	176	1.702128	2.99574528	Fungi	4751	Fungi	Fungi	53.9	2.5e-7	NR	RKP24118.1	1712513	g15818	i0	43.9	2.86363636363636	57	32	97.2	0	174	4	55	111	RKP24118.1 OSCP/delta subunit of ATPase, partial [Syncephalis pseudoplumigaleata]	diamond	504	54.3	0.992633517495396	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis pseudoplumigaleata
29117447	29117447	PRJEB12366_P_NODE_14289_length_190_cov_1.032258_g14099_i0	PRJEB12366	14289	190	1.032258	1.9612902	Sporobolomyces koalae	500713	Fungi	Fungi	129	2.3199999999999993e-34	NR	GAA5924262.1	500713	g14099	i0	92.1	1.98947368421053	63	5	99.5	0	1	189	207	269	GAA5924262.1 hypothetical protein JCM15063_005585 [Sporobolomyces koalae]	diamond	378	129	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces koalae
29243638	29243638	PRJEB12366_P_NODE_309_length_1454_cov_2.707541_g254_i0	PRJEB12366	309	1454	2.707541	39.36764614	Athelia psychrophila	1759441	Fungi	Fungi	403	1.8499999999999998e-132	NR	KZP29788.1	1759441	g254	i0	46.6	0.934662998624484	453	225	91	8	1453	131	73	520	KZP29788.1 phosphoglycerate mutase-like protein [Athelia psychrophila]	diamond	1359	403	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Atheliales	Atheliaceae	Athelia	Athelia psychrophila
29496142	29496142	PRJEB12366_P_NODE_16430_length_173_cov_1.449275_g16240_i0	PRJEB12366	16430	173	1.449275	2.50724575	Umbelopsis isabellina	91625	Fungi	Fungi	44.7	0.0031	NR	KAJ2958150.1	91625	g16240	i0	44.2	0.901734104046243	52	29	90.2	0	166	11	2686	2737	KAJ2958150.1 hypothetical protein NQZ79_g6237 [Umbelopsis isabellina]	diamond	156	44.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis isabellina
29811758	29811758	PRJEB12366_P_NODE_12391_length_208_cov_1.768786_g12201_i0	PRJEB12366	12391	208	1.768786	3.67907488	Trametes maxima	259368	Fungi	Fungi	44.3	0.00682	NR	KAI0668012.1	259368	g12201	i0	60.9	0.331730769230769	23	9	33.2	0	137	205	282	304	KAI0668012.1 efflux transporter [Trametes maxima]	diamond	69	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes maxima
29938334	29938334	PRJEB12366_P_NODE_10391_length_234_cov_1.190955_g10201_i0	PRJEB12366	10391	234	1.190955	2.7868347	Rhizopus delemar	936053	Fungi	Fungi	101	1.5499999999999998e-24	NR	KAG1461572.1	936053	g10201	i0	75.4	0.833333333333333	65	16	83.3	0	27	221	53	117	KAG1461572.1 hypothetical protein G6F56_005699 [Rhizopus delemar]	diamond	195	101	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus delemar
30184618	30184618	PRJEB12366_P_NODE_4912_length_376_cov_2.674487_g4722_i0	PRJEB12366	4912	376	2.674487	10.05607112	Cunninghamellaceae	4851	Fungi	Fungi	86.3	7.01e-18	NR	KAI8075209.1	101105	g4722	i0	56.3	2.83244680851064	71	31	56.6	0	1	213	147	217	KAI8075209.1 GPR1/FUN34/yaaH family-domain-containing protein [Gongronella butleri]	diamond	1065	86.3	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri
31100791	31100791	PRJEB12366_P_NODE_10455_length_233_cov_1.186869_g10265_i0	PRJEB12366	10455	233	1.186869	2.76540477	Nowakowskiella	109880	Fungi	Fungi	74.3	6.69e-14	NR	KAJ1559479.1	2732417	g10265	i0	46.8	1.98283261802575	79	38	96.6	1	226	2	152	230	KAJ1559479.1 hypothetical protein HK096_000452, partial [Nowakowskiella sp. JEL0078]	diamond	462	74.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Nowakowskiellaceae	Nowakowskiella	Nowakowskiella sp. JEL0078
32271419	32271419	PRJEB12366_P_NODE_20258_length_150_cov_2.086957_g20068_i0	PRJEB12366	20258	150	2.086957	3.1304355	Fungi	4751	Fungi	Fungi	90.9	2.5000000000000002e-22	NR	ORX88884.1	1314790	g20068	i0	81.6	10.86	49	9	98	0	150	4	22	70	ORX88884.1 60S ribosomal protein L37 [Basidiobolus meristosporus CBS 931.73]	diamond	1629	90.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus

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