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

11 rows where analysis = "diamond", bioproject = "PRJNA807347" 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
18657742	18657742	PRJNA807347_P_NODE_8695_length_282_cov_1.114833_g8592_i0	PRJNA807347	8695	282	1.114833	3.14382906	Sporidiobolaceae	1799696	Fungi	Fungi	142	4.15e-38	NR	BAF46415.1	5535	g8592	i0	86.7	1.76595744680851	83	11	88.3	0	250	2	325	407	BAF46415.1 NADH dehydrogenase subunit 5, partial [Rhodotorula glutinis]	diamond	498	142	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula glutinis
27591468	27591468	PRJNA807347_P_NODE_11204_length_256_cov_2.650273_g11101_i0	PRJNA807347	11204	256	2.650273	6.78469888	Rhodotorula mucilaginosa	5537	Fungi	Fungi	82	1.3e-16	NR	YP_009443034.1	5537	g11101	i0	49.4	0.94921875	81	40	93.8	1	16	255	34	114	YP_009443034.1 putative GIY-YIG endonuclease [Rhodotorula mucilaginosa]	diamond	243	82	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
29517156	29517156	PRJNA807347_P_NODE_13790_length_248_cov_0.891429_g13687_i0	PRJNA807347	13790	248	0.891429	2.21074392	Tremella mesenterica	5217	Fungi	Fungi	117	2.88e-28	NR	RXK42248.1	5217	g13687	i0	65.9	14.7217741935484	82	28	99.2	0	1	246	58	139	RXK42248.1 dolichyl-phosphate-mannose-protein mannosyltransferase [Tremella mesenterica]	diamond	3651	117	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Tremellaceae	Tremella	Tremella mesenterica
29611688	29611688	PRJNA807347_P_NODE_10310_length_265_cov_1.250000_g10207_i0	PRJNA807347	10310	265	1.25	3.3125	Naematelia encephala	71784	Fungi	Fungi	92.4	1.42e-22	NR	ORY35885.1	71784	g10207	i0	71.2	2.28679245283019	66	19	74.7	0	239	42	1	66	ORY35885.1 40S ribosomal protein S30 [Naematelia encephala]	diamond	606	92.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
30053991	30053991	PRJNA807347_P_NODE_15751_length_244_cov_1.146199_g15648_i0	PRJNA807347	15751	244	1.146199	2.79672556	Rhodotorula mucilaginosa	5537	Fungi	Fungi	73.6	1.79e-13	NR	YP_009443034.1	5537	g15648	i0	50.6	0.94672131147541	77	37	94.7	1	240	10	154	229	YP_009443034.1 putative GIY-YIG endonuclease [Rhodotorula mucilaginosa]	diamond	231	73.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
30844155	30844155	PRJNA807347_P_NODE_16134_length_244_cov_0.888889_g16031_i0	PRJNA807347	16134	244	0.888889	2.16888916	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	57	5.93e-8	NR	XP_007306122.1	721885	g16031	i0	93.1	0.35655737704918	29	2	35.7	0	158	244	73	101	XP_007306122.1 uncharacterized protein STEHIDRAFT_122917 [Stereum hirsutum FP-91666 SS1]	diamond	87	57	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
30852887	30852887	PRJNA807347_P_NODE_12374_length_251_cov_0.876404_g12271_i0	PRJNA807347	12374	251	0.876404	2.19977404	Agaricomycetes	155619	Fungi	Fungi	63.9	1.4e-9	NR	QRW05141.1	170446	g12271	i0	60.9	2.00796812749004	46	16	52.6	1	1	132	460	505	QRW05141.1 C2H2 zinc finger [Ceratobasidium sp. AG-Ba]	diamond	504	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-Ba
31128056	31128056	PRJNA807347_P_NODE_17835_length_227_cov_2.025974_g17732_i0	PRJNA807347	17835	227	2.025974	4.59896098	Malassezia arunalokei	1514897	Fungi	Fungi	149	9.43e-40	NR	WFD17378.1	1514897	g17732	i0	100	0.991189427312775	75	0	99.1	0	227	3	602	676	WFD17378.1 assembly of actin patch protein [Malassezia arunalokei]	diamond	225	149	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
31358734	31358734	PRJNA807347_P_NODE_11916_length_252_cov_1.094972_g11813_i0	PRJNA807347	11916	252	1.094972	2.75932944	root	1	Root_unresolved	Root_unresolved	57.4	1.05e-7	NR	XP_001728967.1	425265	g11813	i0	79.4	3.38095238095238	34	7	40.5	0	150	251	22	55	XP_001728967.1 uncharacterized protein MGL_3961 [Malassezia globosa CBS 7966]	diamond	852	57.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
32330774	32330774	PRJNA807347_P_NODE_16179_length_243_cov_2.652941_g16076_i0	PRJNA807347	16179	243	2.652941	6.44664663	Tulasnella sp. 331	2600221	Fungi	Fungi	112	8.17e-27	NR	KAG8872325.1	2600221	g16076	i0	65.5	1.07407407407407	87	22	97.5	1	2	238	310	396	KAG8872325.1 hypothetical protein FRB97_007767 [Tulasnella sp. 331]	diamond	261	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 331
32718299	32718299	PRJNA807347_P_NODE_10680_length_261_cov_1.659574_g10577_i0	PRJNA807347	10680	261	1.659574	4.33148814	Agaricomycetes	155619	Fungi	Fungi	84.3	1.09e-16	NR	KAI0769247.1	5319	g10577	i0	100	108.252873563218	42	0	48.3	0	259	134	841	882	KAI0769247.1 hypothetical protein BC629DRAFT_1442317 [Irpex lacteus]	diamond	28254	84.7	0.995277449822904	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex lacteus

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