RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1035005", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 17 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 17 ✖

bioproject 1

  • PRJNA1035005 · 17 ✖

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
1443620 1443620 PRJNA1035005_P_NODE_47802_length_259_cov_3.059140_g47396_i0 PRJNA1035005 47802 259 3.05914 7.9231726 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 84.2 8.36e-12   NTclustered gi|551624862|ref|XM_005792577.1| 280463 g47396 i0 77.778 16.7799227799228 135 30 52 0 1 135 520 386 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 4346 84.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
2719184 2719184 PRJNA1035005_P_NODE_2643_length_693_cov_3.701613_g2259_i0 PRJNA1035005 2643 693 3.701613 25.65217809 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 198 8.4e-46   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g2259 i0 81.028 30.1847041847042 253 44 36 2 149 399 151 401 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 20918 198 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14197546 14197546 PRJNA1035005_P_NODE_4672_length_492_cov_9.389021_g4272_i0 PRJNA1035005 4672 492 9.389021 46.19398332 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 148 2.4899999999999996e-43   NR XP_005758635.1 280463 g4272 i0 86.4 13.8109756097561 81 11 49.4 0 444 202 3 83 XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] diamond 6795 148 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26877216 26877216 PRJNA1035005_P_NODE_42921_length_266_cov_1.212435_g42515_i0 PRJNA1035005 42921 266 1.212435 3.2250771 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 123 1.92e-30   NR KOO29726.1 1460289 g42515 i0 73.9 0.992481203007519 88 22 99.2 1 265 2 812 898 KOO29726.1 nfx1-type zinc finger-containing protein 1 [Chrysochromulina tobinii] diamond 264 123 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27193078 27193078 PRJNA1035005_P_NODE_4462_length_505_cov_2.060185_g4063_i0 PRJNA1035005 4462 505 2.060185 10.40393425 Prymnesium parvum 97485 Haptophyta other_Eukaryota 46.2 0.0276   NR KAL1507425.1 97485 g4063 i0 45.5 0.326732673267327 55 29 32.1 1 266 427 182 236 KAL1507425.1 hypothetical protein AB1Y20_008264 [Prymnesium parvum] diamond 165 46.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27256377 27256377 PRJNA1035005_P_NODE_6143_length_432_cov_1.303621_g5743_i0 PRJNA1035005 6143 432 1.303621 5.63164272 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 55.1 1.35e-5   NR XP_005780827.1 280463 g5743 i0 29.6 3.61805555555556 152 85 97.2 7 427 8 107 248 XP_005780827.1 hypothetical protein EMIHUDRAFT_449972 [Emiliania huxleyi CCMP1516] diamond 1563 55.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27343518 27343518 PRJNA1035005_P_NODE_19143_length_304_cov_1.012987_g18737_i0 PRJNA1035005 19143 304 1.012987 3.07948048 root 1 Root_unresolved Root_unresolved 71.6 4.53e-12   NR XP_005793475.1 280463 g18737 i0 54.5 1.59868421052632 55 25 54.3 0 170 6 214 268 XP_005793475.1 hypothetical protein EMIHUDRAFT_222110 [Emiliania huxleyi CCMP1516] diamond 486 71.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27722597 27722597 PRJNA1035005_P_NODE_14484_length_326_cov_2.150198_g14078_i0 PRJNA1035005 14484 326 2.150198 7.00964548 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 74.7 3.79e-13   NR KOO28090.1 1460289 g14078 i0 64.8 2.60429447852761 54 19 49.7 0 164 3 60 113 KOO28090.1 rnp domain-containing protein [Chrysochromulina tobinii] diamond 849 74.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28329959 28329959 PRJNA1035005_P_NODE_31206_length_281_cov_1.312500_g30800_i0 PRJNA1035005 31206 281 1.3125 3.688125 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 155 4.579999999999999e-43   NR KAG8457999.1 2081491 g30800 i0 78.5 0.99288256227758 93 20 99.3 0 3 281 217 309 KAG8457999.1 hypothetical protein KFE25_012670 [Diacronema lutheri] diamond 279 155 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28677503 28677503 PRJNA1035005_P_NODE_11007_length_353_cov_4.332143_g10602_i0 PRJNA1035005 11007 353 4.332143 15.29246479 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 47.8 8.1e-4   NR XP_005793372.1 280463 g10602 i0 57.4 1.03682719546742 61 24 51.8 1 39 221 1 59 XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516] diamond 366 47.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28803445 28803445 PRJNA1035005_P_NODE_53948_length_253_cov_0.866667_g53542_i0 PRJNA1035005 53948 253 0.866667 2.19266751 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 65.9 3.17e-10   NR XP_005760864.1 280463 g53542 i0 43.1 0.770750988142292 65 36 77.1 1 11 205 1967 2030 XP_005760864.1 hypothetical protein EMIHUDRAFT_217630 [Emiliania huxleyi CCMP1516] diamond 195 65.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29245735 29245735 PRJNA1035005_P_NODE_22149_length_293_cov_1.418182_g21743_i0 PRJNA1035005 22149 293 1.418182 4.15527326 Prymnesium parvum 97485 Haptophyta other_Eukaryota 186 1.3199999999999998e-55   NR KAL1514587.1 97485 g21743 i0 84.4 10.7610921501706 96 15 98.3 0 292 5 154 249 KAL1514587.1 hypothetical protein AB1Y20_003681 [Prymnesium parvum] diamond 3153 186 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30477638 30477638 PRJNA1035005_P_NODE_62853_length_250_cov_0.881356_g62447_i0 PRJNA1035005 62853 250 0.881356 2.20339 Prymnesium parvum 97485 Haptophyta other_Eukaryota 110 8.19e-26   NR KAL1518837.1 97485 g62447 i0 60.2 3.996 83 32 98.4 1 250 5 298 380 KAL1518837.1 hypothetical protein AB1Y20_003114 [Prymnesium parvum] diamond 999 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31670596 31670596 PRJNA1035005_P_NODE_15717_length_319_cov_1.203252_g15311_i0 PRJNA1035005 15717 319 1.203252 3.83837388 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 164 1.21e-49   NR KAL1515397.1 97485 g15311 i0 76 1.95611285266458 104 25 97.8 0 3 314 12 115 KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum] diamond 624 164 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32374821 32374821 PRJNA1035005_P_NODE_45579_length_262_cov_1.883598_g45173_i0 PRJNA1035005 45579 262 1.883598 4.93502676 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 140 1.07e-39   NR KAJ1640026.1 483367 g45173 i0 75.9 2.98854961832061 87 21 99.6 0 2 262 82 168 KAJ1640026.1 glutamine synthetase type III N terminal-domain-containing protein [Pavlovales sp. CCMP2436] diamond 783 140 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32588250 32588250 PRJNA1035005_P_NODE_56899_length_252_cov_0.871508_g56493_i0 PRJNA1035005 56899 252 0.871508 2.19620016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42.7 0.0414   NR KAJ1633231.1 483367 g56493 i0 32.1 1.6547619047619 81 46 89.3 3 228 4 5 82 KAJ1633231.1 serine incorporator/TMS membrane protein [Pavlovales sp. CCMP2436] diamond 417 42.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32816366 32816366 PRJNA1035005_P_NODE_15800_length_318_cov_2.073469_g15394_i0 PRJNA1035005 15800 318 2.073469 6.59363142 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 102 3.53e-25   NR KAJ1633966.1 483367 g15394 i0 55.4 0.867924528301887 92 41 86.8 0 42 317 12 103 KAJ1633966.1 ribosomal protein rps12 [Pavlovales sp. CCMP2436] diamond 276 102 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);;