metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA879067" 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
2130760	2130760	PRJNA879067_P_NODE_55102_length_484_cov_4.566910_g51617_i0	PRJNA879067	55102	484	4.56691	22.1038444	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	119	3.92e-31	NR	PJF18579.1	1246581	g51617	i0	54.5	0.898760330578512	145	48	88.6	5	430	2	1	129	PJF18579.1 Subunit common to RNA polymerases I, II, and [Paramicrosporidium saccamoebae]	diamond	435	119	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
7232246	7232246	PRJNA879067_P_NODE_14206_length_1266_cov_18.647946_g11658_i0	PRJNA879067	14206	1266	18.647946	236.08299636	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	232	1.95e-66	NR	PJF19928.1	1246581	g11658	i0	42.7	0.71563981042654	302	163	71.6	6	2	907	261	552	PJF19928.1 hypothetical protein PSACC_00256, partial [Paramicrosporidium saccamoebae]	diamond	906	232	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
21256749	21256749	PRJNA879067_P_NODE_31037_length_746_cov_21.760773_g27706_i0	PRJNA879067	31037	746	21.760773	162.33536658	Fungi	4751	Fungi	Fungi	212	6.45e-66	NR	EPZ32213.1	988480	g27706	i0	56.4	6.2171581769437	172	75	69.2	0	655	140	6	177	EPZ32213.1 60S ribosomal protein L20-B [Rozella allomycis CSF55]	diamond	4638	212	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
26802005	26802005	PRJNA879067_P_NODE_49821_length_526_cov_2.503311_g46341_i0	PRJNA879067	49821	526	2.503311	13.16741586	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	140	3.54e-36	NR	PJF19542.1	1246581	g46341	i0	45.3	0.96958174904943	170	77	93.5	6	496	5	291	450	PJF19542.1 Serine/threonine-dual specificity kinase domain-containing protein [Paramicrosporidium saccamoebae]	diamond	510	140	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);;