contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB55122" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 121163 | 121163 | PRJEB55122_P_NODE_35201_length_173_cov_1.669355_g34804_i0 | PRJEB55122 | 35201 | 173 | 1.669355 | 2.88798415 | Vittaforma corneae | 42399 | Fungi | Fungi | 176 | 8.26e-40 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g34804 | i0 | 86.061 | 3.79768786127168 | 165 | 22 | 95 | 1 | 1 | 164 | 977 | 1141 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 657 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 2671060 | 2671060 | PRJEB55122_P_NODE_29843_length_192_cov_1.664336_g29446_i0 | PRJEB55122 | 29843 | 192 | 1.664336 | 3.19552512 | Vittaforma corneae | 42399 | Fungi | Fungi | 226 | 9.209999999999997e-55 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g29446 | i0 | 88.421 | 3.53645833333333 | 190 | 18 | 98 | 3 | 5 | 192 | 2405 | 2218 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 679 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 2671069 | 2671069 | PRJEB55122_P_NODE_30063_length_191_cov_2.788732_g29666_i0 | PRJEB55122 | 30063 | 191 | 2.788732 | 5.32647812 | Vittaforma corneae | 42399 | Fungi | Fungi | 156 | 1.22e-33 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g29666 | i0 | 92.661 | 0.570680628272251 | 109 | 6 | 57 | 2 | 19 | 126 | 186 | 79 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 109 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 3946889 | 3946889 | PRJEB55122_P_NODE_24504_length_217_cov_3.511905_g24107_i0 | PRJEB55122 | 24504 | 217 | 3.511905 | 7.62083385 | Endoreticulatus sp. CHW-2004 Taiwan | 262393 | Fungi | Fungi | 117 | 6.700000000000001e-22 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g24107 | i0 | 79.878 | 1.28571428571429 | 164 | 29 | 75 | 4 | 55 | 217 | 1943 | 1783 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 279 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 3947235 | 3947235 | PRJEB55122_P_NODE_34604_length_175_cov_1.626984_g34207_i0 | PRJEB55122 | 34604 | 175 | 1.626984 | 2.847222 | Pleistophora mulleri | 249366 | Fungi | Fungi | 302 | 1.33e-77 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g34207 | i0 | 97.714 | 52.8 | 175 | 4 | 100 | 0 | 1 | 175 | 2863 | 3037 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 9240 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 7772693 | 7772693 | PRJEB55122_P_NODE_10187_length_400_cov_3.245014_g9793_i0 | PRJEB55122 | 10187 | 400 | 3.245014 | 12.980056 | Parahepatospora carcini | 1892323 | Fungi | Fungi | 394 | 5.53e-105 | NTclustered | gi|1059045654|gb|KX757849.1| | 1892323 | g9793 | i0 | 84.938 | 92.3125 | 405 | 43 | 98 | 14 | 1 | 392 | 587 | 188 | Parahepatospora carcini isolate RA14060_326 18S ribosomal RNA gene, partial sequence | blastn | 36925 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Parahepatospora | Parahepatospora carcini | ||||
| 12874881 | 12874881 | PRJEB55122_P_NODE_42051_length_163_cov_1.368421_g41654_i0 | PRJEB55122 | 42051 | 163 | 1.368421 | 2.23052623 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g41654 | i0 | 100 | 100.006134969325 | 163 | 0 | 100 | 0 | 1 | 163 | 1716 | 1554 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 16301 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 13745191 | 13745191 | PRJEB55122_P_NODE_13651_length_324_cov_2.436364_g13254_i0 | PRJEB55122 | 13651 | 324 | 2.436364 | 7.89381936 | Thelohaniidae | 72220 | Fungi | Fungi | 244 | 4.6799999999999996e-60 | NTclustered | gi|539395532|gb|KF549987.1| | 366552 | g13254 | i0 | 81.23 | 8.23148148148148 | 309 | 53 | 94 | 5 | 1 | 306 | 1171 | 865 | Agmasoma penaei isolate Ap_12-113 16S ribosomal RNA gene, partial sequence | blastn | 2667 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Thelohaniidae | Agmasoma | Agmasoma penaei | |||
| 19246453 | 19246453 | PRJEB55122_P_NODE_26836_length_205_cov_2.000000_g26439_i0 | PRJEB55122 | 26836 | 205 | 2 | 4.1 | Glugoides intestinalis | 174680 | Fungi | Fungi | 200 | 6.039999999999999e-47 | NTclustered | gi|113470856|gb|DQ680157.2| | 174680 | g26439 | i0 | 84.466 | 42.819512195122 | 206 | 29 | 100 | 3 | 1 | 205 | 1623 | 1420 | Glugoides intestinalis isolate Gi2 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence | blastn | 8778 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis | |||
| 19246765 | 19246765 | PRJEB55122_P_NODE_3656_length_806_cov_2.260238_g3350_i0 | PRJEB55122 | 3656 | 806 | 2.260238 | 18.21751828 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1424 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g3350 | i0 | 98.284 | 98.0359801488834 | 816 | 4 | 100 | 1 | 1 | 806 | 14 | 829 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 79017 | 1424 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 20521234 | 20521234 | PRJEB55122_P_NODE_11277_length_372_cov_1.448916_g10880_i0 | PRJEB55122 | 11277 | 372 | 1.448916 | 5.38996752 | uncultured Microsporidia | 546760 | Fungi | Fungi | 407 | 6.55e-109 | NTclustered | gi|1372080755|gb|MG241431.1| | 546760 | g10880 | i0 | 87.363 | 89.6720430107527 | 364 | 35 | 97 | 10 | 14 | 372 | 387 | 30 | Uncultured Microsporidia clone OTU51 small subunit ribosomal RNA gene, partial sequence | blastn | 33358 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 20521535 | 20521535 | PRJEB55122_P_NODE_1997_length_1125_cov_3.001859_g1783_i0 | PRJEB55122 | 1997 | 1125 | 3.001859 | 33.77091375 | Endoreticulatus sp. CHW-2004 Taiwan | 262393 | Fungi | Fungi | 374 | 2.15e-98 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g1783 | i0 | 79.138 | 14.2773333333333 | 580 | 92 | 69 | 22 | 1 | 578 | 36 | 588 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 16062 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 23072754 | 23072754 | PRJEB55122_P_NODE_22599_length_229_cov_1.444444_g22202_i0 | PRJEB55122 | 22599 | 229 | 1.444444 | 3.30777676 | Vavraia culicis | 103449 | Fungi | Fungi | 327 | 3.03e-85 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g22202 | i0 | 92.889 | 18.6288209606987 | 225 | 16 | 98 | 0 | 5 | 229 | 1048 | 824 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 4266 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis |
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);;