contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1984849 | 1984849 | PRJNA716463_P_NODE_97922_length_253_cov_2.194444_g97505_i0 | PRJNA716463 | 97922 | 253 | 2.194444 | 5.55194332 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 139 | 1.17e-38 | NR | PRP82519.1 | 1890364 | g97505 | i0 | 80 | 0.948616600790514 | 80 | 16 | 94.9 | 0 | 253 | 14 | 139 | 218 | PRP82519.1 ribosomal protein SA-like [Planoprotostelium fungivorum] | diamond | 240 | 139 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 19834947 | 19834947 | PRJNA716463_P_NODE_47936_length_292_cov_2.100457_g47519_i0 | PRJNA716463 | 47936 | 292 | 2.100457 | 6.13333444 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 151 | 3.73e-40 | NR | PRP86903.1 | 1890364 | g47519 | i0 | 75 | 1.97260273972603 | 96 | 23 | 97.6 | 1 | 287 | 3 | 485 | 580 | PRP86903.1 elongation factor 2-like isoform 1 [Planoprotostelium fungivorum] | diamond | 576 | 151 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 21594844 | 21594844 | PRJNA716463_P_NODE_110837_length_242_cov_1.822485_g110419_i0 | PRJNA716463 | 110837 | 242 | 1.822485 | 4.4104137 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 123 | 4.05e-31 | NR | KAF2076175.1 | 133409 | g110419 | i0 | 70 | 1.98347107438017 | 80 | 24 | 99.2 | 0 | 241 | 2 | 115 | 194 | KAF2076175.1 hypothetical protein CYY_002528 [Polysphondylium violaceum] | diamond | 480 | 123 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 22385793 | 22385793 | PRJNA716463_P_NODE_66838_length_278_cov_4.921951_g66421_i0 | PRJNA716463 | 66838 | 278 | 4.921951 | 13.68302378 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 140 | 1.92e-36 | NR | XP_012752978.1 | 1410327 | g66421 | i0 | 73.9 | 1.98561151079137 | 92 | 24 | 99.3 | 0 | 278 | 3 | 672 | 763 | XP_012752978.1 hypothetical protein SAMD00019534_071170 [Acytostelium subglobosum LB1] | diamond | 552 | 140 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23661361 | 23661361 | PRJNA716463_P_NODE_65599_length_279_cov_3.757282_g65182_i0 | PRJNA716463 | 65599 | 279 | 3.757282 | 10.48281678 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 92.4 | 1.71e-20 | NR | KAH3762867.1 | 1580589 | g65182 | i0 | 49 | 1.03225806451613 | 96 | 44 | 97.8 | 2 | 6 | 278 | 53 | 148 | KAH3762867.1 14-3-3 protein [Pelomyxa schiedti] | diamond | 288 | 92.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26935868 | 26935868 | PRJNA716463_P_NODE_93682_length_257_cov_2.152174_g93265_i0 | PRJNA716463 | 93682 | 257 | 2.152174 | 5.53108718 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.2 | 2.28e-18 | NR | AAD24195.1 | 5791 | g93265 | i0 | 52.9 | 1.98443579766537 | 85 | 40 | 99.2 | 0 | 257 | 3 | 236 | 320 | AAD24195.1 fragmin A [Physarum polycephalum] | diamond | 510 | 88.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 27304976 | 27304976 | PRJNA716463_P_NODE_49283_length_291_cov_2.087156_g48866_i0 | PRJNA716463 | 49283 | 291 | 2.087156 | 6.07362396 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 90.1 | 1.51e-18 | NR | KYR00721.1 | 361077 | g48866 | i0 | 49 | 0.989690721649485 | 96 | 45 | 99 | 2 | 2 | 289 | 1099 | 1190 | KYR00721.1 alpha actinin [Tieghemostelium lacteum] | diamond | 288 | 90.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 28820168 | 28820168 | PRJNA716463_P_NODE_62048_length_282_cov_2.200957_g61631_i0 | PRJNA716463 | 62048 | 282 | 2.200957 | 6.20669874 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 114 | 4.8e-28 | NR | XP_004341646.1 | 1257118 | g61631 | i0 | 57.9 | 3.04255319148936 | 95 | 39 | 100 | 1 | 282 | 1 | 202 | 296 | XP_004341646.1 papain family cysteine protease containing protein [Acanthamoeba castellanii str. Neff] | diamond | 858 | 114 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29231140 | 29231140 | PRJNA716463_P_NODE_33549_length_299_cov_5.053097_g33132_i0 | PRJNA716463 | 33549 | 299 | 5.053097 | 15.10876003 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 45.1 | 0.0104 | NR | XP_012751617.1 | 1410327 | g33132 | i0 | 45.1 | 0.511705685618729 | 51 | 27 | 51.2 | 1 | 295 | 143 | 159 | 208 | XP_012751617.1 hypothetical protein SAMD00019534_088060 [Acytostelium subglobosum LB1] | diamond | 153 | 45.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 29294090 | 29294090 | PRJNA716463_P_NODE_100509_length_251_cov_0.865169_g100092_i0 | PRJNA716463 | 100509 | 251 | 0.865169 | 2.17157419 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 92.4 | 1.34e-19 | NR | PRP85070.1 | 1890364 | g100092 | i0 | 55.4 | 0.884462151394422 | 74 | 32 | 88.4 | 1 | 28 | 249 | 590 | 662 | PRP85070.1 hypothetical protein PROFUN_07254 [Planoprotostelium fungivorum] | diamond | 222 | 92.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29609529 | 29609529 | PRJNA716463_P_NODE_92710_length_258_cov_1.664865_g92293_i0 | PRJNA716463 | 92710 | 258 | 1.664865 | 4.2953517 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 74.3 | 1.34e-13 | NR | XP_001733013.1 | 352472 | g92293 | i0 | 44.8 | 1.84883720930233 | 87 | 47 | 100 | 1 | 1 | 258 | 88 | 174 | XP_001733013.1 calcium-binding EF-hand domain-containing protein [Dictyostelium discoideum AX4] | diamond | 477 | 74.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29894190 | 29894190 | PRJNA716463_P_NODE_105711_length_246_cov_3.265896_g105293_i0 | PRJNA716463 | 105711 | 246 | 3.265896 | 8.03410416 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 57.8 | 2.04e-7 | NR | PRP83859.1 | 1890364 | g105293 | i0 | 42.6 | 1.65853658536585 | 68 | 31 | 82.9 | 3 | 13 | 216 | 1252 | 1311 | PRP83859.1 hypothetical protein PROFUN_08890 [Planoprotostelium fungivorum] | diamond | 408 | 57.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30336792 | 30336792 | PRJNA716463_P_NODE_94472_length_256_cov_2.808743_g94055_i0 | PRJNA716463 | 94472 | 256 | 2.808743 | 7.19038208 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 78.2 | 1.58e-15 | NR | XP_003291097.1 | 5786 | g94055 | i0 | 41 | 2.9296875 | 83 | 49 | 97.3 | 0 | 6 | 254 | 17 | 99 | XP_003291097.1 uncharacterized protein DICPUDRAFT_38509 [Dictyostelium purpureum] | diamond | 750 | 78.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30968452 | 30968452 | PRJNA716463_P_NODE_78654_length_269_cov_4.000000_g78237_i0 | PRJNA716463 | 78654 | 269 | 4 | 10.76 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 137 | 5.89e-36 | NR | PRP76506.1 | 1890364 | g78237 | i0 | 67.8 | 0.970260223048327 | 87 | 28 | 97 | 0 | 266 | 6 | 289 | 375 | PRP76506.1 aldehyde dehydrogenase [Planoprotostelium fungivorum] | diamond | 261 | 137 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31727010 | 31727010 | PRJNA716463_P_NODE_49537_length_291_cov_1.821101_g49120_i0 | PRJNA716463 | 49537 | 291 | 1.821101 | 5.29940391 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 73.6 | 9.33e-13 | NR | PRP84218.1 | 1890364 | g49120 | i0 | 55.9 | 0.701030927835051 | 68 | 27 | 70.1 | 1 | 206 | 3 | 26 | 90 | PRP84218.1 hypothetical protein PROFUN_08418 [Planoprotostelium fungivorum] | diamond | 204 | 73.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31758752 | 31758752 | PRJNA716463_P_NODE_99677_length_251_cov_3.129213_g99260_i0 | PRJNA716463 | 99677 | 251 | 3.129213 | 7.85432463 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 97.1 | 6.680000000000001e-22 | NR | PRP76458.1 | 1890364 | g99260 | i0 | 55.4 | 2.00796812749004 | 83 | 36 | 99.2 | 1 | 251 | 3 | 53 | 134 | PRP76458.1 vacuolar protein sorting-associated protein 26 [Planoprotostelium fungivorum] | diamond | 504 | 97.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31885216 | 31885216 | PRJNA716463_P_NODE_96877_length_254_cov_2.160221_g96460_i0 | PRJNA716463 | 96877 | 254 | 2.160221 | 5.48696134 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 84.7 | 7.24e-17 | NR | PRP88434.1 | 1890364 | g96460 | i0 | 58.2 | 1.86614173228346 | 79 | 33 | 93.3 | 0 | 247 | 11 | 341 | 419 | PRP88434.1 hypothetical protein PROFUN_03151 [Planoprotostelium fungivorum] | diamond | 474 | 84.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;