metadata: contig_metadata: 4 rows where bioproject = "PRJNA876641", tax_kingdom = "Fungi" and tax

4 rows where bioproject = "PRJNA876641", tax_kingdom = "Fungi" 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
22529822	22529822	PRJNA876641_P_NODE_14058_length_259_cov_1.629032_g13984_i0	PRJNA876641	14058	259	1.629032	4.21919288	Opisthokonta	33154	Fungi	Fungi	102	4.18e-25	NR	RVD92979.1	291195	g13984	i0	67.6	11.2818532818533	71	23	82.2	0	258	46	103	173	RVD92979.1 60S ribosomal L11 [Tubulinosema ratisbonensis]	diamond	2922	102	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Tubulinosema	Tubulinosema ratisbonensis
26991759	26991759	PRJNA876641_P_NODE_21362_length_244_cov_0.865497_g21288_i0	PRJNA876641	21362	244	0.865497	2.11181268	Mitosporidium daphniae	1485682	Fungi	Fungi	135	1.22e-36	NR	XP_013239014.1	1485682	g21288	i0	80.2	0.995901639344262	81	16	99.6	0	243	1	122	202	XP_013239014.1 cofactor-APC complex of cell division cycle 20-like protein 1 [Mitosporidium daphniae]	diamond	243	135	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28255284	28255284	PRJNA876641_P_NODE_16786_length_250_cov_0.870056_g16712_i0	PRJNA876641	16786	250	0.870056	2.17514	Dictyocoela muelleri	279532	Fungi	Fungi	67	1.1e-10	NR	KAG0440048.1	279532	g16712	i0	53.8	0.624	52	23	62.4	1	161	6	409	459	KAG0440048.1 Replication protein A 70 kDa DNA-binding subunit [Dictyocoela muelleri]	diamond	156	67	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
31667014	31667014	PRJNA876641_P_NODE_14597_length_256_cov_1.836066_g14523_i0	PRJNA876641	14597	256	1.836066	4.70032896	Mitosporidium daphniae	1485682	Fungi	Fungi	76.6	3.89e-14	NR	XP_013236957.1	1485682	g14523	i0	51.2	0.9609375	82	40	96.1	0	254	9	232	313	XP_013236957.1 uncharacterized protein DI09_67p180 [Mitosporidium daphniae]	diamond	246	76.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae

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