contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA792582" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7155519 | 7155519 | PRJNA792582_P_NODE_5086_length_730_cov_1.406393_g4362_i0 | PRJNA792582 | 5086 | 730 | 1.406393 | 10.2666689 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 236 | 3.19e-67 | NR | GEU28517.1 | 118510 | g4362 | i0 | 62.4 | 0.776712328767123 | 189 | 38 | 77.7 | 1 | 5 | 571 | 422 | 577 | GEU28517.1 preprotein translocase subunit SCY1, chloroplastic [Tanacetum cinerariifolium] | diamond | 567 | 236 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 13530455 | 13530455 | PRJNA792582_P_NODE_20471_length_380_cov_2.387622_g19657_i0 | PRJNA792582 | 20471 | 380 | 2.387622 | 9.0729636 | root | 1 | Root_unresolved | Root_unresolved | 126 | 1.0500000000000001e-30 | NR | GEU28483.1 | 118510 | g19657 | i0 | 76.2 | 10.6105263157895 | 84 | 20 | 66.3 | 0 | 127 | 378 | 1140 | 1223 | GEU28483.1 chaperonin CPN60-2, mitochondrial [Tanacetum cinerariifolium] | diamond | 4032 | 126 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 18628772 | 18628772 | PRJNA792582_P_NODE_56935_length_244_cov_0.900585_g56121_i0 | PRJNA792582 | 56935 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Plants | Plants | 119 | 3.04e-29 | NR | KAK4557423.1 | 3512 | g56121 | i0 | 81.8 | 23.5081967213115 | 66 | 12 | 81.1 | 0 | 47 | 244 | 1 | 66 | KAK4557423.1 hypothetical protein RGQ29_007255 [Quercus rubra] | diamond | 5736 | 120 | 0.991666666666667 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 26610387 | 26610387 | PRJNA792582_P_NODE_19841_length_386_cov_2.146965_g19027_i0 | PRJNA792582 | 19841 | 386 | 2.146965 | 8.2872849 | Lactuca sativa | 4236 | Plants | Plants | 87.8 | 2e-17 | NR | XP_023751240.1 | 4236 | g19027 | i0 | 39.8 | 1.03367875647668 | 133 | 74 | 98.7 | 3 | 383 | 3 | 3 | 135 | XP_023751240.1 WD-40 repeat-containing protein MSI3 [Lactuca sativa] | diamond | 399 | 87.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Lactuca | Lactuca sativa | |
| 26768892 | 26768892 | PRJNA792582_P_NODE_30601_length_312_cov_0.832636_g29787_i0 | PRJNA792582 | 30601 | 312 | 0.832636 | 2.59782432 | Gossypium turneri | 34284 | Plants | Plants | 43.5 | 0.0349 | NR | MFQ6658037.1 | 34284 | g29787 | i0 | 35.7 | 0.403846153846154 | 42 | 27 | 40.4 | 0 | 19 | 144 | 60 | 101 | MFQ6658037.1 hypothetical protein [Gossypium turneri] | diamond | 126 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium turneri | |
| 27157416 | 27157416 | PRJNA792582_P_NODE_33882_length_296_cov_1.376682_g33068_i0 | PRJNA792582 | 33882 | 296 | 1.376682 | 4.07497872 | Magnoliopsida | 3398 | Plants | Plants | 48.1 | 8.81e-4 | NR | KAI3709967.1 | 13427 | g33068 | i0 | 42.9 | 1.27702702702703 | 63 | 31 | 63.9 | 1 | 265 | 77 | 519 | 576 | KAI3709967.1 hypothetical protein L2E82_39738 [Cichorium intybus] | diamond | 378 | 48.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Cichorium | Cichorium intybus | |
| 27179943 | 27179943 | PRJNA792582_P_NODE_49782_length_251_cov_0.865169_g48968_i0 | PRJNA792582 | 49782 | 251 | 0.865169 | 2.17157419 | Linum trigynum | 586398 | Plants | Plants | 45.4 | 0.00443 | NR | CAL1406803.1 | 586398 | g48968 | i0 | 23.8 | 5.68924302788845 | 101 | 57 | 96.8 | 1 | 1 | 243 | 211 | 311 | CAL1406803.1 unnamed protein product [Linum trigynum] | diamond | 1428 | 45.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Linaceae | Linum | Linum trigynum | |
| 27275075 | 27275075 | PRJNA792582_P_NODE_52103_length_249_cov_0.875000_g51289_i0 | PRJNA792582 | 52103 | 249 | 0.875 | 2.17875 | Miscanthus floridulus | 154761 | Plants | Plants | 43.9 | 0.00778 | NR | XP_066334265.1 | 154761 | g51289 | i0 | 44.1 | 0.819277108433735 | 68 | 31 | 81.9 | 1 | 205 | 2 | 83 | 143 | XP_066334265.1 uncharacterized protein [Miscanthus floridulus] | diamond | 204 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Miscanthus | Miscanthus floridulus | |
| 28159434 | 28159434 | PRJNA792582_P_NODE_22705_length_362_cov_0.972318_g21891_i0 | PRJNA792582 | 22705 | 362 | 0.972318 | 3.51979116 | Triticum aestivum | 4565 | Plants | Plants | 56.2 | 2.48e-6 | NR | XP_044415394.1 | 4565 | g21891 | i0 | 44.4 | 0.522099447513812 | 63 | 35 | 52.2 | 0 | 1 | 189 | 128 | 190 | XP_044415394.1 LRR receptor-like serine/threonine-protein kinase EFR [Triticum aestivum] | diamond | 189 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 28642154 | 28642154 | PRJNA792582_P_NODE_30767_length_311_cov_1.033613_g29953_i0 | PRJNA792582 | 30767 | 311 | 1.033613 | 3.21453643 | Eukaryota | 2759 | Plants | Plants | 85.9 | 1.24e-18 | NR | KAK4336940.1 | 243964 | g29953 | i0 | 59.5 | 2.62379421221865 | 74 | 30 | 71.4 | 0 | 311 | 90 | 1 | 74 | KAK4336940.1 hypothetical protein RND71_043512 [Anisodus tanguticus] | diamond | 816 | 86.7 | 0.990772779700115 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Anisodus | Anisodus tanguticus | |
| 28673633 | 28673633 | PRJNA792582_P_NODE_42327_length_271_cov_3.186869_g41513_i0 | PRJNA792582 | 42327 | 271 | 3.186869 | 8.63641499 | Magnoliopsida | 3398 | Plants | Plants | 56.6 | 6.05e-7 | NR | KAI3672245.1 | 13427 | g41513 | i0 | 61.7 | 2.98892988929889 | 47 | 18 | 52 | 0 | 205 | 65 | 132 | 178 | KAI3672245.1 hypothetical protein L2E82_52919 [Cichorium intybus] | diamond | 810 | 56.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Cichorium | Cichorium intybus | |
| 29178910 | 29178910 | PRJNA792582_P_NODE_24629_length_348_cov_1.269091_g23815_i0 | PRJNA792582 | 24629 | 348 | 1.269091 | 4.41643668 | Streptophyta | 35493 | Plants | Plants | 68.9 | 3.44e-11 | NR | EFJ27613.1 | 88036 | g23815 | i0 | 35.4 | 9.80172413793103 | 113 | 60 | 97.4 | 4 | 2 | 340 | 22 | 121 | EFJ27613.1 LIP1, ras family GTPase [Selaginella moellendorffii] | diamond | 3411 | 69.3 | 0.994227994227994 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Lycopodiopsida | Selaginellales | Selaginellaceae | Selaginella | Selaginella moellendorffii | |
| 29178917 | 29178917 | PRJNA792582_P_NODE_54509_length_246_cov_0.890173_g53695_i0 | PRJNA792582 | 54509 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | Plants | Plants | 55.8 | 9.11e-7 | NR | XP_059597963.1 | 29760 | g53695 | i0 | 43.1 | 6.07317073170732 | 58 | 32 | 69.5 | 1 | 54 | 224 | 90 | 147 | XP_059597963.1 probable leucine-rich repeat receptor-like protein kinase At1g35710 [Vitis vinifera] | diamond | 1494 | 55.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Vitales | Vitaceae | Vitis | Vitis vinifera | |
| 29232861 | 29232861 | PRJNA792582_P_NODE_12889_length_476_cov_0.863524_g12077_i0 | PRJNA792582 | 12889 | 476 | 0.863524 | 4.11037424 | Amborella trichopoda | 13333 | Plants | Plants | 75.9 | 9.82e-13 | NR | XP_011624406.1 | 13333 | g12077 | i0 | 44.2 | 3.47268907563025 | 86 | 48 | 54.2 | 0 | 452 | 195 | 284 | 369 | XP_011624406.1 BTB/POZ and MATH domain-containing protein 4 [Amborella trichopoda] | diamond | 1653 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Amborellales | Amborellaceae | Amborella | Amborella trichopoda | |
| 29304960 | 29304960 | PRJNA792582_P_NODE_36349_length_287_cov_1.971963_g35535_i0 | PRJNA792582 | 36349 | 287 | 1.971963 | 5.65953381 | Ananas | 4614 | Plants | Plants | 93.6 | 8.33e-20 | NR | XP_020086597.1 | 4615 | g35535 | i0 | 49.4 | 2.64459930313589 | 85 | 38 | 88.9 | 1 | 283 | 29 | 343 | 422 | XP_020086597.1 beta-hexosaminidase 1 [Ananas comosus] | diamond | 759 | 93.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Bromeliaceae | Ananas | Ananas comosus | |
| 29737662 | 29737662 | PRJNA792582_P_NODE_56190_length_244_cov_1.725146_g55376_i0 | PRJNA792582 | 56190 | 244 | 1.725146 | 4.20935624 | Trifolium medium | 97028 | Plants | Plants | 43.1 | 0.0134 | NR | MCI12986.1 | 97028 | g55376 | i0 | 42.1 | 0.700819672131147 | 57 | 31 | 68.9 | 2 | 11 | 178 | 81 | 136 | MCI12986.1 lysine-specific demethylase 5B [Trifolium medium] | diamond | 171 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium medium | |
| 30622342 | 30622342 | PRJNA792582_P_NODE_37333_length_285_cov_1.165094_g36519_i0 | PRJNA792582 | 37333 | 285 | 1.165094 | 3.3205179 | Triticum aestivum | 4565 | Plants | Plants | 43.1 | 0.0386 | NR | XBH82435.1 | 4565 | g36519 | i0 | 49.2 | 0.621052631578947 | 59 | 25 | 56.8 | 2 | 2 | 163 | 142 | 200 | XBH82435.1 hypothetical protein VPH35_071092 [Triticum aestivum] | diamond | 177 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 30622345 | 30622345 | PRJNA792582_P_NODE_41253_length_274_cov_1.975124_g40439_i0 | PRJNA792582 | 41253 | 274 | 1.975124 | 5.41183976 | Populus tomentosa | 118781 | Plants | Plants | 43.5 | 0.0235 | NR | KAG6749690.1 | 118781 | g40439 | i0 | 37.5 | 0.613138686131387 | 56 | 34 | 61.3 | 1 | 106 | 273 | 37 | 91 | KAG6749690.1 hypothetical protein POTOM_046757 [Populus tomentosa] | diamond | 168 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus tomentosa | |
| 30821262 | 30821262 | PRJNA792582_P_NODE_41054_length_275_cov_1.247525_g40240_i0 | PRJNA792582 | 41054 | 275 | 1.247525 | 3.43069375 | Eukaryota | 2759 | Plants | Plants | 92 | 1.95e-19 | NR | CAH1426817.1 | 75947 | g40240 | i0 | 46.2 | 9.85090909090909 | 91 | 49 | 99.3 | 0 | 1 | 273 | 72 | 162 | CAH1426817.1 unnamed protein product [Lactuca virosa] | diamond | 2709 | 92.8 | 0.991379310344828 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Lactuca | Lactuca virosa | |
| 30938598 | 30938598 | PRJNA792582_P_NODE_44714_length_265_cov_1.416667_g43900_i0 | PRJNA792582 | 44714 | 265 | 1.416667 | 3.75416755 | Kingdonia uniflora | 39325 | Plants | Plants | 76.6 | 1.34e-14 | NR | KAF6163148.1 | 39325 | g43900 | i0 | 79.2 | 1.10943396226415 | 48 | 10 | 54.3 | 0 | 265 | 122 | 196 | 243 | KAF6163148.1 hypothetical protein GIB67_025012 [Kingdonia uniflora] | diamond | 294 | 76.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Circaeasteraceae | Kingdonia | Kingdonia uniflora | |
| 31643041 | 31643041 | PRJNA792582_P_NODE_53796_length_247_cov_0.885057_g52982_i0 | PRJNA792582 | 53796 | 247 | 0.885057 | 2.18609079 | root | 1 | Root_unresolved | Root_unresolved | 119 | 7.009999999999999e-31 | NR | CAM6053906.1 | 128247 | g52982 | i0 | 63.8 | 1.94331983805668 | 80 | 29 | 97.2 | 0 | 2 | 241 | 6 | 85 | CAM6053906.1 unnamed protein product [Sphagnum tenellum] | diamond | 480 | 119 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum tenellum | |
| 31665530 | 31665530 | PRJNA792582_P_NODE_14897_length_445_cov_3.161290_g14084_i0 | PRJNA792582 | 14897 | 445 | 3.16129 | 14.0677405 | Cucumis melo | 3656 | Plants | Plants | 53.5 | 5.1e-5 | NR | XP_008464825.1 | 3656 | g14084 | i0 | 39 | 3.28988764044944 | 100 | 49 | 60 | 3 | 174 | 440 | 28 | 126 | XP_008464825.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 1A [Cucumis melo] | diamond | 1464 | 53.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucumis | Cucumis melo | |
| 31697258 | 31697258 | PRJNA792582_P_NODE_24597_length_348_cov_1.658182_g23783_i0 | PRJNA792582 | 24597 | 348 | 1.658182 | 5.77047336 | Cryptomeria japonica | 3369 | Plants | Plants | 54.7 | 7.76e-6 | NR | XP_059073962.1 | 3369 | g23783 | i0 | 43.9 | 0.491379310344828 | 57 | 32 | 49.1 | 0 | 3 | 173 | 214 | 270 | XP_059073962.1 receptor-like protein 35 [Cryptomeria japonica] | diamond | 171 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 32045343 | 32045343 | PRJNA792582_P_NODE_54958_length_246_cov_0.890173_g54144_i0 | PRJNA792582 | 54958 | 246 | 0.890173 | 2.18982558 | Glycine soja | 3848 | Plants | Plants | 43.1 | 0.0233 | NR | KHN04400.1 | 3848 | g54144 | i0 | 29.3 | 0.914634146341463 | 75 | 44 | 80.5 | 1 | 22 | 219 | 41 | 115 | KHN04400.1 Hexokinase-2, chloroplastic [Glycine soja] | diamond | 225 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Glycine | Glycine soja | |
| 32086076 | 32086076 | PRJNA792582_P_NODE_55458_length_245_cov_0.895349_g54644_i0 | PRJNA792582 | 55458 | 245 | 0.895349 | 2.19360505 | Brassica | 3705 | Plants | Plants | 44.7 | 0.00792 | NR | CDY27513.1 | 3708 | g54644 | i0 | 35.2 | 1.98367346938776 | 54 | 35 | 66.1 | 0 | 222 | 61 | 263 | 316 | CDY27513.1 BnaC04g51540D [Brassica napus] | diamond | 486 | 44.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 32298762 | 32298762 | PRJNA792582_P_NODE_51719_length_249_cov_0.875000_g50905_i0 | PRJNA792582 | 51719 | 249 | 0.875 | 2.17875 | Trifolium repens | 3899 | Plants | Plants | 41.6 | 0.0283 | NR | WJX15399.1 | 3899 | g50905 | i0 | 40.4 | 0.626506024096386 | 52 | 28 | 59 | 2 | 101 | 247 | 42 | 93 | WJX15399.1 hypothetical protein P8452_05546 [Trifolium repens] | diamond | 156 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Trifolium | Trifolium repens | |
| 32456767 | 32456767 | PRJNA792582_P_NODE_29119_length_320_cov_1.246964_g28305_i0 | PRJNA792582 | 29119 | 320 | 1.246964 | 3.9902848 | Mikania micrantha | 192012 | Plants | Plants | 59.3 | 8.3e-8 | NR | KAD5316810.1 | 192012 | g28305 | i0 | 42.5 | 0.75 | 80 | 32 | 61.9 | 2 | 237 | 40 | 119 | 198 | KAD5316810.1 hypothetical protein E3N88_16756 [Mikania micrantha] | diamond | 240 | 59.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Mikania | Mikania micrantha | |
| 32560962 | 32560962 | PRJNA792582_P_NODE_55499_length_245_cov_0.895349_g54685_i0 | PRJNA792582 | 55499 | 245 | 0.895349 | 2.19360505 | Escallonia | 23075 | Plants | Plants | 63.9 | 1.31e-9 | NR | KAK2975102.1 | 112253 | g54685 | i0 | 39.2 | 9.6734693877551 | 79 | 41 | 96.7 | 2 | 245 | 9 | 268 | 339 | KAK2975102.1 hypothetical protein RJ640_018904, partial [Escallonia rubra] | diamond | 2370 | 63.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Escalloniales | Escalloniaceae | Escallonia | Escallonia rubra | |
| 32623613 | 32623613 | PRJNA792582_P_NODE_5920_length_681_cov_1.995066_g5161_i0 | PRJNA792582 | 5920 | 681 | 1.995066 | 13.58639946 | Eukaryota | 2759 | Plants | Plants | 47.4 | 0.0123 | NR | CAL9222530.1 | 81970 | g5161 | i0 | 24.7 | 2.42290748898678 | 154 | 103 | 63.9 | 3 | 545 | 111 | 7 | 156 | CAL9222530.1 unnamed protein product [Arabidopsis halleri] | diamond | 1650 | 47.8 | 0.99163179916318 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Arabidopsis | Arabidopsis halleri |
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);;