RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1242190 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
350767 350767 PRJNA1242190_S_NODE_3621_length_417_cov_2.953488_g3614_i0 PRJNA1242190 3621 417 2.953488 12.31604496 Magnoliopsida 3398 Plants Plants 129 2.94e-33   NR KAJ3681180.1 13579 g3614 i0 59.8 15.3021582733813 112 41 79.1 3 47 376 235 344 KAJ3681180.1 hypothetical protein LUZ60_015669 [Juncus effusus] diamond 6381 130 0.992307692307692 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
350777 350777 PRJNA1242190_S_NODE_4381_length_386_cov_4.939297_g4374_i0 PRJNA1242190 4381 386 4.939297 19.06568642 Nymphaea colorata 210225 Plants Plants 121 4.399999999999999e-33   NR VVW89097.1 210225 g4374 i0 63.3 2.1139896373057 90 33 69.9 0 6 275 5 94 VVW89097.1 unnamed protein product, partial [Nymphaea colorata] diamond 816 121 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
1051070 1051070 PRJNA1242190_S_NODE_7081_length_317_cov_2.942623_g7074_i0 PRJNA1242190 7081 317 2.942623 9.32811491 Hordeum vulgare subsp. vulgare 112509 Plants Plants 97.4 4.4300000000000005e-21   NR BAJ97146.1 112509 g7074 i0 69.2 2.46056782334385 65 20 61.5 0 3 197 426 490 BAJ97146.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 780 97.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
4879152 4879152 PRJNA1242190_S_NODE_4244_length_391_cov_8.757862_g4237_i0 PRJNA1242190 4244 391 8.757862 34.24324042 Eukaryota 2759 Plants Plants 100 1.06e-23   NR XP_006370602.3 3694 g4237 i0 60.9 1.94884910485934 87 34 66.8 0 389 129 83 169 XP_006370602.3 histone H2A.6 [Populus trichocarpa] diamond 762 101 0.99009900990099 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus trichocarpa
8004163 8004163 PRJNA1242190_S_NODE_1587_length_537_cov_3.980603_g1580_i0 PRJNA1242190 1587 537 3.980603 21.37583811 root 1 Root_unresolved Root_unresolved 159 1.6499999999999999e-46   NR VVW89318.1 210225 g1580 i0 48.7 1.73184357541899 154 77 86 1 511 50 6 157 VVW89318.1 unnamed protein product [Nymphaea colorata] diamond 930 159 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
15653876 15653876 PRJNA1242190_S_NODE_1853_length_516_cov_4.507901_g1846_i0 PRJNA1242190 1853 516 4.507901 23.26076916 Sphagnum balticum 128184 Plants Plants 213 8.919999999999999e-68   NR CAM6005785.1 128184 g1846 i0 71.1 2.56395348837209 149 39 86.6 1 491 45 1 145 CAM6005785.1 unnamed protein product [Sphagnum balticum] diamond 1323 213 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
16353541 16353541 PRJNA1242190_S_NODE_6813_length_322_cov_3.682731_g6806_i0 PRJNA1242190 6813 322 3.682731 11.85839382 Magnoliopsida 3398 Plants Plants 90.5 6.78e-19   NR KAI7753804.1 4212 g6806 i0 62.5 5.85093167701863 64 22 59.6 1 311 120 290 351 KAI7753804.1 hypothetical protein M8C21_003186, partial [Ambrosia artemisiifolia] diamond 1884 90.9 0.995599559955996 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
16928129 16928129 PRJNA1242190_S_NODE_5634_length_348_cov_6.680000_g5627_i0 PRJNA1242190 5634 348 6.68 23.2464 Nymphaea colorata 210225 Plants Plants 85.9 2.4e-18   NR VVW87158.1 210225 g5627 i0 47.9 1.6551724137931 96 49 82.8 1 1 288 75 169 VVW87158.1 unnamed protein product, partial [Nymphaea colorata] diamond 576 85.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
16928131 16928131 PRJNA1242190_S_NODE_5774_length_345_cov_1.290441_g5767_i0 PRJNA1242190 5774 345 1.290441 4.45202145 Sphagnum balticum 128184 Plants Plants 177 9.549999999999998e-55   NR CAM6005785.1 128184 g5767 i0 75.7 0.965217391304348 111 27 96.5 0 3 335 35 145 CAM6005785.1 unnamed protein product [Sphagnum balticum] diamond 333 177 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
19477002 19477002 PRJNA1242190_S_NODE_3936_length_403_cov_4.527273_g3929_i0 PRJNA1242190 3936 403 4.527273 18.24491019 Arabidopsis thaliana 3702 Plants Plants 80.1 9.21e-17   NR NP_001118871.1 3702 g3929 i0 52 0.558312655086849 75 36 55.8 0 15 239 8 82 NP_001118871.1 Zinc-binding ribosomal protein family protein [Arabidopsis thaliana] diamond 225 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
22027629 22027629 PRJNA1242190_S_NODE_1978_length_508_cov_3.439080_g1971_i0 PRJNA1242190 1978 508 3.43908 17.4705264 Eukaryota 2759 Plants Plants 91.3 5.01e-20   NR XP_010683697.1 3555 g1971 i0 37.8 3.1240157480315 135 82 78.5 2 504 106 3 137 XP_010683697.1 ubiquitin [Beta vulgaris subsp. vulgaris] diamond 1587 91.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Beta Beta vulgaris
24003071 24003071 PRJNA1242190_S_NODE_4339_length_388_cov_1.517460_g4332_i0 PRJNA1242190 4339 388 1.51746 5.8877448 Sphagnum balticum 128184 Plants Plants 152 5.96e-45   NR CAM6001409.1 128184 g4332 i0 82.6 0.664948453608247 86 15 66.5 0 387 130 45 130 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 258 152 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
26661764 26661764 PRJNA1242190_S_NODE_2921_length_450_cov_4.002653_g2914_i0 PRJNA1242190 2921 450 4.002653 18.0119385 Amaranthus tricolor 29722 Plants Plants 127 2.31e-33   NR XP_057547886.1 29722 g2914 i0 54.6 6.90666666666667 130 49 86 3 1 387 110 230 XP_057547886.1 60S ribosomal protein L6-like [Amaranthus tricolor] diamond 3108 127 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Amaranthaceae Amaranthus Amaranthus tricolor
26756894 26756894 PRJNA1242190_S_NODE_1941_length_511_cov_2.500000_g1934_i0 PRJNA1242190 1941 511 2.5 12.775 Hordeum vulgare subsp. vulgare 112509 Plants Plants 118 1.9599999999999997e-30   NR BAK02983.1 112509 g1934 i0 47.6 2.60665362035225 145 75 85.1 1 495 61 4 147 BAK02983.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 1332 118 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27768785 27768785 PRJNA1242190_S_NODE_10904_length_262_cov_1.370370_g10897_i0 PRJNA1242190 10904 262 1.37037 3.5903694 Sphagnum balticum 128184 Plants Plants 120 7.519999999999999e-32   NR CAM6002349.1 128184 g10897 i0 92.8 0.790076335877863 69 5 79 0 212 6 163 231 CAM6002349.1 unnamed protein product, partial [Sphagnum balticum] diamond 207 120 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
29207631 29207631 PRJNA1242190_S_NODE_11349_length_257_cov_1.304348_g11342_i0 PRJNA1242190 11349 257 1.304348 3.35217436 Streptophyta 35493 Plants Plants 66.2 3.28e-12   NR KAG9132170.1 34254 g11342 i0 73.8 11.8015564202335 42 11 49 0 56 181 23 64 KAG9132170.1 hypothetical protein Leryth_022233 [Lithospermum erythrorhizon] diamond 3033 66.6 0.993993993993994 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Boraginales Boraginaceae Lithospermum Lithospermum erythrorhizon
29568170 29568170 PRJNA1242190_S_NODE_13770_length_241_cov_3.761905_g13763_i0 PRJNA1242190 13770 241 3.761905 9.06619105 Nymphaea colorata 210225 Plants Plants 67 9.15e-12   NR XP_031472781.1 210225 g13763 i0 48.7 0.970954356846473 78 36 92.1 1 17 238 6 83 XP_031472781.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116245286 [Nymphaea colorata] diamond 234 67 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
29884206 29884206 PRJNA1242190_S_NODE_11171_length_259_cov_1.290323_g11164_i0 PRJNA1242190 11171 259 1.290323 3.34193657 Carica papaya 3649 Plants Plants 46.6 0.0019   NR XP_021911524.1 3649 g11164 i0 54.1 1.84169884169884 37 17 42.9 0 47 157 286 322 XP_021911524.1 papain-like [Carica papaya] diamond 477 46.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Caricaceae Carica Carica papaya
29997040 29997040 PRJNA1242190_S_NODE_6811_length_322_cov_4.807229_g6804_i0 PRJNA1242190 6811 322 4.807229 15.47927738 Eukaryota 2759 Plants Plants 62 1.67e-9   NR PIA28139.1 218851 g6804 i0 63.2 3.27950310559006 57 16 49.4 2 320 162 63 118 PIA28139.1 hypothetical protein AQUCO_07200050v1 [Aquilegia coerulea] diamond 1056 62 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Ranunculaceae Aquilegia Aquilegia coerulea
30105099 30105099 PRJNA1242190_S_NODE_4732_length_374_cov_4.950166_g4725_i0 PRJNA1242190 4732 374 4.950166 18.51362084 Nymphaea colorata 210225 Plants Plants 91.3 2.53e-20   NR VVW87158.1 210225 g4725 i0 49 2.40641711229947 100 50 80.2 1 370 71 71 169 VVW87158.1 unnamed protein product, partial [Nymphaea colorata] diamond 900 91.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
30326876 30326876 PRJNA1242190_S_NODE_13932_length_233_cov_3.325000_g13925_i0 PRJNA1242190 13932 233 3.325 7.74725 Hordeum vulgare subsp. vulgare 112509 Plants Plants 58.9 7.99e-9   NR BAJ99260.1 112509 g13925 i0 41.5 0.836909871244635 65 38 83.7 0 204 10 8 72 BAJ99260.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 195 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
30407959 30407959 PRJNA1242190_S_NODE_12313_length_250_cov_1.101695_g12306_i0 PRJNA1242190 12313 250 1.101695 2.7542375 Fabaceae 3803 Plants Plants 48.5 3.68e-4   NR KAK7395747.1 3891 g12306 i0 39.7 3.9 58 34 69.6 1 53 226 415 471 KAK7395747.1 hypothetical protein VNO78_16314 [Psophocarpus tetragonolobus] diamond 975 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Psophocarpus Psophocarpus tetragonolobus
30597079 30597079 PRJNA1242190_S_NODE_2693_length_462_cov_4.776350_g2686_i0 PRJNA1242190 2693 462 4.77635 22.066737 Eukaryota 2759 Plants Plants 155 1.54e-45   NR XP_002963396.1 88036 g2686 i0 58.6 2.69480519480519 140 56 90.9 1 460 41 2 139 XP_002963396.1 60S ribosomal protein L26-2 [Selaginella moellendorffii] diamond 1245 155 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
31102579 31102579 PRJNA1242190_S_NODE_4955_length_367_cov_1.710884_g4948_i0 PRJNA1242190 4955 367 1.710884 6.27894428 Magnoliopsida 3398 Plants Plants 119 5.630000000000001e-29   NR KAJ3695967.1 13579 g4948 i0 56.3 5.11716621253406 103 44 83.4 1 366 61 240 342 KAJ3695967.1 hypothetical protein LUZ60_001344 [Juncus effusus] diamond 1878 120 0.991666666666667 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
31812010 31812010 PRJNA1242190_S_NODE_13457_length_243_cov_1.500000_g13450_i0 PRJNA1242190 13457 243 1.5 3.645 Nymphaea colorata 210225 Plants Plants 59.3 1.31e-9   NR VVW89105.1 210225 g13450 i0 54.2 0.592592592592593 48 22 59.3 0 78 221 5 52 VVW89105.1 unnamed protein product, partial [Nymphaea colorata] diamond 144 59.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
31829888 31829888 PRJNA1242190_S_NODE_12037_length_251_cov_3.005618_g12030_i0 PRJNA1242190 12037 251 3.005618 7.54410118 Eukaryota 2759 Plants Plants 93.6 3.45e-21   NR XP_031472812.1 210225 g12030 i0 80 4.97211155378486 55 11 65.7 0 246 82 187 241 XP_031472812.1 14-3-3-like protein GF14 epsilon [Nymphaea colorata] diamond 1248 94 0.995744680851064 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
32255290 32255290 PRJNA1242190_S_NODE_9978_length_273_cov_1.695000_g9971_i0 PRJNA1242190 9978 273 1.695 4.62735 Zizania palustris 103762 Plants Plants 64.7 9.62e-10   NR KAG8098239.1 103762 g9971 i0 46.5 0.78021978021978 71 36 78 1 269 57 428 496 KAG8098239.1 hypothetical protein GUJ93_ZPchr0013g36173 [Zizania palustris] diamond 213 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zizania Zizania palustris
32286896 32286896 PRJNA1242190_S_NODE_3359_length_429_cov_4.224719_g3352_i0 PRJNA1242190 3359 429 4.224719 18.12404451 Nymphaea colorata 210225 Plants Plants 144 4e-41   NR XP_031472781.1 210225 g3352 i0 52.1 0.993006993006993 142 64 96.5 1 415 2 6 147 XP_031472781.1 LOW QUALITY PROTEIN: uncharacterized protein LOC116245286 [Nymphaea colorata] diamond 426 144 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata

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