metadata: contig_metadata: 7 rows where bioproject = "PRJNA914897" and tax

7 rows where bioproject = "PRJNA914897" 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
4723345	4723345	PRJNA914897_P_NODE_19504_length_385_cov_2.125000_g19082_i0	PRJNA914897	19504	385	2.125	8.18125	Fungi	4751	Fungi	Fungi	197	5.57e-61	NR	EPZ32691.1	988480	g19082	i0	74	12.8493506493506	127	33	99	0	381	1	1	127	EPZ32691.1 40S ribosomal protein S4 [Rozella allomycis CSF55]	diamond	4947	197	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
12374155	12374155	PRJNA914897_P_NODE_40490_length_244_cov_49.666667_g40066_i0	PRJNA914897	40490	244	49.666667	121.18666748	Rozella allomycis CSF55	988480	Fungi	Fungi	82.4	7.49e-17	NR	EPZ34692.1	988480	g40066	i0	66.2	3.86065573770492	65	21	78.7	1	23	214	190	254	EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55]	diamond	942	82.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
23847108	23847108	PRJNA914897_P_NODE_2159_length_1298_cov_5.081633_g1960_i0	PRJNA914897	2159	1298	5.081633	65.95959634	Eukaryota	2759	Fungi	Fungi	217	5.1899999999999995e-62	NR	EPZ33472.1	988480	g1960	i0	63.5	2.87981510015408	178	65	41.1	0	772	239	192	369	EPZ33472.1 Cysteine desulfurase, mitochondrial [Rozella allomycis CSF55]	diamond	3738	218	0.995412844036697	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28477349	28477349	PRJNA914897_P_NODE_31366_length_281_cov_1.067308_g30942_i0	PRJNA914897	31366	281	1.067308	2.99913548	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	67.4	7.61e-11	NR	PJF18115.1	1246581	g30942	i0	47.7	0.918149466192171	86	43	91.8	2	277	20	31	114	PJF18115.1 Lupus La protein [Paramicrosporidium saccamoebae]	diamond	258	67.4	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29014427	29014427	PRJNA914897_P_NODE_6328_length_786_cov_1.100982_g5956_i0	PRJNA914897	6328	786	1.100982	8.65371852	Rozella allomycis CSF55	988480	Fungi	Fungi	141	1.06e-35	NR	EPZ36789.1	988480	g5956	i0	41.1	0.725190839694656	190	106	72.1	5	219	785	49	233	EPZ36789.1 Protein farnesyltransferase subunit beta domain-containing protein [Rozella allomycis CSF55]	diamond	570	141	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31921063	31921063	PRJNA914897_P_NODE_1717_length_1409_cov_3.481287_g1555_i0	PRJNA914897	1717	1409	3.481287	49.05133383	Rozella allomycis CSF55	988480	Fungi	Fungi	71.6	1.96e-9	NR	RKP16186.1	988480	g1555	i0	23.6	2.05039034776437	365	242	74.1	12	265	1308	21	365	RKP16186.1 Indoleamine 2,3-dioxygenase [Rozella allomycis CSF55]	diamond	2889	71.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
32110960	32110960	PRJNA914897_P_NODE_10198_length_590_cov_1.638298_g9781_i0	PRJNA914897	10198	590	1.638298	9.6659582	Rozella allomycis CSF55	988480	Fungi	Fungi	53.5	1.79e-4	NR	EPZ33762.1	988480	g9781	i0	29.4	0.727118644067797	143	86	71.7	2	586	164	274	403	EPZ33762.1 IKI3 domain-containing protein [Rozella allomycis CSF55]	diamond	429	53.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);;