metadata: contig_metadata: 11 rows where bioproject = "PRJNA1122875", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA1122875", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"

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_genus	tax_species
4104620	4104620	PRJNA1122875_P_NODE_24964_length_332_cov_1.687259_g24740_i0	PRJNA1122875	24964	332	1.687259	5.60169988	Rozella allomycis CSF55	988480	Fungi	Fungi	179	1.87e-51	NR	EPZ33750.1	988480	g24740	i0	75.9	7.89759036144578	108	26	97.6	0	324	1	330	437	EPZ33750.1 Dihydrolipoyl dehydrogenase, mitochondrial [Rozella allomycis CSF55]	diamond	2622	179	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
4105023	4105023	PRJNA1122875_P_NODE_6484_length_628_cov_3.632432_g6268_i0	PRJNA1122875	6484	628	3.632432	22.81167296	Fungi	4751	Fungi	Fungi	243	3.83e-78	NR	EPZ31448.1	988480	g6268	i0	71	5.00636942675159	176	45	82.2	2	1	516	32	205	EPZ31448.1 40S ribosomal protein S8-B [Rozella allomycis CSF55]	diamond	3144	243	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
13031654	13031654	PRJNA1122875_P_NODE_9191_length_543_cov_2.657447_g8972_i0	PRJNA1122875	9191	543	2.657447	14.42993721	Rozella allomycis CSF55	988480	Fungi	Fungi	177	1.9499999999999993e-52	NR	EPZ32906.1	988480	g8972	i0	60	4.59116022099448	165	63	91.2	3	6	500	73	234	EPZ32906.1 Ribosomal protein L2 2 domain-containing protein [Rozella allomycis CSF55]	diamond	2493	177	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
14306825	14306825	PRJNA1122875_P_NODE_6312_length_635_cov_6.067616_g6096_i0	PRJNA1122875	6312	635	6.067616	38.5293616	Rozella allomycis CSF55	988480	Fungi	Fungi	300	4.960000000000001e-100	NR	EPZ33659.1	988480	g6096	i0	72.1	6.3259842519685	190	53	89.8	0	632	63	61	250	EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55]	diamond	4017	300	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
18129740	18129740	PRJNA1122875_P_NODE_9175_length_544_cov_1.447983_g8956_i0	PRJNA1122875	9175	544	1.447983	7.87702752	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	258	2.2e-84	NR	PJF19905.1	1246581	g8956	i0	72.1	23.6525735294118	179	38	92.6	2	41	544	11	188	PJF19905.1 GTP-binding nuclear protein [Paramicrosporidium saccamoebae]	diamond	12867	258	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
27470320	27470320	PRJNA1122875_P_NODE_2663_length_881_cov_2.825495_g2501_i0	PRJNA1122875	2663	881	2.825495	24.89261095	Fungi	4751	Fungi	Fungi	269	2.6e-86	NR	PJF16902.1	1246581	g2501	i0	61.8	17.3121452894438	238	82	78	2	789	103	18	255	PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae]	diamond	15252	271	0.992619926199262	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
27828331	27828331	PRJNA1122875_P_NODE_8884_length_552_cov_1.824635_g8665_i0	PRJNA1122875	8884	552	1.824635	10.0719852	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	72.8	3.22e-11	NR	PJF18437.1	1246581	g8665	i0	29.1	1.02717391304348	189	129	100	2	1	552	592	780	PJF18437.1 GPCR, family 3 domain-containing protein [Paramicrosporidium saccamoebae]	diamond	567	72.8	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29375386	29375386	PRJNA1122875_P_NODE_9529_length_534_cov_2.900217_g9310_i0	PRJNA1122875	9529	534	2.900217	15.48715878	Rozella allomycis CSF55	988480	Fungi	Fungi	176	2.36e-53	NR	EPZ33737.1	988480	g9310	i0	64.2	1.50561797752809	134	44	73	2	461	72	11	144	EPZ33737.1 40S ribosomal protein S15 [Rozella allomycis CSF55]	diamond	804	176	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30101618	30101618	PRJNA1122875_P_NODE_50712_length_244_cov_0.900585_g50488_i0	PRJNA1122875	50712	244	0.900585	2.1974274	Rozella allomycis	281847	Fungi	Fungi	43.5	0.0197	NR	YP_008144609.1	281847	g50488	i0	39.8	1.02049180327869	83	47	99.6	2	2	244	51	132	YP_008144609.1 apocytochrome b [Rozella allomycis]	diamond	249	43.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31302465	31302465	PRJNA1122875_P_NODE_4455_length_732_cov_3.534143_g4255_i0	PRJNA1122875	4455	732	3.534143	25.86992676	Rozella allomycis CSF55	988480	Fungi	Fungi	204	3.48e-62	NR	EPZ32906.1	988480	g4255	i0	61	1.48770491803279	177	69	72.5	0	589	59	58	234	EPZ32906.1 Ribosomal protein L2 2 domain-containing protein [Rozella allomycis CSF55]	diamond	1089	204	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31618738	31618738	PRJNA1122875_P_NODE_31736_length_290_cov_1.368664_g31512_i0	PRJNA1122875	31736	290	1.368664	3.9691256	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	82	1.02e-15	NR	PJF19461.1	1246581	g31512	i0	53.5	1.76896551724138	86	33	87.9	2	3	257	720	799	PJF19461.1 RNA-binding domain-containing protein [Paramicrosporidium saccamoebae]	diamond	513	82	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae

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