RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA756891", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 21 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 21 ✖

bioproject 1

  • PRJNA756891 · 21 ✖

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
7580214 7580214 PRJNA756891_P_NODE_1966_length_592_cov_1.427746_g1899_i0 PRJNA756891 1966 592 1.427746 8.45225632 root 1 Root_unresolved Root_unresolved 145 2.3299999999999997e-37   NR XP_005783951.1 280463 g1899 i0 43.6 9.70439189189189 211 103 99.3 4 590 3 177 386 XP_005783951.1 hypothetical protein EMIHUDRAFT_456273 [Emiliania huxleyi CCMP1516] diamond 5745 145 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
8385356 8385356 PRJNA756891_P_NODE_987_length_806_cov_2.373806_g927_i0 PRJNA756891 987 806 2.373806 19.13287636 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 299 3.8099999999999994e-99   NR KAG8461791.1 2081491 g927 i0 87.8 13.0682382133995 156 19 58.1 0 529 62 63 218 KAG8461791.1 hypothetical protein KFE25_001409 [Diacronema lutheri] diamond 10533 299 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
9660514 9660514 PRJNA756891_P_NODE_5708_length_355_cov_2.992908_g5639_i0 PRJNA756891 5708 355 2.992908 10.6248234 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 96.3 1.26e-20   NR KAG8465735.1 2081491 g5639 i0 48.5 0.819718309859155 97 50 82 0 293 3 25 121 KAG8465735.1 hypothetical protein KFE25_005305 [Diacronema lutheri] diamond 291 96.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
9660527 9660527 PRJNA756891_P_NODE_8748_length_294_cov_1.045249_g8679_i0 PRJNA756891 8748 294 1.045249 3.07303206 Diacronema 70451 Haptophyta other_Eukaryota 161 3.58e-46   NR KAJ1629205.1 483367 g8679 i0 79.6 3 98 20 100 0 1 294 177 274 KAJ1629205.1 pyruvate kinase [Pavlovales sp. CCMP2436] diamond 882 162 0.993827160493827 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
21134598 21134598 PRJNA756891_P_NODE_6837_length_328_cov_1.725490_g6768_i0 PRJNA756891 6837 328 1.72549 5.6596072 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 130 2.31e-32   NR KAL1511253.1 97485 g6768 i0 62.4 26.9176829268293 109 38 99.7 1 1 327 41 146 KAL1511253.1 hypothetical protein AB1Y20_006062 [Prymnesium parvum] diamond 8829 131 0.99236641221374 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27094341 27094341 PRJNA756891_P_NODE_3062_length_477_cov_32.326733_g2994_i0 PRJNA756891 3062 477 32.326733 154.19851641 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 148 1.2099999999999999e-42   NR KAL1514807.1 97485 g2994 i0 58.3 20.6729559748428 139 55 86.8 2 26 439 4 140 KAL1514807.1 hypothetical protein AB1Y20_003893 [Prymnesium parvum] diamond 9861 149 0.993288590604027 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27874185 27874185 PRJNA756891_P_NODE_5285_length_369_cov_1.040541_g5216_i0 PRJNA756891 5285 369 1.040541 3.83959629 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.8 4.69e-18   NR XP_005764670.1 280463 g5216 i0 41.9 1.70731707317073 105 56 85.4 1 318 4 89 188 XP_005764670.1 hypothetical protein EMIHUDRAFT_247554 [Emiliania huxleyi CCMP1516] diamond 630 87.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27937461 27937461 PRJNA756891_P_NODE_2945_length_488_cov_1.346988_g2877_i0 PRJNA756891 2945 488 1.346988 6.57330144 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 113 4.9999999999999996e-26   NR KAJ1633252.1 483367 g2877 i0 41.9 0.983606557377049 160 91 98.4 2 7 486 162 319 KAJ1633252.1 lung seven transmembrane receptor-domain-containing protein [Pavlovales sp. CCMP2436] diamond 480 113 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
27937472 27937472 PRJNA756891_P_NODE_9365_length_284_cov_2.739336_g9296_i0 PRJNA756891 9365 284 2.739336 7.77971424 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 57.8 3.28e-7   NR XP_005770616.1 280463 g9296 i0 37.5 2.00704225352113 96 51 98.2 2 6 284 348 437 XP_005770616.1 trafficking protein particle complex 8 [Emiliania huxleyi CCMP1516] diamond 570 57.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28294401 28294401 PRJNA756891_P_NODE_10586_length_269_cov_1.571429_g10517_i0 PRJNA756891 10586 269 1.571429 4.22714401 Viridiplantae 33090 Haptophyta other_Eukaryota 72.8 1.3e-12   NR KAL1530334.1 97485 g10517 i0 40.7 3.08921933085502 91 52 99.3 1 268 2 171 261 KAL1530334.1 hypothetical protein AB1Y20_001243 [Prymnesium parvum] diamond 831 72.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29011258 29011258 PRJNA756891_P_NODE_8648_length_295_cov_1.662162_g8579_i0 PRJNA756891 8648 295 1.662162 4.9033779 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 125 1.3e-32   NR XP_005778118.1 280463 g8579 i0 67 2.95932203389831 97 32 98.6 0 293 3 139 235 XP_005778118.1 putative prohibitin [Emiliania huxleyi CCMP1516] diamond 873 125 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29705058 29705058 PRJNA756891_P_NODE_1390_length_688_cov_2.097561_g1326_i0 PRJNA756891 1390 688 2.097561 14.43121968 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 196 7.519999999999999e-55   NR KAG8457352.1 2081491 g1326 i0 51 1.78779069767442 192 84 79.8 3 611 63 59 249 KAG8457352.1 hypothetical protein KFE25_014081 [Diacronema lutheri] diamond 1230 196 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30031230 30031230 PRJNA756891_P_NODE_3611_length_441_cov_2.119565_g3542_i0 PRJNA756891 3611 441 2.119565 9.34728165 Prymnesiales 73028 Haptophyta other_Eukaryota 85.1 5.67e-16   NR KOO29069.1 1460289 g3542 i0 53.5 1.9047619047619 71 33 48.3 0 214 2 3140 3210 KOO29069.1 ring finger protein 213-like protein [Chrysochromulina tobinii] diamond 840 85.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30464108 30464108 PRJNA756891_P_NODE_5933_length_350_cov_1.007220_g5864_i0 PRJNA756891 5933 350 1.00722 3.52527 Prymnesium parvum 97485 Haptophyta other_Eukaryota 64.3 3.61e-9   NR KAL1530236.1 97485 g5864 i0 29.6 2.88 115 70 98.6 2 6 350 842 945 KAL1530236.1 hypothetical protein AB1Y20_001151 [Prymnesium parvum] diamond 1008 64.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30694641 30694641 PRJNA756891_P_NODE_4793_length_385_cov_1.480769_g4724_i0 PRJNA756891 4793 385 1.480769 5.70096065 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 106 1.0799999999999999e-23   NR KAL1510627.1 97485 g4724 i0 45.1 8.34545454545455 122 66 94.3 1 2 364 144 265 KAL1510627.1 hypothetical protein AB1Y20_006928 [Prymnesium parvum] diamond 3213 106 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31064219 31064219 PRJNA756891_P_NODE_12215_length_251_cov_0.865169_g12146_i0 PRJNA756891 12215 251 0.865169 2.17157419 Prymnesium parvum 97485 Haptophyta other_Eukaryota 51.2 4.07e-5   NR KAL1499907.1 97485 g12146 i0 48.4 0.741035856573705 62 32 74.1 0 207 22 101 162 KAL1499907.1 hypothetical protein AB1Y20_012590 [Prymnesium parvum] diamond 186 51.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31443357 31443357 PRJNA756891_P_NODE_16536_length_241_cov_0.916667_g16467_i0 PRJNA756891 16536 241 0.916667 2.20916747 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 47.8 6.39e-4   NR KAG8468221.1 2081491 g16467 i0 44.3 0.759336099585062 61 32 73.4 1 196 20 906 966 KAG8468221.1 hypothetical protein KFE25_013304 [Diacronema lutheri] diamond 183 47.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31727941 31727941 PRJNA756891_P_NODE_3477_length_448_cov_3.490667_g3409_i0 PRJNA756891 3477 448 3.490667 15.63818816 Prymnesium parvum 97485 Haptophyta other_Eukaryota 77.8 5.96e-15   NR KAL1503953.1 97485 g3409 i0 42.1 1.43973214285714 95 54 62.9 1 88 369 18 112 KAL1503953.1 hypothetical protein AB1Y20_010371 [Prymnesium parvum] diamond 645 77.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31800971 31800971 PRJNA756891_P_NODE_4237_length_408_cov_2.056716_g4168_i0 PRJNA756891 4237 408 2.056716 8.39140128 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 88.6 2.2e-17   NR KAL1510627.1 97485 g4168 i0 37.2 1.92647058823529 129 77 91.9 1 404 30 511 639 KAL1510627.1 hypothetical protein AB1Y20_006928 [Prymnesium parvum] diamond 786 88.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32266181 32266181 PRJNA756891_P_NODE_798_length_888_cov_2.136196_g746_i0 PRJNA756891 798 888 2.136196 18.96942048 Prymnesium parvum 97485 Haptophyta other_Eukaryota 369 1.11e-124   NR KAL1520043.1 97485 g746 i0 61.6 0.932432432432432 276 106 93.2 0 13 840 56 331 KAL1520043.1 hypothetical protein AB1Y20_023519 [Prymnesium parvum] diamond 828 369 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32560751 32560751 PRJNA756891_P_NODE_10739_length_267_cov_1.577320_g10670_i0 PRJNA756891 10739 267 1.57732 4.2114444 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 76.6 1.43e-15   NR ALD47925.1 2903 g10670 i0 41.9 3.49438202247191 86 48 96.6 1 8 265 6 89 ALD47925.1 adaptor protein complex 1 subunit gamma, partial [Emiliania huxleyi] diamond 933 76.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);;