RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA287283" 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 · 24 ✖

bioproject 1

  • PRJNA287283 · 24 ✖

analysis 1

  • blastn · 24 ✖
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
2334435 2334435 PRJNA287283_P_NODE_6402_length_225_cov_1.058140_g6178_i0 PRJNA287283 6402 225 1.05814 2.380815 Eukaryota 2759 Plants Plants 121 5.409999999999999e-23   NTclustered gi|2634830881|ref|XM_061509307.1| 150636 g6178 i0 83.206 24.1155555555556 131 22 58 0 95 225 183 313 PREDICTED: Gastrolobium bilobum ADP-ribosylation factor 2 (LOC133308658), transcript variant X2, mRNA blastn 5426 122 0.991803278688525 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Gastrolobium Gastrolobium bilobum
2334438 2334438 PRJNA287283_P_NODE_9502_length_179_cov_0.888889_g9278_i0 PRJNA287283 9502 179 0.888889 1.59111131 Eukaryota 2759 Plants Plants 54.7 0.004   NTclustered gi|1666250390|ref|XM_025834421.2| 3818 g9278 i0 100 3.5195530726257 29 0 16 0 129 157 1351 1379 PREDICTED: Arachis hypogaea protein CHUP1, chloroplastic (LOC112791548), transcript variant X2, mRNA blastn 630 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
2922847 2922847 PRJNA287283_P_NODE_10143_length_176_cov_0.910569_g9919_i0 PRJNA287283 10143 176 0.910569 1.60260144 Citrus sinensis 2711 Plants Plants 326 7.92e-85   NTclustered gi|2396002411|ref|XM_052433009.1| 2711 g9919 i0 100 1.94886363636364 176 0 100 0 1 176 754 929 PREDICTED: Citrus sinensis protein SPA, chloroplastic (LOC102619544), transcript variant X2, mRNA blastn 343 326 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
3609722 3609722 PRJNA287283_P_NODE_2623_length_403_cov_1.520000_g2399_i0 PRJNA287283 2623 403 1.52 6.1256 Pinopsida 58019 Plants Plants 739 0   NTclustered gi|152060711|gb|EF673730.1| 93926 g2399 i0 99.752 103.069478908189 404 0 100 1 1 403 201 604 Picea morrisonicola 18S ribosomal RNA gene, partial sequence blastn 41537 739 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea morrisonicola
8711873 8711873 PRJNA287283_P_NODE_10487_length_175_cov_0.918033_g10263_i0 PRJNA287283 10487 175 0.918033 1.60655775 Rutaceae 23513 Plants Plants 324 2.83e-84   NTclustered gi|1381390543|ref|NC_037463.1| 2711 g10263 i0 100 18.6285714285714 175 0 100 0 1 175 17763 17937 Citrus sinensis mitochondrion, complete genome blastn 3260 324 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
9987313 9987313 PRJNA287283_P_NODE_10088_length_176_cov_1.186992_g9864_i0 PRJNA287283 10088 176 1.186992 2.08910592 Streptophyta 35493 Plants Plants 305 1.03e-78   NTclustered gi|2248512710|ref|NC_063788.1| 36775 g9864 i0 100 147.068181818182 165 0 94 0 1 165 110264 110100 Cuphea hookeriana chloroplast, complete genome blastn 25884 307 0.993485342019544 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Myrtales Lythraceae Cuphea Cuphea hookeriana
9987314 9987314 PRJNA287283_P_NODE_2648_length_401_cov_41.913793_g2424_i0 PRJNA287283 2648 401 41.913793 168.07430993 Eukaryota 2759 Plants Plants 664 0   NTclustered gi|195616321|gb|EU957873.1| 4577 g2424 i0 96.509 54.4513715710723 401 14 100 0 1 401 1284 884 Zea mays clone 1628308 zinc finger protein mRNA, complete cds blastn 21835 664 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
11850837 11850837 PRJNA287283_P_NODE_9370_length_179_cov_0.888889_g9146_i0 PRJNA287283 9370 179 0.888889 1.59111131 Triticum monococcum 4568 Plants Plants 274 2.97e-69   NTclustered gi|2581913088|emb|OY737865.1| 4568 g9146 i0 94.444 664.63687150838 180 7 100 2 1 179 48526441 48526618 Triticum monococcum genome assembly, chromosome: UA blastn 118970 274 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum monococcum
13812571 13812571 PRJNA287283_P_NODE_4191_length_306_cov_2.778656_g3967_i0 PRJNA287283 4191 306 2.778656 8.50268736 Magnoliopsida 3398 Plants Plants 560 3.84e-155   NTclustered gi|2504382689|gb|ON479685.1| 2708 g3967 i0 100 100.245098039216 303 0 99 0 4 306 1968 1666 Citrus x limon 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence blastn 30675 560 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x limon
14401169 14401169 PRJNA287283_P_NODE_6072_length_234_cov_1.337017_g5848_i0 PRJNA287283 6072 234 1.337017 3.12861978 Citrus sinensis 2711 Plants Plants 392 1.0899999999999999e-104   NTclustered gi|2395998644|ref|XR_008051163.1| 2711 g5848 i0 96.996 21.7777777777778 233 7 99 0 2 234 517 749 PREDICTED: Citrus sinensis uncharacterized LOC127899203 (LOC127899203), ncRNA blastn 5096 392 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
15674919 15674919 PRJNA287283_P_NODE_8313_length_184_cov_1.282443_g8089_i0 PRJNA287283 8313 184 1.282443 2.35969512 Picea smithiana 123602 Plants Plants 340 2.99e-89   NTclustered gi|170516046|gb|EU161351.1| 123602 g8089 i0 100 105.940217391304 184 0 100 0 1 184 1241 1424 Picea smithiana 26S ribosomal RNA gene, partial sequence blastn 19493 340 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea smithiana
16361658 16361658 PRJNA287283_P_NODE_6313_length_227_cov_1.775862_g6089_i0 PRJNA287283 6313 227 1.775862 4.03120674 Magnoliopsida 3398 Plants Plants 414 2.2399999999999998e-111   NTclustered gi|2504382689|gb|ON479685.1| 2708 g6089 i0 99.559 100.039647577093 227 1 100 0 1 227 4947 5173 Citrus x limon 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence blastn 22709 414 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x limon
18223854 18223854 PRJNA287283_P_NODE_8715_length_182_cov_0.868217_g8491_i0 PRJNA287283 8715 182 0.868217 1.58015494 Triticum aestivum 4565 Plants Plants 82.4 1.97e-11   NTclustered gi|58533118|gb|AY663392.1| 4565 g8491 i0 92.982 2.64835164835165 57 3 31 1 1 56 139869 139813 Triticum aestivum cultivar Renan clone BAC 930H14, complete sequence blastn 482 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
18223855 18223855 PRJNA287283_P_NODE_9155_length_180_cov_0.881890_g8931_i0 PRJNA287283 9155 180 0.88189 1.587402 Juglans regia 51240 Plants Plants 333 4.87e-87   NTclustered gi|1882650304|ref|XM_035686527.1| 51240 g8931 i0 100 3 180 0 100 0 1 180 710 531 PREDICTED: Juglans regia embryogenic cell protein 40 (LOC109013340), mRNA blastn 540 333 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Juglans Juglans regia
18910622 18910622 PRJNA287283_P_NODE_9115_length_180_cov_0.881890_g8891_i0 PRJNA287283 9115 180 0.88189 1.587402 Triticum 4564 Plants Plants 267 5.009999999999999e-67   NTclustered gi|1282798539|gb|MG560142.1| 4565 g8891 i0 93.333 19.8277777777778 180 12 100 0 1 180 2454304 2454483 Triticum aestivum omega gliadin-D1, omega gliadin-D2, omega gliadin-D3, gamma gliadin-D1, delta gliadin-D1, gamma gliadin-D2, gamma gliadin-D3, gamma gliadin-D4, LMW-D1, LMW-D2, LMW-D3, LMW-D6, and LMW-D7 genes, complete cds blastn 3569 267 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
20185235 20185235 PRJNA287283_P_NODE_8576_length_183_cov_0.861538_g8352_i0 PRJNA287283 8576 183 0.861538 1.57661454 Citrus 2706 Plants Plants 147 6.949999999999999e-31   NTclustered gi|2395994740|ref|XM_052432111.1| 2711 g8352 i0 100 2.15300546448087 79 0 43 0 1 79 373 295 PREDICTED: Citrus sinensis serine carboxypeptidase-like 12 (LOC127899135), mRNA blastn 394 147 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
20185236 20185236 PRJNA287283_P_NODE_8616_length_182_cov_1.736434_g8392_i0 PRJNA287283 8616 182 1.736434 3.16030988 Magnoliopsida 3398 Plants Plants 337 3.82e-88   NTclustered gi|2504382689|gb|ON479685.1| 2708 g8392 i0 100 100 182 0 100 0 1 182 6549 6730 Citrus x limon 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S large subunit ribosomal RNA gene, complete sequence blastn 18200 337 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x limon
20773683 20773683 PRJNA287283_P_NODE_6737_length_215_cov_1.716049_g6513_i0 PRJNA287283 6737 215 1.716049 3.68950535 Justicia demissa 1685546 Plants Plants 387 4.57e-103   NTclustered gi|2482680364|gb|OQ785890.1| 1685546 g6513 i0 99.074 106.018604651163 216 1 100 1 1 215 5433 5648 Justicia demissa small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 22794 387 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Acanthaceae Justicia Justicia demissa
21460935 21460935 PRJNA287283_P_NODE_3137_length_362_cov_1.511327_g2913_i0 PRJNA287283 3137 362 1.511327 5.47100374 Eukaryota 2759 Plants Plants 60.2 2.05e-4   NTclustered gi|1516499363|emb|LR031568.1| 3711 g2913 i0 100 0.301104972375691 32 0 9 0 317 348 2586359 2586328 Brassica rapa genome, scaffold: A09 blastn 109 60.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
21460938 21460938 PRJNA287283_P_NODE_6877_length_211_cov_3.050633_g6653_i0 PRJNA287283 6877 211 3.050633 6.43683563 Pinopsida 58019 Plants Plants 388 1.24e-103   NTclustered gi|115501512|gb|DQ987892.1| 64686 g6653 i0 100 102.45971563981 210 0 99 0 1 210 1373 1582 Cathaya argyrophylla 18S ribosomal RNA gene, partial sequence blastn 21619 388 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Cathaya Cathaya argyrophylla
22048643 22048643 PRJNA287283_P_NODE_8378_length_183_cov_1.484615_g8154_i0 PRJNA287283 8378 183 1.484615 2.71684545 Sequoiadendron giganteum 99814 Plants Plants 254 3.98e-63   NTclustered gi|9187620|emb|AJ271027.1| 99814 g8154 i0 91.848 10.4371584699454 184 11 100 3 1 183 2814 2994 Sequoiadendron giganteum partial 25S rRNA gene blastn 1910 254 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Sequoiadendron Sequoiadendron giganteum
22736014 22736014 PRJNA287283_P_NODE_9858_length_177_cov_0.903226_g9634_i0 PRJNA287283 9858 177 0.903226 1.59871002 Magnoliopsida 3398 Plants Plants 316 4.799999999999999e-82   NTclustered gi|18057|emb|X03641.1| 2708 g9634 i0 98.87 100.16384180791 177 2 100 0 1 177 207 31 Citrus limon 26S ribosomal RNA gene 3' region blastn 17729 316 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x limon
25285258 25285258 PRJNA287283_P_NODE_3120_length_363_cov_1.296774_g2896_i0 PRJNA287283 3120 363 1.296774 4.70728962 root 1 Root_unresolved Root_unresolved 54.7 0.01   NTclustered gi|1885270526|emb|LR862145.1| 296719 g2896 i0 96.875 0.168044077134986 32 1 9 0 231 262 721729 721760 Ananas comosus var. bracteatus genome assembly, chromosome: 17 blastn 61 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
25285262 25285262 PRJNA287283_P_NODE_8600_length_182_cov_3.821705_g8376_i0 PRJNA287283 8600 182 3.821705 6.9555031 Magnoliopsida 3398 Plants Plants 324 2.97e-84   NTclustered gi|19919546|gb|AF479105.1| 16719 g8376 i0 98.901 248.39010989011 182 0 100 2 1 182 2606 2427 Juglans nigra 26S ribosomal RNA gene, complete sequence blastn 45207 326 0.993865030674847 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Juglans Juglans nigra

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