contig_metadata
19 rows where bioproject = "PRJNA879314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2133182 | 2133182 | PRJNA879314_P_NODE_2282_length_314_cov_1.514523_g2232_i0 | PRJNA879314 | 2282 | 314 | 1.514523 | 4.75560222 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 575 | 1.4099999999999994e-159 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g2232 | i0 | 99.682 | 99.8980891719745 | 314 | 1 | 100 | 0 | 1 | 314 | 912 | 1225 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 31368 | 575 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 3792308 | 3792308 | PRJNA879314_P_NODE_3483_length_274_cov_1.930348_g3433_i0 | PRJNA879314 | 3483 | 274 | 1.930348 | 5.28915352 | Heterosporis | 157917 | Fungi | Fungi | 339 | 1.73e-88 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g3433 | i0 | 89.13 | 40.9087591240876 | 276 | 24 | 99 | 4 | 4 | 274 | 2237 | 1963 | 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 | 11209 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 7235987 | 7235987 | PRJNA879314_P_NODE_246_length_835_cov_2.686352_g208_i0 | PRJNA879314 | 246 | 835 | 2.686352 | 22.4310392 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1530 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g208 | i0 | 99.641 | 97.5041916167665 | 835 | 3 | 100 | 0 | 1 | 835 | 859 | 25 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 81416 | 1530 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 13611485 | 13611485 | PRJNA879314_P_NODE_2551_length_302_cov_1.816594_g2501_i0 | PRJNA879314 | 2551 | 302 | 1.816594 | 5.4861138800000004 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 181 | 2.7099999999999997e-57 | NR | ELQ74559.1 | 72359 | g2501 | i0 | 91.7 | 0.95364238410596 | 96 | 8 | 95.4 | 0 | 1 | 288 | 5 | 100 | ELQ74559.1 Histone H4 [Trachipleistophora hominis] | diamond | 288 | 181 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 13611532 | 13611532 | PRJNA879314_P_NODE_7211_length_248_cov_1.565714_g7161_i0 | PRJNA879314 | 7211 | 248 | 1.565714 | 3.88297072 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 449 | 6.81e-122 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g7161 | i0 | 99.194 | 82.875 | 248 | 2 | 100 | 0 | 1 | 248 | 1684 | 1931 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20553 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 26960217 | 26960217 | PRJNA879314_P_NODE_9822_length_244_cov_0.912281_g9772_i0 | PRJNA879314 | 9822 | 244 | 0.912281 | 2.22596564 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 152 | 4.27e-44 | NR | KRH92283.1 | 146866 | g9772 | i0 | 98.8 | 0.995901639344262 | 81 | 1 | 99.6 | 0 | 2 | 244 | 37 | 117 | KRH92283.1 hypothetical protein M153_82380002, partial [Pseudoloma neurophilia] | diamond | 243 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27971272 | 27971272 | PRJNA879314_P_NODE_9605_length_245_cov_0.901163_g9555_i0 | PRJNA879314 | 9605 | 245 | 0.901163 | 2.20784935 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 169 | 5.8299999999999996e-52 | NR | KRH93541.1 | 146866 | g9555 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 2 | 244 | 9 | 89 | KRH93541.1 putative Nucleotide-binding, alpha-beta plait, RNA recognition motif domain protein [Pseudoloma neurophilia] | diamond | 243 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28065985 | 28065985 | PRJNA879314_P_NODE_1925_length_331_cov_1.786822_g1875_i0 | PRJNA879314 | 1925 | 331 | 1.786822 | 5.91438082 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 187 | 6.749999999999999e-55 | NR | KRH93774.1 | 146866 | g1875 | i0 | 99.1 | 0.987915407854985 | 109 | 1 | 98.8 | 0 | 329 | 3 | 350 | 458 | KRH93774.1 hypothetical protein M153_5780002796 [Pseudoloma neurophilia] | diamond | 327 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28065986 | 28065986 | PRJNA879314_P_NODE_3085_length_284_cov_1.606635_g3035_i0 | PRJNA879314 | 3085 | 284 | 1.606635 | 4.5628434 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 174 | 1.6699999999999998e-54 | NR | KRH94016.1 | 146866 | g3035 | i0 | 100 | 0.940140845070423 | 89 | 0 | 94 | 0 | 1 | 267 | 23 | 111 | KRH94016.1 hypothetical protein M153_423000323 [Pseudoloma neurophilia] | diamond | 267 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28445077 | 28445077 | PRJNA879314_P_NODE_5686_length_251_cov_0.876404_g5636_i0 | PRJNA879314 | 5686 | 251 | 0.876404 | 2.19977404 | Hamiltosporidium tvaerminnensis | 1176355 | Fungi | Fungi | 87.8 | 5.06e-18 | NR | TBU12977.1 | 1176355 | g5636 | i0 | 53 | 3.99203187250996 | 83 | 36 | 99.2 | 1 | 249 | 1 | 197 | 276 | TBU12977.1 serine/threonine-protein kinase Rio1 [Hamiltosporidium tvaerminnensis] | diamond | 1002 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium tvaerminnensis | |||
| 29297421 | 29297421 | PRJNA879314_P_NODE_7029_length_249_cov_0.886364_g6979_i0 | PRJNA879314 | 7029 | 249 | 0.886364 | 2.20704636 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 95.5 | 6.820000000000001e-21 | NR | KRH93141.1 | 146866 | g6979 | i0 | 97.5 | 0.975903614457831 | 81 | 1 | 97.6 | 1 | 247 | 5 | 357 | 436 | KRH93141.1 hypothetical protein M153_14260002472 [Pseudoloma neurophilia] | diamond | 243 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29612808 | 29612808 | PRJNA879314_P_NODE_9490_length_245_cov_0.906977_g9440_i0 | PRJNA879314 | 9490 | 245 | 0.906977 | 2.22209365 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 97.4 | 4.4599999999999996e-23 | NR | KRH92021.1 | 146866 | g9440 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 245 | 3 | 98 | 178 | KRH92021.1 hypothetical protein M153_14069000139 [Pseudoloma neurophilia] | diamond | 243 | 97.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29897445 | 29897445 | PRJNA879314_P_NODE_2091_length_323_cov_1.872000_g2041_i0 | PRJNA879314 | 2091 | 323 | 1.872 | 6.04656 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 208 | 5.95e-63 | NR | KRH93774.1 | 146866 | g2041 | i0 | 100 | 0.993808049535604 | 107 | 0 | 99.4 | 0 | 1 | 321 | 249 | 355 | KRH93774.1 hypothetical protein M153_5780002796 [Pseudoloma neurophilia] | diamond | 321 | 208 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31003235 | 31003235 | PRJNA879314_P_NODE_2194_length_318_cov_1.542857_g2144_i0 | PRJNA879314 | 2194 | 318 | 1.542857 | 4.90628526 | Pancytospora epiphaga | 1938578 | Fungi | Fungi | 44.7 | 0.00362 | NR | KAI5168658.1 | 1938578 | g2144 | i0 | 48.8 | 0.386792452830189 | 41 | 21 | 38.7 | 0 | 135 | 13 | 61 | 101 | KAI5168658.1 hypothetical protein PAEPH01_0311 [Pancytospora epiphaga] | diamond | 123 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora epiphaga | ||||
| 31129181 | 31129181 | PRJNA879314_P_NODE_2435_length_307_cov_1.662393_g2385_i0 | PRJNA879314 | 2435 | 307 | 1.662393 | 5.10354651 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 204 | 3.22e-65 | NR | KRH93876.1 | 146866 | g2385 | i0 | 100 | 0.996742671009772 | 102 | 0 | 99.7 | 0 | 306 | 1 | 11 | 112 | KRH93876.1 hypothetical protein M153_5050002994 [Pseudoloma neurophilia] | diamond | 306 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31255974 | 31255974 | PRJNA879314_P_NODE_11135_length_242_cov_0.923077_g11085_i0 | PRJNA879314 | 11135 | 242 | 0.923077 | 2.23384634 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 170 | 8.76e-50 | NR | KRH94915.1 | 146866 | g11085 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 154 | 233 | KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia] | diamond | 240 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31509200 | 31509200 | PRJNA879314_P_NODE_7676_length_248_cov_0.891429_g7626_i0 | PRJNA879314 | 7676 | 248 | 0.891429 | 2.21074392 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 168 | 1.64e-46 | NR | KRH94803.1 | 146866 | g7626 | i0 | 100 | 0.991935483870968 | 82 | 0 | 99.2 | 0 | 246 | 1 | 44 | 125 | KRH94803.1 DNA replication licensing factor, MCM7 component [Pseudoloma neurophilia] | diamond | 246 | 168 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32710447 | 32710447 | PRJNA879314_P_NODE_1340_length_376_cov_2.963696_g1290_i0 | PRJNA879314 | 1340 | 376 | 2.963696 | 11.14349696 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 228 | 1.53e-71 | NR | KRH94061.1 | 146866 | g1290 | i0 | 96 | 0.98936170212766 | 124 | 5 | 98.9 | 0 | 374 | 3 | 230 | 353 | KRH94061.1 hypothetical protein M153_3970004070 [Pseudoloma neurophilia] | diamond | 372 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32867942 | 32867942 | PRJNA879314_P_NODE_8740_length_246_cov_0.901734_g8690_i0 | PRJNA879314 | 8740 | 246 | 0.901734 | 2.21826564 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 157 | 1.4199999999999999e-42 | NR | KRH92907.1 | 146866 | g8690 | i0 | 100 | 1 | 82 | 0 | 100 | 0 | 246 | 1 | 169 | 250 | KRH92907.1 Molecular chaperones HSP70/HSC70, HSP70 superfamily, partial [Pseudoloma neurophilia] | diamond | 246 | 157 | 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);;