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

8 rows where analysis = "diamond", bioproject = "PRJNA672101" 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
27188343	27188343	PRJNA672101_S_NODE_20402_length_283_cov_4.766667_g20371_i0	PRJNA672101	20402	283	4.766667	13.48966761	Malassezia	55193	Fungi	Fungi	66.6	2.27e-11	NR	WFC97793.1	253288	g20371	i0	53.3	3.78445229681979	60	28	63.6	0	185	6	57	116	WFC97793.1 GTP-binding protein [Malassezia yamatoensis]	diamond	1071	66.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia yamatoensis
28388479	28388479	PRJNA672101_S_NODE_30726_length_246_cov_1.780347_g30695_i0	PRJNA672101	30726	246	1.780347	4.37965362	Basidiomycota	5204	Fungi	Fungi	66.2	6.15e-12	NR	KAI8456085.1	170000	g30695	i0	73.2	1.95121951219512	41	11	50	0	3	125	61	101	KAI8456085.1 hypothetical protein BY996DRAFT_4580088 [Phakopsora pachyrhizi]	diamond	480	66.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Phakopsoraceae	Phakopsora	Phakopsora pachyrhizi
30587092	30587092	PRJNA672101_S_NODE_7793_length_369_cov_3.962838_g7762_i0	PRJNA672101	7793	369	3.962838	14.62287222	Naganishia liquefaciens	104408	Fungi	Fungi	111	1.64e-29	NR	GHJ89932.1	104408	g7762	i0	73.6	0.585365853658537	72	19	58.5	0	320	105	1	72	GHJ89932.1 hypothetical protein NliqN6_6334 [Naganishia liquefaciens]	diamond	216	111	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
30840023	30840023	PRJNA672101_S_NODE_7254_length_375_cov_6.867550_g7223_i0	PRJNA672101	7254	375	6.86755	25.7533125	Naganishia adeliensis	92952	Fungi	Fungi	60.8	2.74e-9	NR	KAJ9110021.1	92952	g7223	i0	55.2	1.952	58	26	46.4	0	328	155	31	88	KAJ9110021.1 hypothetical protein QFC20_003095 [Naganishia adeliensis]	diamond	732	60.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia adeliensis
31851639	31851639	PRJNA672101_S_NODE_14777_length_313_cov_8.583333_g14746_i0	PRJNA672101	14777	313	8.583333	26.86583229	Tremella mesenterica	5217	Fungi	Fungi	53.1	7.81e-6	NR	RXK36789.1	5217	g14746	i0	68.3	0.603833865814696	63	20	60.4	0	2	190	124	186	RXK36789.1 cellular nucleic acid-binding protein [Tremella mesenterica]	diamond	189	53.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Tremellaceae	Tremella	Tremella mesenterica
32295125	32295125	PRJNA672101_S_NODE_34199_length_233_cov_3.331250_g34168_i0	PRJNA672101	34199	233	3.33125	7.7618125	Phellinidium pouzarii	167371	Fungi	Fungi	49.3	1.08e-4	NR	THH06115.1	167371	g34168	i0	38.5	0.836909871244635	65	38	81.1	1	233	45	146	210	THH06115.1 hypothetical protein EW145_g4308 [Phellinidium pouzarii]	diamond	195	49.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Phellinidium	Phellinidium pouzarii
32389667	32389667	PRJNA672101_S_NODE_19699_length_287_cov_1.271028_g19668_i0	PRJNA672101	19699	287	1.271028	3.64785036	Bondarzewia mesenterica	1095465	Fungi	Fungi	47.8	7.31e-4	NR	THH16044.1	1095465	g19668	i0	51.1	0.491289198606272	47	22	49.1	1	287	147	165	210	THH16044.1 hypothetical protein EW146_g4547 [Bondarzewia mesenterica]	diamond	141	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Bondarzewiaceae	Bondarzewia	Bondarzewia mesenterica
32548133	32548133	PRJNA672101_S_NODE_8779_length_359_cov_3.045455_g8748_i0	PRJNA672101	8779	359	3.045455	10.93318345	Melampsora larici-populina 98AG31	747676	Fungi	Fungi	90.9	2.45e-20	NR	XP_007415441.1	747676	g8748	i0	74.6	0.493036211699164	59	15	49.3	0	354	178	103	161	XP_007415441.1 uncharacterized protein MELLADRAFT_73017 [Melampsora larici-populina 98AG31]	diamond	177	90.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Melampsoraceae	Melampsora	Melampsora laricis-populina

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