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

9 rows where analysis = "diamond", bioproject = "PRJNA557895" 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
26698818	26698818	PRJNA557895_P_NODE_19861_length_208_cov_1.283019_g19506_i0	PRJNA557895	19861	208	1.283019	2.66867952	Microbotryum lychnidis-dioicae p1A1 Lamole	683840	Fungi	Fungi	47	7.64e-4	NR	KDE07049.1	683840	g19506	i0	34.7	1.08173076923077	75	43	99.5	1	207	1	561	635	KDE07049.1 hypothetical protein MVLG_02625 [Microbotryum lychnidis-dioicae p1A1 Lamole]	diamond	225	47	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Microbotryales	Microbotryaceae	Microbotryum	Microbotryum lychnidis-dioicae
26794110	26794110	PRJNA557895_P_NODE_6561_length_349_cov_1.576667_g6206_i0	PRJNA557895	6561	349	1.576667	5.50256783	Agrocybe pediades	84607	Fungi	Fungi	42	0.0333	NR	KAF4622256.1	84607	g6206	i0	42.1	0.326647564469914	38	22	32.7	0	200	87	37	74	KAF4622256.1 hypothetical protein D9613_009010 [Agrocybe pediades]	diamond	114	42	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Agrocybe	Agrocybe pediades
28292958	28292958	PRJNA557895_P_NODE_19186_length_211_cov_2.506173_g18831_i0	PRJNA557895	19186	211	2.506173	5.28802503	Agaricomycetes	155619	Fungi	Fungi	89	1.09e-18	NR	KAI0065430.1	48021	g18831	i0	65.6	15.3981042654028	64	22	91	0	210	19	398	461	KAI0065430.1 citrate synthase [Artomyces pyxidatus]	diamond	3249	89	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Auriscalpiaceae	Artomyces	Artomyces pyxidatus
28910160	28910160	PRJNA557895_P_NODE_16028_length_230_cov_0.883978_g15673_i0	PRJNA557895	16028	230	0.883978	2.0331494	Rhizoctonia solani AG-1 IA	983506	Fungi	Fungi	66.6	4.45e-11	NR	ELU43530.1	983506	g15673	i0	48.6	0.965217391304348	74	38	96.5	0	226	5	153	226	ELU43530.1 hypothetical protein AG1IA_02424 [Rhizoctonia solani AG-1 IA]	diamond	222	66.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
29005624	29005624	PRJNA557895_P_NODE_27608_length_175_cov_1.142857_g27253_i0	PRJNA557895	27608	175	1.142857	1.99999975	Daedaleopsis nitida	1140402	Fungi	Fungi	42.4	0.0109	NR	KAI0739986.1	1140402	g27253	i0	52.8	0.617142857142857	36	17	61.7	0	109	2	65	100	KAI0739986.1 heat shock 70 kd protein cognate 1 [Daedaleopsis nitida]	diamond	108	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Daedaleopsis	Daedaleopsis nitida
29177346	29177346	PRJNA557895_P_NODE_35049_length_163_cov_1.780702_g34694_i0	PRJNA557895	35049	163	1.780702	2.90254426	root	1	Root_unresolved	Root_unresolved	64.7	2.27e-10	NR	KAG6335274.1	265491	g34694	i0	64.4	28.9325153374233	45	16	82.8	0	2	136	500	544	KAG6335274.1 hypothetical protein ID866_3803 [Astraeus odoratus]	diamond	4716	65.1	0.993855606758833	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Astraeaceae	Astraeus	Astraeus odoratus
29921067	29921067	PRJNA557895_P_NODE_25391_length_183_cov_1.828358_g25036_i0	PRJNA557895	25391	183	1.828358	3.34589514	Mycena filopes	858877	Fungi	Fungi	47	5.48e-4	NR	KAJ7177930.1	858877	g25036	i0	43.1	2.50819672131148	51	29	83.6	0	153	1	322	372	KAJ7177930.1 hypothetical protein C8R46DRAFT_1212662 [Mycena filopes]	diamond	459	47	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena filopes
31026886	31026886	PRJNA557895_P_NODE_32295_length_165_cov_1.603448_g31940_i0	PRJNA557895	32295	165	1.603448	2.6456892	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	96.3	1.7700000000000003e-21	NR	XP_066821962.1	1397322	g31940	i0	74.5	1	55	14	100	0	1	165	91	145	XP_066821962.1 Myo-inositol-1-phosphate synthase [Cystobasidium minutum MCA 4210]	diamond	165	96.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
31785431	31785431	PRJNA557895_P_NODE_30217_length_167_cov_0.864407_g29862_i0	PRJNA557895	30217	167	0.864407	1.44355969	Kockovaella imperatae	4999	Fungi	Fungi	57.8	6.59e-8	NR	XP_021869642.1	4999	g29862	i0	46.2	0.934131736526946	52	28	93.4	0	11	166	468	519	XP_021869642.1 P-loop containing nucleoside triphosphate hydrolase protein [Kockovaella imperatae]	diamond	156	57.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cuniculitremaceae	Kockovaella	Kockovaella imperatae

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