metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB6584" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB6584" 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
25795774	25795774	PRJEB6584h_S_NODE_20915_length_178_cov_3.706294_g20853_i0	PRJEB6584	20915	178	3.706294	6.59720332	Ichthyosporidium weissii	1172315	Fungi	Fungi	228	2.3299999999999995e-55	NTclustered	gi\|384232434\|gb\|JQ062988.1\|	1172315	g20853	i0	90.23	97.061797752809	174	17	98	0	1	174	1551	1378	Ichthyosporidium weissii small subunit ribosomal RNA gene, partial sequence; small subunit rRNA-large subunit rRNA intergenic spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	17277	228	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Ichthyosporidium	Ichthyosporidium weissii
25795806	25795806	PRJEB6584h_S_NODE_57203_length_162_cov_1.259843_g57141_i0	PRJEB6584	57203	162	1.259843	2.04094566	Vavraia culicis subsp. floridensis	948595	Fungi	Fungi	196	5.89e-46	NTclustered	gi\|667636757\|ref\|XR_552273.1\|	948595	g57141	i0	90.541	1.81481481481481	148	14	91	0	15	162	2636	2489	Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA	blastn	294	196	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia culicis
25932093	25932093	PRJEB6584h_S_NODE_8068_length_214_cov_3.837989_g8006_i0	PRJEB6584	8068	214	3.837989	8.21329646	Pleistophora sp. 1	73787	Fungi	Fungi	156	1.4e-33	NTclustered	gi\|3033524\|gb\|AF044394.1\|	73787	g8006	i0	81.553	57.7429906542056	206	22	91	10	3	197	1346	1146	Pleistophora sp.1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	12357	156	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Pleistophora	Pleistophora sp. 1
26068029	26068029	PRJEB6584h_S_NODE_1949_length_330_cov_5.420339_g1887_i0	PRJEB6584	1949	330	5.420339	17.8871187	Fusasporis stethaprioni	2777717	Fungi	Fungi	488	2e-133	NTclustered	gi\|1914073495\|gb\|MW077214.1\|	2777717	g1887	i0	93.353	95.7333333333333	331	21	100	1	1	330	465	795	Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence	blastn	31592	488	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Glugeidae	Fusasporis	Fusasporis stethaprioni
26204362	26204362	PRJEB6584h_S_NODE_6294_length_229_cov_11.453608_g6232_i0	PRJEB6584	6294	229	11.453608	26.22876232	Microsporidium sp. LVPEI.SMW V3S1-FR	1734473	Fungi	Fungi	374	3.8399999999999996e-99	NTclustered	gi\|937656209\|gb\|KR303710.1\|	1734473	g6232	i0	96.46	100.519650655022	226	8	99	0	4	229	978	753	Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence	blastn	23019	374	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Microsporidium	Microsporidium sp. LVPEI.SMW V3S1-FR
26204370	26204370	PRJEB6584h_S_NODE_8222_length_213_cov_3.730337_g8160_i0	PRJEB6584	8222	213	3.730337	7.94561781	Endoreticulatus sp. CHW-2	133530	Fungi	Fungi	152	1.8e-32	NTclustered	gi\|63095238\|gb\|AY960111.1\|	262393	g8160	i0	83.14	1.1830985915493	172	24	80	4	20	189	562	394	Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence	blastn	252	152	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Endoreticulatus	Endoreticulatus sp. CHW-2004 Taiwan
26204376	26204376	PRJEB6584h_S_NODE_9798_length_204_cov_2.112426_g9736_i0	PRJEB6584	9798	204	2.112426	4.30934904	Glugoides intestinalis	174680	Fungi	Fungi	257	3.51e-64	NTclustered	gi\|113470857\|gb\|DQ680158.2\|	174680	g9736	i0	89.655	8.65686274509804	203	19	99	2	1	202	71	272	Glugoides intestinalis isolate Gi3 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence	blastn	1766	257	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Glugeidae	Glugoides	Glugoides intestinalis
26340127	26340127	PRJEB6584h_S_NODE_21919_length_177_cov_2.845070_g21857_i0	PRJEB6584	21919	177	2.84507	5.0357739	Vittaforma corneae ATCC 5	42399	Fungi	Fungi	182	1.83e-41	NTclustered	gi\|667639983\|ref\|XR_552275.1\|	993615	g21857	i0	85.475	4.11299435028249	179	20	99	5	2	177	967	1142	Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA	blastn	728	182	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma corneae
26568100	26568100	PRJEB6584h_S_NODE_1216_length_378_cov_2.862974_g1154_i0	PRJEB6584	1216	378	2.862974	10.82204172	Vittaforma	42398	Fungi	Fungi	603	7.929999999999999e-168	NTclustered	gi\|38489197\|gb\|AY375043.1\|	255593	g1154	i0	100	86.7592592592593	326	0	86	0	53	378	470	145	Vittaforma-like parasite isolate 5830 small subunit ribosomal RNA gene, partial sequence	blastn	32795	603	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vittaforma	Vittaforma-like parasite isolate 5830

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