contig_metadata
20 rows where bioproject = "PRJNA781196", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2035490 | 2035490 | PRJNA781196_P_NODE_49402_length_254_cov_1.292818_g49025_i0 | PRJNA781196 | 49402 | 254 | 1.292818 | 3.28375772 | Vavraia culicis | 103449 | Fungi | Fungi | 283 | 7.51e-72 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g49025 | i0 | 86.873 | 12.0551181102362 | 259 | 26 | 100 | 6 | 1 | 254 | 927 | 672 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 3062 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 18610693 | 18610693 | PRJNA781196_P_NODE_23075_length_356_cov_1.222615_g22698_i0 | PRJNA781196 | 23075 | 356 | 1.222615 | 4.3525094 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 649 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g22698 | i0 | 99.438 | 91.6938202247191 | 356 | 2 | 100 | 0 | 1 | 356 | 860 | 505 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 32643 | 649 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27685687 | 27685687 | PRJNA781196_P_NODE_67004_length_242_cov_0.923077_g66627_i0 | PRJNA781196 | 67004 | 242 | 0.923077 | 2.23384634 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 158 | 9.959999999999998e-47 | NR | KRH92033.1 | 146866 | g66627 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 87 | 166 | KRH92033.1 putative Ras small GTPase [Pseudoloma neurophilia] | diamond | 240 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27811811 | 27811811 | PRJNA781196_P_NODE_11764_length_473_cov_0.912500_g11388_i0 | PRJNA781196 | 11764 | 473 | 0.9125 | 4.316125 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 123 | 3.8e-29 | NR | KRH94565.1 | 146866 | g11388 | i0 | 83.5 | 0.501057082452431 | 79 | 13 | 50.1 | 0 | 472 | 236 | 768 | 846 | KRH94565.1 hypothetical protein M153_2090009003 [Pseudoloma neurophilia] | diamond | 237 | 123 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27969485 | 27969485 | PRJNA781196_P_NODE_59945_length_246_cov_1.803468_g59568_i0 | PRJNA781196 | 59945 | 246 | 1.803468 | 4.43653128 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 171 | 8e-51 | NR | KRH92371.1 | 146866 | g59568 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 245 | 3 | 4 | 84 | KRH92371.1 hypothetical protein M153_6864000155 [Pseudoloma neurophilia] | diamond | 243 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28916511 | 28916511 | PRJNA781196_P_NODE_52868_length_251_cov_0.876404_g52491_i0 | PRJNA781196 | 52868 | 251 | 0.876404 | 2.19977404 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 163 | 8.919999999999998e-47 | NR | KRH94879.1 | 146866 | g52491 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 1 | 249 | 10 | 92 | KRH94879.1 Amino Acid/Auxin Permease (AAAP) Family [Pseudoloma neurophilia] | diamond | 249 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29074828 | 29074828 | PRJNA781196_P_NODE_58088_length_248_cov_0.891429_g57711_i0 | PRJNA781196 | 58088 | 248 | 0.891429 | 2.21074392 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 152 | 4.19e-41 | NR | KRH94876.1 | 146866 | g57711 | i0 | 96.3 | 0.991935483870968 | 82 | 3 | 99.2 | 0 | 2 | 247 | 404 | 485 | KRH94876.1 hypothetical protein M153_1190004841 [Pseudoloma neurophilia] | diamond | 246 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30527391 | 30527391 | PRJNA781196_P_NODE_55113_length_250_cov_0.881356_g54736_i0 | PRJNA781196 | 55113 | 250 | 0.881356 | 2.20339 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 159 | 5.799999999999999e-43 | NR | KRH95068.1 | 146866 | g54736 | i0 | 100 | 0.984 | 82 | 0 | 98.4 | 0 | 248 | 3 | 9 | 90 | KRH95068.1 RNA polymerase II, second largest subunit [Pseudoloma neurophilia] | diamond | 246 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30527392 | 30527392 | PRJNA781196_P_NODE_56093_length_249_cov_0.886364_g55716_i0 | PRJNA781196 | 56093 | 249 | 0.886364 | 2.20704636 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 58.5 | 1.07e-7 | NR | KRH93035.1 | 146866 | g55716 | i0 | 100 | 0.349397590361446 | 29 | 0 | 34.9 | 0 | 3 | 89 | 424 | 452 | KRH93035.1 Histone deacetylase complex, SIN3 component, partial [Pseudoloma neurophilia] | diamond | 87 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30590560 | 30590560 | PRJNA781196_P_NODE_45033_length_267_cov_1.206186_g44656_i0 | PRJNA781196 | 45033 | 267 | 1.206186 | 3.22051662 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 178 | 1.1599999999999999e-54 | NR | KRH94419.1 | 146866 | g44656 | i0 | 100 | 0.97752808988764 | 87 | 0 | 97.8 | 0 | 265 | 5 | 67 | 153 | KRH94419.1 60s ribosomal protein L10 [Pseudoloma neurophilia] | diamond | 261 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31602261 | 31602261 | PRJNA781196_P_NODE_25016_length_345_cov_1.128676_g24639_i0 | PRJNA781196 | 25016 | 345 | 1.128676 | 3.8939322 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 140 | 6.12e-40 | NR | KRH95291.1 | 146866 | g24639 | i0 | 100 | 0.660869565217391 | 76 | 0 | 66.1 | 0 | 116 | 343 | 1 | 76 | KRH95291.1 H+- or Na+-translocating F-type, V-type and A-type ATPase (F-ATPase) Superfamily [Pseudoloma neurophilia] | diamond | 228 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31791675 | 31791675 | PRJNA781196_P_NODE_35717_length_297_cov_1.392857_g35340_i0 | PRJNA781196 | 35717 | 297 | 1.392857 | 4.13678529 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 188 | 7.520000000000001e-59 | NR | KRH93636.1 | 146866 | g35340 | i0 | 100 | 0.98989898989899 | 98 | 0 | 99 | 0 | 295 | 2 | 5 | 102 | KRH93636.1 60S ribosomal protein L18 [Pseudoloma neurophilia] | diamond | 294 | 188 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31855120 | 31855120 | PRJNA781196_P_NODE_62197_length_245_cov_0.906977_g61820_i0 | PRJNA781196 | 62197 | 245 | 0.906977 | 2.22209365 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 150 | 1.35e-43 | NR | KRH92045.1 | 146866 | g61820 | i0 | 100 | 0.881632653061225 | 72 | 0 | 88.2 | 0 | 243 | 28 | 158 | 229 | KRH92045.1 putative Nucleotide-binding, alpha-beta plait, RNA recognition motif domain protein [Pseudoloma neurophilia] | diamond | 216 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31886729 | 31886729 | PRJNA781196_P_NODE_50357_length_253_cov_0.866667_g49980_i0 | PRJNA781196 | 50357 | 253 | 0.866667 | 2.19266751 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 170 | 1.63e-51 | NR | KRH91984.1 | 146866 | g49980 | i0 | 100 | 0.984189723320158 | 83 | 0 | 98.4 | 0 | 251 | 3 | 110 | 192 | KRH91984.1 60S ribosomal protein L13a, partial [Pseudoloma neurophilia] | diamond | 249 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32045025 | 32045025 | PRJNA781196_P_NODE_20798_length_371_cov_2.000000_g20421_i0 | PRJNA781196 | 20798 | 371 | 2 | 7.42 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 230 | 5.04e-71 | NR | KRH93774.1 | 146866 | g20421 | i0 | 100 | 0.986522911051213 | 122 | 0 | 98.7 | 0 | 370 | 5 | 7 | 128 | KRH93774.1 hypothetical protein M153_5780002796 [Pseudoloma neurophilia] | diamond | 366 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32330068 | 32330068 | PRJNA781196_P_NODE_15839_length_416_cov_0.801749_g15462_i0 | PRJNA781196 | 15839 | 416 | 0.801749 | 3.33527584 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 136 | 6.51e-38 | NR | KRH93465.1 | 146866 | g15462 | i0 | 51.1 | 0.987980769230769 | 137 | 67 | 98.8 | 0 | 414 | 4 | 11 | 147 | KRH93465.1 hypothetical protein M153_8590003450 [Pseudoloma neurophilia] | diamond | 411 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32330120 | 32330120 | PRJNA781196_P_NODE_66719_length_242_cov_0.923077_g66342_i0 | PRJNA781196 | 66719 | 242 | 0.923077 | 2.23384634 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 68.9 | 2.17e-11 | NR | KRH93798.1 | 146866 | g66342 | i0 | 100 | 0.421487603305785 | 34 | 0 | 42.1 | 0 | 241 | 140 | 810 | 843 | KRH93798.1 hypothetical protein M153_5660002998, partial [Pseudoloma neurophilia] | diamond | 102 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32361697 | 32361697 | PRJNA781196_P_NODE_68079_length_228_cov_2.012903_g67702_i0 | PRJNA781196 | 68079 | 228 | 2.012903 | 4.5894188400000004 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 118 | 4.59e-32 | NR | XP_008073948.1 | 948595 | g67702 | i0 | 94.3 | 0.921052631578947 | 70 | 4 | 92.1 | 0 | 210 | 1 | 1 | 70 | XP_008073948.1 uncharacterized protein VCUG_00927 [Vavraia culicis subsp. floridensis] | diamond | 210 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 32551552 | 32551552 | PRJNA781196_P_NODE_60959_length_246_cov_0.901734_g60582_i0 | PRJNA781196 | 60959 | 246 | 0.901734 | 2.21826564 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 164 | 1.59e-47 | NR | KRH94915.1 | 146866 | g60582 | i0 | 97.5 | 0.98780487804878 | 81 | 2 | 98.8 | 0 | 244 | 2 | 35 | 115 | KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia] | diamond | 243 | 164 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32614287 | 32614287 | PRJNA781196_P_NODE_35260_length_299_cov_1.030973_g34883_i0 | PRJNA781196 | 35260 | 299 | 1.030973 | 3.08260927 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 192 | 1.9e-55 | NR | KRH92907.1 | 146866 | g34883 | i0 | 100 | 0.993311036789298 | 99 | 0 | 99.3 | 0 | 298 | 2 | 190 | 288 | KRH92907.1 Molecular chaperones HSP70/HSC70, HSP70 superfamily, partial [Pseudoloma neurophilia] | diamond | 297 | 192 | 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);;