RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA407886" 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 · 17 ✖

bioproject 1

  • PRJNA407886 · 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
417679 417679 PRJNA407886_P_NODE_56341_length_284_cov_2.146919_g54647_i0 PRJNA407886 56341 284 2.146919 6.09724996 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 122 2.44e-30   NR XP_005762554.1 280463 g54647 i0 67.4 3.88732394366197 92 27 97.2 1 2 277 193 281 XP_005762554.1 heat shock protein 60, partial [Emiliania huxleyi CCMP1516] diamond 1104 122 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
4244886 4244886 PRJNA407886_P_NODE_61844_length_269_cov_2.346939_g60150_i0 PRJNA407886 61844 269 2.346939 6.31326591 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 257 4.87e-64   NTclustered gi|551555198|ref|XM_005764739.1| 280463 g60150 i0 86.066 92.8810408921933 244 29 89 4 1 240 1031 789 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 24985 257 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6795173 6795173 PRJNA407886_P_NODE_42906_length_332_cov_1.810811_g41212_i0 PRJNA407886 42906 332 1.810811 6.01189252 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 193 1.77e-44   NTclustered gi|551548842|ref|XM_005762007.1| 280463 g41212 i0 81.435 17.4066265060241 237 42 71 2 8 243 169 404 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 5779 193 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
14446774 14446774 PRJNA407886_P_NODE_64212_length_263_cov_2.200000_g62518_i0 PRJNA407886 64212 263 2.2 5.786 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 54.7 0.007   NTclustered gi|551565513|ref|XM_005769136.1| 280463 g62518 i0 100 0.110266159695817 29 0 11 0 13 41 4600 4628 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 29 54.7 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24643584 24643584 PRJNA407886_P_NODE_32060_length_399_cov_3.622699_g30366_i0 PRJNA407886 32060 399 3.622699 14.45456901 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 149 2.62e-44   NR XP_005758635.1 280463 g30366 i0 86.4 0.609022556390977 81 11 60.9 0 370 128 3 83 XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516] diamond 243 149 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
24644612 24644612 PRJNA407886_P_NODE_83900_length_226_cov_2.013072_g82206_i0 PRJNA407886 83900 226 2.013072 4.54954272 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 58.4 4.32e-4   NTclustered gi|551609532|ref|XM_005785912.1| 280463 g82206 i0 85.965 1.34955752212389 57 5 25 2 25 81 574 627 Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA blastn 305 58.4 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
26822480 26822480 PRJNA407886_P_NODE_40221_length_345_cov_2.691176_g38527_i0 PRJNA407886 40221 345 2.691176 9.2845572 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 80.9 1.52e-15   NR XP_005767823.1 280463 g38527 i0 47.1 4.61739130434783 102 48 87 3 1 300 159 256 XP_005767823.1 hypothetical protein EMIHUDRAFT_356503 [Emiliania huxleyi CCMP1516] diamond 1593 80.9 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27012172 27012172 PRJNA407886_P_NODE_50462_length_302_cov_2.558952_g48768_i0 PRJNA407886 50462 302 2.558952 7.72803504 Prymnesium sp. 2812485 Haptophyta other_Eukaryota 128 1.3e-34   NR KAL3914914.1 2812485 g48768 i0 62.9 7.07284768211921 89 33 88.4 0 302 36 131 219 KAL3914914.1 MAG: hypothetical protein SGPRY_007452 [Prymnesium sp.] diamond 2136 128 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium sp.
28338837 28338837 PRJNA407886_P_NODE_60826_length_272_cov_1.542714_g59132_i0 PRJNA407886 60826 272 1.542714 4.19618208 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 115 6.63e-31   NR XP_005787147.1 280463 g59132 i0 79.2 2.38235294117647 72 15 79.4 0 271 56 56 127 XP_005787147.1 hypothetical protein EMIHUDRAFT_460589 [Emiliania huxleyi CCMP1516] diamond 648 115 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
28717812 28717812 PRJNA407886_P_NODE_80387_length_242_cov_0.911243_g78693_i0 PRJNA407886 80387 242 0.911243 2.20520806 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 84.3 7.49e-17   NR KAJ1615610.1 483367 g78693 i0 59.3 1.00413223140496 81 29 99.2 3 242 3 65 142 KAJ1615610.1 hypothetical protein T492DRAFT_897359, partial [Pavlovales sp. CCMP2436] diamond 243 84.3 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30391943 30391943 PRJNA407886_P_NODE_73233_length_248_cov_0.880000_g71539_i0 PRJNA407886 73233 248 0.88 2.1824 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 51.2 4.02e-5   NR KAG8460110.1 2081491 g71539 i0 57.9 0.459677419354839 38 16 46 0 115 2 62 99 KAG8460110.1 hypothetical protein KFE25_014255 [Diacronema lutheri] diamond 114 51.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30612506 30612506 PRJNA407886_P_NODE_76793_length_245_cov_0.895349_g75099_i0 PRJNA407886 76793 245 0.895349 2.19360505 Prymnesium parvum 97485 Haptophyta other_Eukaryota 43.9 0.0146   NR KAL1503670.1 97485 g75099 i0 32.4 0.906122448979592 74 49 89.4 1 20 238 299 372 KAL1503670.1 hypothetical protein AB1Y20_012143 [Prymnesium parvum] diamond 222 43.9 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30707339 30707339 PRJNA407886_P_NODE_38554_length_354_cov_2.587189_g36860_i0 PRJNA407886 38554 354 2.587189 9.15864906 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 97.1 6.160000000000001e-22   NR KAJ1635632.1 483367 g36860 i0 50.5 5.71186440677966 111 55 94.1 0 19 351 7 117 KAJ1635632.1 ribosomal protein L30, ferredoxin-like fold domain-containing protein [Pavlovales sp. CCMP2436] diamond 2022 97.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
30755746 30755746 PRJNA407886_P_NODE_71974_length_249_cov_0.875000_g70280_i0 PRJNA407886 71974 249 0.875 2.17875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 62.4 3.81e-9   NR KOO28548.1 1460289 g70280 i0 35.8 1.93975903614458 81 52 97.6 0 3 245 220 300 KOO28548.1 multidrug oligosaccharidyl-lipid polysaccharide flippase superfamily [Chrysochromulina tobinii] diamond 483 62.8 0.993630573248408 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31086596 31086596 PRJNA407886_P_NODE_67095_length_257_cov_1.179348_g65401_i0 PRJNA407886 67095 257 1.179348 3.03092436 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 61.6 9.69e-9   NR KOO23580.1 1460289 g65401 i0 46.8 0.723735408560311 62 33 72.4 0 256 71 189 250 KOO23580.1 surface protein with egf [Chrysochromulina tobinii] diamond 186 61.6 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31845433 31845433 PRJNA407886_P_NODE_76737_length_245_cov_0.895349_g75043_i0 PRJNA407886 76737 245 0.895349 2.19360505 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 45.8 0.00305   NR KAG8462471.1 2081491 g75043 i0 37.1 0.857142857142857 70 40 80.8 2 199 2 189 258 KAG8462471.1 hypothetical protein KFE25_010296 [Diacronema lutheri] diamond 210 45.8 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
32856537 32856537 PRJNA407886_P_NODE_39240_length_350_cov_2.891697_g37546_i0 PRJNA407886 39240 350 2.891697 10.1209395 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 93.6 5.57e-22   NR XP_005782836.1 280463 g37546 i0 51 7.05428571428571 102 46 86.6 2 16 318 16 114 XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] diamond 2469 93.6 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi

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