RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB27957 · 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
26716212 26716212 PRJEB27957_P_NODE_112101_length_166_cov_0.888889_g111991_i0 PRJEB27957 112101 166 0.888889 1.47555574 Miscanthus lutarioriparius 422564 Plants Plants 40.8 0.0417   NR CAD6205948.1 422564 g111991 i0 42.3 0.939759036144578 52 27 94 2 3 158 19 67 CAD6205948.1 unnamed protein product [Miscanthus lutarioriparius] diamond 156 40.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Miscanthus Miscanthus lutarioriparius
27254301 27254301 PRJEB27957_P_NODE_81023_length_190_cov_1.843972_g80913_i0 PRJEB27957 81023 190 1.843972 3.5035468 Prunus yedoensis var. nudiflora 2094558 Plants Plants 40.4 0.0457   NR PQQ10688.1 2094558 g80913 i0 38.9 0.852631578947368 54 20 64.7 1 153 31 53 106 PQQ10688.1 hypothetical protein Pyn_18974 [Prunus yedoensis var. nudiflora] diamond 162 40.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus yedoensis
27412669 27412669 PRJEB27957_P_NODE_57503_length_219_cov_2.447059_g57393_i0 PRJEB27957 57503 219 2.447059 5.35905921 Hibiscus cannabinus 229543 Plants Plants 41.2 0.0401   NR KAL4303047.1 229543 g57393 i0 40.5 0.575342465753425 42 25 57.5 0 142 17 61 102 KAL4303047.1 hypothetical protein GQ457_10G014400 [Hibiscus cannabinus] diamond 126 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus cannabinus
28201585 28201585 PRJEB27957_P_NODE_106826_length_168_cov_0.873950_g106716_i0 PRJEB27957 106826 168 0.87395 1.468236 Colocasia esculenta 4460 Plants Plants 41.2 0.0461   NR MQM02114.1 4460 g106716 i0 38.2 0.982142857142857 55 34 98.2 0 1 165 129 183 MQM02114.1 hypothetical protein [Colocasia esculenta] diamond 165 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
28612292 28612292 PRJEB27957_P_NODE_127987_length_152_cov_2.019417_g127877_i0 PRJEB27957 127987 152 2.019417 3.06951384 Taxus chinensis 29808 Plants Plants 70.5 1.33e-12   NR KAH9306868.1 29808 g127877 i0 66.7 1.89473684210526 48 8 94.7 1 144 1 36 75 KAH9306868.1 hypothetical protein KI387_011272, partial [Taxus chinensis] diamond 288 70.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
28675535 28675535 PRJEB27957_P_NODE_62387_length_213_cov_0.908537_g62277_i0 PRJEB27957 62387 213 0.908537 1.93518381 Glycine max 3847 Plants Plants 41.2 0.0247   NR KAG5146555.1 3847 g62277 i0 35.6 0.830985915492958 59 33 76.1 1 11 172 4 62 KAG5146555.1 hypothetical protein JHK84_032098 [Glycine max] diamond 177 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
28959800 28959800 PRJEB27957_P_NODE_52828_length_227_cov_1.106742_g52718_i0 PRJEB27957 52828 227 1.106742 2.51230434 Forsythia ovata 205694 Plants Plants 41.2 0.0332   NR KAL2550100.1 205694 g52718 i0 71.4 0.277533039647577 21 6 27.8 0 138 76 70 90 KAL2550100.1 protein TIC [Forsythia ovata] diamond 63 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
29054441 29054441 PRJEB27957_P_NODE_68928_length_204_cov_1.341935_g68818_i0 PRJEB27957 68928 204 1.341935 2.7375474 Citrus sinensis 2711 Plants Plants 43.1 0.0117   NR KAH9746202.1 2711 g68818 i0 58.3 0.352941176470588 24 10 35.3 0 35 106 151 174 KAH9746202.1 UBC core domain-containing protein [Citrus sinensis] diamond 72 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
29559350 29559350 PRJEB27957_P_NODE_116410_length_165_cov_0.896552_g116300_i0 PRJEB27957 116410 165 0.896552 1.4793108 Triticum aestivum 4565 Plants Plants 64.7 9.5e-11   NR XBI50748.1 4565 g116300 i0 69 2.29090909090909 42 13 76.4 0 139 14 108 149 XBI50748.1 hypothetical protein VPH35_114110 [Triticum aestivum] diamond 378 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
29559351 29559351 PRJEB27957_P_NODE_32750_length_273_cov_1.625000_g32640_i0 PRJEB27957 32750 273 1.625 4.43625 Canavalia gladiata 3824 Plants Plants 42 0.0459   NR KAK7329016.1 3824 g32640 i0 36.4 0.483516483516484 44 28 48.4 0 15 146 77 120 KAK7329016.1 hypothetical protein VNO77_23161 [Canavalia gladiata] diamond 132 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Canavalia Canavalia gladiata
30759949 30759949 PRJEB27957_P_NODE_112514_length_166_cov_0.888889_g112404_i0 PRJEB27957 112514 166 0.888889 1.47555574 Alopecurus aequalis 114194 Plants Plants 80.1 8.96e-16   NR CAM0948600.1 114194 g112404 i0 70.9 0.993975903614458 55 16 99.4 0 1 165 107 161 CAM0948600.1 unnamed protein product [Alopecurus aequalis] diamond 165 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Alopecurus Alopecurus aequalis
30823066 30823066 PRJEB27957_P_NODE_109214_length_167_cov_0.881356_g109104_i0 PRJEB27957 109214 167 0.881356 1.47186452 Psophocarpus tetragonolobus 3891 Plants Plants 41.6 0.0342   NR KAK7387263.1 3891 g109104 i0 43.4 0.952095808383233 53 24 95.2 1 165 7 98 144 KAK7387263.1 hypothetical protein VNO78_27921 [Psophocarpus tetragonolobus] diamond 159 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Psophocarpus Psophocarpus tetragonolobus
30943153 30943153 PRJEB27957_P_NODE_108714_length_167_cov_1.322034_g108604_i0 PRJEB27957 108714 167 1.322034 2.20779678 Oryza 4527 Plants Plants 48.1 1.57e-4   NR XP_052135586.1 4538 g108604 i0 75 1.9940119760479 28 7 50.3 0 165 82 258 285 XP_052135586.1 probable LRR receptor-like serine/threonine-protein kinase At3g47570 isoform X3 [Oryza glaberrima] diamond 333 48.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza glaberrima
31107310 31107310 PRJEB27957_P_NODE_64615_length_210_cov_0.968944_g64505_i0 PRJEB27957 64615 210 0.968944 2.0347824 Drosera rotundifolia 173423 Plants Plants 43.1 0.0178   NR GAB2216187.1 173423 g64505 i0 37.2 0.614285714285714 43 27 61.4 0 74 202 295 337 GAB2216187.1 hypothetical protein Drorol1_Dr00023957 [Drosera rotundifolia] diamond 129 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Droseraceae Drosera Drosera rotundifolia
31866279 31866279 PRJEB27957_P_NODE_68697_length_204_cov_2.032258_g68587_i0 PRJEB27957 68697 204 2.032258 4.14580632 Juncus effusus 13579 Plants Plants 42 0.0437   NR KAJ3678032.1 13579 g68587 i0 51.4 0.514705882352941 35 17 51.5 0 76 180 302 336 KAJ3678032.1 hypothetical protein LUZ60_001835 [Juncus effusus] diamond 105 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
32056240 32056240 PRJEB27957_P_NODE_45318_length_241_cov_0.750000_g45208_i0 PRJEB27957 45318 241 0.75 1.8075 Vaccinium darrowii 229202 Plants Plants 44.3 0.00987   NR KAH7853734.1 229202 g45208 i0 41.3 0.572614107883817 46 27 57.3 0 75 212 3 48 KAH7853734.1 hypothetical protein Vadar_006063 [Vaccinium darrowii] diamond 138 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Vaccinium Vaccinium darrowii
32246456 32246456 PRJEB27957_P_NODE_117858_length_164_cov_1.356522_g117748_i0 PRJEB27957 117858 164 1.356522 2.22469608 Nicotiana tomentosiformis 4098 Plants Plants 42.4 0.0178   NR XP_070032252.1 4098 g117748 i0 41.2 0.621951219512195 34 20 62.2 0 114 13 354 387 XP_070032252.1 uncharacterized protein [Nicotiana tomentosiformis] diamond 102 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana tomentosiformis
32531084 32531084 PRJEB27957_P_NODE_119839_length_164_cov_0.904348_g119729_i0 PRJEB27957 119839 164 0.904348 1.48313072 Aegilops tauschii subsp. strangulata 200361 Plants Plants 73.9 1.26e-13   NR XP_020200029.1 200361 g119729 i0 81 0.768292682926829 42 8 76.8 0 163 38 834 875 XP_020200029.1 uncharacterized protein LOC109785847 [Aegilops tauschii subsp. strangulata] diamond 126 73.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
32625419 32625419 PRJEB27957_P_NODE_83220_length_188_cov_1.496403_g83110_i0 PRJEB27957 83220 188 1.496403 2.81323764 Acer yangbiense 1000413 Plants Plants 42 0.0343   NR TXG73078.1 1000413 g83110 i0 38 0.797872340425532 50 28 79.8 1 158 9 810 856 TXG73078.1 hypothetical protein EZV62_001657 [Acer yangbiense] diamond 150 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer yangbiense
32650286 32650286 PRJEB27957_P_NODE_14820_length_367_cov_0.981132_g14710_i0 PRJEB27957 14820 367 0.981132 3.60075444 Oryza 4527 Plants Plants 88.6 6.52e-19   NR KAB8086467.1 4530 g14710 i0 91.5 1.15258855585831 47 4 38.4 0 2 142 146 192 KAB8086467.1 hypothetical protein EE612_009774, partial [Oryza sativa] diamond 423 88.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa

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