contig_metadata
16 rows where bioproject = "PRJNA784979", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5869053 | 5869053 | PRJNA784979_S_NODE_2565_length_287_cov_2.033613_g2523_i0 | PRJNA784979 | 2565 | 287 | 2.033613 | 5.83646931 | Pleistophora mulleri | 249366 | Fungi | Fungi | 418 | 2.2699999999999993e-112 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g2523 | i0 | 93.007 | 26.3205574912892 | 286 | 18 | 99 | 2 | 4 | 287 | 3525 | 3240 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 7554 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 7144058 | 7144058 | PRJNA784979_S_NODE_946_length_560_cov_4.772994_g904_i0 | PRJNA784979 | 946 | 560 | 4.772994 | 26.7287664 | Pleistophora mulleri | 249366 | Fungi | Fungi | 568 | 4.429999999999999e-157 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g904 | i0 | 87.959 | 40.6928571428571 | 490 | 47 | 86 | 9 | 6 | 487 | 2111 | 1626 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 22788 | 568 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 9693907 | 9693907 | PRJNA784979_S_NODE_2228_length_310_cov_4.379310_g2186_i0 | PRJNA784979 | 2228 | 310 | 4.37931 | 13.575861 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 425 | 1.48e-114 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g2186 | i0 | 92.053 | 97.0193548387097 | 302 | 24 | 97 | 0 | 9 | 310 | 582 | 281 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 30076 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 9693927 | 9693927 | PRJNA784979_S_NODE_4728_length_219_cov_4.752941_g4686_i0 | PRJNA784979 | 4728 | 219 | 4.752941 | 10.40894079 | Vavraia culicis | 103449 | Fungi | Fungi | 224 | 3.879999999999999e-54 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g4686 | i0 | 85.581 | 1.97260273972603 | 215 | 30 | 98 | 1 | 5 | 219 | 2586 | 2373 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 432 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 13519334 | 13519334 | PRJNA784979_S_NODE_1851_length_346_cov_2.973064_g1809_i0 | PRJNA784979 | 1851 | 346 | 2.973064 | 10.28680144 | Vavraia culicis | 103449 | Fungi | Fungi | 412 | 1.3e-110 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g1809 | i0 | 88.506 | 24.4335260115607 | 348 | 30 | 99 | 7 | 3 | 346 | 748 | 407 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 8454 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 14794134 | 14794134 | PRJNA784979_S_NODE_1552_length_387_cov_3.497041_g1510_i0 | PRJNA784979 | 1552 | 387 | 3.497041 | 13.53354867 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 606 | 6.289999999999998e-169 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g1510 | i0 | 95.778 | 97.6589147286822 | 379 | 11 | 98 | 4 | 3 | 380 | 839 | 1213 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 37794 | 606 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 14794135 | 14794135 | PRJNA784979_S_NODE_1792_length_353_cov_3.605263_g1750_i0 | PRJNA784979 | 1792 | 353 | 3.605263 | 12.72657839 | Pleistophora mulleri | 249366 | Fungi | Fungi | 457 | 6.05e-124 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g1750 | i0 | 90.113 | 36.1671388101983 | 354 | 29 | 99 | 4 | 1 | 350 | 3174 | 3525 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 12767 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 16068027 | 16068027 | PRJNA784979_S_NODE_1153_length_481_cov_7.791667_g1111_i0 | PRJNA784979 | 1153 | 481 | 7.791667 | 37.47791827 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 880 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g1111 | i0 | 100 | 98.1372141372141 | 476 | 0 | 99 | 0 | 1 | 476 | 860 | 1335 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 47204 | 880 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 17343791 | 17343791 | PRJNA784979_S_NODE_5834_length_203_cov_9.064935_g5792_i0 | PRJNA784979 | 5834 | 203 | 9.064935 | 18.40181805 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 351 | 1.56e-92 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g5792 | i0 | 98.492 | 98.8620689655172 | 199 | 3 | 98 | 0 | 1 | 199 | 1705 | 1507 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20069 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 19065103 | 19065103 | PRJNA784979_S_NODE_635_length_839_cov_5.163291_g609_i0 | PRJNA784979 | 635 | 839 | 5.163291 | 43.32001149 | Heterosporis | 157917 | Fungi | Fungi | 664 | 0 | NTclustered | gi|27448231|gb|AF387331.1| | 184033 | g609 | i0 | 81.425 | 17.2800953516091 | 856 | 120 | 99 | 33 | 6 | 839 | 2960 | 2122 | Heterosporis anguillarum small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 14498 | 664 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis anguillarum | |||
| 22442863 | 22442863 | PRJNA784979_S_NODE_2478_length_291_cov_4.033058_g2436_i0 | PRJNA784979 | 2478 | 291 | 4.033058 | 11.73619878 | Pleistophora mulleri | 249366 | Fungi | Fungi | 405 | 1.7999999999999997e-108 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g2436 | i0 | 95.652 | 42.659793814433 | 253 | 9 | 87 | 2 | 7 | 258 | 3093 | 2842 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 12414 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 22442879 | 22442879 | PRJNA784979_S_NODE_4738_length_219_cov_2.152941_g4696_i0 | PRJNA784979 | 4738 | 219 | 2.152941 | 4.71494079 | Vavraia culicis | 103449 | Fungi | Fungi | 257 | 3.83e-64 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g4696 | i0 | 88.679 | 1.91780821917808 | 212 | 23 | 97 | 1 | 8 | 219 | 2578 | 2368 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 420 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 22442887 | 22442887 | PRJNA784979_S_NODE_658_length_810_cov_8.735874_g630_i0 | PRJNA784979 | 658 | 810 | 8.735874 | 70.7605794 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1262 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g630 | i0 | 95.031 | 97.1185185185185 | 805 | 35 | 99 | 5 | 9 | 810 | 860 | 58 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 78666 | 1262 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 23718376 | 23718376 | PRJNA784979_S_NODE_2859_length_272_cov_6.112108_g2817_i0 | PRJNA784979 | 2859 | 272 | 6.112108 | 16.62493376 | Ovipleistophora diplostomuri | 2023159 | Fungi | Fungi | 322 | 1.72e-83 | NTclustered | gi|2017842943|gb|MW811107.1| | 2023159 | g2817 | i0 | 89.098 | 26.0882352941176 | 266 | 20 | 96 | 8 | 9 | 268 | 1306 | 1568 | Ovipleistophora diplostomuri isolate 15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 7096 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora diplostomuri | |||
| 24164994 | 24164994 | PRJNA784979_S_NODE_3059_length_264_cov_3.874419_g3017_i0 | PRJNA784979 | 3059 | 264 | 3.874419 | 10.22846616 | Pleistophora | 35233 | Fungi | Fungi | 233 | 8.02e-57 | NTclustered | gi|3033524|gb|AF044394.1| | 73787 | g3017 | i0 | 83.459 | 80.2613636363636 | 266 | 28 | 97 | 10 | 9 | 263 | 1401 | 1141 | Pleistophora sp.1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21189 | 235 | 0.991489361702128 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora sp. 1 | |||
| 28127617 | 28127617 | PRJNA784979_S_NODE_3125_length_261_cov_8.042453_g3083_i0 | PRJNA784979 | 3125 | 261 | 8.042453 | 20.99080233 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 159 | 7.829999999999999e-46 | NR | KRH93531.1 | 146866 | g3083 | i0 | 97.7 | 1 | 87 | 2 | 100 | 0 | 261 | 1 | 16 | 102 | KRH93531.1 hypothetical protein M153_7960002914 [Pseudoloma neurophilia] | diamond | 261 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;