metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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
19337940	19337940	PRJNA1103784_P_NODE_456_length_697_cov_3.184295_g403_i0	PRJNA1103784	456	697	3.184295	22.19453615	Fungi	4751	Fungi	Fungi	311	2.22e-103	NR	KAJ3564534.1	56174	g403	i0	66.5	25.9670014347202	215	72	92.5	0	684	40	83	297	KAJ3564534.1 hypothetical protein NP233_g8232 [Leucocoprinus birnbaumii]	diamond	18099	314	0.990445859872611	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Leucocoprinus	Leucocoprinus birnbaumii
21888974	21888974	PRJNA1103784_P_NODE_7238_length_243_cov_2.264706_g7183_i0	PRJNA1103784	7238	243	2.264706	5.50323558	Schizopora paradoxa	27342	Fungi	Fungi	99.4	6.929999999999999e-23	NR	KLO06104.1	27342	g7183	i0	65.4	4.65432098765432	78	27	96.3	0	10	243	70	147	KLO06104.1 large subunit ribosomal protein LP0 [Schizopora paradoxa]	diamond	1131	99.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Schizoporaceae	Schizopora	Schizopora paradoxa
28195847	28195847	PRJNA1103784_P_NODE_766_length_559_cov_1.899177_g712_i0	PRJNA1103784	766	559	1.899177	10.61639943	Fungi	4751	Fungi	Fungi	146	4.56e-41	NR	GAA6020434.1	86839	g712	i0	44.7	10.0626118067979	170	90	91.2	2	24	533	1	166	GAA6020434.1 hypothetical protein JCM8202_000069 [Rhodotorula sphaerocarpa]	diamond	5625	147	0.993197278911565	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula sphaerocarpa
29656698	29656698	PRJNA1103784_P_NODE_3690_length_289_cov_3.032407_g3635_i0	PRJNA1103784	3690	289	3.032407	8.76365623	Cantharellus anzutake	1750568	Fungi	Fungi	86.3	4.75e-18	NR	XP_038917079.1	1750568	g3635	i0	45.7	2.63667820069204	94	47	97.6	1	287	6	157	246	XP_038917079.1 40S ribosomal protein S1 [Cantharellus anzutake]	diamond	762	86.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Hydnaceae	Cantharellus	Cantharellus anzutake
30130531	30130531	PRJNA1103784_P_NODE_4952_length_264_cov_1.167539_g4897_i0	PRJNA1103784	4952	264	1.167539	3.08230296	Malassezia pachydermatis	77020	Fungi	Fungi	102	6.61e-23	NR	XP_017990559.1	77020	g4897	i0	91.1	1.375	56	5	63.6	0	171	4	340	395	XP_017990559.1 hypothetical protein Malapachy_0576 [Malassezia pachydermatis]	diamond	363	102	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis
31742700	31742700	PRJNA1103784_P_NODE_5657_length_251_cov_0.865169_g5602_i0	PRJNA1103784	5657	251	0.865169	2.17157419	Vararia minispora EC-137	1314806	Fungi	Fungi	63.2	5.09e-10	NR	KAI0036451.1	1314806	g5602	i0	52.2	0.800796812749004	67	15	80.1	1	1	201	100	149	KAI0036451.1 copper zinc superoxide dismutase, partial [Vararia minispora EC-137]	diamond	201	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Lachnocladiaceae	Vararia	Vararia minispora
32303913	32303913	PRJNA1103784_P_NODE_4019_length_282_cov_1.373206_g3964_i0	PRJNA1103784	4019	282	1.373206	3.87244092	Opisthokonta	33154	Fungi	Fungi	137	7.199999999999999e-36	NR	XP_052943822.1	4972	g3964	i0	71	26.6914893617021	93	27	98.9	0	280	2	394	486	XP_052943822.1 HAD-like domain-containing protein [Dioszegia hungarica]	diamond	7527	138	0.992753623188406	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
32565741	32565741	PRJNA1103784_P_NODE_5419_length_254_cov_2.314917_g5364_i0	PRJNA1103784	5419	254	2.314917	5.87988918	Rhodotorula toruloides NP11	1130832	Fungi	Fungi	51.6	9.32e-6	NR	XP_016275084.1	1130832	g5364	i0	43.1	0.767716535433071	65	34	76.8	1	228	34	84	145	XP_016275084.1 nascent polypeptide-associated complex subunit alpha [Rhodotorula toruloides NP11]	diamond	195	51.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula toruloides

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