RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA800090", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 21 ✖

tax_phylum 1

tax_clade 1

  • Haptista · 21 ✖

bioproject 1

  • PRJNA800090 · 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
796809 796809 PRJNA800090_P_NODE_122661_length_288_cov_1.534247_g120476_i0 PRJNA800090 122661 288 1.534247 4.41863136 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 167 1.15e-49   NR KAL1495223.1 97485 g120476 i0 83.2 78.125 95 16 99 0 3 287 98 192 KAL1495223.1 hypothetical protein AB1Y20_017086 [Prymnesium parvum] diamond 22500 167 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
2073762 2073762 PRJNA800090_P_NODE_174222_length_235_cov_0.879518_g172037_i0 PRJNA800090 174222 235 0.879518 2.0668673 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 85.5 2.8e-17   NR KAL1504882.1 97485 g172037 i0 61.9 1.4936170212766 63 24 80.4 0 190 2 195 257 KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum] diamond 351 85.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
3349909 3349909 PRJNA800090_P_NODE_37363_length_610_cov_3.055453_g35214_i0 PRJNA800090 37363 610 3.055453 18.6382633 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 251 9.67e-82   NR XP_005783873.1 280463 g35214 i0 64.5 3.83114754098361 197 64 93.9 1 575 3 1 197 XP_005783873.1 hypothetical protein EMIHUDRAFT_442198 [Emiliania huxleyi CCMP1516] diamond 2337 251 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
18649881 18649881 PRJNA800090_P_NODE_192395_length_228_cov_1.075472_g190210_i0 PRJNA800090 192395 228 1.075472 2.45207616 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 158 4.189999999999999e-34   NTclustered gi|551616442|ref|XM_005789008.1| 280463 g190210 i0 84.049 57.6973684210526 163 26 71 0 17 179 37 199 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 13155 158 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
23750782 23750782 PRJNA800090_P_NODE_179379_length_233_cov_0.890244_g177194_i0 PRJNA800090 179379 233 0.890244 2.07426852 Prymnesium parvum 97485 Haptophyta other_Eukaryota 137 7.16e-36   NR KAL1495187.1 97485 g177194 i0 85.7 4.95708154506438 77 10 99.1 1 3 233 442 517 KAL1495187.1 hypothetical protein AB1Y20_017052 [Prymnesium parvum] diamond 1155 137 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26705669 26705669 PRJNA800090_P_NODE_179541_length_233_cov_0.890244_g177356_i0 PRJNA800090 179541 233 0.890244 2.07426852 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 107 6.0400000000000005e-27   NR KAG8471032.1 2081491 g177356 i0 68.9 2.88412017167382 74 23 95.3 0 223 2 73 146 KAG8471032.1 hypothetical protein KFE25_009453 [Diacronema lutheri] diamond 672 107 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26968033 26968033 PRJNA800090_P_NODE_131222_length_276_cov_1.763285_g129037_i0 PRJNA800090 131222 276 1.763285 4.8666666 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 127 1.99e-35   NR KAL1523551.1 97485 g129037 i0 66.3 3.8695652173913 89 30 96.7 0 1 267 22 110 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 1068 128 0.9921875 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
26990614 26990614 PRJNA800090_P_NODE_98982_length_328_cov_1.478764_g96797_i0 PRJNA800090 98982 328 1.478764 4.85034592 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 58.2 1.69e-7   NR XP_005783668.1 280463 g96797 i0 68.8 1.4359756097561 32 10 29.3 0 104 9 52 83 XP_005783668.1 hypothetical protein EMIHUDRAFT_456383 [Emiliania huxleyi CCMP1516] diamond 471 58.2 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27211966 27211966 PRJNA800090_P_NODE_198202_length_216_cov_2.292517_g196017_i0 PRJNA800090 198202 216 2.292517 4.95183672 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 84 1e-18   NR KAG8458175.1 2081491 g196017 i0 58 5.65277777777778 69 28 95.8 1 207 1 13 80 KAG8458175.1 hypothetical protein KFE25_011706 [Diacronema lutheri] diamond 1221 84 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28001837 28001837 PRJNA800090_P_NODE_184665_length_231_cov_0.901235_g182480_i0 PRJNA800090 184665 231 0.901235 2.08185285 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 46.2 6.56e-4   NR KOO20826.1 1460289 g182480 i0 56.4 1.77922077922078 39 17 50.6 0 100 216 40 78 KOO20826.1 calmodulin-like protein [Chrysochromulina tobinii] diamond 411 46.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28475306 28475306 PRJNA800090_P_NODE_125126_length_284_cov_3.753488_g122941_i0 PRJNA800090 125126 284 3.753488 10.65990592 Prymnesium parvum 97485 Haptophyta other_Eukaryota 53.1 2.61e-6   NR KAL1512308.1 97485 g122941 i0 55.1 0.517605633802817 49 22 51.8 0 32 178 83 131 KAL1512308.1 hypothetical protein AB1Y20_005570 [Prymnesium parvum] diamond 147 53.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28885633 28885633 PRJNA800090_P_NODE_152328_length_254_cov_1.227027_g150143_i0 PRJNA800090 152328 254 1.227027 3.11664858 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 113 4.0199999999999998e-28   NR KAG8458504.1 2081491 g150143 i0 66.7 0.992125984251969 84 28 99.2 0 2 253 224 307 KAG8458504.1 hypothetical protein KFE25_003039 [Diacronema lutheri] diamond 252 113 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
28989646 28989646 PRJNA800090_P_NODE_157588_length_249_cov_1.361111_g155403_i0 PRJNA800090 157588 249 1.361111 3.38916639 Prymnesiales 73028 Haptophyta other_Eukaryota 110 3.42e-28   NR KAL1515683.1 97485 g155403 i0 63.9 2.98795180722892 83 28 100 1 1 249 90 170 KAL1515683.1 hypothetical protein AB1Y20_002300 [Prymnesium parvum] diamond 744 110 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29548584 29548584 PRJNA800090_P_NODE_131950_length_275_cov_2.019417_g129765_i0 PRJNA800090 131950 275 2.019417 5.55339675 Prymnesium parvum 97485 Haptophyta other_Eukaryota 68.2 6.23e-11   NR KAL1515824.1 97485 g129765 i0 48.6 0.763636363636364 70 30 76.4 1 243 34 647 710 KAL1515824.1 hypothetical protein AB1Y20_002440 [Prymnesium parvum] diamond 210 68.2 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30780794 30780794 PRJNA800090_P_NODE_70274_length_407_cov_1.106509_g68089_i0 PRJNA800090 70274 407 1.106509 4.50349163 Prymnesium parvum 97485 Haptophyta other_Eukaryota 122 1.97e-32   NR KAL1523551.1 97485 g68089 i0 54.9 10.3783783783784 113 45 78.9 1 60 380 8 120 KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum] diamond 4224 122 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30884491 30884491 PRJNA800090_P_NODE_117054_length_296_cov_1.969163_g114869_i0 PRJNA800090 117054 296 1.969163 5.82872248 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42.4 0.0298   NR KAJ1620622.1 483367 g114869 i0 36 3.14189189189189 75 46 75 2 74 295 7 80 KAJ1620622.1 hypothetical protein T492DRAFT_1076613 [Pavlovales sp. CCMP2436] diamond 930 42.7 0.992974238875878 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
31507983 31507983 PRJNA800090_P_NODE_147176_length_259_cov_1.336842_g144991_i0 PRJNA800090 147176 259 1.336842 3.46242078 Prymnesium parvum 97485 Haptophyta other_Eukaryota 134 3.499999999999999e-38   NR KAL1514451.1 97485 g144991 i0 74.1 1.8996138996139 81 21 93.8 0 11 253 6 86 KAL1514451.1 hypothetical protein AB1Y20_003550 [Prymnesium parvum] diamond 492 134 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31602856 31602856 PRJNA800090_P_NODE_191976_length_228_cov_1.761006_g189791_i0 PRJNA800090 191976 228 1.761006 4.01509368 Prymnesium parvum 97485 Haptophyta other_Eukaryota 89.7 8.41e-19   NR KAL1525905.1 97485 g189791 i0 58.1 3.89473684210526 74 31 97.4 0 6 227 318 391 KAL1525905.1 hypothetical protein AB1Y20_020733 [Prymnesium parvum] diamond 888 89.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31832854 31832854 PRJNA800090_P_NODE_181857_length_232_cov_0.895706_g179672_i0 PRJNA800090 181857 232 0.895706 2.07803792 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 114 3.07e-28   NR KAJ1641422.1 483367 g179672 i0 70.1 3.94396551724138 77 22 98.3 1 229 2 115 191 KAJ1641422.1 alternative oxidase-domain-containing protein [Pavlovales sp. CCMP2436] diamond 915 114 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
32267278 32267278 PRJNA800090_P_NODE_57278_length_464_cov_1.235443_g55094_i0 PRJNA800090 57278 464 1.235443 5.73245552 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 71.6 2.53e-12   NR KAL3916050.1 2812485 g55094 i0 36.7 0.633620689655172 98 54 58.2 1 193 462 66 163 KAL3916050.1 MAG: hypothetical protein SGPRY_006984 [Prymnesium sp.] diamond 294 71.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
32339506 32339506 PRJNA800090_P_NODE_143199_length_263_cov_1.257732_g141014_i0 PRJNA800090 143199 263 1.257732 3.30783516 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 124 3.3799999999999995e-32   NR KOO22616.1 1460289 g141014 i0 63.2 1.98479087452471 87 32 99.2 0 2 262 202 288 KOO22616.1 NADH-cytochrome b5 [Chrysochromulina tobinii] diamond 522 125 0.992 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii

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