contig_metadata
20 rows where bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447832 | 447832 | PRJNA478247_P_NODE_361_length_795_cov_2.212794_g279_i0 | PRJNA478247 | 361 | 795 | 2.212794 | 17.5917123 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 121 | 4.47e-27 | NR | KAK9908763.1 | 248742 | g279 | i0 | 53.1 | 1.27924528301887 | 113 | 50 | 41.5 | 1 | 586 | 257 | 211 | 323 | KAK9908763.1 hypothetical protein WJX75_002528 [Coccomyxa subellipsoidea] | diamond | 1017 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 1722522 | 1722522 | PRJNA478247_P_NODE_162_length_1172_cov_4.269466_g119_i0 | PRJNA478247 | 162 | 1172 | 4.269466 | 50.03814152 | Eukaryota | 2759 | Plants | Plants | 381 | 5.23e-127 | NR | KAI3431832.1 | 3077 | g119 | i0 | 57.7 | 60.3993174061433 | 369 | 147 | 93.4 | 5 | 1154 | 60 | 1 | 364 | KAI3431832.1 hypothetical protein D9Q98_010585 [Chlorella vulgaris] | diamond | 70788 | 384 | 0.9921875 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 5551420 | 5551420 | PRJNA478247_P_NODE_3585_length_152_cov_1.699187_g3479_i0 | PRJNA478247 | 3585 | 152 | 1.699187 | 2.58276424 | Stichococcus bacillaris | 37433 | Plants | Plants | 248 | 1.48e-61 | NTclustered | gi|115430291|emb|AM260460.1| | 37433 | g3479 | i0 | 96.053 | 99.9736842105263 | 152 | 6 | 100 | 0 | 1 | 152 | 64 | 215 | Stichococcus bacillaris partial 26S rRNA gene, strain SAG 379-1b | blastn | 15196 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 8100855 | 8100855 | PRJNA478247_P_NODE_3247_length_165_cov_2.007353_g3141_i0 | PRJNA478247 | 3247 | 165 | 2.007353 | 3.31213245 | Eukaryota | 2759 | Plants | Plants | 100 | 1.07e-24 | NR | GHP08779.1 | 41880 | g3141 | i0 | 83.6 | 7 | 55 | 9 | 100 | 0 | 1 | 165 | 45 | 99 | GHP08779.1 Rab-7 protein [Pycnococcus provasolii] | diamond | 1155 | 101 | 0.99009900990099 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pycnococcaceae | Pycnococcus | Pycnococcus provasolii | ||
| 9375589 | 9375589 | PRJNA478247_P_NODE_868_length_446_cov_2.527578_g763_i0 | PRJNA478247 | 868 | 446 | 2.527578 | 11.27299788 | Haematococcus lacustris | 44745 | Plants | Plants | 186 | 5.4199999999999984e-55 | NR | GFH24957.1 | 44745 | g763 | i0 | 61.2 | 7.88340807174888 | 147 | 57 | 98.9 | 0 | 445 | 5 | 162 | 308 | GFH24957.1 cyclin N-terminal domain-containing protein [Haematococcus lacustris] | diamond | 3516 | 186 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 16399726 | 16399726 | PRJNA478247_P_NODE_2533_length_206_cov_2.457627_g2427_i0 | PRJNA478247 | 2533 | 206 | 2.457627 | 5.06271162 | Eukaryota | 2759 | Plants | Plants | 259 | 9.89e-65 | NTclustered | gi|2082262574|ref|XM_001694020.2| | 3055 | g2427 | i0 | 89.32 | 99.0291262135922 | 206 | 22 | 100 | 0 | 1 | 206 | 304 | 509 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g542250v5), mRNA | blastn | 20400 | 261 | 0.992337164750958 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17025038 | 17025038 | PRJNA478247_P_NODE_1134_length_373_cov_4.517442_g1028_i0 | PRJNA478247 | 1134 | 373 | 4.517442 | 16.85005866 | Valonia macrophysa | 432605 | Plants | Plants | 449 | 1.0799999999999998e-121 | NTclustered | gi|969822378|gb|KT950956.1| | 432605 | g1028 | i0 | 89.548 | 93.0160857908847 | 354 | 37 | 95 | 0 | 20 | 373 | 12 | 365 | Valonia macrophysa isolate 1528 actin gene, partial cds | blastn | 34695 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Cladophorales | Valoniaceae | Valonia | Valonia macrophysa | |
| 22774131 | 22774131 | PRJNA478247_P_NODE_2818_length_189_cov_1.618750_g2712_i0 | PRJNA478247 | 2818 | 189 | 1.61875 | 3.0594375 | Eukaryota | 2759 | Plants | Plants | 104 | 4.41e-18 | NTclustered | gi|2082259818|ref|XM_001690833.2| | 3055 | g2712 | i0 | 85.714 | 1.92063492063492 | 98 | 14 | 52 | 0 | 60 | 157 | 197 | 100 | Chlamydomonas reinhardtii ribosomal protein L18 (CHLRE_12g512600v5), mRNA | blastn | 363 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 27060755 | 27060755 | PRJNA478247_P_NODE_2082_length_239_cov_2.600000_g1976_i0 | PRJNA478247 | 2082 | 239 | 2.6 | 6.214 | Eukaryota | 2759 | Plants | Plants | 102 | 9.07e-27 | NR | KAL0020376.1 | 2905654 | g1976 | i0 | 70.4 | 5.52301255230125 | 71 | 21 | 89.1 | 0 | 16 | 228 | 1 | 71 | KAL0020376.1 hypothetical protein WJX79_009890 [Trebouxia sp. C0005] | diamond | 1320 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 27139085 | 27139085 | PRJNA478247_P_NODE_1762_length_270_cov_2.597510_g1656_i0 | PRJNA478247 | 1762 | 270 | 2.59751 | 7.013277 | Symbiochloris irregularis | 706552 | Plants | Plants | 99.4 | 6.04e-25 | NR | KAK9808445.1 | 706552 | g1656 | i0 | 64.1 | 1.71111111111111 | 78 | 26 | 85.6 | 2 | 268 | 38 | 17 | 93 | KAK9808445.1 hypothetical protein WJX73_006634 [Symbiochloris irregularis] | diamond | 462 | 99.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 27676762 | 27676762 | PRJNA478247_P_NODE_3044_length_175_cov_2.445205_g2938_i0 | PRJNA478247 | 3044 | 175 | 2.445205 | 4.27910875 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 44.7 | 0.0032 | NR | KAK3244880.1 | 36881 | g2938 | i0 | 43.2 | 0.754285714285714 | 44 | 23 | 75.4 | 1 | 40 | 171 | 281 | 322 | KAK3244880.1 hypothetical protein CYMTET_45530 [Cymbomonas tetramitiformis] | diamond | 132 | 44.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 28718541 | 28718541 | PRJNA478247_P_NODE_807_length_467_cov_2.184932_g702_i0 | PRJNA478247 | 807 | 467 | 2.184932 | 10.20363244 | Tetradesmus obliquus | 3088 | Plants | Plants | 151 | 2.41e-39 | NR | WIA13321.1 | 3088 | g702 | i0 | 54.7 | 1.81798715203426 | 139 | 62 | 89.3 | 1 | 433 | 17 | 469 | 606 | WIA13321.1 hypothetical protein OEZ85_006904 [Tetradesmus obliquus] | diamond | 849 | 151 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29902950 | 29902950 | PRJNA478247_P_NODE_371_length_783_cov_5.588859_g287_i0 | PRJNA478247 | 371 | 783 | 5.588859 | 43.76076597 | Eukaryota | 2759 | Plants | Plants | 273 | 8.369999999999999e-89 | NR | KAK2080821.1 | 3111 | g287 | i0 | 59.7 | 11.2222222222222 | 236 | 94 | 90.4 | 1 | 42 | 749 | 3 | 237 | KAK2080821.1 60S ribosomal protein L7B [Prototheca wickerhamii] | diamond | 8787 | 275 | 0.992727272727273 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29997742 | 29997742 | PRJNA478247_P_NODE_2231_length_227_cov_1.570707_g2125_i0 | PRJNA478247 | 2231 | 227 | 1.570707 | 3.56550489 | Eukaryota | 2759 | Plants | Plants | 70.9 | 3.77e-12 | NR | KAJ9533139.1 | 44745 | g2125 | i0 | 57.4 | 23.511013215859 | 68 | 21 | 79.3 | 1 | 180 | 1 | 4 | 71 | KAJ9533139.1 hypothetical protein QJQ45_018232 [Haematococcus lacustris] | diamond | 5337 | 71.2 | 0.995786516853933 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 30107782 | 30107782 | PRJNA478247_P_NODE_3432_length_158_cov_1.232558_g3326_i0 | PRJNA478247 | 3432 | 158 | 1.232558 | 1.94744164 | Dunaliella salina | 3046 | Plants | Plants | 43.1 | 0.00443 | NR | KAF5829452.1 | 3046 | g3326 | i0 | 58.1 | 2.86708860759494 | 31 | 13 | 58.9 | 0 | 147 | 55 | 82 | 112 | KAF5829452.1 ribosomal protein L14 component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina] | diamond | 453 | 43.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 30202423 | 30202423 | PRJNA478247_P_NODE_352_length_804_cov_3.698065_g272_i0 | PRJNA478247 | 352 | 804 | 3.698065 | 29.7324426 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 358 | 6.14e-116 | NR | KAF8059167.1 | 2742167 | g272 | i0 | 64.3 | 28.7686567164179 | 258 | 92 | 96.3 | 0 | 15 | 788 | 453 | 710 | KAF8059167.1 RPS4 [Scenedesmus sp. PABB004] | diamond | 23130 | 358 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 30882203 | 30882203 | PRJNA478247_P_NODE_514_length_631_cov_3.893688_g418_i0 | PRJNA478247 | 514 | 631 | 3.893688 | 24.56917128 | Eukaryota | 2759 | Plants | Plants | 298 | 7.8e-91 | NR | PRW60132.1 | 3076 | g418 | i0 | 73.6 | 32.4960380348653 | 201 | 52 | 95.1 | 1 | 31 | 630 | 1 | 201 | PRW60132.1 60S ribosomal L15 [Chlorella sorokiniana] | diamond | 20505 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31688090 | 31688090 | PRJNA478247_P_NODE_477_length_652_cov_2.804173_g384_i0 | PRJNA478247 | 477 | 652 | 2.804173 | 18.28320796 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 76.6 | 3.23e-12 | NR | KAK3276030.1 | 36881 | g384 | i0 | 28.1 | 1.06288343558282 | 231 | 107 | 97.1 | 8 | 8 | 640 | 236 | 427 | KAK3276030.1 hypothetical protein CYMTET_15873 [Cymbomonas tetramitiformis] | diamond | 693 | 76.6 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 31782861 | 31782861 | PRJNA478247_P_NODE_1017_length_401_cov_3.602151_g911_i0 | PRJNA478247 | 1017 | 401 | 3.602151 | 14.44462551 | Monoraphidium minutum | 39955 | Plants | Plants | 44.7 | 0.00914 | NR | KAI8470570.1 | 39955 | g911 | i0 | 58.3 | 0.269326683291771 | 36 | 15 | 26.9 | 0 | 272 | 165 | 2 | 37 | KAI8470570.1 MAG: hypothetical protein J3K34DRAFT_468978 [Monoraphidium minutum] | diamond | 108 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 32731523 | 32731523 | PRJNA478247_P_NODE_100_length_1455_cov_4.359748_g66_i0 | PRJNA478247 | 100 | 1455 | 4.359748 | 63.4343334 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 81.3 | 2.68e-12 | NR | KAL4435574.1 | 554058 | g66 | i0 | 28.6 | 1.68659793814433 | 262 | 141 | 49.9 | 9 | 1416 | 691 | 246 | 481 | KAL4435574.1 hypothetical protein ABPG77_002537 [Micractinium sp. CCAP 211/92] | diamond | 2454 | 81.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 |
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);;