metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA944406" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA944406" 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
7302287	7302287	PRJNA944406_P_NODE_13806_length_343_cov_1.140741_g12847_i0	PRJNA944406	13806	343	1.140741	3.91274163	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	191	7.44e-59	NR	PJF17825.1	1246581	g12847	i0	74.6	4.95918367346939	114	29	99.7	0	343	2	46	159	PJF17825.1 hypothetical protein PSACC_02363 [Paramicrosporidium saccamoebae]	diamond	1701	191	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
27909494	27909494	PRJNA944406_P_NODE_29765_length_282_cov_1.473684_g28806_i0	PRJNA944406	29765	282	1.473684	4.15578888	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	124	9.2e-31	NR	PJF17226.1	1246581	g28806	i0	68.1	1	94	29	98.9	1	280	2	627	720	PJF17226.1 DNA helicase [Paramicrosporidium saccamoebae]	diamond	282	124	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
29141404	29141404	PRJNA944406_P_NODE_93909_length_244_cov_1.035088_g92950_i0	PRJNA944406	93909	244	1.035088	2.52561472	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	132	2.39e-36	NR	PJF17825.1	1246581	g92950	i0	73.8	3.83606557377049	80	21	98.4	0	3	242	41	120	PJF17825.1 hypothetical protein PSACC_02363 [Paramicrosporidium saccamoebae]	diamond	936	132	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32396620	32396620	PRJNA944406_P_NODE_85099_length_246_cov_1.335260_g84140_i0	PRJNA944406	85099	246	1.33526	3.2847396	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	85.5	1.31e-17	NR	PJF18422.1	1246581	g84140	i0	51.9	0.98780487804878	81	39	98.8	0	244	2	230	310	PJF18422.1 Mannose-1-phosphate guanyltransferase [Paramicrosporidium saccamoebae]	diamond	243	85.5	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32617671	32617671	PRJNA944406_P_NODE_10960_length_377_cov_1.440789_g10001_i0	PRJNA944406	10960	377	1.440789	5.43177453	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	169	1.1699999999999998e-47	NR	PJF17735.1	1246581	g10001	i0	61.9	1.0026525198939	126	46	98.7	1	5	376	127	252	PJF17735.1 hypothetical protein PSACC_02450 [Paramicrosporidium saccamoebae]	diamond	378	169	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);;