RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA752572", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 15 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 15 ✖

bioproject 1

  • PRJNA752572 · 15 ✖

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
26841469 26841469 PRJNA752572_P_NODE_84641_length_295_cov_1.673077_g84134_i0 PRJNA752572 84641 295 1.673077 4.93557715 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 127 1.02e-32   NR KAL1512169.1 97485 g84134 i0 63.8 7.83050847457627 94 34 95.6 0 284 3 297 390 KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum] diamond 2310 128 0.9921875 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27021255 27021255 PRJNA752572_P_NODE_59302_length_354_cov_20.081505_g58795_i0 PRJNA752572 59302 354 20.081505 71.0885277 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.4 1.53e-19   NR XP_005782836.1 280463 g58795 i0 50 1.76271186440678 102 47 85.6 2 329 27 16 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 624 87.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27052965 27052965 PRJNA752572_P_NODE_88502_length_288_cov_1.988142_g87995_i0 PRJNA752572 88502 288 1.988142 5.72584896 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 60.5 3.54e-8   NR KOO47707.1 1460289 g87995 i0 51.6 1.53125 64 28 63.5 2 197 15 72 135 KOO47707.1 protein notum-like protein [Chrysochromulina tobinii] diamond 441 60.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27147247 27147247 PRJNA752572_P_NODE_255342_length_167_cov_1.515152_g254835_i0 PRJNA752572 255342 167 1.515152 2.53030384 Prymnesium parvum 97485 Haptophyta other_Eukaryota 47.4 3.09e-4   NR KAL1500220.1 97485 g254835 i0 40.7 0.970059880239521 54 31 95.2 1 8 166 360 413 KAL1500220.1 hypothetical protein AB1Y20_012889 [Prymnesium parvum] diamond 162 47.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28158527 28158527 PRJNA752572_P_NODE_146325_length_221_cov_2.198925_g145818_i0 PRJNA752572 146325 221 2.198925 4.85962425 Prymnesium parvum 97485 Haptophyta other_Eukaryota 96.3 3.97e-21   NR KAL1523153.1 97485 g145818 i0 76.4 0.746606334841629 55 12 74.7 1 1 165 634 687 KAL1523153.1 hypothetical protein AB1Y20_018108 [Prymnesium parvum] diamond 165 96.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28474121 28474121 PRJNA752572_P_NODE_255206_length_167_cov_1.636364_g254699_i0 PRJNA752572 255206 167 1.636364 2.73272788 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 95.1 4.72e-21   NR XP_005784012.1 280463 g254699 i0 70.9 4.94011976047904 55 16 98.8 0 167 3 674 728 XP_005784012.1 hypothetical protein EMIHUDRAFT_418272 [Emiliania huxleyi CCMP1516] diamond 825 95.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28568704 28568704 PRJNA752572_P_NODE_8427_length_873_cov_2.718377_g8121_i0 PRJNA752572 8427 873 2.718377 23.73143121 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 184 9.24e-53   NR KOO25738.1 1460289 g8121 i0 42 0.776632302405498 226 122 75.3 5 824 168 27 250 KOO25738.1 lipase family protein [Chrysochromulina tobinii] diamond 678 184 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29147350 29147350 PRJNA752572_P_NODE_173229_length_203_cov_1.261905_g172722_i0 PRJNA752572 173229 203 1.261905 2.56166715 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 77 6.23e-16   NR KAL1514451.1 97485 g172722 i0 53.7 2.97044334975369 67 31 99 0 2 202 64 130 KAL1514451.1 hypothetical protein AB1Y20_003550 [Prymnesium parvum] diamond 603 77.4 0.994832041343669 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29421071 29421071 PRJNA752572_P_NODE_146669_length_221_cov_1.629032_g146162_i0 PRJNA752572 146669 221 1.629032 3.60016072 Prymnesium parvum 97485 Haptophyta other_Eukaryota 44.3 0.00781   NR KAL1510149.1 97485 g146162 i0 31.3 1.08597285067873 80 46 96.4 2 7 219 100 179 KAL1510149.1 hypothetical protein AB1Y20_006480 [Prymnesium parvum] diamond 240 44.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29863270 29863270 PRJNA752572_P_NODE_151911_length_217_cov_1.626374_g151404_i0 PRJNA752572 151911 217 1.626374 3.52923158 Prymnesium parvum 97485 Haptophyta other_Eukaryota 61.6 6.06e-9   NR KAL1507715.1 97485 g151404 i0 48.4 0.857142857142857 62 32 85.7 0 186 1 3220 3281 KAL1507715.1 hypothetical protein AB1Y20_007328 [Prymnesium parvum] diamond 186 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30189052 30189052 PRJNA752572_P_NODE_45032_length_407_cov_4.454301_g44527_i0 PRJNA752572 45032 407 4.454301 18.12900507 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 80.9 1.82e-16   NR KAL1510948.1 97485 g44527 i0 38.5 3.17690417690418 130 65 87 4 4 357 10 136 KAL1510948.1 hypothetical protein AB1Y20_005775 [Prymnesium parvum] diamond 1293 80.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30906127 30906127 PRJNA752572_P_NODE_95994_length_276_cov_1.950207_g95487_i0 PRJNA752572 95994 276 1.950207 5.38257132 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 81.6 1.11e-15   NR XP_005769036.1 280463 g95487 i0 67.3 8.47826086956522 52 17 56.5 0 4 159 120 171 XP_005769036.1 hypothetical protein EMIHUDRAFT_419452 [Emiliania huxleyi CCMP1516] diamond 2340 81.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31443296 31443296 PRJNA752572_P_NODE_204236_length_186_cov_1.582781_g203729_i0 PRJNA752572 204236 186 1.582781 2.94397266 Prymnesium parvum 97485 Haptophyta other_Eukaryota 89 2.28e-19   NR KAL1519728.1 97485 g203729 i0 71 2 62 16 100 1 1 186 157 216 KAL1519728.1 hypothetical protein AB1Y20_023237 [Prymnesium parvum] diamond 372 89 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31570053 31570053 PRJNA752572_P_NODE_110556_length_256_cov_2.411765_g110049_i0 PRJNA752572 110556 256 2.411765 6.1741184 Prymnesium parvum 97485 Haptophyta other_Eukaryota 105 2.6999999999999993e-24   NR KAL1504395.1 97485 g110049 i0 58.3 0.984375 84 35 98.4 0 255 4 29 112 KAL1504395.1 hypothetical protein AB1Y20_010801 [Prymnesium parvum] diamond 252 105 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31886080 31886080 PRJNA752572_P_NODE_150217_length_218_cov_2.103825_g149710_i0 PRJNA752572 150217 218 2.103825 4.5863385 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 99.4 5.24e-24   NR KAG8458660.1 2081491 g149710 i0 61.1 3.93577981651376 72 28 99.1 0 1 216 5 76 KAG8458660.1 hypothetical protein KFE25_008457 [Diacronema lutheri] diamond 858 99.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri

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