contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA983838" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2240270 | 2240270 | PRJNA983838_P_NODE_20222_length_926_cov_2.762016_g18210_i0 | PRJNA983838 | 20222 | 926 | 2.762016 | 25.57626816 | Chlorophyta | 3041 | Plants | Plants | 460 | 7.239999999999998e-152 | NR | XP_002500915.1 | 296587 | g18210 | i0 | 78.4 | 5.67278617710583 | 282 | 61 | 91.4 | 0 | 1 | 846 | 648 | 929 | XP_002500915.1 predicted protein [Micromonas commoda] | diamond | 5253 | 460 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 17543960 | 17543960 | PRJNA983838_P_NODE_98134_length_263_cov_1.394737_g95767_i0 | PRJNA983838 | 98134 | 263 | 1.394737 | 3.66815831 | root | 1 | Root_unresolved | Root_unresolved | 136 | 6.46e-35 | NR | XP_001417128.1 | 436017 | g95767 | i0 | 70.1 | 4.96197718631179 | 87 | 26 | 99.2 | 0 | 3 | 263 | 316 | 402 | XP_001417128.1 predicted protein [Ostreococcus lucimarinus CCE9901] | diamond | 1305 | 137 | 0.992700729927007 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus sp. 'lucimarinus' | ||
| 25192216 | 25192216 | PRJNA983838_P_NODE_93600_length_271_cov_1.525253_g91233_i0 | PRJNA983838 | 93600 | 271 | 1.525253 | 4.13343563 | Chlorophyta | 3041 | Plants | Plants | 138 | 9.21e-38 | NR | CAG9462523.1 | 765719 | g91233 | i0 | 72.2 | 72.7306273062731 | 90 | 25 | 99.6 | 0 | 2 | 271 | 152 | 241 | CAG9462523.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 19710 | 138 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 27184218 | 27184218 | PRJNA983838_P_NODE_103502_length_254_cov_1.624309_g101135_i0 | PRJNA983838 | 103502 | 254 | 1.624309 | 4.12574486 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 84.3 | 3.51e-19 | NR | XP_003055561.1 | 564608 | g101135 | i0 | 69.6 | 0.661417322834646 | 56 | 17 | 66.1 | 0 | 176 | 9 | 32 | 87 | XP_003055561.1 uncharacterized protein MICPUCDRAFT_50343 [Micromonas pusilla CCMP1545] | diamond | 168 | 84.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 27253469 | 27253469 | PRJNA983838_P_NODE_122723_length_228_cov_3.645161_g120356_i0 | PRJNA983838 | 122723 | 228 | 3.645161 | 8.31096708 | Chlorophyta | 3041 | Plants | Plants | 64.3 | 3.82e-10 | NR | KAK3282277.1 | 36881 | g120356 | i0 | 49.2 | 7.21052631578947 | 61 | 31 | 80.3 | 0 | 228 | 46 | 188 | 248 | KAK3282277.1 hypothetical protein CYMTET_9977 [Cymbomonas tetramitiformis] | diamond | 1644 | 64.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27759232 | 27759232 | PRJNA983838_P_NODE_100344_length_259_cov_1.677419_g97977_i0 | PRJNA983838 | 100344 | 259 | 1.677419 | 4.34451521 | Viridiplantae | 33090 | Plants | Plants | 47.8 | 7.71e-4 | NR | KAK3236469.1 | 36881 | g97977 | i0 | 42 | 1.25096525096525 | 50 | 29 | 57.9 | 0 | 18 | 167 | 949 | 998 | KAK3236469.1 hypothetical protein CYMTET_53396 [Cymbomonas tetramitiformis] | diamond | 324 | 47.8 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28826197 | 28826197 | PRJNA983838_P_NODE_100328_length_259_cov_1.677419_g97961_i0 | PRJNA983838 | 100328 | 259 | 1.677419 | 4.34451521 | Chloropicon primus | 1764295 | Plants | Plants | 50.4 | 8.62e-5 | NR | QDZ22834.1 | 1764295 | g97961 | i0 | 48.9 | 1.08880308880309 | 47 | 22 | 52.1 | 1 | 124 | 258 | 325 | 371 | QDZ22834.1 hypothetical protein A3770_08p53520 [Chloropicon primus] | diamond | 282 | 50.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 28990598 | 28990598 | PRJNA983838_P_NODE_83588_length_291_cov_1.431193_g81221_i0 | PRJNA983838 | 83588 | 291 | 1.431193 | 4.16477163 | Chlorophyta | 3041 | Plants | Plants | 120 | 3.24e-29 | NR | KAL4853064.1 | 3077 | g81221 | i0 | 62.9 | 19.0721649484536 | 89 | 33 | 91.8 | 0 | 289 | 23 | 1390 | 1478 | KAL4853064.1 Proteasome subunit alpha type-2 [Chlorella vulgaris] | diamond | 5550 | 121 | 0.991735537190083 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 29363264 | 29363264 | PRJNA983838_P_NODE_104429_length_253_cov_0.866667_g102062_i0 | PRJNA983838 | 104429 | 253 | 0.866667 | 2.19266751 | Volvox reticuliferus | 1737510 | Plants | Plants | 58.5 | 1.14e-7 | NR | GIL88831.1 | 1737510 | g102062 | i0 | 37 | 1.92094861660079 | 81 | 50 | 94.9 | 1 | 249 | 10 | 459 | 539 | GIL88831.1 hypothetical protein Vretifemale_16749 [Volvox reticuliferus] | diamond | 486 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 30380262 | 30380262 | PRJNA983838_P_NODE_26312_length_745_cov_7.004464_g24058_i0 | PRJNA983838 | 26312 | 745 | 7.004464 | 52.1832568 | Eukaryota | 2759 | Plants | Plants | 165 | 5.79e-45 | NR | WIA40358.1 | 3088 | g24058 | i0 | 45.5 | 7.40134228187919 | 189 | 99 | 74.5 | 3 | 4 | 558 | 202 | 390 | WIA40358.1 hypothetical protein OEZ86_013722 [Tetradesmus obliquus] | diamond | 5514 | 166 | 0.993975903614458 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 30911158 | 30911158 | PRJNA983838_P_NODE_71794_length_325_cov_1.238095_g69427_i0 | PRJNA983838 | 71794 | 325 | 1.238095 | 4.02380875 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 51.2 | 9.29e-5 | NR | KAG1665159.1 | 1653778 | g69427 | i0 | 56.9 | 0.470769230769231 | 51 | 21 | 47.1 | 1 | 6 | 158 | 292 | 341 | KAG1665159.1 hypothetical protein FOA52_005540 [Chlamydomonas sp. UWO 241] | diamond | 153 | 51.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 31106453 | 31106453 | PRJNA983838_P_NODE_117115_length_243_cov_1.270588_g114748_i0 | PRJNA983838 | 117115 | 243 | 1.270588 | 3.08752884 | Chlamydomonadales | 3042 | Plants | Plants | 109 | 1.41e-29 | NR | XP_042924859.1 | 3055 | g114748 | i0 | 82 | 2.2962962962963 | 61 | 11 | 75.3 | 0 | 6 | 188 | 1 | 61 | XP_042924859.1 uncharacterized protein CHLRE_05g237700v5 [Chlamydomonas reinhardtii] | diamond | 558 | 110 | 0.990909090909091 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 31194966 | 31194966 | PRJNA983838_P_NODE_108115_length_250_cov_0.881356_g105748_i0 | PRJNA983838 | 108115 | 250 | 0.881356 | 2.20339 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 49.3 | 1.93e-4 | NR | KAF8055395.1 | 2742167 | g105748 | i0 | 73.3 | 0.36 | 30 | 8 | 36 | 0 | 236 | 147 | 134 | 163 | KAF8055395.1 XBAT31 [Scenedesmus sp. PABB004] | diamond | 90 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 31290133 | 31290133 | PRJNA983838_P_NODE_105235_length_252_cov_1.743017_g102868_i0 | PRJNA983838 | 105235 | 252 | 1.743017 | 4.39240284 | Coccomyxa elongata | 1965095 | Plants | Plants | 84 | 1.29e-16 | NR | CAL8466735.1 | 1965095 | g102868 | i0 | 54.1 | 0.880952380952381 | 74 | 34 | 88.1 | 0 | 238 | 17 | 696 | 769 | CAL8466735.1 g6271 [Coccomyxa elongata] | diamond | 222 | 84 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 31448467 | 31448467 | PRJNA983838_P_NODE_122016_length_231_cov_2.803797_g119649_i0 | PRJNA983838 | 122016 | 231 | 2.803797 | 6.47677107 | Symbiochloris irregularis | 706552 | Plants | Plants | 100 | 5.04e-23 | NR | KAK9807924.1 | 706552 | g119649 | i0 | 56.6 | 0.987012987012987 | 76 | 30 | 97.4 | 2 | 1 | 225 | 80 | 153 | KAK9807924.1 hypothetical protein WJX73_002821 [Symbiochloris irregularis] | diamond | 228 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 31517792 | 31517792 | PRJNA983838_P_NODE_77276_length_307_cov_7.615385_g74909_i0 | PRJNA983838 | 77276 | 307 | 7.615385 | 23.37923195 | Viridiplantae | 33090 | Plants | Plants | 57.4 | 1.94e-8 | NR | XP_007514946.1 | 41875 | g74909 | i0 | 56.5 | 1.08469055374593 | 46 | 20 | 45 | 0 | 57 | 194 | 7 | 52 | XP_007514946.1 predicted protein [Bathycoccus prasinos] | diamond | 333 | 57.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 32112798 | 32112798 | PRJNA983838_P_NODE_81398_length_296_cov_2.762332_g79031_i0 | PRJNA983838 | 81398 | 296 | 2.762332 | 8.17650272 | Bathycoccus prasinos | 41875 | Plants | Plants | 81.6 | 2.74e-18 | NR | XP_007515728.1 | 41875 | g79031 | i0 | 85 | 0.405405405405405 | 40 | 6 | 40.5 | 0 | 48 | 167 | 1 | 40 | XP_007515728.1 predicted protein [Bathycoccus prasinos] | diamond | 120 | 81.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 32750651 | 32750651 | PRJNA983838_P_NODE_107520_length_250_cov_2.508475_g105153_i0 | PRJNA983838 | 107520 | 250 | 2.508475 | 6.2711875 | Eukaryota | 2759 | Plants | Plants | 138 | 8.64e-39 | NR | XP_011401684.1 | 3075 | g105153 | i0 | 84.3 | 1776.804 | 83 | 13 | 99.6 | 0 | 249 | 1 | 12 | 94 | XP_011401684.1 Histone H3.1 [Auxenochlorella protothecoides] | diamond | 444201 | 139 | 0.992805755395683 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;