metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1031674" 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
2717028	2717028	PRJNA1031674_P_NODE_13483_length_282_cov_1.468900_g13272_i0	PRJNA1031674	13483	282	1.4689	4.142298	Malassezia globosa CBS 7966	425265	Fungi	Fungi	80.1	4.45e-15	NR	XP_001732769.1	425265	g13272	i0	65.2	0.734042553191489	69	23	72.3	1	3	206	2519	2587	XP_001732769.1 uncharacterized protein MGL_0544 [Malassezia globosa CBS 7966]	diamond	207	80.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
27375195	27375195	PRJNA1031674_P_NODE_18823_length_263_cov_2.142105_g18612_i0	PRJNA1031674	18823	263	2.142105	5.63373615	Hymenochaetales	139380	Fungi	Fungi	119	1.18e-30	NR	TDL25040.1	50990	g18612	i0	80.9	4.71102661596958	68	13	77.6	0	262	59	145	212	TDL25040.1 DUF887-domain-containing protein [Rickenella mellea]	diamond	1239	120	0.991666666666667	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Rickenellaceae	Rickenella	Rickenella mellea
27887879	27887879	PRJNA1031674_P_NODE_26985_length_243_cov_0.876471_g26774_i0	PRJNA1031674	26985	243	0.876471	2.12982453	Moesziomyces antarcticus	84753	Fungi	Fungi	43.5	0.0179	NR	XP_014659000.1	84753	g26774	i0	44.3	0.753086419753086	61	30	70.4	2	46	216	7	67	XP_014659000.1 uncharacterized protein PAN0_002d1348 [Moesziomyces antarcticus]	diamond	183	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Moesziomyces	Moesziomyces antarcticus
28329917	28329917	PRJNA1031674_P_NODE_27926_length_241_cov_0.916667_g27715_i0	PRJNA1031674	27926	241	0.916667	2.20916747	Gymnopus androsaceus JB14	1447944	Fungi	Fungi	52	1.9e-5	NR	KAE9393585.1	1447944	g27715	i0	70.3	0.460580912863071	37	11	46.1	0	113	3	2	38	KAE9393585.1 MFS general substrate transporter [Gymnopus androsaceus JB14]	diamond	111	52	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Gymnopus	Gymnopus androsaceus
28866750	28866750	PRJNA1031674_P_NODE_22508_length_250_cov_1.480226_g22297_i0	PRJNA1031674	22508	250	1.480226	3.700565	Pleurotus pulmonarius	28995	Fungi	Fungi	53.5	6.18e-6	NR	KAF4567682.1	28995	g22297	i0	71.9	2.184	32	9	38.4	0	154	249	21	52	KAF4567682.1 hypothetical protein EYR36_011306 [Pleurotus pulmonarius]	diamond	546	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus pulmonarius
29087945	29087945	PRJNA1031674_P_NODE_11548_length_288_cov_1.432558_g11337_i0	PRJNA1031674	11548	288	1.432558	4.12576704	Malassezia restricta	76775	Fungi	Fungi	44.3	0.0134	NR	XP_027484557.1	76775	g11337	i0	69.2	0.270833333333333	26	8	27.1	0	80	3	1	26	XP_027484557.1 derlin [Malassezia restricta]	diamond	78	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30320047	30320047	PRJNA1031674_P_NODE_27772_length_241_cov_1.476190_g27561_i0	PRJNA1031674	27772	241	1.47619	3.5576179	Malassezia cuniculi	948313	Fungi	Fungi	85.5	3.31e-17	NR	WFD36247.1	948313	g27561	i0	54.9	1.0207468879668	82	35	99.6	1	241	2	382	463	WFD36247.1 hypothetical protein MCUN1_003125 [Malassezia cuniculi]	diamond	246	85.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi
30730195	30730195	PRJNA1031674_P_NODE_27714_length_241_cov_1.755952_g27503_i0	PRJNA1031674	27714	241	1.755952	4.23184432	Naganishia friedmannii	89922	Fungi	Fungi	72.4	1.34e-12	NR	KAJ9106126.1	89922	g27503	i0	57.8	1.12033195020747	90	28	99.6	2	1	240	1116	1205	KAJ9106126.1 hypothetical protein QFC21_001268 [Naganishia friedmannii]	diamond	270	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia friedmannii
31109224	31109224	PRJNA1031674_P_NODE_20515_length_257_cov_1.326087_g20304_i0	PRJNA1031674	20515	257	1.326087	3.40804359	Malassezia sympodialis ATCC 42132	1230383	Fungi	Fungi	82	6.66e-16	NR	XP_018741687.1	1230383	g20304	i0	61.8	2.27626459143969	68	26	79.4	0	39	242	17	84	XP_018741687.1 uncharacterized protein MSY001_3198 [Malassezia sympodialis ATCC 42132]	diamond	585	82	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis
31615334	31615334	PRJNA1031674_P_NODE_28116_length_240_cov_3.185629_g27905_i0	PRJNA1031674	28116	240	3.185629	7.6455096	Puccinia coronata f. sp. avenae	200324	Fungi	Fungi	171	2.5e-48	NR	PLW42643.1	200324	g27905	i0	100	0.9875	79	0	98.8	0	2	238	53	131	PLW42643.1 hypothetical protein PCANC_11743 [Puccinia coronata f. sp. avenae]	diamond	237	171	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia coronata

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