contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1583878 | 1583878 | PRJNA1160211_S_NODE_138242_length_392_cov_2.862069_g137010_i0 | PRJNA1160211 | 138242 | 392 | 2.862069 | 11.21931048 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 177 | 8.57e-54 | NR | PRP84519.1 | 1890364 | g137010 | i0 | 74.1 | 0.826530612244898 | 108 | 28 | 82.7 | 0 | 391 | 68 | 73 | 180 | PRP84519.1 ribosomal protein L11 [Planoprotostelium fungivorum] | diamond | 324 | 177 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 6688724 | 6688724 | PRJNA1160211_S_NODE_82166_length_493_cov_38.211905_g80948_i0 | PRJNA1160211 | 82166 | 493 | 38.211905 | 188.38469165 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 246 | 2.11e-81 | NR | PRP85958.1 | 1890364 | g80948 | i0 | 87.1 | 0.845841784989858 | 139 | 16 | 83.4 | 1 | 60 | 470 | 1 | 139 | PRP85958.1 hypothetical protein PROFUN_06080 [Planoprotostelium fungivorum] | diamond | 417 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 11787711 | 11787711 | PRJNA1160211_S_NODE_116230_length_427_cov_31.799435_g115001_i0 | PRJNA1160211 | 116230 | 427 | 31.799435 | 135.78358745 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 71.6 | 2.19e-11 | NR | KAH3757423.1 | 1580589 | g115001 | i0 | 50 | 0.463700234192037 | 66 | 33 | 46.4 | 0 | 223 | 420 | 195 | 260 | KAH3757423.1 cation efflux protein [Pelomyxa schiedti] | diamond | 198 | 71.6 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 18162300 | 18162300 | PRJNA1160211_S_NODE_69015_length_524_cov_4.172949_g67810_i0 | PRJNA1160211 | 69015 | 524 | 4.172949 | 21.86625276 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 5.91e-46 | NR | XP_020430877.1 | 670386 | g67810 | i0 | 68.4 | 12.8530534351145 | 136 | 40 | 77.9 | 1 | 3 | 410 | 653 | 785 | XP_020430877.1 cell division cycle protein 48 [Heterostelium album PN500] | diamond | 6735 | 171 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 26787334 | 26787334 | PRJNA1160211_S_NODE_243701_length_267_cov_2.381443_g242468_i0 | PRJNA1160211 | 243701 | 267 | 2.381443 | 6.35845281 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 46.2 | 0.00307 | NR | PRP88438.1 | 1890364 | g242468 | i0 | 43.5 | 0.51685393258427 | 46 | 26 | 51.7 | 0 | 252 | 115 | 658 | 703 | PRP88438.1 centaurin beta [Planoprotostelium fungivorum] | diamond | 138 | 46.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26913718 | 26913718 | PRJNA1160211_S_NODE_178642_length_336_cov_3.000000_g177409_i0 | PRJNA1160211 | 178642 | 336 | 3 | 10.08 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 44.7 | 0.0234 | NR | PRP81712.1 | 1890364 | g177409 | i0 | 32.7 | 0.982142857142857 | 110 | 50 | 98.2 | 4 | 5 | 334 | 1080 | 1165 | PRP81712.1 hypothetical protein PROFUN_10812 [Planoprotostelium fungivorum] | diamond | 330 | 44.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 26945370 | 26945370 | PRJNA1160211_S_NODE_6242_length_902_cov_19.675513_g5621_i0 | PRJNA1160211 | 6242 | 902 | 19.675513 | 177.47312726 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 95.5 | 8.44e-18 | NR | PRP84160.1 | 1890364 | g5621 | i0 | 46.8 | 0.362527716186253 | 109 | 50 | 33.9 | 2 | 377 | 682 | 728 | 835 | PRP84160.1 hypothetical protein PROFUN_04151 [Planoprotostelium fungivorum] | diamond | 327 | 95.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28051117 | 28051117 | PRJNA1160211_S_NODE_153965_length_369_cov_3.057432_g152732_i0 | PRJNA1160211 | 153965 | 369 | 3.057432 | 11.28192408 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 88.6 | 1.35e-17 | NR | PRP88045.1 | 1890364 | g152732 | i0 | 38.4 | 0.910569105691057 | 112 | 63 | 88.6 | 3 | 5 | 331 | 97 | 205 | PRP88045.1 hypothetical protein PROFUN_04473 [Planoprotostelium fungivorum] | diamond | 336 | 88.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29282338 | 29282338 | PRJNA1160211_S_NODE_19789_length_711_cov_3.327586_g18792_i0 | PRJNA1160211 | 19789 | 711 | 3.327586 | 23.65913646 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 175 | 2.85e-49 | NR | KAH3743152.1 | 1580589 | g18792 | i0 | 51.6 | 1.33333333333333 | 157 | 71 | 66.2 | 3 | 1 | 471 | 196 | 347 | KAH3743152.1 beta-1,3-glucan-binding protein [Pelomyxa schiedti] | diamond | 948 | 175 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 30281328 | 30281328 | PRJNA1160211_S_NODE_246192_length_265_cov_1.703125_g244959_i0 | PRJNA1160211 | 246192 | 265 | 1.703125 | 4.51328125 | Dictyosteliales | 2058949 | Evosea | other_Eukaryota | 108 | 1.88e-25 | NR | XP_003288404.1 | 5786 | g244959 | i0 | 56.3 | 8.78490566037736 | 87 | 37 | 98.5 | 1 | 264 | 4 | 271 | 356 | XP_003288404.1 protein phosphatase 2A 55 kDa regulatory B subunit [Dictyostelium purpureum] | diamond | 2328 | 109 | 0.990825688073395 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30849560 | 30849560 | PRJNA1160211_S_NODE_223954_length_285_cov_5.353774_g222721_i0 | PRJNA1160211 | 223954 | 285 | 5.353774 | 15.2582559 | Dictyosteliaceae | 2058185 | Evosea | other_Eukaryota | 143 | 2.32e-37 | NR | XP_003292154.1 | 5786 | g222721 | i0 | 77.3 | 6.46315789473684 | 88 | 20 | 92.6 | 0 | 22 | 285 | 508 | 595 | XP_003292154.1 major vault protein-alpha [Dictyostelium purpureum] | diamond | 1842 | 144 | 0.993055555555556 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 31208995 | 31208995 | PRJNA1160211_S_NODE_133875_length_399_cov_2.193252_g132643_i0 | PRJNA1160211 | 133875 | 399 | 2.193252 | 8.75107548 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 179 | 8.13e-53 | NR | PRP82884.1 | 1890364 | g132643 | i0 | 64.8 | 1.93233082706767 | 128 | 45 | 96.2 | 0 | 11 | 394 | 199 | 326 | PRP82884.1 3-hydroxyisobutyrate dehydrogenase [Planoprotostelium fungivorum] | diamond | 771 | 179 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31272726 | 31272726 | PRJNA1160211_S_NODE_132795_length_400_cov_15.094801_g131563_i0 | PRJNA1160211 | 132795 | 400 | 15.094801 | 60.379204 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 117 | 1.16e-27 | NR | XP_012760143.1 | 1410327 | g131563 | i0 | 83.8 | 1.11 | 74 | 12 | 55.5 | 0 | 28 | 249 | 702 | 775 | XP_012760143.1 hypothetical protein SAMD00019534_037970 [Acytostelium subglobosum LB1] | diamond | 444 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 31387053 | 31387053 | PRJNA1160211_S_NODE_151896_length_372_cov_2.581940_g150663_i0 | PRJNA1160211 | 151896 | 372 | 2.58194 | 9.6048168 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 3.35e-15 | NR | PRP79675.1 | 1890364 | g150663 | i0 | 41.5 | 4.41935483870968 | 106 | 58 | 84.7 | 3 | 20 | 334 | 161 | 263 | PRP79675.1 hypothetical protein PROFUN_12573 [Planoprotostelium fungivorum] | diamond | 1644 | 81.3 | 0.990159901599016 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31399371 | 31399371 | PRJNA1160211_S_NODE_128996_length_406_cov_11.300300_g127764_i0 | PRJNA1160211 | 128996 | 406 | 11.3003 | 45.879218 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 52.4 | 1.03e-5 | NR | PRP74450.1 | 1890364 | g127764 | i0 | 47.1 | 0.517241379310345 | 70 | 30 | 51 | 3 | 283 | 77 | 46 | 109 | PRP74450.1 hypothetical protein PROFUN_06579 [Planoprotostelium fungivorum] | diamond | 210 | 52.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31399389 | 31399389 | PRJNA1160211_S_NODE_244076_length_267_cov_1.190722_g242843_i0 | PRJNA1160211 | 244076 | 267 | 1.190722 | 3.17922774 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 92.4 | 1.74e-19 | NR | PRP82109.1 | 1890364 | g242843 | i0 | 57.8 | 0.932584269662921 | 83 | 34 | 92.1 | 1 | 246 | 1 | 909 | 991 | PRP82109.1 Alpha amylase, catalytic subdomain [Planoprotostelium fungivorum] | diamond | 249 | 92.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31430802 | 31430802 | PRJNA1160211_S_NODE_243496_length_267_cov_3.469072_g242263_i0 | PRJNA1160211 | 243496 | 267 | 3.469072 | 9.26242224 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 43.9 | 0.0132 | NR | PRP77835.1 | 1890364 | g242263 | i0 | 40 | 0.674157303370786 | 60 | 34 | 65.2 | 1 | 220 | 47 | 120 | 179 | PRP77835.1 hypothetical protein PROFUN_14154 [Planoprotostelium fungivorum] | diamond | 180 | 43.9 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31683715 | 31683715 | PRJNA1160211_S_NODE_226357_length_283_cov_2.409524_g225124_i0 | PRJNA1160211 | 226357 | 283 | 2.4095240000000002 | 6.81895292 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 89.7 | 1.84e-18 | NR | PRP87320.1 | 1890364 | g225124 | i0 | 58.6 | 0.614840989399293 | 58 | 24 | 61.5 | 0 | 107 | 280 | 310 | 367 | PRP87320.1 SH3 domain-containing protein [Planoprotostelium fungivorum] | diamond | 174 | 89.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31747064 | 31747064 | PRJNA1160211_S_NODE_186537_length_326_cov_5.770751_g185304_i0 | PRJNA1160211 | 186537 | 326 | 5.770751 | 18.81264826 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 141 | 5.6e-40 | NR | PRP89530.1 | 1890364 | g185304 | i0 | 85.2 | 0.745398773006135 | 81 | 12 | 74.5 | 0 | 296 | 54 | 108 | 188 | PRP89530.1 component of cytosolic 80S ribosome and 40S small subunit [Planoprotostelium fungivorum] | diamond | 243 | 141 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31810420 | 31810420 | PRJNA1160211_S_NODE_281737_length_241_cov_9.017857_g280504_i0 | PRJNA1160211 | 281737 | 241 | 9.017857 | 21.73303537 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 80.1 | 1.24e-16 | NR | XP_629020.1 | 352472 | g280504 | i0 | 70.4 | 1.34439834024896 | 54 | 15 | 66 | 1 | 23 | 181 | 121 | 174 | XP_629020.1 dCTP deaminase [Dictyostelium discoideum AX4] | diamond | 324 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 32884497 | 32884497 | PRJNA1160211_S_NODE_24600_length_681_cov_2.404605_g23548_i0 | PRJNA1160211 | 24600 | 681 | 2.404605 | 16.37536005 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 140 | 1.56e-37 | NR | KAH3744073.1 | 1580589 | g23548 | i0 | 44.7 | 0.748898678414097 | 170 | 79 | 74.9 | 4 | 1 | 510 | 56 | 210 | KAH3744073.1 sialate O-acetylesterase [Pelomyxa schiedti] | diamond | 510 | 140 | 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);;