contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8296325 | 8296325 | PRJNA674048_P_NODE_10247_length_294_cov_1.636735_g10044_i0 | PRJNA674048 | 10247 | 294 | 1.636735 | 4.8120009 | Eukaryota | 2759 | Plants | Plants | 178 | 8.979999999999999e-52 | NR | BAK23239.1 | 940905 | g10044 | i0 | 83.7 | 24 | 98 | 16 | 100 | 0 | 1 | 294 | 188 | 285 | BAK23239.1 eukaryotic translation elongation factor 1 alpha [Boodlea coacta] | diamond | 7056 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Boodleaceae | Boodlea | Boodlea coacta | |
| 9571629 | 9571629 | PRJNA674048_P_NODE_2648_length_705_cov_2.557927_g2487_i0 | PRJNA674048 | 2648 | 705 | 2.557927 | 18.03338535 | Chlorophyta | 3041 | Plants | Plants | 350 | 1.4899999999999999e-115 | NR | YP_009646614.1 | 88271 | g2487 | i0 | 69.7 | 16.9659574468085 | 234 | 67 | 99.6 | 1 | 703 | 2 | 293 | 522 | YP_009646614.1 cytochrome c oxidase subunit 1 [Picocystis salinarum] | diamond | 11961 | 350 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Picocystophyceae | Picocystales | Picocystaceae | Picocystis | Picocystis salinarum | ||
| 17221079 | 17221079 | PRJNA674048_P_NODE_13974_length_241_cov_1.968750_g13771_i0 | PRJNA674048 | 13974 | 241 | 1.96875 | 4.7446875 | Sphaeropleales | 35491 | Plants | Plants | 137 | 4.59e-40 | NR | XP_013890906.1 | 145388 | g13771 | i0 | 83.3 | 6.79668049792531 | 78 | 13 | 97.1 | 0 | 239 | 6 | 6 | 83 | XP_013890906.1 40S ribosomal protein S4-C [Monoraphidium neglectum] | diamond | 1638 | 138 | 0.992753623188406 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 19770062 | 19770062 | PRJNA674048_P_NODE_3996_length_546_cov_2.022133_g3799_i0 | PRJNA674048 | 3996 | 546 | 2.022133 | 11.04084618 | Eukaryota | 2759 | Plants | Plants | 284 | 4.2299999999999997e-94 | NR | XP_001693710.1 | 3055 | g3799 | i0 | 74 | 8.93956043956044 | 181 | 47 | 99.5 | 0 | 544 | 2 | 29 | 209 | XP_001693710.1 ribosomal protein S3a [Chlamydomonas reinhardtii] | diamond | 4881 | 285 | 0.996491228070175 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24869240 | 24869240 | PRJNA674048_P_NODE_16480_length_219_cov_2.317647_g16277_i0 | PRJNA674048 | 16480 | 219 | 2.317647 | 5.07564693 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 99 | 7.46e-23 | NR | WZN61821.1 | 1461544 | g16277 | i0 | 65.6 | 2.53424657534247 | 61 | 21 | 83.6 | 0 | 12 | 194 | 258 | 318 | WZN61821.1 cathepsin B cysteine protease [Chloropicon roscoffensis] | diamond | 555 | 99 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 26796956 | 26796956 | PRJNA674048_P_NODE_18121_length_208_cov_1.635220_g17918_i0 | PRJNA674048 | 18121 | 208 | 1.63522 | 3.4012576 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 55.5 | 5.6e-7 | NR | CAG9461842.1 | 765719 | g17918 | i0 | 64.9 | 0.533653846153846 | 37 | 13 | 53.4 | 0 | 206 | 96 | 221 | 257 | CAG9461842.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 111 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 26796958 | 26796958 | PRJNA674048_P_NODE_30581_length_164_cov_1.808696_g30378_i0 | PRJNA674048 | 30581 | 164 | 1.808696 | 2.96626144 | Symbiochloris irregularis | 706552 | Plants | Plants | 58.9 | 2.46e-8 | NR | KAK9808489.1 | 706552 | g30378 | i0 | 88.2 | 0.621951219512195 | 34 | 4 | 62.2 | 0 | 3 | 104 | 43 | 76 | KAK9808489.1 hypothetical protein WJX73_000788 [Symbiochloris irregularis] | diamond | 102 | 58.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 26903985 | 26903985 | PRJNA674048_P_NODE_21861_length_188_cov_1.496403_g21658_i0 | PRJNA674048 | 21861 | 188 | 1.496403 | 2.81323764 | Eukaryota | 2759 | Plants | Plants | 46.6 | 7.98e-4 | NR | PSC69766.1 | 554055 | g21658 | i0 | 42.9 | 1.88297872340426 | 56 | 24 | 76.6 | 2 | 42 | 185 | 760 | 815 | PSC69766.1 pro convertase subtilisin kexin type 5-like [Micractinium conductrix] | diamond | 354 | 47 | 0.991489361702128 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 26986719 | 26986719 | PRJNA674048_P_NODE_29642_length_166_cov_0.888889_g29439_i0 | PRJNA674048 | 29642 | 166 | 0.888889 | 1.47555574 | Volvox africanus | 51714 | Plants | Plants | 43.9 | 0.00509 | NR | GIL49005.1 | 51714 | g29439 | i0 | 40.7 | 0.975903614457831 | 54 | 31 | 97.6 | 1 | 163 | 2 | 154 | 206 | GIL49005.1 hypothetical protein Vafri_5494, partial [Volvox africanus] | diamond | 162 | 43.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 27062047 | 27062047 | PRJNA674048_P_NODE_29302_length_166_cov_0.888889_g29099_i0 | PRJNA674048 | 29302 | 166 | 0.888889 | 1.47555574 | Eukaryota | 2759 | Plants | Plants | 89.7 | 2.9e-19 | NR | KAK2078202.1 | 3111 | g29099 | i0 | 70.9 | 9.93975903614458 | 55 | 16 | 99.4 | 0 | 165 | 1 | 43 | 97 | KAK2078202.1 Rab GDP dissociation inhibitor beta [Prototheca wickerhamii] | diamond | 1650 | 89.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 27946516 | 27946516 | PRJNA674048_P_NODE_30145_length_165_cov_0.896552_g29942_i0 | PRJNA674048 | 30145 | 165 | 0.896552 | 1.4793108 | Eukaryota | 2759 | Plants | Plants | 73.2 | 2.35e-13 | NR | GFH08902.1 | 44745 | g29942 | i0 | 68.6 | 5.27272727272727 | 51 | 16 | 92.7 | 0 | 11 | 163 | 38 | 88 | GFH08902.1 uncharacterized protein HaLaN_03944 [Haematococcus lacustris] | diamond | 870 | 73.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28250194 | 28250194 | PRJNA674048_P_NODE_6466_length_396_cov_1.927954_g6263_i0 | PRJNA674048 | 6466 | 396 | 1.927954 | 7.63469784 | Coccomyxa viridis | 1274662 | Plants | Plants | 162 | 9.56e-45 | NR | CAL5225195.1 | 1274662 | g6263 | i0 | 67 | 5.95454545454545 | 112 | 37 | 84.8 | 0 | 394 | 59 | 240 | 351 | CAL5225195.1 g7978 [Coccomyxa viridis] | diamond | 2358 | 162 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 29146681 | 29146681 | PRJNA674048_P_NODE_10889_length_283_cov_1.115385_g10686_i0 | PRJNA674048 | 10889 | 283 | 1.115385 | 3.15653955 | Chlorophyta | 3041 | Plants | Plants | 138 | 1.45e-36 | NR | KAK3250066.1 | 36881 | g10686 | i0 | 69.7 | 2.83038869257951 | 89 | 27 | 94.3 | 0 | 282 | 16 | 34 | 122 | KAK3250066.1 hypothetical protein CYMTET_40537 [Cymbomonas tetramitiformis] | diamond | 801 | 139 | 0.992805755395683 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29702350 | 29702350 | PRJNA674048_P_NODE_5410_length_448_cov_2.596491_g5207_i0 | PRJNA674048 | 5410 | 448 | 2.596491 | 11.63227968 | Dunaliella salina | 3046 | Plants | Plants | 67 | 2.64e-11 | NR | KAF5829190.1 | 3046 | g5207 | i0 | 60.8 | 1.64732142857143 | 51 | 20 | 34.2 | 0 | 444 | 292 | 48 | 98 | KAF5829190.1 component of cytosolic 80S ribosome and 40S small subunit [Dunaliella salina] | diamond | 738 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 29797310 | 29797310 | PRJNA674048_P_NODE_22831_length_184_cov_1.459259_g22628_i0 | PRJNA674048 | 22831 | 184 | 1.459259 | 2.68503656 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 92.4 | 5.4e-20 | NR | KAK3272978.1 | 36881 | g22628 | i0 | 66.7 | 0.978260869565217 | 60 | 20 | 97.8 | 0 | 2 | 181 | 530 | 589 | KAK3272978.1 hypothetical protein CYMTET_18759 [Cymbomonas tetramitiformis] | diamond | 180 | 92.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 30524077 | 30524077 | PRJNA674048_P_NODE_29513_length_166_cov_0.888889_g29310_i0 | PRJNA674048 | 29513 | 166 | 0.888889 | 1.47555574 | Chlorella sorokiniana | 3076 | Plants | Plants | 58.2 | 1.54e-8 | NR | PRW57226.1 | 3076 | g29310 | i0 | 54 | 11.2409638554217 | 50 | 23 | 90.4 | 0 | 153 | 4 | 52 | 101 | PRW57226.1 60S ribosomal L18a-2 [Chlorella sorokiniana] | diamond | 1866 | 58.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30840038 | 30840038 | PRJNA674048_P_NODE_24674_length_177_cov_1.234375_g24471_i0 | PRJNA674048 | 24674 | 177 | 1.234375 | 2.18484375 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 74.3 | 1.09e-13 | NR | WZN60194.1 | 1461544 | g24471 | i0 | 59.6 | 0.966101694915254 | 57 | 16 | 96.6 | 2 | 172 | 2 | 238 | 287 | WZN60194.1 papain cysteine proteinase [Chloropicon roscoffensis] | diamond | 171 | 74.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 31504041 | 31504041 | PRJNA674048_P_NODE_31716_length_163_cov_0.912281_g31513_i0 | PRJNA674048 | 31716 | 163 | 0.912281 | 1.48701803 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 75.9 | 2.07e-14 | NR | KAG1666165.1 | 1653778 | g31513 | i0 | 70.8 | 4.58282208588957 | 48 | 14 | 88.3 | 0 | 18 | 161 | 32 | 79 | KAG1666165.1 hypothetical protein FOA52_011577 [Chlamydomonas sp. UWO 241] | diamond | 747 | 75.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 32326810 | 32326810 | PRJNA674048_P_NODE_32559_length_162_cov_0.920354_g32356_i0 | PRJNA674048 | 32559 | 162 | 0.920354 | 1.49097348 | Micromonas commoda | 296587 | Plants | Plants | 51.2 | 3.39e-6 | NR | XP_002503077.1 | 296587 | g32356 | i0 | 47.2 | 0.981481481481482 | 53 | 25 | 98.1 | 1 | 162 | 4 | 4 | 53 | XP_002503077.1 predicted protein [Micromonas commoda] | diamond | 159 | 51.2 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda |
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);;