RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1102048" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 21 ✖

bioproject 1

  • PRJNA1102048 · 21 ✖

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
9139333 9139333 PRJNA1102048_P_NODE_168_length_1398_cov_4.339623_g128_i0 PRJNA1102048 168 1398 4.339623 60.66792954 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 366 9.039999999999998e-121   NR KOO23867.1 1460289 g128 i0 62.7 3.76394849785408 284 102 60.5 3 1158 313 40 321 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 5262 369 0.991869918699187 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
11690497 11690497 PRJNA1102048_P_NODE_990_length_744_cov_2.253353_g898_i0 PRJNA1102048 990 744 2.253353 16.76494632 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 104 2.03e-17   NTclustered gi|551538436|ref|XM_005757713.1| 280463 g898 i0 72.063 3.29435483870968 383 95 51 8 90 469 629 256 Emiliania huxleyi CCMP1516 60S ribosomal protein L10a partial mRNA blastn 2451 104 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
12965504 12965504 PRJNA1102048_P_NODE_10631_length_271_cov_1.555556_g10527_i0 PRJNA1102048 10631 271 1.555556 4.21555676 Prymnesium parvum 97485 Haptophyta other_Eukaryota 146 3.65e-42   NR KAL1523812.1 97485 g10527 i0 76.9 2.54612546125461 78 18 86.3 0 7 240 102 179 KAL1523812.1 hypothetical protein AB1Y20_018734 [Prymnesium parvum] diamond 690 146 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
15047662 15047662 PRJNA1102048_P_NODE_10692_length_270_cov_2.918782_g10588_i0 PRJNA1102048 10692 270 2.918782 7.8807114 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 158 5.1e-34   NTclustered gi|551624794|ref|XM_005792543.1| 280463 g10588 i0 84.146 8.81111111111111 164 24 61 2 105 268 86 247 Emiliania huxleyi CCMP1516 40S ribosomal protein S14 partial mRNA blastn 2379 159 0.993710691823899 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
15047664 15047664 PRJNA1102048_P_NODE_11512_length_262_cov_1.201058_g11408_i0 PRJNA1102048 11512 262 1.201058 3.14677196 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 147 5.9099999999999996e-40   NR KOO33560.1 1460289 g11408 i0 84.5 6.80152671755725 84 13 96.2 0 261 10 300 383 KOO33560.1 RuvB-like 1 [Chrysochromulina tobinii] diamond 1782 147 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
18871598 18871598 PRJNA1102048_P_NODE_4595_length_398_cov_2.461538_g4491_i0 PRJNA1102048 4595 398 2.461538 9.79692124 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 165 1.41e-47   NR KAL1522923.1 97485 g4491 i0 62.9 4.96733668341709 132 49 99.5 0 397 2 114 245 KAL1522923.1 hypothetical protein AB1Y20_017888 [Prymnesium parvum] diamond 1977 166 0.993975903614458 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26774275 26774275 PRJNA1102048_P_NODE_6281_length_344_cov_2.442804_g6177_i0 PRJNA1102048 6281 344 2.442804 8.40324576 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 147 3.04e-39   NR KAL1507780.1 97485 g6177 i0 59.8 4.00290697674419 117 42 98.5 2 340 2 237 352 KAL1507780.1 hypothetical protein AB1Y20_007390 [Prymnesium parvum] diamond 1377 147 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27036044 27036044 PRJNA1102048_P_NODE_17162_length_242_cov_0.911243_g17058_i0 PRJNA1102048 17162 242 0.911243 2.20520806 Prymnesium parvum 97485 Haptophyta other_Eukaryota 65.1 5.08e-10   NR KAL1512226.1 97485 g17058 i0 37.9 0.818181818181818 66 41 81.8 0 38 235 6670 6735 KAL1512226.1 hypothetical protein AB1Y20_005488 [Prymnesium parvum] diamond 198 65.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28425802 28425802 PRJNA1102048_P_NODE_14466_length_247_cov_1.747126_g14362_i0 PRJNA1102048 14466 247 1.747126 4.31540122 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 53.5 5.67e-6   NR KOO31837.1 1460289 g14362 i0 38.7 0.910931174089069 75 37 91.1 2 227 3 12 77 KOO31837.1 peptidase [Chrysochromulina tobinii] diamond 225 53.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28488889 28488889 PRJNA1102048_P_NODE_10567_length_272_cov_1.366834_g10463_i0 PRJNA1102048 10567 272 1.366834 3.71778848 Prymnesium parvum 97485 Haptophyta other_Eukaryota 85.1 6.78e-17   NR KAL1495813.1 97485 g10463 i0 49.4 0.981617647058823 89 43 98.2 1 2 268 1119 1205 KAL1495813.1 hypothetical protein AB1Y20_016673 [Prymnesium parvum] diamond 267 85.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28732809 28732809 PRJNA1102048_P_NODE_12187_length_255_cov_1.543956_g12083_i0 PRJNA1102048 12187 255 1.543956 3.9370878 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 61.6 8.05e-9   NR KAL1523974.1 97485 g12083 i0 44.6 4.54117647058824 74 35 84.7 2 216 1 165 234 KAL1523974.1 hypothetical protein AB1Y20_018889 [Prymnesium parvum] diamond 1158 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29025917 29025917 PRJNA1102048_P_NODE_5068_length_381_cov_1.993506_g4964_i0 PRJNA1102048 5068 381 1.993506 7.59525786 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 96.3 2.89e-20   NR XP_005762436.1 280463 g4964 i0 41.5 1.65354330708661 106 62 83.5 0 63 380 10 115 XP_005762436.1 glyceraldehyde-3-phosphate dehydrogenase [Emiliania huxleyi CCMP1516] diamond 630 96.3 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29688351 29688351 PRJNA1102048_P_NODE_5950_length_354_cov_1.096085_g5846_i0 PRJNA1102048 5950 354 1.096085 3.8801409 Prymnesium parvum 97485 Haptophyta other_Eukaryota 139 1.09e-39   NR KAL1523551.1 97485 g5846 i0 63 1.83050847457627 108 40 91.5 0 324 1 1 108 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 648 139 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30604718 30604718 PRJNA1102048_P_NODE_8693_length_294_cov_4.678733_g8589_i0 PRJNA1102048 8693 294 4.678733 13.75547502 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 67.8 1.17e-12   NR KAG8458221.1 2081491 g8589 i0 57.1 0.571428571428571 56 24 57.1 0 109 276 6 61 KAG8458221.1 hypothetical protein KFE25_001513 [Diacronema lutheri] diamond 168 67.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30731134 30731134 PRJNA1102048_P_NODE_13254_length_250_cov_0.870056_g13150_i0 PRJNA1102048 13254 250 0.870056 2.17514 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 56.6 3.63e-7   NR KAJ1637674.1 483367 g13150 i0 38.1 3.636 84 48 97.2 2 246 4 123 205 KAJ1637674.1 translocon-associated protein [Pavlovales sp. CCMP2436] diamond 909 56.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30920953 30920953 PRJNA1102048_P_NODE_5934_length_354_cov_1.633452_g5830_i0 PRJNA1102048 5934 354 1.633452 5.78242008 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 94.4 2.51e-21   NR KAG8463376.1 2081491 g5830 i0 65.7 1.07627118644068 67 22 55.9 1 157 354 27 93 KAG8463376.1 hypothetical protein KFE25_004887 [Diacronema lutheri] diamond 381 94.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31070221 31070221 PRJNA1102048_P_NODE_3135_length_476_cov_6.133995_g3031_i0 PRJNA1102048 3135 476 6.133995 29.1978162 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 148 1.2099999999999999e-42   NR KAL1514807.1 97485 g3031 i0 58.3 20.7163865546218 139 55 87 2 25 438 4 140 KAL1514807.1 hypothetical protein AB1Y20_003893 [Prymnesium parvum] diamond 9861 149 0.993288590604027 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31837530 31837530 PRJNA1102048_P_NODE_9557_length_283_cov_1.904762_g9453_i0 PRJNA1102048 9557 283 1.904762 5.39047646 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 92 2.85e-19   NR KAG8457352.1 2081491 g9453 i0 46.2 0.964664310954064 91 47 96.5 1 283 11 120 208 KAG8457352.1 hypothetical protein KFE25_014081 [Diacronema lutheri] diamond 273 92 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32312610 32312610 PRJNA1102048_P_NODE_7319_length_320_cov_1.866397_g7215_i0 PRJNA1102048 7319 320 1.866397 5.9724704 Prymnesium parvum 97485 Haptophyta other_Eukaryota 90.5 3.7300000000000006e-21   NR KAL1510806.1 97485 g7215 i0 72.5 0.646875 69 17 62.8 1 85 285 25 93 KAL1510806.1 hypothetical protein AB1Y20_007090 [Prymnesium parvum] diamond 207 90.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32659646 32659646 PRJNA1102048_P_NODE_9260_length_287_cov_1.280374_g9156_i0 PRJNA1102048 9260 287 1.280374 3.67467338 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87 1.72e-17   NR XP_005761190.1 280463 g9156 i0 50.6 0.867595818815331 83 41 86.8 0 38 286 847 929 XP_005761190.1 hypothetical protein EMIHUDRAFT_438208 [Emiliania huxleyi CCMP1516] diamond 249 87 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
32871635 32871635 PRJNA1102048_P_NODE_240_length_1223_cov_2.478261_g190_i0 PRJNA1102048 240 1223 2.478261 30.30913203 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 509 1.86e-177   NR AAW79315.1 37099 g190 i0 67 6.46606704824203 358 108 85.6 2 1116 70 11 367 AAW79315.1 chloroplast ferredoxin NADP(+) reductase, partial [Isochrysis galbana] diamond 7908 513 0.992202729044834 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Isochrysis Isochrysis galbana

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