RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 22 ✖

bioproject 1

  • PRJNA781196 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
10963279 10963279 PRJNA781196_P_NODE_30089_length_320_cov_1.157895_g29712_i0 PRJNA781196 30089 320 1.157895 3.705264 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 160 3.26e-46   NR KOO31611.1 1460289 g29712 i0 72.4 0.984375 105 29 98.4 0 317 3 161 265 KOO31611.1 hydroxyacyl-coenzyme a mitochondrial precursor [Chrysochromulina tobinii] diamond 315 160 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27085173 27085173 PRJNA781196_P_NODE_40222_length_282_cov_1.492823_g39845_i0 PRJNA781196 40222 282 1.492823 4.20976086 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 61.6 1.31e-8   NR KOO22224.1 1460289 g39845 i0 40.2 0.978723404255319 92 47 94.7 2 14 280 401 487 KOO22224.1 hypothetical protein Ctob_005412 [Chrysochromulina tobinii] diamond 276 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27094475 27094475 PRJNA781196_P_NODE_52422_length_252_cov_0.871508_g52045_i0 PRJNA781196 52422 252 0.871508 2.19620016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 109 1.18e-25   NR KAL1518638.1 97485 g52045 i0 62.4 9.98809523809524 85 31 100 1 252 1 323 407 KAL1518638.1 hypothetical protein AB1Y20_002926 [Prymnesium parvum] diamond 2517 109 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27338100 27338100 PRJNA781196_P_NODE_4223_length_743_cov_5.489552_g3879_i0 PRJNA781196 4223 743 5.489552 40.78737136 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 79.3 7.27e-13   NR KAL3899099.1 2812485 g3879 i0 39.7 0.508748317631225 126 64 47.2 4 741 391 416 538 KAL3899099.1 MAG: hypothetical protein SGPRY_012703, partial [Prymnesium sp.] diamond 378 79.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
27568313 27568313 PRJNA781196_P_NODE_46104_length_264_cov_1.198953_g45727_i0 PRJNA781196 46104 264 1.198953 3.16523592 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 108 3.4e-25   NR KAG8467851.1 2081491 g45727 i0 58.6 3.90909090909091 87 35 98.9 1 3 263 281 366 KAG8467851.1 hypothetical protein KFE25_006903 [Diacronema lutheri] diamond 1032 108 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27843040 27843040 PRJNA781196_P_NODE_42724_length_274_cov_1.393035_g42347_i0 PRJNA781196 42724 274 1.393035 3.8169159 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 48.5 4.13e-4   NR KOO34512.1 1460289 g42347 i0 29 0.755474452554745 69 44 70.1 2 16 207 53 121 KOO34512.1 hypothetical protein Ctob_010233 [Chrysochromulina tobinii] diamond 207 48.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28221886 28221886 PRJNA781196_P_NODE_18526_length_389_cov_1.974684_g18149_i0 PRJNA781196 18526 389 1.974684 7.68152076 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 168 8.599999999999999e-49   NR KAJ1620885.1 483367 g18149 i0 62.8 4.9280205655527 129 48 99.5 0 389 3 117 245 KAJ1620885.1 small nucleolar RNA, C/D box 21 [Pavlovales sp. CCMP2436] diamond 1917 168 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28231221 28231221 PRJNA781196_P_NODE_32706_length_309_cov_0.961864_g32329_i0 PRJNA781196 32706 309 0.961864 2.97215976 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 115 1.84e-30   NR ALD47893.1 2903 g32329 i0 80 6.77669902912621 70 14 68 0 96 305 74 143 ALD47893.1 adaptor protein complex 4 subunit sigma [Emiliania huxleyi] diamond 2094 115 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28474717 28474717 PRJNA781196_P_NODE_16606_length_408_cov_0.823881_g16229_i0 PRJNA781196 16606 408 0.823881 3.36143448 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 52.8 6.13e-5   NR XP_005767886.1 280463 g16229 i0 59 0.286764705882353 39 14 27.2 1 134 244 324 362 XP_005767886.1 hypothetical protein EMIHUDRAFT_470551 [Emiliania huxleyi CCMP1516] diamond 117 52.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28705206 28705206 PRJNA781196_P_NODE_45087_length_267_cov_1.092784_g44710_i0 PRJNA781196 45087 267 1.092784 2.91773328 Centroplasthelida 193537 Haptophyta other_Eukaryota 112 2.14e-26   NR KAL1526066.1 97485 g44710 i0 65.9 2.87640449438202 88 30 98.9 0 2 265 781 868 KAL1526066.1 hypothetical protein AB1Y20_020887 [Prymnesium parvum] diamond 768 113 0.991150442477876 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28853395 28853395 PRJNA781196_P_NODE_53688_length_251_cov_0.876404_g53311_i0 PRJNA781196 53688 251 0.876404 2.19977404 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 44.3 0.0111   NR XP_005764043.1 280463 g53311 i0 34.2 1.74501992031873 73 43 83.7 2 227 18 180 250 XP_005764043.1 hypothetical protein EMIHUDRAFT_214467 [Emiliania huxleyi CCMP1516] diamond 438 44.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29453121 29453121 PRJNA781196_P_NODE_18590_length_389_cov_0.987342_g18213_i0 PRJNA781196 18590 389 0.987342 3.84076038 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 113 3.72e-26   NR XP_005790123.1 280463 g18213 i0 45.7 2.96915167095116 129 66 98.7 2 385 2 203 328 XP_005790123.1 putative nitric oxide dioxygenase [Emiliania huxleyi CCMP1516] diamond 1155 113 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29863958 29863958 PRJNA781196_P_NODE_65131_length_243_cov_0.917647_g64754_i0 PRJNA781196 65131 243 0.917647 2.22988221 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 49.7 1.35e-4   NR XP_005775434.1 280463 g64754 i0 45.5 0.54320987654321 44 24 54.3 0 106 237 108 151 XP_005775434.1 hypothetical protein EMIHUDRAFT_447768 [Emiliania huxleyi CCMP1516] diamond 132 49.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30022089 30022089 PRJNA781196_P_NODE_56671_length_249_cov_0.886364_g56294_i0 PRJNA781196 56671 249 0.886364 2.20704636 Prymnesium parvum 97485 Haptophyta other_Eukaryota 109 4.54e-26   NR KAL1522495.1 97485 g56294 i0 61 1.91566265060241 82 32 98.8 0 2 247 61 142 KAL1522495.1 hypothetical protein AB1Y20_017483 [Prymnesium parvum] diamond 477 109 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30433038 30433038 PRJNA781196_P_NODE_5153_length_678_cov_1.661157_g4790_i0 PRJNA781196 5153 678 1.661157 11.26264446 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 73.2 5.75e-11   NR KAL3899099.1 2812485 g4790 i0 37.9 0.384955752212389 87 52 38.5 1 661 401 454 538 KAL3899099.1 MAG: hypothetical protein SGPRY_012703, partial [Prymnesium sp.] diamond 261 73.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30653658 30653658 PRJNA781196_P_NODE_43693_length_271_cov_1.181818_g43316_i0 PRJNA781196 43693 271 1.181818 3.20272678 Prymnesium parvum 97485 Haptophyta other_Eukaryota 123 2.19e-31   NR KAL1523991.1 97485 g43316 i0 66.3 1.8929889298893 83 28 91.9 0 21 269 61 143 KAL1523991.1 hypothetical protein AB1Y20_018906 [Prymnesium parvum] diamond 513 123 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30748667 30748667 PRJNA781196_P_NODE_58554_length_247_cov_1.419540_g58177_i0 PRJNA781196 58554 247 1.41954 3.5062638 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 72.4 1.28e-12   NR KOO28186.1 1460289 g58177 i0 81.6 2.89068825910931 38 7 46.2 0 47 160 3 40 KOO28186.1 actin-like protein [Chrysochromulina tobinii] diamond 714 72.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30811766 30811766 PRJNA781196_P_NODE_554_length_1646_cov_5.638271_g461_i0 PRJNA781196 554 1646 5.638271 92.80594066 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 121 2.62e-25   NR KAL3899099.1 2812485 g461 i0 36.1 0.444714459295261 244 124 39.2 9 1074 430 298 538 KAL3899099.1 MAG: hypothetical protein SGPRY_012703, partial [Prymnesium sp.] diamond 732 121 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31001453 31001453 PRJNA781196_P_NODE_27134_length_333_cov_2.830769_g26757_i0 PRJNA781196 27134 333 2.830769 9.42646077 Prymnesium parvum 97485 Haptophyta other_Eukaryota 127 8.179999999999998e-35   NR KAL1523551.1 97485 g26757 i0 61.6 2.68468468468468 99 38 89.2 0 298 2 1 99 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 894 127 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31421718 31421718 PRJNA781196_P_NODE_11836_length_471_cov_2.552764_g11460_i0 PRJNA781196 11836 471 2.552764 12.02351844 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 148 1.13e-42   NR KAL1514807.1 97485 g11460 i0 58.3 20.9363057324841 139 55 87.9 2 452 39 4 140 KAL1514807.1 hypothetical protein AB1Y20_003893 [Prymnesium parvum] diamond 9861 149 0.993288590604027 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31570724 31570724 PRJNA781196_P_NODE_61696_length_245_cov_1.104651_g61319_i0 PRJNA781196 61696 245 1.104651 2.70639495 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 120 5.279999999999999e-31   NR KAG8466066.1 2081491 g61319 i0 75.3 0.991836734693878 81 19 98 1 2 241 198 278 KAG8466066.1 hypothetical protein KFE25_005636 [Diacronema lutheri] diamond 243 120 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31602277 31602277 PRJNA781196_P_NODE_4196_length_746_cov_1.491828_g3852_i0 PRJNA781196 4196 746 1.491828 11.12903688 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 75.1 2.39e-11   NR XP_005794494.1 280463 g3852 i0 30.1 0.546916890080429 136 88 52.3 2 244 633 3 137 XP_005794494.1 insulin degrading metallo proteinase [Emiliania huxleyi CCMP1516] diamond 408 75.1 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);;