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

10 rows where analysis = "diamond", bioproject = "PRJNA846110" 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
16135778	16135778	PRJNA846110_P_NODE_24793_length_248_cov_0.880000_g24548_i0	PRJNA846110	24793	248	0.88	2.1824	Naganishia albida	100951	Fungi	Fungi	176	6.82e-49	NR	KAI5455399.1	100951	g24548	i0	98.8	2.9758064516129	82	1	99.2	0	2	247	503	584	KAI5455399.1 Carbamoyl-phosphate synthase [Naganishia albida]	diamond	738	176	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia albida
17411307	17411307	PRJNA846110_P_NODE_28854_length_243_cov_0.905882_g28609_i0	PRJNA846110	28854	243	0.905882	2.20129326	Malassezia furfur	55194	Fungi	Fungi	154	3.16e-41	NR	WFD45429.1	55194	g28609	i0	100	2	81	0	100	0	1	243	1459	1539	WFD45429.1 polarity establishment/cellular polarization [Malassezia furfur]	diamond	486	154	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur
18684492	18684492	PRJNA846110_P_NODE_975_length_1004_cov_2.506982_g810_i0	PRJNA846110	975	1004	2.506982	25.17009928	Basidiomycota	5204	Fungi	Fungi	388	1.56e-126	NR	KAJ3561854.1	56174	g810	i0	60.8	57.8157370517928	309	116	92.3	2	929	3	237	540	KAJ3561854.1 hypothetical protein NP233_g9941 [Leucocoprinus birnbaumii]	diamond	58047	388	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Leucocoprinus	Leucocoprinus birnbaumii
19959370	19959370	PRJNA846110_P_NODE_14336_length_290_cov_1.714286_g14091_i0	PRJNA846110	14336	290	1.714286	4.9714294	Cutaneotrichosporon	1838142	Fungi	Fungi	175	2.98e-49	NR	XP_018280466.1	879819	g14091	i0	84.2	1.97586206896552	95	15	98.3	0	288	4	157	251	XP_018280466.1 uncharacterized protein COLE_07774 [Cutaneotrichosporon oleaginosum]	diamond	573	175	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Cutaneotrichosporon	Cutaneotrichosporon oleaginosum
27781427	27781427	PRJNA846110_P_NODE_27424_length_245_cov_0.895349_g27179_i0	PRJNA846110	27424	245	0.895349	2.19360505	Malassezia restricta CBS 7877	425264	Fungi	Fungi	112	7.66e-27	NR	AYO43820.1	425264	g27179	i0	80.2	0.991836734693878	81	16	99.2	0	3	245	298	378	AYO43820.1 Homeobox-leucine zipper protein HOX20 [Malassezia restricta CBS 7877]	diamond	243	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
28034039	28034039	PRJNA846110_P_NODE_26645_length_246_cov_0.890173_g26400_i0	PRJNA846110	26645	246	0.890173	2.18982558	Malassezia globosa CBS 7966	425265	Fungi	Fungi	72.4	8.93e-15	NR	XP_001731002.1	425265	g26400	i0	66.7	1.34146341463415	57	19	69.5	0	41	211	4	60	XP_001731002.1 uncharacterized protein MGL_2001 [Malassezia globosa CBS 7966]	diamond	330	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
28357895	28357895	PRJNA846110_P_NODE_15666_length_284_cov_1.402844_g15421_i0	PRJNA846110	15666	284	1.402844	3.98407696	Basidiomycota	5204	Fungi	Fungi	58.2	2.36e-7	NR	XP_007877430.1	1277687	g15421	i0	81.6	1.37323943661972	38	7	40.1	0	2	115	151	188	XP_007877430.1 uncharacterized protein PFL1_01729 [Pseudozyma flocculosa PF-1]	diamond	390	58.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
28791525	28791525	PRJNA846110_P_NODE_6467_length_411_cov_1.266272_g6223_i0	PRJNA846110	6467	411	1.266272	5.20437792	Cyphobasidiales sp. Tagirdzhanova-	2801448	Fungi	Fungi	132	3.45e-36	NR	CAD6586497.1	2778381	g6223	i0	80.7	7.81751824817518	83	16	60.6	0	410	162	94	176	CAD6586497.1 MAG: hypothetical protein CYPHOPRED_003559 [Cyphobasidiales sp. Tagirdzhanova-0007]	diamond	3213	132	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cyphobasidiales			Cyphobasidiales sp. Tagirdzhanova-0007
28854641	28854641	PRJNA846110_P_NODE_14508_length_289_cov_2.620370_g14263_i0	PRJNA846110	14508	289	2.62037	7.5728693	Chiua virens	1914213	Fungi	Fungi	60.8	7.93e-9	NR	KAG9313942.1	1914213	g14263	i0	35.6	0.934256055363322	90	48	83	1	12	251	82	171	KAG9313942.1 hypothetical protein JVU11DRAFT_4716 [Chiua virens]	diamond	270	60.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Chiua	Chiua virens
29833599	29833599	PRJNA846110_P_NODE_29731_length_241_cov_1.779762_g29486_i0	PRJNA846110	29731	241	1.779762	4.28922642	Naganishia albida	100951	Fungi	Fungi	166	8.89e-50	NR	KAI5451172.1	100951	g29486	i0	98.7	0.983402489626556	79	1	98.3	0	239	3	73	151	KAI5451172.1 hypothetical protein NCC49_002048 [Naganishia albida]	diamond	237	166	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia albida

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