RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA416866" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 11 ✖

bioproject 1

  • PRJNA416866 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
11898479 11898479 PRJNA416866_P_NODE_290_length_1307_cov_5.656501_g226_i0 PRJNA416866 290 1307 5.656501 73.93046807 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 366 3.1299999999999993e-121   NR KOO23867.1 1460289 g226 i0 62.7 4.02601377199694 284 102 64.7 3 1061 216 40 321 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 5262 369 0.991869918699187 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
19545489 19545489 PRJNA416866_P_NODE_5256_length_286_cov_1.115556_g5112_i0 PRJNA416866 5256 286 1.115556 3.19049016 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 153 8.35e-45   NR KAG8463376.1 2081491 g5112 i0 68.4 1.99300699300699 95 30 99.7 0 1 285 62 156 KAG8463376.1 hypothetical protein KFE25_004887 [Diacronema lutheri] diamond 570 153 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
20821367 20821367 PRJNA416866_P_NODE_1097_length_678_cov_1.410049_g961_i0 PRJNA416866 1097 678 1.410049 9.56013222 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 242 4.63e-76   NR KAG8464529.1 2081491 g961 i0 53.8 0.986725663716814 223 100 98.2 3 666 1 81 301 KAG8464529.1 hypothetical protein KFE25_009897 [Diacronema lutheri] diamond 669 242 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26965596 26965596 PRJNA416866_P_NODE_2622_length_420_cov_1.727019_g2479_i0 PRJNA416866 2622 420 1.727019 7.2534798 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 50.4 3.05e-4   NR KAL1510187.1 97485 g2479 i0 36.3 2.54285714285714 80 51 57.1 0 420 181 107 186 KAL1510187.1 hypothetical protein AB1Y20_006517 [Prymnesium parvum] diamond 1068 50.8 0.992125984251969 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28465309 28465309 PRJNA416866_P_NODE_4246_length_320_cov_1.490347_g4103_i0 PRJNA416866 4246 320 1.490347 4.7691104 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 60.1 7.46e-8   NR KOO28189.1 1460289 g4103 i0 42.9 0.91875 98 31 91.9 3 1 294 546 618 KOO28189.1 hypothetical protein Ctob_008322 [Chrysochromulina tobinii] diamond 294 60.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28623209 28623209 PRJNA416866_P_NODE_7247_length_240_cov_2.486034_g7103_i0 PRJNA416866 7247 240 2.486034 5.9664816 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 130 1.05e-35   NR KAJ1624329.1 483367 g7103 i0 89.7 15.8125 68 7 85 0 205 2 33 100 KAJ1624329.1 ribosomal protein L15e [Pavlovales sp. CCMP2436] diamond 3795 130 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28686444 28686444 PRJNA416866_P_NODE_10687_length_205_cov_0.888889_g10543_i0 PRJNA416866 10687 205 0.888889 1.82222245 Prymnesium parvum 97485 Haptophyta other_Eukaryota 43.1 0.0161   NR KAL1523234.1 97485 g10543 i0 43.8 0.702439024390244 48 27 70.2 0 10 153 168 215 KAL1523234.1 hypothetical protein AB1Y20_018185 [Prymnesium parvum] diamond 144 43.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29254310 29254310 PRJNA416866_P_NODE_7589_length_235_cov_1.097701_g7445_i0 PRJNA416866 7589 235 1.097701 2.57959735 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 43.5 0.00905   NR XP_005779814.1 280463 g7445 i0 37.3 0.85531914893617 67 39 85.5 1 235 35 70 133 XP_005779814.1 hypothetical protein EMIHUDRAFT_114661 [Emiliania huxleyi CCMP1516] diamond 201 43.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30707460 30707460 PRJNA416866_P_NODE_8554_length_220_cov_1.610063_g8410_i0 PRJNA416866 8554 220 1.610063 3.5421386 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 79.7 2.51e-15   NR KAL3909622.1 2812485 g8410 i0 58.3 0.981818181818182 72 29 96.8 1 3 215 583 654 KAL3909622.1 MAG: hypothetical protein SGPRY_009357 [Prymnesium sp.] diamond 216 79.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30833875 30833875 PRJNA416866_P_NODE_9614_length_209_cov_0.864865_g9470_i0 PRJNA416866 9614 209 0.864865 1.80756785 Raphidocystis contractilis 2792838 Root_unresolved Root_unresolved 103 1.2399999999999999e-23   NR BBB87256.1 2792838 g9470 i0 92.2 3.83253588516746 64 5 91.9 0 3 194 610 673 BBB87256.1 major vault protein [Raphidocystis contractilis] diamond 801 103 1 Eukaryota Haptista     Centroplasthelida Acanthocystida Raphidocystidae Raphidocystis Raphidocystis contractilis
32510357 32510357 PRJNA416866_P_NODE_10779_length_205_cov_0.888889_g10635_i0 PRJNA416866 10779 205 0.888889 1.82222245 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 83.6 6.08e-17   NR XP_005777698.1 280463 g10635 i0 51.6 0.936585365853659 64 31 93.7 0 193 2 168 231 XP_005777698.1 peptidase family M48 [Emiliania huxleyi CCMP1516] diamond 192 83.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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