contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA695273" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15980768 | 15980768 | PRJNA695273_P_NODE_39613_length_431_cov_1.695531_g38855_i0 | PRJNA695273 | 39613 | 431 | 1.695531 | 7.30773861 | Chlorellaceae | 35461 | Plants | Plants | 170 | 4.68e-50 | NR | XP_011401579.1 | 3075 | g38855 | i0 | 84.3 | 10.7331786542923 | 102 | 16 | 71 | 0 | 431 | 126 | 148 | 249 | XP_011401579.1 putative histone H2A variant 3 [Auxenochlorella protothecoides] | diamond | 4626 | 170 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 17760815 | 17760815 | PRJNA695273_P_NODE_58434_length_357_cov_8.288732_g57676_i0 | PRJNA695273 | 58434 | 357 | 8.288732 | 29.59077324 | Eukaryota | 2759 | Plants | Plants | 94.4 | 2.92e-22 | NR | CAD7699363.1 | 121088 | g57676 | i0 | 71.6 | 6.22689075630252 | 67 | 19 | 56.3 | 0 | 28 | 228 | 1 | 67 | CAD7699363.1 unnamed protein product [Ostreobium quekettii] | diamond | 2223 | 95.1 | 0.992639327024185 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 21081495 | 21081495 | PRJNA695273_P_NODE_85657_length_298_cov_2.382222_g84899_i0 | PRJNA695273 | 85657 | 298 | 2.382222 | 7.09902156 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 112 | 8.26e-29 | NR | KDD75394.1 | 1291522 | g84899 | i0 | 57.1 | 1.71140939597315 | 84 | 36 | 84.6 | 0 | 257 | 6 | 11 | 94 | KDD75394.1 Ras family protein [Helicosporidium sp. ATCC 50920] | diamond | 510 | 112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 21584286 | 21584286 | PRJNA695273_P_NODE_132977_length_249_cov_0.875000_g132219_i0 | PRJNA695273 | 132977 | 249 | 0.875 | 2.17875 | Scenedesmaceae | 3086 | Plants | Plants | 126 | 8.769999999999998e-32 | NR | WIA38262.1 | 3088 | g132219 | i0 | 72.6 | 3.02409638554217 | 84 | 22 | 100 | 1 | 1 | 249 | 380 | 463 | WIA38262.1 hypothetical protein OEZ86_001602 [Tetradesmus obliquus] | diamond | 753 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 26650558 | 26650558 | PRJNA695273_P_NODE_34901_length_460_cov_2.881137_g34143_i0 | PRJNA695273 | 34901 | 460 | 2.881137 | 13.2532302 | Eukaryota | 2759 | Plants | Plants | 88.6 | 3.89e-17 | NR | XP_011399055.1 | 3075 | g34143 | i0 | 57.5 | 21.3391304347826 | 73 | 31 | 47.6 | 0 | 86 | 304 | 541 | 613 | XP_011399055.1 FACT complex subunit SSRP1 [Auxenochlorella protothecoides] | diamond | 9816 | 89.4 | 0.991051454138702 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 27114086 | 27114086 | PRJNA695273_P_NODE_154742_length_242_cov_2.278107_g153984_i0 | PRJNA695273 | 154742 | 242 | 2.278107 | 5.51301894 | Ostreobium quekettii | 121088 | Plants | Plants | 141 | 7.679999999999999e-37 | NR | CAD7699859.1 | 121088 | g153984 | i0 | 85 | 6.94214876033058 | 80 | 12 | 99.2 | 0 | 240 | 1 | 505 | 584 | CAD7699859.1 unnamed protein product [Ostreobium quekettii] | diamond | 1680 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 27536344 | 27536344 | PRJNA695273_P_NODE_156863_length_242_cov_0.911243_g156105_i0 | PRJNA695273 | 156863 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Plants | Plants | 82.4 | 4.52e-18 | NR | PRW20803.1 | 3076 | g156105 | i0 | 57.3 | 35.1818181818182 | 75 | 32 | 93 | 0 | 1 | 225 | 49 | 123 | PRW20803.1 60S ribosomal L35-like [Chlorella sorokiniana] | diamond | 8514 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 27556360 | 27556360 | PRJNA695273_P_NODE_100504_length_279_cov_1.495146_g99746_i0 | PRJNA695273 | 100504 | 279 | 1.495146 | 4.17145734 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 82.4 | 6.66e-16 | NR | GMH45333.1 | 3041901 | g99746 | i0 | 47.8 | 0.967741935483871 | 90 | 46 | 96.8 | 1 | 4 | 273 | 333 | 421 | GMH45333.1 hypothetical protein BSKO_13290 [Bryopsis sp. KO-2023] | diamond | 270 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 27714920 | 27714920 | PRJNA695273_P_NODE_95324_length_285_cov_1.320755_g94566_i0 | PRJNA695273 | 95324 | 285 | 1.320755 | 3.76415175 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 89 | 1.24e-18 | NR | CAG9465155.1 | 765719 | g94566 | i0 | 61.8 | 0.715789473684211 | 68 | 26 | 71.6 | 0 | 81 | 284 | 14 | 81 | CAG9465155.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 204 | 89 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 29766650 | 29766650 | PRJNA695273_P_NODE_152151_length_243_cov_0.905882_g151393_i0 | PRJNA695273 | 152151 | 243 | 0.905882 | 2.20129326 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 81.3 | 1.07e-15 | NR | KAF8061075.1 | 2742167 | g151393 | i0 | 65.2 | 1.64197530864198 | 69 | 17 | 85.2 | 1 | 243 | 37 | 169 | 230 | KAF8061075.1 PRP31 [Scenedesmus sp. PABB004] | diamond | 399 | 81.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 30304312 | 30304312 | PRJNA695273_P_NODE_134752_length_248_cov_1.760000_g133994_i0 | PRJNA695273 | 134752 | 248 | 1.76 | 4.3648 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 47.8 | 4.56e-4 | NR | KAF6263591.1 | 2650976 | g133994 | i0 | 64.5 | 0.375 | 31 | 11 | 37.5 | 0 | 219 | 127 | 2 | 32 | KAF6263591.1 hypothetical protein COO60DRAFT_1624524 [Scenedesmus sp. NREL 46B-D3] | diamond | 93 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 31484622 | 31484622 | PRJNA695273_P_NODE_106716_length_272_cov_1.547739_g105958_i0 | PRJNA695273 | 106716 | 272 | 1.547739 | 4.20985008 | Eukaryota | 2759 | Plants | Plants | 46.2 | 0.00309 | NR | KAI3438539.1 | 3077 | g105958 | i0 | 45.3 | 2.72426470588235 | 53 | 29 | 58.5 | 0 | 3 | 161 | 381 | 433 | KAI3438539.1 hypothetical protein D9Q98_000967 [Chlorella vulgaris] | diamond | 741 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 32042575 | 32042575 | PRJNA695273_P_NODE_130078_length_250_cov_0.870056_g129320_i0 | PRJNA695273 | 130078 | 250 | 0.870056 | 2.17514 | Chlorella ohadii | 2649997 | Plants | Plants | 42.7 | 0.0416 | NR | KAI7841105.1 | 2649997 | g129320 | i0 | 37.9 | 0.696 | 58 | 33 | 69.6 | 2 | 189 | 16 | 488 | 542 | KAI7841105.1 hypothetical protein COHA_005330 [Chlorella ohadii] | diamond | 174 | 42.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 32053765 | 32053765 | PRJNA695273_P_NODE_62498_length_346_cov_2.717949_g61740_i0 | PRJNA695273 | 62498 | 346 | 2.717949 | 9.40410354 | Eukaryota | 2759 | Plants | Plants | 124 | 1.15e-33 | NR | KAF5836119.1 | 3046 | g61740 | i0 | 52.4 | 10.8294797687861 | 126 | 45 | 96.2 | 2 | 345 | 13 | 25 | 150 | KAF5836119.1 NAC domain-containing protein [Dunaliella salina] | diamond | 3747 | 125 | 0.992 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 32895095 | 32895095 | PRJNA695273_P_NODE_154360_length_243_cov_0.905882_g153602_i0 | PRJNA695273 | 154360 | 243 | 0.905882 | 2.20129326 | Gonium pectorale | 33097 | Plants | Plants | 53.9 | 3.81e-6 | NR | KXZ48496.1 | 33097 | g153602 | i0 | 48.7 | 2.5679012345679 | 78 | 24 | 96.3 | 4 | 235 | 2 | 149 | 210 | KXZ48496.1 hypothetical protein GPECTOR_27g666 [Gonium pectorale] | diamond | 624 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;