RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 12 ✖

bioproject 1

  • PRJNA738523 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26609089 26609089 PRJNA738523_P_NODE_6381_length_290_cov_1.419355_g6310_i0 PRJNA738523 6381 290 1.419355 4.1161295 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 85.5 5.96e-17   NR KOO24395.1 1460289 g6310 i0 60 0.620689655172414 60 24 62.1 0 190 11 9 68 KOO24395.1 poly(3-hydroxybutyrate) depolymerase [Chrysochromulina tobinii] diamond 180 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
26925912 26925912 PRJNA738523_P_NODE_13742_length_245_cov_1.343023_g13671_i0 PRJNA738523 13742 245 1.343023 3.29040635 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 47.8 6.56e-4   NR KAG8463724.1 2081491 g13671 i0 41.5 2.63265306122449 65 36 79.6 1 241 47 447 509 KAG8463724.1 hypothetical protein KFE25_003997 [Diacronema lutheri] diamond 645 47.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27716261 27716261 PRJNA738523_P_NODE_13284_length_246_cov_0.890173_g13213_i0 PRJNA738523 13284 246 0.890173 2.18982558 Prymnesium parvum 97485 Haptophyta other_Eukaryota 89.7 2.16e-19   NR KAL1498955.1 97485 g13213 i0 54.3 2.01219512195122 81 32 92.7 1 16 243 132 212 KAL1498955.1 hypothetical protein AB1Y20_013476 [Prymnesium parvum] diamond 495 89.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27716272 27716272 PRJNA738523_P_NODE_6424_length_290_cov_1.179724_g6353_i0 PRJNA738523 6424 290 1.179724 3.4211996 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 92.8 1.24e-19   NR KOO24863.1 1460289 g6353 i0 50.5 1.02413793103448 99 43 97.2 2 282 1 275 372 KOO24863.1 hypothetical protein Ctob_003032 [Chrysochromulina tobinii] diamond 297 92.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28694886 28694886 PRJNA738523_P_NODE_14967_length_243_cov_0.905882_g14896_i0 PRJNA738523 14967 243 0.905882 2.20129326 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 112 2.47e-27   NR KAJ1619626.1 483367 g14896 i0 61.7 1 81 30 100 1 1 243 136 215 KAJ1619626.1 hypothetical protein T492DRAFT_620365, partial [Pavlovales sp. CCMP2436] diamond 243 112 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
29105307 29105307 PRJNA738523_P_NODE_4688_length_327_cov_0.838583_g4617_i0 PRJNA738523 4688 327 0.838583 2.74216641 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 85.1 1.33e-16   NR XP_005771754.1 280463 g4617 i0 45.6 1.4954128440367 90 47 81.7 2 325 59 82 170 XP_005771754.1 hypothetical protein EMIHUDRAFT_118001 [Emiliania huxleyi CCMP1516] diamond 489 85.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29515397 29515397 PRJNA738523_P_NODE_16330_length_241_cov_0.916667_g16259_i0 PRJNA738523 16330 241 0.916667 2.20916747 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 67.4 1.21e-11   NR KOO36011.1 1460289 g16259 i0 68.4 0.970954356846473 38 12 47.3 0 2 115 141 178 KOO36011.1 ADP-ribosylation factor 3 [Chrysochromulina tobinii] diamond 234 67.4 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30684255 30684255 PRJNA738523_P_NODE_13313_length_246_cov_0.890173_g13242_i0 PRJNA738523 13313 246 0.890173 2.18982558 Prymnesium parvum 97485 Haptophyta other_Eukaryota 86.7 7.73e-18   NR KAL1504596.1 97485 g13242 i0 46.2 0.951219512195122 78 42 95.1 0 244 11 276 353 KAL1504596.1 hypothetical protein AB1Y20_008381 [Prymnesium parvum] diamond 234 86.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30884115 30884115 PRJNA738523_P_NODE_15194_length_243_cov_0.905882_g15123_i0 PRJNA738523 15194 243 0.905882 2.20129326 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 87.4 3.03e-18   NR XP_005779857.1 280463 g15123 i0 58.9 1.80246913580247 73 30 90.1 0 1 219 272 344 XP_005779857.1 hypothetical protein EMIHUDRAFT_418635, partial [Emiliania huxleyi CCMP1516] diamond 438 87.8 0.995444191343964 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31284679 31284679 PRJNA738523_P_NODE_12395_length_248_cov_0.880000_g12324_i0 PRJNA738523 12395 248 0.88 2.1824 Prymnesium parvum 97485 Haptophyta other_Eukaryota 82.8 2.09e-16   NR KAL1493488.1 97485 g12324 i0 75.9 0.653225806451613 54 13 65.3 0 244 83 328 381 KAL1493488.1 hypothetical protein AB1Y20_017193 [Prymnesium parvum] diamond 162 82.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32360654 32360654 PRJNA738523_P_NODE_4439_length_333_cov_0.888462_g4368_i0 PRJNA738523 4439 333 0.888462 2.95857846 Prymnesium parvum 97485 Haptophyta other_Eukaryota 88.6 1.1e-19   NR KAL1499813.1 97485 g4368 i0 46 0.783783783783784 87 47 78.4 0 331 71 63 149 KAL1499813.1 hypothetical protein AB1Y20_012498 [Prymnesium parvum] diamond 261 88.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32739381 32739381 PRJNA738523_P_NODE_12740_length_247_cov_0.885057_g12669_i0 PRJNA738523 12740 247 0.885057 2.18609079 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 86.3 1.24e-17   NR XP_005789044.1 280463 g12669 i0 55.4 0.898785425101215 74 29 85 1 5 214 321 394 XP_005789044.1 hypothetical protein EMIHUDRAFT_110098 [Emiliania huxleyi CCMP1516] diamond 222 86.3 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);;