contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA554794" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2398730 | 2398730 | PRJNA554794_P_NODE_11502_length_312_cov_0.893536_g7574_i0 | PRJNA554794 | 11502 | 312 | 0.893536 | 2.78783232 | Evosea | 2605435 | Evosea | other_Eukaryota | 149 | 1.31e-43 | NR | KAF2072588.1 | 133409 | g7574 | i0 | 71.7 | 6.66346153846154 | 99 | 28 | 95.2 | 0 | 297 | 1 | 1 | 99 | KAF2072588.1 hypothetical protein CYY_006111 [Polysphondylium violaceum] | diamond | 2079 | 150 | 0.993333333333333 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 10725037 | 10725037 | PRJNA554794_P_NODE_10589_length_359_cov_1.087097_g6682_i0 | PRJNA554794 | 10589 | 359 | 1.087097 | 3.90267823 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 196 | 9.16e-59 | NR | PRP83118.1 | 1890364 | g6682 | i0 | 75.6 | 4.97214484679666 | 119 | 29 | 99.4 | 0 | 1 | 357 | 231 | 349 | PRP83118.1 60S ribosomal protein L3 [Planoprotostelium fungivorum] | diamond | 1785 | 196 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 13274907 | 13274907 | PRJNA554794_P_NODE_11951_length_292_cov_1.374486_g8022_i0 | PRJNA554794 | 11951 | 292 | 1.374486 | 4.01349912 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 87.4 | 6.95e-20 | NR | KYQ92458.1 | 361077 | g8022 | i0 | 53.3 | 1.84931506849315 | 90 | 40 | 92.5 | 1 | 20 | 289 | 1 | 88 | KYQ92458.1 40S ribosomal protein S25 [Tieghemostelium lacteum] | diamond | 540 | 87.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 20923063 | 20923063 | PRJNA554794_P_NODE_14777_length_215_cov_0.626506_g10848_i0 | PRJNA554794 | 14777 | 215 | 0.626506 | 1.3469879 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 134 | 2.09e-34 | NR | XP_012753483.1 | 1410327 | g10848 | i0 | 88.7 | 6.90697674418605 | 71 | 8 | 99.1 | 0 | 214 | 2 | 496 | 566 | XP_012753483.1 hypothetical protein SAMD00019534_069170 [Acytostelium subglobosum LB1] | diamond | 1485 | 134 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23473393 | 23473393 | PRJNA554794_P_NODE_24439_length_162_cov_0.752212_g20510_i0 | PRJNA554794 | 24439 | 162 | 0.752212 | 1.21858344 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.1 | 7.55e-9 | NR | XP_003287614.1 | 5786 | g20510 | i0 | 59.6 | 3.05555555555556 | 52 | 16 | 96.3 | 1 | 161 | 6 | 248 | 294 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 495 | 60.5 | 0.993388429752066 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27267844 | 27267844 | PRJNA554794_P_NODE_24043_length_163_cov_0.877193_g20114_i0 | PRJNA554794 | 24043 | 163 | 0.877193 | 1.42982459 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 58.9 | 2.45e-8 | NR | XP_003291358.1 | 5786 | g20114 | i0 | 57.4 | 0.993865030674847 | 54 | 23 | 99.4 | 0 | 1 | 162 | 376 | 429 | XP_003291358.1 actin binding protein [Dictyostelium purpureum] | diamond | 162 | 58.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27457655 | 27457655 | PRJNA554794_P_NODE_15143_length_211_cov_1.469136_g11214_i0 | PRJNA554794 | 15143 | 211 | 1.469136 | 3.09987696 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 57.4 | 5.61e-8 | NR | KAH3757229.1 | 1580589 | g11214 | i0 | 65.1 | 0.611374407582938 | 43 | 15 | 61.1 | 0 | 175 | 47 | 46 | 88 | KAH3757229.1 hypothetical protein Pelo_10959 [Pelomyxa schiedti] | diamond | 129 | 57.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28562639 | 28562639 | PRJNA554794_P_NODE_21627_length_178_cov_0.790698_g17698_i0 | PRJNA554794 | 21627 | 178 | 0.790698 | 1.40744244 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 63.5 | 6.69e-10 | NR | PRP77394.1 | 1890364 | g17698 | i0 | 40.4 | 0.960674157303371 | 57 | 34 | 96.1 | 0 | 6 | 176 | 295 | 351 | PRP77394.1 hypothetical protein PROFUN_14400 [Planoprotostelium fungivorum] | diamond | 171 | 63.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29067878 | 29067878 | PRJNA554794_P_NODE_21708_length_177_cov_0.757812_g17779_i0 | PRJNA554794 | 21708 | 177 | 0.757812 | 1.34132724 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 66.2 | 8.03e-11 | NR | KAF2070099.1 | 133409 | g17779 | i0 | 56.9 | 1.96610169491525 | 58 | 24 | 98.3 | 1 | 177 | 4 | 59 | 115 | KAF2070099.1 hypothetical protein CYY_008583 [Polysphondylium violaceum] | diamond | 348 | 66.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 29256948 | 29256948 | PRJNA554794_P_NODE_19809_length_205_cov_0.801282_g15880_i0 | PRJNA554794 | 19809 | 205 | 0.801282 | 1.6426281 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 94.7 | 1.35e-23 | NR | PRP85004.1 | 1890364 | g15880 | i0 | 76.4 | 2.61951219512195 | 55 | 13 | 80.5 | 0 | 171 | 7 | 5 | 59 | PRP85004.1 hypothetical protein PROFUN_07292 [Planoprotostelium fungivorum] | diamond | 537 | 94.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29477868 | 29477868 | PRJNA554794_P_NODE_24590_length_161_cov_0.910714_g20661_i0 | PRJNA554794 | 24590 | 161 | 0.910714 | 1.46624954 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 43.1 | 0.0091 | NR | XP_004258661.1 | 370355 | g20661 | i0 | 72.7 | 0.409937888198758 | 22 | 6 | 41 | 0 | 150 | 85 | 818 | 839 | XP_004258661.1 protein serine/threonine kinase, putative [Entamoeba invadens IP1] | diamond | 66 | 43.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 29745105 | 29745105 | PRJNA554794_P_NODE_11170_length_328_cov_0.637993_g7244_i0 | PRJNA554794 | 11170 | 328 | 0.637993 | 2.09261704 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 66.6 | 4.19e-10 | NR | XP_004350707.1 | 261658 | g7244 | i0 | 39.7 | 2.1219512195122 | 116 | 49 | 99.7 | 5 | 328 | 2 | 519 | 620 | XP_004350707.1 uncharacterized protein DFA_11760 [Cavenderia fasciculata] | diamond | 696 | 66.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30092641 | 30092641 | PRJNA554794_P_NODE_13332_length_248_cov_0.763819_g9403_i0 | PRJNA554794 | 13332 | 248 | 0.763819 | 1.89427112 | Acytosteliales | 2058181 | Evosea | other_Eukaryota | 137 | 8e-38 | NR | XP_004355894.1 | 261658 | g9403 | i0 | 89 | 3.97983870967742 | 82 | 8 | 99.2 | 1 | 246 | 1 | 164 | 244 | XP_004355894.1 actin bundling protein [Cavenderia fasciculata] | diamond | 987 | 138 | 0.992753623188406 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 30426241 | 30426241 | PRJNA554794_P_NODE_23993_length_163_cov_0.885965_g20064_i0 | PRJNA554794 | 23993 | 163 | 0.885965 | 1.44412295 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 73.6 | 8.29e-15 | NR | XP_639901.1 | 352472 | g20064 | i0 | 58.3 | 0.883435582822086 | 48 | 20 | 88.3 | 0 | 6 | 149 | 60 | 107 | XP_639901.1 ubiquitin-conjugating enzyme E2 [Dictyostelium discoideum AX4] | diamond | 144 | 73.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31563865 | 31563865 | PRJNA554794_P_NODE_24036_length_163_cov_0.877193_g20107_i0 | PRJNA554794 | 24036 | 163 | 0.877193 | 1.42982459 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 93.2 | 1.68e-21 | NR | PRP82908.1 | 1890364 | g20107 | i0 | 81.5 | 2.98159509202454 | 54 | 10 | 99.4 | 0 | 163 | 2 | 65 | 118 | PRP82908.1 40S ribosomal protein S6 [Planoprotostelium fungivorum] | diamond | 486 | 93.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31974837 | 31974837 | PRJNA554794_P_NODE_11098_length_332_cov_1.703180_g7172_i0 | PRJNA554794 | 11098 | 332 | 1.70318 | 5.6545576 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 116 | 4.55e-30 | NR | PRP86688.1 | 1890364 | g7172 | i0 | 53.6 | 0.993975903614458 | 110 | 49 | 97.6 | 2 | 326 | 3 | 78 | 187 | PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum] | diamond | 330 | 116 | 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);;