metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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
27987951	27987951	PRJNA1151638_P_NODE_5385_length_249_cov_0.886364_g5318_i0	PRJNA1151638	5385	249	0.886364	2.20704636	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	57.8	1.98e-7	NR	XP_066820679.1	1397322	g5318	i0	44.9	0.939759036144578	78	25	94	1	239	6	296	355	XP_066820679.1 uncharacterized protein P389DRAFT_99876 [Cystobasidium minutum MCA 4210]	diamond	234	57.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
28859642	28859642	PRJNA1151638_P_NODE_6328_length_244_cov_0.912281_g6261_i0	PRJNA1151638	6328	244	0.912281	2.22596564	Malassezia	55193	Fungi	Fungi	67	3.63e-11	NR	AYO41756.1	425264	g6261	i0	88.9	0.885245901639344	36	4	44.3	0	136	243	192	227	AYO41756.1 Transport protein particle subunit trs31 [Malassezia restricta CBS 7877]	diamond	216	67	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
29945629	29945629	PRJNA1151638_P_NODE_6571_length_243_cov_0.917647_g6504_i0	PRJNA1151638	6571	243	0.917647	2.22988221	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	67.8	5.3e-11	NR	XP_066824360.1	1397322	g6504	i0	70.2	0.580246913580247	47	14	58	0	141	1	7	53	XP_066824360.1 uncharacterized protein P389DRAFT_32636 [Cystobasidium minutum MCA 4210]	diamond	141	67.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
31651963	31651963	PRJNA1151638_P_NODE_6137_length_245_cov_0.906977_g6070_i0	PRJNA1151638	6137	245	0.906977	2.22209365	Rhodotorula mucilaginosa	5537	Fungi	Fungi	112	8.65e-27	NR	KAG0664242.1	5537	g6070	i0	100	0.991836734693878	81	0	99.2	0	245	3	41	121	KAG0664242.1 SWI/SNF chromatin-remodeling complex subunit [Rhodotorula mucilaginosa]	diamond	243	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
32903740	32903740	PRJNA1151638_P_NODE_6580_length_243_cov_0.917647_g6513_i0	PRJNA1151638	6580	243	0.917647	2.22988221	Malassezia	55193	Fungi	Fungi	135	3.69e-35	NR	KAI3627193.1	55194	g6513	i0	75	2.96296296296296	80	20	98.8	0	242	3	84	163	KAI3627193.1 ASH2 [Malassezia furfur]	diamond	720	136	0.992647058823529	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur

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