metadata: contig_metadata: 7 rows where bioproject = "PRJNA188516", tax_kingdom = "Fungi" and tax

7 rows where bioproject = "PRJNA188516", 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
20767348	20767348	PRJNA188516_P_NODE_4117_length_169_cov_0.866667_g4067_i0	PRJNA188516	4117	169	0.866667	1.46466723	Mitosporidium daphniae	1485682	Fungi	Fungi	82.4	3.12e-18	NR	XP_013239437.1	1485682	g4067	i0	78.8	0.923076923076923	52	11	92.3	0	160	5	7	58	XP_013239437.1 40S ribosomal protein S16 [Mitosporidium daphniae]	diamond	156	82.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28621532	28621532	PRJNA188516_P_NODE_4387_length_168_cov_0.873950_g4337_i0	PRJNA188516	4387	168	0.87395	1.468236	Pseudoloma neurophilia	146866	Fungi	Fungi	106	3.46e-25	NR	KRH93196.1	146866	g4337	i0	100	1	56	0	100	0	168	1	402	457	KRH93196.1 Protein disulfide isomerase (prolyl 4-hydroxylase beta subunit) [Pseudoloma neurophilia]	diamond	168	106	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
29316022	29316022	PRJNA188516_P_NODE_3389_length_184_cov_1.925926_g3339_i0	PRJNA188516	3389	184	1.925926	3.54370384	Anncaliia algerae PRA1	723287	Fungi	Fungi	49.7	2.65e-5	NR	KCZ75641.1	1240240	g3339	i0	52.1	0.782608695652174	48	23	78.3	0	27	170	14	61	KCZ75641.1 hypothetical protein H311_03378 [Anncaliia algerae PRA109]	diamond	144	49.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Anncaliia	Anncaliia algerae
29979155	29979155	PRJNA188516_P_NODE_5391_length_164_cov_0.904348_g5341_i0	PRJNA188516	5391	164	0.904348	1.48313072	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	78.2	2.03e-16	NR	OQS55746.1	646526	g5341	i0	64.2	0.969512195121951	53	19	97	0	5	163	38	90	OQS55746.1 hypothetical protein EHP00_2593 [Enterocytozoon hepatopenaei]	diamond	159	78.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
30737315	30737315	PRJNA188516_P_NODE_5214_length_165_cov_0.896552_g5164_i0	PRJNA188516	5214	165	0.896552	1.4793108	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	85.5	4.32e-20	NR	OQS54250.1	646526	g5164	i0	72.7	1	55	15	100	0	1	165	10	64	OQS54250.1 RPL36 [Enterocytozoon hepatopenaei]	diamond	165	85.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
31242919	31242919	PRJNA188516_P_NODE_2675_length_209_cov_1.300000_g2625_i0	PRJNA188516	2675	209	1.3	2.717	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	58.2	2.53e-9	NR	OQS54970.1	646526	g2625	i0	59.1	0.631578947368421	44	18	63.2	0	193	62	12	55	OQS54970.1 hypothetical protein EHP00_1335 [Enterocytozoon hepatopenaei]	diamond	132	58.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
32508681	32508681	PRJNA188516_P_NODE_4299_length_168_cov_0.873950_g4249_i0	PRJNA188516	4299	168	0.87395	1.468236	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	68.9	2.87e-12	NR	OQS54844.1	646526	g4249	i0	63.6	0.982142857142857	55	19	96.4	1	5	166	184	238	OQS54844.1 RPS0 [Enterocytozoon hepatopenaei]	diamond	165	68.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei

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