contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA917598" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2527418 | 2527418 | PRJNA917598_P_NODE_94222_length_242_cov_0.911243_g93278_i0 | PRJNA917598 | 94222 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 107 | 4.98e-26 | NR | YP_665670.1 | 31312 | g93278 | i0 | 68.8 | 19.8471074380165 | 80 | 24 | 99.2 | 1 | 241 | 2 | 131 | 209 | YP_665670.1 NADH dehydrogenase subunit 1 [Nephroselmis olivacea] | diamond | 4803 | 107 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Nephroselmidophyceae | Nephroselmidales | Nephroselmidaceae | Nephroselmis | Nephroselmis olivacea | ||
| 7274046 | 7274046 | PRJNA917598_P_NODE_34866_length_389_cov_1.275316_g33922_i0 | PRJNA917598 | 34866 | 389 | 1.275316 | 4.96097924 | Eukaryota | 2759 | Plants | Plants | 176 | 1.65e-51 | NR | KAK9809167.1 | 41462 | g33922 | i0 | 68.2 | 22.0025706940874 | 129 | 41 | 99.5 | 0 | 389 | 3 | 127 | 255 | KAK9809167.1 hypothetical protein WJX72_010554 [[Myrmecia] bisecta] | diamond | 8559 | 177 | 0.994350282485876 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 7629784 | 7629784 | PRJNA917598_P_NODE_83746_length_249_cov_0.875000_g82802_i0 | PRJNA917598 | 83746 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Plants | Plants | 64.3 | 4.63e-10 | NR | KAF5832399.1 | 3046 | g82802 | i0 | 44.6 | 3.85542168674699 | 83 | 41 | 98.8 | 2 | 246 | 1 | 49 | 127 | KAF5832399.1 hypothetical protein DUNSADRAFT_11731 [Dunaliella salina] | diamond | 960 | 64.7 | 0.993817619783617 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 9824005 | 9824005 | PRJNA917598_P_NODE_46748_length_335_cov_2.950382_g45804_i0 | PRJNA917598 | 46748 | 335 | 2.950382 | 9.8837797 | Chlorophyceae | 3166 | Plants | Plants | 85.9 | 1.23e-18 | NR | GFR49314.1 | 47775 | g45804 | i0 | 53.1 | 6.09850746268657 | 96 | 43 | 86 | 1 | 301 | 14 | 43 | 136 | GFR49314.1 hypothetical protein Agub_g11337, partial [Astrephomene gubernaculifera] | diamond | 2043 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 10180432 | 10180432 | PRJNA917598_P_NODE_96528_length_237_cov_2.048780_g95584_i0 | PRJNA917598 | 96528 | 237 | 2.04878 | 4.8556086 | Eukaryota | 2759 | Plants | Plants | 94.7 | 1.17e-20 | NR | ABQ81938.1 | 3116 | g95584 | i0 | 52.6 | 7.88607594936709 | 78 | 37 | 98.7 | 0 | 236 | 3 | 163 | 240 | ABQ81938.1 elongation factor-1 alpha-like protein, partial [Ulva intestinalis] | diamond | 1869 | 95.1 | 0.995793901156677 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva intestinalis | |
| 11099505 | 11099505 | PRJNA917598_P_NODE_41349_length_357_cov_1.369718_g40405_i0 | PRJNA917598 | 41349 | 357 | 1.369718 | 4.88989326 | Eukaryota | 2759 | Plants | Plants | 181 | 3.1499999999999988e-55 | NR | XP_011398857.1 | 3075 | g40405 | i0 | 75.4 | 111.050420168067 | 118 | 29 | 99.2 | 0 | 2 | 355 | 92 | 209 | XP_011398857.1 60S ribosomal protein L10a-3 [Auxenochlorella protothecoides] | diamond | 39645 | 181 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 11100709 | 11100709 | PRJNA917598_P_NODE_91369_length_244_cov_0.900585_g90425_i0 | PRJNA917598 | 91369 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Plants | Plants | 111 | 1.97e-26 | NR | CAA87753.1 | 3161 | g90425 | i0 | 66.7 | 42.2459016393443 | 81 | 27 | 99.6 | 0 | 243 | 1 | 3 | 83 | CAA87753.1 Cytochrome oxidase subunit I [Tetraselmis subcordiformis] | diamond | 10308 | 112 | 0.991071428571429 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorodendrophyceae | Chlorodendrales | Chlorodendraceae | Tetraselmis | Tetraselmis subcordiformis | |
| 22572410 | 22572410 | PRJNA917598_P_NODE_14958_length_609_cov_1.552239_g14024_i0 | PRJNA917598 | 14958 | 609 | 1.552239 | 9.45313551 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 204 | 1.05e-63 | NR | KAK3252504.1 | 36881 | g14024 | i0 | 66.9 | 3.4679802955665 | 151 | 46 | 72.9 | 2 | 1 | 444 | 10 | 159 | KAK3252504.1 30S ribosomal protein S11, chloroplastic [Cymbomonas tetramitiformis] | diamond | 2112 | 204 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 27561561 | 27561561 | PRJNA917598_P_NODE_95524_length_241_cov_0.916667_g94580_i0 | PRJNA917598 | 95524 | 241 | 0.916667 | 2.20916747 | [Myrmecia] bisecta | 41462 | Plants | Plants | 52.4 | 1.07e-5 | NR | KAK9817993.1 | 41462 | g94580 | i0 | 60.8 | 0.634854771784232 | 51 | 19 | 62.2 | 1 | 91 | 240 | 7 | 57 | KAK9817993.1 hypothetical protein WJX72_005455 [[Myrmecia] bisecta] | diamond | 153 | 52.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 27916208 | 27916208 | PRJNA917598_P_NODE_58605_length_295_cov_2.081081_g57661_i0 | PRJNA917598 | 58605 | 295 | 2.081081 | 6.13918895 | Chlorophyta | 3041 | Plants | Plants | 66.2 | 2.75e-10 | NR | GAX84818.1 | 1157962 | g57661 | i0 | 65.5 | 4.21016949152542 | 87 | 29 | 88.5 | 1 | 2 | 262 | 229 | 314 | GAX84818.1 hypothetical protein CEUSTIGMA_g12239.t1 [Chlamydomonas eustigma] | diamond | 1242 | 66.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28319503 | 28319503 | PRJNA917598_P_NODE_64726_length_282_cov_1.473684_g63782_i0 | PRJNA917598 | 64726 | 282 | 1.473684 | 4.15578888 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 82.8 | 1.69e-16 | NR | GFR44809.1 | 47775 | g63782 | i0 | 53.6 | 1.46808510638298 | 69 | 31 | 72.3 | 1 | 280 | 77 | 22 | 90 | GFR44809.1 hypothetical protein Agub_g6145 [Astrephomene gubernaculifera] | diamond | 414 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 28326682 | 28326682 | PRJNA917598_P_NODE_96946_length_229_cov_2.179487_g96002_i0 | PRJNA917598 | 96946 | 229 | 2.179487 | 4.99102523 | Chlorophyta | 3041 | Plants | Plants | 114 | 2.7700000000000003e-27 | NR | KAL4857675.1 | 3077 | g96002 | i0 | 68.1 | 9.43231441048035 | 72 | 23 | 94.3 | 0 | 216 | 1 | 1 | 72 | KAL4857675.1 40S ribosomal protein S6 [Chlorella vulgaris] | diamond | 2160 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 28579548 | 28579548 | PRJNA917598_P_NODE_96767_length_232_cov_2.735849_g95823_i0 | PRJNA917598 | 96767 | 232 | 2.735849 | 6.34716968 | Eukaryota | 2759 | Plants | Plants | 73.2 | 1.92e-14 | NR | XP_011400384.1 | 3075 | g95823 | i0 | 52.2 | 8.04310344827586 | 67 | 32 | 86.6 | 0 | 203 | 3 | 13 | 79 | XP_011400384.1 60S ribosomal protein L22-2 [Auxenochlorella protothecoides] | diamond | 1866 | 73.9 | 0.990527740189445 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 28793031 | 28793031 | PRJNA917598_P_NODE_93347_length_242_cov_1.822485_g92403_i0 | PRJNA917598 | 93347 | 242 | 1.822485 | 4.4104137 | Volvox reticuliferus | 1737510 | Plants | Plants | 53.1 | 1.06e-6 | NR | GIL81802.1 | 1737510 | g92403 | i0 | 47.8 | 1.73553719008264 | 46 | 24 | 57 | 0 | 3 | 140 | 69 | 114 | GIL81802.1 hypothetical protein Vretifemale_10800 [Volvox reticuliferus] | diamond | 420 | 53.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 29393173 | 29393173 | PRJNA917598_P_NODE_55649_length_305_cov_1.327586_g54705_i0 | PRJNA917598 | 55649 | 305 | 1.327586 | 4.0491373 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 113 | 7.3e-29 | NR | XP_003056914.1 | 564608 | g54705 | i0 | 64.3 | 1.92786885245902 | 98 | 34 | 96.4 | 1 | 303 | 10 | 59 | 155 | XP_003056914.1 uncharacterized protein MICPUCDRAFT_62462 [Micromonas pusilla CCMP1545] | diamond | 588 | 113 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 29613733 | 29613733 | PRJNA917598_P_NODE_82870_length_249_cov_0.875000_g81926_i0 | PRJNA917598 | 82870 | 249 | 0.875 | 2.17875 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 107 | 9.78e-25 | NR | KAG7669235.1 | 1650286 | g81926 | i0 | 64.6 | 2.96385542168675 | 82 | 29 | 98.8 | 0 | 246 | 1 | 165 | 246 | KAG7669235.1 hypothetical protein KSW81_007394 [Chlorella desiccata (nom. nud.)] | diamond | 738 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 29810700 | 29810700 | PRJNA917598_P_NODE_83011_length_249_cov_0.875000_g82067_i0 | PRJNA917598 | 83011 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Plants | Plants | 53.5 | 1.27e-6 | NR | OUS49676.1 | 70448 | g82067 | i0 | 46.3 | 6.60240963855422 | 54 | 29 | 65.1 | 0 | 3 | 164 | 82 | 135 | OUS49676.1 putative 40S ribosomal protein S17 [Ostreococcus tauri] | diamond | 1644 | 53.9 | 0.992578849721707 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 30253336 | 30253336 | PRJNA917598_P_NODE_34112_length_393_cov_1.993750_g33168_i0 | PRJNA917598 | 34112 | 393 | 1.99375 | 7.8354375 | Eukaryota | 2759 | Plants | Plants | 129 | 4.38e-36 | NR | KAK2079597.1 | 3111 | g33168 | i0 | 66 | 10.763358778626 | 94 | 32 | 71.8 | 0 | 1 | 282 | 15 | 108 | KAK2079597.1 60S ribosomal protein L35a-3 [Prototheca wickerhamii] | diamond | 4230 | 130 | 0.992307692307692 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 31864975 | 31864975 | PRJNA917598_P_NODE_85557_length_247_cov_1.614943_g84613_i0 | PRJNA917598 | 85557 | 247 | 1.614943 | 3.98890921 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 1.09e-5 | NR | PNH01224.1 | 47790 | g84613 | i0 | 55 | 4.46963562753036 | 40 | 18 | 48.6 | 0 | 246 | 127 | 67 | 106 | PNH01224.1 Peptidyl-prolyl cis-trans isomerase [Tetrabaena socialis] | diamond | 1104 | 50.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 32016063 | 32016063 | PRJNA917598_P_NODE_67318_length_277_cov_1.627451_g66374_i0 | PRJNA917598 | 67318 | 277 | 1.627451 | 4.50803927 | Ostreococcus lucimarinus CCE99 | 242159 | Plants | Plants | 144 | 5.32e-38 | NR | XP_001421094.1 | 436017 | g66374 | i0 | 74.7 | 0.985559566787004 | 91 | 23 | 98.6 | 0 | 274 | 2 | 177 | 267 | XP_001421094.1 predicted protein [Ostreococcus lucimarinus CCE9901] | diamond | 273 | 144 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus sp. 'lucimarinus' | ||
| 32174541 | 32174541 | PRJNA917598_P_NODE_93078_length_243_cov_0.905882_g92134_i0 | PRJNA917598 | 93078 | 243 | 0.905882 | 2.20129326 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 108 | 2.57e-25 | NR | KAG1675970.1 | 1653778 | g92134 | i0 | 67.5 | 1.97530864197531 | 80 | 26 | 98.8 | 0 | 242 | 3 | 1053 | 1132 | KAG1675970.1 hypothetical protein FOA52_014214 [Chlamydomonas sp. UWO 241] | diamond | 480 | 108 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 |
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);;