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

10 rows where bioproject = "PRJNA493827", 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
4933139	4933139	PRJNA493827_P_NODE_149804_length_280_cov_1.043478_g147606_i0	PRJNA493827	149804	280	1.043478	2.9217384	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	75.5	1.82e-13	NR	PJF19132.1	1246581	g147606	i0	61.4	2.30357142857143	57	22	61.1	0	279	109	795	851	PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae]	diamond	645	75.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
14498919	14498919	PRJNA493827_P_NODE_13152_length_1124_cov_4.249286_g11689_i0	PRJNA493827	13152	1124	4.249286	47.76197464	Eukaryota	2759	Fungi	Fungi	217	9.69e-63	NR	EPZ33472.1	988480	g11689	i0	63.5	3.32562277580071	178	65	47.5	0	603	70	192	369	EPZ33472.1 Cysteine desulfurase, mitochondrial [Rozella allomycis CSF55]	diamond	3738	218	0.995412844036697	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
15776020	15776020	PRJNA493827_P_NODE_58413_length_461_cov_1.528351_g56217_i0	PRJNA493827	58413	461	1.528351	7.04569811	Rozella allomycis CSF55	988480	Fungi	Fungi	257	4.41e-78	NR	RKP16771.1	988480	g56217	i0	79.3	3.87201735357918	150	31	97.6	0	11	460	623	772	RKP16771.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Rozella allomycis CSF55]	diamond	1785	257	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
17684002	17684002	PRJNA493827_P_NODE_89754_length_362_cov_2.131488_g87556_i0	PRJNA493827	89754	362	2.131488	7.71598656	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	164	3.51e-49	NR	PJF20044.1	1246581	g87556	i0	73.8	1.74861878453039	103	27	85.4	0	360	52	62	164	PJF20044.1 hypothetical protein PSACC_00140 [Paramicrosporidium saccamoebae]	diamond	633	164	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29034931	29034931	PRJNA493827_P_NODE_176408_length_257_cov_1.385870_g174210_i0	PRJNA493827	176408	257	1.38587	3.5616859	Rozella allomycis CSF55	988480	Fungi	Fungi	155	1.18e-45	NR	EPZ35492.1	988480	g174210	i0	90.4	6.78210116731517	83	8	96.9	0	7	255	1	83	EPZ35492.1 60S ribosomal protein L15 [Rozella allomycis CSF55]	diamond	1743	155	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29050535	29050535	PRJNA493827_P_NODE_151428_length_278_cov_1.536585_g149230_i0	PRJNA493827	151428	278	1.536585	4.2717063	root	1	Root_unresolved	Root_unresolved	101	2.7799999999999996e-23	NR	PJF16823.1	1246581	g149230	i0	62.5	4.03597122302158	72	27	77.7	0	4	219	288	359	PJF16823.1 Small GTPase superfamily domain-containing protein [Paramicrosporidium saccamoebae]	diamond	1122	101	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29318831	29318831	PRJNA493827_P_NODE_236969_length_234_cov_2.478261_g234770_i0	PRJNA493827	236969	234	2.478261	5.79913074	Rozella allomycis CSF55	988480	Fungi	Fungi	81.6	1.65e-17	NR	EPZ34940.1	988480	g234770	i0	73.5	1.24358974358974	49	13	62.8	0	147	1	10	58	EPZ34940.1 40S ribosomal protein S19-A [Rozella allomycis CSF55]	diamond	291	81.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30929826	30929826	PRJNA493827_P_NODE_133414_length_296_cov_0.923767_g131216_i0	PRJNA493827	133414	296	0.923767	2.73435032	Rozella allomycis CSF55	988480	Fungi	Fungi	49.7	2.55e-4	NR	EPZ35991.1	988480	g131216	i0	43.6	0.557432432432432	55	30	54.7	1	197	36	230	284	EPZ35991.1 Translation initiation factor eIF3 subunit 135 domain-containing protein [Rozella allomycis CSF55]	diamond	165	49.7	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31625328	31625328	PRJNA493827_P_NODE_136616_length_292_cov_1.406393_g134418_i0	PRJNA493827	136616	292	1.406393	4.10666756	Rozella allomycis CSF55	988480	Fungi	Fungi	70.5	3.45e-12	NR	EPZ32906.1	988480	g134418	i0	45.7	0.965753424657534	94	47	92.5	1	7	276	110	203	EPZ32906.1 Ribosomal protein L2 2 domain-containing protein [Rozella allomycis CSF55]	diamond	282	70.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32179120	32179120	PRJNA493827_P_NODE_212778_length_245_cov_0.895349_g210580_i0	PRJNA493827	212778	245	0.895349	2.19360505	Eukaryota	2759	Fungi	Fungi	81.6	3.55e-17	NR	EPZ32213.1	988480	g210580	i0	54.8	1.81224489795918	73	33	89.4	0	2	220	104	176	EPZ32213.1 60S ribosomal protein L20-B [Rozella allomycis CSF55]	diamond	444	81.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis

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