RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB8827 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
25530349 25530349 PRJEB8827h_S_NODE_385_length_396_cov_403.462604_g366_i0 PRJEB8827 385 396 403.462604 1597.71191184 Scenedesmus sp. PABB 2909984 Plants Plants 93.6 6.98e-22   NR KAF8069428.1 2742167 g366 i0 77.8 3.3030303030303 63 14 47.7 0 394 206 37 99 KAF8069428.1 RL36 [Scenedesmus sp. PABB004] diamond 1308 93.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. PABB004
25938716 25938716 PRJEB8827h_S_NODE_41396_length_163_cov_1.875000_g41377_i0 PRJEB8827 41396 163 1.875 3.05625 Scenedesmus sp. NREL 46B-D3 2650976 Plants Plants 84.3 3.35e-18   NR KAF6263477.1 2650976 g41377 i0 74.5 0.938650306748466 51 13 93.9 0 158 6 164 214 KAF6263477.1 60S ribosomal protein L7 [Scenedesmus sp. NREL 46B-D3] diamond 153 84.3 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus sp. NREL 46B-D3
32913850 32913850 PRJEB8827c_S_NODE_1145_length_176_cov_2.553191_g1132_i0 PRJEB8827 1145 176 2.553191 4.49361616 Ostreococcus tauri 70448 Plants Plants 75.5 2.49e-14   NR XP_022840204.1 70448 g1132 i0 66 3.61363636363636 53 18 90.3 0 3 161 261 313 XP_022840204.1 G-protein beta WD-40 repeat [Ostreococcus tauri] diamond 636 75.5 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
32914170 32914170 PRJEB8827h_S_NODE_6017_length_199_cov_4.823171_g5998_i0 PRJEB8827 6017 199 4.823171 9.59811029 Bryopsis sp. KO-2 3115439 Plants Plants 41.6 0.0319   NR GMH38167.1 3041901 g5998 i0 37.3 0.889447236180904 59 37 88.9 0 186 10 26 84 GMH38167.1 hypothetical protein BSKO_06051 [Bryopsis sp. KO-2023] diamond 177 41.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Bryopsidaceae Bryopsis Bryopsis sp. KO-2023
32923267 32923267 PRJEB8827f_S_NODE_1089_length_355_cov_3.571875_g1069_i0 PRJEB8827 1089 355 3.571875 12.68015625 Chlorophyceae 3166 Plants Plants 92 6.64e-19   NR GBF96991.1 307507 g1069 i0 74.1 2.45070422535211 58 15 49 0 353 180 456 513 GBF96991.1 ATP synthase beta mitochondrial precursor [Raphidocelis subcapitata] diamond 870 92.4 0.995670995670996 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Selenastraceae Raphidocelis Raphidocelis subcapitata
32931221 32931221 PRJEB8827f_S_NODE_2297_length_279_cov_4.147541_g2277_i0 PRJEB8827 2297 279 4.147541 11.57163939 Pedinophyceae sp. YPF-7 765719 Plants Plants 48.9 3.15e-4   NR CAG9461842.1 765719 g2277 i0 60.6 0.354838709677419 33 13 35.5 0 14 112 225 257 CAG9461842.1 unnamed protein product [Pedinophyceae sp. YPF-701] diamond 99 48.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Pedinophyceae       Pedinophyceae sp. YPF-701
32948532 32948532 PRJEB8827h_S_NODE_1010_length_293_cov_4.182171_g991_i0 PRJEB8827 1010 293 4.182171 12.25376103 Ostreococcus tauri 70448 Plants Plants 72.4 1.56e-12   NR XP_022840204.1 70448 g991 i0 64.7 2.08873720136519 51 18 52.2 0 291 139 263 313 XP_022840204.1 G-protein beta WD-40 repeat [Ostreococcus tauri] diamond 612 72.4 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri
32999533 32999533 PRJEB8827f_S_NODE_21075_length_164_cov_2.844961_g21055_i0 PRJEB8827 21075 164 2.844961 4.66573604 Trebouxia sp. A1-2 2608996 Plants Plants 51.6 4.79e-7   NR KAA6429663.1 2608996 g21055 i0 63 1.68292682926829 46 17 84.1 0 26 163 1 46 KAA6429663.1 MAG: hypothetical protein FRX49_00097 [Trebouxia sp. A1-2] diamond 276 51.6 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Trebouxia Trebouxia sp. A1-2
33050819 33050819 PRJEB8827h_S_NODE_47085_length_154_cov_1.890756_g47066_i0 PRJEB8827 47085 154 1.890756 2.91176424 Chlorella sorokiniana 3076 Plants Plants 44.7 0.00235   NR PRW56493.1 3076 g47066 i0 76.9 1.28571428571429 26 6 50.6 0 150 73 605 630 PRW56493.1 heat shock 70 [Chlorella sorokiniana] diamond 198 44.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sorokiniana
33084738 33084738 PRJEB8827e_S_NODE_25630_length_172_cov_2.562044_g25602_i0 PRJEB8827 25630 172 2.562044 4.40671568 Helicosporidium sp. ATCC 5 1907511 Plants Plants 69.7 4.45e-12   NR KDD76122.1 1291522 g25602 i0 61.4 8.8953488372093 57 20 99.4 1 171 1 663 717 KDD76122.1 glycosyl hydrolase [Helicosporidium sp. ATCC 50920] diamond 1530 69.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Helicosporidium Helicosporidium sp. ATCC 50920
33136185 33136185 PRJEB8827h_S_NODE_1095_length_285_cov_2.820000_g1076_i0 PRJEB8827 1095 285 2.82 8.037 Chlamydomonas sp. UWO 241 1653778 Plants Plants 96.7 6.99e-22   NR KAG1673219.1 1653778 g1076 i0 66.2 4.12631578947368 65 22 68.4 0 283 89 193 257 KAG1673219.1 hypothetical protein FOA52_013099 [Chlamydomonas sp. UWO 241] diamond 1176 96.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas sp. UWO 241
33145338 33145338 PRJEB8827g_S_NODE_991_length_293_cov_3.872093_g970_i0 PRJEB8827 991 293 3.872093 11.34523249 Eukaryota 2759 Plants Plants 66.2 2.72e-10   NR XP_022840204.1 70448 g970 i0 64.4 2.76450511945392 45 16 46.1 0 3 137 269 313 XP_022840204.1 G-protein beta WD-40 repeat [Ostreococcus tauri] diamond 810 66.2 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus tauri

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