RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA561138" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA561138 · 17 ✖

analysis 1

  • diamond · 17 ✖

tax_kingdom 0

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
26826094 26826094 PRJNA561138_P_NODE_15941_length_329_cov_0.902344_g15746_i0 PRJNA561138 15941 329 0.902344 2.96871176 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 184 4.17e-52   NR CAJ1382445.1 2562239 g15746 i0 100 0.811550151975684 89 0 81.2 0 2 268 659 747 CAJ1382445.1 unnamed protein product [Effrenium voratum] diamond 267 184 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
27047497 27047497 PRJNA561138_P_NODE_16142_length_327_cov_0.881890_g15947_i0 PRJNA561138 16142 327 0.88189 2.8837803 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 186 2.71e-53   NR CAJ1398870.1 2562239 g15947 i0 82.4 0.990825688073395 108 19 99.1 0 325 2 480 587 CAJ1398870.1 unnamed protein product [Effrenium voratum] diamond 324 186 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
27079074 27079074 PRJNA561138_P_NODE_25382_length_250_cov_0.870056_g25187_i0 PRJNA561138 25382 250 0.870056 2.17514 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 47.4 9.77e-4   NR CAJ1374272.1 2562239 g25187 i0 100 0.276 23 0 27.6 0 79 147 927 949 CAJ1374272.1 unnamed protein product [Effrenium voratum] diamond 69 47.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
27110496 27110496 PRJNA561138_P_NODE_6602_length_483_cov_0.856098_g6408_i0 PRJNA561138 6602 483 0.856098 4.13495334 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 169 4.33e-45   NR OLP93893.1 2951 g6408 i0 52.1 3.02484472049689 163 75 99.4 1 2 481 1194 1356 OLP93893.1 hypothetical protein AK812_SmicGene24167 [Symbiodinium microadriaticum] diamond 1461 169 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27332122 27332122 PRJNA561138_P_NODE_24683_length_251_cov_0.865169_g24488_i0 PRJNA561138 24683 251 0.865169 2.17157419 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 142 4.69e-38   NR XP_001007359.2 312017 g24488 i0 91.9 0.884462151394422 74 6 88.4 0 250 29 371 444 XP_001007359.2 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 222 142 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27426925 27426925 PRJNA561138_P_NODE_29683_length_242_cov_0.881657_g29488_i0 PRJNA561138 29683 242 0.881657 2.13360994 Symbiodinium natans 878477 SAR_Eukaryotes SAR_Eukaryotes 123 1.39e-30   NR CAE7560940.1 878477 g29488 i0 72.5 0.991735537190083 80 22 99.2 0 2 241 439 518 CAE7560940.1 RE1 [Symbiodinium natans] diamond 240 123 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium natans
27711336 27711336 PRJNA561138_P_NODE_29444_length_242_cov_0.911243_g29249_i0 PRJNA561138 29444 242 0.911243 2.20520806 Symbiodinium pilosum 2952 SAR_Eukaryotes SAR_Eukaryotes 50.1 9.93e-5   NR CAE7248469.1 2952 g29249 i0 46.3 0.508264462809917 41 22 50.8 0 13 135 84 124 CAE7248469.1 JNK, partial [Symbiodinium pilosum] diamond 123 50.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium pilosum
27931923 27931923 PRJNA561138_P_NODE_10225_length_401_cov_0.939024_g10030_i0 PRJNA561138 10225 401 0.939024 3.76548624 Cladocopium goreaui 2562237 SAR_Eukaryotes SAR_Eukaryotes 74.3 2.02e-12   NR CAL1171563.1 2562237 g10030 i0 77.3 1.97506234413965 44 10 32.9 0 205 74 242 285 CAL1171563.1 unnamed protein product [Cladocopium goreaui] diamond 792 74.3 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui
28437230 28437230 PRJNA561138_P_NODE_16506_length_323_cov_0.904000_g16311_i0 PRJNA561138 16506 323 0.904 2.91992 Symbiodinium sp. CCMP2592 631055 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.25e-8   NR CAE7784667.1 631055 g16311 i0 42 1.63467492260062 88 50 80.8 1 313 53 800 887 CAE7784667.1 unnamed protein product [Symbiodinium sp. CCMP2592] diamond 528 62.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2592
28437233 28437233 PRJNA561138_P_NODE_29246_length_242_cov_1.307692_g29051_i0 PRJNA561138 29246 242 1.307692 3.16461464 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 168 9.42e-47   NR CAJ1333746.1 2562239 g29051 i0 97.5 1.98347107438017 80 2 99.2 0 242 3 199 278 CAJ1333746.1 unnamed protein product, partial [Effrenium voratum] diamond 480 168 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
28563489 28563489 PRJNA561138_P_NODE_24507_length_251_cov_0.865169_g24312_i0 PRJNA561138 24507 251 0.865169 2.17157419 Cladocopium goreaui 2562237 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00895   NR CAL1140379.1 2562237 g24312 i0 36.6 0.848605577689243 71 44 83.7 1 41 250 2930 3000 CAL1140379.1 unnamed protein product, partial [Cladocopium goreaui] diamond 213 44.7 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui
29605010 29605010 PRJNA561138_P_NODE_28170_length_244_cov_1.467836_g27975_i0 PRJNA561138 28170 244 1.467836 3.58151984 Symbiodinium sp. KB8 230985 SAR_Eukaryotes SAR_Eukaryotes 64.7 4.9e-10   NR CAE7848699.1 230985 g27975 i0 42.2 1.02049180327869 83 45 98.4 2 4 243 9 91 CAE7848699.1 unnamed protein product [Symbiodinium sp. KB8] diamond 249 64.7 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. KB8
30679193 30679193 PRJNA561138_P_NODE_17293_length_315_cov_0.876033_g17098_i0 PRJNA561138 17293 315 0.876033 2.75950395 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 136 9.76e-35   NR CAJ1381986.1 2562239 g17098 i0 83.7 0.819047619047619 86 3 71.4 1 3 227 1258 1343 CAJ1381986.1 unnamed protein product, partial [Effrenium voratum] diamond 258 136 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
31184650 31184650 PRJNA561138_P_NODE_25175_length_250_cov_0.870056_g24980_i0 PRJNA561138 25175 250 0.870056 2.17514 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 70.1 8.09e-14   NR KAJ1438204.1 483371 g24980 i0 80 0.96 40 8 48 0 123 4 21 60 KAJ1438204.1 hypothetical protein B484DRAFT_392436 [Ochromonadaceae sp. CCMP2298] diamond 240 70.1 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32197228 32197228 PRJNA561138_P_NODE_9258_length_416_cov_0.897959_g9063_i0 PRJNA561138 9258 416 0.897959 3.73550944 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0492   NR CAE7481164.1 2951 g9063 i0 32.8 0.418269230769231 58 39 41.8 0 178 351 748 805 CAE7481164.1 unnamed protein product [Symbiodinium microadriaticum] diamond 174 44.7 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32576971 32576971 PRJNA561138_P_NODE_8019_length_441_cov_0.836957_g7824_i0 PRJNA561138 8019 441 0.836957 3.69098037 Symbiodinium sp. CCMP2592 631055 SAR_Eukaryotes SAR_Eukaryotes 125 5.88e-30   NR CAE6962770.1 631055 g7824 i0 55.3 5.38775510204082 132 51 87.8 4 10 396 2244 2370 CAE6962770.1 unnamed protein product [Symbiodinium sp. CCMP2592] diamond 2376 125 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2592
32796950 32796950 PRJNA561138_P_NODE_11360_length_384_cov_0.990354_g11165_i0 PRJNA561138 11360 384 0.990354 3.80295936 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 254 6.86e-76   NR CAJ1335232.1 2562239 g11165 i0 99.2 1 128 1 100 0 1 384 357 484 CAJ1335232.1 unnamed protein product [Effrenium voratum] diamond 384 254 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum

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