RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA929522" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 11 ✖

bioproject 1

  • PRJNA929522 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
2529109 2529109 PRJNA929522_S_NODE_4762_length_316_cov_1.814815_g4692_i0 PRJNA929522 4762 316 1.814815 5.7348154 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 106 1.8899999999999998e-24   NR KAG8463530.1 2081491 g4692 i0 81 0.598101265822785 63 12 59.8 0 313 125 406 468 KAG8463530.1 hypothetical protein KFE25_003803 [Diacronema lutheri] diamond 189 106 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
4733779 4733779 PRJNA929522_S_NODE_3284_length_370_cov_0.932660_g3214_i0 PRJNA929522 3284 370 0.93266 3.450842 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 70.5 2.93e-11   NR KOO33925.1 1460289 g3214 i0 64.3 0.340540540540541 42 15 34.1 0 369 244 470 511 KOO33925.1 papain family cysteine protease containing protein [Chrysochromulina tobinii] diamond 126 70.5 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
27341110 27341110 PRJNA929522_S_NODE_8903_length_248_cov_1.320000_g8833_i0 PRJNA929522 8903 248 1.32 3.2736 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 137 1.51e-35   NR XP_005787431.1 280463 g8833 i0 77.8 3.03629032258065 81 18 98 0 2 244 443 523 XP_005787431.1 hypothetical protein EMIHUDRAFT_467500 [Emiliania huxleyi CCMP1516] diamond 753 137 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
27877755 27877755 PRJNA929522_S_NODE_10065_length_241_cov_1.297619_g9995_i0 PRJNA929522 10065 241 1.297619 3.12726179 Emiliania huxleyi CCMP1516 280463 Haptophyta other_Eukaryota 107 7.97e-26   NR XP_005766461.1 280463 g9995 i0 55.7 0.983402489626556 79 35 98.3 0 3 239 91 169 XP_005766461.1 hypothetical protein EMIHUDRAFT_211957 [Emiliania huxleyi CCMP1516] diamond 237 107 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
29204054 29204054 PRJNA929522_S_NODE_10069_length_241_cov_1.267857_g9999_i0 PRJNA929522 10069 241 1.267857 3.05553537 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 65.1 4.74e-10   NR KAG8464174.1 2081491 g9999 i0 42.9 0.871369294605809 70 40 87.1 0 215 6 375 444 KAG8464174.1 hypothetical protein KFE25_003237 [Diacronema lutheri] diamond 210 65.1 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
30435927 30435927 PRJNA929522_S_NODE_4893_length_313_cov_1.445833_g4823_i0 PRJNA929522 4893 313 1.445833 4.52545729 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 51.2 8.82e-5   NR KAG8465680.1 2081491 g4823 i0 30.9 0.929712460063898 97 67 93 0 303 13 45 141 KAG8465680.1 hypothetical protein KFE25_002987 [Diacronema lutheri] diamond 291 51.2 1 Eukaryota Haptista   Haptophyta Pavlovophyceae Pavlovales Pavlovaceae Diacronema Diacronema lutheri
31200584 31200584 PRJNA929522_S_NODE_8155_length_255_cov_1.060440_g8085_i0 PRJNA929522 8155 255 1.06044 2.704122 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 109 1.2e-25   NR KOO22476.1 1460289 g8085 i0 61.9 17.8705882352941 84 30 98.8 1 2 253 2372 2453 KOO22476.1 ATP-binding cassette sub-family a member 3 [Chrysochromulina tobinii] diamond 4557 109 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31573657 31573657 PRJNA929522_S_NODE_2736_length_404_cov_1.299094_g2666_i0 PRJNA929522 2736 404 1.299094 5.24833976 Chrysochromulina tobinii 1460289 Haptophyta other_Eukaryota 124 3.05e-30   NR KOO27975.1 1460289 g2666 i0 70.4 2.43564356435644 81 24 60.1 0 37 279 434 514 KOO27975.1 inositol-3-phosphate synthase [Chrysochromulina tobinii] diamond 984 124 1 Eukaryota Haptista   Haptophyta   Prymnesiales Chrysochromulinaceae Chrysochromulina Chrysochromulina tobinii
31928479 31928479 PRJNA929522_S_NODE_6577_length_279_cov_0.956311_g6507_i0 PRJNA929522 6577 279 0.956311 2.66810769 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 130 4.04e-33   NR KAL1498447.1 97485 g6507 i0 62.6 2.05376344086022 91 32 97.8 1 275 3 148 236 KAL1498447.1 hypothetical protein AB1Y20_013772 [Prymnesium parvum] diamond 573 131 0.99236641221374 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32055017 32055017 PRJNA929522_S_NODE_2638_length_412_cov_1.837758_g2568_i0 PRJNA929522 2638 412 1.837758 7.57156296 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 157 9.07e-44   NR KAL1522936.1 97485 g2568 i0 55.1 5.5631067961165 127 57 92.5 0 2 382 120 246 KAL1522936.1 hypothetical protein AB1Y20_017901 [Prymnesium parvum] diamond 2292 157 1 Eukaryota Haptista   Haptophyta   Prymnesiales Prymnesiaceae Prymnesium Prymnesium parvum
32396113 32396113 PRJNA929522_S_NODE_2739_length_403_cov_2.333333_g2669_i0 PRJNA929522 2739 403 2.333333 9.40333199 Diacronema lutheri 2081491 Haptophyta other_Eukaryota 199 7.21e-59   NR KAG8463530.1 2081491 g2669 i0 78.7 1.82382133995037 122 26 90.8 0 371 6 1 122 KAG8463530.1 hypothetical protein KFE25_003803 [Diacronema lutheri] diamond 735 199 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);;