metadata: contig_metadata: 12 rows where bioproject = "PRJNA594101", tax_clade = "Opisthokonta" and tax

12 rows where bioproject = "PRJNA594101", 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
9495687	9495687	PRJNA594101_S_NODE_8188_length_571_cov_2.578313_g7888_i0	PRJNA594101	8188	571	2.578313	14.72216723	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	198	1.3499999999999998e-57	NR	XP_007604860.1	993615	g7888	i0	58	5.31173380035026	162	63	85.1	2	486	1	145	301	XP_007604860.1 cysteine-tRNA ligase [Vittaforma corneae ATCC 50505]	diamond	3033	198	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
13893445	13893445	PRJNA594101_S_NODE_11771_length_480_cov_1.911548_g11469_i0	PRJNA594101	11771	480	1.911548	9.1754304	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	84	1.45e-15	NR	OIR57626.1	1866961	g11469	i0	33.6	2.44375	128	82	78.8	2	100	477	20	146	OIR57626.1 MAG: histone-binding protein RBBP4 [Amphiamblys sp. WSBS2006]	diamond	1173	84	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
26636545	26636545	PRJNA594101_S_NODE_44861_length_261_cov_1.223404_g44559_i0	PRJNA594101	44861	261	1.223404	3.19308444	Mitosporidium daphniae	1485682	Fungi	Fungi	47.8	8.25e-4	NR	XP_013237124.1	1485682	g44559	i0	33.7	1.05747126436782	92	51	96.6	3	1	252	367	456	XP_013237124.1 subunit of mRNA cleavage factor complex [Mitosporidium daphniae]	diamond	276	47.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28184961	28184961	PRJNA594101_S_NODE_7366_length_602_cov_2.328922_g7069_i0	PRJNA594101	7366	602	2.328922	14.02011044	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	63.2	4.01e-8	NR	XP_007603568.1	993615	g7069	i0	38.2	0.338870431893688	68	42	33.9	0	601	398	12	79	XP_007603568.1 uncharacterized protein VICG_00115 [Vittaforma corneae ATCC 50505]	diamond	204	63.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
28956598	28956598	PRJNA594101_S_NODE_35868_length_289_cov_1.425926_g35566_i0	PRJNA594101	35868	289	1.425926	4.12092614	Nematocida	586132	Fungi	Fungi	48.9	5.4e-5	NR	XP_051332159.1	1912983	g35566	i0	42.6	1.12110726643599	54	30	56.1	1	93	254	10	62	XP_051332159.1 mediator of RNA polymerase II transcription subunit 31 [Nematocida minor]	diamond	324	48.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida minor
29290239	29290239	PRJNA594101_S_NODE_5529_length_691_cov_2.533981_g5244_i0	PRJNA594101	5529	691	2.533981	17.50980871	Edhazardia aedis USNM 41457	1003232	Fungi	Fungi	129	2.13e-33	NR	EJW04091.1	1003232	g5244	i0	37.5	2.32706222865412	208	117	89.4	4	7	624	9	205	EJW04091.1 small GTP-binding protein domain [Edhazardia aedis USNM 41457]	diamond	1608	129	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
29619043	29619043	PRJNA594101_S_NODE_51490_length_248_cov_0.880000_g51188_i0	PRJNA594101	51490	248	0.88	2.1824	Anncaliia	311453	Fungi	Fungi	59.3	5.15e-8	NR	KCZ77893.1	1240240	g51188	i0	36.6	2.96370967741935	82	49	98	2	3	245	48	127	KCZ77893.1 PLK protein kinase, partial [Anncaliia algerae PRA109]	diamond	735	59.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Anncaliia	Anncaliia algerae
30788286	30788286	PRJNA594101_S_NODE_20174_length_373_cov_1.990000_g19872_i0	PRJNA594101	20174	373	1.99	7.4227	Fungi	4751	Fungi	Fungi	70.1	3.93e-11	NR	OIR57732.1	1866961	g19872	i0	31.7	1.9544235924933	123	80	95.7	2	368	12	337	459	OIR57732.1 MAG: protein disulfide isomerase [Amphiamblys sp. WSBS2006]	diamond	729	70.5	0.994326241134752	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
30901332	30901332	PRJNA594101_S_NODE_39714_length_276_cov_1.477833_g39412_i0	PRJNA594101	39714	276	1.477833	4.07881908	Nematocida sp. LUAm3	2670340	Fungi	Fungi	97.4	3.3e-21	NR	KAI5172789.1	2670340	g39412	i0	64.7	0.739130434782609	68	22	71.7	1	199	2	74	141	KAI5172789.1 valyl-tRNA synthetase [Nematocida sp. LUAm3]	diamond	204	97.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. LUAm3
31248777	31248777	PRJNA594101_S_NODE_33015_length_300_cov_1.162996_g32713_i0	PRJNA594101	33015	300	1.162996	3.488988	Nematocida sp. AWRm8	1927920	Fungi	Fungi	142	5.4399999999999995e-37	NR	KAI5181369.1	2670343	g32713	i0	60.8	0.97	97	38	97	0	298	8	770	866	KAI5181369.1 DNA topoisomerase II [Nematocida sp. AWRm80]	diamond	291	142	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80
31343809	31343809	PRJNA594101_S_NODE_56696_length_242_cov_0.911243_g56394_i0	PRJNA594101	56696	242	0.911243	2.20520806	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	43.9	0.0143	NR	OIR57869.1	1866961	g56394	i0	31.4	1.57438016528926	70	47	86.8	1	15	224	481	549	OIR57869.1 MAG: DNA replication factor A protein 1 [Amphiamblys sp. WSBS2006]	diamond	381	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
31818080	31818080	PRJNA594101_S_NODE_17657_length_396_cov_1.554180_g17355_i0	PRJNA594101	17657	396	1.55418	6.1545528	Encephalitozoon hellem	27973	Fungi	Fungi	44.7	0.0403	NR	KAG5859834.1	27973	g17355	i0	30.8	0.787878787878788	104	44	78.8	4	312	1	208	283	KAG5859834.1 RNA helicase [Encephalitozoon hellem]	diamond	312	44.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Unikaryonidae	Encephalitozoon	Encephalitozoon hellem

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