RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1214993" 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 · 16 ✖

bioproject 1

  • PRJNA1214993 · 16 ✖

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
7983751 7983751 PRJNA1214993_P_NODE_23087_length_247_cov_0.896552_g22901_i0 PRJNA1214993 23087 247 0.896552 2.21448344 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 120 8.59e-32   NR KAJ1620981.1 483367 g22901 i0 74.1 0.983805668016194 81 21 98.4 0 243 1 1 81 KAJ1620981.1 P-loop containing nucleoside triphosphate hydrolase protein [Pavlovales sp. CCMP2436] diamond 243 120 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
11808973 11808973 PRJNA1214993_P_NODE_21850_length_249_cov_0.886364_g21664_i0 PRJNA1214993 21850 249 0.886364 2.20704636 Prymnesium parvum 97485 Haptophyta other_Eukaryota 125 5.769999999999999e-32   NR KAL1512169.1 97485 g21664 i0 69.5 0.987951807228916 82 25 98.8 0 248 3 145 226 KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum] diamond 246 125 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
19456331 19456331 PRJNA1214993_P_NODE_12756_length_309_cov_1.322034_g12570_i0 PRJNA1214993 12756 309 1.322034 4.08508506 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 119 4.709999999999999e-32   NR KAG8457026.1 2081491 g12570 i0 69 8.31067961165049 87 23 84.5 1 48 308 16 98 KAG8457026.1 hypothetical protein KFE25_010442 [Diacronema lutheri] diamond 2568 119 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
23282560 23282560 PRJNA1214993_P_NODE_6239_length_430_cov_1.627451_g6054_i0 PRJNA1214993 6239 430 1.627451 6.9980393 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 252 3.81e-62   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g6054 i0 81.433 23.2348837209302 307 57 71 0 57 363 411 105 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 9991 252 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26755942 26755942 PRJNA1214993_P_NODE_18841_length_258_cov_1.329730_g18655_i0 PRJNA1214993 18841 258 1.32973 3.4307034 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 55.8 1.06e-6   NR XP_005763545.1 280463 g18655 i0 39.5 0.883720930232558 76 41 86 2 27 248 519 591 XP_005763545.1 hypothetical protein EMIHUDRAFT_437682 [Emiliania huxleyi CCMP1516] diamond 228 55.8 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26819691 26819691 PRJNA1214993_P_NODE_26221_length_242_cov_0.911243_g26035_i0 PRJNA1214993 26221 242 0.911243 2.20520806 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 43.1 0.0258   NR XP_005789301.1 280463 g26035 i0 38 0.880165289256198 71 43 86.8 1 9 218 9 79 XP_005789301.1 hypothetical protein EMIHUDRAFT_201150 [Emiliania huxleyi CCMP1516] diamond 213 43.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27135444 27135444 PRJNA1214993_P_NODE_19642_length_253_cov_0.866667_g19456_i0 PRJNA1214993 19642 253 0.866667 2.19266751 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 76.6 4.72e-14   NR KAL3925578.1 2812485 g19456 i0 47.6 1.99209486166008 84 44 99.6 0 2 253 355 438 KAL3925578.1 MAG: hypothetical protein SGPRY_003612 [Prymnesium sp.] diamond 504 76.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
27515046 27515046 PRJNA1214993_P_NODE_22683_length_248_cov_0.880000_g22497_i0 PRJNA1214993 22683 248 0.88 2.1824 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 110 3.82e-26   NR XP_005787344.1 280463 g22497 i0 59 1.00403225806452 83 33 99.2 1 248 3 351 433 XP_005787344.1 hypothetical protein EMIHUDRAFT_252709 [Emiliania huxleyi CCMP1516] diamond 249 110 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29712090 29712090 PRJNA1214993_P_NODE_21070_length_250_cov_0.881356_g20884_i0 PRJNA1214993 21070 250 0.881356 2.20339 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42 0.0312   NR KOO27134.1 1460289 g20884 i0 63.6 0.696 22 8 26.4 0 183 248 74 95 KOO27134.1 54s ribosomal protein mitochondrial-like protein [Chrysochromulina tobinii] diamond 174 42 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
30186169 30186169 PRJNA1214993_P_NODE_14712_length_289_cov_1.199074_g14526_i0 PRJNA1214993 14712 289 1.199074 3.46532386 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 105 1.09e-26   NR KAL1529987.1 97485 g14526 i0 54.3 11.5017301038062 92 42 95.5 0 13 288 8 99 KAL1529987.1 hypothetical protein AB1Y20_000913 [Prymnesium parvum] diamond 3324 105 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30262522 30262522 PRJNA1214993_P_NODE_4252_length_516_cov_2.040632_g4067_i0 PRJNA1214993 4252 516 2.040632 10.52966112 Prymnesium parvum 97485 Haptophyta other_Eukaryota 182 4.119999999999999e-52   NR KAL1499712.1 97485 g4067 i0 56.5 1.02906976744186 177 64 95.9 4 22 516 268 443 KAL1499712.1 hypothetical protein AB1Y20_011907 [Prymnesium parvum] diamond 531 182 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31526522 31526522 PRJNA1214993_P_NODE_25076_length_244_cov_0.900585_g24890_i0 PRJNA1214993 25076 244 0.900585 2.1974274 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 46.6 0.00158   NR XP_005760173.1 280463 g24890 i0 35.1 0.909836065573771 74 47 91 1 233 12 362 434 XP_005760173.1 hypothetical protein EMIHUDRAFT_106464 [Emiliania huxleyi CCMP1516] diamond 222 46.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31640032 31640032 PRJNA1214993_P_NODE_11496_length_325_cov_1.190476_g11310_i0 PRJNA1214993 11496 325 1.190476 3.869047 Cryptophyceae 3027 Haptophyta other_Eukaryota 106 7.250000000000001e-27   NR KAL1495619.1 97485 g11310 i0 51.9 2.88 104 50 96 0 314 3 7 110 KAL1495619.1 hypothetical protein AB1Y20_016487 [Prymnesium parvum] diamond 936 106 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31988025 31988025 PRJNA1214993_P_NODE_17238_length_270_cov_1.187817_g17052_i0 PRJNA1214993 17238 270 1.187817 3.2071059 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 103 1.5799999999999998e-23   NR KAL1499136.1 97485 g17052 i0 59.8 5.87777777777778 87 33 94.4 1 8 262 364 450 KAL1499136.1 hypothetical protein AB1Y20_013647 [Prymnesium parvum] diamond 1587 104 0.990384615384615 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32032588 32032588 PRJNA1214993_P_NODE_23878_length_246_cov_0.890173_g23692_i0 PRJNA1214993 23878 246 0.890173 2.18982558 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 44.7 0.00212   NR KOO29468.1 1460289 g23692 i0 70.3 0.451219512195122 37 10 45.1 1 226 116 78 113 KOO29468.1 ubiquitin [Chrysochromulina tobinii] diamond 111 44.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
32790586 32790586 PRJNA1214993_P_NODE_16780_length_273_cov_1.560000_g16594_i0 PRJNA1214993 16780 273 1.56 4.2588 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 92.4 9.57e-20   NR KAJ1638893.1 483367 g16594 i0 48.3 0.978021978021978 89 45 97.8 1 271 5 144 231 KAJ1638893.1 NADP-dependent oxidoreductase domain-containing protein [Pavlovales sp. CCMP2436] diamond 267 92.4 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);;