contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_kingdom = "Viridiplantae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365756 | 365756 | PRJNA188516_P_NODE_1821_length_260_cov_0.966825_g1771_i0 | PRJNA188516 | 1821 | 260 | 0.966825 | 2.513745 | Eukaryota | 2759 | Plants | Plants | 142 | 2.17e-41 | NR | CAM6005785.1 | 128184 | g1771 | i0 | 76.7 | 2.96538461538462 | 86 | 20 | 99.2 | 0 | 1 | 258 | 49 | 134 | CAM6005785.1 unnamed protein product [Sphagnum balticum] | diamond | 771 | 142 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 1055229 | 1055229 | PRJNA188516_P_NODE_761_length_446_cov_9.302267_g711_i0 | PRJNA188516 | 761 | 446 | 9.302267 | 41.48811082 | Juncus effusus | 13579 | Plants | Plants | 153 | 9e-43 | NR | KAJ3679406.1 | 13579 | g711 | i0 | 65.9 | 3.40358744394619 | 126 | 43 | 84.8 | 0 | 442 | 65 | 119 | 244 | KAJ3679406.1 hypothetical protein LUZ60_017417 [Juncus effusus] | diamond | 1518 | 153 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 20767303 | 20767303 | PRJNA188516_P_NODE_1697_length_272_cov_1.632287_g1647_i0 | PRJNA188516 | 1697 | 272 | 1.632287 | 4.43982064 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 132 | 5.74e-36 | NR | XP_005643653.1 | 574566 | g1647 | i0 | 69.7 | 4.90808823529412 | 89 | 27 | 98.2 | 0 | 5 | 271 | 106 | 194 | XP_005643653.1 60S ribosomal protein L7 [Coccomyxa subellipsoidea C-169] | diamond | 1335 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24592032 | 24592032 | PRJNA188516_P_NODE_1740_length_268_cov_1.159817_g1690_i0 | PRJNA188516 | 1740 | 268 | 1.159817 | 3.10830956 | Eukaryota | 2759 | Plants | Plants | 131 | 5.16e-36 | NR | CAC27136.1 | 3329 | g1690 | i0 | 70.5 | 330.033582089552 | 88 | 26 | 98.5 | 0 | 5 | 268 | 45 | 132 | CAC27136.1 40S ribosomal protein S2 [Picea abies] | diamond | 88449 | 132 | 0.992424242424242 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea abies | |
| 27136715 | 27136715 | PRJNA188516_P_NODE_2462_length_219_cov_1.011765_g2412_i0 | PRJNA188516 | 2462 | 219 | 1.011765 | 2.21576535 | Salvia splendens | 180675 | Plants | Plants | 63.2 | 1.65e-9 | NR | KAG6408789.1 | 180675 | g2412 | i0 | 57.4 | 1.73972602739726 | 61 | 25 | 82.2 | 1 | 217 | 38 | 38 | 98 | KAG6408789.1 hypothetical protein SASPL_131812 [Salvia splendens] | diamond | 381 | 63.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Lamiaceae | Salvia | Salvia splendens | |
| 27344813 | 27344813 | PRJNA188516_P_NODE_6083_length_162_cov_0.920354_g6033_i0 | PRJNA188516 | 6083 | 162 | 0.920354 | 1.49097348 | Eukaryota | 2759 | Plants | Plants | 75.9 | 2.32e-14 | NR | XP_020100862.1 | 4615 | g6033 | i0 | 63.5 | 4.85185185185185 | 52 | 19 | 96.3 | 0 | 4 | 159 | 298 | 349 | XP_020100862.1 DDB1- and CUL4-associated factor 13 isoform X2 [Ananas comosus] | diamond | 786 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 27881378 | 27881378 | PRJNA188516_P_NODE_4945_length_166_cov_0.888889_g4895_i0 | PRJNA188516 | 4945 | 166 | 0.888889 | 1.47555574 | Streptophyta | 35493 | Plants | Plants | 86.3 | 1.57e-18 | NR | KAG0562162.1 | 3225 | g4895 | i0 | 74.1 | 9.84939759036145 | 54 | 14 | 97.6 | 0 | 165 | 4 | 126 | 179 | KAG0562162.1 hypothetical protein KC19_9G122700 [Ceratodon purpureus] | diamond | 1635 | 87 | 0.991954022988506 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 28197013 | 28197013 | PRJNA188516_P_NODE_3506_length_181_cov_1.181818_g3456_i0 | PRJNA188516 | 3506 | 181 | 1.181818 | 2.13909058 | Eukaryota | 2759 | Plants | Plants | 51.6 | 7.49e-6 | NR | WIA28302.1 | 3088 | g3456 | i0 | 66.7 | 8.13812154696133 | 36 | 12 | 59.7 | 0 | 3 | 110 | 86 | 121 | WIA28302.1 hypothetical protein OEZ86_010854 [Tetradesmus obliquus] | diamond | 1473 | 52 | 0.992307692307692 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28432016 | 28432016 | PRJNA188516_P_NODE_5786_length_163_cov_0.912281_g5736_i0 | PRJNA188516 | 5786 | 163 | 0.912281 | 1.48701803 | Ostreococcus tauri | 70448 | Plants | Plants | 73.2 | 2.24e-13 | NR | XP_003079274.2 | 70448 | g5736 | i0 | 61.1 | 1.98773006134969 | 54 | 20 | 99.4 | 1 | 2 | 163 | 51 | 103 | XP_003079274.2 Citrate synthase active site, partial [Ostreococcus tauri] | diamond | 324 | 73.2 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Ostreococcus | Ostreococcus tauri | ||
| 28575997 | 28575997 | PRJNA188516_P_NODE_5867_length_163_cov_0.877193_g5817_i0 | PRJNA188516 | 5867 | 163 | 0.877193 | 1.42982459 | root | 1 | Root_unresolved | Root_unresolved | 82 | 1.73e-16 | NR | XP_002506705.1 | 296587 | g5817 | i0 | 59.6 | 1.93251533742331 | 52 | 21 | 95.7 | 0 | 8 | 163 | 53 | 104 | XP_002506705.1 predicted protein [Micromonas commoda] | diamond | 315 | 82.8 | 0.990338164251208 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 28747692 | 28747692 | PRJNA188516_P_NODE_4007_length_169_cov_1.300000_g3957_i0 | PRJNA188516 | 4007 | 169 | 1.3 | 2.197 | Prototheca wickerhamii | 3111 | Plants | Plants | 49.3 | 4.76e-5 | NR | KAK2079365.1 | 3111 | g3957 | i0 | 37 | 0.958579881656805 | 54 | 34 | 95.9 | 0 | 167 | 6 | 156 | 209 | KAK2079365.1 hypothetical protein QBZ16_003056 [Prototheca wickerhamii] | diamond | 162 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28905307 | 28905307 | PRJNA188516_P_NODE_3748_length_174_cov_2.080000_g3698_i0 | PRJNA188516 | 3748 | 174 | 2.08 | 3.6192 | Trebouxia sp. C | 2796353 | Plants | Plants | 64.3 | 1.78e-11 | NR | KAL0042167.1 | 2905653 | g3698 | i0 | 61.4 | 3.25862068965517 | 44 | 17 | 75.9 | 0 | 33 | 164 | 5 | 48 | KAL0042167.1 hypothetical protein WJX77_005300 [Trebouxia sp. C0004] | diamond | 567 | 64.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 29631478 | 29631478 | PRJNA188516_P_NODE_2790_length_205_cov_1.493590_g2740_i0 | PRJNA188516 | 2790 | 205 | 1.49359 | 3.0618595 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 82.4 | 2.41e-16 | NR | CAG9467028.1 | 765719 | g2740 | i0 | 55.2 | 6.81951219512195 | 67 | 30 | 98 | 0 | 1 | 201 | 617 | 683 | CAG9467028.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 1398 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 29757934 | 29757934 | PRJNA188516_P_NODE_5451_length_164_cov_0.904348_g5401_i0 | PRJNA188516 | 5451 | 164 | 0.904348 | 1.48313072 | Chlorella vulgaris | 3077 | Plants | Plants | 63.2 | 2.91e-10 | NR | KAI3430572.1 | 3077 | g5401 | i0 | 49.1 | 2.50609756097561 | 53 | 27 | 97 | 0 | 1 | 159 | 28 | 80 | KAI3430572.1 hypothetical protein D9Q98_005165 [Chlorella vulgaris] | diamond | 411 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 29852882 | 29852882 | PRJNA188516_P_NODE_5771_length_163_cov_0.912281_g5721_i0 | PRJNA188516 | 5771 | 163 | 0.912281 | 1.48701803 | Nymphaea colorata | 210225 | Plants | Plants | 72 | 4.79e-14 | NR | VVW87744.1 | 210225 | g5721 | i0 | 65.4 | 3.86503067484663 | 52 | 18 | 95.7 | 0 | 5 | 160 | 30 | 81 | VVW87744.1 unnamed protein product, partial [Nymphaea colorata] | diamond | 630 | 72 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Nymphaeales | Nymphaeaceae | Nymphaea | Nymphaea colorata | |
| 29979152 | 29979152 | PRJNA188516_P_NODE_2611_length_212_cov_1.269939_g2561_i0 | PRJNA188516 | 2611 | 212 | 1.269939 | 2.69227068 | Sphagnum balticum | 128184 | Plants | Plants | 64.3 | 4.67e-10 | NR | CAM5999666.1 | 128184 | g2561 | i0 | 45.7 | 1.99528301886792 | 70 | 38 | 99.1 | 0 | 3 | 212 | 185 | 254 | CAM5999666.1 unnamed protein product [Sphagnum balticum] | diamond | 423 | 64.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum balticum | |
| 30010905 | 30010905 | PRJNA188516_P_NODE_3191_length_191_cov_0.985915_g3141_i0 | PRJNA188516 | 3191 | 191 | 0.985915 | 1.88309765 | Camellia sinensis var. sinensis | 542762 | Plants | Plants | 43.1 | 0.00733 | NR | GMP76123.1 | 542762 | g3141 | i0 | 36.9 | 3.06282722513089 | 65 | 31 | 88 | 2 | 1 | 168 | 58 | 121 | GMP76123.1 hypothetical protein CsSME_00032934 [Camellia sinensis var. sinensis] | diamond | 585 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Theaceae | Camellia | Camellia sinensis | |
| 30010906 | 30010906 | PRJNA188516_P_NODE_3451_length_183_cov_1.156716_g3401_i0 | PRJNA188516 | 3451 | 183 | 1.156716 | 2.11679028 | Daucus carota subsp. sativus | 79200 | Plants | Plants | 80.9 | 4.97e-16 | NR | XP_017247816.1 | 79200 | g3401 | i0 | 71.2 | 6.78688524590164 | 59 | 16 | 96.7 | 1 | 183 | 7 | 285 | 342 | XP_017247816.1 large ribosomal subunit protein uL4 [Daucus carota subsp. sativus] | diamond | 1242 | 80.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Daucus | Daucus carota | |
| 30105433 | 30105433 | PRJNA188516_P_NODE_4872_length_166_cov_0.888889_g4822_i0 | PRJNA188516 | 4872 | 166 | 0.888889 | 1.47555574 | Zostera marina | 29655 | Plants | Plants | 77.4 | 7.6e-15 | NR | KMZ65940.1 | 29655 | g4822 | i0 | 64.8 | 11.710843373494 | 54 | 19 | 97.6 | 0 | 164 | 3 | 282 | 335 | KMZ65940.1 Pre-mRNA-splicing factor CLF1 [Zostera marina] | diamond | 1944 | 77.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Zosteraceae | Zostera | Zostera marina | |
| 30231909 | 30231909 | PRJNA188516_P_NODE_3492_length_181_cov_1.969697_g3442_i0 | PRJNA188516 | 3492 | 181 | 1.969697 | 3.56515157 | Taxus chinensis | 29808 | Plants | Plants | 71.2 | 2.04e-13 | NR | KAH9328155.1 | 29808 | g3442 | i0 | 60.4 | 0.878453038674033 | 53 | 21 | 87.8 | 0 | 23 | 181 | 1 | 53 | KAH9328155.1 hypothetical protein KI387_000263 [Taxus chinensis] | diamond | 159 | 71.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 30263826 | 30263826 | PRJNA188516_P_NODE_4072_length_169_cov_0.866667_g4022_i0 | PRJNA188516 | 4072 | 169 | 0.866667 | 1.46466723 | Ceratopteris richardii | 49495 | Plants | Plants | 70.9 | 1.67e-12 | NR | KAH7297056.1 | 49495 | g4022 | i0 | 52.7 | 5.85798816568047 | 55 | 26 | 97.6 | 0 | 1 | 165 | 867 | 921 | KAH7297056.1 hypothetical protein KP509_26G051100 [Ceratopteris richardii] | diamond | 990 | 70.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Ceratopteris | Ceratopteris richardii | |
| 31274600 | 31274600 | PRJNA188516_P_NODE_2055_length_241_cov_1.614583_g2005_i0 | PRJNA188516 | 2055 | 241 | 1.614583 | 3.89114503 | Physcomitrium patens | 3218 | Plants | Plants | 62.4 | 5.68e-10 | NR | NP_001365811.1 | 3218 | g2005 | i0 | 40.8 | 4.79253112033195 | 76 | 43 | 94.6 | 1 | 229 | 2 | 9 | 82 | NP_001365811.1 40S ribosomal protein S15-like [Physcomitrium patens] | diamond | 1155 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 31337807 | 31337807 | PRJNA188516_P_NODE_5216_length_165_cov_0.896552_g5166_i0 | PRJNA188516 | 5216 | 165 | 0.896552 | 1.4793108 | Astrephomene gubernaculifera | 47775 | Plants | Plants | 89.7 | 3.51e-19 | NR | GFR43178.1 | 47775 | g5166 | i0 | 79.2 | 1.94545454545455 | 53 | 11 | 96.4 | 0 | 163 | 5 | 425 | 477 | GFR43178.1 hypothetical protein Agub_g4228 [Astrephomene gubernaculifera] | diamond | 321 | 89.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Astrephomenaceae | Astrephomene | Astrephomene gubernaculifera | |
| 31608743 | 31608743 | PRJNA188516_P_NODE_3656_length_177_cov_1.218750_g3606_i0 | PRJNA188516 | 3656 | 177 | 1.21875 | 2.1571875 | Eukaryota | 2759 | Plants | Plants | 83.6 | 1.63e-18 | NR | KAJ3669820.1 | 13579 | g3606 | i0 | 73.7 | 18.6949152542373 | 57 | 14 | 94.9 | 1 | 10 | 177 | 9 | 65 | KAJ3669820.1 hypothetical protein LUZ60_010144 [Juncus effusus] | diamond | 3309 | 83.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 31875442 | 31875442 | PRJNA188516_P_NODE_4457_length_168_cov_0.873950_g4407_i0 | PRJNA188516 | 4457 | 168 | 0.87395 | 1.468236 | Monoraphidium minutum | 39955 | Plants | Plants | 82.8 | 2.76e-17 | NR | KAI8470704.1 | 39955 | g4407 | i0 | 72.2 | 4.82142857142857 | 54 | 15 | 96.4 | 0 | 166 | 5 | 76 | 129 | KAI8470704.1 MAG: ribosomal protein S2, flavodoxin-like domain-containing protein [Monoraphidium minutum] | diamond | 810 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 32318896 | 32318896 | PRJNA188516_P_NODE_5459_length_164_cov_0.904348_g5409_i0 | PRJNA188516 | 5459 | 164 | 0.904348 | 1.48313072 | Arabidopsis thaliana | 3702 | Plants | Plants | 56.6 | 1.6e-7 | NR | CAD5333473.1 | 3702 | g5409 | i0 | 48.9 | 12.4756097560976 | 47 | 24 | 86 | 0 | 5 | 145 | 225 | 271 | CAD5333473.1 unnamed protein product [Arabidopsis thaliana] | diamond | 2046 | 56.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 32494784 | 32494784 | PRJNA188516_P_NODE_4039_length_169_cov_0.866667_g3989_i0 | PRJNA188516 | 4039 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 2.15e-6 | NR | GHP03167.1 | 41880 | g3989 | i0 | 42.6 | 5.5207100591716 | 54 | 31 | 95.9 | 0 | 4 | 165 | 462 | 515 | GHP03167.1 hypothetical protein PPROV_000192200 [Pycnococcus provasolii] | diamond | 933 | 53.9 | 0.992578849721707 | Eukaryota | Viridiplantae | Chlorophyta | Pseudoscourfieldiophyceae | Pseudoscourfieldiales | Pycnococcaceae | Pycnococcus | Pycnococcus provasolii | ||
| 32508682 | 32508682 | PRJNA188516_P_NODE_4819_length_166_cov_0.888889_g4769_i0 | PRJNA188516 | 4819 | 166 | 0.888889 | 1.47555574 | Forsythia ovata | 205694 | Plants | Plants | 69.3 | 1.86e-13 | NR | KAL2500444.1 | 205694 | g4769 | i0 | 65.1 | 2.29518072289157 | 43 | 15 | 77.7 | 0 | 134 | 6 | 33 | 75 | KAL2500444.1 ras-related protein RABA1f-like [Forsythia ovata] | diamond | 381 | 69.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Forsythia | Forsythia ovata |
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);;