RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA358490" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 32 ✖

bioproject 1

  • PRJNA358490 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
4226187 4226187 PRJNA358490_P_NODE_1724_length_1061_cov_8.590020_g1596_i0 PRJNA358490 1724 1061 8.59002 91.1401122 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 436 5.8e-150   NR CAE7382485.1 2951 g1596 i0 77 1.54948162111216 274 62 77.5 1 1040 219 62 334 CAE7382485.1 rpl3, partial [Symbiodinium microadriaticum] diamond 1644 436 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
26599743 26599743 PRJNA358490_P_NODE_13501_length_209_cov_0.947059_g13157_i0 PRJNA358490 13501 209 0.947059 1.97935331 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.54e-7   NR XP_001011163.2 312017 g13157 i0 73.7 0.545454545454545 38 9 53.1 1 209 99 318 355 XP_001011163.2 zinc-binding dehydrogenase family oxidoreductase [Tetrahymena thermophila SB210] diamond 114 57.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26758238 26758238 PRJNA358490_P_NODE_9861_length_339_cov_5.970000_g9519_i0 PRJNA358490 9861 339 5.97 20.2383 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 55.1 5.31e-6   NR KAL4470289.1 5901 g9519 i0 65.7 0.619469026548673 35 12 31 0 25 129 515 549 KAL4470289.1 hypothetical protein ABPG74_011900 [Tetrahymena malaccensis] diamond 210 55.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27043256 27043256 PRJNA358490_P_NODE_42_length_3051_cov_16.653054_g38_i0 PRJNA358490 42 3051 16.653054 508.08467754 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 379 1.2699999999999997e-106   NR CAE8613047.1 89957 g38 i0 33.6 0.745329400196657 758 469 72.8 13 2244 25 2438 3179 CAE8613047.1 unnamed protein product, partial [Polarella glacialis] diamond 2274 379 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
27201089 27201089 PRJNA358490_P_NODE_16302_length_167_cov_1.562500_g15958_i0 PRJNA358490 16302 167 1.5625 2.609375 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 81.3 1.7e-16   NR XP_001022070.3 312017 g15958 i0 86.8 1.36526946107784 38 5 68.3 0 2 115 288 325 XP_001022070.3 glycoside hydrolase family 18 protein [Tetrahymena thermophila SB210] diamond 228 81.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27612065 27612065 PRJNA358490_P_NODE_6684_length_504_cov_6.296774_g6354_i0 PRJNA358490 6684 504 6.296774 31.73574096 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 57.4 4.36e-6   NR KAL3770804.1 259834 g6354 i0 34.8 0.68452380952381 115 67 64.9 3 32 358 1002 1114 KAL3770804.1 hypothetical protein ACHAWU_006363 [Discostella pseudostelligera] diamond 345 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28148850 28148850 PRJNA358490_P_NODE_2605_length_887_cov_26.981132_g2429_i0 PRJNA358490 2605 887 26.981132 239.32264084 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.5e-4   NR KAG5178752.1 303371 g2429 i0 33.6 0.422773393461105 125 78 42.3 1 272 646 441 560 KAG5178752.1 hypothetical protein JKP88DRAFT_350243 [Tribonema minus] diamond 375 55.5 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
28197268 28197268 PRJNA358490_P_NODE_6846_length_493_cov_11.160793_g6515_i0 PRJNA358490 6846 493 11.160793 55.02270949 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.88e-5   NR TMW59321.1 41045 g6515 i0 32.2 4.87423935091278 115 74 70 2 109 453 624 734 TMW59321.1 hypothetical protein Poli38472_004390 [Pythium oligandrum] diamond 2403 55.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
28274900 28274900 PRJNA358490_P_NODE_17006_length_161_cov_0.877049_g16662_i0 PRJNA358490 17006 161 0.877049 1.41204889 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 73.2 5.25e-14   NR XP_976941.1 312017 g16662 i0 92.3 0.726708074534162 39 3 72.7 0 118 2 150 188 XP_976941.1 proteasome subunit beta type protein [Tetrahymena thermophila SB210] diamond 117 73.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28338208 28338208 PRJNA358490_P_NODE_15626_length_174_cov_1.696296_g15282_i0 PRJNA358490 15626 174 1.696296 2.95155504 Tetraparma gracilis 2962635 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.36e-4   NR GMI27850.1 2962635 g15282 i0 54.1 1.1551724137931 37 15 60.3 1 148 44 53 89 GMI27850.1 hypothetical protein TeGR_g11896 [Tetraparma gracilis] diamond 201 47.8 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Tetraparma Tetraparma gracilis
28338209 28338209 PRJNA358490_P_NODE_17806_length_154_cov_1.773913_g17462_i0 PRJNA358490 17806 154 1.773913 2.73182602 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 47 3.54e-4   NR XP_001024076.2 312017 g17462 i0 79.3 1.12987012987013 29 6 56.5 0 1 87 134 162 XP_001024076.2 RNA recognition motif protein [Tetrahymena thermophila SB210] diamond 174 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28338210 28338210 PRJNA358490_P_NODE_18146_length_152_cov_1.283186_g17802_i0 PRJNA358490 18146 152 1.283186 1.95044272 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00222   NR KAL4440766.1 5901 g17802 i0 84 0.493421052631579 25 4 49.3 0 151 77 301 325 KAL4440766.1 hypothetical protein ABPG74_013747 [Tetrahymena malaccensis] diamond 75 44.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28496162 28496162 PRJNA358490_P_NODE_10547_length_305_cov_3.255639_g10205_i0 PRJNA358490 10547 305 3.255639 9.92969895 Tetraparma gracilis 2962635 SAR_Eukaryotes SAR_Eukaryotes 74.3 4.48e-14   NR GMI35530.1 2962635 g10205 i0 44.2 1.79016393442623 77 43 75.7 0 284 54 92 168 GMI35530.1 hypothetical protein TeGR_g6932 [Tetraparma gracilis] diamond 546 74.3 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Tetraparma Tetraparma gracilis
28843171 28843171 PRJNA358490_P_NODE_15028_length_182_cov_1.713287_g14684_i0 PRJNA358490 15028 182 1.713287 3.11818234 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 67 4.52e-11   NR KAL4454299.1 5901 g14684 i0 79.5 1.28571428571429 39 8 64.3 0 21 137 581 619 KAL4454299.1 hypothetical protein ABPG74_012256 [Tetrahymena malaccensis] diamond 234 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29001614 29001614 PRJNA358490_P_NODE_18448_length_150_cov_1.477477_g18104_i0 PRJNA358490 18448 150 1.477477 2.2162155 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 71.2 6.12e-13   NR XP_012653036.1 312017 g18104 i0 69.4 0.98 49 15 98 0 2 148 213 261 XP_012653036.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 147 71.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29018625 29018625 PRJNA358490_P_NODE_6528_length_513_cov_3.740506_g6200_i0 PRJNA358490 6528 513 3.740506 19.18879578 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 120 7.5e-28   NR KAL4434517.1 5901 g6200 i0 54 1.43859649122807 126 58 73.7 0 465 88 1 126 KAL4434517.1 hypothetical protein ABPG74_007301 [Tetrahymena malaccensis] diamond 738 120 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29033013 29033013 PRJNA358490_P_NODE_5248_length_597_cov_11.186380_g4957_i0 PRJNA358490 5248 597 11.18638 66.7826886 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 234 2.19e-71   NR KAG5184554.1 303371 g4957 i0 66.5 0.899497487437186 179 53 86.4 3 22 537 295 473 KAG5184554.1 endoplasmic reticulum vesicle transporter-domain-containing protein [Tribonema minus] diamond 537 234 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
29176387 29176387 PRJNA358490_P_NODE_9_length_3899_cov_5.781088_g7_i0 PRJNA358490 9 3899 5.781088 225.40462112 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 449 3.08e-131   NR KAL4441904.1 5901 g7 i0 59.9 1.13952295460374 464 169 35 2 97 1461 22 477 KAL4441904.1 hypothetical protein ABPG74_003655 [Tetrahymena malaccensis] diamond 4443 449 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29190778 29190778 PRJNA358490_P_NODE_14349_length_192_cov_2.503268_g14005_i0 PRJNA358490 14349 192 2.503268 4.80627456 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.81e-18   NR XP_001033223.2 312017 g14005 i0 76.8 0.875 56 13 87.5 0 23 190 600 655 XP_001033223.2 eukaryotic translation initiation factor 3 subunit B, putative [Tetrahymena thermophila SB210] diamond 168 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29253556 29253556 PRJNA358490_P_NODE_1109_length_1247_cov_5.080298_g1025_i0 PRJNA358490 1109 1247 5.080298 63.35131606 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 148 9.49e-39   NR KAL4502306.1 2486642 g1025 i0 81.6 0.209302325581395 87 16 20.9 0 838 578 89 175 KAL4502306.1 hypothetical protein ABPG72_011893 [Tetrahymena utriculariae] diamond 261 148 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
29727136 29727136 PRJNA358490_P_NODE_7290_length_469_cov_5.411628_g6956_i0 PRJNA358490 7290 469 5.411628 25.38053532 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 99.4 3.46e-21   NR KRX05667.1 266149 g6956 i0 83.9 0.358208955223881 56 9 35.8 0 449 282 360 415 KRX05667.1 Pyridoxal phosphate-dependent transferase [Pseudocohnilembus persalinus] diamond 168 99.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29807575 29807575 PRJNA358490_P_NODE_4971_length_620_cov_3.745267_g4696_i0 PRJNA358490 4971 620 3.745267 23.2206554 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 190 1.27e-53   NR KAF1787781.1 29920 g4696 i0 56.4 14.7241935483871 179 72 85.6 2 6 536 379 553 KAF1787781.1 Transglutaminase elicitor [Phytophthora cactorum] diamond 9129 191 0.994764397905759 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
29807577 29807577 PRJNA358490_P_NODE_8231_length_424_cov_5.667532_g7890_i0 PRJNA358490 8231 424 5.667532 24.03033568 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47 0.00822   NR CAE7641857.1 2952 g7890 i0 42.5 1.76179245283019 73 31 46 5 23 217 574 643 CAE7641857.1 plbB [Symbiodinium pilosum] diamond 747 47.4 0.991561181434599 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium pilosum
29948542 29948542 PRJNA358490_P_NODE_18531_length_150_cov_1.090090_g18187_i0 PRJNA358490 18531 150 1.09009 1.635135 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 99.4 1.5099999999999998e-23   NR KAL4438788.1 5901 g18187 i0 95.9 2.94 49 2 98 0 149 3 137 185 KAL4438788.1 hypothetical protein ABPG74_013461 [Tetrahymena malaccensis] diamond 441 99.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30074709 30074709 PRJNA358490_P_NODE_7352_length_466_cov_3.789227_g7018_i0 PRJNA358490 7352 466 3.789227 17.65779782 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 110 1.6600000000000002e-26   NR KAG5177868.1 303371 g7018 i0 83.1 1.21673819742489 59 10 38 0 21 197 177 235 KAG5177868.1 light harvesting complex protein [Tribonema minus] diamond 567 110 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
30328142 30328142 PRJNA358490_P_NODE_5052_length_612_cov_20.218150_g4772_i0 PRJNA358490 5052 612 20.21815 123.735078 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 205 2.5500000000000003e-64   NR CAD8150344.1 43138 g4772 i0 73.5 0.666666666666667 136 36 66.7 0 552 145 1 136 CAD8150344.1 unnamed protein product [Paramecium pentaurelia] diamond 408 205 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
31275519 31275519 PRJNA358490_P_NODE_9215_length_375_cov_1.616071_g8874_i0 PRJNA358490 9215 375 1.616071 6.06026625 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 170 2.9799999999999998e-46   NR XP_001009172.1 312017 g8874 i0 81.5 0.864 108 20 86.4 0 4 327 881 988 XP_001009172.1 hypothetical protein TTHERM_00550810 [Tetrahymena thermophila SB210] diamond 324 170 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31338746 31338746 PRJNA358490_P_NODE_17956_length_153_cov_1.429825_g17612_i0 PRJNA358490 17956 153 1.429825 2.18763225 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.2e-21   NR XP_001027141.1 312017 g17612 i0 80 0.980392156862745 50 10 98 0 151 2 55 104 XP_001027141.1 Mpv17/PMP22 family protein [Tetrahymena thermophila SB210] diamond 150 91.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31654950 31654950 PRJNA358490_P_NODE_557_length_1580_cov_5.440623_g507_i0 PRJNA358490 557 1580 5.440623 85.9618434 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 141 3.11e-31   NR CAK0882875.1 89957 g507 i0 40.9 0.408227848101266 215 116 38.9 5 778 164 845 1058 CAK0882875.1 unnamed protein product [Polarella glacialis] diamond 645 141 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
32305309 32305309 PRJNA358490_P_NODE_15299_length_178_cov_2.705036_g14955_i0 PRJNA358490 15299 178 2.705036 4.81496408 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.5e-9   NR KAI2500166.1 210448 g14955 i0 57.1 6.70786516853933 49 20 82.6 1 3 149 29 76 KAI2500166.1 hypothetical protein MHU86_14310 [Fragilaria crotonensis] diamond 1194 58.9 0.99320882852292 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32509636 32509636 PRJNA358490_P_NODE_799_length_1409_cov_7.265693_g731_i0 PRJNA358490 799 1409 7.265693 102.37361437 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 60.1 1e-5   NR CAJ1957534.1 2856 g731 i0 37.8 0.174591909155429 82 41 17.5 2 385 140 80 151 CAJ1957534.1 unnamed protein product [Cylindrotheca closterium] diamond 246 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32698422 32698422 PRJNA358490_P_NODE_9080_length_382_cov_3.320700_g8739_i0 PRJNA358490 9080 382 3.3207 12.685074 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.85e-20   NR XP_001014580.2 312017 g8739 i0 88.5 0.408376963350785 52 6 40.8 0 363 208 436 487 XP_001014580.2 dihydrolipoyl dehydrogenase [Tetrahymena thermophila SB210] diamond 156 96.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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