metadata: contig_metadata: 10 rows where bioproject = "PRJNA1113956", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA1113956", tax_kingdom = "Fungi" 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
2772564	2772564	PRJNA1113956_P_NODE_18103_length_271_cov_2.151515_g17763_i0	PRJNA1113956	18103	271	2.151515	5.83060565	Malassezia restricta	76775	Fungi	Fungi	484	2.07e-132	NTclustered	gi\|1546629955\|ref\|XM_027626638.1\|	76775	g17763	i0	98.893	1.96309963099631	271	3	100	0	1	271	2705	2975	Malassezia restricta pre-mRNA-processing factor 8 (MRET_0011), partial mRNA	blastn	532	484	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
14250997	14250997	PRJNA1113956_P_NODE_8652_length_498_cov_0.905882_g8314_i0	PRJNA1113956	8652	498	0.905882	4.51129236	Sphaerobolus stellatus SS14	990650	Fungi	Fungi	66.2	3.31e-11	NR	KIJ44297.1	990650	g8314	i0	65	0.240963855421687	40	14	24.1	0	397	278	2	41	KIJ44297.1 hypothetical protein M422DRAFT_168342 [Sphaerobolus stellatus SS14]	diamond	120	66.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Geastrales	Sphaerobolaceae	Sphaerobolus	Sphaerobolus stellatus
26656233	26656233	PRJNA1113956_P_NODE_6341_length_645_cov_5.652098_g6018_i0	PRJNA1113956	6341	645	5.652098	36.4560321	Phakopsora pachyrhizi	170000	Fungi	Fungi	170	3.73e-50	NR	KAI8455471.1	170000	g6018	i0	67.2	0.595348837209302	128	42	59.5	0	142	525	3	130	KAI8455471.1 dUTP diphosphatase [Phakopsora pachyrhizi]	diamond	384	170	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Phakopsoraceae	Phakopsora	Phakopsora pachyrhizi
27573498	27573498	PRJNA1113956_P_NODE_12404_length_368_cov_4.881356_g12064_i0	PRJNA1113956	12404	368	4.881356	17.96339008	Cytidiella melzeri	1883072	Fungi	Fungi	52.4	5.45e-5	NR	KAI0697147.1	1883072	g12064	i0	37.3	1.58967391304348	110	57	80.7	5	364	68	58	166	KAI0697147.1 hypothetical protein BC835DRAFT_1270798 [Cytidiella melzeri]	diamond	585	52.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Cytidiella	Cytidiella melzeri
28290629	28290629	PRJNA1113956_P_NODE_9186_length_473_cov_2.470000_g8847_i0	PRJNA1113956	9186	473	2.47	11.6831	Fungi	4751	Fungi	Fungi	61.2	1.01e-7	NR	KAJ3726058.1	153919	g8847	i0	33.6	2.96828752642706	137	59	66.6	4	93	407	12	148	KAJ3726058.1 PPP4R2-domain-containing protein [Lentinula raphanica]	diamond	1404	61.6	0.993506493506494	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Lentinula	Lentinula raphanica
28353907	28353907	PRJNA1113956_P_NODE_1666_length_1431_cov_2.621502_g1531_i0	PRJNA1113956	1666	1431	2.621502	37.51369362	Fungi	4751	Fungi	Fungi	53.5	0.002	NR	CDO73757.1	5643	g1531	i0	22.7	3.69601677148847	362	242	71.1	12	397	1413	67	413	CDO73757.1 hypothetical protein BN946_scf185015.g85 [Trametes cinnabarina]	diamond	5289	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes cinnabarina
31449640	31449640	PRJNA1113956_P_NODE_2196_length_1258_cov_3.035443_g2022_i0	PRJNA1113956	2196	1258	3.035443	38.18587294	Basidiomycota	5204	Fungi	Fungi	55.8	3.36e-4	NR	KAI0078289.1	1314784	g2022	i0	41.9	1.05405405405405	62	36	14.8	0	166	351	503	564	KAI0078289.1 hypothetical protein K474DRAFT_1706522 [Panus rudis PR-1116 ss-1]	diamond	1326	55.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Panaceae	Panus	Panus rudis
31806390	31806390	PRJNA1113956_P_NODE_8857_length_488_cov_3.057831_g8519_i0	PRJNA1113956	8857	488	3.057831	14.92221528	Gautieria morchelliformis	112417	Fungi	Fungi	48.9	0.00316	NR	KAF8502442.1	112417	g8519	i0	29.8	0.700819672131147	114	65	68.9	4	356	21	982	1082	KAF8502442.1 ras guanine nucleotide exchange factor domain-containing protein [Gautieria morchelliformis]	diamond	342	48.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Gomphales	Gomphaceae	Gautieria	Gautieria morchelliformis
31828856	31828856	PRJNA1113956_P_NODE_7537_length_554_cov_9.592516_g7204_i0	PRJNA1113956	7537	554	9.592516	53.14253864	Basidiomycota	5204	Fungi	Fungi	71.2	7.2e-12	NR	PVG00374.1	109899	g7204	i0	32.8	2.26895306859206	137	90	74.2	2	434	24	18	152	PVG00374.1 prenylated rab acceptor PRA1 [Serendipita vermifera]	diamond	1257	71.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita vermifera
32303989	32303989	PRJNA1113956_P_NODE_2159_length_1266_cov_14.279966_g1986_i0	PRJNA1113956	2159	1266	14.279966	180.78436956	Opisthokonta	33154	Fungi	Fungi	232	7.16e-69	NR	TRM58836.1	97359	g1986	i0	38.1	13.0687203791469	339	197	79.4	6	184	1188	18	347	TRM58836.1 farnesyl-diphosphate synthase [Schizophyllum amplum]	diamond	16545	233	0.995708154506438	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Schizophyllaceae	Schizophyllum	Schizophyllum amplum

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