metadata: contig_metadata: 10 rows where bioproject = "PRJNA703759", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA703759", tax_clade = "Opisthokonta" 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
18536097	18536097	PRJNA703759_P_NODE_27835_length_274_cov_1.542289_g27359_i0	PRJNA703759	27835	274	1.542289	4.22587186	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	184	1.5699999999999995e-54	NR	OQS54413.1	646526	g27359	i0	92.3	0.996350364963504	91	7	99.6	0	274	2	17	107	OQS54413.1 TUB1 [Enterocytozoon hepatopenaei]	diamond	273	184	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
23637520	23637520	PRJNA703759_P_NODE_41639_length_248_cov_0.891429_g41163_i0	PRJNA703759	41639	248	0.891429	2.21074392	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	139	1.26e-36	NR	OQS55835.1	646526	g41163	i0	80.5	0.991935483870968	82	16	99.2	0	246	1	154	235	OQS55835.1 DBP2 [Enterocytozoon hepatopenaei]	diamond	246	139	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
26987742	26987742	PRJNA703759_P_NODE_22562_length_295_cov_1.747748_g22086_i0	PRJNA703759	22562	295	1.747748	5.1558566	Enterospora canceri	1081671	Fungi	Fungi	171	1.31e-51	NR	ORD94116.1	1081671	g22086	i0	84.7	0.996610169491525	98	15	99.7	0	295	2	36	133	ORD94116.1 RL10 [Enterospora canceri]	diamond	294	171	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterospora	Enterospora canceri
28914178	28914178	PRJNA703759_P_NODE_20448_length_307_cov_1.333333_g19972_i0	PRJNA703759	20448	307	1.333333	4.09333231	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	86.3	3.94e-18	NR	OQS54079.1	646526	g19972	i0	43.2	0.928338762214984	95	54	92.8	0	305	21	141	235	OQS54079.1 hypothetical protein EHP00_1799 [Enterocytozoon hepatopenaei]	diamond	285	86.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
29072472	29072472	PRJNA703759_P_NODE_23848_length_289_cov_1.791667_g23372_i0	PRJNA703759	23848	289	1.791667	5.17791763	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	145	1.6e-40	NR	OQS55863.1	646526	g23372	i0	78.1	0.996539792387543	96	21	99.7	0	2	289	74	169	OQS55863.1 RPL4 [Enterocytozoon hepatopenaei]	diamond	288	145	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
29482525	29482525	PRJNA703759_P_NODE_34870_length_253_cov_0.866667_g34394_i0	PRJNA703759	34870	253	0.866667	2.19266751	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	115	1.5e-27	NR	OQS54907.1	646526	g34394	i0	64.6	0.972332015810277	82	29	97.2	0	2	247	419	500	OQS54907.1 Peptidase M1 [Enterocytozoon hepatopenaei]	diamond	246	115	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
29514143	29514143	PRJNA703759_P_NODE_24690_length_286_cov_1.366197_g24214_i0	PRJNA703759	24690	286	1.366197	3.90732342	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	99.8	3.2099999999999994e-24	NR	OQS53780.1	646526	g24214	i0	57.9	0.996503496503496	95	38	97.6	1	284	6	57	151	OQS53780.1 hypothetical protein EHP00_1236 [Enterocytozoon hepatopenaei]	diamond	285	99.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
30240855	30240855	PRJNA703759_P_NODE_47652_length_244_cov_0.912281_g47176_i0	PRJNA703759	47652	244	0.912281	2.22596564	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	90.1	3.86e-19	NR	OQS55467.1	646526	g47176	i0	61.2	0.823770491803279	67	26	82.4	0	218	18	289	355	OQS55467.1 hypothetical protein EHP00_1198 [Enterocytozoon hepatopenaei]	diamond	201	90.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
30272683	30272683	PRJNA703759_P_NODE_34712_length_253_cov_0.866667_g34236_i0	PRJNA703759	34712	253	0.866667	2.19266751	Enterocytozoon hepatopenaei	646526	Fungi	Fungi	47.8	7.52e-4	NR	OQS54357.1	646526	g34236	i0	30	1.18577075098814	100	52	97.2	1	247	2	667	766	OQS54357.1 pad-1 [Enterocytozoon hepatopenaei]	diamond	300	47.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
30777975	30777975	PRJNA703759_P_NODE_7814_length_493_cov_1.485714_g7338_i0	PRJNA703759	7814	493	1.485714	7.32457002	Enterocytozoon bieneusi H348	481877	Fungi	Fungi	249	5.63e-78	NR	EED44298.1	481877	g7338	i0	76.2	0.997971602434077	164	39	99.8	0	493	2	196	359	EED44298.1 protein translation elongation factor EF-1A [Enterocytozoon bieneusi H348]	diamond	492	249	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi

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