metadata: contig_metadata: 12 rows where bioproject = "PRJNA575566", tax_clade = "Opisthokonta" and tax

12 rows where bioproject = "PRJNA575566", tax_clade = "Opisthokonta" 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
1835384	1835384	PRJNA575566_P_NODE_16202_length_262_cov_1.273632_g16005_i0	PRJNA575566	16202	262	1.273632	3.33691584	Cutaneotrichosporon oleaginosum	879819	Fungi	Fungi	195	3.75e-45	NTclustered	gi\|1071042533\|ref\|XM_018426560.1\|	879819	g16005	i0	82.018	20.8053435114504	228	41	87	0	2	229	450	223	Cutaneotrichosporon oleaginosum 60S ribosomal protein eL19 (COLE_06920), partial mRNA	blastn	5451	195	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Cutaneotrichosporon	Cutaneotrichosporon oleaginosum
3110837	3110837	PRJNA575566_P_NODE_13923_length_282_cov_1.158371_g13726_i0	PRJNA575566	13923	282	1.158371	3.26660622	Tremellomycetes	155616	Fungi	Fungi	152	1.8199999999999999e-40	NR	GHJ87648.1	104408	g13726	i0	70.7	15.6276595744681	92	27	97.9	0	280	5	16	107	GHJ87648.1 hypothetical protein NliqN6_4050 [Naganishia liquefaciens]	diamond	4407	153	0.993464052287582	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
4387330	4387330	PRJNA575566_P_NODE_10044_length_330_cov_1.003717_g9847_i0	PRJNA575566	10044	330	1.003717	3.3122661	Tilletiopsis washingtonensis	58919	Fungi	Fungi	128	5.02e-25	NTclustered	gi\|1423575308\|ref\|XM_025742166.1\|	58919	g9847	i0	84.328	0.745454545454545	134	17	40	4	31	161	213	345	Tilletiopsis washingtonensis putative 40s ribosomal protein s20 (FA09DRAFT_329402), mRNA	blastn	246	128	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
4387444	4387444	PRJNA575566_P_NODE_17724_length_250_cov_1.354497_g17527_i0	PRJNA575566	17724	250	1.354497	3.3862425	Pseudozyma flocculosa	84751	Fungi	Fungi	172	1.67e-38	NTclustered	gi\|630968635\|ref\|XM_007882535.1\|	1277687	g17527	i0	82.412	52.012	199	33	79	2	1	198	244	47	Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_05006), partial mRNA	blastn	13003	172	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
8213023	8213023	PRJNA575566_P_NODE_14307_length_278_cov_1.364055_g14110_i0	PRJNA575566	14307	278	1.364055	3.7920729	Basidiomycota	5204	Fungi	Fungi	121	6.93e-33	NR	KAJ8293786.1	5286	g14110	i0	59.3	8.8705035971223	91	37	98.2	0	277	5	65	155	KAJ8293786.1 Ubiquitin-40S ribosomal protein S27a [Rhodotorula toruloides]	diamond	2466	121	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula toruloides
13890774	13890774	PRJNA575566_P_NODE_25131_length_208_cov_0.870748_g24934_i0	PRJNA575566	25131	208	0.870748	1.81115584	Ustilaginaceae	5268	Fungi	Fungi	385	1.58e-102	NTclustered	gi\|1358186638\|gb\|MH047195.1\|	5270	g24934	i0	100	97.4855769230769	208	0	100	0	1	208	4565	4358	Mycosarcoma maydis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	20277	385	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Mycosarcoma	Mycosarcoma maydis
26618266	26618266	PRJNA575566_P_NODE_14781_length_274_cov_1.201878_g14584_i0	PRJNA575566	14781	274	1.201878	3.29314572	Opisthokonta	33154	Fungi	Fungi	78.6	1.3e-14	NR	CEQ39742.1	5005	g14584	i0	80.4	13.6970802919708	46	9	50.4	0	135	272	164	209	CEQ39742.1 SPOSA6832_01284 [Sporobolomyces salmonicolor]	diamond	3753	79	0.994936708860759	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmonicolor
27725306	27725306	PRJNA575566_P_NODE_30384_length_191_cov_2.100000_g30187_i0	PRJNA575566	30384	191	2.1	4.011	Fungi	4751	Fungi	Fungi	91.3	1.5e-19	NR	CDZ96739.1	264483	g30187	i0	67.8	11.1832460732984	59	18	92.7	1	2	178	408	465	CDZ96739.1 eukaryotic translation elongation factor 2 [Phaffia rhodozyma]	diamond	2136	92	0.992391304347826	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
28293153	28293153	PRJNA575566_P_NODE_21706_length_224_cov_1.092025_g21509_i0	PRJNA575566	21706	224	1.092025	2.446136	Eukaryota	2759	Fungi	Fungi	79.3	1.75e-16	NR	ORY92463.1	106004	g21509	i0	56.8	2.97321428571429	74	32	99.1	0	3	224	12	85	ORY92463.1 PCI domain-domain-containing protein [Leucosporidium creatinivorum]	diamond	666	79.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Leucosporidiales	Leucosporidiaceae	Leucosporidium	Leucosporidium creatinivorum
30977920	30977920	PRJNA575566_P_NODE_9174_length_345_cov_1.200704_g8977_i0	PRJNA575566	9174	345	1.200704	4.1424288	Fungi	4751	Fungi	Fungi	112	1.46e-28	NR	KAH9983893.1	40490	g8977	i0	55	20.2608695652174	111	43	94.8	2	328	2	49	154	KAH9983893.1 ribosomal protein S19-domain-containing protein [Russula compacta]	diamond	6990	113	0.991150442477876	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula compacta
32116419	32116419	PRJNA575566_P_NODE_8758_length_354_cov_1.218430_g8561_i0	PRJNA575566	8758	354	1.21843	4.3132422	Fungi	4751	Fungi	Fungi	73.6	4.29e-14	NR	ORY28810.1	71784	g8561	i0	64.9	2.80508474576271	57	20	48.3	0	4	174	16	72	ORY28810.1 60s acidic ribosomal protein-domain-containing protein [Naematelia encephala]	diamond	993	73.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
32527870	32527870	PRJNA575566_P_NODE_3199_length_579_cov_1.606178_g3004_i0	PRJNA575566	3199	579	1.606178	9.29977062	Eukaryota	2759	Fungi	Fungi	180	1.89e-52	NR	XP_021872123.1	4999	g3004	i0	50.6	31.4559585492228	168	83	87	0	578	75	107	274	XP_021872123.1 putative 60S acidic ribosomal protein [Kockovaella imperatae]	diamond	18213	181	0.994475138121547	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cuniculitremaceae	Kockovaella	Kockovaella imperatae

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