metadata: contig_metadata: 8 rows where bioproject = "PRJNA849822", tax_kingdom = "Fungi" and tax

8 rows where bioproject = "PRJNA849822", 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
838489	838489	PRJNA849822_P_NODE_13281_length_403_cov_0.909091_g13107_i0	PRJNA849822	13281	403	0.909091	3.66363673	Rozella allomycis CSF55	988480	Fungi	Fungi	159	2.33e-43	NR	EPZ31141.1	988480	g13107	i0	82.6	8.50124069478908	92	16	68.5	0	127	402	15	106	EPZ31141.1 V-type proton ATPase subunit B [Rozella allomycis CSF55]	diamond	3426	159	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
4666993	4666993	PRJNA849822_P_NODE_15544_length_368_cov_3.332203_g15370_i0	PRJNA849822	15544	368	3.332203	12.26250704	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	132	1.85e-35	NR	PJF16614.1	1246581	g15370	i0	76.8	0.807065217391304	99	23	80.7	0	365	69	146	244	PJF16614.1 40S ribosomal protein S6 [Paramicrosporidium saccamoebae]	diamond	297	132	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
9766635	9766635	PRJNA849822_P_NODE_22768_length_303_cov_8.695652_g22594_i0	PRJNA849822	22768	303	8.695652	26.34782556	Fungi	4751	Fungi	Fungi	97.4	2.23e-22	NR	PJF16449.1	1246581	g22594	i0	48.5	3.93069306930693	97	48	96	1	299	9	135	229	PJF16449.1 60S ribosomal protein L27 [Paramicrosporidium saccamoebae]	diamond	1191	97.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
12318001	12318001	PRJNA849822_P_NODE_9830_length_478_cov_1.348148_g9657_i0	PRJNA849822	9830	478	1.348148	6.44414744	Fungi	4751	Fungi	Fungi	236	9.469999999999999e-74	NR	EPZ36253.1	988480	g9657	i0	70.4	26.9309623430962	159	47	99.8	0	1	477	183	341	EPZ36253.1 Actin-related protein 2 [Rozella allomycis CSF55]	diamond	12873	238	0.991596638655462	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28760169	28760169	PRJNA849822_P_NODE_16727_length_355_cov_0.992908_g16553_i0	PRJNA849822	16727	355	0.992908	3.5248234	Rozella allomycis CSF55	988480	Fungi	Fungi	79	2.77e-14	NR	EPZ32737.1	988480	g16553	i0	35.8	0.895774647887324	106	66	89.6	1	32	349	349	452	EPZ32737.1 DUF1929 domain-containing protein [Rozella allomycis CSF55]	diamond	318	79	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30244651	30244651	PRJNA849822_P_NODE_37852_length_248_cov_0.891429_g37678_i0	PRJNA849822	37852	248	0.891429	2.21074392	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	67	1.11e-10	NR	PJF18005.1	1246581	g37678	i0	62.3	0.641129032258065	53	19	64.1	1	22	180	5	56	PJF18005.1 UDP-glucose 6-dehydrogenase [Paramicrosporidium saccamoebae]	diamond	159	67	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31200207	31200207	PRJNA849822_P_NODE_40575_length_245_cov_0.906977_g40401_i0	PRJNA849822	40575	245	0.906977	2.22209365	Eukaryota	2759	Fungi	Fungi	79.3	3.35e-15	NR	RKP19184.1	988480	g40401	i0	49.3	2.27755102040816	67	34	82	0	45	245	298	364	RKP19184.1 hypothetical protein ROZALSC1DRAFT_29188 [Rozella allomycis CSF55]	diamond	558	79.7	0.994981179422836	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32308129	32308129	PRJNA849822_P_NODE_25179_length_289_cov_1.666667_g25005_i0	PRJNA849822	25179	289	1.666667	4.81666763	root	1	Root_unresolved	Root_unresolved	91.7	4.33e-19	NR	PJF17439.1	1246581	g25005	i0	46.9	4.98269896193772	96	50	99.7	1	288	1	100	194	PJF17439.1 Glutamine synthetase, catalytic domain-containing protein [Paramicrosporidium saccamoebae]	diamond	1440	91.7	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);;