RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1123309", 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

  • PRJNA1123309 · 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
18129762 18129762 PRJNA1123309_P_NODE_10415_length_468_cov_2.111392_g10039_i0 PRJNA1123309 10415 468 2.111392 9.88131456 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 117 2.54e-29   NR KAG8462568.1 2081491 g10039 i0 52.4 1.58333333333333 124 57 78.2 1 102 467 1 124 KAG8462568.1 hypothetical protein KFE25_010393 [Diacronema lutheri] diamond 741 117 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26595139 26595139 PRJNA1123309_P_NODE_67981_length_229_cov_2.820513_g67601_i0 PRJNA1123309 67981 229 2.820513 6.45897477 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 106 5.95e-25   NR KAG8463530.1 2081491 g67601 i0 68.8 3.02620087336245 77 21 96.9 1 223 2 241 317 KAG8463530.1 hypothetical protein KFE25_003803 [Diacronema lutheri] diamond 693 106 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26658434 26658434 PRJNA1123309_P_NODE_16081_length_387_cov_1.455414_g15702_i0 PRJNA1123309 16081 387 1.455414 5.63245218 Prymnesium parvum 97485 Haptophyta other_Eukaryota 110 3.31e-25   NR KAL1520290.1 97485 g15702 i0 41.5 2.87596899224806 123 67 95.3 1 386 18 146 263 KAL1520290.1 hypothetical protein AB1Y20_021882 [Prymnesium parvum] diamond 1113 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26658451 26658451 PRJNA1123309_P_NODE_47661_length_253_cov_0.866667_g47281_i0 PRJNA1123309 47661 253 0.866667 2.19266751 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 69.3 1.85e-11   NR KOO33026.1 1460289 g47281 i0 64.4 1.05533596837945 45 16 53.4 0 240 106 551 595 KOO33026.1 prolyl 4-hydroxylase alpha subunit, partial [Chrysochromulina tobinii] diamond 267 69.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
26721606 26721606 PRJNA1123309_P_NODE_61301_length_245_cov_0.906977_g60921_i0 PRJNA1123309 61301 245 0.906977 2.22209365 Prymnesium parvum 97485 Haptophyta other_Eukaryota 47 0.00115   NR KAL1496131.1 97485 g60921 i0 63 0.648979591836735 27 10 33.1 0 159 239 27 53 KAL1496131.1 hypothetical protein AB1Y20_014752 [Prymnesium parvum] diamond 159 47 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26943552 26943552 PRJNA1123309_P_NODE_8282_length_522_cov_1.178174_g7912_i0 PRJNA1123309 8282 522 1.178174 6.15006828 Prymnesium parvum 97485 Haptophyta other_Eukaryota 225 1.75e-64   NR KAL1503067.1 97485 g7912 i0 62.8 0.988505747126437 172 62 98.9 1 4 519 2068 2237 KAL1503067.1 hypothetical protein AB1Y20_011133 [Prymnesium parvum] diamond 516 225 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27133013 27133013 PRJNA1123309_P_NODE_20502_length_350_cov_1.090253_g20123_i0 PRJNA1123309 20502 350 1.090253 3.8158855 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 163 5.28e-46   NR KOO22559.1 1460289 g20123 i0 70.9 3.81428571428571 110 32 94.3 0 6 335 288 397 KOO22559.1 peptidyl-prolyl cis-trans isomerase [Chrysochromulina tobinii] diamond 1335 163 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27228133 27228133 PRJNA1123309_P_NODE_38723_length_274_cov_1.144279_g38343_i0 PRJNA1123309 38723 274 1.144279 3.13532446 Prymnesium parvum 97485 Haptophyta other_Eukaryota 54.3 4.58e-6   NR KAL1503913.1 97485 g38343 i0 42.9 0.613138686131387 56 32 61.3 0 172 5 326 381 KAL1503913.1 hypothetical protein AB1Y20_012374 [Prymnesium parvum] diamond 168 54.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27323090 27323090 PRJNA1123309_P_NODE_32823_length_288_cov_1.427907_g32443_i0 PRJNA1123309 32823 288 1.427907 4.11237216 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 122 1.3199999999999999e-31   NR KAG8464430.1 2081491 g32443 i0 64.7 1.78125 85 30 88.5 0 266 12 182 266 KAG8464430.1 hypothetical protein KFE25_003493 [Diacronema lutheri] diamond 513 122 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27575755 27575755 PRJNA1123309_P_NODE_61544_length_245_cov_0.906977_g61164_i0 PRJNA1123309 61544 245 0.906977 2.22209365 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 94.7 7.37e-23   NR XP_005791688.1 280463 g61164 i0 72.7 0.808163265306122 66 18 80.8 0 203 6 61 126 XP_005791688.1 hypothetical protein EMIHUDRAFT_439923 [Emiliania huxleyi CCMP1516] diamond 198 94.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27596632 27596632 PRJNA1123309_P_NODE_46464_length_254_cov_1.298343_g46084_i0 PRJNA1123309 46464 254 1.298343 3.29779122 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 122 4.96e-30   NR KAL1526687.1 97485 g46084 i0 68.8 4.71259842519685 80 25 94.5 0 13 252 508 587 KAL1526687.1 hypothetical protein AB1Y20_015389 [Prymnesium parvum] diamond 1197 122 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27691553 27691553 PRJNA1123309_P_NODE_16124_length_387_cov_0.910828_g15745_i0 PRJNA1123309 16124 387 0.910828 3.52490436 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.9 4.11e-7   NR KAG8463807.1 2081491 g15745 i0 59.1 0.689922480620155 44 16 34.1 1 16 147 524 565 KAG8463807.1 hypothetical protein KFE25_004080 [Diacronema lutheri] diamond 267 58.9 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27723207 27723207 PRJNA1123309_P_NODE_35204_length_282_cov_1.808612_g34824_i0 PRJNA1123309 35204 282 1.808612 5.10028584 root 1 Root_unresolved Root_unresolved 96.7 1.95e-21   NR KAJ1617553.1 483367 g34824 i0 58.2 5.24468085106383 79 31 84 1 274 38 55 131 KAJ1617553.1 hypothetical protein T492DRAFT_1098967 [Pavlovales sp. CCMP2436] diamond 1479 97.4 0.992813141683778 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30070100 30070100 PRJNA1123309_P_NODE_30872_length_293_cov_2.254545_g30492_i0 PRJNA1123309 30872 293 2.254545 6.60581685 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 67.8 1.13e-12   NR KAG8458221.1 2081491 g30492 i0 62.3 0.542662116040956 53 20 54.3 0 163 5 6 58 KAG8458221.1 hypothetical protein KFE25_001513 [Diacronema lutheri] diamond 159 67.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30101642 30101642 PRJNA1123309_P_NODE_27712_length_308_cov_0.987234_g27332_i0 PRJNA1123309 27712 308 0.987234 3.04068072 Prymnesium parvum 97485 Haptophyta other_Eukaryota 142 1.91e-37   NR KAL1507780.1 97485 g27332 i0 64.4 3.8474025974026 101 32 94.5 1 7 297 237 337 KAL1507780.1 hypothetical protein AB1Y20_007390 [Prymnesium parvum] diamond 1185 142 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30196392 30196392 PRJNA1123309_P_NODE_10032_length_476_cov_2.870968_g9656_i0 PRJNA1123309 10032 476 2.870968 13.66580768 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 67.8 7.19e-10   NR XP_005794372.1 280463 g9656 i0 32.9 1.07142857142857 170 100 98.3 5 7 474 16 185 XP_005794372.1 hypothetical protein EMIHUDRAFT_95135 [Emiliania huxleyi CCMP1516] diamond 510 67.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30228089 30228089 PRJNA1123309_P_NODE_14632_length_403_cov_0.933333_g14255_i0 PRJNA1123309 14632 403 0.933333 3.76133199 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 56.6 3.06e-6   NR XP_005765871.1 280463 g14255 i0 35.1 0.699751861042184 94 48 61 2 251 6 704 796 XP_005765871.1 hypothetical protein EMIHUDRAFT_212500 [Emiliania huxleyi CCMP1516] diamond 282 56.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30607215 30607215 PRJNA1123309_P_NODE_43573_length_261_cov_2.414894_g43193_i0 PRJNA1123309 43573 261 2.414894 6.30287334 Prymnesium parvum 97485 Haptophyta other_Eukaryota 48.1 5.74e-4   NR KAL1502925.1 97485 g43193 i0 30.3 1.02298850574713 89 48 88.5 2 6 236 171 257 KAL1502925.1 hypothetical protein AB1Y20_010997 [Prymnesium parvum] diamond 267 48.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31355058 31355058 PRJNA1123309_P_NODE_5236_length_638_cov_3.309735_g4893_i0 PRJNA1123309 5236 638 3.309735 21.1161093 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 315 1.41e-104   NR KAL1523363.1 97485 g4893 i0 76.1 4.42476489028213 188 45 88.4 0 623 60 173 360 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 2823 315 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32156794 32156794 PRJNA1123309_P_NODE_8138_length_526_cov_1.450331_g7769_i0 PRJNA1123309 8138 526 1.450331 7.62874106 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 67.8 1.21e-9   NR KAG8462988.1 2081491 g7769 i0 46.3 0.895437262357414 82 41 46.2 2 508 266 356 435 KAG8462988.1 hypothetical protein KFE25_001761 [Diacronema lutheri] diamond 471 67.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32177598 32177598 PRJNA1123309_P_NODE_11718_length_444_cov_1.396226_g11342_i0 PRJNA1123309 11718 444 1.396226 6.19924344 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 89 2.36e-17   NR KAL1502925.1 97485 g11342 i0 29.9 4.17567567567568 157 90 95.9 4 5 430 139 290 KAL1502925.1 hypothetical protein AB1Y20_010997 [Prymnesium parvum] diamond 1854 89.7 0.992196209587514 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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