metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
27213558	27213558	PRJNA896973_S_NODE_702_length_441_cov_4.092391_g688_i0	PRJNA896973	702	441	4.092391	18.04744431	Malassezia restricta	76775	Fungi	Fungi	119	5.37e-32	NR	XP_027483127.1	76775	g688	i0	77.8	0.612244897959184	90	20	61.2	0	336	67	10	99	XP_027483127.1 rRNA-processing protein CGR1 [Malassezia restricta]	diamond	270	119	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
29140183	29140183	PRJNA896973_P_NODE_27469_length_242_cov_0.911243_g27375_i0	PRJNA896973	27469	242	0.911243	2.20520806	Sporisorium reilianum SRZ2	999809	Fungi	Fungi	94	3.49e-20	NR	CBQ72715.1	999809	g27375	i0	78.7	0.929752066115702	75	12	93	1	3	227	24	94	CBQ72715.1 conserved hypothetical protein [Sporisorium reilianum SRZ2]	diamond	225	94	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Sporisorium	Sporisorium reilianum
29392653	29392653	PRJNA896973_P_NODE_16969_length_278_cov_1.312195_g16875_i0	PRJNA896973	16969	278	1.312195	3.6479021	Leucosporidium creatinivorum	106004	Fungi	Fungi	83.2	5.56e-17	NR	ORY85321.1	106004	g16875	i0	59.2	0.766187050359712	71	25	76.6	1	65	277	161	227	ORY85321.1 P-loop containing nucleoside triphosphate hydrolase protein [Leucosporidium creatinivorum]	diamond	213	83.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Leucosporidiales	Leucosporidiaceae	Leucosporidium	Leucosporidium creatinivorum
30221287	30221287	PRJNA896973_P_NODE_23652_length_248_cov_0.880000_g23558_i0	PRJNA896973	23652	248	0.88	2.1824	Malassezia	55193	Fungi	Fungi	87	1.03e-17	NR	XP_027485067.1	76775	g23558	i0	77.1	4.06451612903226	48	11	58.1	0	248	105	1170	1217	XP_027485067.1 phospholipid-transporting ATPase [Malassezia restricta]	diamond	1008	87	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30631955	30631955	PRJNA896973_S_NODE_2033_length_276_cov_2.546798_g2019_i0	PRJNA896973	2033	276	2.546798	7.02916248	Eukaryota	2759	Fungi	Fungi	57.8	8.31e-8	NR	XP_025360381.1	1569628	g2019	i0	90	0.652173913043478	30	2	31.5	1	253	167	150	179	XP_025360381.1 40S ribosomal protein S15 [Jaminaea rosea]	diamond	180	57.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Microstromatales		Jaminaea	Jaminaea rosea
30845654	30845654	PRJNA896973_P_NODE_29134_length_213_cov_5.464286_g29040_i0	PRJNA896973	29134	213	5.464286	11.63892918	Armillaria luteobubalina	153913	Fungi	Fungi	42.7	0.0248	NR	KAK0495293.1	153913	g29040	i0	44.9	0.690140845070423	49	21	62	2	66	197	118	165	KAK0495293.1 hypothetical protein EDD18DRAFT_1394090 [Armillaria luteobubalina]	diamond	147	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Armillaria	Armillaria luteobubalina
31572884	31572884	PRJNA896973_P_NODE_28456_length_237_cov_2.493902_g28362_i0	PRJNA896973	28456	237	2.493902	5.91054774	Malassezia arunalokei	1514897	Fungi	Fungi	49.3	1.79e-4	NR	WFD16437.1	1514897	g28362	i0	62.9	0.784810126582278	62	15	74.7	4	16	192	27	83	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	186	49.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
31770128	31770128	PRJNA896973_S_NODE_2377_length_259_cov_4.204301_g2363_i0	PRJNA896973	2377	259	4.204301	10.88913959	Kwoniella	490731	Fungi	Fungi	66.2	1.67e-10	NR	XP_019049821.1	1296100	g2363	i0	65.3	1.13513513513514	49	17	56.8	0	24	170	260	308	XP_019049821.1 uncharacterized protein I302_101556 [Kwoniella bestiolae CBS 10118]	diamond	294	66.6	0.993993993993994	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella bestiolae

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