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

6 rows where bioproject = "PRJNA1175041" 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
13070100	13070100	PRJNA1175041_P_NODE_106751_length_240_cov_0.910180_g103883_i0	PRJNA1175041	106751	240	0.91018	2.184432	Malassezia restricta	76775	Fungi	Fungi	333	6.88e-87	NTclustered	gi\|1546636919\|ref\|XM_027630102.1\|	76775	g103883	i0	91.667	1	240	20	100	0	1	240	1902	1663	Malassezia restricta dihydroorotate dehydrogenase (MRET_3475), partial mRNA	blastn	240	333	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
19442458	19442458	PRJNA1175041_P_NODE_102436_length_244_cov_0.888889_g99568_i0	PRJNA1175041	102436	244	0.888889	2.16888916	Malassezia restricta	76775	Fungi	Fungi	451	1.86e-122	NTclustered	gi\|1546633086\|ref\|XM_027628203.1\|	76775	g99568	i0	100	1	244	0	100	0	1	244	1332	1575	Malassezia restricta exocyst complex component 6 (MRET_1576), partial mRNA	blastn	244	451	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27956667	27956667	PRJNA1175041_P_NODE_99665_length_246_cov_1.317919_g96797_i0	PRJNA1175041	99665	246	1.317919	3.24208074	Mycena olivaceomarginata	230810	Fungi	Fungi	44.7	0.00785	NR	KAJ7858950.1	230810	g96797	i0	41.5	0.792682926829268	65	33	73.2	2	221	42	277	341	KAJ7858950.1 hypothetical protein B0H14DRAFT_2747799 [Mycena olivaceomarginata]	diamond	195	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena olivaceomarginata
28714437	28714437	PRJNA1175041_P_NODE_63247_length_358_cov_1.066667_g60379_i0	PRJNA1175041	63247	358	1.066667	3.81866786	Macrolepiota fuliginosa MF-IS2	1400762	Fungi	Fungi	45.1	0.016	NR	KAF9439556.1	1400762	g60379	i0	40	0.460893854748603	55	27	41.9	2	252	103	100	153	KAF9439556.1 hypothetical protein P691DRAFT_690403, partial [Macrolepiota fuliginosa MF-IS2]	diamond	165	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Macrolepiota	Macrolepiota fuliginosa
30893857	30893857	PRJNA1175041_P_NODE_73314_length_316_cov_1.362140_g70446_i0	PRJNA1175041	73314	316	1.36214	4.3043624	Collybiopsis luxurians FD-317 M1	944289	Fungi	Fungi	43.9	0.0347	NR	KIK55604.1	944289	g70446	i0	46.9	0.465189873417722	49	16	37	1	127	11	18	66	KIK55604.1 hypothetical protein GYMLUDRAFT_264110 [Collybiopsis luxurians FD-317 M1]	diamond	147	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Collybiopsis	Collybiopsis luxurians
31399591	31399591	PRJNA1175041_P_NODE_103776_length_243_cov_0.894118_g100908_i0	PRJNA1175041	103776	243	0.894118	2.17270674	Malassezia restricta	76775	Fungi	Fungi	53.1	6.18e-6	NR	XP_027484041.1	76775	g100908	i0	100	0.345679012345679	28	0	34.6	0	134	51	233	260	XP_027484041.1 cysteine-rich secretory protein [Malassezia restricta]	diamond	84	53.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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