metadata: contig_metadata: 9 rows where bioproject = "PRJNA832865" and tax

9 rows where bioproject = "PRJNA832865" 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
822937	822937	PRJNA832865_S_NODE_31681_length_509_cov_1.206422_g26612_i0	PRJNA832865	31681	509	1.206422	6.14068798	Amanita sp. CQC-2022a	2984036	Fungi	Fungi	52.8	0.05	NTclustered	gi\|2513212536\|gb\|ON556618.1\|	2984036	g26612	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
7201694	7201694	PRJNA832865_S_NODE_61666_length_316_cov_1.901235_g56580_i0	PRJNA832865	61666	316	1.901235	6.0079026	Serendipita sp. 396	2600209	Fungi	Fungi	199	1.3e-62	NR	KAG8760757.1	2600209	g56580	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
9751729	9751729	PRJNA832865_S_NODE_76668_length_281_cov_1.110577_g71582_i0	PRJNA832865	76668	281	1.110577	3.12072137	Hemileia vastatrix	203904	Fungi	Fungi	54.7	0.007	NTclustered	gi\|326374591\|gb\|JF288624.1\|	203904	g71582	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
27275951	27275951	PRJNA832865_S_NODE_94863_length_251_cov_0.865169_g89777_i0	PRJNA832865	94863	251	0.865169	2.17157419	Malassezia restricta CBS 7877	425264	Fungi	Fungi	133	6.029999999999998e-35	NR	AYO40981.1	425264	g89777	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
27379460	27379460	PRJNA832865_S_NODE_80623_length_273_cov_1.550000_g75537_i0	PRJNA832865	80623	273	1.55	4.2315	root	1	Root_unresolved	Root_unresolved	66.2	2.91e-10	NR	TFY51092.1	34475	g75537	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
27559961	27559961	PRJNA832865_S_NODE_73544_length_287_cov_1.841121_g68458_i0	PRJNA832865	73544	287	1.841121	5.28401727	Guyanagaster necrorhizus MCA 395	856835	Fungi	Fungi	45.1	0.00896	NR	XP_043045723.1	1450536	g68458	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
29454166	29454166	PRJNA832865_S_NODE_108990_length_242_cov_0.911243_g103904_i0	PRJNA832865	108990	242	0.911243	2.20520806	Ramaria rubella	113071	Fungi	Fungi	40.8	0.0464	NR	KAF8577564.1	113071	g103904	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
32520969	32520969	PRJNA832865_S_NODE_48939_length_364_cov_1.192440_g43853_i0	PRJNA832865	48939	364	1.19244	4.3404816	Austropuccinia psidii	181123	Fungi	Fungi	44.3	0.0116	NR	MBW0479807.1	1389203	g43853	i0	38.7	0.510989010989011	62	34	51.1	1	363	178	40	97	MBW0479807.1 hypothetical protein [Austropuccinia psidii MF-1]	diamond	186	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Sphaerophragmiaceae	Austropuccinia	Austropuccinia psidii
32646487	32646487	PRJNA832865_S_NODE_65260_length_306_cov_2.313305_g60174_i0	PRJNA832865	65260	306	2.313305	7.0787133	Hermanssonia centrifuga	98765	Fungi	Fungi	46.6	0.00348	NR	THG92752.1	98765	g60174	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);;