contig_metadata
17 rows where bioproject = "PRJNA743294", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 722125 | 722125 | PRJNA743294_P_NODE_47941_length_251_cov_0.876404_g47485_i0 | PRJNA743294 | 47941 | 251 | 0.876404 | 2.19977404 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 75 | 4.85e-9 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g47485 | i0 | 95.652 | 0.183266932270916 | 46 | 2 | 18 | 0 | 176 | 221 | 2962 | 2917 | 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 | 46 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 3273567 | 3273567 | PRJNA743294_P_NODE_57563_length_237_cov_3.603659_g57107_i0 | PRJNA743294 | 57563 | 237 | 3.603659 | 8.54067183 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 60.2 | 1.27e-4 | NTclustered | gi|914965904|ref|XM_013384195.1| | 1485682 | g57107 | i0 | 97.143 | 0.270042194092827 | 35 | 1 | 15 | 0 | 151 | 185 | 151 | 185 | Mitosporidium daphniae uncharacterized protein (DI09_103p60), partial mRNA | blastn | 64 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 16501296 | 16501296 | PRJNA743294_P_NODE_23933_length_335_cov_6.492366_g23477_i0 | PRJNA743294 | 23933 | 335 | 6.492366 | 21.7494261 | Fungi | 4751 | Fungi | Fungi | 183 | 1.0699999999999998e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g23477 | i0 | 95.652 | 35.9313432835821 | 115 | 4 | 34 | 1 | 58 | 172 | 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 | 12037 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 20324808 | 20324808 | PRJNA743294_P_NODE_55576_length_243_cov_0.917647_g55120_i0 | PRJNA743294 | 55576 | 243 | 0.917647 | 2.22988221 | Fungi | 4751 | Fungi | Fungi | 107 | 1.9899999999999999e-25 | NR | KAK6090315.1 | 40135 | g55120 | i0 | 62.3 | 3.44444444444444 | 69 | 26 | 85.2 | 0 | 32 | 238 | 1 | 69 | KAK6090315.1 hypothetical protein P3W45_000672 [Vairimorpha bombi] | diamond | 837 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha bombi | |||
| 26926038 | 26926038 | PRJNA743294_P_NODE_26882_length_319_cov_1.268293_g26426_i0 | PRJNA743294 | 26882 | 319 | 1.268293 | 4.04585467 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 58.5 | 2.34e-7 | NR | XP_007603942.1 | 993615 | g26426 | i0 | 46.2 | 0.489028213166144 | 52 | 28 | 48.9 | 0 | 304 | 149 | 176 | 227 | XP_007603942.1 uncharacterized protein VICG_00490 [Vittaforma corneae ATCC 50505] | diamond | 156 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 27842164 | 27842164 | PRJNA743294_P_NODE_58224_length_234_cov_2.186335_g57768_i0 | PRJNA743294 | 58224 | 234 | 2.186335 | 5.1160239 | Spraguea lophii 42_11 | 51541 | Fungi | Fungi | 87.8 | 4.5e-18 | NR | EPR80086.1 | 1358809 | g57768 | i0 | 64.5 | 3.71794871794872 | 62 | 22 | 79.5 | 0 | 223 | 38 | 786 | 847 | EPR80086.1 DNA-directed RNA polymerase II complex subunit Rpb2 [Spraguea lophii 42_110] | diamond | 870 | 88.2 | 0.99546485260771 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 29137135 | 29137135 | PRJNA743294_P_NODE_49489_length_249_cov_1.715909_g49033_i0 | PRJNA743294 | 49489 | 249 | 1.715909 | 4.27261341 | Nematocida sp. LUAm3 | 2670340 | Fungi | Fungi | 43.1 | 0.0262 | NR | KAI5172630.1 | 2670340 | g49033 | i0 | 33.8 | 0.927710843373494 | 77 | 51 | 92.8 | 0 | 2 | 232 | 27 | 103 | KAI5172630.1 cyclin-dependent kinase 2 [Nematocida sp. LUAm3] | diamond | 231 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. LUAm3 | ||||
| 29389585 | 29389585 | PRJNA743294_P_NODE_27669_length_315_cov_1.239669_g27213_i0 | PRJNA743294 | 27669 | 315 | 1.239669 | 3.90495735 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 92.4 | 3.2e-19 | NR | KAF7702637.1 | 658444 | g27213 | i0 | 51.9 | 2.39047619047619 | 79 | 38 | 75.2 | 0 | 244 | 8 | 12 | 90 | KAF7702637.1 DNA-directed RNA polymerase I subunit RPA1 [Cucumispora dikerogammari] | diamond | 753 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 29420831 | 29420831 | PRJNA743294_P_NODE_39329_length_271_cov_1.045455_g38873_i0 | PRJNA743294 | 39329 | 271 | 1.045455 | 2.83318305 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 50.8 | 6.94e-5 | NR | EED44158.1 | 481877 | g38873 | i0 | 33 | 0.974169741697417 | 88 | 57 | 96.3 | 2 | 4 | 264 | 71 | 157 | EED44158.1 RNA-binding protein, predicted [Enterocytozoon bieneusi H348] | diamond | 264 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 29547117 | 29547117 | PRJNA743294_P_NODE_14730_length_417_cov_18.968023_g14274_i0 | PRJNA743294 | 14730 | 417 | 18.968023 | 79.09665591 | Nematocida ausubeli | 1913371 | Fungi | Fungi | 46.6 | 0.00868 | NR | XP_052905589.1 | 1913371 | g14274 | i0 | 43.9 | 0.669064748201439 | 57 | 28 | 41 | 1 | 107 | 277 | 30 | 82 | XP_052905589.1 uncharacterized protein NESG_00106 [Nematocida ausubeli] | diamond | 279 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida ausubeli | ||||
| 30779308 | 30779308 | PRJNA743294_P_NODE_18934_length_372_cov_2.227425_g18478_i0 | PRJNA743294 | 18934 | 372 | 2.227425 | 8.286021 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 51.2 | 1.82e-4 | NR | EJW04015.1 | 1003232 | g18478 | i0 | 50 | 0.32258064516129 | 40 | 20 | 32.3 | 0 | 4 | 123 | 1726 | 1765 | EJW04015.1 hypothetical protein EDEG_01698 [Edhazardia aedis USNM 41457] | diamond | 120 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 30789382 | 30789382 | PRJNA743294_P_NODE_7834_length_560_cov_2.965092_g7379_i0 | PRJNA743294 | 7834 | 560 | 2.965092 | 16.6045152 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 1.73e-5 | NR | KAG0441259.1 | 279532 | g7379 | i0 | 30.7 | 1.77857142857143 | 101 | 54 | 45.5 | 3 | 490 | 236 | 93 | 193 | KAG0441259.1 Ran GTPase-activating protein 1 [Dictyocoela muelleri] | diamond | 996 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 30969086 | 30969086 | PRJNA743294_P_NODE_55634_length_243_cov_0.917647_g55178_i0 | PRJNA743294 | 55634 | 243 | 0.917647 | 2.22988221 | Anncaliia algerae PRA339 | 1288291 | Fungi | Fungi | 40.8 | 0.0439 | NR | KCZ81851.1 | 1288291 | g55178 | i0 | 57.1 | 0.345679012345679 | 28 | 12 | 34.6 | 0 | 152 | 69 | 45 | 72 | KCZ81851.1 hypothetical protein H312_00750 [Anncaliia algerae PRA339] | diamond | 84 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 31063929 | 31063929 | PRJNA743294_P_NODE_56155_length_242_cov_1.349112_g55699_i0 | PRJNA743294 | 56155 | 242 | 1.349112 | 3.26485104 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 58.2 | 1.32e-7 | NR | RVD92603.1 | 291195 | g55699 | i0 | 40 | 1.98347107438017 | 80 | 36 | 99.2 | 2 | 242 | 3 | 213 | 280 | RVD92603.1 UTP-glucose-1-phosphate uridylyltransferase [Tubulinosema ratisbonensis] | diamond | 480 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 31727654 | 31727654 | PRJNA743294_P_NODE_49337_length_249_cov_2.482955_g48881_i0 | PRJNA743294 | 49337 | 249 | 2.482955 | 6.18255795 | Hamiltosporidium tvaerminnensis | 1176355 | Fungi | Fungi | 46.2 | 0.00162 | NR | TBU11887.1 | 1176355 | g48881 | i0 | 36 | 1.07228915662651 | 89 | 45 | 94 | 3 | 248 | 15 | 77 | 164 | TBU11887.1 hypothetical protein CWI38_0995p0020 [Hamiltosporidium tvaerminnensis] | diamond | 267 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium tvaerminnensis | |||
| 32202333 | 32202333 | PRJNA743294_P_NODE_2338_length_960_cov_16.549042_g2015_i0 | PRJNA743294 | 2338 | 960 | 16.549042 | 158.8708032 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 77.8 | 1.43e-12 | NR | XP_013236389.1 | 1485682 | g2015 | i0 | 38.6 | 0.4125 | 132 | 73 | 39.1 | 6 | 196 | 570 | 109 | 239 | XP_013236389.1 uncharacterized protein DI09_9p70 [Mitosporidium daphniae] | diamond | 396 | 77.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 32613361 | 32613361 | PRJNA743294_P_NODE_21600_length_351_cov_1.687050_g21144_i0 | PRJNA743294 | 21600 | 351 | 1.68705 | 5.9215455 | Vairimorpha necatrix | 6039 | Fungi | Fungi | 51.2 | 1.26e-4 | NR | XP_065330597.1 | 6039 | g21144 | i0 | 27.8 | 2.52991452991453 | 97 | 70 | 82.9 | 0 | 6 | 296 | 264 | 360 | XP_065330597.1 E3 ubiquitin-protein ligase NEDD4-like [Vairimorpha necatrix] | diamond | 888 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix |
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);;