metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1248424" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1248424" 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
5456770	5456770	PRJNA1248424_P_NODE_78805_length_242_cov_0.911243_g72736_i0	PRJNA1248424	78805	242	0.911243	2.20520806	Serendipita vermifera MAFF 3	109899	Fungi	Fungi	162	3.33e-47	NR	KIM21393.1	933852	g72736	i0	97.5	0.991735537190083	80	2	99.2	0	2	241	53	132	KIM21393.1 hypothetical protein M408DRAFT_333473 [Serendipita vermifera MAFF 305830]	diamond	240	162	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita vermifera
9280524	9280524	PRJNA1248424_P_NODE_25628_length_628_cov_2.886486_g19671_i0	PRJNA1248424	25628	628	2.886486	18.12713208	Filobasidium floriforme	5210	Fungi	Fungi	258	1.21e-83	NR	KAG7579948.1	5210	g19671	i0	63.5	11.5175159235669	200	73	95.5	0	1	600	37	236	KAG7579948.1 hypothetical protein FFLO_00156 [Filobasidium floriforme]	diamond	7233	258	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
26598500	26598500	PRJNA1248424_P_NODE_59081_length_278_cov_1.282927_g53013_i0	PRJNA1248424	59081	278	1.282927	3.56653706	Amanita muscaria Koide BX	41956	Fungi	Fungi	41.2	0.0397	NR	KIL59548.1	946122	g53013	i0	36.1	0.658273381294964	61	38	64.7	1	70	249	22	82	KIL59548.1 hypothetical protein M378DRAFT_169213 [Amanita muscaria Koide BX008]	diamond	183	41.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita muscaria
27186328	27186328	PRJNA1248424_P_NODE_14802_length_1248_cov_2.862979_g10396_i0	PRJNA1248424	14802	1248	2.862979	35.72997792	Opisthokonta	33154	Fungi	Fungi	44.7	0.0387	NR	KAF4564413.1	28995	g10396	i0	59.5	0.233173076923077	37	14	8.9	1	969	1079	28	63	KAF4564413.1 hypothetical protein EYR36_002347 [Pleurotus pulmonarius]	diamond	291	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius
29239142	29239142	PRJNA1248424_P_NODE_56409_length_285_cov_1.089623_g50341_i0	PRJNA1248424	56409	285	1.089623	3.10542555	Agaricomycetes	155619	Fungi	Fungi	70.1	1.39e-12	NR	KAI0304113.1	98861	g50341	i0	45	6.37894736842105	100	48	98.9	3	282	1	19	117	KAI0304113.1 translationally controlled tumor protein [Russula brevipes]	diamond	1818	70.5	0.994326241134752	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula brevipes
29378879	29378879	PRJNA1248424_P_NODE_77429_length_243_cov_1.676471_g71360_i0	PRJNA1248424	77429	243	1.676471	4.0738245300000004	Suillus lakei	48574	Fungi	Fungi	109	3.91e-27	NR	KAG1753036.1	48574	g71360	i0	67.9	4.81481481481481	78	24	96.3	1	2	235	77	153	KAG1753036.1 guanine nucleotide binding protein beta subunit [Suillus lakei]	diamond	1170	109	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus lakei
29568206	29568206	PRJNA1248424_P_NODE_53770_length_291_cov_2.784404_g47702_i0	PRJNA1248424	53770	291	2.784404	8.10261564	Malassezia globosa CBS 7966	425265	Fungi	Fungi	100	1.5199999999999995e-23	NR	XP_001730677.1	425265	g47702	i0	86	1.03092783505155	50	7	51.5	0	1	150	13	62	XP_001730677.1 uncharacterized protein MGL_2131 [Malassezia globosa CBS 7966]	diamond	300	100	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
30281676	30281676	PRJNA1248424_P_NODE_55532_length_287_cov_1.205607_g49464_i0	PRJNA1248424	55532	287	1.205607	3.46009209	Malassezia	55193	Fungi	Fungi	72.8	1.92e-13	NR	XP_027483674.1	76775	g49464	i0	62.3	1.96515679442509	61	12	63.8	1	64	246	53	102	XP_027483674.1 peptidyl-tRNA hydrolase ICT1 [Malassezia restricta]	diamond	564	73.2	0.994535519125683	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30313396	30313396	PRJNA1248424_P_NODE_77432_length_243_cov_1.670588_g71363_i0	PRJNA1248424	77432	243	1.670588	4.05952884	Pleurotaceae	104366	Fungi	Fungi	157	8.33e-44	NR	KAL0950518.1	104357	g71363	i0	84.8	7.83950617283951	79	12	97.5	0	238	2	218	296	KAL0950518.1 hypothetical protein HGRIS_007327 [Hohenbuehelia grisea]	diamond	1905	157	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Hohenbuehelia	Hohenbuehelia grisea
30705405	30705405	PRJNA1248424_P_NODE_36234_length_412_cov_2.132743_g30178_i0	PRJNA1248424	36234	412	2.132743	8.78690116	Serendipita indica DSM 11827	1109443	Fungi	Fungi	47.8	0.00401	NR	CAG7853007.1	1109443	g30178	i0	30.3	0.648058252427185	89	61	64.1	1	68	331	574	662	CAG7853007.1 Thioredoxin reductase; AltName: Full=Caffeine resistance protein 4 [Serendipita indica DSM 11827]	diamond	267	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita indica
31116030	31116030	PRJNA1248424_P_NODE_81575_length_228_cov_4.167742_g75505_i0	PRJNA1248424	81575	228	4.167742	9.50245176	Cerioporus squamosus	2829415	Fungi	Fungi	72.4	1.12e-12	NR	KAI0719785.1	2829415	g75505	i0	62.9	1.55263157894737	70	21	85.5	2	213	19	707	776	KAI0719785.1 hypothetical protein C8T65DRAFT_736345 [Cerioporus squamosus]	diamond	354	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Cerioporus	Cerioporus squamosus
31337464	31337464	PRJNA1248424_P_NODE_72996_length_247_cov_1.919540_g66927_i0	PRJNA1248424	72996	247	1.91954	4.7412638	Rhizoctonia solani AG-1 IB	1108050	Fungi	Fungi	43.5	0.0214	NR	CEL52860.1	1108050	g66927	i0	34.7	0.910931174089069	75	43	83.8	2	8	214	119	193	CEL52860.1 Retrotransposable element Tf2 155 kDa protein type 1 OS=Schizosaccharomyces pombe (strain 972 / ATCC 24843) GN=Tf2-1 PE=4 SV=1 [Rhizoctonia solani AG-1 IB]	diamond	225	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
31671875	31671875	PRJNA1248424_P_NODE_72777_length_248_cov_0.880000_g66708_i0	PRJNA1248424	72777	248	0.88	2.1824	Basidiomycota	5204	Fungi	Fungi	102	5.51e-23	NR	KAK0548176.1	155126	g66708	i0	58.5	5.95161290322581	82	34	99.2	0	248	3	1123	1204	KAK0548176.1 ubiquitin-protein ligase (E3) [Tilletia horrida]	diamond	1476	102	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Tilletiales	Tilletiaceae	Tilletia	Tilletia horrida
32160229	32160229	PRJNA1248424_P_NODE_80258_length_241_cov_0.916667_g74189_i0	PRJNA1248424	80258	241	0.916667	2.20916747	Mycena sanguinolenta	230812	Fungi	Fungi	45.4	0.00405	NR	KAJ6500977.1	230812	g74189	i0	47.2	0.659751037344398	53	26	66	2	234	76	346	396	KAJ6500977.1 hypothetical protein C8R45DRAFT_1093026 [Mycena sanguinolenta]	diamond	159	45.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena sanguinolenta

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