RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJEB7366" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 14 ✖

bioproject 1

  • PRJEB7366 · 14 ✖

analysis 1

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
3546090 3546090 PRJEB7366_P_NODE_10603_length_253_cov_1.467890_g10169_i0 PRJEB7366 10603 253 1.46789 3.7137617 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 129 8.73e-34   NR KOO29482.1 1460289 g10169 i0 67.8 2.06324110671937 87 25 99.6 1 2 253 163 249 KOO29482.1 mitogen-activated protein kinase [Chrysochromulina tobinii] diamond 522 129 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
26844503 26844503 PRJEB7366_P_NODE_5761_length_373_cov_1.547337_g5328_i0 PRJEB7366 5761 373 1.547337 5.77156701 Prymnesium parvum 97485 Haptophyta other_Eukaryota 67.8 1.74e-10   NR KAL1520312.1 97485 g5328 i0 34.4 1.00536193029491 125 73 98.9 3 5 373 85 202 KAL1520312.1 hypothetical protein AB1Y20_021903 [Prymnesium parvum] diamond 375 67.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27855390 27855390 PRJEB7366_P_NODE_20225_length_169_cov_1.470149_g19791_i0 PRJEB7366 20225 169 1.470149 2.48455181 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 72.4 4.76e-13   NR KAG8464196.1 2081491 g19791 i0 54.5 0.976331360946746 55 25 97.6 0 166 2 460 514 KAG8464196.1 hypothetical protein KFE25_003259 [Diacronema lutheri] diamond 165 72.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27918486 27918486 PRJEB7366_P_NODE_17905_length_181_cov_2.184932_g17471_i0 PRJEB7366 17905 181 2.184932 3.95472692 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.1 0.00256   NR KAL1519075.1 97485 g17471 i0 71.9 0.530386740331492 32 8 53 1 156 61 40 70 KAL1519075.1 hypothetical protein AB1Y20_003342 [Prymnesium parvum] diamond 96 45.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28802402 28802402 PRJEB7366_P_NODE_14068_length_211_cov_0.909091_g13634_i0 PRJEB7366 14068 211 0.909091 1.91818201 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 90.1 4.93e-19   NR BBB87256.1 2792838 g13634 i0 61.2 0.95260663507109 67 26 95.3 0 209 9 757 823 BBB87256.1 major vault protein [Raphidocystis contractilis] diamond 201 90.1 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
29024056 29024056 PRJEB7366_P_NODE_14588_length_206_cov_1.631579_g14154_i0 PRJEB7366 14588 206 1.631579 3.36105274 Prymnesium parvum 97485 Haptophyta other_Eukaryota 117 2.08e-29   NR KAL1495976.1 97485 g14154 i0 85.9 0.932038834951456 64 9 93.2 0 3 194 361 424 KAL1495976.1 hypothetical protein AB1Y20_014616 [Prymnesium parvum] diamond 192 117 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29433831 29433831 PRJEB7366_P_NODE_17370_length_185_cov_1.066667_g16936_i0 PRJEB7366 17370 185 1.066667 1.97333395 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 84 5.14e-17   NR KAG8468614.1 2081491 g16936 i0 58.1 1.00540540540541 62 25 98.9 1 3 185 770 831 KAG8468614.1 hypothetical protein KFE25_013697 [Diacronema lutheri] diamond 186 84 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30255634 30255634 PRJEB7366_P_NODE_15372_length_199_cov_1.609756_g14938_i0 PRJEB7366 15372 199 1.609756 3.20341444 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 43.5 0.0111   NR KOO31924.1 1460289 g14938 i0 50 0.57286432160804 38 19 57.3 0 71 184 87 124 KOO31924.1 RNA-binding protein 42 [Chrysochromulina tobinii] diamond 114 43.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30287334 30287334 PRJEB7366_P_NODE_8052_length_302_cov_1.647940_g7618_i0 PRJEB7366 8052 302 1.64794 4.9767788 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 61.2 9.14e-9   NR XP_005783668.1 280463 g7618 i0 60.5 0.377483443708609 38 15 37.7 0 179 292 52 89 XP_005783668.1 hypothetical protein EMIHUDRAFT_456383 [Emiliania huxleyi CCMP1516] diamond 114 61.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31227447 31227447 PRJEB7366_P_NODE_15675_length_197_cov_0.987654_g15241_i0 PRJEB7366 15675 197 0.987654 1.94567838 Prymnesiales 73028 Haptophyta other_Eukaryota 81.3 5.34e-16   NR KAL1525905.1 97485 g15241 i0 64.6 2.95431472081218 65 23 99 0 3 197 331 395 KAL1525905.1 hypothetical protein AB1Y20_020733 [Prymnesium parvum] diamond 582 81.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31266473 31266473 PRJEB7366_P_NODE_22435_length_159_cov_1.612903_g22001_i0 PRJEB7366 22435 159 1.612903 2.56451577 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 80.1 6.75e-16   NR KOO32230.1 1460289 g22001 i0 70.6 0.962264150943396 51 15 96.2 0 3 155 77 127 KOO32230.1 nucleoredoxin 1 [Chrysochromulina tobinii] diamond 153 80.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31393115 31393115 PRJEB7366_P_NODE_20076_length_170_cov_1.185185_g19642_i0 PRJEB7366 20076 170 1.185185 2.0148145 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 43.5 0.0074400000000000004   NR XP_005780741.1 280463 g19642 i0 41.3 0.811764705882353 46 27 81.2 0 1 138 186 231 XP_005780741.1 hypothetical protein EMIHUDRAFT_463067 [Emiliania huxleyi CCMP1516] diamond 138 43.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31424527 31424527 PRJEB7366_P_NODE_13496_length_216_cov_1.988950_g13062_i0 PRJEB7366 13496 216 1.98895 4.296132 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 68.2 1.6e-12   NR XP_005769005.1 280463 g13062 i0 42.3 1.91666666666667 71 41 98.6 0 216 4 17 87 XP_005769005.1 hypothetical protein EMIHUDRAFT_244952 [Emiliania huxleyi CCMP1516] diamond 414 68.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31424541 31424541 PRJEB7366_P_NODE_6716_length_339_cov_1.842105_g6282_i0 PRJEB7366 6716 339 1.842105 6.24473595 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 136 1.46e-38   NR KAJ1638552.1 483367 g6282 i0 63.4 2.95575221238938 112 40 99.1 1 337 2 8 118 KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436] diamond 1002 136 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436

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