RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB56027" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB56027 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
6500833 6500833 PRJEB56027_P_NODE_125746_length_245_cov_0.895349_g122937_i0 PRJEB56027 125746 245 0.895349 2.19360505 Humulus lupulus 3486 Plants Plants 146 1.04e-38   NR XP_062086582.1 3486 g122937 i0 83.8 5.87755102040816 80 13 98 0 240 1 257 336 XP_062086582.1 uncharacterized protein LOC133792694 [Humulus lupulus] diamond 1440 146 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
26685267 26685267 PRJEB56027_P_NODE_85061_length_290_cov_1.419355_g82252_i0 PRJEB56027 85061 290 1.419355 4.1161295 Beta vulgaris subsp. vulgaris 3555 Plants Plants 77.4 5.78e-15   NR XP_010670308.2 3555 g82252 i0 42.6 1.0448275862069 101 47 96.2 2 287 9 29 126 XP_010670308.2 uncharacterized protein LOC104887390 [Beta vulgaris subsp. vulgaris] diamond 303 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Beta Beta vulgaris
26812100 26812100 PRJEB56027_P_NODE_117881_length_249_cov_0.875000_g115072_i0 PRJEB56027 117881 249 0.875 2.17875 Spirodela intermedia 51605 Plants Plants 42.7 0.0403   NR CAA2622183.1 51605 g115072 i0 45.5 0.530120481927711 44 24 53 0 104 235 928 971 CAA2622183.1 unnamed protein product [Spirodela intermedia] diamond 132 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Spirodela Spirodela intermedia
27065110 27065110 PRJEB56027_P_NODE_92002_length_280_cov_1.159420_g89193_i0 PRJEB56027 92002 280 1.15942 3.246376 Chara braunii 69332 Plants Plants 122 6.08e-30   NR GBG72690.1 69332 g89193 i0 65 6.35357142857143 100 25 98.6 2 1 276 1027 1124 GBG72690.1 hypothetical protein CBR_g12258 [Chara braunii] diamond 1779 122 1 Eukaryota   Viridiplantae Streptophyta Charophyceae Charales Characeae Chara Chara braunii
27065111 27065111 PRJEB56027_P_NODE_98142_length_271_cov_1.555556_g95333_i0 PRJEB56027 98142 271 1.555556 4.21555676 Cannabis sativa 3483 Plants Plants 60.8 1.45e-8   NR XP_030478046.1 3483 g95333 i0 34.6 2.690036900369 81 53 89.7 0 4 246 110 190 XP_030478046.1 protein FAR1-RELATED SEQUENCE 1-like [Cannabis sativa] diamond 729 60.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
27602466 27602466 PRJEB56027_P_NODE_104824_length_262_cov_1.629630_g102015_i0 PRJEB56027 104824 262 1.62963 4.2696306 Cannabis sativa 3483 Plants Plants 79 8.6e-15   NR XP_060974037.1 3483 g102015 i0 65 2.40458015267176 60 21 68.7 0 4 183 656 715 XP_060974037.1 uncharacterized protein LOC133039215 [Cannabis sativa] diamond 630 79 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
28644378 28644378 PRJEB56027_P_NODE_38107_length_562_cov_0.781186_g35317_i0 PRJEB56027 38107 562 0.781186 4.39026532 Vigna unguiculata 3917 Plants Plants 45.1 0.0401   NR QCE14216.1 3917 g35317 i0 38.9 0.288256227758007 54 32 28.3 1 125 283 47 100 QCE14216.1 hypothetical protein DEO72_LG11g1215 [Vigna unguiculata] diamond 162 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna unguiculata
29118051 29118051 PRJEB56027_P_NODE_127569_length_244_cov_0.900585_g124760_i0 PRJEB56027 127569 244 0.900585 2.1974274 Acer yangbiense 1000413 Plants Plants 67.4 7.47e-11   NR TXG49608.1 1000413 g124760 i0 78.6 0.516393442622951 42 9 51.6 0 221 96 258 299 TXG49608.1 hypothetical protein EZV62_025483 [Acer yangbiense] diamond 126 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
29370531 29370531 PRJEB56027_P_NODE_137969_length_226_cov_2.294118_g135160_i0 PRJEB56027 137969 226 2.294118 5.18470668 Chenopodium quinoa 63459 Plants Plants 129 1.23e-33   NR XP_021729244.1 63459 g135160 i0 77.3 0.995575221238938 75 17 99.6 0 225 1 139 213 XP_021729244.1 uncharacterized protein LOC110696272 isoform X2 [Chenopodium quinoa] diamond 225 129 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Chenopodium Chenopodium quinoa
29402001 29402001 PRJEB56027_P_NODE_88289_length_285_cov_1.452830_g85480_i0 PRJEB56027 88289 285 1.45283 4.1405655 Triticum aestivum 4565 Plants Plants 153 6.84e-41   NR BDI54545.1 4565 g85480 i0 77.2 0.968421052631579 92 21 96.8 0 281 6 783 874 BDI54545.1 nucleolar and coiled-body phosphoprotein 1-like, partial [Triticum aestivum] diamond 276 153 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
29402003 29402003 PRJEB56027_P_NODE_96369_length_274_cov_0.820896_g93560_i0 PRJEB56027 96369 274 0.820896 2.24925504 Tanacetum cinerariifolium 118510 Plants Plants 41.6 0.0403   NR GEY64073.1 118510 g93560 i0 41.2 0.558394160583942 51 29 54.7 1 244 95 47 97 GEY64073.1 hypothetical protein [Tanacetum cinerariifolium] diamond 153 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
30823475 30823475 PRJEB56027_P_NODE_81974_length_297_cov_1.044643_g79165_i0 PRJEB56027 81974 297 1.044643 3.10258971 Drosera rotundifolia 173423 Plants Plants 45.4 0.00754   NR GAB2260388.1 173423 g79165 i0 39.7 0.686868686868687 68 37 67.7 2 77 277 208 272 GAB2260388.1 hypothetical protein Droror1_Dr00011243 [Drosera rotundifolia] diamond 204 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Droseraceae Drosera Drosera rotundifolia
30855021 30855021 PRJEB56027_P_NODE_125474_length_245_cov_0.895349_g122665_i0 PRJEB56027 125474 245 0.895349 2.19360505 Morus notabilis 981085 Plants Plants 46.2 0.0022   NR EXC16208.1 981085 g122665 i0 60 0.428571428571429 35 14 42.9 0 2 106 367 401 EXC16208.1 hypothetical protein L484_024379 [Morus notabilis] diamond 105 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Morus Morus notabilis
31076357 31076357 PRJEB56027_P_NODE_118935_length_248_cov_2.228571_g116126_i0 PRJEB56027 118935 248 2.228571 5.52685608 Papaver somniferum 3469 Plants Plants 56.6 3.56e-7   NR XP_026398758.1 3469 g116126 i0 59.1 1.06451612903226 44 18 53.2 0 117 248 93 136 XP_026398758.1 uncharacterized protein LOC113294584 [Papaver somniferum] diamond 264 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver somniferum
31455740 31455740 PRJEB56027_P_NODE_108976_length_257_cov_1.298913_g106167_i0 PRJEB56027 108976 257 1.298913 3.33820641 Physcomitrium patens 3218 Plants Plants 51.2 3.89e-5   NR XP_024373065.1 3218 g106167 i0 71 2.32295719844358 31 9 36.2 0 162 254 50 80 XP_024373065.1 thiamine pyrophosphokinase 1-like [Physcomitrium patens] diamond 597 51.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
31575533 31575533 PRJEB56027_P_NODE_96556_length_273_cov_1.945000_g93747_i0 PRJEB56027 96556 273 1.945 5.30985 Moraceae 3487 Plants Plants 50.1 1.33e-4   NR GMN29384.1 3494 g93747 i0 60 3.46153846153846 40 16 44 0 137 256 266 305 GMN29384.1 hypothetical protein TIFTF001_044343, partial [Ficus carica] diamond 945 50.4 0.994047619047619 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
31803424 31803424 PRJEB56027_P_NODE_104097_length_263_cov_1.621053_g101288_i0 PRJEB56027 104097 263 1.621053 4.26336939 Acer yangbiense 1000413 Plants Plants 50.1 1.19e-4   NR TXG54160.1 1000413 g101288 i0 80.8 0.296577946768061 26 5 29.7 0 155 232 355 380 TXG54160.1 hypothetical protein EZV62_019416 [Acer yangbiense] diamond 78 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
32429692 32429692 PRJEB56027_P_NODE_121059_length_247_cov_1.724138_g118250_i0 PRJEB56027 121059 247 1.724138 4.25862086 Rosales 3744 Plants Plants 72.8 1.01e-12   NR ONI11500.1 3760 g118250 i0 42.7 3.69230769230769 75 15 91.1 1 21 245 200 246 ONI11500.1 hypothetical protein PRUPE_4G109500 [Prunus persica] diamond 912 73.2 0.994535519125683 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus persica
32429693 32429693 PRJEB56027_P_NODE_132359_length_241_cov_1.666667_g129550_i0 PRJEB56027 132359 241 1.666667 4.01666747 Sapindales 41937 Plants Plants 67.8 5.59e-11   NR XP_024037590.1 85681 g129550 i0 48.4 3.87136929460581 64 32 78.4 1 1 189 8 71 XP_024037590.1 uncharacterized protein LOC112097210 [Citrus x clementina] diamond 933 67.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x clementina
32594571 32594571 PRJEB56027_P_NODE_97460_length_272_cov_1.547739_g94651_i0 PRJEB56027 97460 272 1.547739 4.20985008 Acer saccharum 4024 Plants Plants 83.6 1.98e-16   NR KAK0576545.1 4024 g94651 i0 67.9 0.584558823529412 53 17 58.5 0 111 269 137 189 KAK0576545.1 hypothetical protein LWI29_019351 [Acer saccharum] diamond 159 83.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
32877781 32877781 PRJEB56027_P_NODE_126160_length_245_cov_0.895349_g123351_i0 PRJEB56027 126160 245 0.895349 2.19360505 Trifolium repens 3899 Plants Plants 43.9 0.0144   NR KAK2349506.1 3899 g123351 i0 32.2 0.722448979591837 59 40 72.2 0 1 177 187 245 KAK2349506.1 hypothetical protein QL285_099171 [Trifolium repens] diamond 177 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens

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