RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJEB75017" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 14 ✖

bioproject 1

  • PRJEB75017 · 14 ✖

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
2685397 2685397 PRJEB75017_P_NODE_13503_length_255_cov_1.285714_g13374_i0 PRJEB75017 13503 255 1.285714 3.2785707 Prymnesium parvum 97485 Haptophyta other_Eukaryota 122 4.2699999999999995e-30   NR KAL1503391.1 97485 g13374 i0 60 1.05882352941176 90 31 100 1 255 1 223 312 KAL1503391.1 hypothetical protein AB1Y20_011442 [Prymnesium parvum] diamond 270 122 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
5237858 5237858 PRJEB75017_P_NODE_10805_length_281_cov_1.283654_g10676_i0 PRJEB75017 10805 281 1.283654 3.60706774 root 1 Root_unresolved Root_unresolved 137 3.63e-36   NR KAJ1620891.1 483367 g10676 i0 69.6 2.95729537366548 92 28 98.2 0 5 280 152 243 KAJ1620891.1 pyruvate dehydrogenase E1 component subunit alpha-2, mitochondrial-like protein [Pavlovales sp. CCMP2436] diamond 831 137 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
26812696 26812696 PRJEB75017_P_NODE_6961_length_338_cov_1.105660_g6832_i0 PRJEB75017 6961 338 1.10566 3.7371308 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 71.6 8.14e-12   NR XP_005781676.1 280463 g6832 i0 38.4 1.98816568047337 112 60 99.4 3 338 3 533 635 XP_005781676.1 hypothetical protein EMIHUDRAFT_99684 [Emiliania huxleyi CCMP1516] diamond 672 71.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27034140 27034140 PRJEB75017_P_NODE_6022_length_360_cov_1.118467_g5893_i0 PRJEB75017 6022 360 1.118467 4.0264812 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 95.5 4.74e-20   NR KAG8457384.1 2081491 g5893 i0 40.3 2.99166666666667 119 65 99.2 3 357 1 513 625 KAG8457384.1 hypothetical protein KFE25_005065 [Diacronema lutheri] diamond 1077 95.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27792430 27792430 PRJEB75017_P_NODE_9764_length_291_cov_1.605505_g9635_i0 PRJEB75017 9764 291 1.605505 4.67201955 Prymnesium parvum 97485 Haptophyta other_Eukaryota 83.2 3.77e-16   NR KAL1504730.1 97485 g9635 i0 50.7 0.77319587628866 75 34 75.3 2 71 289 26 99 KAL1504730.1 hypothetical protein AB1Y20_008508 [Prymnesium parvum] diamond 225 83.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28202541 28202541 PRJEB75017_P_NODE_11566_length_274_cov_1.004975_g11437_i0 PRJEB75017 11566 274 1.004975 2.7536315 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 54.3 4.65e-6   NR KAJ1637702.1 483367 g11437 i0 34.5 0.952554744525547 87 49 95.3 2 262 2 55 133 KAJ1637702.1 WD40-repeat-containing domain protein [Pavlovales sp. CCMP2436] diamond 261 54.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28360499 28360499 PRJEB75017_P_NODE_16666_length_246_cov_0.901734_g16537_i0 PRJEB75017 16666 246 0.901734 2.21826564 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 62.4 4.68e-9   NR KAL3933817.1 2812485 g16537 i0 46.9 0.98780487804878 81 43 98.8 0 3 245 656 736 KAL3933817.1 MAG: hypothetical protein SGPRY_000115 [Prymnesium sp.] diamond 243 62.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
29907954 29907954 PRJEB75017_P_NODE_12531_length_264_cov_1.507853_g12402_i0 PRJEB75017 12531 264 1.507853 3.98073192 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 107 1.97e-25   NR XP_005759937.1 280463 g12402 i0 55.3 0.965909090909091 85 38 96.6 0 264 10 124 208 XP_005759937.1 hypothetical protein EMIHUDRAFT_453331 [Emiliania huxleyi CCMP1516] diamond 255 107 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
30729280 30729280 PRJEB75017_P_NODE_8634_length_307_cov_1.000000_g8505_i0 PRJEB75017 8634 307 1 3.07 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 115 1.28e-27   NR KOO24782.1 1460289 g8505 i0 60.6 0.96742671009772 99 34 96.7 1 3 299 279 372 KOO24782.1 tripeptidyl peptidase i [Chrysochromulina tobinii] diamond 297 115 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32050018 32050018 PRJEB75017_P_NODE_5918_length_363_cov_0.882759_g5789_i0 PRJEB75017 5918 363 0.882759 3.20441517 root 1 Root_unresolved Root_unresolved 144 5.059999999999999e-37   NR XP_005759203.1 280463 g5789 i0 63.8 16 105 38 86.8 0 347 33 1242 1346 XP_005759203.1 putative ABC transporter [Emiliania huxleyi CCMP1516] diamond 5808 144 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32113432 32113432 PRJEB75017_P_NODE_17838_length_243_cov_1.370588_g17709_i0 PRJEB75017 17838 243 1.370588 3.33052884 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 95.9 5.850000000000001e-21   NR KAL1521954.1 97485 g17709 i0 61.3 1.93827160493827 80 30 97.5 1 2 238 98 177 KAL1521954.1 hypothetical protein AB1Y20_021600 [Prymnesium parvum] diamond 471 95.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32398204 32398204 PRJEB75017_P_NODE_15479_length_249_cov_0.886364_g15350_i0 PRJEB75017 15479 249 0.886364 2.20704636 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.6 1.74e-16   NR KAL1504951.1 97485 g15350 i0 51.9 3.68674698795181 81 38 97.6 1 247 5 5298 5377 KAL1504951.1 hypothetical protein AB1Y20_008718 [Prymnesium parvum] diamond 918 84 0.995238095238095 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32720996 32720996 PRJEB75017_P_NODE_1500_length_704_cov_1.906498_g1377_i0 PRJEB75017 1500 704 1.906498 13.42174592 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 55.5 6.24e-5   NR KAJ1630321.1 483367 g1377 i0 38.6 0.84375 70 43 29.8 0 661 452 1 70 KAJ1630321.1 hypothetical protein T492DRAFT_90866 [Pavlovales sp. CCMP2436] diamond 594 55.5 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32721002 32721002 PRJEB75017_P_NODE_18600_length_242_cov_0.911243_g18471_i0 PRJEB75017 18600 242 0.911243 2.20520806 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 60.8 1.49e-8   NR KOO29678.1 1460289 g18471 i0 47.9 1.8595041322314 71 35 85.5 1 241 35 40 110 KOO29678.1 hypothetical protein Ctob_001144 [Chrysochromulina tobinii] diamond 450 60.8 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);;