metadata: contig_metadata: 5 rows where bioproject = "PRJNA1195374", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA1195374", 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
9970680	9970680	PRJNA1195374_P_NODE_1748_length_1343_cov_13.688976_g1595_i0	PRJNA1195374	1748	1343	13.688976	183.84294768	Fungi	4751	Fungi	Fungi	183	4.67e-41	NTclustered	gi\|1378896647\|gb\|MF278562.1\|	1485682	g1595	i0	95.652	17.1630677587491	115	4	18	1	1038	1152	5537	5650	Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, 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	23050	183	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
26755694	26755694	PRJNA1195374_P_NODE_39861_length_354_cov_1.096085_g39517_i0	PRJNA1195374	39861	354	1.096085	3.8801409	Cucumispora dikerogammari	658444	Fungi	Fungi	61.2	2.24e-9	NR	KAF7698662.1	658444	g39517	i0	32.7	4.83898305084746	101	55	83.1	2	319	26	16	106	KAF7698662.1 Transposable element Tc3 transposase [Cucumispora dikerogammari]	diamond	1713	61.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Cucumispora	Cucumispora dikerogammari
27420338	27420338	PRJNA1195374_P_NODE_43763_length_336_cov_0.958175_g43419_i0	PRJNA1195374	43763	336	0.958175	3.219468	Antonospora locustae	278021	Fungi	Fungi	43.9	0.0353	NR	AAT12327.1	278021	g43419	i0	28.3	0.883928571428571	99	65	85.7	2	26	313	3	98	AAT12327.1 hypothetical protein [Antonospora locustae]	diamond	297	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Antonospora	Antonospora locustae
27925264	27925264	PRJNA1195374_P_NODE_36245_length_373_cov_1.763333_g35901_i0	PRJNA1195374	36245	373	1.763333	6.57723209	Nematocida minor	1912983	Fungi	Fungi	66.2	2.05e-10	NR	XP_051333867.1	1912983	g35901	i0	48	0.603217158176944	75	32	55.5	2	368	162	98	171	XP_051333867.1 Ras-related protein Rab-1A [Nematocida minor]	diamond	225	66.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida minor
30217716	30217716	PRJNA1195374_P_NODE_71892_length_250_cov_1.740113_g71548_i0	PRJNA1195374	71892	250	1.740113	4.3502825	Hamiltosporidium	1176354	Fungi	Fungi	82.4	4.7e-18	NR	TBT96880.1	148818	g71548	i0	75	4.404	52	13	62.4	0	250	95	68	119	TBT96880.1 transcription initiation factor IID, partial [Hamiltosporidium magnivora]	diamond	1101	82.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Dubosqiidae	Hamiltosporidium	Hamiltosporidium magnivora

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