RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 13 ✖

bioproject 1

  • PRJNA1174234 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
18167706 18167706 PRJNA1174234_P_NODE_20655_length_304_cov_1.164502_g20459_i0 PRJNA1174234 20655 304 1.164502 3.54008608 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 66.2 1.82e-10   NR KAG8462568.1 2081491 g20459 i0 52.6 0.75 76 34 73 1 224 3 1 76 KAG8462568.1 hypothetical protein KFE25_010393 [Diacronema lutheri] diamond 228 66.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
26850838 26850838 PRJNA1174234_P_NODE_1321_length_1035_cov_1.703742_g1197_i0 PRJNA1174234 1321 1035 1.703742 17.6337297 Prymnesium parvum 97485 Haptophyta other_Eukaryota 205 2.06e-60   NR KAL1520255.1 97485 g1197 i0 40.4 2.26666666666667 255 151 73.6 1 39 800 4 258 KAL1520255.1 hypothetical protein AB1Y20_023725 [Prymnesium parvum] diamond 2346 205 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27103638 27103638 PRJNA1174234_P_NODE_27182_length_261_cov_2.457447_g26986_i0 PRJNA1174234 27182 261 2.457447 6.41393667 Prymnesium parvum 97485 Haptophyta other_Eukaryota 99 3.6300000000000003e-22   NR KAL1530215.1 97485 g26986 i0 56.6 1.86206896551724 76 33 87.4 0 261 34 73 148 KAL1530215.1 hypothetical protein AB1Y20_001130 [Prymnesium parvum] diamond 486 99 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
27134955 27134955 PRJNA1174234_P_NODE_10162_length_433_cov_0.841667_g9966_i0 PRJNA1174234 10162 433 0.841667 3.64441811 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 76.6 1.15e-13   NR KAJ1624672.1 483367 g9966 i0 50.8 1.22632794457275 59 29 40.9 0 431 255 181 239 KAJ1624672.1 tryptophan RNA-binding attenuator protein-like domain-containing protein [Pavlovales sp. CCMP2436] diamond 531 76.6 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
28019898 28019898 PRJNA1174234_P_NODE_28885_length_251_cov_2.331461_g28689_i0 PRJNA1174234 28885 251 2.331461 5.85196711 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 74.7 7.82e-14   NR KOO32158.1 1460289 g28689 i0 52.2 6.50199203187251 67 32 80.1 0 227 27 123 189 KOO32158.1 flagellar calmodulin [Chrysochromulina tobinii] diamond 1632 74.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
28177315 28177315 PRJNA1174234_P_NODE_15726_length_348_cov_8.269091_g15530_i0 PRJNA1174234 15726 348 8.269091 28.77643668 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 87.4 1.42e-19   NR XP_005782836.1 280463 g15530 i0 51 0.844827586206897 98 44 83.6 2 30 320 20 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 294 87.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28177358 28177358 PRJNA1174234_P_NODE_4666_length_622_cov_1.730419_g4473_i0 PRJNA1174234 4666 622 1.730419 10.76320618 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 132 1.71e-31   NR KOO28486.1 1460289 g4473 i0 42.9 1.04662379421222 217 106 98.4 9 2 613 545 756 KOO28486.1 mhck ef2 kinase domain family protein [Chrysochromulina tobinii] diamond 651 132 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29535301 29535301 PRJNA1174234_P_NODE_8770_length_465_cov_1.734694_g8574_i0 PRJNA1174234 8770 465 1.734694 8.0663271 Prymnesium parvum 97485 Haptophyta other_Eukaryota 127 2.4099999999999993e-34   NR KAL1520230.1 97485 g8574 i0 55.2 1.65161290322581 125 54 80.6 1 428 54 1 123 KAL1520230.1 hypothetical protein AB1Y20_023700 [Prymnesium parvum] diamond 768 127 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30420060 30420060 PRJNA1174234_P_NODE_30493_length_249_cov_0.875000_g30297_i0 PRJNA1174234 30493 249 0.875 2.17875 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 47.8 1.1e-4   NR KAG8469222.1 2081491 g30297 i0 35.1 0.927710843373494 77 46 89.2 2 17 238 1 76 KAG8469222.1 hypothetical protein KFE25_007740 [Diacronema lutheri] diamond 231 47.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30502106 30502106 PRJNA1174234_P_NODE_7313_length_507_cov_0.868664_g7117_i0 PRJNA1174234 7313 507 0.868664 4.40412648 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 182 2.6499999999999998e-52   NR KAL1512169.1 97485 g7117 i0 57.5 4.55621301775148 153 65 90.5 0 506 48 265 417 KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum] diamond 2310 183 0.994535519125683 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
31083238 31083238 PRJNA1174234_P_NODE_20355_length_306_cov_1.313305_g20159_i0 PRJNA1174234 20355 306 1.313305 4.0187133 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 47.4 0.00194   NR KAG8463617.1 2081491 g20159 i0 41.1 0.549019607843137 56 31 52.9 1 10 171 932 987 KAG8463617.1 hypothetical protein KFE25_003890 [Diacronema lutheri] diamond 168 47.4 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31260467 31260467 PRJNA1174234_P_NODE_31855_length_247_cov_0.885057_g31659_i0 PRJNA1174234 31855 247 0.885057 2.18609079 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 102 1.9899999999999999e-25   NR KAL1528781.1 97485 g31659 i0 69.6 1.74898785425101 69 21 83.8 0 246 40 81 149 KAL1528781.1 hypothetical protein AB1Y20_010108 [Prymnesium parvum] diamond 432 103 0.990291262135922 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32821763 32821763 PRJNA1174234_P_NODE_17920_length_325_cov_2.313492_g17724_i0 PRJNA1174234 17920 325 2.313492 7.518849 Prymnesium parvum 97485 Haptophyta other_Eukaryota 69.7 3.42e-11   NR KAL1504725.1 97485 g17724 i0 54.1 1.71692307692308 61 27 56.3 1 143 325 705 764 KAL1504725.1 hypothetical protein AB1Y20_008503 [Prymnesium parvum] diamond 558 69.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum

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