RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA358009 · 25 ✖

analysis 1

  • diamond · 25 ✖
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
14427146 14427146 PRJNA358009_P_NODE_8872_length_189_cov_5.028571_g8803_i0 PRJNA358009 8872 189 5.028571 9.50399919 Picea sitchensis 3332 Plants Plants 90.1 6.94e-20   NR ABK23131.1 3332 g8803 i0 87.8 0.777777777777778 49 6 77.8 0 17 163 104 152 ABK23131.1 unknown [Picea sitchensis] diamond 147 90.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
18249766 18249766 PRJNA358009_P_NODE_10015_length_182_cov_4.563910_g9946_i0 PRJNA358009 10015 182 4.56391 8.3063162 Forsythia ovata 205694 Plants Plants 94.4 2.5300000000000003e-21   NR KAL2536726.1 205694 g9946 i0 74.6 4.87912087912088 59 15 97.3 0 182 6 199 257 KAL2536726.1 Polygalacturonase QRT2 [Forsythia ovata] diamond 888 94.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
20199116 20199116 PRJNA358009_P_NODE_5916_length_327_cov_1.600719_g5853_i0 PRJNA358009 5916 327 1.600719 5.23435113 Picea sitchensis 3332 Plants Plants 73.6 1.4e-12   NR ABK26513.1 3332 g5853 i0 41.9 0.963302752293578 105 55 96.3 1 315 1 195 293 ABK26513.1 unknown [Picea sitchensis] diamond 315 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
23350249 23350249 PRJNA358009_P_NODE_16579_length_160_cov_4.846847_g16510_i0 PRJNA358009 16579 160 4.846847 7.7549552 Lolium multiflorum 4521 Plants Plants 114 7.16e-28   NR KAK1678999.1 4521 g16510 i0 100 17.55 52 0 97.5 0 160 5 352 403 KAK1678999.1 hypothetical protein QYE76_039847 [Lolium multiflorum] diamond 2808 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
27738579 27738579 PRJNA358009_P_NODE_6084_length_327_cov_1.550360_g6021_i0 PRJNA358009 6084 327 1.55036 5.0696772 Acer yangbiense 1000413 Plants Plants 62.4 1.1e-8   NR TXG55485.1 1000413 g6021 i0 96.9 0.293577981651376 32 1 29.4 0 230 325 32 63 TXG55485.1 hypothetical protein EZV62_020741 [Acer yangbiense] diamond 96 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
28496156 28496156 PRJNA358009_P_NODE_17287_length_157_cov_2.583333_g17218_i0 PRJNA358009 17287 157 2.583333 4.05583281 Aegilops tauschii subsp. strangulata 200361 Plants Plants 73.2 2.06e-13   NR XP_040256311.1 200361 g17218 i0 75.5 0.936305732484076 49 12 93.6 0 149 3 25 73 XP_040256311.1 enolase-phosphatase E1-like [Aegilops tauschii subsp. strangulata] diamond 147 73.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
28653915 28653915 PRJNA358009_P_NODE_8747_length_190_cov_3.347518_g8678_i0 PRJNA358009 8747 190 3.347518 6.3602842 Dipteronia dyeriana 168575 Plants Plants 62 2.96e-9   NR KAK2641889.1 168575 g8678 i0 68.3 1.26315789473684 41 13 64.7 0 183 61 7 47 KAK2641889.1 hypothetical protein Ddye_023652 [Dipteronia dyeriana] diamond 240 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia dyeriana
29001601 29001601 PRJNA358009_P_NODE_4368_length_327_cov_2.158273_g4305_i0 PRJNA358009 4368 327 2.158273 7.05755271 Pinus taeda 3352 Plants Plants 45.1 0.00373   NR QDZ06029.1 3352 g4305 i0 77.3 0.201834862385321 22 5 20.2 0 296 231 74 95 QDZ06029.1 polygalacturonase [Pinus taeda] diamond 66 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus taeda
29159256 29159256 PRJNA358009_P_NODE_10309_length_180_cov_6.305344_g10240_i0 PRJNA358009 10309 180 6.305344 11.3496192 Ensete ventricosum 4639 Plants Plants 57.8 7.74e-8   NR RWW46034.1 4639 g10240 i0 55.9 2.95 59 24 95 2 8 178 240 298 RWW46034.1 hypothetical protein BHE74_00048088 [Ensete ventricosum] diamond 531 57.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Ensete Ensete ventricosum
29316934 29316934 PRJNA358009_P_NODE_16689_length_159_cov_26.100000_g16620_i0 PRJNA358009 16689 159 26.1 41.499 Castanea mollissima 60419 Plants Plants 69.3 1.29e-12   NR KAF3969285.1 60419 g16620 i0 61.7 1.77358490566038 47 14 88.7 1 8 148 174 216 KAF3969285.1 hypothetical protein CMV_006911 [Castanea mollissima] diamond 282 69.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Castanea Castanea mollissima
29380079 29380079 PRJNA358009_P_NODE_17529_length_156_cov_2.439252_g17460_i0 PRJNA358009 17529 156 2.439252 3.80523312 Triticum aestivum 4565 Plants Plants 69.3 4.68e-12   NR XP_044378721.1 4565 g17460 i0 57.1 2.82692307692308 49 21 94.2 0 149 3 376 424 XP_044378721.1 uncharacterized protein LOC123101257 [Triticum aestivum] diamond 441 69.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
30201001 30201001 PRJNA358009_P_NODE_1492_length_343_cov_3.013605_g1431_i0 PRJNA358009 1492 343 3.013605 10.33666515 Taxus chinensis 29808 Plants Plants 76.6 1.55e-13   NR KAH9321004.1 29808 g1431 i0 43.5 0.944606413994169 108 60 94.5 1 326 3 1087 1193 KAH9321004.1 hypothetical protein KI387_015643, partial [Taxus chinensis] diamond 324 76.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
30232814 30232814 PRJNA358009_P_NODE_5832_length_327_cov_1.625899_g5769_i0 PRJNA358009 5832 327 1.625899 5.31668973 Castanea mollissima 60419 Plants Plants 49.7 7.5e-5   NR KAF3945936.1 60419 g5769 i0 82.1 0.256880733944954 28 5 25.7 0 91 8 36 63 KAF3945936.1 hypothetical protein CMV_027738, partial [Castanea mollissima] diamond 84 49.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Castanea Castanea mollissima
30801434 30801434 PRJNA358009_P_NODE_10254_length_181_cov_2.136364_g10185_i0 PRJNA358009 10254 181 2.136364 3.86681884 Cryptomeria japonica 3369 Plants Plants 77 1.3e-14   NR XP_059076672.1 3369 g10185 i0 54.7 0.878453038674033 53 24 87.8 0 177 19 216 268 XP_059076672.1 uncharacterized protein LOC131875950 [Cryptomeria japonica] diamond 159 77 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
30801441 30801441 PRJNA358009_P_NODE_4734_length_327_cov_2.010791_g4671_i0 PRJNA358009 4734 327 2.010791 6.57528657 Triticum aestivum 4565 Plants Plants 47 0.00254   NR XP_044460197.1 4565 g4671 i0 80 0.275229357798165 30 6 27.5 0 12 101 48 77 XP_044460197.1 uncharacterized protein LOC123191586 [Triticum aestivum] diamond 90 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
30991240 30991240 PRJNA358009_P_NODE_4014_length_327_cov_2.312950_g3951_i0 PRJNA358009 4014 327 2.31295 7.5633465 Smallanthus sonchifolius 185202 Plants Plants 55.1 4.72e-6   NR KAI3799072.1 185202 g3951 i0 85.7 0.256880733944954 28 4 25.7 0 7 90 605 632 KAI3799072.1 hypothetical protein L1987_34362 [Smallanthus sonchifolius] diamond 84 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
31022772 31022772 PRJNA358009_P_NODE_3195_length_327_cov_2.834532_g3132_i0 PRJNA358009 3195 327 2.834532 9.26891964 Quercus rubra 3512 Plants Plants 73.6 8.83e-14   NR KAK4594628.1 3512 g3132 i0 100 0.293577981651376 32 0 29.4 0 100 5 95 126 KAK4594628.1 hypothetical protein RGQ29_018349 [Quercus rubra] diamond 96 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
31180352 31180352 PRJNA358009_P_NODE_17215_length_157_cov_4.027778_g17146_i0 PRJNA358009 17215 157 4.027778 6.32361146 Taxus chinensis 29808 Plants Plants 73.6 4.82e-14   NR KAH9310847.1 29808 g17146 i0 68 0.955414012738854 50 16 95.5 0 3 152 56 105 KAH9310847.1 hypothetical protein KI387_025882 [Taxus chinensis] diamond 150 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
32097943 32097943 PRJNA358009_P_NODE_3878_length_327_cov_2.392086_g3815_i0 PRJNA358009 3878 327 2.392086 7.82212122 Pinus tabuliformis 88731 Plants Plants 53.5 1.36e-6   NR AJA33577.1 88731 g3815 i0 90.3 0.284403669724771 31 3 28.4 0 325 233 6 36 AJA33577.1 late embryogenesis abundant protein LEA4-2 [Pinus tabuliformis] diamond 93 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus tabuliformis
32115280 32115280 PRJNA358009_P_NODE_4338_length_327_cov_2.169065_g4275_i0 PRJNA358009 4338 327 2.169065 7.09284255 Streptophyta 35493 Plants Plants 68.2 1.21e-10   NR GLJ46536.1 3369 g4275 i0 84.8 3.63302752293578 33 5 30.3 0 100 2 1038 1070 GLJ46536.1 hypothetical protein SUGI_0980760 [Cryptomeria japonica] diamond 1188 68.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
32224683 32224683 PRJNA358009_P_NODE_13838_length_165_cov_4.068966_g13769_i0 PRJNA358009 13838 165 4.068966 6.7137939 Lolium perenne 4522 Plants Plants 80.5 6.28e-16   NR XP_051221962.1 4522 g13769 i0 73.6 0.963636363636364 53 14 96.4 0 164 6 784 836 XP_051221962.1 uncharacterized protein LOC127340226 [Lolium perenne] diamond 159 80.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium perenne
32319851 32319851 PRJNA358009_P_NODE_17319_length_157_cov_2.055556_g17250_i0 PRJNA358009 17319 157 2.055556 3.22722292 Capsicum annuum 4072 Plants Plants 57 1.04e-7   NR KAF3669085.1 4072 g17250 i0 70.6 1.94904458598726 34 10 65 0 54 155 1635 1668 KAF3669085.1 hypothetical protein FXO38_07760 [Capsicum annuum] diamond 306 57 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum annuum
32319854 32319854 PRJNA358009_P_NODE_4719_length_327_cov_2.014388_g4656_i0 PRJNA358009 4719 327 2.014388 6.58704876 Dipteronia sinensis 43782 Plants Plants 62.4 3.72e-9   NR KAK3204930.1 43782 g4656 i0 87.9 0.908256880733945 33 4 30.3 0 326 228 87 119 KAK3204930.1 hypothetical protein Dsin_018976 [Dipteronia sinensis] diamond 297 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia sinensis
32446291 32446291 PRJNA358009_P_NODE_16799_length_159_cov_4.209091_g16730_i0 PRJNA358009 16799 159 4.209091 6.69245469 Aegilops tauschii subsp. strangulata 200361 Plants Plants 54.7 7.07e-7   NR XP_020172929.1 200361 g16730 i0 60.4 3.64150943396226 48 19 90.6 0 12 155 10 57 XP_020172929.1 dynactin subunit 1-like [Aegilops tauschii subsp. strangulata] diamond 579 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
32541232 32541232 PRJNA358009_P_NODE_6879_length_317_cov_2.350746_g6816_i0 PRJNA358009 6879 317 2.350746 7.45186482 Taxus chinensis 29808 Plants Plants 124 2.7699999999999997e-30   NR KAH9299881.1 29808 g6816 i0 58.3 5.84858044164038 103 43 97.5 0 2 310 185 287 KAH9299881.1 hypothetical protein KI387_044104 [Taxus chinensis] diamond 1854 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis

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