contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA698538" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10885401 | 10885401 | PRJNA698538_S_NODE_18969_length_289_cov_1.398148_g18803_i0 | PRJNA698538 | 18969 | 289 | 1.398148 | 4.04064772 | Lotus japonicus | 34305 | Plants | Plants | 134 | 6.35e-36 | NR | AFK42829.1 | 34305 | g18803 | i0 | 89.4 | 1.38062283737024 | 66 | 7 | 68.5 | 0 | 6 | 203 | 268 | 333 | AFK42829.1 unknown [Lotus japonicus] | diamond | 399 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Lotus | Lotus japonicus | |
| 12160448 | 12160448 | PRJNA698538_S_NODE_15870_length_307_cov_2.320513_g15704_i0 | PRJNA698538 | 15870 | 307 | 2.320513 | 7.12397491 | Eukaryota | 2759 | Plants | Plants | 143 | 9.21e-42 | NR | XP_047308679.1 | 253017 | g15704 | i0 | 85.2 | 80.8241042345277 | 88 | 12 | 85 | 1 | 47 | 307 | 22 | 109 | XP_047308679.1 probable histone H2A variant 3 [Impatiens glandulifera] | diamond | 24813 | 143 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Balsaminaceae | Impatiens | Impatiens glandulifera | |
| 26861558 | 26861558 | PRJNA698538_S_NODE_26361_length_252_cov_2.150838_g26195_i0 | PRJNA698538 | 26361 | 252 | 2.150838 | 5.42011176 | Humulus scandens | 228586 | Plants | Plants | 50.4 | 5.6e-6 | NR | AVY54507.1 | 228586 | g26195 | i0 | 45.1 | 0.607142857142857 | 51 | 28 | 60.7 | 0 | 7 | 159 | 23 | 73 | AVY54507.1 Hum s 3 allergen [Humulus scandens] | diamond | 153 | 50.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus scandens | |
| 27051181 | 27051181 | PRJNA698538_S_NODE_20642_length_280_cov_1.806763_g20476_i0 | PRJNA698538 | 20642 | 280 | 1.806763 | 5.0589364 | Brachypodium distachyon | 15368 | Plants | Plants | 43.9 | 0.00257 | NR | PNT67338.1 | 15368 | g20476 | i0 | 38.2 | 0.589285714285714 | 55 | 22 | 58.9 | 1 | 65 | 229 | 13 | 55 | PNT67338.1 hypothetical protein BRADI_3g25594v3 [Brachypodium distachyon] | diamond | 165 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Brachypodium | Brachypodium distachyon | |
| 27062284 | 27062284 | PRJNA698538_S_NODE_28162_length_246_cov_3.115607_g27996_i0 | PRJNA698538 | 28162 | 246 | 3.115607 | 7.66439322 | Magnoliopsida | 3398 | Plants | Plants | 57.8 | 1.98e-7 | NR | KDO59476.1 | 2711 | g27996 | i0 | 100 | 75.7317073170732 | 27 | 0 | 32.9 | 0 | 1 | 81 | 563 | 589 | KDO59476.1 hypothetical protein CISIN_1g007033mg [Citrus sinensis] | diamond | 18630 | 57.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 27820605 | 27820605 | PRJNA698538_S_NODE_23104_length_267_cov_4.824742_g22938_i0 | PRJNA698538 | 23104 | 267 | 4.824742 | 12.88206114 | Magnoliopsida | 3398 | Plants | Plants | 42.4 | 0.00976 | NR | PON55230.1 | 3476 | g22938 | i0 | 52.4 | 0.921348314606742 | 42 | 17 | 44.9 | 2 | 2 | 121 | 33 | 73 | PON55230.1 Pollen allergen ole e [Parasponia andersonii] | diamond | 246 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Parasponia | Parasponia andersonii | |
| 27840619 | 27840619 | PRJNA698538_S_NODE_24104_length_263_cov_1.015789_g23938_i0 | PRJNA698538 | 24104 | 263 | 1.015789 | 2.67152507 | Humulus lupulus | 3486 | Plants | Plants | 58.5 | 3.04e-8 | NR | XP_062104844.1 | 3486 | g23938 | i0 | 83.3 | 0.4106463878327 | 36 | 6 | 41.1 | 0 | 1 | 108 | 132 | 167 | XP_062104844.1 GPI-anchored protein LLG3-like [Humulus lupulus] | diamond | 108 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 27978286 | 27978286 | PRJNA698538_S_NODE_14105_length_318_cov_3.142857_g13939_i0 | PRJNA698538 | 14105 | 318 | 3.142857 | 9.99428526 | Eukaryota | 2759 | Plants | Plants | 57 | 2.73e-7 | NR | GAA0165535.1 | 34254 | g13939 | i0 | 47.2 | 2.42452830188679 | 53 | 26 | 50 | 1 | 1 | 159 | 124 | 174 | GAA0165535.1 hypothetical protein LIER_20916 [Lithospermum erythrorhizon] | diamond | 771 | 57.4 | 0.993031358885017 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Boraginales | Boraginaceae | Lithospermum | Lithospermum erythrorhizon | |
| 28072954 | 28072954 | PRJNA698538_S_NODE_6705_length_384_cov_3.565916_g6539_i0 | PRJNA698538 | 6705 | 384 | 3.565916 | 13.69311744 | Eukaryota | 2759 | Plants | Plants | 58.5 | 1.9e-7 | NR | KAJ8645526.1 | 3435 | g6539 | i0 | 33.7 | 7.609375 | 95 | 60 | 74.2 | 2 | 378 | 94 | 57 | 148 | KAJ8645526.1 hypothetical protein MRB53_007274 [Persea americana] | diamond | 2922 | 58.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Persea | Persea americana | |
| 28661856 | 28661856 | PRJNA698538_S_NODE_25467_length_256_cov_2.573770_g25301_i0 | PRJNA698538 | 25467 | 256 | 2.57377 | 6.5888512 | Parasponia andersonii | 3476 | Plants | Plants | 55.8 | 8.33e-8 | NR | PON58107.1 | 3476 | g25301 | i0 | 84.2 | 0.4453125 | 38 | 4 | 44.5 | 1 | 255 | 142 | 65 | 100 | PON58107.1 hypothetical protein PanWU01x14_168770 [Parasponia andersonii] | diamond | 114 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Parasponia | Parasponia andersonii | |
| 28862256 | 28862256 | PRJNA698538_S_NODE_31588_length_227_cov_2.097403_g31422_i0 | PRJNA698538 | 31588 | 227 | 2.097403 | 4.76110481 | Marchantia | 3196 | Plants | Plants | 65.5 | 2.29e-10 | NR | KAG6552940.1 | 56867 | g31422 | i0 | 69.8 | 3.64757709251101 | 43 | 12 | 55.5 | 1 | 226 | 101 | 259 | 301 | KAG6552940.1 hypothetical protein Mapa_005473 [Marchantia paleacea] | diamond | 828 | 65.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Marchantiaceae | Marchantia | Marchantia paleacea | |
| 29209811 | 29209811 | PRJNA698538_S_NODE_24009_length_263_cov_1.752632_g23843_i0 | PRJNA698538 | 24009 | 263 | 1.752632 | 4.60942216 | Magnoliopsida | 3398 | Plants | Plants | 54.7 | 7.93e-7 | NR | CAF2239439.1 | 3708 | g23843 | i0 | 57.4 | 8.32699619771863 | 47 | 20 | 53.6 | 0 | 263 | 123 | 107 | 153 | CAF2239439.1 unnamed protein product [Brassica napus] | diamond | 2190 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 29261442 | 29261442 | PRJNA698538_S_NODE_7069_length_380_cov_1.752443_g6903_i0 | PRJNA698538 | 7069 | 380 | 1.752443 | 6.6592834 | Urochloa decumbens | 240449 | Plants | Plants | 79.7 | 1.76e-14 | NR | CAL5071761.1 | 240449 | g6903 | i0 | 67.3 | 0.386842105263158 | 49 | 16 | 38.7 | 0 | 378 | 232 | 413 | 461 | CAL5071761.1 unnamed protein product [Urochloa decumbens] | diamond | 147 | 79.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Urochloa | Urochloa decumbens | |
| 29450803 | 29450803 | PRJNA698538_S_NODE_19030_length_288_cov_4.939535_g18864_i0 | PRJNA698538 | 19030 | 288 | 4.939535 | 14.2258608 | Humulus lupulus | 3486 | Plants | Plants | 68.6 | 4.74e-13 | NR | XP_062076519.1 | 3486 | g18864 | i0 | 97.3 | 0.770833333333333 | 37 | 1 | 38.5 | 0 | 287 | 177 | 26 | 62 | XP_062076519.1 arabinogalactan protein 13-like [Humulus lupulus] | diamond | 222 | 68.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Humulus | Humulus lupulus | |
| 29577139 | 29577139 | PRJNA698538_S_NODE_17690_length_296_cov_3.372197_g17524_i0 | PRJNA698538 | 17690 | 296 | 3.372197 | 9.98170312 | Parasponia andersonii | 3476 | Plants | Plants | 76.6 | 4.75e-16 | NR | PON40070.1 | 3476 | g17524 | i0 | 57.9 | 0.577702702702703 | 57 | 23 | 56.8 | 1 | 4 | 171 | 19 | 75 | PON40070.1 hypothetical protein PanWU01x14_300130 [Parasponia andersonii] | diamond | 171 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Parasponia | Parasponia andersonii | |
| 29861595 | 29861595 | PRJNA698538_S_NODE_30211_length_240_cov_3.826347_g30045_i0 | PRJNA698538 | 30211 | 240 | 3.826347 | 9.1832328 | Catharanthus roseus | 4058 | Plants | Plants | 55.1 | 1.57e-6 | NR | KAI5670966.1 | 4058 | g30045 | i0 | 64.3 | 0.525 | 42 | 15 | 52.5 | 0 | 2 | 127 | 515 | 556 | KAI5670966.1 hypothetical protein M9H77_11330 [Catharanthus roseus] | diamond | 126 | 55.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Gentianales | Apocynaceae | Catharanthus | Catharanthus roseus | |
| 30367507 | 30367507 | PRJNA698538_S_NODE_18092_length_294_cov_1.742081_g17926_i0 | PRJNA698538 | 18092 | 294 | 1.742081 | 5.12171814 | Picea sitchensis | 3332 | Plants | Plants | 134 | 2.1e-37 | NR | ABK27059.1 | 3332 | g17926 | i0 | 80.8 | 2.23469387755102 | 73 | 14 | 74.5 | 0 | 2 | 220 | 119 | 191 | ABK27059.1 unknown [Picea sitchensis] | diamond | 657 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea sitchensis | |
| 30725781 | 30725781 | PRJNA698538_S_NODE_20574_length_280_cov_3.347826_g20408_i0 | PRJNA698538 | 20574 | 280 | 3.347826 | 9.3739128 | Eukaryota | 2759 | Plants | Plants | 94.4 | 4.669999999999999e-23 | NR | KAJ3695878.1 | 13579 | g20408 | i0 | 70.5 | 25.3285714285714 | 61 | 18 | 65.4 | 0 | 1 | 183 | 16 | 76 | KAJ3695878.1 hypothetical protein LUZ60_001255 [Juncus effusus] | diamond | 7092 | 95.1 | 0.992639327024185 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 31251720 | 31251720 | PRJNA698538_S_NODE_11715_length_335_cov_4.297710_g11549_i0 | PRJNA698538 | 11715 | 335 | 4.29771 | 14.3973285 | Cryptomeria japonica | 3369 | Plants | Plants | 156 | 6.03e-46 | NR | XP_057865288.2 | 3369 | g11549 | i0 | 74 | 0.859701492537313 | 96 | 25 | 86 | 0 | 1 | 288 | 86 | 181 | XP_057865288.2 uncharacterized protein LOC131072982 [Cryptomeria japonica] | diamond | 288 | 156 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 31505006 | 31505006 | PRJNA698538_S_NODE_4296_length_427_cov_4.389831_g4130_i0 | PRJNA698538 | 4296 | 427 | 4.389831 | 18.74457837 | Cannabis sativa | 3483 | Plants | Plants | 77.4 | 1.1e-15 | NR | KAF4379259.1 | 3483 | g4130 | i0 | 50 | 0.548009367681499 | 78 | 33 | 54.1 | 3 | 3 | 233 | 5 | 77 | KAF4379259.1 hypothetical protein G4B88_010653 [Cannabis sativa] | diamond | 234 | 77.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 32169406 | 32169406 | PRJNA698538_S_NODE_7378_length_376_cov_1.795380_g7212_i0 | PRJNA698538 | 7378 | 376 | 1.79538 | 6.7506288 | Kingdonia uniflora | 39325 | Plants | Plants | 59.3 | 2.48e-7 | NR | KAF6145608.1 | 39325 | g7212 | i0 | 44.3 | 2.91223404255319 | 70 | 37 | 55.9 | 1 | 95 | 304 | 3 | 70 | KAF6145608.1 hypothetical protein GIB67_037641 [Kingdonia uniflora] | diamond | 1095 | 59.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Circaeasteraceae | Kingdonia | Kingdonia uniflora | |
| 32180513 | 32180513 | PRJNA698538_S_NODE_22638_length_270_cov_1.172589_g22472_i0 | PRJNA698538 | 22638 | 270 | 1.172589 | 3.1659903 | Magnoliopsida | 3398 | Plants | Plants | 53.9 | 6.34e-6 | NR | KAG7598815.1 | 45249 | g22472 | i0 | 57.5 | 2.25555555555556 | 40 | 17 | 44.4 | 0 | 1 | 120 | 1440 | 1479 | KAG7598815.1 GAG-pre-integrase domain [Arabidopsis suecica] | diamond | 609 | 53.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis suecica | |
| 32674699 | 32674699 | PRJNA698538_S_NODE_11620_length_336_cov_2.490494_g11454_i0 | PRJNA698538 | 11620 | 336 | 2.490494 | 8.36805984 | Cryptomeria japonica | 3369 | Plants | Plants | 87 | 3.31e-17 | NR | GLJ22641.1 | 3369 | g11454 | i0 | 46.8 | 0.991071428571429 | 111 | 56 | 99.1 | 1 | 334 | 2 | 1783 | 1890 | GLJ22641.1 hypothetical protein SUGI_0426380 [Cryptomeria japonica] | diamond | 333 | 87 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32769239 | 32769239 | PRJNA698538_S_NODE_12100_length_332_cov_5.015444_g11934_i0 | PRJNA698538 | 12100 | 332 | 5.015444 | 16.65127408 | Sphagnum fallax | 53036 | Plants | Plants | 102 | 8.89e-23 | NR | KAH8948750.1 | 53036 | g11934 | i0 | 51.4 | 1.00301204819277 | 111 | 51 | 99.4 | 2 | 3 | 332 | 76 | 184 | KAH8948750.1 hypothetical protein BDL97_11G109700 [Sphagnum fallax] | diamond | 333 | 102 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum fallax | |
| 32769241 | 32769241 | PRJNA698538_S_NODE_18440_length_292_cov_1.757991_g18274_i0 | PRJNA698538 | 18440 | 292 | 1.757991 | 5.13333372 | Cryptomeria japonica | 3369 | Plants | Plants | 55.8 | 1.48e-6 | NR | XP_057817356.1 | 3369 | g18274 | i0 | 64.9 | 0.729452054794521 | 37 | 13 | 38 | 0 | 2 | 112 | 279 | 315 | XP_057817356.1 protein EXORDIUM-like 2 [Cryptomeria japonica] | diamond | 213 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica |
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);;