contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1639411 | 1639411 | PRJNA168635_P_NODE_32542_length_161_cov_3.303571_g32126_i0 | PRJNA168635 | 32542 | 161 | 3.303571 | 5.31874931 | Metchnikovella dogieli | 2804710 | Fungi | Fungi | 110 | 7.83e-20 | NTclustered | gi|2131667796|gb|OK155995.1| | 2804710 | g32126 | i0 | 94.366 | 49.9503105590062 | 71 | 4 | 44 | 0 | 83 | 153 | 1599 | 1529 | Metchnikovella dogieli internal transcribed spacer, partial sequence; large subunit ribosomal RNA gene, complete sequence; and intergenic spacer, partial sequence | blastn | 8042 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Metchnikovellidae | Metchnikovella | Metchnikovella dogieli | |||
| 2329438 | 2329438 | PRJNA168635_P_NODE_13742_length_218_cov_3.597633_g13326_i0 | PRJNA168635 | 13742 | 218 | 3.597633 | 7.84283994 | Microsporidium | 144516 | Fungi | Fungi | 110 | 1.13e-19 | NTclustered | gi|656343722|gb|KF894401.1| | 1504584 | g13326 | i0 | 89.535 | 4.01376146788991 | 86 | 9 | 39 | 0 | 59 | 144 | 1363 | 1448 | Microsporidium sp. M1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 875 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. M1 | ||||
| 2329592 | 2329592 | PRJNA168635_P_NODE_30462_length_163_cov_2.701754_g30046_i0 | PRJNA168635 | 30462 | 163 | 2.701754 | 4.40385902 | Orthosomella | 148816 | Fungi | Fungi | 272 | 9.58e-69 | NTclustered | gi|338777455|gb|JF960137.1| | 1049365 | g30046 | i0 | 97.484 | 74.9263803680982 | 159 | 4 | 98 | 0 | 4 | 162 | 870 | 1028 | Unikaryonidae sp. JI-2011 small subunit ribosomal RNA gene, partial sequence | blastn | 12213 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Unikaryonidae sp. JI-2011 | ||||
| 2329624 | 2329624 | PRJNA168635_P_NODE_35082_length_152_cov_7.116505_g34666_i0 | PRJNA168635 | 35082 | 152 | 7.116505 | 10.8170876 | Endoreticulatus | 42400 | Fungi | Fungi | 193 | 7.02e-45 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g34666 | i0 | 90.972 | 44.9407894736842 | 144 | 12 | 94 | 1 | 1 | 143 | 999 | 1142 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 6831 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 2914993 | 2914993 | PRJNA168635_P_NODE_13823_length_217_cov_5.357143_g13407_i0 | PRJNA168635 | 13823 | 217 | 5.357143 | 11.62500031 | Helmichia lacustris | 856670 | Fungi | Fungi | 327 | 2.84e-85 | NTclustered | gi|298919555|gb|GU130406.1| | 856670 | g13407 | i0 | 94.009 | 16.6036866359447 | 217 | 12 | 100 | 1 | 1 | 217 | 665 | 450 | Helmichia lacustris small subunit ribosomal RNA gene, partial sequence | blastn | 3603 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Helmichia | Helmichia lacustris | ||||
| 2915187 | 2915187 | PRJNA168635_P_NODE_24483_length_170_cov_2.545455_g24067_i0 | PRJNA168635 | 24483 | 170 | 2.545455 | 4.3272735 | Episeptum pseudoinversum | 1966657 | Fungi | Fungi | 241 | 2.8300000000000007e-59 | NTclustered | gi|115501686|gb|DQ864441.1| | 1966657 | g24067 | i0 | 92.353 | 5.95294117647059 | 170 | 12 | 100 | 1 | 1 | 170 | 159 | 327 | Episeptum pseudoinversum isolate 15b small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1012 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Gurleyidae | Episeptum | Episeptum pseudoinversum | |||
| 2915347 | 2915347 | PRJNA168635_P_NODE_4183_length_410_cov_28.135734_g102_i3 | PRJNA168635 | 4183 | 410 | 28.135734 | 115.3565094 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 86.1 | 3.88e-12 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g102 | i3 | 80.909 | 0.268292682926829 | 110 | 20 | 27 | 1 | 274 | 383 | 2962 | 2854 | 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 | 110 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 3604735 | 3604735 | PRJNA168635_P_NODE_29943_length_164_cov_0.904348_g29527_i0 | PRJNA168635 | 29943 | 164 | 0.904348 | 1.48313072 | Opisthokonta | 33154 | Fungi | Fungi | 52.8 | 0.014 | NTclustered | gi|449329369|gb|KC513609.1| | 6035 | g29527 | i0 | 100 | 1.19512195121951 | 28 | 0 | 17 | 0 | 1 | 28 | 132527 | 132554 | Encephalitozoon cuniculi clone supercont1.6 genomic sequence | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 5467765 | 5467765 | PRJNA168635_P_NODE_22045_length_176_cov_2.244094_g21629_i0 | PRJNA168635 | 22045 | 176 | 2.244094 | 3.94960544 | uncultured Microsporidium | 1142133 | Fungi | Fungi | 209 | 8.33e-50 | NTclustered | gi|525526973|gb|KC111786.1| | 1142133 | g21629 | i0 | 88.889 | 34.2670454545455 | 171 | 17 | 97 | 2 | 1 | 170 | 31 | 200 | Uncultured Microsporidium sp. clone Comp_L_Van8 18S ribosomal RNA gene, partial sequence | blastn | 6031 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | uncultured Microsporidium | ||||
| 11257565 | 11257565 | PRJNA168635_P_NODE_3069_length_475_cov_62.910798_g2675_i0 | PRJNA168635 | 3069 | 475 | 62.910798 | 298.8262905 | Pleistophoridae | 35232 | Fungi | Fungi | 82.4 | 5.9e-11 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g2675 | i0 | 96 | 3.89052631578947 | 50 | 2 | 21 | 0 | 112 | 161 | 2110 | 2159 | 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 | 1848 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 13118413 | 13118413 | PRJNA168635_P_NODE_31591_length_162_cov_1.840708_g31175_i0 | PRJNA168635 | 31591 | 162 | 1.840708 | 2.98194696 | Antonospora locustae | 278021 | Fungi | Fungi | 60.2 | 8.06e-5 | NTclustered | gi|3252884|gb|AF053589.1|AF053589 | 278021 | g31175 | i0 | 97.143 | 2.85802469135802 | 35 | 1 | 22 | 0 | 8 | 42 | 102 | 136 | Nosema locustae U2 snRNA gene, complete sequence | blastn | 463 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Antonospora | Antonospora locustae | ||||
| 14393763 | 14393763 | PRJNA168635_P_NODE_34212_length_155_cov_4.075472_g33796_i0 | PRJNA168635 | 34212 | 155 | 4.075472 | 6.3169816 | Anisofilariata chironomi | 745834 | Fungi | Fungi | 182 | 1.56e-41 | NTclustered | gi|291603819|gb|GU126383.1| | 745834 | g33796 | i0 | 87.898 | 98.1741935483871 | 157 | 16 | 99 | 2 | 1 | 154 | 880 | 724 | Anisofilariata chironomi isolate CP-NWR-1 small subunit ribosomal RNA gene, partial sequence | blastn | 15217 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Anisofilariata | Anisofilariata chironomi | ||||
| 16356657 | 16356657 | PRJNA168635_P_NODE_21973_length_176_cov_3.181102_g21557_i0 | PRJNA168635 | 21973 | 176 | 3.181102 | 5.59873952 | Endoreticulatus | 42400 | Fungi | Fungi | 219 | 1.3799999999999999e-52 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g21557 | i0 | 90 | 48.7215909090909 | 170 | 16 | 97 | 1 | 4 | 173 | 966 | 1134 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 8575 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 20766148 | 20766148 | PRJNA168635_P_NODE_30417_length_163_cov_3.394737_g30001_i0 | PRJNA168635 | 30417 | 163 | 3.394737 | 5.53342131 | Vavraia culicis | 103449 | Fungi | Fungi | 121 | 3.669999999999999e-23 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g30001 | i0 | 80.368 | 4.04294478527607 | 163 | 28 | 98 | 4 | 4 | 163 | 843 | 1004 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 659 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 20766323 | 20766323 | PRJNA168635_P_NODE_8497_length_289_cov_5.579167_g8082_i0 | PRJNA168635 | 8497 | 289 | 5.579167 | 16.12379263 | Endoreticulatus sp. CHW-2004 Taiwan | 262393 | Fungi | Fungi | 193 | 1.51e-44 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g8082 | i0 | 79.167 | 23.5813148788927 | 288 | 52 | 99 | 7 | 1 | 285 | 1747 | 2029 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 6815 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 22041181 | 22041181 | PRJNA168635_P_NODE_28518_length_165_cov_2.603448_g28102_i0 | PRJNA168635 | 28518 | 165 | 2.603448 | 4.2956892 | Vittaforma corneae | 42399 | Fungi | Fungi | 244 | 2.12e-60 | NTclustered | gi|1389130261|gb|MH333240.1| | 42399 | g28102 | i0 | 97.222 | 87.2848484848485 | 144 | 4 | 87 | 0 | 22 | 165 | 657 | 800 | Vittaforma corneae strain wwy1 small subunit ribosomal RNA gene, partial sequence | blastn | 14402 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 23316487 | 23316487 | PRJNA168635_P_NODE_16279_length_198_cov_3.449664_g15863_i0 | PRJNA168635 | 16279 | 198 | 3.449664 | 6.83033472 | Helmichia lacustris | 856670 | Fungi | Fungi | 294 | 2.58e-75 | NTclustered | gi|298919555|gb|GU130406.1| | 856670 | g15863 | i0 | 98.214 | 59.6010101010101 | 168 | 3 | 85 | 0 | 31 | 198 | 1280 | 1113 | Helmichia lacustris small subunit ribosomal RNA gene, partial sequence | blastn | 11801 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Helmichia | Helmichia lacustris | ||||
| 24590561 | 24590561 | PRJNA168635_P_NODE_13860_length_217_cov_2.327381_g13444_i0 | PRJNA168635 | 13860 | 217 | 2.327381 | 5.05041677 | Microsporidium sp. BWOH3 | 698284 | Fungi | Fungi | 296 | 8.02e-76 | NTclustered | gi|272477506|gb|FJ756188.1| | 698284 | g13444 | i0 | 91.284 | 69.1612903225806 | 218 | 17 | 100 | 2 | 1 | 217 | 379 | 595 | Microsporidium sp. BWOH3 small subunit ribosomal RNA gene, partial sequence | blastn | 15008 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BWOH3 | ||||
| 24590838 | 24590838 | PRJNA168635_P_NODE_29420_length_164_cov_3.895652_g29004_i0 | PRJNA168635 | 29420 | 164 | 3.895652 | 6.38886928 | Glugoides intestinalis | 174680 | Fungi | Fungi | 134 | 4.75e-27 | NTclustered | gi|113470857|gb|DQ680158.2| | 174680 | g29004 | i0 | 89.623 | 42.5365853658537 | 106 | 9 | 64 | 2 | 3 | 107 | 476 | 580 | 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 | 6976 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis |
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);;