RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 17 ✖

bioproject 1

  • PRJNA1004255 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26615317 26615317 PRJNA1004255_S_NODE_8901_length_211_cov_3.785714_g8693_i0 PRJNA1004255 8901 211 3.785714 7.98785654 Magnoliopsida 3398 Plants Plants 62 5.26e-10   NR KAG5588365.1 4109 g8693 i0 39.7 2.91469194312796 73 37 93.8 1 1 198 63 135 KAG5588365.1 hypothetical protein H5410_048799 [Solanum commersonii] diamond 615 62.4 0.993589743589744 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum commersonii
27160598 27160598 PRJNA1004255_S_NODE_8162_length_219_cov_2.732955_g7954_i0 PRJNA1004255 8162 219 2.732955 5.98517145 Drosera rotundifolia 173423 Plants Plants 42.4 0.0367   NR GAB2240311.1 173423 g7954 i0 51.4 0.506849315068493 37 17 49.3 1 128 21 245 281 GAB2240311.1 hypothetical protein Droror1_Dr00020829 [Drosera rotundifolia] diamond 111 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Droseraceae Drosera Drosera rotundifolia
27192346 27192346 PRJNA1004255_S_NODE_5002_length_263_cov_3.204545_g4794_i0 PRJNA1004255 5002 263 3.204545 8.42795335 Carpinus fangiana 176857 Plants Plants 58.5 4.65e-9   NR KAE7996271.1 176857 g4794 i0 70.6 0.387832699619772 34 10 38.8 0 2 103 45 78 KAE7996271.1 hypothetical protein FH972_001005 [Carpinus fangiana] diamond 102 58.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
28171462 28171462 PRJNA1004255_S_NODE_11006_length_193_cov_0.940000_g10798_i0 PRJNA1004255 11006 193 0.94 1.8142 Anisodus tanguticus 243964 Plants Plants 41.6 0.0489   NR KAK4336818.1 243964 g10798 i0 43.6 0.854922279792746 55 29 82.4 1 27 185 482 536 KAK4336818.1 hypothetical protein RND71_043697 [Anisodus tanguticus] diamond 165 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Anisodus Anisodus tanguticus
28258628 28258628 PRJNA1004255_S_NODE_1646_length_380_cov_4.727003_g1438_i0 PRJNA1004255 1646 380 4.727003 17.9626114 Oleaceae 4144 Plants Plants 99 4.75e-22   NR CAI9778164.1 56036 g1438 i0 80.3 1.12894736842105 71 12 54.5 1 379 173 237 307 CAI9778164.1 unnamed protein product [Fraxinus pennsylvanica] diamond 429 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
28360807 28360807 PRJNA1004255_S_NODE_2106_length_350_cov_4.837134_g1898_i0 PRJNA1004255 2106 350 4.837134 16.929969 Eucalyptus grandis 71139 Plants Plants 98.6 3.9399999999999996e-23   NR KAK3407144.1 71139 g1898 i0 54.2 0.917142857142857 107 44 87.4 1 1 306 65 171 KAK3407144.1 hypothetical protein EUGRSUZ_K03246 [Eucalyptus grandis] diamond 321 98.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Myrtaceae Eucalyptus Eucalyptus grandis
28676808 28676808 PRJNA1004255_S_NODE_4227_length_279_cov_3.461864_g4019_i0 PRJNA1004255 4227 279 3.461864 9.65860056 Striga hermonthica 68872 Plants Plants 70.9 4.63e-13   NR CAA0817128.1 68872 g4019 i0 40.8 0.817204301075269 76 38 78.5 2 16 234 78 149 CAA0817128.1 Plant self-incompatibility protein S1 family [Striga hermonthica] diamond 228 70.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
28834532 28834532 PRJNA1004255_S_NODE_6768_length_235_cov_3.916667_g6560_i0 PRJNA1004255 6768 235 3.916667 9.20416745 Dorcoceras hygrometricum 472368 Plants Plants 138 1.5e-36   NR KZV57879.1 472368 g6560 i0 85.9 2.98723404255319 78 11 99.6 0 2 235 162 239 KZV57879.1 sugar transport protein 10-like [Dorcoceras hygrometricum] diamond 702 138 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Gesneriaceae Dorcoceras Dorcoceras hygrometricum
28992745 28992745 PRJNA1004255_S_NODE_1388_length_403_cov_5.122222_g1180_i0 PRJNA1004255 1388 403 5.122222 20.64255466 Castilleja foliolosa 1961234 Plants Plants 124 2.68e-33   NR KAL3615127.1 1961234 g1180 i0 56.6 1.64516129032258 113 47 83.4 2 3 338 56 167 KAL3615127.1 hypothetical protein CASFOL_040788 [Castilleja foliolosa] diamond 663 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Castilleja Castilleja foliolosa
30785303 30785303 PRJNA1004255_S_NODE_5614_length_252_cov_7.334928_g5406_i0 PRJNA1004255 5614 252 7.334928 18.48401856 Lamiales 4143 Plants Plants 52 8.43e-6   NR CAI9775829.1 56036 g5406 i0 43.1 2.69047619047619 58 32 67.9 1 1 171 109 166 CAI9775829.1 unnamed protein product [Fraxinus pennsylvanica] diamond 678 52.4 0.99236641221374 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
31013894 31013894 PRJNA1004255_S_NODE_6955_length_233_cov_0.989474_g6747_i0 PRJNA1004255 6955 233 0.989474 2.30547442 Bienertia sinuspersici 338654 Plants Plants 124 5.9999999999999997e-33   NR KAL2933396.1 338654 g6747 i0 70.5 3.9656652360515 78 22 99.1 1 231 1 81 158 KAL2933396.1 Expansin-A32 [Bienertia sinuspersici] diamond 924 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Bienertia Bienertia sinuspersici
31393442 31393442 PRJNA1004255_S_NODE_18176_length_153_cov_1.281818_g17968_i0 PRJNA1004255 18176 153 1.281818 1.96118154 Dorcoceras hygrometricum 472368 Plants Plants 53.9 1.21e-6   NR KZV41175.1 472368 g17968 i0 80 0.588235294117647 30 6 58.8 0 151 62 412 441 KZV41175.1 hypothetical protein F511_10309 [Dorcoceras hygrometricum] diamond 90 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Gesneriaceae Dorcoceras Dorcoceras hygrometricum
31804330 31804330 PRJNA1004255_S_NODE_3997_length_284_cov_3.751037_g3789_i0 PRJNA1004255 3997 284 3.751037 10.65294508 Rhododendron williamsianum 262921 Plants Plants 142 8.06e-41   NR KAE9447494.1 262921 g3789 i0 67.4 8.69366197183099 92 28 95.1 2 284 15 75 166 KAE9447494.1 hypothetical protein C3L33_20608, partial [Rhododendron williamsianum] diamond 2469 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Rhododendron Rhododendron williamsianum
32215858 32215858 PRJNA1004255_S_NODE_13078_length_178_cov_7.977778_g12870_i0 PRJNA1004255 13078 178 7.977778 14.20044484 Cucumis melo var. makuwa 1194695 Plants Plants 80.9 5.64e-16   NR KAA0037057.1 1194695 g12870 i0 55.9 20.8820224719101 59 26 99.4 0 2 178 227 285 KAA0037057.1 Ty3/gypsy retrotransposon protein [Cucumis melo var. makuwa] diamond 3717 80.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis melo
32303553 32303553 PRJNA1004255_S_NODE_2199_length_345_cov_4.572848_g1991_i0 PRJNA1004255 2199 345 4.572848 15.7763256 Lamiales 4143 Plants Plants 51.6 5.4e-6   NR CAA0824520.1 68872 g1991 i0 60.9 0.826086956521739 46 16 40 1 345 208 29 72 CAA0824520.1 RPM1-interacting protein 4 (RIN4) family protein [Striga hermonthica] diamond 285 52 0.992307692307692 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga hermonthica
32405708 32405708 PRJNA1004255_S_NODE_3279_length_303_cov_4.411538_g3071_i0 PRJNA1004255 3279 303 4.411538 13.36696014 Handroanthus impetiginosus 429701 Plants Plants 160 1.15e-45   NR PIN11761.1 429701 g3071 i0 72.3 3 101 28 100 0 1 303 278 378 PIN11761.1 Pectate lyase [Handroanthus impetiginosus] diamond 909 160 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Bignoniaceae Handroanthus Handroanthus impetiginosus
32847153 32847153 PRJNA1004255_S_NODE_2120_length_349_cov_9.330065_g1912_i0 PRJNA1004255 2120 349 9.330065 32.56192685 Sphagnum magellanicum 128215 Plants Plants 113 3.68e-30   NR KAH9538044.1 128215 g1912 i0 72.3 0.713467048710602 83 23 71.3 0 349 101 8 90 KAH9538044.1 hypothetical protein CY35_16G084200 [Sphagnum magellanicum] diamond 249 113 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum magellanicum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;