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

9 rows where analysis = "diamond", bioproject = "PRJNA758770" 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
26831632	26831632	PRJNA758770_S_NODE_25101_length_251_cov_0.876404_g24975_i0	PRJNA758770	25101	251	0.876404	2.19977404	Serendipita vermifera	109899	Fungi	Fungi	91.3	4.26e-21	NR	PVF93487.1	109899	g24975	i0	77.8	0.645418326693227	54	12	64.5	0	250	89	106	159	PVF93487.1 hypothetical protein CPB86DRAFT_790048 [Serendipita vermifera]	diamond	162	91.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita vermifera
26936178	26936178	PRJNA758770_S_NODE_27102_length_249_cov_0.886364_g26976_i0	PRJNA758770	27102	249	0.886364	2.20704636	Saitozyma	1890244	Fungi	Fungi	45.8	0.00326	NR	GFZ48958.1	1639000	g26976	i0	34.9	1.51807228915663	63	41	75.9	0	239	51	368	430	GFZ48958.1 hypothetical protein JCM24511_06707 [Saitozyma sp. JCM 24511]	diamond	378	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Trimorphomycetaceae	Saitozyma	Saitozyma sp. JCM 24511
26957991	26957991	PRJNA758770_S_NODE_27822_length_248_cov_0.891429_g27696_i0	PRJNA758770	27822	248	0.891429	2.21074392	Naganishia adeliensis	92952	Fungi	Fungi	156	1.78e-43	NR	KAJ9091675.1	92952	g27696	i0	97.6	0.991935483870968	82	2	99.2	0	1	246	39	120	KAJ9091675.1 hypothetical protein QFC20_007586 [Naganishia adeliensis]	diamond	246	156	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia adeliensis
28063738	28063738	PRJNA758770_S_NODE_27485_length_248_cov_0.891429_g27359_i0	PRJNA758770	27485	248	0.891429	2.21074392	Cyphobasidiales sp. Tagirdzhanova-	2801448	Fungi	Fungi	117	2.19e-28	NR	CAD6571630.1	2778381	g27359	i0	72.4	0.919354838709677	76	21	91.9	0	229	2	291	366	CAD6571630.1 MAG: hypothetical protein CYPHOPRED_004502 [Cyphobasidiales sp. Tagirdzhanova-0007]	diamond	228	117	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cyphobasidiales			Cyphobasidiales sp. Tagirdzhanova-0007
28442839	28442839	PRJNA758770_S_NODE_30666_length_244_cov_0.912281_g30540_i0	PRJNA758770	30666	244	0.912281	2.22596564	Volvariella volvacea WC 439	1457512	Fungi	Fungi	124	5.69e-31	NR	KAF8651484.1	1457512	g30540	i0	92.6	0.836065573770492	68	0	83.6	1	243	40	1231	1293	KAF8651484.1 hypothetical protein AX16_004782 [Volvariella volvacea WC 439]	diamond	204	124	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pluteaceae	Volvariella	Volvariella volvacea
30432619	30432619	PRJNA758770_S_NODE_26113_length_250_cov_0.881356_g25987_i0	PRJNA758770	26113	250	0.881356	2.20339	Serendipita vermifera	109899	Fungi	Fungi	117	6.65e-32	NR	PVF98497.1	109899	g25987	i0	85.5	0.828	69	10	82.8	0	208	2	1	69	PVF98497.1 hypothetical protein CPB86DRAFT_814712 [Serendipita vermifera]	diamond	207	117	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita vermifera
31064375	31064375	PRJNA758770_S_NODE_31895_length_243_cov_0.917647_g31769_i0	PRJNA758770	31895	243	0.917647	2.22988221	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	151	1.28e-41	NR	XP_066819659.1	1397322	g31769	i0	91.1	1.96296296296296	79	7	97.5	0	242	6	170	248	XP_066819659.1 citrate synthase-like protein [Cystobasidium minutum MCA 4210]	diamond	477	151	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
31158585	31158585	PRJNA758770_S_NODE_29095_length_246_cov_0.901734_g28969_i0	PRJNA758770	29095	246	0.901734	2.21826564	Filobasidium floriforme	5210	Fungi	Fungi	141	6.73e-37	NR	XP_046036673.1	5210	g28969	i0	82.7	0.98780487804878	81	14	98.8	0	3	245	178	258	XP_046036673.1 putative 64 kDa mitochondrial NADH dehydrogenase [Filobasidium floriforme]	diamond	243	141	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
31949515	31949515	PRJNA758770_S_NODE_29057_length_246_cov_0.901734_g28931_i0	PRJNA758770	29057	246	0.901734	2.21826564	Ceratobasidium sp. 423	2600206	Fungi	Fungi	108	2.65e-25	NR	KAG8763058.1	2600206	g28931	i0	74.4	1	82	17	98.8	2	245	3	509	587	KAG8763058.1 hypothetical protein FRC11_006252, partial [Ceratobasidium sp. 423]	diamond	246	108	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. 423

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