RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA906294" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 25 ✖

bioproject 1

  • PRJNA906294 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
4716533 4716533 PRJNA906294_P_NODE_217784_length_245_cov_1.976744_g213668_i0 PRJNA906294 217784 245 1.976744 4.8430228 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 4.500000000000001e-28   NR XP_005792577.1 280463 g213668 i0 65.8 4.84897959183674 79 26 96.7 1 239 3 1 78 XP_005792577.1 hypothetical protein EMIHUDRAFT_422986 [Emiliania huxleyi CCMP1516] diamond 1188 115 0.991304347826087 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
5990969 5990969 PRJNA906294_P_NODE_200765_length_254_cov_2.314917_g196649_i0 PRJNA906294 200765 254 2.314917 5.87988918 root 1 Root_unresolved Root_unresolved 99 1.86e-23   NR KAJ1640283.1 483367 g196649 i0 64.3 29.9527559055118 70 25 82.7 0 2 211 150 219 KAJ1640283.1 Manganese/iron superoxide dismutase [Pavlovales sp. CCMP2436] diamond 7608 99.8 0.991983967935872 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
8542336 8542336 PRJNA906294_P_NODE_69607_length_549_cov_1.275210_g65507_i0 PRJNA906294 69607 549 1.27521 7.0009029 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 255 2.0599999999999998e-82   NR KAL1498655.1 97485 g65507 i0 66.5 9.02732240437158 182 61 99.5 0 1 546 57 238 KAL1498655.1 hypothetical protein AB1Y20_013968 [Prymnesium parvum] diamond 4956 256 0.99609375 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11091743 11091743 PRJNA906294_P_NODE_221729_length_244_cov_0.900585_g217613_i0 PRJNA906294 221729 244 0.900585 2.1974274 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 134 9.529999999999999e-35   NR KAL1496000.1 97485 g217613 i0 83.5 3.86065573770492 79 13 97.1 0 244 8 260 338 KAL1496000.1 hypothetical protein AB1Y20_014636 [Prymnesium parvum] diamond 942 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
12366925 12366925 PRJNA906294_P_NODE_20750_length_1278_cov_2.550207_g18125_i0 PRJNA906294 20750 1278 2.550207 32.59164546 Prymnesium parvum 97485 Haptophyta other_Eukaryota 414 2.0899999999999996e-133   NR KAL1526066.1 97485 g18125 i0 52.7 3.04929577464789 429 195 99.3 3 4 1272 393 819 KAL1526066.1 hypothetical protein AB1Y20_020887 [Prymnesium parvum] diamond 3897 414 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
17467851 17467851 PRJNA906294_P_NODE_78034_length_502_cov_3.060606_g73925_i0 PRJNA906294 78034 502 3.060606 15.36424212 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 236 5.39e-77   NR KAG8461279.1 2081491 g73925 i0 71.4 11.6593625498008 161 46 96.2 0 19 501 1 161 KAG8461279.1 hypothetical protein KFE25_010466 [Diacronema lutheri] diamond 5853 236 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
20016009 20016009 PRJNA906294_P_NODE_71716_length_536_cov_1.622030_g67614_i0 PRJNA906294 71716 536 1.62203 8.6940808 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 227 4.33e-67   NR KAG8463458.1 2081491 g67614 i0 63.1 7.97574626865672 179 65 99.6 1 3 536 440 618 KAG8463458.1 hypothetical protein KFE25_004969 [Diacronema lutheri] diamond 4275 227 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
21291690 21291690 PRJNA906294_P_NODE_84657_length_471_cov_7.366834_g80543_i0 PRJNA906294 84657 471 7.366834 34.69778814 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 207 5.77e-66   NR KAL1523551.1 97485 g80543 i0 72 1.91082802547771 150 40 94.3 1 12 455 1 150 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 900 209 0.990430622009569 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26992464 26992464 PRJNA906294_P_NODE_226962_length_242_cov_1.331361_g222846_i0 PRJNA906294 226962 242 1.331361 3.22189362 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 77.8 1.67e-14   NR KAG8465477.1 2081491 g222846 i0 56 0.929752066115702 75 32 93 1 232 8 562 635 KAG8465477.1 hypothetical protein KFE25_002784 [Diacronema lutheri] diamond 225 77.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27150334 27150334 PRJNA906294_P_NODE_203082_length_252_cov_1.698324_g198966_i0 PRJNA906294 203082 252 1.698324 4.27977648 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 102 1.32e-26   NR KOO35440.1 1460289 g198966 i0 88.3 2.1547619047619 60 7 71.4 0 244 65 1 60 KOO35440.1 40s ribosomal protein s30 [Chrysochromulina tobinii] diamond 543 102 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27157963 27157963 PRJNA906294_P_NODE_148882_length_313_cov_1.475000_g144766_i0 PRJNA906294 148882 313 1.475 4.61675 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 62 3.82e-9   NR XP_005784096.1 280463 g144766 i0 39.5 3.91054313099042 76 46 72.8 0 243 16 26 101 XP_005784096.1 ATP synthase O subunit mitochondrial precursor [Emiliania huxleyi CCMP1516] diamond 1224 62.4 0.993589743589744 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27624752 27624752 PRJNA906294_P_NODE_136924_length_331_cov_2.434109_g132808_i0 PRJNA906294 136924 331 2.434109 8.05690079 Prymnesium parvum 97485 Haptophyta other_Eukaryota 51.6 4.43e-5   NR KAL1510286.1 97485 g132808 i0 72.4 0.570996978851964 29 8 26.3 0 308 222 110 138 KAL1510286.1 hypothetical protein AB1Y20_006606 [Prymnesium parvum] diamond 189 51.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28035212 28035212 PRJNA906294_P_NODE_31185_length_987_cov_2.284464_g27840_i0 PRJNA906294 31185 987 2.284464 22.54765968 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 228 9.58e-70   NR KAG8462568.1 2081491 g27840 i0 49.6 0.772036474164134 254 120 76.6 2 52 807 1 248 KAG8462568.1 hypothetical protein KFE25_010393 [Diacronema lutheri] diamond 762 228 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28066655 28066655 PRJNA906294_P_NODE_82825_length_480_cov_1.120393_g78711_i0 PRJNA906294 82825 480 1.120393 5.3778864 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 66.6 1.76e-9   NR KOO21284.1 1460289 g78711 i0 31.7 0.75 120 70 69.4 3 349 17 247 363 KOO21284.1 mpv17 protein [Chrysochromulina tobinii] diamond 360 66.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28918986 28918986 PRJNA906294_P_NODE_213508_length_247_cov_0.873563_g209392_i0 PRJNA906294 213508 247 0.873563 2.15770061 Prymnesium parvum 97485 Haptophyta other_Eukaryota 68.6 3.05e-11   NR KAL1511966.1 97485 g209392 i0 81.8 1.10526315789474 33 6 40.1 0 147 245 22 54 KAL1511966.1 hypothetical protein AB1Y20_005246 [Prymnesium parvum] diamond 273 68.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28982552 28982552 PRJNA906294_P_NODE_7468_length_2123_cov_3.933171_g6339_i0 PRJNA906294 7468 2123 3.933171 83.50122033 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 120 7.399999999999998e-25   NR XP_005759595.1 280463 g6339 i0 34.9 0.416862929816298 295 161 39.4 11 1095 1931 161 440 XP_005759595.1 von Willebrand factor type A domain-containing protein [Emiliania huxleyi CCMP1516] diamond 885 120 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29708128 29708128 PRJNA906294_P_NODE_96430_length_427_cov_1.553672_g92315_i0 PRJNA906294 96430 427 1.553672 6.63417944 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 75.9 6.37e-13   NR KOO31798.1 1460289 g92315 i0 33.1 1.84074941451991 130 81 89.9 3 40 423 6 131 KOO31798.1 histone-binding protein rbbp4 [Chrysochromulina tobinii] diamond 786 75.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29715739 29715739 PRJNA906294_P_NODE_153970_length_306_cov_1.304721_g149854_i0 PRJNA906294 153970 306 1.304721 3.99244626 root 1 Root_unresolved Root_unresolved 110 3.37e-26   NR KOO52755.1 1460289 g149854 i0 47.5 6.58823529411765 99 49 96.1 2 2 295 246 342 KOO52755.1 glycosyl family 30 [Chrysochromulina tobinii] diamond 2016 111 0.990990990990991 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29842310 29842310 PRJNA906294_P_NODE_229931_length_241_cov_1.285714_g225815_i0 PRJNA906294 229931 241 1.285714 3.09857074 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 107 1.05e-25   NR KAL1520839.1 97485 g225815 i0 65.8 6.84647302904564 79 27 98.3 0 3 239 134 212 KAL1520839.1 hypothetical protein AB1Y20_022401 [Prymnesium parvum] diamond 1650 108 0.990740740740741 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29905660 29905660 PRJNA906294_P_NODE_92751_length_440_cov_1.389646_g88637_i0 PRJNA906294 92751 440 1.389646 6.1144424 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 139 5.1e-36   NR KAL1496496.1 97485 g88637 i0 50.3 9.35454545454546 155 64 99.5 5 440 3 257 407 KAL1496496.1 hypothetical protein AB1Y20_016450 [Prymnesium parvum] diamond 4116 140 0.992857142857143 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30340840 30340840 PRJNA906294_P_NODE_220492_length_244_cov_3.269006_g216376_i0 PRJNA906294 220492 244 3.269006 7.97637464 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 70.9 1.25e-13   NR XP_005782836.1 280463 g216376 i0 57.1 2.55737704918033 70 27 86.1 1 9 218 48 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 624 70.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30505854 30505854 PRJNA906294_P_NODE_67593_length_561_cov_1.590164_g63500_i0 PRJNA906294 67593 561 1.590164 8.92082004 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 93.2 2.92e-20   NR KAG8469711.1 2081491 g63500 i0 43.9 1.98395721925134 123 60 64.7 2 368 6 44 159 KAG8469711.1 hypothetical protein KFE25_006166 [Diacronema lutheri] diamond 1113 93.6 0.995726495726496 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30972343 30972343 PRJNA906294_P_NODE_223074_length_244_cov_0.888889_g218958_i0 PRJNA906294 223074 244 0.888889 2.16888916 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 49.7 1.25e-4   NR KOO22191.1 1460289 g218958 i0 39.7 0.959016393442623 78 39 89.8 2 24 242 11 85 KOO22191.1 drug metabolite transporter superfamily [Chrysochromulina tobinii] diamond 234 49.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31192989 31192989 PRJNA906294_P_NODE_132695_length_339_cov_1.018797_g128579_i0 PRJNA906294 132695 339 1.018797 3.45372183 Prymnesium parvum 97485 Haptophyta other_Eukaryota 132 1.98e-33   NR KAL1523567.1 97485 g128579 i0 70 0.79646017699115 90 27 79.6 0 275 6 437 526 KAL1523567.1 hypothetical protein AB1Y20_018503 [Prymnesium parvum] diamond 270 132 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31351575 31351575 PRJNA906294_P_NODE_115416_length_374_cov_1.106312_g111301_i0 PRJNA906294 115416 374 1.106312 4.13760688 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 89 9.14e-18   NR KOO21324.1 1460289 g111301 i0 39.2 1.99732620320856 120 71 94.7 2 373 20 212 331 KOO21324.1 bardet-biedl syndrome 7 protein [Chrysochromulina tobinii] diamond 747 89 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii

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