contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA561138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5648795 | 5648795 | PRJNA561138_P_NODE_13325_length_358_cov_1.266667_g13130_i0 | PRJNA561138 | 13325 | 358 | 1.266667 | 4.53466786 | Micractinium conductrix | 554055 | Plants | Plants | 204 | 7.7e-59 | NR | YP_009456037.1 | 554055 | g13130 | i0 | 86.3 | 0.980446927374302 | 117 | 16 | 98 | 0 | 353 | 3 | 708 | 824 | YP_009456037.1 cell division protein FtsH [Micractinium conductrix] | diamond | 351 | 204 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 15847957 | 15847957 | PRJNA561138_P_NODE_25693_length_249_cov_0.875000_g25498_i0 | PRJNA561138 | 25693 | 249 | 0.875 | 2.17875 | Chlorellaceae | 35461 | Plants | Plants | 99.4 | 4.87e-22 | NR | QSJ54232.1 | 3077 | g25498 | i0 | 70 | 2.51807228915663 | 70 | 21 | 84.3 | 0 | 248 | 39 | 608 | 677 | QSJ54232.1 RNA polymerase beta subunit [Chlorella vulgaris] | diamond | 627 | 100 | 0.994 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 26920896 | 26920896 | PRJNA561138_P_NODE_28582_length_244_cov_0.900585_g28387_i0 | PRJNA561138 | 28582 | 244 | 0.900585 | 2.1974274 | Haematococcus lacustris | 44745 | Plants | Plants | 166 | 2.06e-46 | NR | KAJ9533738.1 | 44745 | g28387 | i0 | 98.8 | 52.7581967213115 | 81 | 1 | 99.6 | 0 | 2 | 244 | 450 | 530 | KAJ9533738.1 hypothetical protein QJQ45_026804 [Haematococcus lacustris] | diamond | 12873 | 166 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 26952363 | 26952363 | PRJNA561138_P_NODE_9262_length_416_cov_0.897959_g9067_i0 | PRJNA561138 | 9262 | 416 | 0.897959 | 3.73550944 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 100 | 1.1e-21 | NR | KAL4425680.1 | 2728915 | g9067 | i0 | 77.8 | 0.454326923076923 | 63 | 11 | 45.4 | 1 | 347 | 159 | 314 | 373 | KAL4425680.1 hypothetical protein ABPG75_009696 [Micractinium tetrahymenae] | diamond | 189 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 27679651 | 27679651 | PRJNA561138_P_NODE_14624_length_343_cov_0.848148_g14429_i0 | PRJNA561138 | 14624 | 343 | 0.848148 | 2.90914764 | Chlorella vulgaris | 3077 | Plants | Plants | 176 | 1.5599999999999994e-48 | NR | KAL4853635.1 | 3077 | g14429 | i0 | 78 | 5.7201166180758 | 109 | 23 | 94.5 | 1 | 341 | 18 | 737 | 845 | KAL4853635.1 hypothetical protein ACK3TF_005359 [Chlorella vulgaris] | diamond | 1962 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 28121344 | 28121344 | PRJNA561138_P_NODE_9905_length_406_cov_0.912913_g9710_i0 | PRJNA561138 | 9905 | 406 | 0.912913 | 3.70642678 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 187 | 5.55e-53 | NR | KAL4441049.1 | 554058 | g9710 | i0 | 67.2 | 1.935960591133 | 131 | 43 | 96.8 | 0 | 404 | 12 | 150 | 280 | KAL4441049.1 hypothetical protein ABPG77_010480 [Micractinium sp. CCAP 211/92] | diamond | 786 | 187 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 28215834 | 28215834 | PRJNA561138_P_NODE_6886_length_473_cov_1.297500_g6692_i0 | PRJNA561138 | 6886 | 473 | 1.2975 | 6.137175 | Haematococcus lacustris | 44745 | Plants | Plants | 286 | 2.4700000000000002e-86 | NR | KAJ9512429.1 | 44745 | g6692 | i0 | 99.4 | 19.9090909090909 | 157 | 1 | 99.6 | 0 | 472 | 2 | 922 | 1078 | KAJ9512429.1 hypothetical protein QJQ45_013014 [Haematococcus lacustris] | diamond | 9417 | 286 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28247487 | 28247487 | PRJNA561138_P_NODE_8286_length_435_cov_0.850829_g8091_i0 | PRJNA561138 | 8286 | 435 | 0.850829 | 3.70110615 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 57.8 | 1.75e-6 | NR | KAL4421480.1 | 2728915 | g8091 | i0 | 96.2 | 0.544827586206897 | 26 | 1 | 17.9 | 0 | 85 | 162 | 823 | 848 | KAL4421480.1 hypothetical protein ABPG75_010771 [Micractinium tetrahymenae] | diamond | 237 | 57.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 28847392 | 28847392 | PRJNA561138_P_NODE_29808_length_241_cov_0.916667_g29613_i0 | PRJNA561138 | 29808 | 241 | 0.916667 | 2.20916747 | Haematococcus lacustris | 44745 | Plants | Plants | 72.8 | 1.24e-13 | NR | GFH23684.1 | 44745 | g29613 | i0 | 100 | 0.871369294605809 | 35 | 0 | 43.6 | 0 | 14 | 118 | 159 | 193 | GFH23684.1 DNA mismatch repair protein, partial [Haematococcus lacustris] | diamond | 210 | 72.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29352862 | 29352862 | PRJNA561138_P_NODE_8769_length_425_cov_1.309659_g8574_i0 | PRJNA561138 | 8769 | 425 | 1.309659 | 5.56605075 | Haematococcus lacustris | 44745 | Plants | Plants | 159 | 4.7399999999999996e-42 | NR | KAJ9513937.1 | 44745 | g8574 | i0 | 80.8 | 0.734117647058824 | 104 | 19 | 73.4 | 1 | 312 | 1 | 580 | 682 | KAJ9513937.1 hypothetical protein QJQ45_021040 [Haematococcus lacustris] | diamond | 312 | 159 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29384398 | 29384398 | PRJNA561138_P_NODE_10369_length_399_cov_0.840491_g10174_i0 | PRJNA561138 | 10369 | 399 | 0.840491 | 3.35355909 | Haematococcus lacustris | 44745 | Plants | Plants | 82 | 2.06e-16 | NR | KAJ9522799.1 | 44745 | g10174 | i0 | 97.5 | 0.601503759398496 | 40 | 1 | 30.1 | 0 | 105 | 224 | 99 | 138 | KAJ9522799.1 hypothetical protein QJQ45_019787, partial [Haematococcus lacustris] | diamond | 240 | 82 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29384404 | 29384404 | PRJNA561138_P_NODE_28929_length_243_cov_0.905882_g28734_i0 | PRJNA561138 | 28929 | 243 | 0.905882 | 2.20129326 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 50.8 | 5.25e-5 | NR | KAL4458444.1 | 2728915 | g28734 | i0 | 89.3 | 0.691358024691358 | 28 | 3 | 34.6 | 0 | 86 | 3 | 1084 | 1111 | KAL4458444.1 hypothetical protein ABPG75_013309 [Micractinium tetrahymenae] | diamond | 168 | 50.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 29542073 | 29542073 | PRJNA561138_P_NODE_24710_length_251_cov_0.865169_g24515_i0 | PRJNA561138 | 24710 | 251 | 0.865169 | 2.17157419 | Micractinium conductrix | 554055 | Plants | Plants | 119 | 5.830000000000001e-29 | NR | PSC68936.1 | 554055 | g24515 | i0 | 72 | 3.9203187250996 | 82 | 23 | 98 | 0 | 246 | 1 | 531 | 612 | PSC68936.1 reverse transcriptase [Micractinium conductrix] | diamond | 984 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 29668141 | 29668141 | PRJNA561138_P_NODE_19050_length_298_cov_0.991111_g18855_i0 | PRJNA561138 | 19050 | 298 | 0.991111 | 2.95351078 | Haematococcus lacustris | 44745 | Plants | Plants | 181 | 1.29e-50 | NR | KAJ9527530.1 | 44745 | g18855 | i0 | 95.9 | 3.94630872483221 | 98 | 4 | 98.7 | 0 | 296 | 3 | 3443 | 3540 | KAJ9527530.1 hypothetical protein QJQ45_025738, partial [Haematococcus lacustris] | diamond | 1176 | 181 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29921311 | 29921311 | PRJNA561138_P_NODE_28111_length_245_cov_0.895349_g27916_i0 | PRJNA561138 | 28111 | 245 | 0.895349 | 2.19360505 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 131 | 1.76e-33 | NR | KAL4440103.1 | 2728915 | g27916 | i0 | 85.3 | 3.6734693877551 | 75 | 11 | 91.8 | 0 | 226 | 2 | 374 | 448 | KAL4440103.1 hypothetical protein ABPG75_003104 [Micractinium tetrahymenae] | diamond | 900 | 131 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 30047301 | 30047301 | PRJNA561138_P_NODE_22111_length_272_cov_0.929648_g21916_i0 | PRJNA561138 | 22111 | 272 | 0.929648 | 2.52864256 | Haematococcus lacustris | 44745 | Plants | Plants | 106 | 2.5299999999999998e-24 | NR | KAJ9531641.1 | 44745 | g21916 | i0 | 81.2 | 3.04411764705882 | 69 | 13 | 76.1 | 0 | 226 | 20 | 1923 | 1991 | KAJ9531641.1 hypothetical protein QJQ45_021761 [Haematococcus lacustris] | diamond | 828 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 30395440 | 30395440 | PRJNA561138_P_NODE_12173_length_373_cov_1.026667_g11978_i0 | PRJNA561138 | 12173 | 373 | 1.026667 | 3.82946791 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 95.1 | 6.93e-20 | NR | KAL4441458.1 | 554058 | g11978 | i0 | 54.1 | 0.892761394101877 | 111 | 33 | 74.8 | 3 | 92 | 370 | 279 | 389 | KAL4441458.1 hypothetical protein ABPG77_001962 [Micractinium sp. CCAP 211/92] | diamond | 333 | 95.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 31216109 | 31216109 | PRJNA561138_P_NODE_28635_length_244_cov_0.777778_g28440_i0 | PRJNA561138 | 28635 | 244 | 0.777778 | 1.89777832 | Haematococcus lacustris | 44745 | Plants | Plants | 157 | 2.5299999999999993e-42 | NR | KAJ9514942.1 | 44745 | g28440 | i0 | 97.5 | 32.4344262295082 | 79 | 2 | 97.1 | 0 | 242 | 6 | 936 | 1014 | KAJ9514942.1 hypothetical protein QJQ45_002768 [Haematococcus lacustris] | diamond | 7914 | 157 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31279685 | 31279685 | PRJNA561138_P_NODE_12795_length_365_cov_1.195205_g12600_i0 | PRJNA561138 | 12795 | 365 | 1.195205 | 4.36249825 | Haematococcus lacustris | 44745 | Plants | Plants | 56.6 | 1.14e-7 | NR | KAJ9516008.1 | 44745 | g12600 | i0 | 77.1 | 0.287671232876712 | 35 | 7 | 28.8 | 1 | 329 | 225 | 52 | 85 | KAJ9516008.1 hypothetical protein QJQ45_016814, partial [Haematococcus lacustris] | diamond | 105 | 56.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31975647 | 31975647 | PRJNA561138_P_NODE_28738_length_243_cov_0.976471_g28543_i0 | PRJNA561138 | 28738 | 243 | 0.976471 | 2.37282453 | Haematococcus lacustris | 44745 | Plants | Plants | 164 | 8.919999999999998e-47 | NR | KAJ9531330.1 | 44745 | g28543 | i0 | 100 | 17.0864197530864 | 73 | 0 | 90.1 | 0 | 241 | 23 | 391 | 463 | KAJ9531330.1 hypothetical protein QJQ45_006781 [Haematococcus lacustris] | diamond | 4152 | 164 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 32576966 | 32576966 | PRJNA561138_P_NODE_20319_length_287_cov_0.925234_g20124_i0 | PRJNA561138 | 20319 | 287 | 0.925234 | 2.65542158 | Chlorella vulgaris | 3077 | Plants | Plants | 145 | 3.93e-38 | NR | KAL4853269.1 | 3077 | g20124 | i0 | 74.5 | 3.9198606271777 | 94 | 24 | 98.3 | 0 | 286 | 5 | 403 | 496 | KAL4853269.1 LINE-1 retrotransposable element ORF2 protein [Chlorella vulgaris] | diamond | 1125 | 145 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;