contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA999747" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7358283 | 7358283 | PRJNA999747_S_NODE_3926_length_159_cov_13.695312_g3894_i0 | PRJNA999747 | 3926 | 159 | 13.695312 | 21.77554608 | Pleistophora mulleri | 249366 | Fungi | Fungi | 243 | 7.279999999999999e-60 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g3894 | i0 | 94.34 | 28.3081761006289 | 159 | 7 | 99 | 1 | 3 | 159 | 3246 | 3404 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 4501 | 243 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 9908765 | 9908765 | PRJNA999747_S_NODE_28_length_943_cov_41.980263_g22_i0 | PRJNA999747 | 28 | 943 | 41.980263 | 395.87388009 | Ovipleistophora diplostomuri | 2023159 | Fungi | Fungi | 857 | 0 | NTclustered | gi|2017842943|gb|MW811107.1| | 2023159 | g22 | i0 | 83.402 | 21.3191940615058 | 964 | 121 | 99 | 33 | 2 | 943 | 1183 | 2129 | 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 | 20104 | 857 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora diplostomuri | |||
| 10202865 | 10202865 | PRJNA999747_S_NODE_808_length_317_cov_11.965035_g776_i0 | PRJNA999747 | 808 | 317 | 11.965035 | 37.929160950000004 | Nematocida | 586132 | Fungi | Fungi | 80.5 | 1.36e-10 | NTclustered | gi|906375813|ref|XR_001214622.1| | 881290 | g776 | i0 | 95.918 | 0.309148264984227 | 49 | 2 | 15 | 0 | 1 | 49 | 1504 | 1552 | Nematocida parisii ERTm1 28S ribosomal RNA (NEPG_02678), partial rRNA | blastn | 98 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida parisii | ||||
| 11183874 | 11183874 | PRJNA999747_S_NODE_109_length_620_cov_47.422750_g89_i0 | PRJNA999747 | 109 | 620 | 47.42275 | 294.02105 | Vavraia culicis | 103449 | Fungi | Fungi | 719 | 0 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g89 | i0 | 87.879 | 16.4387096774194 | 627 | 57 | 99 | 14 | 4 | 620 | 349 | 966 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 10192 | 719 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 12459734 | 12459734 | PRJNA999747_S_NODE_110_length_620_cov_46.448217_g90_i0 | PRJNA999747 | 110 | 620 | 46.448217 | 287.9789454 | Pleistophora mulleri | 249366 | Fungi | Fungi | 697 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g90 | i0 | 86.998 | 22.4774193548387 | 623 | 75 | 99 | 3 | 4 | 620 | 1715 | 2337 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 13936 | 697 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 12753492 | 12753492 | PRJNA999747_S_NODE_50_length_804_cov_54.116429_g41_i0 | PRJNA999747 | 50 | 804 | 54.116429 | 435.09608916 | Pleistophoridae | 35232 | Fungi | Fungi | 821 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g41 | i0 | 85.244 | 43.6181592039801 | 820 | 92 | 99 | 24 | 1 | 801 | 2337 | 1528 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 35069 | 826 | 0.993946731234867 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 12753501 | 12753501 | PRJNA999747_S_NODE_950_length_299_cov_37.615672_g918_i0 | PRJNA999747 | 950 | 299 | 37.615672000000004 | 112.47085928 | Glugea | 36736 | Fungi | Fungi | 424 | 5.11e-114 | NTclustered | gi|562115|gb|U15987.1|GAU15987 | 36737 | g918 | i0 | 92.359 | 97.5953177257525 | 301 | 18 | 99 | 5 | 3 | 299 | 1 | 300 | Glugea atherinae small subunit ribosomal RNA gene | blastn | 29181 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea atherinae | |||
| 13734107 | 13734107 | PRJNA999747_S_NODE_51_length_804_cov_53.373868_g41_i1 | PRJNA999747 | 51 | 804 | 53.373868 | 429.12589872 | Pleistophora mulleri | 249366 | Fungi | Fungi | 815 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g41 | i1 | 85.086 | 46.5634328358209 | 818 | 97 | 99 | 16 | 4 | 804 | 1528 | 2337 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 37437 | 815 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 15008473 | 15008473 | PRJNA999747_S_NODE_2032_length_213_cov_66.686813_g2000_i0 | PRJNA999747 | 2032 | 213 | 66.686813 | 142.04291169 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 383 | 5.8499999999999996e-102 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g2000 | i0 | 99.524 | 96.7417840375587 | 210 | 1 | 99 | 0 | 4 | 213 | 1501 | 1710 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20606 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 15302084 | 15302084 | PRJNA999747_S_NODE_252_length_480_cov_16.022272_g225_i0 | PRJNA999747 | 252 | 480 | 16.022272 | 76.9069056 | Heterosporis | 157917 | Fungi | Fungi | 645 | 1.6899999999999993e-180 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g225 | i0 | 94.118 | 36.3625 | 425 | 24 | 89 | 1 | 4 | 428 | 3251 | 3674 | 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 | 17454 | 645 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 15302105 | 15302105 | PRJNA999747_S_NODE_52_length_791_cov_49.473684_g41_i2 | PRJNA999747 | 52 | 791 | 49.473684 | 391.33684044 | Pleistophoridae | 35232 | Fungi | Fungi | 835 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g41 | i2 | 85.891 | 36.9152970922882 | 808 | 84 | 99 | 24 | 5 | 791 | 1539 | 2337 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 29200 | 835 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 16283343 | 16283343 | PRJNA999747_S_NODE_53_length_791_cov_48.718421_g41_i3 | PRJNA999747 | 53 | 791 | 48.718421 | 385.36271011 | Pleistophora mulleri | 249366 | Fungi | Fungi | 830 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g41 | i3 | 85.732 | 40.6232616940582 | 806 | 89 | 99 | 16 | 5 | 791 | 1539 | 2337 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 32133 | 830 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 17558472 | 17558472 | PRJNA999747_S_NODE_2114_length_209_cov_44.438202_g2082_i0 | PRJNA999747 | 2114 | 209 | 44.438202 | 92.87584218 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 268 | 1.6699999999999994e-67 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g2082 | i0 | 90.594 | 96.88995215311 | 202 | 19 | 97 | 0 | 8 | 209 | 1509 | 1710 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20250 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 17558473 | 17558473 | PRJNA999747_S_NODE_214_length_508_cov_19.842767_g188_i0 | PRJNA999747 | 214 | 508 | 19.842767 | 100.80125636 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 689 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g188 | i0 | 91.767 | 95.761811023622 | 498 | 37 | 98 | 4 | 12 | 508 | 846 | 1340 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 48647 | 689 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 20107129 | 20107129 | PRJNA999747_S_NODE_1776_length_226_cov_14.138462_g1744_i0 | PRJNA999747 | 1776 | 226 | 14.138462 | 31.95292412 | Vavraia culicis | 103449 | Fungi | Fungi | 283 | 6.55e-72 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g1744 | i0 | 89.686 | 16.4513274336283 | 223 | 22 | 99 | 1 | 4 | 226 | 2356 | 2577 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 3718 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 22951893 | 22951893 | PRJNA999747_S_NODE_18_length_1104_cov_40.164026_g15_i0 | PRJNA999747 | 18 | 1104 | 40.164026 | 443.41084704 | Pleistophoridae | 35232 | Fungi | Fungi | 1099 | 0 | NTclustered | gi|2017842940|gb|MW811106.1| | 103445 | g15 | i0 | 84.921 | 24.2074275362319 | 1134 | 120 | 99 | 45 | 1 | 1103 | 2309 | 1196 | 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 | 26725 | 1109 | 0.990982867448151 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Ovipleistophora | Ovipleistophora ovariae | |||
| 23932991 | 23932991 | PRJNA999747_S_NODE_19_length_1060_cov_54.376093_g16_i0 | PRJNA999747 | 19 | 1060 | 54.376093 | 576.3865858 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1624 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g16 | i0 | 94.267 | 97.4037735849057 | 1064 | 55 | 100 | 5 | 1 | 1060 | 279 | 1340 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 103248 | 1624 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 23933018 | 23933018 | PRJNA999747_S_NODE_939_length_300_cov_37.423792_g907_i0 | PRJNA999747 | 939 | 300 | 37.423792 | 112.271376 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 531 | 2.9399999999999993e-146 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g907 | i0 | 98.658 | 96.3433333333333 | 298 | 4 | 99 | 0 | 1 | 298 | 298 | 1 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28903 | 531 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 25206676 | 25206676 | PRJNA999747_S_NODE_20_length_1057_cov_63.012671_g16_i1 | PRJNA999747 | 20 | 1057 | 63.012671 | 666.04393247 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1927 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g16 | i1 | 99.621 | 95.6310312204352 | 1055 | 2 | 99 | 1 | 5 | 1057 | 286 | 1340 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 101082 | 1927 | 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);;