metadata: contig_metadata: 9 rows where bioproject = "PRJNA1078753", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA1078753", 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
5295501	5295501	PRJNA1078753_P_NODE_705_length_1087_cov_3.266272_g576_i0	PRJNA1078753	705	1087	3.266272	35.50437664	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	545	2.1999999999999994e-184	NR	PJF19132.1	1246581	g576	i0	78	0.965961361545538	350	75	96.6	1	1	1050	524	871	PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae]	diamond	1050	545	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
7845232	7845232	PRJNA1078753_P_NODE_28647_length_250_cov_0.870056_g28451_i0	PRJNA1078753	28647	250	0.870056	2.17514	Fungi	4751	Fungi	Fungi	147	1.16e-40	NR	RKP20783.1	988480	g28451	i0	86.1	12.492	79	11	94.8	0	12	248	326	404	RKP20783.1 histone acetyltransferase ELP3 [Rozella allomycis CSF55]	diamond	3123	147	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
16769513	16769513	PRJNA1078753_P_NODE_254_length_1597_cov_3.572835_g194_i0	PRJNA1078753	254	1597	3.572835	57.05817495	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	804	3.46e-283	NR	PJF19132.1	1246581	g194	i0	80.5	0.971195992485911	517	101	97.1	0	1577	27	1	517	PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae]	diamond	1551	804	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
27636293	27636293	PRJNA1078753_P_NODE_43324_length_241_cov_0.916667_g43128_i0	PRJNA1078753	43324	241	0.916667	2.20916747	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	63.9	1.16e-9	NR	PJF18254.1	1246581	g43128	i0	47.4	2.82572614107884	76	38	94.6	1	1	228	299	372	PJF18254.1 Ribosome production factor 2 [Paramicrosporidium saccamoebae]	diamond	681	63.9	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29025731	29025731	PRJNA1078753_P_NODE_29308_length_250_cov_0.870056_g29112_i0	PRJNA1078753	29308	250	0.870056	2.17514	Rozella allomycis CSF55	988480	Fungi	Fungi	109	1.44e-25	NR	RKP21703.1	988480	g29112	i0	59.8	2.952	82	33	98.4	0	1	246	20	101	RKP21703.1 CLPTM1-domain-containing protein [Rozella allomycis CSF55]	diamond	738	109	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29783124	29783124	PRJNA1078753_P_NODE_11291_length_340_cov_2.307116_g11095_i0	PRJNA1078753	11291	340	2.307116	7.8441944	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	44.3	0.0145	NR	PJF17259.1	1246581	g11095	i0	34.1	0.776470588235294	88	49	73.2	3	1	249	73	156	PJF17259.1 Atp5p [Paramicrosporidium saccamoebae]	diamond	264	44.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32217255	32217255	PRJNA1078753_P_NODE_30678_length_249_cov_0.875000_g30482_i0	PRJNA1078753	30678	249	0.875	2.17875	Rozella allomycis CSF55	988480	Fungi	Fungi	78.6	1e-14	NR	EPZ32737.1	988480	g30482	i0	47.4	0.91566265060241	76	40	91.6	0	19	246	261	336	EPZ32737.1 DUF1929 domain-containing protein [Rozella allomycis CSF55]	diamond	228	78.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32335449	32335449	PRJNA1078753_P_NODE_32739_length_248_cov_0.880000_g32543_i0	PRJNA1078753	32739	248	0.88	2.1824	Fungi	4751	Fungi	Fungi	83.6	1.71e-16	NR	PJF20167.1	1246581	g32543	i0	50.6	1.98387096774194	81	38	98	1	245	3	172	250	PJF20167.1 DNA-directed RNA polymerase subunit [Paramicrosporidium saccamoebae]	diamond	492	84.3	0.991696322657177	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32659435	32659435	PRJNA1078753_P_NODE_26220_length_253_cov_1.838889_g26024_i0	PRJNA1078753	26220	253	1.838889	4.65238917	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	94.4	9.67e-21	NR	PJF19672.1	1246581	g26024	i0	60.5	0.960474308300395	81	32	96	0	245	3	261	341	PJF19672.1 Arginase [Paramicrosporidium saccamoebae]	diamond	243	94.4	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);;