RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 30 ✖

bioproject 1

  • PRJNA994052 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
26678003 26678003 PRJNA994052_P_NODE_41201_length_256_cov_41.016393_g39954_i0 PRJNA994052 41201 256 41.016393 105.00196608 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 85.5 4.5e-19   NR TNV72613.1 5974 g39954 i0 67.7 0.7265625 62 20 72.7 0 255 70 67 128 TNV72613.1 hypothetical protein FGO68_gene17584 [Halteria grandinella] diamond 186 85.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27374496 27374496 PRJNA994052_P_NODE_29443_length_283_cov_40.761905_g28201_i0 PRJNA994052 29443 283 40.761905 115.35619115 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.96e-4   NR XP_004035134.1 5932 g28201 i0 33.8 0.752650176678445 71 46 75.3 1 283 71 85 154 XP_004035134.1 hypothetical protein IMG5_105320 [Ichthyophthirius multifiliis] diamond 213 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27563354 27563354 PRJNA994052_P_NODE_75904_length_205_cov_48.939394_g74648_i0 PRJNA994052 75904 205 48.939394 100.3257577 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 7.17e-4   NR OMJ66661.1 5963 g74648 i0 76 0.365853658536585 25 6 36.6 0 202 128 370 394 OMJ66661.1 hypothetical protein SteCoe_36420 [Stentor coeruleus] diamond 75 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27853627 27853627 PRJNA994052_P_NODE_74244_length_207_cov_45.686567_g72988_i0 PRJNA994052 74244 207 45.686567 94.57119369 Triparma 722752 SAR_Eukaryotes SAR_Eukaryotes 53.1 5.13e-6   NR GMH97591.1 1606542 g72988 i0 50 2.30434782608696 52 26 75.4 0 183 28 741 792 GMH97591.1 hypothetical protein TrVE_jg1599 [Triparma verrucosa] diamond 477 53.1 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma verrucosa
28132112 28132112 PRJNA994052_P_NODE_43445_length_252_cov_26.586592_g42197_i0 PRJNA994052 43445 252 26.586592 66.99821184 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.82e-4   NR KAI2513306.1 210448 g42197 i0 42 1.19047619047619 50 29 59.5 0 2 151 617 666 KAI2513306.1 ubiquitin-specific protease [Fragilaria crotonensis] diamond 300 48.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28232290 28232290 PRJNA994052_P_NODE_9746_length_342_cov_36.200743_g8540_i0 PRJNA994052 9746 342 36.200743 123.80654106 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0213   NR RHY66787.1 112090 g8540 i0 32.4 3.7280701754386 71 46 60.5 1 340 134 246 316 RHY66787.1 hypothetical protein DYB38_005720 [Aphanomyces astaci] diamond 1275 45.1 0.991130820399113 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28384512 28384512 PRJNA994052_P_NODE_40206_length_258_cov_45.021622_g38960_i0 PRJNA994052 40206 258 45.021622 116.15578476 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.97e-4   NR XP_001014479.2 312017 g38960 i0 34.3 0.813953488372093 70 44 81.4 1 218 9 31 98 XP_001014479.2 CRAL TRIO domain protein [Tetrahymena thermophila SB210] diamond 210 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28605571 28605571 PRJNA994052_P_NODE_46307_length_247_cov_34.189655_g45056_i0 PRJNA994052 46307 247 34.189655 84.44844785 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 86.7 5.46e-18   NR OMJ88245.1 5963 g45056 i0 77 0.740890688259109 61 14 74.1 0 242 60 22 82 OMJ88245.1 hypothetical protein SteCoe_9827 [Stentor coeruleus] diamond 183 86.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28611481 28611481 PRJNA994052_P_NODE_69247_length_213_cov_50.314286_g67991_i0 PRJNA994052 69247 213 50.314286 107.16942918 root 1 Root_unresolved Root_unresolved 91.7 1.26e-19   NR CBJ26972.1 2880 g67991 i0 66.7 5.74647887323944 69 23 97.2 0 207 1 122 190 CBJ26972.1 Acetyl-CoA acetyltransferase subunit, putative mitochondrial presursor Acetyl-CoA acetyltransferase [Ectocarpus siliculosus] diamond 1224 92 0.996739130434783 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
28731912 28731912 PRJNA994052_P_NODE_29467_length_283_cov_29.914286_g28225_i0 PRJNA994052 29467 283 29.914286 84.65742938 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 52 1.32e-5   NR KAL3770480.1 2934178 g28225 i0 74.2 0.328621908127208 31 8 32.9 0 201 109 28 58 KAL3770480.1 hypothetical protein ACHAW5_001493 [Stephanodiscus triporus] diamond 93 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28858065 28858065 PRJNA994052_P_NODE_46968_length_246_cov_27.398844_g45717_i0 PRJNA994052 46968 246 27.398844 67.40115624 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.58e-5   NR KRX07603.1 266149 g45717 i0 36.8 0.695121951219512 57 36 69.5 0 231 61 222 278 KRX07603.1 hypothetical protein PPERSA_11152 [Pseudocohnilembus persalinus] diamond 171 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29274330 29274330 PRJNA994052_P_NODE_56489_length_231_cov_27.449367_g55234_i0 PRJNA994052 56489 231 27.449367 63.40803777 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 48.1 3.77e-4   NR KAL3790979.1 382360 g55234 i0 45.2 2.18181818181818 62 21 80.5 2 191 6 41 89 KAL3790979.1 hypothetical protein ACHAWO_000139 [Cyclotella atomus] diamond 504 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29305975 29305975 PRJNA994052_P_NODE_58189_length_228_cov_273.703226_g56933_i0 PRJNA994052 58189 228 273.703226 624.04335528 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.1 8.35e-4   NR EJK58441.1 159749 g56933 i0 73.1 0.697368421052632 26 7 34.2 0 2 79 7 32 EJK58441.1 hypothetical protein THAOC_21443 [Thalassiosira oceanica] diamond 159 45.4 0.993392070484582 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29305977 29305977 PRJNA994052_P_NODE_70989_length_211_cov_30.028986_g69733_i0 PRJNA994052 70989 211 30.028986 63.36116046 Triparma 722752 SAR_Eukaryotes SAR_Eukaryotes 58.9 3.32e-8   NR GMI32528.1 722753 g69733 i0 53.3 2.38862559241706 45 21 64 0 13 147 212 256 GMI32528.1 hypothetical protein TrCOL_g3269 [Triparma columacea] diamond 504 58.9 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma columacea
29647121 29647121 PRJNA994052_P_NODE_40650_length_257_cov_56.989130_g39403_i0 PRJNA994052 40650 257 56.98913 146.4620641 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 96.7 4.77e-21   NR GFH43592.1 426638 g39403 i0 88.7 0.618677042801556 53 6 61.9 0 255 97 658 710 GFH43592.1 transketolase [Chaetoceros tenuissimus] diamond 159 96.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29710301 29710301 PRJNA994052_P_NODE_62630_length_222_cov_26.879195_g61374_i0 PRJNA994052 62630 222 26.879195 59.6718129 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.52e-4   NR CDW73613.1 5949 g61374 i0 54.1 0.5 37 17 50 0 32 142 73 109 CDW73613.1 UNKNOWN [Stylonychia lemnae] diamond 111 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29747830 29747830 PRJNA994052_P_NODE_64730_length_219_cov_41.472603_g63474_i0 PRJNA994052 64730 219 41.472603 90.82500057 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.17e-16   NR TMW60418.1 41045 g63474 i0 66.2 22.7123287671233 68 23 93.2 0 4 207 165 232 TMW60418.1 hypothetical protein Poli38472_000460 [Pythium oligandrum] diamond 4974 83.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
29931908 29931908 PRJNA994052_P_NODE_43971_length_251_cov_31.028090_g42723_i0 PRJNA994052 43971 251 31.02809 77.8805059 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.42e-9   NR XP_001433059.1 5888 g42723 i0 50 1.19521912350598 50 25 59.8 0 227 78 301 350 XP_001433059.1 uncharacterized protein GSPATT00035142001 [Paramecium tetraurelia] diamond 300 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30158493 30158493 PRJNA994052_P_NODE_78612_length_202_cov_33.930233_g77355_i0 PRJNA994052 78612 202 33.930233 68.53907066 root 1 Root_unresolved Root_unresolved 46.2 9.66e-4   NR KAA0151673.1 33653 g77355 i0 49.1 3.19306930693069 55 28 81.7 0 4 168 27 81 KAA0151673.1 hypothetical protein FNF29_04359 [Cafeteria roenbergensis] diamond 645 46.6 0.991416309012876 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
30184407 30184407 PRJNA994052_P_NODE_21232_length_306_cov_26.776824_g20005_i0 PRJNA994052 21232 306 26.776824 81.93708144 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 76.6 5.54e-15   NR KAJ1402601.1 483371 g20005 i0 68 1.96078431372549 50 16 49 0 1 150 78 127 KAJ1402601.1 hypothetical protein B484DRAFT_231852 [Ochromonadaceae sp. CCMP2298] diamond 600 76.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30247893 30247893 PRJNA994052_P_NODE_40692_length_257_cov_41.864130_g39445_i0 PRJNA994052 40692 257 41.86413 107.5908141 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 124 6.089999999999999e-31   NR CDW80051.1 5949 g39445 i0 73.7 0.88715953307393 76 20 88.7 0 247 20 517 592 CDW80051.1 abc transporter b family protein [Stylonychia lemnae] diamond 228 124 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30632520 30632520 PRJNA994052_P_NODE_79273_length_201_cov_84.039062_g78016_i0 PRJNA994052 79273 201 84.039062 168.91851462 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 66.6 3.17e-12   NR XP_004035748.1 5932 g78016 i0 68.8 1.43283582089552 48 15 71.6 0 196 53 64 111 XP_004035748.1 hypothetical protein IMG5_091110 [Ichthyophthirius multifiliis] diamond 288 66.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30911300 30911300 PRJNA994052_P_NODE_45394_length_249_cov_1.772727_g44144_i0 PRJNA994052 45394 249 1.772727 4.41409023 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 47 0.00132   NR DAZ99415.1 4803 g44144 i0 38.2 1.69879518072289 68 39 81.9 1 41 244 4962 5026 DAZ99415.1 TPA: hypothetical protein N0F65_004048 [Lagenidium giganteum] diamond 423 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
31106488 31106488 PRJNA994052_P_NODE_6815_length_379_cov_10.826797_g5745_i0 PRJNA994052 6815 379 10.826797 41.03356063 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77.4 4.41e-15   NR CAI5726576.1 162125 g5745 i0 58.6 3.56200527704485 58 24 45.9 0 377 204 50 107 CAI5726576.1 unnamed protein product [Hyaloperonospora brassicae] diamond 1350 77.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
31258781 31258781 PRJNA994052_P_NODE_61135_length_224_cov_40.986755_g59879_i0 PRJNA994052 61135 224 40.986755 91.8103312 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 62.8 7.64e-10   NR GAX14273.1 1519565 g59879 i0 73.5 1.3125 49 13 65.6 0 221 75 153 201 GAX14273.1 large subunit ribosomal protein L13Ae [Fistulifera solaris] diamond 294 62.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31512017 31512017 PRJNA994052_P_NODE_67936_length_215_cov_21.471831_g66680_i0 PRJNA994052 67936 215 21.471831 46.16443665 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 59.3 3.33e-8   NR KAL3794969.1 382360 g66680 i0 90 0.418604651162791 30 3 41.9 0 213 124 303 332 KAL3794969.1 hypothetical protein ACHAWO_009928 [Cyclotella atomus] diamond 90 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31733091 31733091 PRJNA994052_P_NODE_6857_length_378_cov_35.750820_g5785_i0 PRJNA994052 6857 378 35.75082 135.1380996 Gregarina niphandrodes 110365 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.02e-19   NR XP_011134384.1 110365 g5785 i0 43.7 0.69047619047619 87 28 52.4 1 8 205 158 244 XP_011134384.1 putative PWI domain protein [Gregarina niphandrodes] diamond 261 91.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eugregarinorida Gregarinidae Gregarina Gregarina niphandrodes
32049522 32049522 PRJNA994052_P_NODE_64778_length_219_cov_33.821918_g63522_i0 PRJNA994052 64778 219 33.821918 74.07000042 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 42 0.0322   NR CAI5729742.1 86335 g63522 i0 42.3 0.712328767123288 52 23 67.1 2 216 70 115 162 CAI5729742.1 unnamed protein product [Peronospora destructor] diamond 156 42 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
32081171 32081171 PRJNA994052_P_NODE_59498_length_227_cov_6.512987_g58242_i0 PRJNA994052 59498 227 6.512987 14.78448049 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00249   NR CAI2386419.1 5936 g58242 i0 39.7 0.766519823788546 58 34 76.7 1 175 2 236 292 CAI2386419.1 unnamed protein product [Moneuplotes crassus] diamond 174 45.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32366201 32366201 PRJNA994052_P_NODE_19659_length_309_cov_73.182203_g18436_i0 PRJNA994052 19659 309 73.182203 226.13300727 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 67 1.08e-10   NR KAK7230984.1 44056 g18436 i0 43.7 4.22330097087379 87 49 84.5 0 12 272 169 255 KAK7230984.1 guanine nucleotide exchange factor [Aureococcus anophagefferens] diamond 1305 67 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens

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