RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJNA1008624" 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

  • PRJNA1008624 · 28 ✖

analysis 1

  • blastn · 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
154317 154317 PRJNA1008624_P_NODE_25241_length_174_cov_1.608000_g25053_i0 PRJNA1008624 25241 174 1.608 2.79792 Cannabis sativa 3483 Plants Plants 52.8 0.015   NTclustered gi|2748511025|gb|CP158655.1| 3483 g25053 i0 100 0.32183908045977 28 0 16 0 147 174 10106189 10106216 Cannabis sativa cultivar ERBxHO40_23 chromosome 2 blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
1001345 1001345 PRJNA1008624_P_NODE_33981_length_164_cov_0.904348_g33793_i0 PRJNA1008624 33981 164 0.904348 1.48313072 Gossypium 3633 Plants Plants 52.8 0.014   NTclustered gi|2029558680|ref|XM_016893982.2| 3635 g33793 i0 100 0.853658536585366 28 0 17 0 51 78 1816 1843 PREDICTED: Gossypium hirsutum starch synthase 3, chloroplastic/amyloplastic (LOC107958271), mRNA blastn 140 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
2704499 2704499 PRJNA1008624_P_NODE_24283_length_177_cov_1.625000_g24095_i0 PRJNA1008624 24283 177 1.625 2.87625 Adenophora triphylla 187269 Plants Plants 318 1.34e-82   NTclustered gi|1896498728|gb|MT649408.1| 187269 g24095 i0 100 97.1694915254237 172 0 97 0 4 175 20690 20519 Adenophora triphylla chloroplast, complete genome blastn 17199 318 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora triphylla
3551924 3551924 PRJNA1008624_P_NODE_4603_length_396_cov_1.276657_g4416_i0 PRJNA1008624 4603 396 1.276657 5.05556172 Streptophyta 35493 Plants Plants 119 3.68e-22   NTclustered gi|8099444|gb|AF226036.1| 3234 g4416 i0 85.124 22.6161616161616 121 12 30 5 184 303 264 379 Anthoceros punctatus 26S ribosomal RNA gene, partial sequence blastn 8956 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Anthocerotopsida Anthocerotales Anthocerotaceae Anthoceros Anthoceros punctatus
3551932 3551932 PRJNA1008624_P_NODE_6283_length_335_cov_5.639860_g6095_i0 PRJNA1008624 6283 335 5.63986 18.893531 Campanulaceae 4381 Plants Plants 606 5.379999999999997e-169   NTclustered gi|1274236559|ref|NC_036221.1| 82271 g6095 i0 99.698 189.029850746269 331 1 99 0 2 332 114930 114600 Adenophora divaricata chloroplast, complete genome blastn 63325 612 0.990196078431373 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora divaricata
4829340 4829340 PRJNA1008624_P_NODE_26724_length_169_cov_3.575000_g26536_i0 PRJNA1008624 26724 169 3.575 6.04175 Magnoliopsida 3398 Plants Plants 305 9.81e-79   NTclustered gi|2646014499|ref|XR_009881405.1| 3486 g26536 i0 100 97.6331360946746 165 0 98 0 4 168 1584 1748 PREDICTED: Humulus lupulus 28S ribosomal RNA (LOC133809660), rRNA blastn 16500 305 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
5257006 5257006 PRJNA1008624_P_NODE_18385_length_199_cov_1.340000_g18197_i0 PRJNA1008624 18385 199 1.34 2.6666 Populus trichocarpa 3694 Plants Plants 52.8 0.017   NTclustered gi|48056729|gb|AC149424.1| 3694 g18197 i0 94.286 0.527638190954774 35 1 17 1 45 78 149201 149167 Populus trichocarpa clone Pop1-011N15, complete sequence blastn 105 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus trichocarpa
7378906 7378906 PRJNA1008624_P_NODE_2566_length_538_cov_5.533742_g2386_i0 PRJNA1008624 2566 538 5.533742 29.77153196 Adenophora 82270 Plants Plants 983 0   NTclustered gi|2437124052|gb|OP920648.1| 103991 g2386 i0 99.628 193.368029739777 538 2 100 0 1 538 113729 114266 Adenophora remotiflora chloroplast, complete genome blastn 104032 989 0.993933265925177 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora remotiflora
7378930 7378930 PRJNA1008624_P_NODE_5586_length_357_cov_2.412338_g5398_i0 PRJNA1008624 5586 357 2.412338 8.61204666 Campanulaceae 4381 Plants Plants 643 4.379999999999998e-180   NTclustered gi|1274236559|ref|NC_036221.1| 82271 g5398 i0 99.435 103.750700280112 354 2 99 0 4 357 1193 840 Adenophora divaricata chloroplast, complete genome blastn 37039 643 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora divaricata
7806955 7806955 PRJNA1008624_P_NODE_29247_length_167_cov_1.966102_g29059_i0 PRJNA1008624 29247 167 1.966102 3.28339034 Hevea brasiliensis 3981 Plants Plants 56.5 0.001   NTclustered gi|46326466|gb|AY486610.1| 3981 g29059 i0 100 0.179640718562874 30 0 18 0 117 146 117 88 Hevea brasiliensis clone mHbCIRT2127 microsatellite sequence blastn 30 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
9081949 9081949 PRJNA1008624_P_NODE_32728_length_165_cov_0.896552_g32540_i0 PRJNA1008624 32728 165 0.896552 1.4793108 Ananas comosus 4615 Plants Plants 52.8 0.014   NTclustered gi|1885255823|emb|LR862137.1| 296719 g32540 i0 100 0.16969696969697 28 0 17 0 82 109 19893879 19893906 Ananas comosus var. bracteatus genome assembly, chromosome: 9 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
10356983 10356983 PRJNA1008624_P_NODE_10669_length_255_cov_2.441748_g10481_i0 PRJNA1008624 10669 255 2.441748 6.2264574 Vitis vinifera 29760 Plants Plants 52.8 0.023   NTclustered gi|147777539|emb|AM432656.2| 29760 g10481 i0 96.774 0.12156862745098 31 1 12 0 2 32 616 586 Vitis vinifera contig VV78X053000.2, whole genome shotgun sequence blastn 31 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
11633337 11633337 PRJNA1008624_P_NODE_8750_length_283_cov_1.192308_g8562_i0 PRJNA1008624 8750 283 1.192308 3.37423164 Cannabis sativa 3483 Plants Plants 52.8 0.026   NTclustered gi|2748542233|gb|CP158652.1| 3483 g8562 i0 100 0.0989399293286219 28 0 10 0 238 265 14251917 14251944 Cannabis sativa cultivar ERBxHO40_23 chromosome X blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
12480173 12480173 PRJNA1008624_P_NODE_32950_length_165_cov_0.896552_g32762_i0 PRJNA1008624 32950 165 0.896552 1.4793108 Poaceae 4479 Plants Plants 303 3.45e-78   NTclustered gi|2155905707|emb|OV049916.1| 4529 g32762 i0 100 99.3939393939394 164 0 99 0 1 164 17653 17490 Oryza rufipogon genome assembly, organelle: plastid:chloroplast blastn 16400 303 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza rufipogon
12908111 12908111 PRJNA1008624_P_NODE_30851_length_166_cov_0.888889_g30663_i0 PRJNA1008624 30851 166 0.888889 1.47555574 Olea europaea 4146 Plants Plants 54.7 0.004   NTclustered gi|1279075503|ref|XR_002697431.1| 158386 g30663 i0 100 0.174698795180723 29 0 17 0 86 114 117 145 PREDICTED: Olea europaea var. sylvestris uncharacterized LOC111365412 (LOC111365412), ncRNA blastn 29 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
15456968 15456968 PRJNA1008624_P_NODE_27393_length_169_cov_0.866667_g27205_i0 PRJNA1008624 27393 169 0.866667 1.46466723 Quercus lobata 97700 Plants Plants 302 1.27e-77   NTclustered gi|1757498988|ref|XM_031093528.1| 97700 g27205 i0 100 3.85798816568047 163 0 96 0 3 165 124 286 PREDICTED: Quercus lobata aldose 1-epimerase-like (LOC115973268), mRNA blastn 652 302 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus lobata
16731460 16731460 PRJNA1008624_P_NODE_4134_length_420_cov_3.954178_g3947_i0 PRJNA1008624 4134 420 3.954178 16.6075476 Adenophora triphylla 187269 Plants Plants 771 0   NTclustered gi|1896498728|gb|MT649408.1| 187269 g3947 i0 100 186.280952380952 417 0 99 0 1 417 184924 184508 Adenophora triphylla chloroplast, complete genome blastn 78238 771 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora triphylla
17579183 17579183 PRJNA1008624_P_NODE_2554_length_539_cov_9.048980_g2374_i0 PRJNA1008624 2554 539 9.04898 48.7740022 Campanulaceae 4381 Plants Plants 896 0   NTclustered gi|1274236559|ref|NC_036221.1| 82271 g2374 i0 99.795 191.684601113173 488 1 99 0 52 539 118112 118599 Adenophora divaricata chloroplast, complete genome blastn 103318 902 0.993348115299335 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora divaricata
17579199 17579199 PRJNA1008624_P_NODE_31514_length_166_cov_0.888889_g31326_i0 PRJNA1008624 31514 166 0.888889 1.47555574 Quercus 3511 Plants Plants 298 1.62e-76   NTclustered gi|2293140549|ref|XM_050388257.1| 38942 g31326 i0 100 30.8915662650602 161 0 97 0 5 165 1732 1892 PREDICTED: Quercus robur putative zinc transporter At3g08650 (LOC126692592), transcript variant X2, mRNA blastn 5128 298 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
18006166 18006166 PRJNA1008624_P_NODE_29875_length_167_cov_0.881356_g29687_i0 PRJNA1008624 29875 167 0.881356 1.47186452 Brassica oleracea 3712 Plants Plants 54.7 0.004   NTclustered gi|1516589221|emb|LR031878.1| 3712 g29687 i0 100 0.173652694610778 29 0 17 0 130 158 4837134 4837162 Brassica oleracea HDEM genome, scaffold: C1 blastn 29 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica oleracea
19279511 19279511 PRJNA1008624_P_NODE_13976_length_225_cov_1.028409_g13788_i0 PRJNA1008624 13976 225 1.028409 2.31392025 Phragmites australis 29695 Plants Plants 52.8 0.02   NTclustered gi|2649479528|ref|XM_062340132.1| 29695 g13788 i0 100 0.124444444444444 28 0 12 0 156 183 1283 1256 PREDICTED: Phragmites australis transcription factor MYBS3-like (LOC133899170), mRNA blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phragmites Phragmites australis
19280194 19280194 PRJNA1008624_P_NODE_5916_length_345_cov_4.070946_g5728_i0 PRJNA1008624 5916 345 4.070946 14.0447637 Adenophora triphylla 187269 Plants Plants 638 1.97e-178   NTclustered gi|1896498728|gb|MT649408.1| 187269 g5728 i0 100 319.411594202899 345 0 100 0 1 345 185334 184990 Adenophora triphylla chloroplast, complete genome blastn 110197 638 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Adenophora Adenophora triphylla
20555210 20555210 PRJNA1008624_P_NODE_16177_length_211_cov_1.253086_g15989_i0 PRJNA1008624 16177 211 1.253086 2.64401146 Musa acuminata 4641 Plants Plants 54.7 0.005   NTclustered gi|2008914241|emb|HG996476.1| 214687 g15989 i0 96.875 0.151658767772512 32 1 15 0 96 127 32347967 32347998 Musa acuminata subsp. malaccensis strain Doubled-haploid Pahang (DH-Pahang) genome assembly, chromosome: A10 blastn 32 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Musa Musa acuminata
20555240 20555240 PRJNA1008624_P_NODE_17077_length_206_cov_1.203822_g16889_i0 PRJNA1008624 17077 206 1.203822 2.47987332 Prunus dulcis 3755 Plants Plants 52.8 0.018   NTclustered gi|2699132189|emb|OZ022204.1| 3755 g16889 i0 100 0.135922330097087 28 0 14 0 174 201 24297058 24297031 Prunus dulcis genome assembly, chromosome: 8 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
21403391 21403391 PRJNA1008624_P_NODE_14297_length_223_cov_0.793103_g14109_i0 PRJNA1008624 14297 223 0.793103 1.76861969 Campanulaceae 4381 Plants Plants 405 1.32e-108   NTclustered gi|674840250|ref|NC_024732.1| 103032 g14109 i0 100 98.1121076233184 219 0 98 0 1 219 1273 1491 Hanabusaya asiatica voucher Yoo86859 chloroplast, complete genome blastn 21879 405 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Campanulaceae Hanabusaya Hanabusaya asiatica
23106666 23106666 PRJNA1008624_P_NODE_28619_length_168_cov_0.873950_g28431_i0 PRJNA1008624 28619 168 0.87395 1.468236 Aristolochia californica 171875 Plants Plants 52.8 0.014   NTclustered gi|2811359591|ref|XM_068811281.1| 171875 g28431 i0 100 0.166666666666667 28 0 17 0 4 31 778 805 PREDICTED: Aristolochia californica elongation factor Tu, chloroplastic-like (LOC137964018), mRNA blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia californica
23106784 23106784 PRJNA1008624_P_NODE_34279_length_164_cov_0.904348_g34091_i0 PRJNA1008624 34279 164 0.904348 1.48313072 Chenopodium quinoa 63459 Plants Plants 52.8 0.014   NTclustered gi|1219055924|ref|XM_021897987.1| 63459 g34091 i0 100 0.170731707317073 28 0 17 0 56 83 31 4 PREDICTED: Chenopodium quinoa bZIP transcription factor 50-like (LOC110719077), mRNA blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Chenopodium Chenopodium quinoa
25227580 25227580 PRJNA1008624_P_NODE_34380_length_164_cov_0.904348_g34192_i0 PRJNA1008624 34380 164 0.904348 1.48313072 Oryza 4527 Plants Plants 300 4.43e-77   NTclustered gi|2155905707|emb|OV049916.1| 4529 g34192 i0 100 98.780487804878 162 0 99 0 1 162 60687 60848 Oryza rufipogon genome assembly, organelle: plastid:chloroplast blastn 16200 300 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza rufipogon

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