metadata: contig_metadata: 5 rows where bioproject = "PRJNA827593", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA827593", tax_clade = "Opisthokonta" 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
7199840	7199840	PRJNA827593_P_NODE_64706_length_245_cov_3.436047_g64407_i0	PRJNA827593	64706	245	3.436047	8.41831515	Rozella sp.	1932610	Fungi	Fungi	130	9.93e-26	NTclustered	gi\|2468791001\|gb\|OQ702917.1\|	1932610	g64407	i0	94.186	48.3428571428571	86	4	35	1	1	86	4295	4379	Rozella sp. isolate PSC230 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	11844	130	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Rozella	Rozella sp.
29170449	29170449	PRJNA827593_P_NODE_33149_length_357_cov_1.957746_g32850_i0	PRJNA827593	33149	357	1.957746	6.98915322	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	138	3.02e-35	NR	PJF16965.1	1246581	g32850	i0	69.7	0.747899159663866	89	27	74.8	0	345	79	32	120	PJF16965.1 Deoxyhypusine hydroxylase [Paramicrosporidium saccamoebae]	diamond	267	138	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
30528355	30528355	PRJNA827593_P_NODE_17373_length_515_cov_1.678733_g17075_i0	PRJNA827593	17373	515	1.678733	8.64547495	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	72	3.32e-11	NR	PJF18855.1	1246581	g17075	i0	33.6	0.745631067961165	128	79	74.6	4	13	396	282	403	PJF18855.1 Dihydrofolate synthetase [Paramicrosporidium saccamoebae]	diamond	384	72	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
31919489	31919489	PRJNA827593_P_NODE_54777_length_268_cov_1.579487_g54478_i0	PRJNA827593	54777	268	1.579487	4.23302516	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	113	6.22e-27	NR	PJF18842.1	1246581	g54478	i0	60.2	0.985074626865672	88	35	98.5	0	266	3	456	543	PJF18842.1 E3 ubiquitinprotein ligase Bre1like [Paramicrosporidium saccamoebae]	diamond	264	113	1	Eukaryota	Opisthokonta	Fungi	Cryptomycota	Paramicrosporidium	Paramicrosporidium saccamoebae
32236202	32236202	PRJNA827593_P_NODE_39018_length_325_cov_2.138889_g38719_i0	PRJNA827593	39018	325	2.138889	6.95138925	Paramicrosporidium saccamoebae	1246581	Fungi	Fungi	87.8	1.03e-17	NR	PJF18855.1	1246581	g38719	i0	44.8	0.969230769230769	105	49	96.9	1	316	2	74	169	PJF18855.1 Dihydrofolate synthetase [Paramicrosporidium saccamoebae]	diamond	315	87.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);;