RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA485080" and tax_kingdom = "Viridiplantae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Viridiplantae · 16 ✖

bioproject 1

  • PRJNA485080 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
2372903 2372903 PRJNA485080_P_NODE_26542_length_249_cov_0.875000_g26448_i0 PRJNA485080 26542 249 0.875 2.17875 Chlorella variabilis 554065 Plants Plants 102 1.2299999999999997e-23   NR XP_005851680.1 554065 g26448 i0 87.9 1.39759036144578 58 7 69.9 0 2 175 360 417 XP_005851680.1 hypothetical protein CHLNCDRAFT_29144 [Chlorella variabilis] diamond 348 102 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
11927690 11927690 PRJNA485080_P_NODE_18530_length_269_cov_2.219388_g18436_i0 PRJNA485080 18530 269 2.219388 5.97015372 Eukaryota 2759 Plants Plants 147 6.36e-39   NR KAI3437883.1 3077 g18436 i0 75 17.7323420074349 88 22 98.1 0 2 265 203 290 KAI3437883.1 hypothetical protein D9Q98_000328 [Chlorella vulgaris] diamond 4770 148 0.993243243243243 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella vulgaris
17026320 17026320 PRJNA485080_P_NODE_21234_length_252_cov_1.083799_g21140_i0 PRJNA485080 21234 252 1.083799 2.73117348 Genlisea aurea 192259 Plants Plants 81.6 8.27e-16   NR EPS59507.1 192259 g21140 i0 54.7 0.892857142857143 75 34 89.3 0 3 227 146 220 EPS59507.1 hypothetical protein M569_15298, partial [Genlisea aurea] diamond 225 81.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lentibulariaceae Genlisea Genlisea aurea
17026601 17026601 PRJNA485080_P_NODE_40534_length_242_cov_0.911243_g40440_i0 PRJNA485080 40534 242 0.911243 2.20520806 Eukaryota 2759 Plants Plants 119 3.5799999999999997e-32   NR OUS48503.1 70448 g40440 i0 87.5 26.1322314049587 64 8 79.3 0 241 50 86 149 OUS48503.1 ribosomal protein S23 component of cytosolic 80S ribosome and 40S small subunit [Ostreococcus tauri] diamond 6324 119 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
20850650 20850650 PRJNA485080_P_NODE_19617_length_262_cov_1.629630_g19523_i0 PRJNA485080 19617 262 1.62963 4.2696306 root 1 Root_unresolved Root_unresolved 114 1.81e-27   NR KAK3235231.1 36881 g19523 i0 80.3 3.91603053435115 71 14 81.3 0 260 48 364 434 KAK3235231.1 hypothetical protein CYMTET_54557 [Cymbomonas tetramitiformis] diamond 1026 115 0.991304347826087 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Cymbomonas Cymbomonas tetramitiformis
27060767 27060767 PRJNA485080_P_NODE_30042_length_247_cov_0.885057_g29948_i0 PRJNA485080 30042 247 0.885057 2.18609079 Chlorophyta 3041 Plants Plants 65.9 2e-10   NR KAJ9528545.1 44745 g29948 i0 45.5 3.86234817813765 77 41 93.5 1 5 235 54 129 KAJ9528545.1 hypothetical protein QJQ45_020474 [Haematococcus lacustris] diamond 954 65.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Haematococcaceae Haematococcus Haematococcus lacustris
27234350 27234350 PRJNA485080_P_NODE_25623_length_249_cov_1.312500_g25529_i0 PRJNA485080 25623 249 1.3125 3.268125 Helianthus anomalus 73274 Plants Plants 41.2 0.0263   NR MFS7933087.1 73274 g25529 i0 44.2 0.518072289156627 43 23 50.6 1 30 155 11 53 MFS7933087.1 hypothetical protein [Helianthus anomalus] diamond 129 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus anomalus
27740033 27740033 PRJNA485080_P_NODE_29184_length_248_cov_0.880000_g29090_i0 PRJNA485080 29184 248 0.88 2.1824 Hordeum vulgare subsp. vulgare 112509 Plants Plants 88.6 6.86e-20   NR BAJ94142.1 112509 g29090 i0 71 0.834677419354839 69 14 76.2 2 203 15 27 95 BAJ94142.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 207 88.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27834326 27834326 PRJNA485080_P_NODE_15224_length_291_cov_1.059633_g15130_i0 PRJNA485080 15224 291 1.059633 3.08353203 Genlisea aurea 192259 Plants Plants 68.2 7.48e-11   NR EPS59507.1 192259 g15130 i0 72.1 0.443298969072165 43 12 44.3 0 290 162 319 361 EPS59507.1 hypothetical protein M569_15298, partial [Genlisea aurea] diamond 129 68.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lentibulariaceae Genlisea Genlisea aurea
28323995 28323995 PRJNA485080_P_NODE_37346_length_244_cov_0.900585_g37252_i0 PRJNA485080 37346 244 0.900585 2.1974274 Trebouxia 13786 Plants Plants 114 1.8e-27   NR KAL0032166.1 2905653 g37252 i0 74.4 2.87704918032787 78 19 95.9 1 234 1 633 709 KAL0032166.1 hypothetical protein WJX77_008567 [Trebouxia sp. C0004] diamond 702 114 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. C0004
28529236 28529236 PRJNA485080_P_NODE_34967_length_245_cov_0.895349_g34873_i0 PRJNA485080 34967 245 0.895349 2.19360505 Closterium sp. NIES-53 3014310 Plants Plants 43.1 0.0279   NR CAI7764356.1 3014310 g34873 i0 61.8 0.416326530612245 34 13 41.6 0 138 239 444 477 CAI7764356.1 unnamed protein product [Closterium sp. NIES-53] diamond 102 43.1 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. NIES-53
28844602 28844602 PRJNA485080_P_NODE_29288_length_248_cov_0.880000_g29194_i0 PRJNA485080 29288 248 0.88 2.1824 Chlorella variabilis 554065 Plants Plants 59.3 5.67e-8   NR XP_005851108.1 554065 g29194 i0 45.1 0.991935483870968 82 39 99.2 2 246 1 397 472 XP_005851108.1 hypothetical protein CHLNCDRAFT_49822 [Chlorella variabilis] diamond 246 59.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella variabilis
29065940 29065940 PRJNA485080_P_NODE_11188_length_324_cov_1.031873_g11094_i0 PRJNA485080 11188 324 1.031873 3.34326852 Genlisea aurea 192259 Plants Plants 53.1 2.09e-5   NR EPS59507.1 192259 g11094 i0 45.6 0.62962962962963 68 32 59.3 2 322 131 164 230 EPS59507.1 hypothetical protein M569_15298, partial [Genlisea aurea] diamond 204 53.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lentibulariaceae Genlisea Genlisea aurea
29728589 29728589 PRJNA485080_P_NODE_24290_length_250_cov_0.870056_g24196_i0 PRJNA485080 24290 250 0.870056 2.17514 Linum tenue 586396 Plants Plants 44.3 0.00175   NR CAI0551783.1 586396 g24196 i0 40.4 0.564 47 24 56.4 1 56 196 15 57 CAI0551783.1 unnamed protein product [Linum tenue] diamond 141 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Linaceae Linum Linum tenue
30866118 30866118 PRJNA485080_P_NODE_22074_length_251_cov_0.865169_g21980_i0 PRJNA485080 22074 251 0.865169 2.17157419 Rubroshorea leprosula 152421 Plants Plants 40.8 0.044   NR GKV48853.1 152421 g21980 i0 36.4 0.525896414342629 44 28 52.6 0 42 173 44 87 GKV48853.1 hypothetical protein SLEP1_g55644 [Rubroshorea leprosula] diamond 132 40.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Dipterocarpaceae Rubroshorea Rubroshorea leprosula
31071985 31071985 PRJNA485080_P_NODE_16495_length_283_cov_0.933333_g16401_i0 PRJNA485080 16495 283 0.933333 2.64133239 root 1 Root_unresolved Root_unresolved 43.9 0.011   NR GMP76123.1 542762 g16401 i0 37.2 2.30035335689046 86 43 81.6 3 1 231 58 141 GMP76123.1 hypothetical protein CsSME_00032934 [Camellia sinensis var. sinensis] diamond 651 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis

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