contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA390533" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13163590 | 13163590 | PRJNA390533_P_NODE_4311_length_918_cov_2.260523_g3735_i0 | PRJNA390533 | 4311 | 918 | 2.260523 | 20.751601139999998 | Amborella trichopoda | 13333 | Plants | Plants | 177 | 6.2e-52 | NR | XP_006844639.2 | 13333 | g3735 | i0 | 63.9 | 0.434640522875817 | 133 | 45 | 43.5 | 1 | 54 | 452 | 1 | 130 | XP_006844639.2 HVA22-like protein e [Amborella trichopoda] | diamond | 399 | 177 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Amborellales | Amborellaceae | Amborella | Amborella trichopoda | |
| 19535318 | 19535318 | PRJNA390533_P_NODE_13316_length_522_cov_16.244306_g12353_i0 | PRJNA390533 | 13316 | 522 | 16.244306 | 84.79527732 | Lolium perenne | 4522 | Plants | Plants | 204 | 9.910000000000001e-64 | NR | XP_051203898.1 | 4522 | g12353 | i0 | 85 | 0.689655172413793 | 120 | 18 | 69 | 0 | 497 | 138 | 73 | 192 | XP_051203898.1 uncharacterized protein LOC127317374 [Lolium perenne] | diamond | 360 | 204 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 20811456 | 20811456 | PRJNA390533_P_NODE_40277_length_179_cov_2.307143_g39250_i0 | PRJNA390533 | 40277 | 179 | 2.307143 | 4.12978597 | root | 1 | Root_unresolved | Root_unresolved | 94.7 | 3.9800000000000006e-21 | NR | XP_057948064.1 | 397392 | g39250 | i0 | 89.3 | 44.6312849162011 | 56 | 6 | 93.9 | 0 | 170 | 3 | 344 | 399 | XP_057948064.1 phosphoglycerate kinase, cytosolic [Malania oleifera] | diamond | 7989 | 95.5 | 0.991623036649215 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Ximeniaceae | Malania | Malania oleifera | |
| 26663451 | 26663451 | PRJNA390533_P_NODE_33541_length_218_cov_9.525140_g32514_i0 | PRJNA390533 | 33541 | 218 | 9.52514 | 20.7648052 | Cucumis melo var. makuwa | 1194695 | Plants | Plants | 52.8 | 1.68e-6 | NR | KAA0058983.1 | 1194695 | g32514 | i0 | 64.1 | 0.536697247706422 | 39 | 14 | 53.7 | 0 | 87 | 203 | 40 | 78 | KAA0058983.1 putative endo-1,3(4)-beta-glucanase 2 [Cucumis melo var. makuwa] | diamond | 117 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 26790555 | 26790555 | PRJNA390533_P_NODE_43741_length_167_cov_0.953125_g42714_i0 | PRJNA390533 | 43741 | 167 | 0.953125 | 1.59171875 | Triticum aestivum | 4565 | Plants | Plants | 95.1 | 4.72e-21 | NR | BDI54545.1 | 4565 | g42714 | i0 | 73.1 | 0.934131736526946 | 52 | 14 | 93.4 | 0 | 156 | 1 | 711 | 762 | BDI54545.1 nucleolar and coiled-body phosphoprotein 1-like, partial [Triticum aestivum] | diamond | 156 | 95.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 27028836 | 27028836 | PRJNA390533_P_NODE_11522_length_573_cov_1.981273_g10605_i0 | PRJNA390533 | 11522 | 573 | 1.981273 | 11.35269429 | Magnoliopsida | 3398 | Plants | Plants | 129 | 4.989999999999999e-31 | NR | XP_022866758.1 | 158386 | g10605 | i0 | 50.5 | 2.80104712041885 | 107 | 53 | 56 | 0 | 359 | 39 | 9 | 115 | XP_022866758.1 uncharacterized protein LOC111386530 [Olea europaea var. sylvestris] | diamond | 1605 | 130 | 0.992307692307692 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Olea | Olea europaea | |
| 27976453 | 27976453 | PRJNA390533_P_NODE_10725_length_596_cov_4.868941_g9827_i0 | PRJNA390533 | 10725 | 596 | 4.868941 | 29.01888836 | Magnoliopsida | 3398 | Plants | Plants | 46.6 | 0.00236 | NR | CAA0394719.1 | 3702 | g9827 | i0 | 43.1 | 2.0989932885906 | 72 | 31 | 31.2 | 3 | 458 | 273 | 2 | 73 | CAA0394719.1 unnamed protein product [Arabidopsis thaliana] | diamond | 1251 | 46.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis thaliana | |
| 28370079 | 28370079 | PRJNA390533_P_NODE_3746_length_970_cov_19.149302_g3215_i0 | PRJNA390533 | 3746 | 970 | 19.149302 | 185.7482294 | Ceratodon purpureus | 3225 | Plants | Plants | 371 | 1.23e-126 | NR | KAG0567052.1 | 3225 | g3215 | i0 | 80.6 | 0.702061855670103 | 227 | 44 | 70.2 | 0 | 816 | 136 | 7 | 233 | KAG0567052.1 hypothetical protein KC19_7G106700 [Ceratodon purpureus] | diamond | 681 | 371 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 28545051 | 28545051 | PRJNA390533_P_NODE_39527_length_183_cov_1.090278_g38500_i0 | PRJNA390533 | 39527 | 183 | 1.090278 | 1.99520874 | root | 1 | Root_unresolved | Root_unresolved | 76.6 | 1.75e-15 | NR | GMD90523.1 | 4120 | g38500 | i0 | 82.9 | 3.90163934426229 | 41 | 7 | 67.2 | 0 | 60 | 182 | 24 | 64 | GMD90523.1 thioredoxin reductase NTRC [Ipomoea batatas] | diamond | 714 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Convolvulaceae | Ipomoea | Ipomoea batatas | |
| 28576371 | 28576371 | PRJNA390533_P_NODE_11487_length_573_cov_27.683521_g10572_i0 | PRJNA390533 | 11487 | 573 | 27.683521 | 158.62657533 | Magnoliopsida | 3398 | Plants | Plants | 79.3 | 1.83e-14 | NR | KAF4388071.1 | 3483 | g10572 | i0 | 88.6 | 2.2303664921466 | 44 | 5 | 23 | 0 | 546 | 415 | 44 | 87 | KAF4388071.1 hypothetical protein F8388_014754 [Cannabis sativa] | diamond | 1278 | 79.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 29208072 | 29208072 | PRJNA390533_P_NODE_18969_length_402_cov_1.570248_g17949_i0 | PRJNA390533 | 18969 | 402 | 1.570248 | 6.31239696 | Magnoliopsida | 3398 | Plants | Plants | 75.1 | 4.01e-14 | NR | GKU88917.1 | 152421 | g17949 | i0 | 71.7 | 1.79850746268657 | 60 | 17 | 44.8 | 0 | 394 | 215 | 56 | 115 | GKU88917.1 hypothetical protein SLEP1_g3126 [Rubroshorea leprosula] | diamond | 723 | 75.5 | 0.994701986754967 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Dipterocarpaceae | Rubroshorea | Rubroshorea leprosula | |
| 29253974 | 29253974 | PRJNA390533_P_NODE_1289_length_1417_cov_5.701742_g1063_i0 | PRJNA390533 | 1289 | 1417 | 5.701742 | 80.79368414 | Ceratodon purpureus | 3225 | Plants | Plants | 471 | 9.759999999999999e-161 | NR | KAG0559621.1 | 3225 | g1063 | i0 | 56.9 | 0.884968242766408 | 418 | 153 | 83.8 | 8 | 1417 | 230 | 6 | 418 | KAG0559621.1 hypothetical protein KC19_10G119000 [Ceratodon purpureus] | diamond | 1254 | 471 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 29411990 | 29411990 | PRJNA390533_P_NODE_17909_length_420_cov_3.627297_g16892_i0 | PRJNA390533 | 17909 | 420 | 3.627297 | 15.2346474 | Asparagus officinalis | 4686 | Plants | Plants | 84.7 | 1.94e-17 | NR | ONK75651.1 | 4686 | g16892 | i0 | 80 | 0.357142857142857 | 50 | 10 | 35.7 | 0 | 5 | 154 | 122 | 171 | ONK75651.1 uncharacterized protein A4U43_C03F19120 [Asparagus officinalis] | diamond | 150 | 84.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Asparagaceae | Asparagus | Asparagus officinalis | |
| 29632717 | 29632717 | PRJNA390533_P_NODE_7650_length_711_cov_22.108631_g6894_i0 | PRJNA390533 | 7650 | 711 | 22.108631 | 157.19236641 | Adiantum nelumboides | 2759587 | Plants | Plants | 106 | 5.8599999999999996e-24 | NR | MCO5578226.1 | 2759587 | g6894 | i0 | 50.7 | 0.565400843881857 | 134 | 50 | 49.8 | 5 | 96 | 449 | 3 | 136 | MCO5578226.1 hypothetical protein [Adiantum nelumboides] | diamond | 402 | 106 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum nelumboides | |
| 29727539 | 29727539 | PRJNA390533_P_NODE_38810_length_186_cov_1.612245_g37783_i0 | PRJNA390533 | 38810 | 186 | 1.612245 | 2.9987757 | Apostasia shenzhenica | 1088818 | Plants | Plants | 40.8 | 0.0136 | NR | PKA67061.1 | 1088818 | g37783 | i0 | 61.5 | 0.419354838709677 | 26 | 10 | 41.9 | 0 | 77 | 154 | 17 | 42 | PKA67061.1 hypothetical protein AXF42_Ash004552 [Apostasia shenzhenica] | diamond | 78 | 40.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Apostasia | Apostasia shenzhenica | |
| 30012215 | 30012215 | PRJNA390533_P_NODE_26091_length_306_cov_3.352060_g25064_i0 | PRJNA390533 | 26091 | 306 | 3.35206 | 10.2573036 | Lolium perenne | 4522 | Plants | Plants | 53.1 | 7.86e-6 | NR | XP_051208054.1 | 4522 | g25064 | i0 | 30.4 | 2.19607843137255 | 112 | 61 | 93.1 | 1 | 22 | 306 | 39 | 150 | XP_051208054.1 uncharacterized protein LOC127323903 isoform X2 [Lolium perenne] | diamond | 672 | 53.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium perenne | |
| 30012218 | 30012218 | PRJNA390533_P_NODE_29851_length_254_cov_1.693023_g28824_i0 | PRJNA390533 | 29851 | 254 | 1.693023 | 4.30027842 | Picea sitchensis | 3332 | Plants | Plants | 78.6 | 9.67e-15 | NR | ABK25480.1 | 3332 | g28824 | i0 | 77.3 | 0.519685039370079 | 44 | 10 | 52 | 0 | 1 | 132 | 417 | 460 | ABK25480.1 unknown [Picea sitchensis] | diamond | 132 | 78.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Pinales | Pinaceae | Picea | Picea sitchensis | |
| 30075126 | 30075126 | PRJNA390533_P_NODE_13512_length_517_cov_2.897490_g12541_i0 | PRJNA390533 | 13512 | 517 | 2.89749 | 14.9800233 | Ceratodon purpureus | 3225 | Plants | Plants | 63.5 | 5.77e-9 | NR | KAG0615955.1 | 3225 | g12541 | i0 | 39.2 | 0.562862669245648 | 97 | 49 | 51.6 | 2 | 498 | 232 | 85 | 179 | KAG0615955.1 hypothetical protein M758_5G079300 [Ceratodon purpureus] | diamond | 291 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30612243 | 30612243 | PRJNA390533_P_NODE_12073_length_557_cov_5.185328_g11137_i0 | PRJNA390533 | 12073 | 557 | 5.185328 | 28.88227696 | Diospyros lotus | 55363 | Plants | Plants | 95.1 | 5.02e-22 | NR | XP_052203006.1 | 55363 | g11137 | i0 | 60.5 | 2.87612208258528 | 81 | 30 | 43.6 | 1 | 506 | 264 | 1 | 79 | XP_052203006.1 uncharacterized protein LOC127808484 [Diospyros lotus] | diamond | 1602 | 95.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ebenaceae | Diospyros | Diospyros lotus | |
| 30770511 | 30770511 | PRJNA390533_P_NODE_20934_length_370_cov_3.308157_g19910_i0 | PRJNA390533 | 20934 | 370 | 3.308157 | 12.2401809 | Heracleum sosnowskyi | 360622 | Plants | Plants | 120 | 1.09e-30 | NR | KAK1373039.1 | 360622 | g19910 | i0 | 91.2 | 0.551351351351351 | 68 | 6 | 55.1 | 0 | 349 | 146 | 187 | 254 | KAK1373039.1 late embryogenesis abundant protein D-34-like [Heracleum sosnowskyi] | diamond | 204 | 120 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Apiales | Apiaceae | Heracleum | Heracleum sosnowskyi | |
| 31307500 | 31307500 | PRJNA390533_P_NODE_19255_length_397_cov_4.583799_g18233_i0 | PRJNA390533 | 19255 | 397 | 4.583799 | 18.19768203 | Lolium rigidum | 89674 | Plants | Plants | 89 | 2.24e-20 | NR | XP_047061562.1 | 89674 | g18233 | i0 | 58.4 | 0.581863979848867 | 77 | 29 | 55.9 | 2 | 347 | 126 | 1 | 77 | XP_047061562.1 uncharacterized protein LOC124668476 [Lolium rigidum] | diamond | 231 | 89 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Lolium | Lolium rigidum | |
| 31529128 | 31529128 | PRJNA390533_P_NODE_13716_length_511_cov_9.792373_g12739_i0 | PRJNA390533 | 13716 | 511 | 9.792373 | 50.03902603 | Quercus rubra | 3512 | Plants | Plants | 134 | 9.08e-38 | NR | KAK4589130.1 | 3512 | g12739 | i0 | 91.8 | 0.428571428571429 | 73 | 5 | 42.9 | 1 | 156 | 374 | 1 | 72 | KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra] | diamond | 219 | 134 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 31655318 | 31655318 | PRJNA390533_P_NODE_14037_length_503_cov_7.711207_g13056_i0 | PRJNA390533 | 14037 | 503 | 7.711207 | 38.78737121 | Forsythia ovata | 205694 | Plants | Plants | 79 | 5.02e-15 | NR | KAL2548042.1 | 205694 | g13056 | i0 | 60 | 0.775347912524851 | 70 | 23 | 41.7 | 2 | 22 | 231 | 2 | 66 | KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] | diamond | 390 | 79 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Forsythia | Forsythia ovata | |
| 32098380 | 32098380 | PRJNA390533_P_NODE_43858_length_166_cov_1.913386_g42831_i0 | PRJNA390533 | 43858 | 166 | 1.913386 | 3.17622076 | Cryptomeria japonica | 3369 | Plants | Plants | 85.9 | 8.32e-18 | NR | GLJ55894.1 | 3369 | g42831 | i0 | 81.8 | 1.98795180722892 | 55 | 10 | 99.4 | 0 | 2 | 166 | 491 | 545 | GLJ55894.1 hypothetical protein SUGI_1200030 [Cryptomeria japonica] | diamond | 330 | 85.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32242139 | 32242139 | PRJNA390533_P_NODE_3478_length_1002_cov_10.861890_g2973_i0 | PRJNA390533 | 3478 | 1002 | 10.86189 | 108.8361378 | Magnoliopsida | 3398 | Plants | Plants | 47.4 | 0.0181 | NR | XP_068466390.1 | 3885 | g2973 | i0 | 35.8 | 0.470059880239521 | 53 | 34 | 15.9 | 0 | 708 | 866 | 84 | 136 | XP_068466390.1 RING-H2 finger protein ATL40-like [Phaseolus vulgaris] | diamond | 471 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Phaseolus | Phaseolus vulgaris | |
| 32621192 | 32621192 | PRJNA390533_P_NODE_39100_length_185_cov_1.102740_g38073_i0 | PRJNA390533 | 39100 | 185 | 1.10274 | 2.040069 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 9.5e-9 | NR | KMZ60691.1 | 29655 | g38073 | i0 | 55.3 | 5.4972972972973 | 47 | 20 | 74.6 | 1 | 171 | 34 | 481 | 527 | KMZ60691.1 transducin family protein / WD-40 repeat family protein [Zostera marina] | diamond | 1017 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Zosteraceae | Zostera | Zostera marina | |
| 32635737 | 32635737 | PRJNA390533_P_NODE_21140_length_367_cov_5.015244_g20116_i0 | PRJNA390533 | 21140 | 367 | 5.015244 | 18.40594548 | Solanum pinnatisectum | 50273 | Plants | Plants | 77.8 | 2.51e-15 | NR | KAK4732708.1 | 50273 | g20116 | i0 | 40.4 | 1.4550408719346 | 89 | 47 | 69.5 | 2 | 109 | 363 | 8 | 94 | KAK4732708.1 hypothetical protein R3W88_025696 [Solanum pinnatisectum] | diamond | 534 | 77.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum pinnatisectum | |
| 32635744 | 32635744 | PRJNA390533_P_NODE_34700_length_210_cov_2.292398_g33673_i0 | PRJNA390533 | 34700 | 210 | 2.292398 | 4.8140358 | Acorus calamus | 4465 | Plants | Plants | 72.8 | 3.26e-14 | NR | KAK1306485.1 | 4465 | g33673 | i0 | 65.3 | 2.91428571428571 | 49 | 17 | 70 | 0 | 210 | 64 | 96 | 144 | KAK1306485.1 40S ribosomal protein S19-1 [Acorus calamus] | diamond | 612 | 72.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Acorales | Acoraceae | Acorus | Acorus calamus |
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);;