contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4554848 | 4554848 | PRJNA751877_P_NODE_22124_length_251_cov_1.297753_g22002_i0 | PRJNA751877 | 22124 | 251 | 1.297753 | 3.25736003 | Chlorophyceae | 3166 | Plants | Plants | 103 | 9.06e-24 | NR | KAF5831075.1 | 3046 | g22002 | i0 | 59.5 | 4.01593625498008 | 84 | 33 | 99.2 | 1 | 251 | 3 | 76 | 159 | KAF5831075.1 hypothetical protein DUNSADRAFT_13631 [Dunaliella salina] | diamond | 1008 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 18578179 | 18578179 | PRJNA751877_P_NODE_2695_length_531_cov_4.222707_g2573_i0 | PRJNA751877 | 2695 | 531 | 4.222707 | 22.42257417 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 93.6 | 1.55e-18 | NR | KAF8054880.1 | 2742167 | g2573 | i0 | 52.8 | 3.67231638418079 | 106 | 48 | 59.9 | 1 | 518 | 201 | 1 | 104 | KAF8054880.1 ARSA1 [Scenedesmus sp. PABB004] | diamond | 1950 | 93.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 26767947 | 26767947 | PRJNA751877_P_NODE_14261_length_305_cov_1.021552_g14139_i0 | PRJNA751877 | 14261 | 305 | 1.021552 | 3.1157336 | Monoraphidium neglectum | 145388 | Plants | Plants | 100 | 3.3299999999999998e-25 | NR | XP_013902846.1 | 145388 | g14139 | i0 | 68.1 | 0.678688524590164 | 69 | 21 | 66.9 | 1 | 300 | 97 | 3 | 71 | XP_013902846.1 60S acidic ribosomal protein P1 [Monoraphidium neglectum] | diamond | 207 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 27283998 | 27283998 | PRJNA751877_P_NODE_17423_length_281_cov_1.480769_g17301_i0 | PRJNA751877 | 17423 | 281 | 1.480769 | 4.16096089 | Eukaryota | 2759 | Plants | Plants | 118 | 1.64e-28 | NR | KAL4859025.1 | 3077 | g17301 | i0 | 74.7 | 13.5160142348754 | 79 | 14 | 84.3 | 1 | 1 | 237 | 58 | 130 | KAL4859025.1 60S ribosomal protein L26-1 [Chlorella vulgaris] | diamond | 3798 | 118 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 28000563 | 28000563 | PRJNA751877_P_NODE_21965_length_252_cov_1.424581_g21843_i0 | PRJNA751877 | 21965 | 252 | 1.424581 | 3.58994412 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 65.9 | 5.48e-12 | NR | KAF8060025.1 | 2742167 | g21843 | i0 | 54.9 | 0.607142857142857 | 51 | 23 | 60.7 | 0 | 19 | 171 | 25 | 75 | KAF8060025.1 hypothetical protein HT031_004963 [Scenedesmus sp. PABB004] | diamond | 153 | 65.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 28252884 | 28252884 | PRJNA751877_P_NODE_15766_length_291_cov_1.766055_g15644_i0 | PRJNA751877 | 15766 | 291 | 1.766055 | 5.13922005 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 50.4 | 8.77e-5 | NR | KDD76215.1 | 1291522 | g15644 | i0 | 37.2 | 0.969072164948454 | 94 | 51 | 94.8 | 3 | 6 | 281 | 45 | 132 | KDD76215.1 hypothetical protein H632_c312p3 [Helicosporidium sp. ATCC 50920] | diamond | 282 | 50.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 28316148 | 28316148 | PRJNA751877_P_NODE_5546_length_420_cov_1.775216_g5424_i0 | PRJNA751877 | 5546 | 420 | 1.775216 | 7.4559072 | Raphidocelis subcapitata | 307507 | Plants | Plants | 51.6 | 3.45e-5 | NR | GBG00239.1 | 307507 | g5424 | i0 | 34.1 | 1.4 | 129 | 77 | 90 | 4 | 412 | 35 | 8 | 131 | GBG00239.1 60S ribosomal protein L28-like [Raphidocelis subcapitata] | diamond | 588 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 29052378 | 29052378 | PRJNA751877_P_NODE_21668_length_254_cov_1.657459_g21546_i0 | PRJNA751877 | 21668 | 254 | 1.657459 | 4.20994586 | Eukaryota | 2759 | Plants | Plants | 60.1 | 4.51e-9 | NR | XP_011398290.1 | 3075 | g21546 | i0 | 58.8 | 1.57086614173228 | 51 | 21 | 60.2 | 0 | 10 | 162 | 47 | 97 | XP_011398290.1 putative RNA-binding protein, partial [Auxenochlorella protothecoides] | diamond | 399 | 60.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 29452432 | 29452432 | PRJNA751877_P_NODE_24730_length_248_cov_0.880000_g24608_i0 | PRJNA751877 | 24730 | 248 | 0.88 | 2.1824 | Coccomyxa elongata | 1965095 | Plants | Plants | 150 | 7.38e-40 | NR | CAL8470668.1 | 1965095 | g24608 | i0 | 89 | 2.9758064516129 | 82 | 9 | 99.2 | 0 | 2 | 247 | 1324 | 1405 | CAL8470668.1 g10210 [Coccomyxa elongata] | diamond | 738 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 30495238 | 30495238 | PRJNA751877_P_NODE_24913_length_248_cov_0.880000_g24791_i0 | PRJNA751877 | 24913 | 248 | 0.88 | 2.1824 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 49.3 | 1.99e-4 | NR | XP_042918964.1 | 3055 | g24791 | i0 | 62.5 | 2.32258064516129 | 40 | 15 | 48.4 | 0 | 49 | 168 | 1379 | 1418 | XP_042918964.1 uncharacterized protein CHLRE_12g552851v5 [Chlamydomonas reinhardtii] | diamond | 576 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 32085798 | 32085798 | PRJNA751877_P_NODE_8218_length_370_cov_1.296296_g8096_i0 | PRJNA751877 | 8218 | 370 | 1.296296 | 4.7962952 | Eukaryota | 2759 | Plants | Plants | 152 | 5.31e-44 | NR | KAK9798542.1 | 706552 | g8096 | i0 | 63.9 | 6.91621621621622 | 122 | 43 | 98.9 | 1 | 366 | 1 | 7 | 127 | KAK9798542.1 hypothetical protein WJX73_001310 [Symbiochloris irregularis] | diamond | 2559 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 32275923 | 32275923 | PRJNA751877_P_NODE_21698_length_254_cov_1.276243_g21576_i0 | PRJNA751877 | 21698 | 254 | 1.276243 | 3.24165722 | Coccomyxa | 41891 | Plants | Plants | 50.8 | 5.96e-5 | NR | CAL5226881.1 | 1274662 | g21576 | i0 | 56.3 | 3.81496062992126 | 32 | 14 | 37.8 | 0 | 102 | 7 | 369 | 400 | CAL5226881.1 g9754 [Coccomyxa viridis] | diamond | 969 | 50.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis |
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);;