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

5 rows where bioproject = "PRJNA340009" and tax_phylum = "Microsporidia"

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_family	tax_genus	tax_species
24618245	24618245	PRJNA340009_P_NODE_33460_length_217_cov_1.238095_g33153_i0	PRJNA340009	33460	217	1.238095	2.68666615	Nosematidae	27974	Fungi	Fungi	116	3.5800000000000003e-29	NR	XP_007604468.1	993615	g33153	i0	80	1.93548387096774	70	14	96.8	0	217	8	40	109	XP_007604468.1 26S protease regulatory subunit 8 [Vittaforma corneae ATCC 50505]	diamond	420	116	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
27169298	27169298	PRJNA340009_P_NODE_51362_length_181_cov_2.893939_g51055_i0	PRJNA340009	51362	181	2.893939	5.23802959	Enteropsectra breve	1912989	Fungi	Fungi	76.6	1.52e-16	NR	KAI5149819.1	1912989	g51055	i0	64.2	0.878453038674033	53	19	87.8	0	1	159	36	88	KAI5149819.1 large subunit ribosomal protein L37e [Enteropsectra breve]	diamond	159	76.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve
28179886	28179886	PRJNA340009_P_NODE_36286_length_209_cov_7.062500_g35979_i0	PRJNA340009	36286	209	7.0625	14.760625	Pancytospora epiphaga	1938578	Fungi	Fungi	87.4	1.69e-18	NR	KAI5169592.1	1938578	g35979	i0	81.3	11.3397129186603	48	9	68.9	0	199	56	285	332	KAI5169592.1 DNA repair protein RAD51 [Pancytospora epiphaga]	diamond	2370	87.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga
29506118	29506118	PRJNA340009_P_NODE_13430_length_320_cov_3.313653_g13123_i0	PRJNA340009	13430	320	3.313653	10.6036896	Mitosporidium daphniae	1485682	Fungi	Fungi	72.8	2.53e-12	NR	XP_013237514.1	1485682	g13123	i0	73.1	0.8625	52	13	47.8	1	302	150	500	551	XP_013237514.1 theta subunit of T-complex protein 1 [Mitosporidium daphniae]	diamond	276	72.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
31939551	31939551	PRJNA340009_P_NODE_69597_length_164_cov_0.886957_g69290_i0	PRJNA340009	69597	164	0.886957	1.45460948	Nematocida sp. AWRm8	1927920	Fungi	Fungi	43.9	0.00505	NR	KAI5181525.1	2670343	g69290	i0	51.2	0.75	41	20	75	0	3	125	807	847	KAI5181525.1 elongation factor 2 [Nematocida sp. AWRm80]	diamond	123	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80

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);;