contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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);;