metadata: contig_metadata: 11 rows where bioproject = "PRJNA798511" and tax

11 rows where bioproject = "PRJNA798511" 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
2066085	2066085	PRJNA798511_P_NODE_31982_length_509_cov_1.206422_g27732_i0	PRJNA798511	31982	509	1.206422	6.14068798	Amanita sp. CQC-2022a	2984036	Fungi	Fungi	52.8	0.05	NTclustered	gi\|2513212536\|gb\|ON556618.1\|	2984036	g27732	i0	87.5	0.18860510805501	48	2	9	3	345	389	58087	58041	Amanita sp. CQC-2022a voucher GNHR-430 mitochondrion, complete genome	blastn	96	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita sp. CQC-2022a
7168332	7168332	PRJNA798511_P_NODE_20886_length_768_cov_4.230216_g1010_i1	PRJNA798511	20886	768	4.230216	32.48805888	Lactarius trivialis	217427	Fungi	Fungi	54.7	0.021	NTclustered	gi\|2091527986\|ref\|NC_057510.1\|	217427	g1010	i1	96.97	0.04296875	33	0	4	1	503	535	40338	40307	Lactarius trivialis mitochondrion, complete genome	blastn	33	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius trivialis
10994866	10994866	PRJNA798511_P_NODE_66549_length_298_cov_1.368889_g62283_i0	PRJNA798511	66549	298	1.368889	4.07928922	Lentinula edodes	5353	Fungi	Fungi	52.8	0.028	NTclustered	gi\|2185515908\|ref\|XM_046236439.1\|	5353	g62283	i0	100	0.0939597315436242	28	0	9	0	225	252	86	113	Lentinula edodes uncharacterized protein (C8R40DRAFT_848008), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Lentinula	Lentinula edodes
13544340	13544340	PRJNA798511_P_NODE_60391_length_316_cov_1.901235_g56125_i0	PRJNA798511	60391	316	1.901235	6.0079026	Serendipita sp. 396	2600209	Fungi	Fungi	199	1.3e-62	NR	KAG8760757.1	2600209	g56125	i0	87	11.629746835443	100	13	94.9	0	301	2	6	105	KAG8760757.1 GTP-binding nuclear protein gsp1/Ran [Serendipita sp. 396]	diamond	3675	199	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita sp. 396
25017439	25017439	PRJNA798511_P_NODE_73500_length_281_cov_1.110577_g69234_i0	PRJNA798511	73500	281	1.110577	3.12072137	Hemileia vastatrix	203904	Fungi	Fungi	54.7	0.007	NTclustered	gi\|326374591\|gb\|JF288624.1\|	203904	g69234	i0	100	0.103202846975089	29	0	10	0	250	278	2811	2783	Hemileia vastatrix microsatellite Hva01488 sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Zaghouaniaceae	Hemileia	Hemileia vastatrix
27275270	27275270	PRJNA798511_P_NODE_88703_length_251_cov_0.865169_g84437_i0	PRJNA798511	88703	251	0.865169	2.17157419	Malassezia restricta CBS 7877	425264	Fungi	Fungi	133	6.029999999999998e-35	NR	AYO40981.1	425264	g84437	i0	74.7	0.99203187250996006	83	21	99.2	0	250	2	162	244	AYO40981.1 Carbamoyl-phosphate synthase arginine-specific small chain [Malassezia restricta CBS 7877]	diamond	249	133	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27496411	27496411	PRJNA798511_P_NODE_65103_length_302_cov_1.449782_g60837_i0	PRJNA798511	65103	302	1.449782	4.37834164	Amanita thiersii Skay4	235537	Fungi	Fungi	46.6	0.00264	NR	PFH44902.1	703135	g60837	i0	56.3	0.903973509933775	32	14	31.8	0	149	54	168	199	PFH44902.1 hypothetical protein AMATHDRAFT_164934, partial [Amanita thiersii Skay4041]	diamond	273	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Amanitaceae	Amanita	Amanita thiersii
27812275	27812275	PRJNA798511_P_NODE_101364_length_242_cov_0.911243_g97098_i0	PRJNA798511	101364	242	0.911243	2.20520806	Ramaria rubella	113071	Fungi	Fungi	40.8	0.0464	NR	KAF8577564.1	113071	g97098	i0	39.1	0.793388429752066	64	33	75.6	2	234	52	16	76	KAF8577564.1 hypothetical protein K439DRAFT_550894 [Ramaria rubella]	diamond	192	40.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Gomphales	Gomphaceae	Ramaria	Ramaria rubella
27947470	27947470	PRJNA798511_P_NODE_76945_length_273_cov_1.550000_g72679_i0	PRJNA798511	76945	273	1.55	4.2315	root	1	Root_unresolved	Root_unresolved	66.2	2.91e-10	NR	TFY51092.1	34475	g72679	i0	59.6	4.94505494505495	47	19	51.6	0	230	90	555	601	TFY51092.1 hypothetical protein EVJ58_g10744 [Rhodofomes roseus]	diamond	1350	66.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Fomitopsidaceae	Rhodofomes	Rhodofomes roseus
29422151	29422151	PRJNA798511_P_NODE_70749_length_287_cov_1.841121_g66483_i0	PRJNA798511	70749	287	1.841121	5.28401727	Guyanagaster necrorhizus MCA 395	856835	Fungi	Fungi	45.1	0.00896	NR	XP_043045723.1	1450536	g66483	i0	31.6	0.825783972125436	79	53	82.6	1	32	268	249	326	XP_043045723.1 uncharacterized protein BT62DRAFT_999974 [Guyanagaster necrorhizus MCA 3950]	diamond	237	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Guyanagaster	Guyanagaster necrorhizus
30085428	30085428	PRJNA798511_P_NODE_63612_length_306_cov_1.982833_g59346_i0	PRJNA798511	63612	306	1.982833	6.06746898	Hermanssonia centrifuga	98765	Fungi	Fungi	46.6	0.00348	NR	THG92752.1	98765	g59346	i0	32.2	1.81372549019608	87	57	83.3	1	292	38	764	850	THG92752.1 hypothetical protein EW026_g8259 [Hermanssonia centrifuga]	diamond	555	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Meruliaceae	Hermanssonia	Hermanssonia centrifuga

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