contig_metadata
12 rows where bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2166705 | 2166705 | PRJNA911178_P_NODE_114402_length_341_cov_3.257463_g111930_i0 | PRJNA911178 | 114402 | 341 | 3.257463 | 11.10794883 | Glugoides intestinalis | 174680 | Fungi | Fungi | 110 | 1.89e-19 | NTclustered | gi|113470857|gb|DQ680158.2| | 174680 | g111930 | i0 | 84.821 | 21.9618768328446 | 112 | 13 | 32 | 3 | 132 | 241 | 1425 | 1534 | 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 | 7489 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis | |||
| 8902339 | 8902339 | PRJNA911178_P_NODE_10847_length_1009_cov_9.614316_g9166_i0 | PRJNA911178 | 10847 | 1009 | 9.614316 | 97.00844844 | Fungi | 4751 | Fungi | Fungi | 183 | 3.48e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g9166 | i0 | 95.652 | 13.0317145688801 | 115 | 4 | 11 | 1 | 845 | 959 | 5537 | 5650 | 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 | 13149 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 11096414 | 11096414 | PRJNA911178_P_NODE_295609_length_240_cov_2.778443_g293135_i0 | PRJNA911178 | 295609 | 240 | 2.778443 | 6.6682632 | uncultured Nosema | 198216 | Fungi | Fungi | 313 | 8.97e-81 | NTclustered | gi|157366978|gb|EU119071.1| | 198216 | g293135 | i0 | 91.026 | 71.8166666666667 | 234 | 17 | 97 | 3 | 9 | 240 | 148 | 379 | Uncultured Nosema clone Biofilm5-2 small subunit ribosomal RNA gene, partial sequence | blastn | 17236 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | uncultured Nosema | |||
| 11096519 | 11096519 | PRJNA911178_P_NODE_309149_length_198_cov_4.632000_g306675_i0 | PRJNA911178 | 309149 | 198 | 4.632 | 9.17136 | Vittaforma corneae | 42399 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g306675 | i0 | 100 | 0.151515151515152 | 30 | 0 | 15 | 0 | 44 | 73 | 2370 | 2341 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 16194316 | 16194316 | PRJNA911178_P_NODE_133133_length_320_cov_3.631579_g130660_i0 | PRJNA911178 | 133133 | 320 | 3.631579 | 11.6210528 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 79 | 1.23e-14 | NR | KAI5181725.1 | 2670343 | g130660 | i0 | 57.7 | 0.73125 | 78 | 32 | 73.1 | 1 | 3 | 236 | 33 | 109 | KAI5181725.1 hypothetical protein NEOKW01_1889, partial [Nematocida sp. AWRm80] | diamond | 234 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 17470506 | 17470506 | PRJNA911178_P_NODE_219834_length_261_cov_1.526596_g217360_i0 | PRJNA911178 | 219834 | 261 | 1.526596 | 3.98441556 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 320 | 5.91e-83 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g217360 | i0 | 95.96 | 1.30268199233716 | 198 | 7 | 75 | 1 | 65 | 261 | 3206 | 3403 | 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 | 340 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 17471785 | 17471785 | PRJNA911178_P_NODE_85714_length_385_cov_5.618590_g83246_i0 | PRJNA911178 | 85714 | 385 | 5.61859 | 21.6315715 | Amphiamblys sp. WSBS2011 | 1892499 | Fungi | Fungi | 69.4 | 3.65e-7 | NTclustered | gi|1059048644|gb|KX214675.1| | 1892499 | g83246 | i0 | 82.278 | 0.706493506493507 | 79 | 14 | 21 | 0 | 101 | 179 | 573 | 651 | Amphiamblys sp. WSBS2011 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 272 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2011 | |||
| 17471793 | 17471793 | PRJNA911178_P_NODE_87034_length_383_cov_1.648387_g84564_i0 | PRJNA911178 | 87034 | 383 | 1.648387 | 6.31332221 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 75 | 7.8e-9 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g84564 | i0 | 95.652 | 0.120104438642298 | 46 | 2 | 12 | 0 | 331 | 376 | 2917 | 2962 | 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 | |||
| 23844651 | 23844651 | PRJNA911178_P_NODE_238539_length_251_cov_5.668539_g236065_i0 | PRJNA911178 | 238539 | 251 | 5.668539 | 14.22803289 | Nematocida sp. | 1927920 | Fungi | Fungi | 176 | 1.2899999999999999e-39 | NTclustered | gi|2689392687|gb|PP413724.1| | 1927920 | g236065 | i0 | 80.603 | 27.0637450199203 | 232 | 42 | 92 | 3 | 21 | 251 | 992 | 1221 | Nematocida sp. isolate MKI67 small subunit ribosomal RNA gene, partial sequence | blastn | 6793 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. | ||||
| 23845276 | 23845276 | PRJNA911178_P_NODE_32739_length_595_cov_5.009579_g30375_i0 | PRJNA911178 | 32739 | 595 | 5.009579 | 29.80699505 | Spraguea lophii | 51541 | Fungi | Fungi | 86.1 | 5.8e-12 | NTclustered | gi|2367144050|pdb|7QCA|L50 | 1358809 | g30375 | i0 | 81.481 | 0.181512605042017 | 108 | 17 | 18 | 2 | 35 | 141 | 1547 | 1442 | Chain L50, RNA 23S | blastn | 108 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 27561365 | 27561365 | PRJNA911178_P_NODE_175044_length_286_cov_1.272300_g172571_i0 | PRJNA911178 | 175044 | 286 | 1.2723 | 3.638778 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 75.9 | 1.27e-13 | NR | XP_013239596.1 | 1485682 | g172571 | i0 | 43.8 | 1.00699300699301 | 96 | 50 | 96.5 | 2 | 9 | 284 | 339 | 434 | XP_013239596.1 ubiquitin carboxyl-terminal hydrolase [Mitosporidium daphniae] | diamond | 288 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 29645102 | 29645102 | PRJNA911178_P_NODE_306130_length_222_cov_7.838926_g303656_i0 | PRJNA911178 | 306130 | 222 | 7.838926 | 17.40241572 | Nematocida parisii | 586133 | Fungi | Fungi | 55.8 | 6.37e-7 | NR | KAI5159699.1 | 586133 | g303656 | i0 | 64 | 0.675675675675676 | 50 | 17 | 66.2 | 1 | 6 | 152 | 76 | 125 | KAI5159699.1 hypothetical protein NEPAR05_2515, partial [Nematocida parisii] | diamond | 150 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida parisii |
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);;