metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB25789" 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
1297552	1297552	PRJEB25789_S_NODE_6962_length_350_cov_1.111913_g6883_i0	PRJEB25789	6962	350	1.111913	3.8916955	Agaricales	5338	Fungi	Fungi	103	6.149999999999999e-23	NR	TFK36212.1	68775	g6883	i0	74.2	5.25428571428571	66	17	56.6	0	152	349	269	334	TFK36212.1 hypothetical protein BDQ12DRAFT_737074 [Crucibulum laeve]	diamond	1839	103	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Crucibulum	Crucibulum laeve
15325256	15325256	PRJEB25789_S_NODE_13993_length_268_cov_2.323077_g13914_i0	PRJEB25789	13993	268	2.323077	6.22584636	Agaricus bisporus var. burnettii	192524	Fungi	Fungi	156	3.1699999999999995e-47	NR	KAF7770365.1	192524	g13914	i0	83.5	10.4440298507463	85	14	95.1	0	267	13	41	125	KAF7770365.1 hypothetical protein Agabi119p4_6339 [Agaricus bisporus var. burnettii]	diamond	2799	156	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Agaricus	Agaricus bisporus
17874815	17874815	PRJEB25789_S_NODE_18675_length_245_cov_0.895349_g18596_i0	PRJEB25789	18675	245	0.895349	2.19360505	Fungi	4751	Fungi	Fungi	113	5.950000000000001e-29	NR	KAG7579948.1	5210	g18596	i0	64.2	2.97551020408163	81	29	99.2	0	3	245	90	170	KAG7579948.1 hypothetical protein FFLO_00156 [Filobasidium floriforme]	diamond	729	113	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
30943152	30943152	PRJEB25789_S_NODE_8774_length_320_cov_1.554656_g8695_i0	PRJEB25789	8774	320	1.554656	4.9748992	Eukaryota	2759	Fungi	Fungi	110	8.16e-28	NR	XP_046038547.1	5210	g8695	i0	56.6	6.553125	99	43	92.8	0	320	24	98	196	XP_046038547.1 P-loop containing nucleoside triphosphate hydrolase protein [Filobasidium floriforme]	diamond	2097	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
31107304	31107304	PRJEB25789_S_NODE_14295_length_266_cov_1.595855_g14216_i0	PRJEB25789	14295	266	1.595855	4.2449743	Kwoniella newhampshirensis	1651941	Fungi	Fungi	94	3.0800000000000003e-22	NR	XP_066805517.1	1651941	g14216	i0	53.6	0.947368421052632	84	37	92.5	1	253	8	60	143	XP_066805517.1 hypothetical protein IAR55_001189 [Kwoniella newhampshirensis]	diamond	252	94	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella newhampshirensis

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