RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA722925" 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

  • PRJNA722925 · 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
5813821 5813821 PRJNA722925_S_NODE_11065_length_152_cov_1.356522_g11002_i0 PRJNA722925 11065 152 1.356522 2.06191344 Cryptomeria japonica 3369 Plants Plants 92.4 1.96e-20   NR GLJ09288.1 3369 g11002 i0 82 1.97368421052632 50 9 98.7 0 151 2 93 142 GLJ09288.1 hypothetical protein SUGI_0105700 [Cryptomeria japonica] diamond 300 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
9638782 9638782 PRJNA722925_S_NODE_7508_length_173_cov_1.713235_g7445_i0 PRJNA722925 7508 173 1.713235 2.96389655 Magnoliopsida 3398 Plants Plants 82.4 1.08e-16   NR GMN57846.1 3494 g7445 i0 64.9 16.2485549132948 57 20 98.8 0 3 173 193 249 GMN57846.1 hypothetical protein TIFTF001_026943 [Ficus carica] diamond 2811 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
26682553 26682553 PRJNA722925_S_NODE_8241_length_168_cov_1.045802_g8178_i0 PRJNA722925 8241 168 1.045802 1.75694736 Musaceae 4637 Plants Plants 61.2 3.32e-9   NR RRT35435.1 4639 g8178 i0 66.7 13.4642857142857 36 12 64.3 0 1 108 264 299 RRT35435.1 hypothetical protein B296_00059037 [Ensete ventricosum] diamond 2262 61.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Ensete Ensete ventricosum
26894072 26894072 PRJNA722925_S_NODE_10441_length_155_cov_1.161017_g10378_i0 PRJNA722925 10441 155 1.161017 1.79957635 Pinus taeda 3352 Plants Plants 43.1 0.00822   NR AZA14770.1 3352 g10378 i0 66.7 1.04516129032258 27 9 52.3 0 2 82 308 334 AZA14770.1 Fasciclin-like arabinogalactan protein 8 [Pinus taeda] diamond 162 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus taeda
27052169 27052169 PRJNA722925_S_NODE_8662_length_165_cov_0.890625_g8599_i0 PRJNA722925 8662 165 0.890625 1.46953125 Cryptomeria japonica 3369 Plants Plants 86.3 5.27e-18   NR GLJ43737.1 3369 g8599 i0 66 5.12727272727273 47 16 85.5 0 164 24 409 455 GLJ43737.1 hypothetical protein SUGI_0910690 [Cryptomeria japonica] diamond 846 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
28062725 28062725 PRJNA722925_S_NODE_7045_length_177_cov_2.107143_g6982_i0 PRJNA722925 7045 177 2.107143 3.72964311 Picea sitchensis 3332 Plants Plants 94.7 6.59e-21   NR ABR16325.1 3332 g6982 i0 79.7 3.98305084745763 59 12 100 0 177 1 51 109 ABR16325.1 unknown [Picea sitchensis] diamond 705 94.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
29294181 29294181 PRJNA722925_S_NODE_2529_length_274_cov_1.966245_g2466_i0 PRJNA722925 2529 274 1.966245 5.3875113 Papaver nudicaule 74823 Plants Plants 43.1 0.0372   NR MCL7049053.1 74823 g2466 i0 30.9 0.744525547445255 68 46 73.4 1 3 203 286 353 MCL7049053.1 hypothetical protein [Papaver nudicaule] diamond 204 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver nudicaule
29420302 29420302 PRJNA722925_S_NODE_3449_length_238_cov_1.636816_g3386_i0 PRJNA722925 3449 238 1.636816 3.89562208 Picea sitchensis 3332 Plants Plants 110 1.18e-26   NR ABK26513.1 3332 g3386 i0 64.6 0.995798319327731 79 26 97.1 1 233 3 85 163 ABK26513.1 unknown [Picea sitchensis] diamond 237 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
30157071 30157071 PRJNA722925_S_NODE_9932_length_157_cov_2.366667_g9869_i0 PRJNA722925 9932 157 2.366667 3.71566719 Magnoliopsida 3398 Plants Plants 83.6 4.42e-17   NR KAJ3695967.1 13579 g9869 i0 66.7 16.7388535031847 51 17 97.5 0 2 154 272 322 KAJ3695967.1 hypothetical protein LUZ60_001344 [Juncus effusus] diamond 2628 83.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
30842057 30842057 PRJNA722925_S_NODE_11134_length_152_cov_1.017391_g11071_i0 PRJNA722925 11134 152 1.017391 1.54643432 Hordeum vulgare subsp. vulgare 112509 Plants Plants 78.2 5.08e-16   NR BAJ97489.1 112509 g11071 i0 73.5 0.967105263157895 49 13 96.7 0 152 6 17 65 BAJ97489.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 147 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
31611243 31611243 PRJNA722925_S_NODE_8976_length_163_cov_0.928571_g8913_i0 PRJNA722925 8976 163 0.928571 1.51357073 Eukaryota 2759 Plants Plants 45.8 5.88e-4   NR CAM6002815.1 128184 g8913 i0 52.1 3.44171779141104 48 23 88.3 0 18 161 71 118 CAM6002815.1 unnamed protein product [Sphagnum balticum] diamond 561 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
31706005 31706005 PRJNA722925_S_NODE_6457_length_183_cov_1.267123_g6394_i0 PRJNA722925 6457 183 1.267123 2.31883509 Magnoliopsida 3398 Plants Plants 56.2 2.82e-7   NR XP_057547357.1 29722 g6394 i0 43.1 3.78688524590164 58 33 95.1 0 175 2 162 219 XP_057547357.1 polygalacturonase-like [Amaranthus tricolor] diamond 693 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Amaranthaceae Amaranthus Amaranthus tricolor
32391621 32391621 PRJNA722925_S_NODE_8799_length_164_cov_0.921260_g8736_i0 PRJNA722925 8799 164 0.92126 1.5108664 Picea sitchensis 3332 Plants Plants 103 6.529999999999999e-24   NR ABR18191.1 3332 g8736 i0 85.2 0.98780487804878 54 8 98.8 0 3 164 487 540 ABR18191.1 unknown [Picea sitchensis] diamond 162 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
32612854 32612854 PRJNA722925_S_NODE_2800_length_262_cov_1.924444_g2737_i0 PRJNA722925 2800 262 1.924444 5.04204328 Picea sitchensis 3332 Plants Plants 114 1.85e-27   NR ACN40196.1 3332 g2737 i0 60.4 1.04198473282443 91 32 99.6 1 261 1 159 249 ACN40196.1 unknown [Picea sitchensis] diamond 273 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
32612856 32612856 PRJNA722925_S_NODE_7380_length_174_cov_1.620438_g7317_i0 PRJNA722925 7380 174 1.620438 2.81956212 Taxus chinensis 29808 Plants Plants 82.8 1.15e-16   NR KAH9313244.1 29808 g7317 i0 80 0.862068965517241 50 10 86.2 0 150 1 20 69 KAH9313244.1 hypothetical protein KI387_028279, partial [Taxus chinensis] diamond 150 82.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
32644075 32644075 PRJNA722925_S_NODE_640_length_518_cov_10.332640_g580_i0 PRJNA722925 640 518 10.33264 53.5230752 Pinus taeda 3352 Plants Plants 46.2 0.00279   NR QDZ06024.1 3352 g580 i0 40 0.920849420849421 80 39 42.3 2 113 331 6 83 QDZ06024.1 ALLW1950 [Pinus taeda] diamond 477 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus taeda
32770178 32770178 PRJNA722925_S_NODE_200_length_848_cov_7.510481_g169_i0 PRJNA722925 200 848 7.510481 63.68887888 Cryptomeria japonica 3369 Plants Plants 135 1.68e-35   NR XP_057863391.1 3369 g169 i0 44.4 4.28419811320755 153 81 53.4 2 88 540 23 173 XP_057863391.1 TPD1 protein homolog 1 [Cryptomeria japonica] diamond 3633 135 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica

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