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

10 rows where bioproject = "PRJNA737474", 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
25581926	25581926	PRJNA737474f_S_NODE_9937_length_644_cov_2119.210158_g9308_i0	PRJNA737474	9937	644	2119.210158	13647.71341752	Rozella allomycis CSF55	988480	Fungi	Fungi	225	1.16e-66	NR	RKP16896.1	988480	g9308	i0	66.7	0.782608695652174	168	56	78.3	0	642	139	119	286	RKP16896.1 ribosome biogenesis ATPase [Rozella allomycis CSF55]	diamond	504	225	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
26392912	26392912	PRJNA737474f_S_NODE_105359_length_288_cov_6.000000_g104681_i0	PRJNA737474	105359	288	6	17.28	Rozella allomycis CSF55	988480	Fungi	Fungi	125	1.26e-32	NR	EPZ31830.1	988480	g104681	i0	68.5	0.927083333333333	89	28	92.7	0	287	21	206	294	EPZ31830.1 Transaldolase [Rozella allomycis CSF55]	diamond	267	125	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32954696	32954696	PRJNA737474g_S_NODE_175466_length_286_cov_1.403756_g174172_i0	PRJNA737474	175466	286	1.403756	4.01474216	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	58.5	1.76e-7	NR	PJF19671.1	1246581	g174172	i0	33.3	1.00699300699301	96	61	97.6	2	280	2	331	426	PJF19671.1 Integral membrane protein [Paramicrosporidium saccamoebae]	diamond	288	58.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32986975	32986975	PRJNA737474b_S_NODE_33211_length_281_cov_1.086538_g32172_i0	PRJNA737474	33211	281	1.086538	3.05317178	Rozella allomycis CSF55	988480	Fungi	Fungi	59.3	5.59e-9	NR	EPZ32026.1	988480	g32172	i0	49.2	1.38790035587189	65	31	67.3	1	280	92	39	103	EPZ32026.1 DNA-binding TFAR19-related protein domain-containing protein [Rozella allomycis CSF55]	diamond	390	59.3	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32992982	32992982	PRJNA737474f_S_NODE_28651_length_401_cov_2.414634_g27974_i0	PRJNA737474	28651	401	2.414634	9.68268234	Fungi	4751	Fungi	Fungi	107	1.55e-25	NR	EPZ32860.1	988480	g27974	i0	55.9	1.4214463840399	93	41	69.6	0	1	279	184	276	EPZ32860.1 ARP2/3 complex, 34kDa subunit (p34-Arc) domain-containing protein [Rozella allomycis CSF55]	diamond	570	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
33074177	33074177	PRJNA737474g_S_NODE_28485_length_541_cov_2.292735_g27213_i0	PRJNA737474	28485	541	2.292735	12.40369635	Rozella allomycis CSF55	988480	Fungi	Fungi	125	1.34e-29	NR	EPZ32186.1	988480	g27213	i0	42.8	0.842883548983364	152	83	83.7	2	2	454	956	1104	EPZ32186.1 G protein alpha subunit, helical insertion domain-containing protein [Rozella allomycis CSF55]	diamond	456	125	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
33095374	33095374	PRJNA737474f_S_NODE_44646_length_351_cov_1.302158_g43968_i0	PRJNA737474	44646	351	1.302158	4.57057458	Eukaryota	2759	Fungi	Fungi	125	9.72e-33	NR	PJF17472.1	1246581	g43968	i0	58.2	2.5042735042735	98	40	82.9	1	3	293	187	284	PJF17472.1 rRNA adenine N(6)-methyltransferase [Paramicrosporidium saccamoebae]	diamond	879	126	0.992063492063492	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
33124672	33124672	PRJNA737474f_S_NODE_33071_length_383_cov_3.658065_g32393_i0	PRJNA737474	33071	383	3.658065	14.01038895	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	60.5	1.1e-7	NR	PJF19229.1	1246581	g32393	i0	45.7	0.634464751958224	81	34	55.6	1	353	141	561	641	PJF19229.1 hypothetical protein PSACC_00969 [Paramicrosporidium saccamoebae]	diamond	243	60.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
33141025	33141025	PRJNA737474d_S_NODE_46063_length_198_cov_5.192000_g45469_i0	PRJNA737474	46063	198	5.192	10.28016	Rozella allomycis CSF55	988480	Fungi	Fungi	61.6	4.64e-9	NR	EPZ31246.1	988480	g45469	i0	53.8	2.5	65	23	98.5	2	195	1	449	506	EPZ31246.1 Peptidase C19, ubiquitin carboxyl-terminal hydrolase 2 domain-containing protein [Rozella allomycis CSF55]	diamond	495	61.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
33159546	33159546	PRJNA737474g_S_NODE_32928_length_498_cov_4.131765_g31645_i0	PRJNA737474	32928	498	4.131765	20.5761897	Rozella allomycis CSF55	988480	Fungi	Fungi	48.5	0.00382	NR	EPZ34945.1	988480	g31645	i0	56.4	0.234939759036145	39	17	23.5	0	4	120	23	61	EPZ34945.1 hypothetical protein O9G_001675 [Rozella allomycis CSF55]	diamond	117	48.5	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);;