contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2308995 | 2308995 | PRJNA1146029_P_NODE_9322_length_298_cov_1.711111_g9041_i0 | PRJNA1146029 | 9322 | 298 | 1.711111 | 5.09911078 | Chlorophyceae | 3166 | Plants | Plants | 80.5 | 3.69e-17 | NR | MEW5304161.1 | 2578422 | g9041 | i0 | 53.7 | 4.83221476510067 | 95 | 42 | 95.6 | 1 | 5 | 289 | 1 | 93 | MEW5304161.1 hypothetical protein [Sanguina aurantia] | diamond | 1440 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 4117183 | 4117183 | PRJNA1146029_P_NODE_2304_length_567_cov_1.558704_g2029_i0 | PRJNA1146029 | 2304 | 567 | 1.558704 | 8.83785168 | Eukaryota | 2759 | Plants | Plants | 165 | 6.19e-44 | NR | KAK9819769.1 | 41462 | g2029 | i0 | 54.9 | 14.3121693121693 | 175 | 64 | 91 | 6 | 3 | 518 | 291 | 453 | KAK9819769.1 hypothetical protein WJX72_002177 [[Myrmecia] bisecta] | diamond | 8115 | 165 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 7943148 | 7943148 | PRJNA1146029_P_NODE_15927_length_251_cov_0.865169_g15646_i0 | PRJNA1146029 | 15927 | 251 | 0.865169 | 2.17157419 | Dunaliella salina | 3046 | Plants | Plants | 149 | 3.39e-44 | NR | KAF5841112.1 | 3046 | g15646 | i0 | 91.6 | 1.9840637450199201 | 83 | 7 | 99.2 | 0 | 3 | 251 | 10 | 92 | KAF5841112.1 S15 ribosomal protein [Dunaliella salina] | diamond | 498 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 23242379 | 23242379 | PRJNA1146029_P_NODE_12739_length_273_cov_1.540000_g12458_i0 | PRJNA1146029 | 12739 | 273 | 1.54 | 4.2042 | Volvocaceae | 3065 | Plants | Plants | 79.3 | 5.43e-16 | NR | GIL45782.1 | 51714 | g12458 | i0 | 66.1 | 1.2967032967033 | 59 | 20 | 64.8 | 0 | 230 | 54 | 11 | 69 | GIL45782.1 hypothetical protein Vafri_2928 [Volvox africanus] | diamond | 354 | 79.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 27355206 | 27355206 | PRJNA1146029_P_NODE_14403_length_262_cov_0.989418_g14122_i0 | PRJNA1146029 | 14403 | 262 | 0.989418 | 2.59227516 | Coccomyxa elongata | 1965095 | Plants | Plants | 98.2 | 9.62e-22 | NR | CAL8462909.1 | 1965095 | g14122 | i0 | 85.5 | 0.709923664122137 | 62 | 9 | 71 | 0 | 261 | 76 | 248 | 309 | CAL8462909.1 g2443 [Coccomyxa elongata] | diamond | 186 | 98.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 27975432 | 27975432 | PRJNA1146029_P_NODE_18785_length_247_cov_0.885057_g18504_i0 | PRJNA1146029 | 18785 | 247 | 0.885057 | 2.18609079 | Chlorellaceae | 35461 | Plants | Plants | 106 | 4.2e-27 | NR | KAK2077587.1 | 3111 | g18504 | i0 | 57.5 | 3.89878542510121 | 80 | 34 | 97.2 | 0 | 244 | 5 | 6 | 85 | KAK2077587.1 60S ribosomal protein L21A [Prototheca wickerhamii] | diamond | 963 | 107 | 0.990654205607477 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28670202 | 28670202 | PRJNA1146029_P_NODE_10867_length_285_cov_1.452830_g10586_i0 | PRJNA1146029 | 10867 | 285 | 1.45283 | 4.1405655 | Coccomyxa | 41891 | Plants | Plants | 58.9 | 1.26e-7 | NR | CAL8466524.1 | 1965095 | g10586 | i0 | 67.6 | 0.778947368421053 | 37 | 12 | 38.9 | 0 | 174 | 284 | 441 | 477 | CAL8466524.1 g6060 [Coccomyxa elongata] | diamond | 222 | 58.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa elongata | ||
| 29407331 | 29407331 | PRJNA1146029_P_NODE_10729_length_286_cov_1.366197_g10448_i0 | PRJNA1146029 | 10729 | 286 | 1.366197 | 3.90732342 | Pleodorina starrii | 330485 | Plants | Plants | 45.4 | 0.00717 | NR | GLC40065.1 | 330485 | g10448 | i0 | 63 | 0.283216783216783 | 27 | 10 | 28.3 | 0 | 268 | 188 | 2 | 28 | GLC40065.1 hypothetical protein PLESTM_000988100 [Pleodorina starrii] | diamond | 81 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 29648505 | 29648505 | PRJNA1146029_P_NODE_4230_length_417_cov_1.308140_g3952_i0 | PRJNA1146029 | 4230 | 417 | 1.30814 | 5.4549438 | Eukaryota | 2759 | Plants | Plants | 78.6 | 2.02e-14 | NR | PRW39386.1 | 3076 | g3952 | i0 | 58.5 | 3.65467625899281 | 65 | 26 | 46 | 1 | 3 | 194 | 194 | 258 | PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana] | diamond | 1524 | 79.3 | 0.991172761664565 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 29648507 | 29648507 | PRJNA1146029_P_NODE_7790_length_322_cov_1.855422_g7511_i0 | PRJNA1146029 | 7790 | 322 | 1.855422 | 5.97445884 | Chlorophyceae | 3166 | Plants | Plants | 153 | 3.11e-41 | NR | KAJ9518649.1 | 44745 | g7511 | i0 | 71.7 | 8.86024844720497 | 106 | 30 | 98.8 | 0 | 321 | 4 | 348 | 453 | KAJ9518649.1 hypothetical protein QJQ45_018651, partial [Haematococcus lacustris] | diamond | 2853 | 153 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 30102015 | 30102015 | PRJNA1146029_P_NODE_20612_length_243_cov_1.811765_g20331_i0 | PRJNA1146029 | 20612 | 243 | 1.811765 | 4.40258895 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 152 | 6.24e-41 | NR | BDA50462.1 | 2315456 | g20331 | i0 | 95 | 6.91358024691358 | 80 | 4 | 98.8 | 0 | 2 | 241 | 363 | 442 | BDA50462.1 probable Gag-Pol polyprotein at N-terminal half [Coccomyxa sp. Obi] | diamond | 1680 | 152 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 31018490 | 31018490 | PRJNA1146029_P_NODE_14335_length_262_cov_1.629630_g14054_i0 | PRJNA1146029 | 14335 | 262 | 1.62963 | 4.2696306 | Haematococcus lacustris | 44745 | Plants | Plants | 57.4 | 3.4e-7 | NR | KAJ9525166.1 | 44745 | g14054 | i0 | 40 | 2.40458015267176 | 70 | 41 | 80.2 | 1 | 261 | 52 | 937 | 1005 | KAJ9525166.1 hypothetical protein QJQ45_020712 [Haematococcus lacustris] | diamond | 630 | 57.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 31608081 | 31608081 | PRJNA1146029_P_NODE_18056_length_248_cov_0.880000_g17775_i0 | PRJNA1146029 | 18056 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | Plants | Plants | 105 | 3.0899999999999993e-24 | NR | KAK2080915.1 | 3111 | g17775 | i0 | 64.8 | 3.61693548387097 | 71 | 25 | 85.9 | 0 | 248 | 36 | 460 | 530 | KAK2080915.1 hypothetical protein QBZ16_000769 [Prototheca wickerhamii] | diamond | 897 | 106 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 32019318 | 32019318 | PRJNA1146029_P_NODE_11658_length_280_cov_1.487923_g11377_i0 | PRJNA1146029 | 11658 | 280 | 1.487923 | 4.1661844 | Eukaryota | 2759 | Plants | Plants | 130 | 4.34e-33 | NR | KAJ9527696.1 | 44745 | g11377 | i0 | 63.7 | 10.65 | 91 | 33 | 97.5 | 0 | 278 | 6 | 210 | 300 | KAJ9527696.1 hypothetical protein QJQ45_025975 [Haematococcus lacustris] | diamond | 2982 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 32820225 | 32820225 | PRJNA1146029_P_NODE_9440_length_296_cov_2.968610_g9159_i0 | PRJNA1146029 | 9440 | 296 | 2.96861 | 8.7870856 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 44.7 | 0.0136 | NR | GMH40769.1 | 3041901 | g9159 | i0 | 42.6 | 1.43918918918919 | 47 | 26 | 47.6 | 1 | 294 | 154 | 66 | 111 | GMH40769.1 hypothetical protein BSKO_08673 [Bryopsis sp. KO-2023] | diamond | 426 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 |
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);;