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

5 rows where bioproject = "PRJNA867519", 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
18699592	18699592	PRJNA867519_P_NODE_9455_length_366_cov_1.860068_g9301_i0	PRJNA867519	9455	366	1.860068	6.80784888	Nematocida sp. LUAm3	2670340	Fungi	Fungi	194	1.84e-58	NR	KAI5170777.1	2670340	g9301	i0	82.8	18.0655737704918	122	20	99.2	1	3	365	2	123	KAI5170777.1 hypothetical protein NEFER03_0236 [Nematocida sp. LUAm3]	diamond	6612	194	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. LUAm3
29116047	29116047	PRJNA867519_P_NODE_10728_length_349_cov_1.115942_g10574_i0	PRJNA867519	10728	349	1.115942	3.89463758	Fungi	4751	Fungi	Fungi	62.4	9.87e-9	NR	KAG0416868.1	288439	g10574	i0	33.3	2.15759312320917	123	74	99.7	2	348	1	34	155	KAG0416868.1 putative phospholipid-transporting ATPase IIB, partial [Dictyocoela roeselum]	diamond	753	62.8	0.993630573248408	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela roeselum
29494807	29494807	PRJNA867519_P_NODE_16830_length_290_cov_1.064516_g16676_i0	PRJNA867519	16830	290	1.064516	3.0870964	Opisthokonta	33154	Fungi	Fungi	48.5	5.94e-4	NR	XP_003073518.1	876142	g16676	i0	36.8	2.33793103448276	76	42	76.6	2	2	223	55	126	XP_003073518.1 Ca2+-binding actin-bundling protein fimbrin/plastin [Encephalitozoon intestinalis ATCC 50506]	diamond	678	48.9	0.991820040899796	Eukaryota	Opisthokonta	Fungi	Microsporidia	Unikaryonidae	Encephalitozoon	Encephalitozoon intestinalis
29802346	29802346	PRJNA867519_P_NODE_16751_length_290_cov_1.419355_g16597_i0	PRJNA867519	16751	290	1.419355	4.1161295	Mitosporidium daphniae	1485682	Fungi	Fungi	43.1	0.0449	NR	XP_013238457.1	1485682	g16597	i0	37.7	0.796551724137931	77	42	77.6	3	52	276	287	359	XP_013238457.1 uncharacterized protein DI09_222p10 [Mitosporidium daphniae]	diamond	231	43.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
31793310	31793310	PRJNA867519_P_NODE_33537_length_241_cov_0.916667_g33383_i0	PRJNA867519	33537	241	0.916667	2.20916747	Mitosporidium daphniae	1485682	Fungi	Fungi	68.9	1.89e-11	NR	XP_013238342.1	1485682	g33383	i0	75	0.49792531120332	40	10	49.8	0	234	115	335	374	XP_013238342.1 uncharacterized protein DI09_24p20 [Mitosporidium daphniae]	diamond	120	68.9	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);;