contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26737532 | 26737532 | PRJNA827593_P_NODE_34821_length_347_cov_1.948905_g34522_i0 | PRJNA827593 | 34821 | 347 | 1.948905 | 6.76270035 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 75.9 | 2.93e-13 | NR | KAF2072033.1 | 133409 | g34522 | i0 | 36.1 | 1.02881844380403 | 119 | 59 | 99.4 | 2 | 347 | 3 | 408 | 513 | KAF2072033.1 hypothetical protein CYY_006644 [Polysphondylium violaceum] | diamond | 357 | 75.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 27252689 | 27252689 | PRJNA827593_P_NODE_54983_length_267_cov_2.762887_g54684_i0 | PRJNA827593 | 54983 | 267 | 2.762887 | 7.37690829 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94 | 6.120000000000001e-21 | NR | XP_646934.1 | 352472 | g54684 | i0 | 53.4 | 1.97752808988764 | 88 | 40 | 98.9 | 1 | 266 | 3 | 137 | 223 | XP_646934.1 hypothetical protein DDB_G0268970 [Dictyostelium discoideum AX4] | diamond | 528 | 94 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27434046 | 27434046 | PRJNA827593_P_NODE_9383_length_725_cov_1.763804_g9094_i0 | PRJNA827593 | 9383 | 725 | 1.763804 | 12.787579 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 97.4 | 5.38e-19 | NR | KAH3743940.1 | 1580589 | g9094 | i0 | 24.9 | 1.43172413793103 | 346 | 155 | 99.7 | 5 | 1 | 723 | 1260 | 1605 | KAH3743940.1 RNA ligase, T4 RnlA family protein [Pelomyxa schiedti] | diamond | 1038 | 97.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 27591842 | 27591842 | PRJNA827593_P_NODE_49284_length_285_cov_1.905660_g48985_i0 | PRJNA827593 | 49284 | 285 | 1.90566 | 5.431131 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 62.4 | 7.5e-9 | NR | XP_004333053.1 | 1257118 | g48985 | i0 | 34.4 | 0.978947368421053 | 93 | 58 | 94.7 | 2 | 276 | 7 | 328 | 420 | XP_004333053.1 rieske [2fe2s] domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 279 | 62.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28444260 | 28444260 | PRJNA827593_P_NODE_27806_length_395_cov_1.180124_g27507_i0 | PRJNA827593 | 27806 | 395 | 1.180124 | 4.6614898 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 87.4 | 4.97e-17 | NR | PRP85784.1 | 1890364 | g27507 | i0 | 48.9 | 0.713924050632911 | 94 | 45 | 69.1 | 2 | 104 | 376 | 915 | 1008 | PRP85784.1 hypothetical protein PROFUN_05976 [Planoprotostelium fungivorum] | diamond | 282 | 87.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28759807 | 28759807 | PRJNA827593_P_NODE_42047_length_312_cov_1.878661_g41748_i0 | PRJNA827593 | 42047 | 312 | 1.878661 | 5.86142232 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 72 | 4.53e-12 | NR | PRP79649.1 | 1890364 | g41748 | i0 | 45.1 | 9.49038461538461 | 82 | 41 | 75 | 1 | 236 | 3 | 1195 | 1276 | PRP79649.1 hypothetical protein PROFUN_10549 [Planoprotostelium fungivorum] | diamond | 2961 | 72 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29139022 | 29139022 | PRJNA827593_P_NODE_36349_length_339_cov_1.157895_g36050_i0 | PRJNA827593 | 36349 | 339 | 1.157895 | 3.92526405 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 52.4 | 4.34e-5 | NR | XP_004338880.1 | 1257118 | g36050 | i0 | 42.9 | 0.433628318584071 | 49 | 28 | 43.4 | 0 | 151 | 5 | 41 | 89 | XP_004338880.1 DOM3 exoribonuclease, putative [Acanthamoeba castellanii str. Neff] | diamond | 147 | 52.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31508401 | 31508401 | PRJNA827593_P_NODE_47576_length_291_cov_1.678899_g47277_i0 | PRJNA827593 | 47576 | 291 | 1.678899 | 4.88559609 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 54.7 | 4.2e-6 | NR | KAF2073367.1 | 133409 | g47277 | i0 | 65.7 | 0.360824742268041 | 35 | 12 | 36.1 | 0 | 75 | 179 | 405 | 439 | KAF2073367.1 hypothetical protein CYY_005312 [Polysphondylium violaceum] | diamond | 105 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 32077680 | 32077680 | PRJNA827593_P_NODE_68978_length_234_cov_2.223602_g68679_i0 | PRJNA827593 | 68978 | 234 | 2.223602 | 5.20322868 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 47.4 | 7.4e-4 | NR | PRP89756.1 | 1890364 | g68679 | i0 | 40 | 0.833333333333333 | 65 | 34 | 83.3 | 1 | 202 | 8 | 168 | 227 | PRP89756.1 hypothetical protein PROFUN_00098 [Planoprotostelium fungivorum] | diamond | 195 | 47.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32236200 | 32236200 | PRJNA827593_P_NODE_37878_length_331_cov_1.492248_g37579_i0 | PRJNA827593 | 37878 | 331 | 1.492248 | 4.93934088 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 57.8 | 5.66e-7 | NR | PRP80831.1 | 1890364 | g37579 | i0 | 47.5 | 0.552870090634441 | 61 | 32 | 55.3 | 0 | 95 | 277 | 297 | 357 | PRP80831.1 hypothetical protein PROFUN_11246 [Planoprotostelium fungivorum] | diamond | 183 | 57.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32583994 | 32583994 | PRJNA827593_P_NODE_52079_length_276_cov_1.517241_g51780_i0 | PRJNA827593 | 52079 | 276 | 1.517241 | 4.18758516 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 100 | 5.51e-23 | NR | KAH3759660.1 | 1580589 | g51780 | i0 | 53.5 | 2.71739130434783 | 86 | 40 | 93.5 | 0 | 259 | 2 | 115 | 200 | KAH3759660.1 hypothetical protein Pelo_8558 [Pelomyxa schiedti] | diamond | 750 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti |
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);;