RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 18 ✖

bioproject 1

  • PRJEB12237 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
20721 20721 PRJEB12237_P_NODE_8821_length_183_cov_1.351351_g8625_i0 PRJEB12237 8821 183 1.351351 2.47297233 Prymnesium parvum 97485 Haptophyta other_Eukaryota 70.1 6.21e-13   NR KAL1503052.1 97485 g8625 i0 57.8 2.11475409836066 64 23 98.4 1 182 3 75 138 KAL1503052.1 hypothetical protein AB1Y20_011119 [Prymnesium parvum] diamond 387 70.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
11498694 11498694 PRJEB12237_P_NODE_2710_length_424_cov_5.470437_g2514_i0 PRJEB12237 2710 424 5.470437 23.19465288 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 150 2.51e-44   NR XP_005758635.1 280463 g2514 i0 86.4 0.57311320754717 81 11 57.3 0 377 135 3 83 XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] diamond 243 150 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
21697394 21697394 PRJEB12237_P_NODE_1498_length_589_cov_4.400722_g1322_i0 PRJEB12237 1498 589 4.400722 25.92025258 root 1 Root_unresolved Root_unresolved 263 4.89e-79   NR KAL1495697.1 97485 g1322 i0 80 21.641765704584 165 31 83 1 588 100 722 886 KAL1495697.1 hypothetical protein AB1Y20_016560 [Prymnesium parvum] diamond 12747 263 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26875108 26875108 PRJEB12237_P_NODE_9561_length_173_cov_2.601449_g9365_i0 PRJEB12237 9561 173 2.601449 4.50050677 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 44.7 0.00159   NR XP_005793372.1 280463 g9365 i0 61.2 1.69942196531792 49 19 85 0 151 5 1 49 XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516] diamond 294 44.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26937914 26937914 PRJEB12237_P_NODE_5482_length_255_cov_2.113636_g5286_i0 PRJEB12237 5482 255 2.113636 5.3897718 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 68.6 3.25e-11   NR XP_005793475.1 280463 g5286 i0 57.1 0.576470588235294 49 21 57.6 0 186 40 216 264 XP_005793475.1 hypothetical protein EMIHUDRAFT_222110 [Emiliania huxleyi CCMP1516] diamond 147 68.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26994773 26994773 PRJEB12237_P_NODE_10082_length_168_cov_1.000000_g9886_i0 PRJEB12237 10082 168 1 1.68 root 1 Root_unresolved Root_unresolved 97.4 5.31e-22   NR KAL1530808.1 97485 g9886 i0 78.2 12.7678571428571 55 12 98.2 0 166 2 295 349 KAL1530808.1 hypothetical protein AB1Y20_001704 [Prymnesium parvum] diamond 2145 97.8 0.995910020449898 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27096147 27096147 PRJEB12237_P_NODE_4502_length_298_cov_1.771863_g4306_i0 PRJEB12237 4502 298 1.771863 5.28015174 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 97.8 9.96e-22   NR KAG8464121.1 2081491 g4306 i0 67.2 3.89597315436242 64 21 64.4 0 11 202 276 339 KAG8464121.1 hypothetical protein KFE25_000289 [Diacronema lutheri] diamond 1161 97.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28195110 28195110 PRJEB12237_P_NODE_8806_length_183_cov_1.621622_g8610_i0 PRJEB12237 8806 183 1.621622 2.96756826 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 104 1.35e-25   NR KAL1528518.1 97485 g8610 i0 85.5 11.8196721311475 55 8 90.2 0 165 1 1 55 KAL1528518.1 hypothetical protein AB1Y20_009861 [Prymnesium parvum] diamond 2163 105 0.990476190476191 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29331980 29331980 PRJEB12237_P_NODE_6949_length_216_cov_1.077348_g6753_i0 PRJEB12237 6949 216 1.077348 2.32707168 root 1 Root_unresolved Root_unresolved 96.7 4.0699999999999996e-23   NR XP_005789762.1 280463 g6753 i0 63.8 3.81944444444444 69 18 95.8 1 5 211 81 142 XP_005789762.1 hypothetical protein EMIHUDRAFT_252121 [Emiliania huxleyi CCMP1516] diamond 825 96.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29363663 29363663 PRJEB12237_P_NODE_6969_length_215_cov_1.777778_g6773_i0 PRJEB12237 6969 215 1.777778 3.8222227 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 105 5.71e-25   NR KAL1523363.1 97485 g6773 i0 72.9 4.93953488372093 59 16 82.3 0 213 37 302 360 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 1062 105 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29401420 29401420 PRJEB12237_P_NODE_11449_length_155_cov_1.958333_g11253_i0 PRJEB12237 11449 155 1.958333 3.03541615 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 56.6 1.41e-7   NR KAG8466231.1 2081491 g11253 i0 50.9 1.0258064516129 53 23 96.8 1 5 154 48 100 KAG8466231.1 hypothetical protein KFE25_001987 [Diacronema lutheri] diamond 159 56.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
29748461 29748461 PRJEB12237_P_NODE_8011_length_195_cov_1.493750_g7815_i0 PRJEB12237 8011 195 1.49375 2.9128125 Prymnesium parvum 97485 Haptophyta other_Eukaryota 79 3.21e-15   NR KAL1524241.1 97485 g7815 i0 61.3 0.953846153846154 62 21 95.4 2 186 1 380 438 KAL1524241.1 hypothetical protein AB1Y20_019146 [Prymnesium parvum] diamond 186 79 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29938330 29938330 PRJEB12237_P_NODE_1431_length_603_cov_2.535211_g1260_i0 PRJEB12237 1431 603 2.535211 15.28732233 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 198 1.26e-56   NR KOO24782.1 1460289 g1260 i0 58.3 1.66169154228856 168 66 83.6 2 601 98 431 594 KOO24782.1 tripeptidyl peptidase i [Chrysochromulina tobinii] diamond 1002 198 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30279862 30279862 PRJEB12237_P_NODE_2032_length_501_cov_2.160944_g1844_i0 PRJEB12237 2032 501 2.160944 10.82632944 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 214 9.41e-64   NR KAL1495187.1 97485 g1844 i0 80.6 4.45508982035928 124 24 74.3 0 2 373 424 547 KAL1495187.1 hypothetical protein AB1Y20_017052 [Prymnesium parvum] diamond 2232 214 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30981079 30981079 PRJEB12237_P_NODE_10034_length_168_cov_1.503759_g9838_i0 PRJEB12237 10034 168 1.503759 2.52631512 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 50.1 3.54e-5   NR XP_005770794.1 280463 g9838 i0 43.6 0.982142857142857 55 31 98.2 0 1 165 272 326 XP_005770794.1 hypothetical protein EMIHUDRAFT_61679, partial [Emiliania huxleyi CCMP1516] diamond 165 50.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31328503 31328503 PRJEB12237_P_NODE_4016_length_323_cov_1.246528_g3820_i0 PRJEB12237 4016 323 1.246528 4.02628544 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 85.5 5.61e-19   NR KAL3903319.1 2812485 g3820 i0 54.7 2.79566563467492 75 34 69.7 0 17 241 37 111 KAL3903319.1 MAG: hypothetical protein SGPRY_011725, partial [Prymnesium sp.] diamond 903 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31575421 31575421 PRJEB12237_P_NODE_11876_length_152_cov_1.367521_g11680_i0 PRJEB12237 11876 152 1.367521 2.07863192 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.1 9.66e-18   NR XP_005789579.1 280463 g11680 i0 80 7.10526315789474 45 9 88.8 0 135 1 1 45 XP_005789579.1 60S ribosomal protein L3, partial [Emiliania huxleyi CCMP1516] diamond 1080 80.9 0.990111248454882 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32436091 32436091 PRJEB12237_P_NODE_1819_length_532_cov_3.949698_g1635_i0 PRJEB12237 1819 532 3.949698 21.01239336 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 127 6.86e-34   NR KAJ1638552.1 483367 g1635 i0 55.6 0.710526315789474 126 55 71.1 1 468 91 4 128 KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436] diamond 378 127 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436

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