contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1137393" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4111834 | 4111834 | PRJNA1137393_P_NODE_60684_length_164_cov_1.530435_g60168_i0 | PRJNA1137393 | 60684 | 164 | 1.530435 | 2.5099134 | Chlorella sorokiniana | 3076 | Plants | Plants | 73.2 | 2.36e-13 | NR | PRW45196.1 | 3076 | g60168 | i0 | 67.3 | 3.80487804878049 | 52 | 15 | 95.1 | 1 | 164 | 9 | 536 | 585 | PRW45196.1 26S proteasome non-ATPase regulatory subunit 1-like protein A-like [Chlorella sorokiniana] | diamond | 624 | 73.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 5387905 | 5387905 | PRJNA1137393_P_NODE_32145_length_178_cov_1.511628_g31629_i0 | PRJNA1137393 | 32145 | 178 | 1.511628 | 2.69069784 | Trebouxia | 13786 | Plants | Plants | 113 | 3.4400000000000003e-29 | NR | KAA6424373.1 | 2608996 | g31629 | i0 | 98.3 | 2.93258426966292 | 58 | 1 | 97.8 | 0 | 176 | 3 | 98 | 155 | KAA6424373.1 MAG: major light-harvesting chlorophyll a b [Trebouxia sp. A1-2] | diamond | 522 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 7937852 | 7937852 | PRJNA1137393_P_NODE_64547_length_164_cov_0.878261_g64031_i0 | PRJNA1137393 | 64547 | 164 | 0.878261 | 1.44034804 | Coccomyxa viridis | 1274662 | Plants | Plants | 83.2 | 5.36e-17 | NR | CAL5226079.1 | 1274662 | g64031 | i0 | 96.3 | 0.98780487804878 | 54 | 2 | 98.8 | 0 | 162 | 1 | 252 | 305 | CAL5226079.1 g8894 [Coccomyxa viridis] | diamond | 162 | 83.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 26975434 | 26975434 | PRJNA1137393_P_NODE_40982_length_169_cov_0.866667_g40466_i0 | PRJNA1137393 | 40982 | 169 | 0.866667 | 1.46466723 | Coccomyxa viridis | 1274662 | Plants | Plants | 106 | 5.08e-25 | NR | CAL5224386.1 | 1274662 | g40466 | i0 | 100 | 0.994082840236686 | 56 | 0 | 99.4 | 0 | 168 | 1 | 171 | 226 | CAL5224386.1 g7065 [Coccomyxa viridis] | diamond | 168 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 28333649 | 28333649 | PRJNA1137393_P_NODE_11326_length_247_cov_1.929293_g10810_i0 | PRJNA1137393 | 11326 | 247 | 1.929293 | 4.76535371 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 71.2 | 5.45e-14 | NR | BDA48992.1 | 2315456 | g10810 | i0 | 76.6 | 0.57085020242915 | 47 | 11 | 57.1 | 0 | 243 | 103 | 43 | 89 | BDA48992.1 hypothetical protein COCOBI_13-1020 [Coccomyxa sp. Obi] | diamond | 141 | 71.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 28838765 | 28838765 | PRJNA1137393_P_NODE_45288_length_168_cov_0.873950_g44772_i0 | PRJNA1137393 | 45288 | 168 | 0.87395 | 1.468236 | Apatococcus lobatus | 904363 | Plants | Plants | 82.8 | 9.91e-17 | NR | KAK9817339.1 | 904363 | g44772 | i0 | 75.9 | 0.964285714285714 | 54 | 13 | 96.4 | 0 | 164 | 3 | 350 | 403 | KAK9817339.1 hypothetical protein WJX74_001954 [Apatococcus lobatus] | diamond | 162 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 28901821 | 28901821 | PRJNA1137393_P_NODE_34468_length_175_cov_1.301587_g33952_i0 | PRJNA1137393 | 34468 | 175 | 1.301587 | 2.27777725 | Coccomyxa viridis | 1274662 | Plants | Plants | 61.6 | 3.27e-9 | NR | CAL5218883.1 | 1274662 | g33952 | i0 | 80 | 0.685714285714286 | 40 | 6 | 65.1 | 1 | 175 | 62 | 365 | 404 | CAL5218883.1 g620 [Coccomyxa viridis] | diamond | 120 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 29375594 | 29375594 | PRJNA1137393_P_NODE_36489_length_172_cov_1.691057_g35973_i0 | PRJNA1137393 | 36489 | 172 | 1.691057 | 2.90861804 | Trebouxia sp. C | 2796353 | Plants | Plants | 49.3 | 7.05e-5 | NR | KAL3149619.1 | 3373145 | g35973 | i0 | 55.4 | 1.95348837209302 | 56 | 25 | 97.7 | 0 | 169 | 2 | 5 | 60 | KAL3149619.1 Glycosylphosphatidylinositol anchor attachment 1 protein, variant 2 [Trebouxia sp. C0010 RCD-2024] | diamond | 336 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 29901590 | 29901590 | PRJNA1137393_P_NODE_72971_length_162_cov_0.920354_g72455_i0 | PRJNA1137393 | 72971 | 162 | 0.920354 | 1.49097348 | Chlorella | 3071 | Plants | Plants | 44.3 | 0.00352 | NR | PRW45024.1 | 3076 | g72455 | i0 | 84.6 | 0.962962962962963 | 26 | 4 | 48.1 | 0 | 80 | 3 | 17 | 42 | PRW45024.1 dynamin-related GTPase isoform B [Chlorella sorokiniana] | diamond | 156 | 44.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30153935 | 30153935 | PRJNA1137393_P_NODE_12812_length_235_cov_1.118280_g12296_i0 | PRJNA1137393 | 12812 | 235 | 1.11828 | 2.627958 | Trebouxia | 13786 | Plants | Plants | 45.4 | 0.0033 | NR | KAA6424373.1 | 2608996 | g12296 | i0 | 90.9 | 0.561702127659575 | 22 | 2 | 28.1 | 0 | 234 | 169 | 227 | 248 | KAA6424373.1 MAG: major light-harvesting chlorophyll a b [Trebouxia sp. A1-2] | diamond | 132 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 30291971 | 30291971 | PRJNA1137393_P_NODE_57432_length_165_cov_0.896552_g56916_i0 | PRJNA1137393 | 57432 | 165 | 0.896552 | 1.4793108 | Trebouxia sp. C | 2796353 | Plants | Plants | 67 | 9.17e-12 | NR | KAL3137883.1 | 3373144 | g56916 | i0 | 94.4 | 0.654545454545455 | 36 | 2 | 65.5 | 0 | 165 | 58 | 90 | 125 | KAL3137883.1 hypothetical protein ABBQ38_005135 [Trebouxia sp. C0009 RCD-2024] | diamond | 108 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 30627933 | 30627933 | PRJNA1137393_P_NODE_32813_length_177_cov_1.578125_g32297_i0 | PRJNA1137393 | 32813 | 177 | 1.578125 | 2.79328125 | root | 1 | Root_unresolved | Root_unresolved | 84.3 | 5.74e-18 | NR | KAF5842489.1 | 3046 | g32297 | i0 | 77.2 | 11.6949152542373 | 57 | 12 | 96.6 | 1 | 177 | 7 | 196 | 251 | KAF5842489.1 coproporphyrinogen III oxidase [Dunaliella salina] | diamond | 2070 | 85.1 | 0.990599294947121 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 30765490 | 30765490 | PRJNA1137393_P_NODE_21334_length_198_cov_1.395973_g20818_i0 | PRJNA1137393 | 21334 | 198 | 1.395973 | 2.76402654 | Coccomyxa viridis | 1274662 | Plants | Plants | 100 | 3.03e-24 | NR | CAK0735959.1 | 1274662 | g20818 | i0 | 76.3 | 0.893939393939394 | 59 | 14 | 89.4 | 0 | 178 | 2 | 4 | 62 | CAK0735959.1 Chlorophyll a-b binding protein of LHCII type I, chloroplastic [Coccomyxa viridis] | diamond | 177 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 31133420 | 31133420 | PRJNA1137393_P_NODE_45835_length_168_cov_0.873950_g45319_i0 | PRJNA1137393 | 45835 | 168 | 0.87395 | 1.468236 | Coccomyxa | 41891 | Plants | Plants | 60.5 | 4.3e-9 | NR | CAK0779787.1 | 1274662 | g45319 | i0 | 57.8 | 2.41071428571429 | 45 | 19 | 80.4 | 0 | 32 | 166 | 173 | 217 | CAK0779787.1 hypothetical protein CVIRNUC_004852 [Coccomyxa viridis] | diamond | 405 | 60.8 | 0.995065789473684 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 31144186 | 31144186 | PRJNA1137393_P_NODE_58695_length_165_cov_0.896552_g58179_i0 | PRJNA1137393 | 58695 | 165 | 0.896552 | 1.4793108 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 51.6 | 9.47e-6 | NR | GAX73617.1 | 1157962 | g58179 | i0 | 71 | 1.12727272727273 | 31 | 9 | 56.4 | 0 | 94 | 2 | 113 | 143 | GAX73617.1 hypothetical protein CEUSTIGMA_g1068.t1 [Chlamydomonas eustigma] | diamond | 186 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 31239326 | 31239326 | PRJNA1137393_P_NODE_70715_length_162_cov_0.920354_g70199_i0 | PRJNA1137393 | 70715 | 162 | 0.920354 | 1.49097348 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 56.6 | 1.55e-7 | NR | XP_005644720.1 | 574566 | g70199 | i0 | 64.4 | 0.833333333333333 | 45 | 16 | 83.3 | 0 | 26 | 160 | 857 | 901 | XP_005644720.1 hypothetical protein COCSUDRAFT_18682, partial [Coccomyxa subellipsoidea C-169] | diamond | 135 | 56.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 31903614 | 31903614 | PRJNA1137393_P_NODE_59437_length_165_cov_0.896552_g58921_i0 | PRJNA1137393 | 59437 | 165 | 0.896552 | 1.4793108 | Trebouxia sp. C | 2796353 | Plants | Plants | 47.8 | 2.18e-4 | NR | KAL3140147.1 | 3373144 | g58921 | i0 | 72.2 | 0.654545454545455 | 36 | 5 | 56.4 | 1 | 72 | 164 | 41 | 76 | KAL3140147.1 hypothetical protein ABBQ38_004424 [Trebouxia sp. C0009 RCD-2024] | diamond | 108 | 47.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 32788394 | 32788394 | PRJNA1137393_P_NODE_27120_length_186_cov_1.350365_g26604_i0 | PRJNA1137393 | 27120 | 186 | 1.350365 | 2.5116789 | Carteria obtusa | 69402 | Plants | Plants | 99.8 | 3.0199999999999995e-23 | NR | BAC20448.1 | 69402 | g26604 | i0 | 87.8 | 1.58064516129032 | 49 | 6 | 79 | 0 | 148 | 2 | 124 | 172 | BAC20448.1 P700 chlorophyll a-apoprotein A2, partial [Carteria obtusa] | diamond | 294 | 99.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Carteria | Carteria obtusa |
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);;