metadata: contig_metadata: 6 rows where bioproject = "PRJNA594101", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA594101", 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
26636563	26636563	PRJNA594101_S_NODE_5621_length_685_cov_3.073529_g5334_i0	PRJNA594101	5621	685	3.073529	21.05367365	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	76.6	4.56e-12	NR	PJF19333.1	1246581	g5334	i0	24.6	2.0014598540146	224	142	96.4	7	660	1	252	452	PJF19333.1 hypothetical protein PSACC_00828 [Paramicrosporidium saccamoebae]	diamond	1371	76.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
26890154	26890154	PRJNA594101_S_NODE_30541_length_310_cov_1.383966_g30239_i0	PRJNA594101	30541	310	1.383966	4.2902946	Rozella allomycis CSF55	988480	Fungi	Fungi	71.6	5.83e-12	NR	RKP17956.1	988480	g30239	i0	42.2	0.870967741935484	90	51	87.1	1	6	275	620	708	RKP17956.1 hypothetical protein ROZALSC1DRAFT_30291 [Rozella allomycis CSF55]	diamond	270	71.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29385129	29385129	PRJNA594101_S_NODE_49169_length_251_cov_0.865169_g48867_i0	PRJNA594101	49169	251	0.865169	2.17157419	Rozella allomycis CSF55	988480	Fungi	Fungi	57	3.75e-7	NR	EPZ32903.1	988480	g48867	i0	32.9	8.97609561752988	85	53	99.2	3	250	2	60	142	EPZ32903.1 Serine/threonine-dual specificity kinase domain-containing protein [Rozella allomycis CSF55]	diamond	2253	57	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
29416407	29416407	PRJNA594101_S_NODE_12409_length_468_cov_2.883544_g12107_i0	PRJNA594101	12409	468	2.883544	13.49498592	Rozella allomycis CSF55	988480	Fungi	Fungi	85.1	2.06e-16	NR	EPZ31566.1	988480	g12107	i0	42.2	0.987179487179487	154	80	98.1	3	468	10	26	171	EPZ31566.1 hypothetical protein O9G_000042 [Rozella allomycis CSF55]	diamond	462	85.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30364544	30364544	PRJNA594101_S_NODE_36332_length_287_cov_2.158879_g36030_i0	PRJNA594101	36332	287	2.158879	6.19598273	Rozella allomycis CSF55	988480	Fungi	Fungi	47	0.00201	NR	RKP20297.1	988480	g36030	i0	30.2	1.00348432055749	96	64	99.3	2	2	286	491	584	RKP20297.1 DUF580-domain-containing protein [Rozella allomycis CSF55]	diamond	288	47	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30522096	30522096	PRJNA594101_S_NODE_57693_length_241_cov_0.916667_g57391_i0	PRJNA594101	57693	241	0.916667	2.20916747	Rozella allomycis CSF55	988480	Fungi	Fungi	43.5	0.0169	NR	EPZ36383.1	988480	g57391	i0	46.2	1.0207468879668	39	21	48.5	0	215	99	79	117	EPZ36383.1 RNA recognition motif domain-containing protein [Rozella allomycis CSF55]	diamond	246	43.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);;