RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1188114" 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 · 16 ✖

bioproject 1

  • PRJNA1188114 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
21996777 21996777 PRJNA1188114_P_NODE_8578_length_181_cov_1.628788_g8526_i0 PRJNA1188114 8578 181 1.628788 2.94810628 Lotus japonicus 34305 Plants Plants 110 1.48e-28   NR AFK46383.1 34305 g8526 i0 93.2 0.977900552486188 59 4 97.8 0 179 3 13 71 AFK46383.1 unknown [Lotus japonicus] diamond 177 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
26914080 26914080 PRJNA1188114_P_NODE_7122_length_187_cov_1.340580_g7070_i0 PRJNA1188114 7122 187 1.34058 2.5068846 Humulus lupulus 3486 Plants Plants 90.1 3.58e-19   NR XP_062094769.1 3486 g7070 i0 75.4 2.90374331550802 61 15 97.9 0 187 5 83 143 XP_062094769.1 uncharacterized protein LOC133800750 isoform X1 [Humulus lupulus] diamond 543 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
27167002 27167002 PRJNA1188114_P_NODE_15382_length_164_cov_1.495652_g15330_i0 PRJNA1188114 15382 164 1.495652 2.45286928 Humulus lupulus 3486 Plants Plants 62.8 1.07e-9   NR XP_062081184.1 3486 g15330 i0 66 2.81707317073171 50 17 91.5 0 152 3 236 285 XP_062081184.1 uncharacterized protein LOC133785989 [Humulus lupulus] diamond 462 62.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
27451813 27451813 PRJNA1188114_P_NODE_19963_length_161_cov_0.910714_g19911_i0 PRJNA1188114 19963 161 0.910714 1.46624954 Nymphaea colorata 210225 Plants Plants 45.8 9.81e-4   NR VVW88205.1 210225 g19911 i0 47.1 1.90062111801242 51 25 95 1 158 6 145 193 VVW88205.1 unnamed protein product, partial [Nymphaea colorata] diamond 306 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28051450 28051450 PRJNA1188114_P_NODE_13365_length_166_cov_0.871795_g13313_i0 PRJNA1188114 13365 166 0.871795 1.4471797 Humulus lupulus 3486 Plants Plants 62 2.04e-9   NR XP_062079226.1 3486 g13313 i0 60 0.903614457831325 50 20 90.4 0 3 152 346 395 XP_062079226.1 uncharacterized protein LOC133783591 [Humulus lupulus] diamond 150 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
28146405 28146405 PRJNA1188114_P_NODE_11925_length_167_cov_1.728814_g11873_i0 PRJNA1188114 11925 167 1.728814 2.88711938 Ilex paraguariensis 185542 Plants Plants 42.4 0.00666   NR CAK9173692.1 185542 g11873 i0 47.4 0.682634730538922 38 20 68.3 0 141 28 30 67 CAK9173692.1 unnamed protein product [Ilex paraguariensis] diamond 114 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Aquifoliales Aquifoliaceae Ilex Ilex paraguariensis
28304056 28304056 PRJNA1188114_P_NODE_7266_length_186_cov_1.912409_g7214_i0 PRJNA1188114 7266 186 1.912409 3.55708074 Phyllostachys edulis 38705 Plants Plants 55.5 4.57e-7   NR CCI55288.1 38705 g7214 i0 60 0.725806451612903 45 18 72.6 0 184 50 107 151 CCI55288.1 PH01B001G05.11 [Phyllostachys edulis] diamond 135 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
28304057 28304057 PRJNA1188114_P_NODE_8466_length_182_cov_1.142857_g8414_i0 PRJNA1188114 8466 182 1.142857 2.07999974 Hordeum vulgare subsp. vulgare 112509 Plants Plants 109 4.94e-26   NR BAK02351.1 112509 g8414 i0 93.3 0.989010989010989 60 4 98.9 0 2 181 295 354 BAK02351.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 180 109 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
28430471 28430471 PRJNA1188114_P_NODE_2986_length_252_cov_0.852217_g2934_i0 PRJNA1188114 2986 252 0.852217 2.14758684 Cannabis sativa 3483 Plants Plants 48.1 5.17e-4   NR KAF4368741.1 3483 g2934 i0 39.3 2.17857142857143 61 28 64.3 2 32 193 485 543 KAF4368741.1 hypothetical protein G4B88_003614 [Cannabis sativa] diamond 549 48.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
28620003 28620003 PRJNA1188114_P_NODE_13627_length_166_cov_0.871795_g13575_i0 PRJNA1188114 13627 166 0.871795 1.4471797 Sphagnum fallax 53036 Plants Plants 93.2 2.24e-20   NR KAH8945133.1 53036 g13575 i0 80 0.993975903614458 55 11 99.4 0 165 1 1304 1358 KAH8945133.1 hypothetical protein BDL97_12G024000 [Sphagnum fallax] diamond 165 93.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum fallax
29219873 29219873 PRJNA1188114_P_NODE_20509_length_152_cov_4.825243_g20457_i0 PRJNA1188114 20509 152 4.825243 7.33436936 Ficus carica 3494 Plants Plants 87.8 1.31e-18   NR GMN62847.1 3494 g20457 i0 88.6 0.868421052631579 44 5 86.8 0 152 21 266 309 GMN62847.1 hypothetical protein TIFTF001_031934 [Ficus carica] diamond 132 87.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
30609324 30609324 PRJNA1188114_P_NODE_7673_length_185_cov_1.198529_g7621_i0 PRJNA1188114 7673 185 1.198529 2.21727865 Hordeum vulgare subsp. vulgare 112509 Plants Plants 114 3.0099999999999993e-28   NR BAJ93616.1 112509 g7621 i0 96.7 0.989189189189189 61 2 98.9 0 3 185 66 126 BAJ93616.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 183 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30881213 30881213 PRJNA1188114_P_NODE_15274_length_164_cov_1.773913_g15222_i0 PRJNA1188114 15274 164 1.773913 2.90921732 Eukaryota 2759 Plants Plants 45.1 0.00197   NR XBI54775.1 4565 g15222 i0 61.5 3.67682926829268 26 10 47.6 0 116 39 224 249 XBI54775.1 hypothetical protein VPH35_036721 [Triticum aestivum] diamond 603 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
31589527 31589527 PRJNA1188114_P_NODE_1776_length_319_cov_1.807407_g1724_i0 PRJNA1188114 1776 319 1.807407 5.76562833 Hordeum vulgare subsp. vulgare 112509 Plants Plants 57.8 1.1e-8   NR BAJ98492.1 112509 g1724 i0 65.9 0.385579937304075 41 14 38.6 0 282 160 9 49 BAJ98492.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 123 57.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
31715855 31715855 PRJNA1188114_P_NODE_13677_length_166_cov_0.871795_g13625_i0 PRJNA1188114 13677 166 0.871795 1.4471797 Olea europaea subsp. europaea 158383 Plants Plants 77.4 7.95e-15   NR CAA2977086.1 158383 g13625 i0 69.1 1.89759036144578 55 17 99.4 0 2 166 222 276 CAA2977086.1 hypothetical protein ABT39_MTgene2668 (mitochondrion), partial [Olea europaea subsp. europaea] diamond 315 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31873964 31873964 PRJNA1188114_P_NODE_11337_length_170_cov_1.264463_g11285_i0 PRJNA1188114 11337 170 1.264463 2.1495871 Sphagnum balticum 128184 Plants Plants 77 2.18e-15   NR CAM6002349.1 128184 g11285 i0 57.1 0.988235294117647 56 24 98.8 0 3 170 72 127 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 168 77 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum

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