metadata: contig_metadata: 14 rows where bioproject = "PRJNA1240805" and tax

14 rows where bioproject = "PRJNA1240805" 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
1050478	1050478	PRJNA1240805_P_NODE_5141_length_201_cov_14.328947_g5092_i0	PRJNA1240805	5141	201	14.328947	28.80118347	Microsporidium	144516	Fungi	Fungi	322	1.21e-83	NTclustered	gi\|267672584\|gb\|FJ820194.1\|	546760	g5092	i0	98.895	90.0547263681592	181	1	90	1	1	180	667	487	Uncultured Microsporidia clone BFAS8 small subunit ribosomal RNA gene, partial sequence	blastn	18101	322	1	Eukaryota	Opisthokonta	Fungi	Microsporidia			uncultured Microsporidia
9277711	9277711	PRJNA1240805_P_NODE_5448_length_195_cov_17.623288_g5399_i0	PRJNA1240805	5448	195	17.623288	34.3654116	Vittaforma corneae	42399	Fungi	Fungi	191	3.42e-44	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g5399	i0	91.367	2.75897435897436	139	12	71	0	34	172	2378	2240	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	538	191	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
10553524	10553524	PRJNA1240805_P_NODE_5949_length_187_cov_111.347826_g5900_i0	PRJNA1240805	5949	187	111.347826	208.22043462	Vittaforma corneae	42399	Fungi	Fungi	134	5.56e-27	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g5900	i0	86.667	0.641711229946524	120	16	64	0	1	120	1408	1289	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	120	134	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
11253791	11253791	PRJNA1240805_P_NODE_1649_length_381_cov_3.409639_g1600_i0	PRJNA1240805	1649	381	3.409639	12.99072459	Microsporidium	144516	Fungi	Fungi	614	3.6899999999999996e-171	NTclustered	gi\|2054360354\|gb\|MZ405755.1\|	546760	g1600	i0	99.12	88.3202099737533	341	3	90	0	24	364	20	360	Uncultured Microsporidia clone OTU_19923 small subunit ribosomal RNA gene, partial sequence	blastn	33650	614	1	Eukaryota	Opisthokonta	Fungi	Microsporidia			uncultured Microsporidia
11828150	11828150	PRJNA1240805_P_NODE_850_length_543_cov_56.896761_g803_i0	PRJNA1240805	850	543	56.896761	308.94941223	Vittaforma corneae	42399	Fungi	Fungi	335	4.729999999999999e-87	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g803	i0	82.687	1.22467771639042	387	58	71	8	22	405	385	5	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	665	335	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
14378464	14378464	PRJNA1240805_P_NODE_1752_length_366_cov_165.719243_g1703_i0	PRJNA1240805	1752	366	165.719243	606.53242938	Microsporidium sp. LVPEI.SMW V3S1-FR	1734473	Fungi	Fungi	588	2.1399999999999994e-163	NTclustered	gi\|937656209\|gb\|KR303710.1\|	1734473	g1703	i0	97.935	92.655737704918	339	7	93	0	18	356	1055	717	Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence	blastn	33912	588	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Microsporidium	Microsporidium sp. LVPEI.SMW V3S1-FR
14378480	14378480	PRJNA1240805_P_NODE_3012_length_270_cov_22.230769_g2963_i0	PRJNA1240805	3012	270	22.230769	60.0230763	Microsporidium sp. BLAT21	698151	Fungi	Fungi	457	4.49e-124	NTclustered	gi\|272477390\|gb\|FJ756072.1\|	698151	g2963	i0	100	91.6185185185185	247	0	91	0	1	247	560	314	Microsporidium sp. BLAT21 small subunit ribosomal RNA gene, partial sequence	blastn	24737	457	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Microsporidium	Microsporidium sp. BLAT21
14378494	14378494	PRJNA1240805_P_NODE_4772_length_209_cov_6.975000_g4723_i0	PRJNA1240805	4772	209	6.975	14.57775	Eukaryota	2759	Fungi	Fungi	108	2.51e-28	NR	KAI5149971.1	1912989	g4723	i0	82.3	2.66985645933014	62	11	89	0	187	2	95	156	KAI5149971.1 small subunit ribosomal protein S14e [Enteropsectra breve]	diamond	558	108	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve
15078085	15078085	PRJNA1240805_P_NODE_5052_length_203_cov_5.220779_g5003_i0	PRJNA1240805	5052	203	5.220779	10.59818137	Pleistophoridae	35232	Fungi	Fungi	82.4	2.26e-11	NTclustered	gi\|2017842940\|gb\|MW811106.1\|	103445	g5003	i0	96	4.44827586206897	50	2	25	0	150	199	2159	2110	Ovipleistophora ovariae isolate 2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	903	82.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Ovipleistophora	Ovipleistophora ovariae
18201145	18201145	PRJNA1240805_P_NODE_1675_length_378_cov_19.419453_g1626_i0	PRJNA1240805	1675	378	19.419453	73.40553234	Vittaforma corneae	42399	Fungi	Fungi	472	2.3299999999999996e-128	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g1626	i0	91.404	12.6534391534392	349	23	91	5	17	361	943	598	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	4783	472	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
19475481	19475481	PRJNA1240805_P_NODE_3516_length_247_cov_1.717172_g3467_i0	PRJNA1240805	3516	247	1.717172	4.24141484	Vittaforma corneae	42399	Fungi	Fungi	196	9.75e-46	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g3467	i0	90.132	1.79352226720648	152	14	62	1	57	208	1255	1105	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	443	196	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
29347325	29347325	PRJNA1240805_P_NODE_4649_length_212_cov_7.944785_g4600_i0	PRJNA1240805	4649	212	7.944785	16.8429442	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	78.6	7.62e-16	NR	XP_007605062.1	993615	g4600	i0	58	0.976415094339623	69	29	97.6	0	4	210	141	209	XP_007605062.1 uncharacterized protein VICG_01617 [Vittaforma corneae ATCC 50505]	diamond	207	78.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
31464276	31464276	PRJNA1240805_P_NODE_7736_length_166_cov_2.068376_g7687_i0	PRJNA1240805	7736	166	2.068376	3.43350416	Nematocida sp. LUAm3	2670340	Fungi	Fungi	54.7	3.26e-7	NR	KAI5170870.1	2670340	g7687	i0	61.9	0.759036144578313	42	16	75.9	0	165	40	133	174	KAI5170870.1 large subunit ribosomal protein L11e [Nematocida sp. LUAm3]	diamond	126	54.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. LUAm3
31906860	31906860	PRJNA1240805_P_NODE_2097_length_332_cov_6.424028_g2048_i0	PRJNA1240805	2097	332	6.424028	21.32777296	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	119	9.06e-30	NR	XP_007605485.1	993615	g2048	i0	58.6	0.786144578313253	87	36	78.6	0	5	265	70	156	XP_007605485.1 uncharacterized protein VICG_02040 [Vittaforma corneae ATCC 50505]	diamond	261	119	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae

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