RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA431371", 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

  • PRJNA431371 · 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
9356563 9356563 PRJNA431371_P_NODE_33368_length_244_cov_0.900585_g33295_i0 PRJNA431371 33368 244 0.900585 2.1974274 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 246 9.409999999999999e-61   NTclustered gi|551624794|ref|XM_005792543.1| 280463 g33295 i0 84.836 44.6598360655738 244 37 100 0 1 244 107 350 Emiliania huxleyi CCMP1516 40S ribosomal protein S14 partial mRNA blastn 10897 246 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18279835 18279835 PRJNA431371_P_NODE_27935_length_248_cov_1.320000_g27862_i0 PRJNA431371 27935 248 1.32 3.2736 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 99.4 4.76e-22   NR XP_005774035.1 280463 g27862 i0 62.2 3.78629032258065 82 31 99.2 0 1 246 595 676 XP_005774035.1 threonine-tRNA ligase, partial [Emiliania huxleyi CCMP1516] diamond 939 99.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
22104504 22104504 PRJNA431371_P_NODE_1178_length_887_cov_2.921376_g1116_i0 PRJNA431371 1178 887 2.921376 25.91260512 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 301 5.81e-98   NR KOO23867.1 1460289 g1116 i0 69.9 1.99549041713641 193 58 65.3 0 885 307 129 321 KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii] diamond 1770 301 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
23380418 23380418 PRJNA431371_P_NODE_26859_length_249_cov_0.875000_g26786_i0 PRJNA431371 26859 249 0.875 2.17875 Prymnesium parvum 97485 Haptophyta other_Eukaryota 73.6 4.83e-13   NR KAL1527694.1 97485 g26786 i0 69.4 1.79518072289157 49 15 59 0 147 1 132 180 KAL1527694.1 hypothetical protein AB1Y20_009080 [Prymnesium parvum] diamond 447 73.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26648901 26648901 PRJNA431371_P_NODE_1521_length_817_cov_3.321237_g1455_i0 PRJNA431371 1521 817 3.321237 27.13450629 Prymnesiales 73028 Haptophyta other_Eukaryota 419 2.0099999999999994e-144   NR KAL1523363.1 97485 g1455 i0 77.5 6.40024479804162 249 56 91.4 0 45 791 112 360 KAL1523363.1 hypothetical protein AB1Y20_018307 [Prymnesium parvum] diamond 5229 419 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27360414 27360414 PRJNA431371_P_NODE_4903_length_537_cov_1.823276_g4830_i0 PRJNA431371 4903 537 1.823276 9.79099212 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 127 1.1399999999999999e-32   NR KAG8460620.1 2081491 g4830 i0 43.8 1.80446927374302 162 83 88.3 3 5 478 87 244 KAG8460620.1 hypothetical protein KFE25_011395 [Diacronema lutheri] diamond 969 127 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
27708052 27708052 PRJNA431371_P_NODE_9944_length_395_cov_2.894410_g9871_i0 PRJNA431371 9944 395 2.89441 11.4329195 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 85.1 1.1e-17   NR KAG8459362.1 2081491 g9871 i0 64.2 0.40253164556962 53 19 40.3 0 159 1 120 172 KAG8459362.1 hypothetical protein KFE25_012998 [Diacronema lutheri] diamond 159 85.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28212499 28212499 PRJNA431371_P_NODE_22206_length_270_cov_1.172589_g22133_i0 PRJNA431371 22206 270 1.172589 3.1659903 Prymnesium parvum 97485 Haptophyta other_Eukaryota 45.1 0.00766   NR KAL1495853.1 97485 g22133 i0 34.1 0.911111111111111 82 52 91.1 1 266 21 260 339 KAL1495853.1 hypothetical protein AB1Y20_014497 [Prymnesium parvum] diamond 246 45.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28244150 28244150 PRJNA431371_P_NODE_16186_length_319_cov_1.252033_g16113_i0 PRJNA431371 16186 319 1.252033 3.99398527 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 56.2 1.61e-6   NR XP_005762768.1 280463 g16113 i0 45.2 4.66457680250784 62 34 58.3 0 195 10 224 285 XP_005762768.1 hypothetical protein EMIHUDRAFT_459859 [Emiliania huxleyi CCMP1516] diamond 1488 56.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28339103 28339103 PRJNA431371_P_NODE_14986_length_330_cov_1.198444_g14913_i0 PRJNA431371 14986 330 1.198444 3.9548652 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 43.5 0.0415   NR XP_005779065.1 280463 g14913 i0 45.7 0.418181818181818 46 25 41.8 0 285 148 168 213 XP_005779065.1 hypothetical protein EMIHUDRAFT_236679 [Emiliania huxleyi CCMP1516] diamond 138 43.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29412453 29412453 PRJNA431371_P_NODE_3449_length_614_cov_2.325323_g3376_i0 PRJNA431371 3449 614 2.325323 14.27748322 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 58.5 2.34e-6   NR ABI13166.1 2903 g3376 i0 32.4 0.9185667752443 188 110 87.9 7 544 5 64 242 ABI13166.1 putative outer mitochondrial membrane protein porin [Emiliania huxleyi] diamond 564 58.5 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29791273 29791273 PRJNA431371_P_NODE_30211_length_246_cov_1.329480_g30138_i0 PRJNA431371 30211 246 1.32948 3.2705208 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 57.8 1.65e-7   NR KAL3899236.1 2812485 g30138 i0 48.1 0.634146341463415 52 27 63.4 0 186 31 52 103 KAL3899236.1 MAG: hypothetical protein SGPRY_012678, partial [Prymnesium sp.] diamond 156 57.8 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
30107256 30107256 PRJNA431371_P_NODE_35572_length_242_cov_0.911243_g35499_i0 PRJNA431371 35572 242 0.911243 2.20520806 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 44.7 0.00741   NR KAG8460774.1 2081491 g35499 i0 40.3 0.768595041322314 62 37 76.9 0 191 6 280 341 KAG8460774.1 hypothetical protein KFE25_010829 [Diacronema lutheri] diamond 186 44.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30233736 30233736 PRJNA431371_P_NODE_8512_length_425_cov_1.184659_g8439_i0 PRJNA431371 8512 425 1.184659 5.03480075 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 61.6 1.92e-8   NR KAL3897067.1 2812485 g8439 i0 36.6 0.712941176470588 101 55 67.1 3 303 19 76 173 KAL3897067.1 MAG: hypothetical protein SGPRY_013129 [Prymnesium sp.] diamond 303 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
31071852 31071852 PRJNA431371_P_NODE_31115_length_246_cov_0.890173_g31042_i0 PRJNA431371 31115 246 0.890173 2.18982558 root 1 Root_unresolved Root_unresolved 85.1 4.52e-17   NR XP_005762436.1 280463 g31042 i0 52.5 4.75609756097561 80 33 97.6 2 244 5 374 448 XP_005762436.1 glyceraldehyde-3-phosphate dehydrogenase [Emiliania huxleyi CCMP1516] diamond 1170 85.1 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
31877272 31877272 PRJNA431371_P_NODE_14697_length_333_cov_1.184615_g14624_i0 PRJNA431371 14697 333 1.184615 3.94476795 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 67.8 1.08e-10   NR KAJ1615605.1 483367 g14624 i0 42.9 1.1981981981982 70 40 63.1 0 316 107 13 82 KAJ1615605.1 Ion transport protein-domain-containing protein, partial [Pavlovales sp. CCMP2436] diamond 399 67.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32731007 32731007 PRJNA431371_P_NODE_11620_length_369_cov_1.300676_g11547_i0 PRJNA431371 11620 369 1.300676 4.79949444 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 82.4 2.03e-15   NR KAG8466765.1 2081491 g11547 i0 39.2 2.99186991869919 120 38 97.6 3 360 1 216 300 KAG8466765.1 hypothetical protein KFE25_008144 [Diacronema lutheri] diamond 1104 82.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);;