metadata: contig_metadata: 6 rows where bioproject = "PRJEB17675" and tax

6 rows where bioproject = "PRJEB17675" 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
27381017	27381017	PRJEB17675_P_NODE_12903_length_232_cov_1.624365_g12599_i0	PRJEB17675	12903	232	1.624365	3.7685268	Mitosporidium daphniae	1485682	Fungi	Fungi	106	2.6999999999999997e-25	NR	XP_013236430.1	1485682	g12599	i0	68.4	4.91379310344828	76	24	98.3	0	3	230	293	368	XP_013236430.1 mitochondrial isovaleryl-CoA dehydrogenase [Mitosporidium daphniae]	diamond	1140	106	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
27696936	27696936	PRJEB17675_P_NODE_23664_length_157_cov_0.967213_g23360_i0	PRJEB17675	23664	157	0.967213	1.51852441	Astathelohania contejeani	164912	Fungi	Fungi	72.4	3.32e-13	NR	KAF7683933.1	164912	g23360	i0	69.8	7.87261146496815	43	13	82.2	0	2	130	319	361	KAF7683933.1 Developmentally-regulated GTP-binding protein 2 [Astathelohania contejeani]	diamond	1236	72.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Astathelohaniidae	Astathelohania	Astathelohania contejeani
30507133	30507133	PRJEB17675_P_NODE_20633_length_170_cov_1.607407_g20329_i0	PRJEB17675	20633	170	1.607407	2.7325919	Nematocida sp. AWRm8	1927920	Fungi	Fungi	52.4	5.48e-6	NR	KAI5181157.1	2670343	g20329	i0	46	0.882352941176471	50	26	88.2	1	168	19	361	409	KAI5181157.1 importin subunit alpha-1/8 [Nematocida sp. AWRm80]	diamond	150	52.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80
30886220	30886220	PRJEB17675_P_NODE_15134_length_208_cov_2.080925_g14830_i0	PRJEB17675	15134	208	2.080925	4.328324	Hepatospora eriocheir	1081669	Fungi	Fungi	49.3	1.09e-4	NR	ORD97842.1	1081669	g14830	i0	42.9	0.908653846153846	63	34	90.9	1	198	10	84	144	ORD97842.1 DOHH [Hepatospora eriocheir]	diamond	189	49.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Hepatosporidae	Hepatospora	Hepatospora eriocheir
32182924	32182924	PRJEB17675_P_NODE_14278_length_217_cov_1.318681_g13974_i0	PRJEB17675	14278	217	1.318681	2.86153777	Nematocida minor	1912983	Fungi	Fungi	80.5	1.76e-16	NR	XP_051332425.1	1912983	g13974	i0	63	5.69585253456221	54	20	74.7	0	55	216	4	57	XP_051332425.1 choline-phosphate cytidylyltransferase [Nematocida minor]	diamond	1236	80.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida minor
32656643	32656643	PRJEB17675_P_NODE_17880_length_187_cov_1.315789_g17576_i0	PRJEB17675	17880	187	1.315789	2.46052543	Nematocida displodere	1805483	Fungi	Fungi	58.5	4.7e-8	NR	XP_067544945.1	1805483	g17576	i0	41.9	1.98930481283422	62	36	99.5	0	2	187	279	340	XP_067544945.1 ATP-dependent RNA helicase DDX19/DBP5 [Nematocida displodere]	diamond	372	58.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida displodere

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