contig_metadata
19 rows where bioproject = "PRJNA798905" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5046175 | 5046175 | PRJNA798905_S_NODE_12504_length_400_cov_4.241590_g12055_i0 | PRJNA798905 | 12504 | 400 | 4.24159 | 16.96636 | Heterosporis | 157917 | Fungi | Fungi | 551 | 3.0999999999999986e-152 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g12055 | i0 | 91.542 | 33.51 | 402 | 30 | 100 | 3 | 1 | 400 | 3560 | 3161 | Heterosporis sp. NBDP-2013a isolate MN/WAE small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13404 | 551 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 11422083 | 11422083 | PRJNA798905_S_NODE_29869_length_276_cov_5.512315_g29420_i0 | PRJNA798905 | 29869 | 276 | 5.512315 | 15.213989400000001 | Heterosporis | 157917 | Fungi | Fungi | 313 | 1.05e-80 | NTclustered | gi|27448231|gb|AF387331.1| | 184033 | g29420 | i0 | 88.976 | 29.6376811594203 | 254 | 26 | 91 | 1 | 22 | 273 | 2047 | 2300 | Heterosporis anguillarum small subunit ribosomal RNA gene, internal transcribed spacer, and large subunit ribosomal RNA gene, complete sequence | blastn | 8180 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis anguillarum | |||
| 21194943 | 21194943 | PRJNA798905_S_NODE_6477_length_524_cov_19.064302_g6028_i0 | PRJNA798905 | 6477 | 524 | 19.064302 | 99.89694248 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 905 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g6028 | i0 | 99.797 | 93.5362595419847 | 492 | 1 | 100 | 0 | 1 | 492 | 796 | 305 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 49013 | 905 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 21620306 | 21620306 | PRJNA798905_S_NODE_28977_length_281_cov_1.451923_g28528_i0 | PRJNA798905 | 28977 | 281 | 1.451923 | 4.07990363 | Pleistophoridae | 35232 | Fungi | Fungi | 333 | 8.259999999999999e-87 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g28528 | i0 | 88.07 | 53.2526690391459 | 285 | 28 | 100 | 5 | 1 | 281 | 1968 | 1686 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 14964 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 25444839 | 25444839 | PRJNA798905_S_NODE_16900_length_356_cov_6.180212_g16451_i0 | PRJNA798905 | 16900 | 356 | 6.180212 | 22.00155472 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 69.3 | 2.37e-11 | NR | KRH94204.1 | 146866 | g16451 | i0 | 43.3 | 1.60112359550562 | 104 | 48 | 80.9 | 3 | 336 | 49 | 124 | 224 | KRH94204.1 hypothetical protein M153_340000906 [Pseudoloma neurophilia] | diamond | 570 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27211816 | 27211816 | PRJNA798905_S_NODE_17782_length_349_cov_4.557971_g17333_i0 | PRJNA798905 | 17782 | 349 | 4.557971 | 15.90731879 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 152 | 2e-43 | NR | KRH93469.1 | 146866 | g17333 | i0 | 85.1 | 0.808022922636103 | 94 | 14 | 80.8 | 0 | 347 | 66 | 147 | 240 | KRH93469.1 hypothetical protein M153_8510002738 [Pseudoloma neurophilia] | diamond | 282 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27306972 | 27306972 | PRJNA798905_S_NODE_19683_length_334_cov_8.111111_g19234_i0 | PRJNA798905 | 19683 | 334 | 8.111111 | 27.09111074 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 136 | 6.15e-36 | NR | KRH92462.1 | 146866 | g19234 | i0 | 98.5 | 0.592814371257485 | 66 | 1 | 59.3 | 0 | 198 | 1 | 93 | 158 | KRH92462.1 hypothetical protein M153_57350001210 [Pseudoloma neurophilia] | diamond | 198 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27338566 | 27338566 | PRJNA798905_S_NODE_17163_length_354_cov_5.124555_g16714_i0 | PRJNA798905 | 17163 | 354 | 5.124555 | 18.1409247 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 221 | 4.31e-69 | NR | KRH94915.1 | 146866 | g16714 | i0 | 99.1 | 0.915254237288136 | 108 | 1 | 91.5 | 0 | 8 | 331 | 270 | 377 | KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia] | diamond | 324 | 221 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27843519 | 27843519 | PRJNA798905_S_NODE_3744_length_690_cov_3.019449_g3313_i0 | PRJNA798905 | 3744 | 690 | 3.019449 | 20.8341981 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 398 | 2.1199999999999998e-136 | NR | KRH92462.1 | 146866 | g3313 | i0 | 95.7 | 0.9 | 207 | 9 | 90 | 0 | 688 | 68 | 158 | 364 | KRH92462.1 hypothetical protein M153_57350001210 [Pseudoloma neurophilia] | diamond | 621 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27906559 | 27906559 | PRJNA798905_S_NODE_34125_length_257_cov_2.510870_g33676_i0 | PRJNA798905 | 34125 | 257 | 2.51087 | 6.4529359 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 153 | 1.11e-44 | NR | KRH94683.1 | 146866 | g33676 | i0 | 100 | 0.992217898832685 | 85 | 0 | 99.2 | 0 | 255 | 1 | 74 | 158 | KRH94683.1 hypothetical protein M153_1650005536 [Pseudoloma neurophilia] | diamond | 255 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28222391 | 28222391 | PRJNA798905_S_NODE_32586_length_264_cov_1.382199_g32137_i0 | PRJNA798905 | 32586 | 264 | 1.382199 | 3.64900536 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 149 | 2.9199999999999995e-43 | NR | KRH93927.1 | 146866 | g32137 | i0 | 90.8 | 0.863636363636364 | 76 | 3 | 81.8 | 1 | 216 | 1 | 26 | 101 | KRH93927.1 hypothetical protein M153_485000642 [Pseudoloma neurophilia] | diamond | 228 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28696355 | 28696355 | PRJNA798905_S_NODE_35807_length_251_cov_1.292135_g35358_i0 | PRJNA798905 | 35807 | 251 | 1.292135 | 3.24325885 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 79 | 1.38e-15 | NR | KRH93076.1 | 146866 | g35358 | i0 | 48.1 | 0.944223107569721 | 79 | 41 | 94.4 | 0 | 2 | 238 | 133 | 211 | KRH93076.1 hypothetical protein M153_156700021, partial [Pseudoloma neurophilia] | diamond | 237 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28696357 | 28696357 | PRJNA798905_S_NODE_42367_length_229_cov_2.032051_g41918_i0 | PRJNA798905 | 42367 | 229 | 2.032051 | 4.65339679 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 157 | 5.92e-47 | NR | KRH93443.1 | 146866 | g41918 | i0 | 92.1 | 0.995633187772926 | 76 | 6 | 99.6 | 0 | 1 | 228 | 73 | 148 | KRH93443.1 Polyadenylation factor I complex, subunit, Yth1 (CPSF subunit) [Pseudoloma neurophilia] | diamond | 228 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28948995 | 28948995 | PRJNA798905_S_NODE_16628_length_359_cov_1.793706_g16179_i0 | PRJNA798905 | 16628 | 359 | 1.793706 | 6.43940454 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 132 | 1.02e-35 | NR | KRH92856.1 | 146866 | g16179 | i0 | 95.4 | 0.543175487465181 | 65 | 3 | 54.3 | 0 | 213 | 19 | 162 | 226 | KRH92856.1 hypothetical protein M153_24140001108 [Pseudoloma neurophilia] | diamond | 195 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29043673 | 29043673 | PRJNA798905_S_NODE_33268_length_261_cov_2.047872_g32819_i0 | PRJNA798905 | 33268 | 261 | 2.047872 | 5.34494592 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 198 | 9.51e-63 | NR | KRH93927.1 | 146866 | g32819 | i0 | 100 | 0.988505747126437 | 86 | 0 | 98.9 | 0 | 260 | 3 | 98 | 183 | KRH93927.1 hypothetical protein M153_485000642 [Pseudoloma neurophilia] | diamond | 258 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29138458 | 29138458 | PRJNA798905_S_NODE_21989_length_319_cov_7.589431_g21540_i0 | PRJNA798905 | 21989 | 319 | 7.589431 | 24.21028489 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 222 | 1.8499999999999999e-69 | NR | KRH94915.1 | 146866 | g21540 | i0 | 100 | 0.987460815047022 | 105 | 0 | 98.7 | 0 | 3 | 317 | 160 | 264 | KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia] | diamond | 315 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30307256 | 30307256 | PRJNA798905_S_NODE_39752_length_241_cov_2.291667_g39303_i0 | PRJNA798905 | 39752 | 241 | 2.291667 | 5.52291747 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 61.6 | 5.52e-9 | NR | KRH94238.1 | 146866 | g39303 | i0 | 96.3 | 0.336099585062241 | 27 | 1 | 33.6 | 0 | 240 | 160 | 250 | 276 | KRH94238.1 hypothetical protein M153_3250008583 [Pseudoloma neurophilia] | diamond | 81 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31887207 | 31887207 | PRJNA798905_S_NODE_24537_length_304_cov_3.393939_g24088_i0 | PRJNA798905 | 24537 | 304 | 3.393939 | 10.31757456 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 48.1 | 7.36e-4 | NR | KAG0441725.1 | 279532 | g24088 | i0 | 30.4 | 1.00657894736842 | 102 | 69 | 98.7 | 1 | 304 | 5 | 120 | 221 | KAG0441725.1 Ran-specific GTPase-activating protein 1 [Dictyocoela muelleri] | diamond | 306 | 48.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 32235656 | 32235656 | PRJNA798905_S_NODE_35398_length_252_cov_2.581006_g34949_i0 | PRJNA798905 | 35398 | 252 | 2.581006 | 6.50413512 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 134 | 1.21e-37 | NR | KRH94122.1 | 146866 | g34949 | i0 | 100 | 0.797619047619048 | 67 | 0 | 79.8 | 0 | 252 | 52 | 113 | 179 | KRH94122.1 Membrane protein involved in ER to Golgi transport [Pseudoloma neurophilia] | diamond | 201 | 134 | 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);;