contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA682774" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3215416 | 3215416 | PRJNA682774_P_NODE_1003_length_432_cov_1.086351_g974_i0 | PRJNA682774 | 1003 | 432 | 1.086351 | 4.69303632 | Eukaryota | 2759 | Plants | Plants | 151 | 2.74e-43 | NR | KAG2491764.1 | 47281 | g974 | i0 | 66.4 | 8.29861111111111 | 119 | 39 | 82.6 | 1 | 2 | 358 | 75 | 192 | KAG2491764.1 hypothetical protein HYH03_009925 [Edaphochlamys debaryana] | diamond | 3585 | 152 | 0.993421052631579 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 5768322 | 5768322 | PRJNA682774_P_NODE_865_length_463_cov_1.397436_g836_i0 | PRJNA682774 | 865 | 463 | 1.397436 | 6.47012868 | Chloropicon primus | 1764295 | Plants | Plants | 200 | 7.43e-61 | NR | QDZ22777.1 | 1764295 | g836 | i0 | 59.5 | 0.958963282937365 | 148 | 57 | 94 | 2 | 463 | 29 | 172 | 319 | QDZ22777.1 cathepsin B cysteine protease [Chloropicon primus] | diamond | 444 | 200 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 8317787 | 8317787 | PRJNA682774_P_NODE_1767_length_335_cov_2.381679_g1738_i0 | PRJNA682774 | 1767 | 335 | 2.381679 | 7.97862465 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 82.4 | 1.33e-15 | NR | KAF8054880.1 | 2742167 | g1738 | i0 | 51.9 | 1.86268656716418 | 104 | 47 | 93.1 | 2 | 24 | 335 | 1 | 101 | KAF8054880.1 ARSA1 [Scenedesmus sp. PABB004] | diamond | 624 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 8317817 | 8317817 | PRJNA682774_P_NODE_4227_length_248_cov_2.142857_g4198_i0 | PRJNA682774 | 4227 | 248 | 2.142857 | 5.31428536 | Chlamydomonadales | 3042 | Plants | Plants | 148 | 3.41e-39 | NR | XP_001691785.2 | 3055 | g4198 | i0 | 84.1 | 8.89112903225806 | 82 | 13 | 99.2 | 0 | 247 | 2 | 235 | 316 | XP_001691785.2 uncharacterized protein CHLRE_17g699100v5 [Chlamydomonas reinhardtii] | diamond | 2205 | 149 | 0.993288590604027 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17752540 | 17752540 | PRJNA682774_P_NODE_2514_length_289_cov_1.407407_g2485_i0 | PRJNA682774 | 2514 | 289 | 1.407407 | 4.06740623 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 82.4 | 1.46e-17 | NR | XP_003058268.1 | 564608 | g2485 | i0 | 81.8 | 6.7681660899654 | 55 | 10 | 57.1 | 0 | 289 | 125 | 89 | 143 | XP_003058268.1 H+-or Na+-translocating f-type, v-type and A-type ATPase superfamily [Micromonas pusilla CCMP1545] | diamond | 1956 | 82.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 24126671 | 24126671 | PRJNA682774_P_NODE_1339_length_377_cov_0.921053_g1310_i0 | PRJNA682774 | 1339 | 377 | 0.921053 | 3.47236981 | Chlamydomonadales | 3042 | Plants | Plants | 140 | 1.22e-39 | NR | KAF5836517.1 | 3046 | g1310 | i0 | 80.2 | 3.68435013262599 | 116 | 23 | 92.3 | 0 | 30 | 377 | 1 | 116 | KAF5836517.1 ribosomal protein S27a component of cytosolic 80S ribosome and 40S small subunit [Dunaliella salina] | diamond | 1389 | 140 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 27303530 | 27303530 | PRJNA682774_P_NODE_4723_length_246_cov_0.901734_g4694_i0 | PRJNA682774 | 4723 | 246 | 0.901734 | 2.21826564 | Trebouxia sp. C | 2796353 | Plants | Plants | 55.5 | 1.29e-6 | NR | KAL0048818.1 | 2905655 | g4694 | i0 | 35.7 | 2.5609756097561 | 70 | 45 | 85.4 | 0 | 211 | 2 | 1719 | 1788 | KAL0048818.1 hypothetical protein WJX82_011724 [Trebouxia sp. C0006] | diamond | 630 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 27315185 | 27315185 | PRJNA682774_P_NODE_3963_length_250_cov_0.881356_g3934_i0 | PRJNA682774 | 3963 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | Plants | Plants | 52.4 | 1.66e-5 | NR | KAK9908934.1 | 248742 | g3934 | i0 | 40.5 | 2.964 | 74 | 32 | 88.8 | 1 | 234 | 13 | 314 | 375 | KAK9908934.1 hypothetical protein WJX75_004938 [Coccomyxa subellipsoidea] | diamond | 741 | 52.8 | 0.992424242424242 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27694299 | 27694299 | PRJNA682774_P_NODE_4804_length_245_cov_0.906977_g4775_i0 | PRJNA682774 | 4804 | 245 | 0.906977 | 2.22209365 | Chlamydomonadales | 3042 | Plants | Plants | 110 | 1.63e-29 | NR | XP_042927436.1 | 3055 | g4775 | i0 | 88.7 | 2.27755102040816 | 62 | 7 | 75.9 | 0 | 189 | 4 | 1 | 62 | XP_042927436.1 uncharacterized protein CHLRE_02g105950v5 [Chlamydomonas reinhardtii] | diamond | 558 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 28061168 | 28061168 | PRJNA682774_P_NODE_5205_length_243_cov_0.917647_g5176_i0 | PRJNA682774 | 5205 | 243 | 0.917647 | 2.22988221 | Micromonas commoda | 296587 | Plants | Plants | 135 | 4.52e-38 | NR | XP_002508406.1 | 296587 | g5176 | i0 | 76.3 | 1.97530864197531 | 80 | 19 | 98.8 | 0 | 242 | 3 | 30 | 109 | XP_002508406.1 peptidyl-prolyl cis-trans isomerase [Micromonas commoda] | diamond | 480 | 135 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 28136200 | 28136200 | PRJNA682774_P_NODE_245_length_872_cov_8.782228_g220_i0 | PRJNA682774 | 245 | 872 | 8.782228 | 76.58102816 | Chlamydomonas | 3052 | Plants | Plants | 58.2 | 1.48e-5 | NR | KAG2423999.1 | 51695 | g220 | i0 | 39.2 | 1.32110091743119 | 125 | 62 | 42.3 | 5 | 818 | 450 | 6 | 118 | KAG2423999.1 hypothetical protein HXX76_014825 [Chlamydomonas incerta] | diamond | 1152 | 58.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 28218884 | 28218884 | PRJNA682774_P_NODE_3686_length_252_cov_0.871508_g3657_i0 | PRJNA682774 | 3686 | 252 | 0.871508 | 2.19620016 | Pycnococcus provasolii | 41880 | Plants | Plants | 99.4 | 4.63e-22 | NR | GHP10865.1 | 41880 | g3657 | i0 | 54.3 | 1.86904761904762 | 81 | 37 | 96.4 | 0 | 248 | 6 | 335 | 415 | GHP10865.1 hypothetical protein PPROV_000959600 [Pycnococcus provasolii] | diamond | 471 | 99.4 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pycnococcaceae | Pycnococcus | Pycnococcus provasolii | ||
| 29967473 | 29967473 | PRJNA682774_P_NODE_2831_length_276_cov_1.000000_g2802_i0 | PRJNA682774 | 2831 | 276 | 1 | 2.76 | Opisthokonta | 33154 | Plants | Plants | 61.6 | 1.03e-9 | NR | GHP06741.1 | 41880 | g2802 | i0 | 83.8 | 2.01086956521739 | 37 | 6 | 40.2 | 0 | 275 | 165 | 90 | 126 | GHP06741.1 RNA binding protein snu13 [Pycnococcus provasolii] | diamond | 555 | 61.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pycnococcaceae | Pycnococcus | Pycnococcus provasolii | ||
| 30113650 | 30113650 | PRJNA682774_P_NODE_3332_length_255_cov_1.714286_g3303_i0 | PRJNA682774 | 3332 | 255 | 1.714286 | 4.3714293 | Chlorella sorokiniana | 3076 | Plants | Plants | 128 | 1.01e-33 | NR | PRW33552.1 | 3076 | g3303 | i0 | 67.8 | 2.05882352941176 | 90 | 23 | 98.8 | 1 | 255 | 4 | 226 | 315 | PRW33552.1 Fructose-1,6- cytosolic [Chlorella sorokiniana] | diamond | 525 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30156711 | 30156711 | PRJNA682774_P_NODE_4712_length_246_cov_0.901734_g4683_i0 | PRJNA682774 | 4712 | 246 | 0.901734 | 2.21826564 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.2e-5 | NR | KAI3437560.1 | 3077 | g4683 | i0 | 37 | 5.5609756097561 | 81 | 46 | 96.3 | 3 | 237 | 1 | 609 | 686 | KAI3437560.1 hypothetical protein D9Q98_000013 [Chlorella vulgaris] | diamond | 1368 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 31472774 | 31472774 | PRJNA682774_P_NODE_3856_length_251_cov_0.876404_g3827_i0 | PRJNA682774 | 3856 | 251 | 0.876404 | 2.19977404 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 125 | 5.05e-32 | NR | KAF8063068.1 | 2742167 | g3827 | i0 | 73.5 | 1.9840637450199201 | 83 | 22 | 99.2 | 0 | 2 | 250 | 327 | 409 | KAF8063068.1 hslO [Scenedesmus sp. PABB004] | diamond | 498 | 125 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 31630718 | 31630718 | PRJNA682774_P_NODE_2976_length_269_cov_1.561224_g2947_i0 | PRJNA682774 | 2976 | 269 | 1.561224 | 4.19969256 | Chloropicon roscoffensis | 1461544 | Plants | Plants | 58.5 | 1.25e-7 | NR | WZN61819.1 | 1461544 | g2947 | i0 | 37.1 | 3.08921933085502 | 89 | 46 | 89.2 | 4 | 29 | 268 | 32 | 119 | WZN61819.1 cathepsin B cysteine protease [Chloropicon roscoffensis] | diamond | 831 | 58.5 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon roscoffensis | ||
| 31705658 | 31705658 | PRJNA682774_P_NODE_5517_length_235_cov_3.080247_g5488_i0 | PRJNA682774 | 5517 | 235 | 3.080247 | 7.23858045 | Chlamydomonadales | 3042 | Plants | Plants | 105 | 3.0400000000000004e-27 | NR | GIL66009.1 | 51714 | g5488 | i0 | 78.5 | 1.6595744680851101 | 65 | 14 | 83 | 0 | 39 | 233 | 1 | 65 | GIL66009.1 hypothetical protein Vafri_19640, partial [Volvox africanus] | diamond | 390 | 106 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox africanus | |
| 32327177 | 32327177 | PRJNA682774_P_NODE_2979_length_269_cov_1.367347_g2950_i0 | PRJNA682774 | 2979 | 269 | 1.367347 | 3.67816343 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 87 | 5.92e-18 | NR | XP_003056593.1 | 564608 | g2950 | i0 | 42.7 | 1.92936802973978 | 89 | 51 | 99.3 | 0 | 268 | 2 | 175 | 263 | XP_003056593.1 uncharacterized protein MICPUCDRAFT_65131 [Micromonas pusilla CCMP1545] | diamond | 519 | 87 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 32831737 | 32831737 | PRJNA682774_P_NODE_2080_length_313_cov_0.829167_g2051_i0 | PRJNA682774 | 2080 | 313 | 0.829167 | 2.59529271 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 87.4 | 1.79e-17 | NR | KAF8054880.1 | 2742167 | g2051 | i0 | 54 | 4.62939297124601 | 100 | 43 | 95.8 | 2 | 13 | 312 | 1 | 97 | KAF8054880.1 ARSA1 [Scenedesmus sp. PABB004] | diamond | 1449 | 87.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 32906228 | 32906228 | PRJNA682774_P_NODE_5240_length_243_cov_0.917647_g5211_i0 | PRJNA682774 | 5240 | 243 | 0.917647 | 2.22988221 | Chlamydomonadales | 3042 | Plants | Plants | 67 | 1.04e-10 | NR | KXZ41737.1 | 33097 | g5211 | i0 | 64 | 4.69135802469136 | 50 | 18 | 61.7 | 0 | 241 | 92 | 536 | 585 | KXZ41737.1 BBS9 protein [Gonium pectorale] | diamond | 1140 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;