RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1226487 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
20736326 20736326 PRJNA1226487_P_NODE_14577_length_397_cov_4.728395_g14475_i0 PRJNA1226487 14577 397 4.728395 18.77172815 Streptophyta 35493 Plants Plants 158 5.51e-46   NR KAJ8647930.1 3435 g14475 i0 77.9 140.856423173804 113 23 85.4 2 57 395 65 175 KAJ8647930.1 hypothetical protein MRB53_000953 [Persea americana] diamond 55920 159 0.993710691823899 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Persea Persea americana
20736452 20736452 PRJNA1226487_P_NODE_56597_length_262_cov_1.629630_g56495_i0 PRJNA1226487 56597 262 1.62963 4.2696306 Setaria 4554 Plants Plants 125 2.88e-31   NR XP_004966968.2 4555 g56495 i0 77.5 2.43893129770992 71 16 81.3 0 2 214 929 999 XP_004966968.2 uncharacterized protein LOC101762853 [Setaria italica] diamond 639 125 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Setaria Setaria italica
20736459 20736459 PRJNA1226487_P_NODE_58077_length_260_cov_1.647059_g57975_i0 PRJNA1226487 58077 260 1.647059 4.2823534 Citrus sinensis 2711 Plants Plants 162 5.699999999999998e-44   NR KAH9751852.1 2711 g57975 i0 89.5 1.98461538461538 86 9 99.2 0 258 1 351 436 KAH9751852.1 hypothetical protein KPL71_014469 [Citrus sinensis] diamond 516 162 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
26629574 26629574 PRJNA1226487_P_NODE_73161_length_245_cov_0.895349_g73059_i0 PRJNA1226487 73161 245 0.895349 2.19360505 Nicotiana sylvestris 4096 Plants Plants 85.1 4.58e-17   NR XP_070019817.1 4096 g73059 i0 75.9 0.710204081632653 58 14 71 0 175 2 86 143 XP_070019817.1 uncharacterized protein [Nicotiana sylvestris] diamond 174 85.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
26724106 26724106 PRJNA1226487_P_NODE_5801_length_530_cov_4.048140_g5707_i0 PRJNA1226487 5801 530 4.04814 21.455142 Hordeum vulgare subsp. vulgare 112509 Plants Plants 134 1.77e-33   NR BAK03058.1 112509 g5707 i0 43.6 0.922641509433962 163 92 92.3 0 512 24 14 176 BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 489 134 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
26977834 26977834 PRJNA1226487_P_NODE_69322_length_247_cov_1.770115_g69220_i0 PRJNA1226487 69322 247 1.770115 4.37218405 Lolium multiflorum 4521 Plants Plants 53.5 6.28e-6   NR KAK1678776.1 4521 g69220 i0 35.7 11.9028340080972 70 45 85 0 210 1 672 741 KAK1678776.1 hypothetical protein QYE76_039624 [Lolium multiflorum] diamond 2940 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
27294000 27294000 PRJNA1226487_P_NODE_78703_length_241_cov_0.916667_g78601_i0 PRJNA1226487 78703 241 0.916667 2.20916747 Aristolochia fimbriata 158543 Plants Plants 84.7 5.9e-17   NR KAG9450355.1 158543 g78601 i0 78.9 1.89211618257261 76 16 94.6 0 236 9 196 271 KAG9450355.1 hypothetical protein H6P81_010320 [Aristolochia fimbriata] diamond 456 84.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
28020460 28020460 PRJNA1226487_P_NODE_8585_length_468_cov_14.010127_g8486_i0 PRJNA1226487 8585 468 14.010127 65.56739436 Castanea dentata 134033 Plants Plants 55.1 1.4e-6   NR KAL4628214.1 134033 g8486 i0 46.9 0.576923076923077 49 26 31.4 0 158 304 26 74 KAL4628214.1 hypothetical protein ACB092_05G220700 [Castanea dentata] diamond 270 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Castanea Castanea dentata
29535846 29535846 PRJNA1226487_P_NODE_570_length_1146_cov_9.019571_g520_i0 PRJNA1226487 570 1146 9.019571 103.36428366 Thalictrum thalictroides 46969 Plants Plants 216 3.38e-64   NR KAF5205496.1 46969 g520 i0 42.8 0.740837696335079 283 144 74.1 1 274 1122 21 285 KAF5205496.1 Transposable element tc3 transposase protein [Thalictrum thalictroides] diamond 849 216 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Ranunculaceae Thalictrum Thalictrum thalictroides
30122971 30122971 PRJNA1226487_P_NODE_1272_length_881_cov_5.396040_g1197_i0 PRJNA1226487 1272 881 5.39604 47.5391124 root 1 Root_unresolved Root_unresolved 322 1.4799999999999995e-107   NR CAM6031272.1 128190 g1197 i0 83.1 2.05675368898978 201 34 68.4 0 7 609 30 230 CAM6031272.1 unnamed protein product, partial [Sphagnum compactum] diamond 1812 323 0.996904024767802 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum compactum
30154433 30154433 PRJNA1226487_P_NODE_16772_length_380_cov_2.674267_g16670_i0 PRJNA1226487 16772 380 2.674267 10.1622146 Ericales 41945 Plants Plants 120 1.09e-29   NR KAF7140599.1 118357 g16670 i0 93.4 5.77894736842105 61 4 48.2 0 5 187 304 364 KAF7140599.1 hypothetical protein RHSIM_Rhsim06G0121900 [Rhododendron simsii] diamond 2196 121 0.991735537190083 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Rhododendron Rhododendron simsii
30420654 30420654 PRJNA1226487_P_NODE_45833_length_279_cov_1.558252_g45731_i0 PRJNA1226487 45833 279 1.558252 4.34752308 Sphagnum jensenii 128206 Plants Plants 51.6 4.33e-5   NR CAK9252802.1 128206 g45731 i0 37.2 0.924731182795699 86 45 92.5 2 275 18 538 614 CAK9252802.1 unnamed protein product [Sphagnum jensenii] diamond 258 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
30799300 30799300 PRJNA1226487_P_NODE_53034_length_268_cov_1.579487_g52932_i0 PRJNA1226487 53034 268 1.579487 4.23302516 Panicum virgatum 38727 Plants Plants 53.9 8.47e-7   NR XP_039818524.1 38727 g52932 i0 82.1 0.313432835820896 28 5 31.3 0 184 267 14 41 XP_039818524.1 uncharacterized protein LOC120681030 [Panicum virgatum] diamond 84 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum virgatum
30881325 30881325 PRJNA1226487_P_NODE_3854_length_609_cov_3.796642_g3763_i0 PRJNA1226487 3854 609 3.796642 23.12154978 Oryza 4527 Plants Plants 260 1.23e-78   NR CAE02362.2 39947 g3763 i0 65.6 34.7290640394089 186 59 91.6 1 27 584 415 595 CAE02362.2 OSJNBb0016B03.15 [Oryza sativa Japonica Group] diamond 21150 260 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
30976308 30976308 PRJNA1226487_P_NODE_19654_length_362_cov_4.038062_g19552_i0 PRJNA1226487 19654 362 4.038062 14.61778444 Eukaryota 2759 Plants Plants 123 6.45e-32   NR CAM6002696.1 128184 g19552 i0 53.2 1.80662983425414 109 43 90.3 2 351 25 156 256 CAM6002696.1 unnamed protein product, partial [Sphagnum balticum] diamond 654 123 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
30989145 30989145 PRJNA1226487_P_NODE_9394_length_456_cov_0.702350_g9294_i0 PRJNA1226487 9394 456 0.70235 3.202716 Rubus argutus 59490 Plants Plants 81.3 1.41e-14   NR KAK9911077.1 59490 g9294 i0 41.2 0.671052631578947 102 58 65.8 1 156 455 789 890 KAK9911077.1 hypothetical protein M0R45_035000 [Rubus argutus] diamond 306 81.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Rubus Rubus argutus
31292091 31292091 PRJNA1226487_P_NODE_46615_length_278_cov_1.502439_g46513_i0 PRJNA1226487 46615 278 1.502439 4.17678042 Poaceae 4479 Plants Plants 60.1 4.67e-8   NR KAK1662401.1 4521 g46513 i0 39.7 6.42086330935252 58 35 62.6 0 100 273 1095 1152 KAK1662401.1 hypothetical protein QYE76_050560 [Lolium multiflorum] diamond 1785 60.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
31463423 31463423 PRJNA1226487_P_NODE_7136_length_496_cov_27.378251_g7039_i0 PRJNA1226487 7136 496 27.378251 135.79612496 Camellia sinensis 4442 Plants Plants 129 2.6499999999999996e-31   NR KAF5934628.1 4442 g7039 i0 50.3 7.30645161290323 151 75 91.3 0 494 42 1345 1495 KAF5934628.1 hypothetical protein HYC85_030799 [Camellia sinensis] diamond 3624 129 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
31558327 31558327 PRJNA1226487_P_NODE_14196_length_400_cov_3.162080_g14094_i0 PRJNA1226487 14196 400 3.16208 12.64832 Sphagnum balticum 128184 Plants Plants 64.3 6.57e-9   NR CAM6002459.1 128184 g14094 i0 34.8 1.0125 135 81 96.8 3 14 400 1428 1561 CAM6002459.1 unnamed protein product, partial [Sphagnum balticum] diamond 405 64.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
31893140 31893140 PRJNA1226487_P_NODE_1757_length_784_cov_2.326301_g1675_i0 PRJNA1226487 1757 784 2.326301 18.23819984 Magnoliopsida 3398 Plants Plants 196 5.359999999999999e-54   NR XP_070033576.1 4098 g1675 i0 51.5 12.9107142857143 196 88 73.9 4 779 201 496 687 XP_070033576.1 diamine oxidase [copper-containing] 1, peroxisomal-like isoform X3 [Nicotiana tomentosiformis] diamond 10122 197 0.99492385786802 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana tomentosiformis
32032662 32032662 PRJNA1226487_P_NODE_25278_length_335_cov_2.977099_g25176_i0 PRJNA1226487 25278 335 2.977099 9.97328165 Hordeum vulgare subsp. vulgare 112509 Plants Plants 85.1 1.35e-16   NR BAK03058.1 112509 g25176 i0 47 1.32537313432836 100 53 89.6 0 308 9 53 152 BAK03058.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 444 85.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
32539094 32539094 PRJNA1226487_P_NODE_51019_length_271_cov_1.555556_g50917_i0 PRJNA1226487 51019 271 1.555556 4.21555676 Paspalum notatum var. saurae 547442 Plants Plants 73.2 1.05e-12   NR WVZ81323.1 547442 g50917 i0 67.4 3.45387453874539 46 15 50.9 0 134 271 306 351 WVZ81323.1 hypothetical protein U9M48_028713 [Paspalum notatum var. saurae] diamond 936 73.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
32759435 32759435 PRJNA1226487_P_NODE_74080_length_244_cov_0.900585_g73978_i0 PRJNA1226487 74080 244 0.900585 2.1974274 Triticum turgidum subsp. durum 4567 Plants Plants 55.1 1.73e-6   NR VAI93993.1 4567 g73978 i0 73 0.454918032786885 37 10 45.5 0 22 132 1 37 VAI93993.1 unnamed protein product [Triticum turgidum subsp. durum] diamond 111 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum turgidum

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