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

9 rows where analysis = "diamond", bioproject = "PRJNA1074407" 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
2741418	2741418	PRJNA1074407_P_NODE_88183_length_394_cov_3.146417_g84346_i0	PRJNA1074407	88183	394	3.146417	12.396882980000001	Saitozyma podzolica	1890683	Fungi	Fungi	164	3.5e-49	NR	RSH93423.1	1890683	g84346	i0	59.2	4.86548223350254	130	53	99	0	1	390	11	140	RSH93423.1 nucleoside diphosphate kinase [Saitozyma podzolica]	diamond	1917	164	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Trimorphomycetaceae	Saitozyma	Saitozyma podzolica
27762652	27762652	PRJNA1074407_P_NODE_143244_length_242_cov_1.715976_g139406_i0	PRJNA1074407	143244	242	1.715976	4.15266192	Papiliotrema laurentii	5418	Fungi	Fungi	103	1.47e-23	NR	KAK1922900.1	5418	g139406	i0	60.5	1.00413223140496	81	30	97.9	1	242	6	722	802	KAK1922900.1 hypothetical protein DB88DRAFT_322005 [Papiliotrema laurentii]	diamond	243	103	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Rhynchogastremaceae	Papiliotrema	Papiliotrema laurentii
28994060	28994060	PRJNA1074407_P_NODE_126848_length_269_cov_1.510204_g123010_i0	PRJNA1074407	126848	269	1.510204	4.06244876	Violaceomyces palustris	1673888	Fungi	Fungi	85.5	5.02e-18	NR	PWN51504.1	1673888	g123010	i0	68.6	0.780669144981413	70	12	78.1	1	60	269	49	108	PWN51504.1 NADH-ubiquinone oxidoreductase 20 kDa subunit [Violaceomyces palustris]	diamond	210	85.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Violaceomycetales	Violaceomycetaceae	Violaceomyces	Violaceomyces palustris
29301068	29301068	PRJNA1074407_P_NODE_126849_length_269_cov_1.505102_g123011_i0	PRJNA1074407	126849	269	1.505102	4.04872438	root	1	Root_unresolved	Root_unresolved	43.5	0.0282	NR	GAA5898288.1	183962	g123011	i0	44.7	1.05947955390335	47	26	52.4	0	33	173	8	54	GAA5898288.1 hypothetical protein JCM6883_000983 [Sporobolomyces salmoneus]	diamond	285	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmoneus
30004325	30004325	PRJNA1074407_P_NODE_137371_length_247_cov_1.350575_g133533_i0	PRJNA1074407	137371	247	1.350575	3.33592025	Dioszegia hungarica	4972	Fungi	Fungi	114	1.02e-27	NR	XP_052943727.1	4972	g133533	i0	79.3	0.995951417004049	82	14	99.6	1	2	247	14	92	XP_052943727.1 major facilitator superfamily domain-containing protein [Dioszegia hungarica]	diamond	246	114	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
30762600	30762600	PRJNA1074407_P_NODE_144914_length_241_cov_0.904762_g141076_i0	PRJNA1074407	144914	241	0.904762	2.18047642	Naematelia encephala	71784	Fungi	Fungi	151	8.679999999999997e-42	NR	ORY32560.1	71784	g141076	i0	93.8	0.995850622406639	80	5	99.6	0	2	241	21	100	ORY32560.1 citrate synthase-like protein [Naematelia encephala]	diamond	240	151	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
31521264	31521264	PRJNA1074407_P_NODE_139296_length_246_cov_0.878613_g135458_i0	PRJNA1074407	139296	246	0.878613	2.16138798	Meira miltonrushii	1280837	Fungi	Fungi	128	3e-32	NR	XP_025354559.1	1280837	g135458	i0	74.1	0.98780487804878	81	20	98.8	1	244	2	122	201	XP_025354559.1 RCC1/BLIP-II [Meira miltonrushii]	diamond	243	128	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Exobasidiales	Brachybasidiaceae	Meira	Meira miltonrushii
31995688	31995688	PRJNA1074407_P_NODE_143238_length_242_cov_1.751479_g139400_i0	PRJNA1074407	143238	242	1.751479	4.23857918	Calocera cornea HHB12733	1353952	Fungi	Fungi	45.1	0.00555	NR	KZT54600.1	1353952	g139400	i0	39.3	0.756198347107438	61	33	73.1	3	215	39	239	297	KZT54600.1 hypothetical protein CALCODRAFT_556884 [Calocera cornea HHB12733]	diamond	183	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Dacrymycetes	Dacrymycetales	Dacrymycetaceae	Calocera	Calocera cornea
32375448	32375448	PRJNA1074407_P_NODE_117839_length_293_cov_1.327273_g114001_i0	PRJNA1074407	117839	293	1.327273	3.88890989	Meira miltonrushii	1280837	Fungi	Fungi	48.1	4.47e-4	NR	XP_025355909.1	1280837	g114001	i0	80.8	0.266211604095563	26	5	26.6	0	39	116	1	26	XP_025355909.1 uncharacterized protein FA14DRAFT_155017 [Meira miltonrushii]	diamond	78	48.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Exobasidiales	Brachybasidiaceae	Meira	Meira miltonrushii

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