contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA917598" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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' | |
| 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 | |
| 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);;