RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA222400" 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

  • PRJNA222400 · 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
367267 367267 PRJNA222400_P_NODE_9441_length_162_cov_0.920354_g9408_i0 PRJNA222400 9441 162 0.920354 1.49097348 Pavlovophyceae 3435358 Haptophyta other_Eukaryota 93.6 3.58e-21   NR KAL1524389.1 97485 g9408 i0 79.2 5.88888888888889 53 11 98.1 0 4 162 182 234 KAL1524389.1 hypothetical protein AB1Y20_019284 [Prymnesium parvum] diamond 954 94.4 0.991525423728813 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
1642043 1642043 PRJNA222400_P_NODE_962_length_527_cov_12.106695_g931_i0 PRJNA222400 962 527 12.106695 63.80228265 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 124 5.87e-33   NR XP_005765065.1 280463 g931 i0 55.6 2.62428842504744 117 48 66.6 1 429 79 7 119 XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516] diamond 1383 124 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
6744844 6744844 PRJNA222400_P_NODE_4026_length_222_cov_1.502890_g3993_i0 PRJNA222400 4026 222 1.50289 3.3364158 Haptophyta 2830 Haptophyta other_Eukaryota 94.7 5.21e-21   NR KAJ1617733.1 483367 g3993 i0 81 1.59459459459459 58 11 78.4 0 176 3 10 67 KAJ1617733.1 fructose-bisphosphate aldolase [Pavlovales sp. CCMP2436] diamond 354 95.5 0.991623036649215 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
10571256 10571256 PRJNA222400_P_NODE_3529_length_241_cov_1.942708_g3496_i0 PRJNA222400 3529 241 1.942708 4.68192628 Pavlovales sp. CCMP2436 483367 Haptophyta other_Eukaryota 69.7 1.14e-11   NR KAJ1633408.1 483367 g3496 i0 46.8 0.95850622406639 77 40 95.9 1 234 4 474 549 KAJ1633408.1 stress-induced-phosphoprotein 1-like protein [Pavlovales sp. CCMP2436] diamond 231 69.7 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales     Pavlovales sp. CCMP2436
15670002 15670002 PRJNA222400_P_NODE_4293_length_214_cov_1.575758_g4260_i0 PRJNA222400 4293 214 1.575758 3.37212212 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 123 2.9e-34   NR KOO24604.1 1460289 g4260 i0 81.4 1.96261682242991 70 13 98.1 0 3 212 25 94 KOO24604.1 superoxide dismutase [Chrysochromulina tobinii] diamond 420 123 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
20182571 20182571 PRJNA222400_P_NODE_256_length_957_cov_2.461454_g236_i0 PRJNA222400 256 957 2.461454 23.55611478 Chrysotila carterae 13221 Haptophyta other_Eukaryota 193 1.1e-57   NR Q43362.1 13221 g236 i0 72 0.987460815047022 157 44 49.2 0 801 331 8 164 Q43362.1 RecName: Full=V-type proton ATPase 16 kDa proteolipid subunit; Short=V-ATPase 16 kDa proteolipid subunit; AltName: Full=Vacuolar proton pump 16 kDa proteolipid subunit [Chrysotila carterae] diamond 945 193 1 Eukaryota Haptista   Haptophyta   Isochrysidales Isochrysidaceae Chrysotila Chrysotila carterae
24593457 24593457 PRJNA222400_P_NODE_620_length_657_cov_1.909539_g590_i0 PRJNA222400 620 657 1.909539 12.54567123 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 168 1.18e-49   NR XP_005787147.1 280463 g590 i0 72.6 30.9269406392694 113 31 51.6 0 3 341 14 126 XP_005787147.1 hypothetical protein EMIHUDRAFT_460589 [Emiliania huxleyi CCMP1516] diamond 20319 169 0.994082840236686 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27200207 27200207 PRJNA222400_P_NODE_6082_length_182_cov_1.255639_g6049_i0 PRJNA222400 6082 182 1.255639 2.28526298 Prymnesium parvum 97485 Haptophyta other_Eukaryota 52 8.29e-6   NR KAL1522999.1 97485 g6049 i0 41.8 0.906593406593407 55 31 89 1 1 162 236 290 KAL1522999.1 hypothetical protein AB1Y20_017962 [Prymnesium parvum] diamond 165 52 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28639416 28639416 PRJNA222400_P_NODE_5987_length_184_cov_0.896296_g5954_i0 PRJNA222400 5987 184 0.896296 1.64918464 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 42.7 0.0171   NR KAL1503416.1 97485 g5954 i0 78.3 2.3804347826087 23 5 37.5 0 110 178 85 107 KAL1503416.1 hypothetical protein AB1Y20_011467 [Prymnesium parvum] diamond 438 42.7 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
28670904 28670904 PRJNA222400_P_NODE_8447_length_165_cov_0.896552_g8414_i0 PRJNA222400 8447 165 0.896552 1.4793108 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 43.1 0.00827   NR KAL1511950.1 97485 g8414 i0 61 5.30909090909091 41 16 74.5 0 163 41 139 179 KAL1511950.1 hypothetical protein AB1Y20_005230 [Prymnesium parvum] diamond 876 43.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
29491642 29491642 PRJNA222400_P_NODE_6570_length_175_cov_1.555556_g6537_i0 PRJNA222400 6570 175 1.555556 2.722223 Prymnesiales 73028 Haptophyta other_Eukaryota 64.3 3.65e-10   NR KOO21067.1 1460289 g6537 i0 51.8 3.73714285714286 56 27 96 0 169 2 5 60 KOO21067.1 hypothetical protein Ctob_002660 [Chrysochromulina tobinii] diamond 654 64.3 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
29505394 29505394 PRJNA222400_P_NODE_3790_length_230_cov_1.541436_g3757_i0 PRJNA222400 3790 230 1.541436 3.5453028 Prymnesium parvum 97485 Haptophyta other_Eukaryota 53.1 5.97e-6   NR KAL1528863.1 97485 g3757 i0 53.3 0.58695652173913 45 19 57.4 2 219 88 229 272 KAL1528863.1 hypothetical protein AB1Y20_010186 [Prymnesium parvum] diamond 135 53.1 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
30737362 30737362 PRJNA222400_P_NODE_8274_length_165_cov_1.370690_g8241_i0 PRJNA222400 8274 165 1.37069 2.2616385 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 65.5 1.21e-10   NR KOO31667.1 1460289 g8241 i0 65.1 1.65454545454545 43 15 78.2 0 36 164 93 135 KOO31667.1 actin-related protein 2 3 complex subunit 3, partial [Chrysochromulina tobinii] diamond 273 65.5 1 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);;