metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA692200" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA692200" 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
6283265	6283265	PRJNA692200_S_NODE_305_length_550_cov_15.437126_g274_i0	PRJNA692200	305	550	15.437126	84.904193	Tulasnella sp. 417	2600225	Fungi	Fungi	110	2.21e-27	NR	KAG8920536.1	2600225	g274	i0	47.5	1.93090909090909	122	64	66.5	0	19	384	6	127	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	1062	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417
8325846	8325846	PRJNA692200_S_NODE_19107_length_169_cov_2.058333_g19050_i0	PRJNA692200	19107	169	2.058333	3.47858277	Sphagnurus paluster	117069	Fungi	Fungi	95.1	4.72e-21	NR	KAG5639558.1	117069	g19050	i0	81.8	15.2662721893491	55	10	97.6	0	167	3	825	879	KAG5639558.1 hypothetical protein H0H81_012229 [Sphagnurus paluster]	diamond	2580	95.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Sphagnurus	Sphagnurus paluster
9600979	9600979	PRJNA692200_S_NODE_108_length_653_cov_60.470199_g89_i0	PRJNA692200	108	653	60.470199	394.87039947	Rhodotorula	5533	Fungi	Fungi	84	6.79e-17	NR	GJN91909.1	86838	g89	i0	68.2	3.70290964777948	66	11	30.3	1	2	199	51	106	GJN91909.1 hypothetical protein Rhopal_004934-T1 [Rhodotorula paludigena]	diamond	2418	84	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula paludigena
27188559	27188559	PRJNA692200_S_NODE_16022_length_183_cov_1.500000_g15965_i0	PRJNA692200	16022	183	1.5	2.745	Eukaryota	2759	Fungi	Fungi	49.7	5.78e-5	NR	KAF8798791.1	171480	g15965	i0	52.6	3.40983606557377	38	18	62.3	0	173	60	319	356	KAF8798791.1 nucleic acid-binding protein [Phlegmacium glaucopus]	diamond	624	49.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Cortinariaceae	Phlegmacium	Phlegmacium glaucopus
27809302	27809302	PRJNA692200_S_NODE_21204_length_164_cov_0.895652_g21147_i0	PRJNA692200	21204	164	0.895652	1.46886928	Tulasnella sp. 4	1905295	Fungi	Fungi	46.2	4.83e-4	NR	KAG8905970.1	2600223	g21147	i0	50	0.878048780487805	48	20	87.8	1	144	1	123	166	KAG8905970.1 GAL4 enhancer protein [Tulasnella sp. 403]	diamond	144	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 403
27809305	27809305	PRJNA692200_S_NODE_7764_length_247_cov_1.686869_g7707_i0	PRJNA692200	7764	247	1.686869	4.16656643	Rhizoctonia solani	456999	Fungi	Fungi	87.4	7.28e-20	NR	KAF8677483.1	456999	g7707	i0	56.6	0.923076923076923	76	31	89.9	1	245	24	62	137	KAF8677483.1 UBC-like protein [Rhizoctonia solani]	diamond	228	87.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
31757695	31757695	PRJNA692200_S_NODE_13437_length_197_cov_1.351351_g13380_i0	PRJNA692200	13437	197	1.351351	2.66216147	Cytidiella melzeri	1883072	Fungi	Fungi	42.7	0.0191	NR	KAI0684927.1	1883072	g13380	i0	40.9	0.67005076142132	44	26	67	0	195	64	182	225	KAI0684927.1 ribosomal protein L10-domain-containing protein [Cytidiella melzeri]	diamond	132	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Cytidiella	Cytidiella melzeri
31757698	31757698	PRJNA692200_S_NODE_21197_length_164_cov_0.904348_g21140_i0	PRJNA692200	21197	164	0.904348	1.48313072	Mycena vulgaris	1033282	Fungi	Fungi	41.6	0.0328	NR	KAJ6517669.1	1033282	g21140	i0	41.7	0.658536585365854	36	21	65.9	0	7	114	237	272	KAJ6517669.1 hypothetical protein DFH09DRAFT_1287733 [Mycena vulgaris]	diamond	108	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena vulgaris
32422178	32422178	PRJNA692200_S_NODE_11819_length_208_cov_1.484277_g11762_i0	PRJNA692200	11819	208	1.484277	3.08729616	Sporobolomyces salmoneus	183962	Fungi	Fungi	40.4	0.0433	NR	GAA5892705.1	183962	g11762	i0	35.7	0.807692307692308	56	34	80.8	1	40	207	42	95	GAA5892705.1 hypothetical protein JCM6883_007446 [Sporobolomyces salmoneus]	diamond	168	40.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmoneus
32811968	32811968	PRJNA692200_S_NODE_20300_length_166_cov_1.299145_g20243_i0	PRJNA692200	20300	166	1.299145	2.1565807	Schizophyllum	5333	Fungi	Fungi	63.5	5.78e-10	NR	XP_003031361.1	578458	g20243	i0	81.1	2.71084337349398	37	7	66.9	0	155	45	265	301	XP_003031361.1 polyadenylate binding protein [Schizophyllum commune H4-8]	diamond	450	63.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum commune
32895012	32895012	PRJNA692200_S_NODE_3500_length_325_cov_1.938406_g3443_i0	PRJNA692200	3500	325	1.938406	6.2998195	Malassezia cuniculi	948313	Fungi	Fungi	45.1	0.015	NR	WFD36089.1	948313	g3443	i0	56.4	2.01230769230769	39	17	36	0	238	122	757	795	WFD36089.1 cysteine--tRNA ligase [Malassezia cuniculi]	diamond	654	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi

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