contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1237347" and tax_phylum = "Microsporidia"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 338880 | 338880 | PRJNA1237347_P_NODE_222161_length_404_cov_2.664653_g215589_i0 | PRJNA1237347 | 222161 | 404 | 2.664653 | 10.76519812 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 507 | 6.88e-139 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g215589 | i0 | 89.409 | 101.091584158416 | 406 | 37 | 100 | 5 | 1 | 404 | 355 | 756 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 40841 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 345349 | 345349 | PRJNA1237347_P_NODE_565021_length_229_cov_2.275641_g558447_i0 | PRJNA1237347 | 565021 | 229 | 2.275641 | 5.21121789 | Vairimorpha necatrix | 6039 | Fungi | Fungi | 67.6 | 7.3e-7 | NTclustered | gi|2735583194|ref|XM_065472807.1| | 6039 | g558447 | i0 | 84.507 | 2.63755458515284 | 71 | 7 | 30 | 3 | 3 | 71 | 523 | 591 | Vairimorpha necatrix Rho-associated protein kinase (VNE69_02253), partial mRNA | blastn | 604 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 7998039 | 7998039 | PRJNA1237347_P_NODE_516987_length_245_cov_6.174419_g510414_i0 | PRJNA1237347 | 516987 | 245 | 6.174419 | 15.12732655 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 350 | 7e-92 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g510414 | i0 | 92.593 | 81.8489795918367 | 243 | 18 | 99 | 0 | 3 | 245 | 4 | 246 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 20053 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 10549574 | 10549574 | PRJNA1237347_P_NODE_567449_length_222_cov_4.295302_g560875_i0 | PRJNA1237347 | 567449 | 222 | 4.295302 | 9.53557044 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 411 | 2.8199999999999996e-110 | NTclustered | gi|1372264419|ref|XR_002966747.1| | 40302 | g560875 | i0 | 100 | 80.6801801801802 | 222 | 0 | 100 | 0 | 1 | 222 | 854 | 1075 | Nosema ceranae 23S ribosomal RNA (AAJ76_1700062503), rRNA | blastn | 17911 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 13090401 | 13090401 | PRJNA1237347_P_NODE_121711_length_600_cov_3.313093_g115196_i0 | PRJNA1237347 | 121711 | 600 | 3.313093 | 19.878558 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 342 | 3.15e-89 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g115196 | i0 | 87.542 | 2.85 | 297 | 35 | 82 | 2 | 3 | 298 | 2717 | 3012 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1710 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15075924 | 15075924 | PRJNA1237347_P_NODE_33172_length_1346_cov_541.402985_g29394_i0 | PRJNA1237347 | 33172 | 1346 | 541.402985 | 7287.2841781 | Fungi | 4751 | Fungi | Fungi | 183 | 4.68e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g29394 | i0 | 95.652 | 17.2622585438336 | 115 | 4 | 18 | 1 | 198 | 312 | 5650 | 5537 | Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23235 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 15642454 | 15642454 | PRJNA1237347_P_NODE_247873_length_376_cov_5.983498_g241300_i0 | PRJNA1237347 | 247873 | 376 | 5.983498 | 22.49795248 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 695 | 0 | NTclustered | gi|1779934425|dbj|LC510200.1| | 40302 | g241300 | i0 | 100 | 100 | 376 | 0 | 100 | 0 | 1 | 376 | 378 | 753 | Nosema ceranae gene for SSU rRNA, partial sequence, clone: NCS16 | blastn | 37600 | 695 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 15642953 | 15642953 | PRJNA1237347_P_NODE_273013_length_354_cov_2.156584_g266440_i0 | PRJNA1237347 | 273013 | 354 | 2.156584 | 7.63430736 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 87.9 | 9.18e-13 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g266440 | i0 | 82.828 | 0.279661016949153 | 99 | 16 | 28 | 1 | 256 | 354 | 2854 | 2951 | Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 99 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 15643054 | 15643054 | PRJNA1237347_P_NODE_277573_length_350_cov_6.166065_g271000_i0 | PRJNA1237347 | 277573 | 350 | 6.166065 | 21.5812275 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 291 | 6.44e-74 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g271000 | i0 | 81.972 | 6.63142857142857 | 355 | 52 | 99 | 11 | 3 | 350 | 1743 | 2092 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2321 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 16350440 | 16350440 | PRJNA1237347_P_NODE_253433_length_371_cov_2.859060_g246860_i0 | PRJNA1237347 | 253433 | 371 | 2.85906 | 10.6071126 | Vairimorpha | 6038 | Fungi | Fungi | 686 | 0 | NTclustered | gi|1769784452|gb|MN608539.1| | 33700 | g246860 | i0 | 100 | 99.9649595687331 | 371 | 0 | 100 | 0 | 1 | 371 | 1143 | 773 | Vairimorpha sp. clone B5-2 small subunit ribosomal RNA gene, partial sequence | blastn | 37087 | 686 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha sp. | |||
| 16920550 | 16920550 | PRJNA1237347_P_NODE_446094_length_261_cov_1.117021_g439521_i0 | PRJNA1237347 | 446094 | 261 | 1.117021 | 2.91542481 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 95.3 | 3.9e-15 | NTclustered | gi|2052683922|gb|MW864067.1| | 1485682 | g439521 | i0 | 85.87 | 0.789272030651341 | 92 | 10 | 34 | 2 | 4 | 93 | 5369 | 5279 | Mitosporidium daphniae strain UGP3 mitochondrion, partial genome | blastn | 206 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 18191046 | 18191046 | PRJNA1237347_P_NODE_249135_length_375_cov_2.241722_g242562_i0 | PRJNA1237347 | 249135 | 375 | 2.241722 | 8.4064575 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 675 | 0 | NTclustered | gi|68053514|gb|DQ078785.1| | 40302 | g242562 | i0 | 99.2 | 78.2826666666667 | 375 | 1 | 99 | 1 | 1 | 373 | 2553 | 2927 | Nosema ceranae small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 29356 | 675 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 19468154 | 19468154 | PRJNA1237347_P_NODE_377036_length_289_cov_2.129630_g370463_i0 | PRJNA1237347 | 377036 | 289 | 2.12963 | 6.1546307 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 532 | 7.84e-147 | NTclustered | gi|218533565|gb|FJ481911.1| | 40302 | g370463 | i0 | 100 | 85.7647058823529 | 288 | 0 | 99 | 0 | 1 | 288 | 452 | 739 | Nosema ceranae strain C7 large subunit ribosomal RNA gene, partial sequence | blastn | 24786 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 24570978 | 24570978 | PRJNA1237347_P_NODE_524060_length_245_cov_0.895349_g517487_i0 | PRJNA1237347 | 524060 | 245 | 0.895349 | 2.19360505 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 268 | 2.02e-67 | NTclustered | gi|1372266968|ref|XM_024476562.1| | 40302 | g517487 | i0 | 86.975 | 10.7918367346939 | 238 | 31 | 100 | 0 | 8 | 245 | 326 | 89 | Nosema ceranae collagen triple helix repeat-containing protein (AAJ76_870006810), partial mRNA | blastn | 2644 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae |
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);;