metadata: contig_metadata: 5 rows where bioproject = "PRJNA681822" and tax

5 rows where bioproject = "PRJNA681822" 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
4999309	4999309	PRJNA681822_P_NODE_438764_length_245_cov_1.790698_g437275_i0	PRJNA681822	438764	245	1.790698	4.3872101	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	158	2.2e-43	NR	PJF16950.1	1246581	g437275	i0	85.2	0.991836734693878	81	12	99.2	0	2	244	484	564	PJF16950.1 Receptor of activated protein kinase C 1 [Paramicrosporidium saccamoebae]	diamond	243	158	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
13408698	13408698	PRJNA681822_P_NODE_358591_length_258_cov_1.389189_g357102_i0	PRJNA681822	358591	258	1.389189	3.58410762	Rozella sp.	1932610	Fungi	Fungi	111	3.82e-20	NTclustered	gi\|2468791009\|gb\|OQ702919.1\|	1932610	g357102	i0	79.167	32.0426356589147	168	29	64	5	1	164	4465	4300	Rozella sp. isolate PSC238 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	8267	111	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella sp.
27903064	27903064	PRJNA681822_P_NODE_354485_length_259_cov_1.655914_g352996_i0	PRJNA681822	354485	259	1.655914	4.28881726	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	161	1.0699999999999999e-43	NR	PJF19231.1	1246581	g352996	i0	86.7	0.961389961389961	83	11	96.1	0	258	10	1103	1185	PJF19231.1 Aminoacyl-tRNA synthetase, class Ia domain-containing protein [Paramicrosporidium saccamoebae]	diamond	249	161	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
30587404	30587404	PRJNA681822_P_NODE_463293_length_243_cov_0.905882_g461803_i0	PRJNA681822	463293	243	0.905882	2.20129326	Rozella allomycis CSF55	988480	Fungi	Fungi	88.2	3.11e-18	NR	RKP19300.1	988480	g461803	i0	57.5	0.901234567901235	73	31	90.1	0	233	15	360	432	RKP19300.1 Pkinase-domain-containing protein [Rozella allomycis CSF55]	diamond	219	88.2	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella allomycis
30935181	30935181	PRJNA681822_P_NODE_305774_length_272_cov_4.125628_g304285_i0	PRJNA681822	305774	272	4.125628	11.22170816	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	77.8	2.64e-15	NR	PJF17534.1	1246581	g304285	i0	75	2.21691176470588	52	13	57.4	0	3	158	153	204	PJF17534.1 Ribosomal protein L15 [Paramicrosporidium saccamoebae]	diamond	603	77.8	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);;