contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8447453 | 8447453 | PRJNA799842_P_NODE_19747_length_680_cov_4.140033_g18250_i0 | PRJNA799842 | 19747 | 680 | 4.140033 | 28.1522244 | Eukaryota | 2759 | Plants | Plants | 320 | 6.689999999999998e-99 | NR | PRW60132.1 | 3076 | g18250 | i0 | 75.9 | 36.0397058823529 | 203 | 49 | 89.6 | 0 | 665 | 57 | 1 | 203 | PRW60132.1 60S ribosomal L15 [Chlorella sorokiniana] | diamond | 24507 | 320 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 16097289 | 16097289 | PRJNA799842_P_NODE_37173_length_470_cov_1.627204_g35602_i0 | PRJNA799842 | 37173 | 470 | 1.627204 | 7.6478588 | Chlorellaceae | 35461 | Plants | Plants | 176 | 2.3699999999999998e-48 | NR | RMZ52481.1 | 3075 | g35602 | i0 | 72 | 10.0659574468085 | 157 | 42 | 98.9 | 1 | 468 | 4 | 120 | 276 | RMZ52481.1 hypothetical protein APUTEX25_003624 [Auxenochlorella protothecoides] | diamond | 4731 | 176 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18646799 | 18646799 | PRJNA799842_P_NODE_62995_length_359_cov_1.076923_g61422_i0 | PRJNA799842 | 62995 | 359 | 1.076923 | 3.86615357 | Chlorellaceae | 35461 | Plants | Plants | 198 | 1.92e-57 | NR | AKP17750.1 | 3078 | g61422 | i0 | 81.5 | 9.94428969359332 | 119 | 22 | 99.4 | 0 | 357 | 1 | 233 | 351 | AKP17750.1 heat shock protein 70 [Auxenochlorella pyrenoidosa] | diamond | 3570 | 198 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 19922172 | 19922172 | PRJNA799842_P_NODE_63516_length_357_cov_2.169014_g61943_i0 | PRJNA799842 | 63516 | 357 | 2.169014 | 7.74337998 | Coccomyxa | 41891 | Plants | Plants | 177 | 7.419999999999998e-55 | NR | CAL5219820.1 | 1274662 | g61943 | i0 | 83.3 | 8.02521008403361 | 108 | 17 | 90.8 | 1 | 325 | 2 | 31 | 137 | CAL5219820.1 g1732 [Coccomyxa viridis] | diamond | 2865 | 177 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 27054076 | 27054076 | PRJNA799842_P_NODE_161602_length_246_cov_0.890173_g160029_i0 | PRJNA799842 | 161602 | 246 | 0.890173 | 2.18982558 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 49.3 | 1.99e-4 | NR | KAG1660655.1 | 1653778 | g160029 | i0 | 55.8 | 1.13414634146341 | 43 | 19 | 52.4 | 0 | 16 | 144 | 234 | 276 | KAG1660655.1 hypothetical protein FOA52_008015 [Chlamydomonas sp. UWO 241] | diamond | 279 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 27370391 | 27370391 | PRJNA799842_P_NODE_133203_length_252_cov_1.720670_g131630_i0 | PRJNA799842 | 133203 | 252 | 1.72067 | 4.3360884 | Monoraphidium minutum | 39955 | Plants | Plants | 52 | 2.26e-5 | NR | KAI8472079.1 | 39955 | g131630 | i0 | 35.8 | 0.964285714285714 | 81 | 42 | 84.5 | 2 | 37 | 249 | 300 | 380 | KAI8472079.1 MAG: hypothetical protein J3K34DRAFT_415072 [Monoraphidium minutum] | diamond | 243 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 27442532 | 27442532 | PRJNA799842_P_NODE_88283_length_308_cov_1.638298_g86710_i0 | PRJNA799842 | 88283 | 308 | 1.638298 | 5.04595784 | Selenastraceae | 35466 | Plants | Plants | 81.3 | 2.31e-15 | NR | KAI8462996.1 | 39955 | g86710 | i0 | 57.8 | 3.7012987012987 | 64 | 26 | 61.4 | 1 | 117 | 305 | 68 | 131 | KAI8462996.1 MAG: kinase-like domain-containing protein [Monoraphidium minutum] | diamond | 1140 | 81.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 27496535 | 27496535 | PRJNA799842_P_NODE_72003_length_338_cov_0.913208_g70430_i0 | PRJNA799842 | 72003 | 338 | 0.913208 | 3.08664304 | Chlorella vulgaris | 3077 | Plants | Plants | 73.9 | 1.87e-14 | NR | KAI3425097.1 | 3077 | g70430 | i0 | 44.8 | 0.772189349112426 | 87 | 48 | 77.2 | 0 | 324 | 64 | 5 | 91 | KAI3425097.1 hypothetical protein D9Q98_008475 [Chlorella vulgaris] | diamond | 261 | 73.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 28042221 | 28042221 | PRJNA799842_P_NODE_186605_length_241_cov_0.916667_g185032_i0 | PRJNA799842 | 186605 | 241 | 0.916667 | 2.20916747 | Volvocaceae | 3065 | Plants | Plants | 114 | 8.27e-30 | NR | GLC33227.1 | 330485 | g185032 | i0 | 64.6 | 3.89626556016598 | 79 | 28 | 98.3 | 0 | 3 | 239 | 58 | 136 | GLC33227.1 hypothetical protein PLESTM_000038100 [Pleodorina starrii] | diamond | 939 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 28452773 | 28452773 | PRJNA799842_P_NODE_116506_length_271_cov_1.944444_g114933_i0 | PRJNA799842 | 116506 | 271 | 1.944444 | 5.26944324 | Chlamydomonadales | 3042 | Plants | Plants | 68.6 | 4.15e-11 | NR | KAJ9528508.1 | 44745 | g114933 | i0 | 42 | 6.53136531365314 | 88 | 49 | 97.4 | 1 | 266 | 3 | 196 | 281 | KAJ9528508.1 hypothetical protein QJQ45_020506 [Haematococcus lacustris] | diamond | 1770 | 68.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 29201538 | 29201538 | PRJNA799842_P_NODE_175769_length_243_cov_1.358824_g174196_i0 | PRJNA799842 | 175769 | 243 | 1.358824 | 3.30194232 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 55.8 | 7.02e-7 | NR | KAF6264380.1 | 2650976 | g174196 | i0 | 34.4 | 3.44444444444444 | 96 | 40 | 92.6 | 4 | 227 | 3 | 26 | 119 | KAF6264380.1 hypothetical protein COO60DRAFT_178883 [Scenedesmus sp. NREL 46B-D3] | diamond | 837 | 55.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 29557542 | 29557542 | PRJNA799842_P_NODE_102070_length_288_cov_1.432558_g100497_i0 | PRJNA799842 | 102070 | 288 | 1.432558 | 4.12576704 | Eukaryota | 2759 | Plants | Plants | 133 | 1.2899999999999998e-35 | NR | KAK2076646.1 | 3111 | g100497 | i0 | 67.4 | 11.7916666666667 | 95 | 30 | 99 | 1 | 286 | 2 | 181 | 274 | KAK2076646.1 hypothetical protein QBZ16_005406 [Prototheca wickerhamii] | diamond | 3396 | 133 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29643123 | 29643123 | PRJNA799842_P_NODE_190230_length_241_cov_0.916667_g188657_i0 | PRJNA799842 | 190230 | 241 | 0.916667 | 2.20916747 | Symbiochloris irregularis | 706552 | Plants | Plants | 89.4 | 1.46e-18 | NR | KAK9807397.1 | 706552 | g188657 | i0 | 52.9 | 5.71369294605809 | 70 | 32 | 85.9 | 1 | 207 | 1 | 192 | 261 | KAK9807397.1 hypothetical protein WJX73_000390 [Symbiochloris irregularis] | diamond | 1377 | 89.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 29674697 | 29674697 | PRJNA799842_P_NODE_62050_length_361_cov_2.024306_g60477_i0 | PRJNA799842 | 62050 | 361 | 2.024306 | 7.30774466 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 73.9 | 1.66e-12 | NR | RMZ56356.1 | 3075 | g60477 | i0 | 51.5 | 1.78670360110803 | 68 | 33 | 56.5 | 0 | 218 | 15 | 42 | 109 | RMZ56356.1 hypothetical protein APUTEX25_004713 [Auxenochlorella protothecoides] | diamond | 645 | 73.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 29706158 | 29706158 | PRJNA799842_P_NODE_145170_length_249_cov_0.875000_g143597_i0 | PRJNA799842 | 145170 | 249 | 0.875 | 2.17875 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 76.6 | 9.34e-16 | NR | KAF6265528.1 | 2650976 | g143597 | i0 | 62.3 | 0.734939759036145 | 61 | 23 | 73.5 | 0 | 3 | 185 | 62 | 122 | KAF6265528.1 hypothetical protein COO60DRAFT_1633636 [Scenedesmus sp. NREL 46B-D3] | diamond | 183 | 76.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 29959224 | 29959224 | PRJNA799842_P_NODE_172111_length_244_cov_0.900585_g170538_i0 | PRJNA799842 | 172111 | 244 | 0.900585 | 2.1974274 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 58.9 | 7.72e-8 | NR | KAF6255732.1 | 2650976 | g170538 | i0 | 42 | 8.96311475409836 | 81 | 33 | 97.1 | 2 | 241 | 5 | 125 | 193 | KAF6255732.1 inositol hexakisphosphate-domain-containing protein [Scenedesmus sp. NREL 46B-D3] | diamond | 2187 | 58.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 30347887 | 30347887 | PRJNA799842_P_NODE_117292_length_270_cov_2.497462_g115719_i0 | PRJNA799842 | 117292 | 270 | 2.497462 | 6.7431474 | Trebouxia | 13786 | Plants | Plants | 102 | 1.41e-26 | NR | KAL0020376.1 | 2905654 | g115719 | i0 | 73.5 | 2.23333333333333 | 68 | 18 | 75.6 | 0 | 234 | 31 | 1 | 68 | KAL0020376.1 hypothetical protein WJX79_009890 [Trebouxia sp. C0005] | diamond | 603 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 30370473 | 30370473 | PRJNA799842_P_NODE_85472_length_313_cov_0.962500_g83899_i0 | PRJNA799842 | 85472 | 313 | 0.9625 | 3.012625 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 96.3 | 7.68e-21 | NR | KAG7673517.1 | 1650286 | g83899 | i0 | 49 | 2.95207667731629 | 104 | 49 | 97.8 | 2 | 6 | 311 | 43 | 144 | KAG7673517.1 hypothetical protein KSW81_006722 [Chlorella desiccata (nom. nud.)] | diamond | 924 | 96.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30938879 | 30938879 | PRJNA799842_P_NODE_57174_length_376_cov_1.016502_g55601_i0 | PRJNA799842 | 57174 | 376 | 1.016502 | 3.82204752 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 45.4 | 0.0182 | NR | RMZ53626.1 | 3075 | g55601 | i0 | 32.1 | 1.29255319148936 | 81 | 49 | 61.4 | 3 | 122 | 352 | 472 | 550 | RMZ53626.1 hypothetical protein APUTEX25_003160 [Auxenochlorella protothecoides] | diamond | 486 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 32235721 | 32235721 | PRJNA799842_P_NODE_29558_length_536_cov_1.481641_g27998_i0 | PRJNA799842 | 29558 | 536 | 1.481641 | 7.94159576 | Pleodorina starrii | 330485 | Plants | Plants | 82.8 | 6.91e-16 | NR | GLC37514.1 | 330485 | g27998 | i0 | 35 | 0.766791044776119 | 137 | 87 | 75.6 | 1 | 103 | 507 | 76 | 212 | GLC37514.1 hypothetical protein PLESTM_000597400 [Pleodorina starrii] | diamond | 411 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 32267151 | 32267151 | PRJNA799842_P_NODE_113878_length_274_cov_2.104478_g112305_i0 | PRJNA799842 | 113878 | 274 | 2.104478 | 5.76626972 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 42.4 | 0.0238 | NR | XP_042926764.1 | 3055 | g112305 | i0 | 34.1 | 0.930656934306569 | 85 | 51 | 87.6 | 1 | 29 | 268 | 23 | 107 | XP_042926764.1 uncharacterized protein CHLRE_02g075000v5 [Chlamydomonas reinhardtii] | diamond | 255 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;