metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA630162" 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
27775982	27775982	PRJNA630162_P_NODE_81684_length_199_cov_3.253333_g80161_i0	PRJNA630162	81684	199	3.253333	6.47413267	Rozella allomycis CSF55	988480	Fungi	Fungi	47.8	3.26e-4	NR	EPZ32702.1	988480	g80161	i0	49	0.738693467336683	49	25	73.9	0	166	20	1	49	EPZ32702.1 Glycoside hydrolase/deacetylase, beta/alpha-barrel domain-containing protein [Rozella allomycis CSF55]	diamond	147	47.8	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
28135799	28135799	PRJNA630162_P_NODE_144445_length_166_cov_0.888889_g142922_i0	PRJNA630162	144445	166	0.888889	1.47555574	Eukaryota	2759	Fungi	Fungi	111	2.91e-28	NR	PJF19129.1	1246581	g142922	i0	85.2	6.83132530120482	54	8	97.6	0	4	165	81	134	PJF19129.1 Serine/threonine-protein phosphatase [Paramicrosporidium saccamoebae]	diamond	1134	112	0.991071428571429	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29606509	29606509	PRJNA630162_P_NODE_125970_length_171_cov_2.188525_g124447_i0	PRJNA630162	125970	171	2.188525	3.74237775	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	48.1	1.73e-4	NR	PJF19823.1	1246581	g124447	i0	64.7	0.596491228070175	34	12	59.6	0	103	2	107	140	PJF19823.1 Dbp7p [Paramicrosporidium saccamoebae]	diamond	102	48.1	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
30112205	30112205	PRJNA630162_P_NODE_153412_length_163_cov_38.815789_g151889_i0	PRJNA630162	153412	163	38.815789	63.26973607	Rozella allomycis CSF55	988480	Fungi	Fungi	47.8	1.23e-5	NR	RKP19416.1	988480	g151889	i0	66.7	0.607361963190184	33	11	60.7	0	41	139	8	40	RKP19416.1 hypothetical protein ROZALSC1DRAFT_14013, partial [Rozella allomycis CSF55]	diamond	99	47.8	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
31060385	31060385	PRJNA630162_P_NODE_104635_length_183_cov_1.261194_g103112_i0	PRJNA630162	104635	183	1.261194	2.30798502	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	76.6	1.48e-14	NR	PJF17770.1	1246581	g103112	i0	57.6	0.967213114754098	59	25	96.7	0	178	2	260	318	PJF17770.1 hypothetical protein PSACC_02387 [Paramicrosporidium saccamoebae]	diamond	177	76.6	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31230675	31230675	PRJNA630162_P_NODE_126555_length_171_cov_1.606557_g125032_i0	PRJNA630162	126555	171	1.606557	2.74721247	Fungi	4751	Fungi	Fungi	48.1	3.25e-5	NR	RKP18033.1	988480	g125032	i0	50	1.70175438596491	50	23	87.7	1	17	166	49	96	RKP18033.1 PH domain-like protein [Rozella allomycis CSF55]	diamond	291	48.1	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);;