RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA492363 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
25566724 25566724 PRJNA492363_S_NODE_68737_length_224_cov_1.177914_g67916_i0 PRJNA492363 68737 224 1.177914 2.63852736 Lolium multiflorum 4521 Plants Plants 143 1.4099999999999998e-37   NR KAK1619946.1 4521 g67916 i0 98.4 12.7098214285714 63 1 84.4 0 36 224 1286 1348 KAK1619946.1 hypothetical protein QYE76_025463 [Lolium multiflorum] diamond 2847 143 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
25975738 25975738 PRJNA492363_S_NODE_95156_length_204_cov_1.132867_g94335_i0 PRJNA492363 95156 204 1.132867 2.31104868 Taxus chinensis 29808 Plants Plants 68.6 4.69e-12   NR KAH9327910.1 29808 g94335 i0 47.8 1.97058823529412 67 35 98.5 0 1 201 55 121 KAH9327910.1 hypothetical protein KI387_000018, partial [Taxus chinensis] diamond 402 68.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
26110644 26110644 PRJNA492363_S_NODE_26333_length_243_cov_1.675824_g25512_i0 PRJNA492363 26333 243 1.675824 4.07225232 Cryptomeria japonica 3369 Plants Plants 81.3 1.09e-17   NR GLJ18487.1 3369 g25512 i0 56.3 0.790123456790123 64 28 79 0 222 31 24 87 GLJ18487.1 hypothetical protein SUGI_0328130 [Cryptomeria japonica] diamond 192 81.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
26247952 26247952 PRJNA492363_S_NODE_9382_length_313_cov_0.904762_g8561_i0 PRJNA492363 9382 313 0.904762 2.83190506 Streptophyta 35493 Plants Plants 139 3.83e-39   NR XP_006854038.1 13333 g8561 i0 64.6 46.4856230031949 99 35 94.9 0 299 3 50 148 XP_006854038.1 60S ribosomal protein L9 [Amborella trichopoda] diamond 14550 140 0.992857142857143 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Amborellales Amborellaceae Amborella Amborella trichopoda
32917976 32917976 PRJNA492363_S_NODE_10041_length_304_cov_1.316872_g9220_i0 PRJNA492363 10041 304 1.316872 4.00329088 Trifolium pratense 57577 Plants Plants 192 7.889999999999999e-55   NR XP_045791326.1 57577 g9220 i0 89.1 6.96710526315789 101 11 99.7 0 1 303 110 210 XP_045791326.1 uncharacterized protein LOC123886035 [Trifolium pratense] diamond 2118 192 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium pratense
32935407 32935407 PRJNA492363_S_NODE_97137_length_203_cov_0.901408_g96316_i0 PRJNA492363 97137 203 0.901408 1.82985824 Dipteronia dyeriana 168575 Plants Plants 60.8 9.08e-9   NR KAK2642011.1 168575 g96316 i0 49.3 3.47290640394089 67 25 99 2 203 3 1048 1105 KAK2642011.1 hypothetical protein Ddye_023774 [Dipteronia dyeriana] diamond 705 60.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia dyeriana
33003711 33003711 PRJNA492363_S_NODE_91395_length_206_cov_1.324138_g90574_i0 PRJNA492363 91395 206 1.324138 2.72772428 Paspalum notatum var. saurae 547442 Plants Plants 82.4 1.63e-16   NR WVZ90986.1 547442 g90574 i0 60.3 2.53398058252427 58 23 84.5 0 30 203 159 216 WVZ90986.1 hypothetical protein U9M48_037223 [Paspalum notatum var. saurae] diamond 522 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
33037825 33037825 PRJNA492363_S_NODE_8516_length_324_cov_2.494297_g7695_i0 PRJNA492363 8516 324 2.494297 8.08152228 Sphagnum jensenii 128206 Plants Plants 50.1 2.33e-4   NR CAK9253046.1 128206 g7695 i0 42.6 0.5 54 30 50 1 233 72 314 366 CAK9253046.1 unnamed protein product [Sphagnum jensenii] diamond 162 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
33037886 33037886 PRJNA492363_S_NODE_9532_length_311_cov_1.528000_g8711_i0 PRJNA492363 9532 311 1.528 4.75208 Taxus chinensis 29808 Plants Plants 196 2.8399999999999997e-61   NR KAH9321540.1 29808 g8711 i0 97.9 0.935691318327974 97 2 93.6 0 293 3 1 97 KAH9321540.1 hypothetical protein KI387_016179 [Taxus chinensis] diamond 291 196 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
33054880 33054880 PRJNA492363_S_NODE_88117_length_208_cov_0.870748_g87296_i0 PRJNA492363 88117 208 0.870748 1.81115584 Lolium multiflorum 4521 Plants Plants 47 7.63e-4   NR KAK1665474.1 4521 g87296 i0 56.8 0.634615384615385 44 13 63.5 1 35 166 539 576 KAK1665474.1 hypothetical protein QYE76_053633 [Lolium multiflorum] diamond 132 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
33071703 33071703 PRJNA492363_S_NODE_16309_length_254_cov_1.326425_g15488_i0 PRJNA492363 16309 254 1.326425 3.3691195 Camellia sinensis 4442 Plants Plants 45.4 0.00491   NR KAF5936049.1 4442 g15488 i0 52.1 0.566929133858268 48 23 56.7 0 144 1 121 168 KAF5936049.1 hypothetical protein HYC85_027178 [Camellia sinensis] diamond 144 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
33071907 33071907 PRJNA492363_S_NODE_98765_length_202_cov_1.361702_g97944_i0 PRJNA492363 98765 202 1.361702 2.75063804 Cryptomeria japonica 3369 Plants Plants 108 1.47e-25   NR GLJ37399.1 3369 g97944 i0 80.6 2.98514851485149 67 13 99.5 0 201 1 244 310 GLJ37399.1 hypothetical protein SUGI_0759290 [Cryptomeria japonica] diamond 603 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
33088982 33088982 PRJNA492363_S_NODE_67038_length_225_cov_1.512195_g66217_i0 PRJNA492363 67038 225 1.512195 3.40243875 Gossypium hirsutum 3635 Plants Plants 43.5 0.0155   NR XP_016755333.1 3635 g66217 i0 36.4 2.04 55 34 73.3 1 225 61 107 160 XP_016755333.1 uncharacterized protein [Gossypium hirsutum] diamond 459 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
33105988 33105988 PRJNA492363_S_NODE_41678_length_236_cov_2.114286_g40857_i0 PRJNA492363 41678 236 2.114286 4.98971496 Taxus chinensis 29808 Plants Plants 45.8 5.35e-4   NR KAH9315679.1 29808 g40857 i0 34.8 1.95762711864407 69 40 81.4 1 29 220 17 85 KAH9315679.1 hypothetical protein KI387_024306, partial [Taxus chinensis] diamond 462 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
33111982 33111982 PRJNA492363_S_NODE_96942_length_203_cov_1.352113_g96121_i0 PRJNA492363 96942 203 1.352113 2.74478939 Poaceae 4479 Plants Plants 62.4 2.57e-9   NR XP_044378721.1 4565 g96121 i0 53.1 2.23152709359606 49 23 72.4 0 192 46 619 667 XP_044378721.1 uncharacterized protein LOC123101257 [Triticum aestivum] diamond 453 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
33123117 33123117 PRJNA492363_S_NODE_93151_length_205_cov_1.333333_g92330_i0 PRJNA492363 93151 205 1.333333 2.73333265 Cryptomeria japonica 3369 Plants Plants 105 1.4199999999999999e-25   NR XP_059073404.1 3369 g92330 i0 78.3 2.00487804878049 69 14 99.5 1 205 2 60 128 XP_059073404.1 uncharacterized mitochondrial protein AtMg00810-like [Cryptomeria japonica] diamond 411 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
33129147 33129147 PRJNA492363_S_NODE_61399_length_228_cov_1.532934_g60578_i0 PRJNA492363 61399 228 1.532934 3.49508952 Eukaryota 2759 Plants Plants 55.1 1.39e-6   NR GAV76217.1 3775 g60578 i0 39.4 4.71052631578947 71 37 92.1 3 1 210 37 102 GAV76217.1 SET domain-containing protein/zf-MYND domain-containing protein [Cephalotus follicularis] diamond 1074 55.5 0.992792792792793 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Oxalidales Cephalotaceae Cephalotus Cephalotus follicularis
33129156 33129156 PRJNA492363_S_NODE_74551_length_220_cov_2.515723_g73730_i0 PRJNA492363 74551 220 2.515723 5.5345906 Lamiales 4143 Plants Plants 107 2.15e-25   NR CAI9775472.1 56036 g73730 i0 98.2 5.59090909090909 57 1 77.7 0 219 49 433 489 CAI9775472.1 unnamed protein product [Fraxinus pennsylvanica] diamond 1230 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
33139945 33139945 PRJNA492363_S_NODE_100751_length_201_cov_1.371429_g99930_i0 PRJNA492363 100751 201 1.371429 2.75657229 Punica granatum 22663 Plants Plants 60.1 1.68e-8   NR PKI48058.1 22663 g99930 i0 44.8 2.88059701492537 67 31 100 1 201 1 319 379 PKI48058.1 hypothetical protein CRG98_031575 [Punica granatum] diamond 579 60.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Lythraceae Punica Punica granatum
33174447 33174447 PRJNA492363_S_NODE_89624_length_207_cov_1.315068_g88803_i0 PRJNA492363 89624 207 1.315068 2.72219076 Cryptomeria japonica 3369 Plants Plants 47.8 2.35e-4   NR XP_059070347.1 3369 g88803 i0 60.5 0.550724637681159 38 15 55.1 0 117 4 135 172 XP_059070347.1 uncharacterized protein LOC131860019 [Cryptomeria japonica] diamond 114 47.8 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);;