contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7608487 | 7608487 | PRJNA839281_S_NODE_7126_length_303_cov_1.996063_g6857_i0 | PRJNA839281 | 7126 | 303 | 1.996063 | 6.04807089 | Eukaryota | 2759 | Plants | Plants | 152 | 4.72e-45 | NR | KAK9788151.1 | 706552 | g6857 | i0 | 71.4 | 10.2871287128713 | 98 | 28 | 97 | 0 | 294 | 1 | 1 | 98 | KAK9788151.1 hypothetical protein WJX73_007414 [Symbiochloris irregularis] | diamond | 3117 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 14857543 | 14857543 | PRJNA839281_S_NODE_18252_length_193_cov_1.062500_g17983_i0 | PRJNA839281 | 18252 | 193 | 1.0625 | 2.050625 | Chlorellales | 35460 | Plants | Plants | 112 | 3.06e-30 | NR | XP_005645730.1 | 574566 | g17983 | i0 | 83.3 | 20.5336787564767 | 60 | 10 | 93.3 | 0 | 193 | 14 | 58 | 117 | XP_005645730.1 ribosomal protein S1 [Coccomyxa subellipsoidea C-169] | diamond | 3963 | 112 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 21231964 | 21231964 | PRJNA839281_S_NODE_4617_length_430_cov_2.026247_g4348_i0 | PRJNA839281 | 4617 | 430 | 2.026247 | 8.7128621 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 178 | 2.32e-52 | NR | GAX84818.1 | 1157962 | g4348 | i0 | 60.7 | 2.97209302325581 | 140 | 55 | 97.7 | 0 | 10 | 429 | 123 | 262 | GAX84818.1 hypothetical protein CEUSTIGMA_g12239.t1 [Chlamydomonas eustigma] | diamond | 1278 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27402424 | 27402424 | PRJNA839281_S_NODE_34783_length_162_cov_1.353982_g34514_i0 | PRJNA839281 | 34783 | 162 | 1.353982 | 2.19345084 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 56.2 | 2e-7 | NR | KAA6416439.1 | 2608996 | g34514 | i0 | 50.9 | 2.94444444444444 | 53 | 25 | 98.1 | 1 | 161 | 3 | 241 | 292 | KAA6416439.1 MAG: zinc transporter [Trebouxia sp. A1-2] | diamond | 477 | 56.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27474002 | 27474002 | PRJNA839281_S_NODE_17463_length_196_cov_2.401361_g17194_i0 | PRJNA839281 | 17463 | 196 | 2.401361 | 4.70666756 | Chlorophyceae | 3166 | Plants | Plants | 106 | 3.0200000000000003e-27 | NR | GFH31540.1 | 44745 | g17194 | i0 | 73.8 | 3.97959183673469 | 65 | 17 | 99.5 | 0 | 2 | 196 | 12 | 76 | GFH31540.1 ribosomal_S13_N domain-containing protein, partial [Haematococcus lacustris] | diamond | 780 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27655140 | 27655140 | PRJNA839281_S_NODE_25924_length_168_cov_1.285714_g25655_i0 | PRJNA839281 | 25924 | 168 | 1.285714 | 2.15999952 | Micractinium conductrix | 554055 | Plants | Plants | 42 | 0.0253 | NR | PSC70206.1 | 554055 | g25655 | i0 | 45.5 | 0.785714285714286 | 44 | 22 | 78.6 | 1 | 134 | 3 | 149 | 190 | PSC70206.1 putative E3 ubiquitin-ligase XBOS34 [Micractinium conductrix] | diamond | 132 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 28199965 | 28199965 | PRJNA839281_S_NODE_21386_length_181_cov_1.265152_g21117_i0 | PRJNA839281 | 21386 | 181 | 1.265152 | 2.28992512 | Eukaryota | 2759 | Plants | Plants | 57.8 | 7.98e-8 | NR | KAK9816284.1 | 904363 | g21117 | i0 | 57.1 | 3.49723756906077 | 49 | 20 | 81.2 | 1 | 35 | 181 | 23 | 70 | KAK9816284.1 hypothetical protein WJX74_004177 [Apatococcus lobatus] | diamond | 633 | 58.2 | 0.993127147766323 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 28317973 | 28317973 | PRJNA839281_S_NODE_29406_length_165_cov_1.862069_g29137_i0 | PRJNA839281 | 29406 | 165 | 1.862069 | 3.07241385 | Chlamydomonas incerta | 51695 | Plants | Plants | 62 | 9.24e-10 | NR | KAG2444307.1 | 51695 | g29137 | i0 | 64.4 | 2.14545454545455 | 59 | 17 | 100 | 1 | 1 | 165 | 26 | 84 | KAG2444307.1 hypothetical protein HXX76_001064 [Chlamydomonas incerta] | diamond | 354 | 62 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 28381110 | 28381110 | PRJNA839281_S_NODE_17986_length_194_cov_1.400000_g17717_i0 | PRJNA839281 | 17986 | 194 | 1.4 | 2.716 | Chlorella vulgaris | 3077 | Plants | Plants | 77 | 1.55e-14 | NR | KAI3436301.1 | 3077 | g17717 | i0 | 66 | 3.8659793814433 | 50 | 17 | 77.3 | 0 | 194 | 45 | 197 | 246 | KAI3436301.1 hypothetical protein D9Q98_002354 [Chlorella vulgaris] | diamond | 750 | 77 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 28570504 | 28570504 | PRJNA839281_S_NODE_19967_length_186_cov_1.116788_g19698_i0 | PRJNA839281 | 19967 | 186 | 1.116788 | 2.07722568 | Volvox africanus | 51714 | Plants | Plants | 88.6 | 8.16e-21 | NR | GIL65113.1 | 51714 | g19698 | i0 | 69.4 | 4 | 62 | 19 | 100 | 0 | 1 | 186 | 28 | 89 | GIL65113.1 hypothetical protein Vafri_18930, partial [Volvox africanus] | diamond | 744 | 88.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 28579156 | 28579156 | PRJNA839281_S_NODE_12767_length_224_cov_1.062857_g12498_i0 | PRJNA839281 | 12767 | 224 | 1.062857 | 2.38079968 | Eukaryota | 2759 | Plants | Plants | 58.9 | 5.76e-8 | NR | KAK9809093.1 | 41462 | g12498 | i0 | 41.2 | 1.88839285714286 | 68 | 39 | 91.1 | 1 | 4 | 207 | 202 | 268 | KAK9809093.1 hypothetical protein WJX72_009300 [[Myrmecia] bisecta] | diamond | 423 | 58.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 28633975 | 28633975 | PRJNA839281_S_NODE_27707_length_166_cov_2.051282_g27438_i0 | PRJNA839281 | 27707 | 166 | 2.051282 | 3.40512812 | Edaphochlamys debaryana | 47281 | Plants | Plants | 51.6 | 9.46e-6 | NR | KAG2499376.1 | 47281 | g27438 | i0 | 49 | 0.921686746987952 | 51 | 26 | 92.2 | 0 | 161 | 9 | 456 | 506 | KAG2499376.1 hypothetical protein HYH03_002951 [Edaphochlamys debaryana] | diamond | 153 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 28799844 | 28799844 | PRJNA839281_S_NODE_19867_length_186_cov_2.080292_g19598_i0 | PRJNA839281 | 19867 | 186 | 2.080292 | 3.86934312 | Eukaryota | 2759 | Plants | Plants | 85.9 | 9.58e-18 | NR | WIA33097.1 | 3088 | g19598 | i0 | 54.1 | 4.91935483870968 | 61 | 28 | 98.4 | 0 | 185 | 3 | 228 | 288 | WIA33097.1 hypothetical protein OEZ86_006251 [Tetradesmus obliquus] | diamond | 915 | 86.3 | 0.995365005793743 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29139194 | 29139194 | PRJNA839281_S_NODE_23029_length_176_cov_1.480315_g22760_i0 | PRJNA839281 | 23029 | 176 | 1.480315 | 2.6053544 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 52 | 3.29e-6 | NR | KAI8106175.1 | 2696299 | g22760 | i0 | 57.1 | 2.0625 | 42 | 18 | 71.6 | 0 | 130 | 5 | 6 | 47 | KAI8106175.1 hypothetical protein M9435_000722 [Picochlorum sp. BPE23] | diamond | 363 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 29557683 | 29557683 | PRJNA839281_S_NODE_18970_length_190_cov_1.085106_g18701_i0 | PRJNA839281 | 18970 | 190 | 1.085106 | 2.0617014 | Chlorellaceae | 35461 | Plants | Plants | 75.1 | 6.41e-15 | NR | XP_011399790.1 | 3075 | g18701 | i0 | 64.3 | 11.7631578947368 | 56 | 20 | 88.4 | 0 | 22 | 189 | 27 | 82 | XP_011399790.1 Signal peptidase complex catalytic subunit SEC11C [Auxenochlorella protothecoides] | diamond | 2235 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30781358 | 30781358 | PRJNA839281_S_NODE_30234_length_165_cov_0.879310_g29965_i0 | PRJNA839281 | 30234 | 165 | 0.87931 | 1.4508615 | Sanguina aurantia | 2578422 | Plants | Plants | 65.1 | 1.67e-10 | NR | MEW5316769.1 | 2578422 | g29965 | i0 | 54.7 | 4.69090909090909 | 53 | 24 | 96.4 | 0 | 161 | 3 | 405 | 457 | MEW5316769.1 hypothetical protein [Sanguina aurantia] | diamond | 774 | 65.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 31318561 | 31318561 | PRJNA839281_S_NODE_39115_length_154_cov_2.076190_g38846_i0 | PRJNA839281 | 39115 | 154 | 2.07619 | 3.1973326 | Symbiochloris irregularis | 706552 | Plants | Plants | 44.7 | 0.00233 | NR | KAK9798164.1 | 706552 | g38846 | i0 | 41.3 | 1.85064935064935 | 46 | 27 | 89.6 | 0 | 138 | 1 | 108 | 153 | KAK9798164.1 hypothetical protein WJX73_003251 [Symbiochloris irregularis] | diamond | 285 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 31382002 | 31382002 | PRJNA839281_S_NODE_13696_length_217_cov_1.107143_g13427_i0 | PRJNA839281 | 13696 | 217 | 1.107143 | 2.40250031 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 71.6 | 1.76e-12 | NR | XP_011395923.1 | 3075 | g13427 | i0 | 53.4 | 1.00921658986175 | 73 | 33 | 99.5 | 1 | 216 | 1 | 634 | 706 | XP_011395923.1 Aminopeptidase N [Auxenochlorella protothecoides] | diamond | 219 | 71.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 31928054 | 31928054 | PRJNA839281_S_NODE_19997_length_186_cov_1.116788_g19728_i0 | PRJNA839281 | 19997 | 186 | 1.116788 | 2.07722568 | Eukaryota | 2759 | Plants | Plants | 70.5 | 2.86e-12 | NR | PRW45739.1 | 3076 | g19728 | i0 | 54.1 | 3.91935483870968 | 61 | 28 | 98.4 | 0 | 2 | 184 | 958 | 1018 | PRW45739.1 ATP-binding cassette superfamily [Chlorella sorokiniana] | diamond | 729 | 71.2 | 0.990168539325843 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32204403 | 32204403 | PRJNA839281_S_NODE_9018_length_265_cov_1.240741_g8749_i0 | PRJNA839281 | 9018 | 265 | 1.240741 | 3.28796365 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 89 | 5.76e-19 | NR | XP_011399144.1 | 3075 | g8749 | i0 | 53.3 | 3.04528301886792 | 90 | 40 | 99.6 | 1 | 1 | 264 | 197 | 286 | XP_011399144.1 60S ribosomal protein L5-1 [Auxenochlorella protothecoides] | diamond | 807 | 89 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 32835773 | 32835773 | PRJNA839281_S_NODE_17580_length_196_cov_1.149660_g17311_i0 | PRJNA839281 | 17580 | 196 | 1.14966 | 2.2533336 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 52.4 | 3.57e-6 | NR | XP_011400232.1 | 3075 | g17311 | i0 | 41.5 | 1.86734693877551 | 65 | 34 | 93.4 | 1 | 11 | 193 | 85 | 149 | XP_011400232.1 Heterogeneous nuclear ribonucleoprotein H [Auxenochlorella protothecoides] | diamond | 366 | 52.4 | 1 | 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);;