metadata: contig_metadata: 6 rows where bioproject = "PRJNA727760" and tax

6 rows where bioproject = "PRJNA727760" 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
712648	712648	PRJNA727760_S_NODE_2721_length_277_cov_1.911765_g2693_i0	PRJNA727760	2721	277	1.911765	5.29558905	Malassezia globosa	76773	Fungi	Fungi	496	9.8e-136	NTclustered	gi\|164656572\|ref\|XM_001729362.1\|	425265	g2693	i0	98.917	1	277	3	100	0	1	277	597	873	Malassezia globosa CBS 7966 uncharacterized protein (MGL_3449), partial mRNA	blastn	277	496	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
10916745	10916745	PRJNA727760_S_NODE_2789_length_274_cov_1.164179_g2761_i0	PRJNA727760	2789	274	1.164179	3.18985046	Malassezia restricta	76775	Fungi	Fungi	350	7.97e-92	NTclustered	gi\|1546631199\|ref\|XM_027627260.1\|	76775	g2761	i0	100	48.8284671532847	189	0	69	0	86	274	387	199	Malassezia restricta large subunit ribosomal protein L40e (MRET_0633), partial mRNA	blastn	13379	350	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
24939120	24939120	PRJNA727760_S_NODE_2600_length_282_cov_1.492823_g2572_i0	PRJNA727760	2600	282	1.492823	4.20976086	Malassezia globosa	76773	Fungi	Fungi	448	2.84e-121	NTclustered	gi\|164654895\|ref\|XM_001728534.1\|	425265	g2572	i0	95.374	4.49645390070922	281	13	99	0	2	282	618	338	Malassezia globosa CBS 7966 uncharacterized protein (MGL_4275), partial mRNA	blastn	1268	448	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
27716103	27716103	PRJNA727760_S_NODE_2544_length_285_cov_1.561321_g2516_i0	PRJNA727760	2544	285	1.561321	4.44976485	Malassezia restricta CBS 7877	425264	Fungi	Fungi	118	6.229999999999999e-31	NR	AYO44820.1	425264	g2516	i0	71.1	0.947368421052632	90	26	94.7	0	283	14	61	150	AYO44820.1 heat shock protein GrpE [Malassezia restricta CBS 7877]	diamond	270	118	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
28104746	28104746	PRJNA727760_S_NODE_2505_length_288_cov_0.934884_g2477_i0	PRJNA727760	2505	288	0.934884	2.69246592	Microbotryomycetes	162481	Fungi	Fungi	60.5	6.06e-9	NR	GAA5898551.1	183962	g2477	i0	75.5	2.86458333333333	49	4	44.8	3	286	158	110	156	GAA5898551.1 hypothetical protein JCM6883_003349 [Sporobolomyces salmoneus]	diamond	825	60.8	0.995065789473684	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmoneus
31664041	31664041	PRJNA727760_S_NODE_3637_length_246_cov_0.901734_g3609_i0	PRJNA727760	3637	246	0.901734	2.21826564	Malassezia psittaci	1821823	Fungi	Fungi	60.5	7.19e-9	NR	WFD42247.1	1821823	g3609	i0	43	0.963414634146341	79	32	80.5	2	5	202	119	197	WFD42247.1 hypothetical protein MPSI1_000888 [Malassezia psittaci]	diamond	237	60.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia psittaci

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