metadata: contig_metadata: 9 rows where bioproject = "PRJEB2333", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJEB2333", tax_kingdom = "Fungi" 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
7675148	7675148	PRJEB2333_P_NODE_3647_length_226_cov_5.275132_g2870_i0	PRJEB2333	3647	226	5.275132	11.92179832	Malassezia restricta	76775	Fungi	Fungi	418	1.7199999999999998e-112	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g2870	i0	100	100.185840707965	226	0	100	0	1	226	1720	1945	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	22642	418	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
26773589	26773589	PRJEB2333_P_NODE_3581_length_240_cov_2.660099_g2804_i0	PRJEB2333	3581	240	2.660099	6.3842376	Fungi	4751	Fungi	Fungi	133	6.389999999999999e-38	NR	TXT10985.1	5417	g2804	i0	75.9	130.5625	79	19	98.8	0	1	237	62	140	TXT10985.1 hypothetical protein VHUM_01736 [Vanrija humicola]	diamond	31335	134	0.992537313432836	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija humicola
27942856	27942856	PRJEB2333_P_NODE_3265_length_408_cov_1.366577_g2489_i0	PRJEB2333	3265	408	1.366577	5.57563416	Agaricomycetes	155619	Fungi	Fungi	72	1.89e-12	NR	KAH9983893.1	40490	g2489	i0	33.6	9.61764705882353	134	72	97.8	2	400	2	56	173	KAH9983893.1 ribosomal protein S19-domain-containing protein [Russula compacta]	diamond	3924	72	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula compacta
28580794	28580794	PRJEB2333_P_NODE_4167_length_176_cov_1.618705_g3390_i0	PRJEB2333	4167	176	1.618705	2.8489208	Auriculariopsis ampla	97359	Fungi	Fungi	63.2	5.15e-11	NR	TRM60718.1	97359	g3390	i0	60.8	4.43181818181818	51	20	86.9	0	24	176	1	51	TRM60718.1 60s acidic ribosomal protein-domain-containing protein [Schizophyllum amplum]	diamond	780	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum amplum
29527974	29527974	PRJEB2333_P_NODE_2810_length_478_cov_2.045351_g2038_i0	PRJEB2333	2810	478	2.045351	9.77677778	Kockovaella imperatae	4999	Fungi	Fungi	192	1.26e-58	NR	XP_021874725.1	4999	g2038	i0	56.9	6.89748953974895	160	68	99.8	1	1	477	72	231	XP_021874725.1 putative 60s ribosomal protein l7 [Kockovaella imperatae]	diamond	3297	192	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cuniculitremaceae	Kockovaella	Kockovaella imperatae
30381130	30381130	PRJEB2333_P_NODE_3213_length_415_cov_1.748677_g2438_i0	PRJEB2333	3213	415	1.748677	7.25700955	Tilletiopsis washingtonensis	58919	Fungi	Fungi	90.9	3.65e-19	NR	XP_025600826.1	58919	g2438	i0	55.6	1.19277108433735	81	36	58.6	0	413	171	154	234	XP_025600826.1 putative ribosomal protein S3aE [Tilletiopsis washingtonensis]	diamond	495	90.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
32119706	32119706	PRJEB2333_P_NODE_3898_length_195_cov_1.727848_g3121_i0	PRJEB2333	3898	195	1.727848	3.3693036	Tilletiaria anomala UBC 951	1037660	Fungi	Fungi	84.7	2.12e-17	NR	XP_013245366.1	1037660	g3121	i0	63.5	4.87692307692308	63	23	96.9	0	193	5	115	177	XP_013245366.1 putative RPL3-60s ribosomal protein l3 [Tilletiaria anomala UBC 951]	diamond	951	84.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Georgefischeriales	Tilletiariaceae	Tilletiaria	Tilletiaria anomala
32751460	32751460	PRJEB2333_P_NODE_4360_length_167_cov_1.084615_g3583_i0	PRJEB2333	4360	167	1.084615	1.81130705	Auriculariales sp. MPI-PUGE-AT-	1916346	Fungi	Fungi	89	1.86e-19	NR	KAH7105008.1	2829486	g3583	i0	78.2	7.90419161676647	55	12	98.8	0	165	1	211	265	KAH7105008.1 mitochondrial carrier [Auriculariales sp. MPI-PUGE-AT-0066]	diamond	1320	89	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Auriculariales			Auriculariales sp. MPI-PUGE-AT-0066
32782788	32782788	PRJEB2333_P_NODE_3980_length_189_cov_1.407895_g3203_i0	PRJEB2333	3980	189	1.407895	2.66092155	Pseudomicrostroma glucosiphilum	1684307	Fungi	Fungi	60.5	1.19e-9	NR	XP_025348837.1	1684307	g3203	i0	51.9	0.857142857142857	54	26	85.7	0	189	28	73	126	XP_025348837.1 ribosomal protein L24 [Pseudomicrostroma glucosiphilum]	diamond	162	60.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Pseudomicrostroma	Pseudomicrostroma glucosiphilum

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