RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA680334" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA680334 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
5754316 5754316 PRJNA680334_S_NODE_99305_length_154_cov_1.727273_g98819_i0 PRJNA680334 99305 154 1.727273 2.66000042 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 83.2 6.2e-17   NR XP_001007782.2 312017 g98819 i0 92.3 1.51948051948052 39 3 76 0 8 124 103 141 XP_001007782.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 234 83.6 0.995215311004785 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26923809 26923809 PRJNA680334_S_NODE_24862_length_238_cov_2.839024_g24376_i0 PRJNA680334 24862 238 2.839024 6.75687712 Cryptosporidium hominis TU5 237895 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.44e-9   NR XP_666617.1 353151 g24376 i0 41.7 1.81512605042017 72 41 90.8 1 223 8 214 284 XP_666617.1 ARF GAP-like zinc finger-containing protein (ZIGA2) [Cryptosporidium hominis TU502] diamond 432 63.5 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium hominis
27239911 27239911 PRJNA680334_S_NODE_33743_length_217_cov_1.717391_g33257_i0 PRJNA680334 33743 217 1.717391 3.72673847 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 79.3 2.14e-16   NR GKY99837.1 2872254 g33257 i0 60.6 0.981566820276498 71 25 98.2 2 213 1 16 83 GKY99837.1 hypothetical protein MPSEU_000937500 [Mayamaea pseudoterrestris] diamond 213 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27650739 27650739 PRJNA680334_S_NODE_61804_length_179_cov_4.561644_g61318_i0 PRJNA680334 61804 179 4.561644 8.16534276 Vaucheria litorea 109269 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.01e-19   NR YP_002327507.1 109269 g61318 i0 72.9 2.96648044692737 59 16 98.9 0 3 179 92 150 YP_002327507.1 ribosomal protein S7 [Vaucheria litorea] diamond 531 86.7 1 Eukaryota Sar     Xanthophyceae Vaucheriales Vaucheriaceae Vaucheria Vaucheria litorea
27682532 27682532 PRJNA680334_S_NODE_46044_length_197_cov_1.926829_g45558_i0 PRJNA680334 46044 197 1.926829 3.79585313 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0198   NR CAD8171430.1 43138 g45558 i0 45.7 1.4010152284264 46 24 70.1 1 194 57 135 179 CAD8171430.1 unnamed protein product [Paramecium pentaurelia] diamond 276 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
27871587 27871587 PRJNA680334_S_NODE_75765_length_168_cov_2.185185_g75279_i0 PRJNA680334 75765 168 2.185185 3.6711108 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.68e-15   NR XP_001031668.1 312017 g75279 i0 55.6 0.964285714285714 54 24 96.4 0 1 162 381 434 XP_001031668.1 platelet-activating factor acetylhydrolase Ib subunit alpha, putative [Tetrahymena thermophila SB210] diamond 162 79.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28029603 28029603 PRJNA680334_S_NODE_41145_length_204_cov_1.970760_g40659_i0 PRJNA680334 41145 204 1.97076 4.0203504 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 51.2 7.18e-6   NR CAG9334277.1 1481888 g40659 i0 40.9 0.970588235294118 66 38 95.6 1 7 201 56 121 CAG9334277.1 unnamed protein product [Blepharisma stoltei] diamond 198 51.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
28167678 28167678 PRJNA680334_S_NODE_86565_length_161_cov_1.828125_g86079_i0 PRJNA680334 86565 161 1.828125 2.94328125 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.12e-4   NR KAG5177604.1 303371 g86079 i0 43.4 2.73913043478261 53 30 98.8 0 1 159 1320 1372 KAG5177604.1 hypothetical protein JKP88DRAFT_332224 [Tribonema minus] diamond 441 48.5 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
28609637 28609637 PRJNA680334_S_NODE_107807_length_150_cov_1.692308_g107321_i0 PRJNA680334 107807 150 1.692308 2.538462 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 80.5 5.03e-16   NR XP_001007782.2 312017 g107321 i0 100 1.36 34 0 68 0 15 116 221 254 XP_001007782.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 204 80.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29134820 29134820 PRJNA680334_S_NODE_47889_length_194_cov_4.658385_g47403_i0 PRJNA680334 47889 194 4.658385 9.0372669 Amoebophrya sp. A25 1410381 SAR_Eukaryotes SAR_Eukaryotes 74.7 3.54e-14   NR CAD7970184.1 1410381 g47403 i0 66.7 7.53092783505155 51 17 78.9 0 3 155 210 260 CAD7970184.1 unnamed protein product [Amoebophrya sp. A25] diamond 1461 74.7 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A25
29418615 29418615 PRJNA680334_S_NODE_57109_length_184_cov_2.205298_g56623_i0 PRJNA680334 57109 184 2.205298 4.05774832 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 57 1.52e-7   NR CDW78518.1 5949 g56623 i0 72.7 0.53804347826087 33 9 53.8 0 170 72 511 543 CDW78518.1 cathepsin c [Stylonychia lemnae] diamond 99 57 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29734207 29734207 PRJNA680334_S_NODE_49850_length_192_cov_2.748428_g49364_i0 PRJNA680334 49850 192 2.748428 5.27698176 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.76e-5   NR GKY95538.1 2872254 g49364 i0 48.3 0.9375 60 31 93.8 0 188 9 236 295 GKY95538.1 hypothetical protein MPSEU_000515400 [Mayamaea pseudoterrestris] diamond 180 51.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29765929 29765929 PRJNA680334_S_NODE_72591_length_170_cov_3.722628_g72105_i0 PRJNA680334 72591 170 3.722628 6.3284676 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 78.2 4.46e-15   NR KAG5185655.1 303371 g72105 i0 70.8 1.69411764705882 48 14 84.7 0 144 1 775 822 KAG5185655.1 hypothetical protein JKP88DRAFT_311408 [Tribonema minus] diamond 288 78.2 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
29860800 29860800 PRJNA680334_S_NODE_63931_length_177_cov_4.986111_g63445_i0 PRJNA680334 63931 177 4.986111 8.82541647 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 66.6 5.65e-11   NR XP_001007782.2 312017 g63445 i0 85.7 1.1864406779661 35 5 59.3 0 113 9 185 219 XP_001007782.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 210 66.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30745453 30745453 PRJNA680334_S_NODE_22934_length_244_cov_2.336493_g22448_i0 PRJNA680334 22934 244 2.336493 5.70104292 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00148   NR KAG5177524.1 303371 g22448 i0 59 0.479508196721311 39 16 48 0 242 126 97 135 KAG5177524.1 ribosomal protein L14-domain-containing protein [Tribonema minus] diamond 117 45.4 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
31262809 31262809 PRJNA680334_S_NODE_57815_length_183_cov_3.453333_g57329_i0 PRJNA680334 57815 183 3.453333 6.31959939 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 75.1 6.23e-14   NR KAK1742141.1 267567 g57329 i0 82.9 6.55737704918033 41 7 67.2 0 2 124 425 465 KAK1742141.1 UDP-glucose 6-dehydrogenase [Skeletonema marinoi] diamond 1200 75.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32484983 32484983 PRJNA680334_S_NODE_83159_length_163_cov_2.184615_g82673_i0 PRJNA680334 83159 163 2.184615 3.56092245 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00177   NR CEO99151.1 37360 g82673 i0 100 1.56441717791411 22 0 40.5 0 1 66 125 146 CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae] diamond 255 44.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32863025 32863025 PRJNA680334_S_NODE_38020_length_209_cov_2.187500_g37534_i0 PRJNA680334 38020 209 2.1875 4.571875 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.67e-10   NR ETO07126.1 46433 g37534 i0 50.9 1.66507177033493 53 25 74.6 1 2 157 126 178 ETO07126.1 glutathione peroxidase [Reticulomyxa filosa] diamond 348 63.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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