RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 26 ✖

bioproject 1

  • PRJNA716463 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
5811696 5811696 PRJNA716463_P_NODE_52305_length_289_cov_1.810185_g51888_i0 PRJNA716463 52305 289 1.810185 5.23143465 Cafeteria roenbergensis 33653 SAR_Eukaryotes SAR_Eukaryotes 111 3e-27   NR KAA0161520.1 33653 g51888 i0 56.1 3.77854671280277 98 40 98.6 2 3 287 57 154 KAA0161520.1 hypothetical protein FNF31_03803 [Cafeteria roenbergensis] diamond 1092 111 1 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
10912150 10912150 PRJNA716463_P_NODE_51969_length_289_cov_2.199074_g51552_i0 PRJNA716463 51969 289 2.199074 6.35532386 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 116 1.53e-29   NR XP_001450897.1 5888 g51552 i0 53.1 2.94809688581315 96 45 99.7 0 288 1 100 195 XP_001450897.1 uncharacterized protein GSPATT00017829001 [Paramecium tetraurelia] diamond 852 117 0.991452991452991 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
16011216 16011216 PRJNA716463_P_NODE_87293_length_262_cov_4.000000_g86876_i0 PRJNA716463 87293 262 4 10.48 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 92 2.09e-20   NR KAJ1393893.1 483371 g86876 i0 49.4 0.99618320610687 87 44 99.6 0 2 262 164 250 KAJ1393893.1 hypothetical protein B484DRAFT_459246 [Ochromonadaceae sp. CCMP2298] diamond 261 92 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
17770847 17770847 PRJNA716463_P_NODE_82054_length_267_cov_1.587629_g81637_i0 PRJNA716463 82054 267 1.587629 4.23896943 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 159 6.029999999999999e-45   NR KAJ1429644.1 483371 g81637 i0 87.5 2.96629213483146 88 11 98.9 0 2 265 32 119 KAJ1429644.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 792 159 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
24933676 24933676 PRJNA716463_P_NODE_102200_length_249_cov_3.073864_g101783_i0 PRJNA716463 102200 249 3.073864 7.65392136 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 135 5.22e-38   NR XP_004034912.1 5932 g101783 i0 73.2 3.92771084337349 82 22 98.8 0 246 1 28 109 XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis] diamond 978 135 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26703617 26703617 PRJNA716463_P_NODE_65121_length_280_cov_1.487923_g64704_i0 PRJNA716463 65121 280 1.487923 4.1661844 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 114 2.3400000000000003e-27   NR XP_001428259.1 5888 g64704 i0 69.8 0.921428571428571 86 26 92.1 0 21 278 485 570 XP_001428259.1 uncharacterized protein GSPATT00031090001 [Paramecium tetraurelia] diamond 258 114 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
26767151 26767151 PRJNA716463_P_NODE_24341_length_310_cov_3.054852_g23924_i0 PRJNA716463 24341 310 3.054852 9.4700412 Triparma retinervis 2557542 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.26e-10   NR GMH74996.1 2557542 g23924 i0 55.1 0.474193548387097 49 22 47.4 0 162 308 42 90 GMH74996.1 hypothetical protein TrRE_jg1396 [Triparma retinervis] diamond 147 64.3 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma retinervis
27115042 27115042 PRJNA716463_P_NODE_68482_length_277_cov_2.916667_g68065_i0 PRJNA716463 68482 277 2.916667 8.07916759 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 79.3 3.61e-15   NR XP_004030170.1 5932 g68065 i0 59.4 0.747292418772563 69 25 74.7 2 214 8 1 66 XP_004030170.1 hypothetical protein IMG5_166540 [Ichthyophthirius multifiliis] diamond 207 79.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27652420 27652420 PRJNA716463_P_NODE_16784_length_310_cov_5.793249_g16367_i0 PRJNA716463 16784 310 5.793249 17.9590719 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 60.1 6.5e-8   NR XP_001450650.1 5888 g16367 i0 71.7 1.78064516129032 46 13 44.5 0 298 161 444 489 XP_001450650.1 uncharacterized protein GSPATT00017597001 [Paramecium tetraurelia] diamond 552 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28010309 28010309 PRJNA716463_P_NODE_53825_length_288_cov_1.823256_g53408_i0 PRJNA716463 53825 288 1.823256 5.25097728 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 101 1.2800000000000001e-22   NR KRX07259.1 266149 g53408 i0 52.1 1.95833333333333 94 45 97.9 0 287 6 654 747 KRX07259.1 hypothetical protein PPERSA_00416 [Pseudocohnilembus persalinus] diamond 564 102 0.990196078431373 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28315410 28315410 PRJNA716463_P_NODE_68626_length_277_cov_2.617647_g68209_i0 PRJNA716463 68626 277 2.617647 7.25088219 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.18e-5   NR CAI2369314.1 5936 g68209 i0 33 2.04693140794224 97 58 97.5 3 7 276 32 128 CAI2369314.1 unnamed protein product [Moneuplotes crassus] diamond 567 53.1 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28725793 28725793 PRJNA716463_P_NODE_83067_length_266_cov_2.113990_g82650_i0 PRJNA716463 83067 266 2.11399 5.6232134 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.43e-15   NR KRX03681.1 266149 g82650 i0 67.3 1.29699248120301 55 18 62 0 3 167 135 189 KRX03681.1 hypothetical protein PPERSA_10365 [Pseudocohnilembus persalinus] diamond 345 78.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29073302 29073302 PRJNA716463_P_NODE_76468_length_271_cov_2.636364_g76051_i0 PRJNA716463 76468 271 2.636364 7.14454644 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.5 4.76e-4   NR XP_001010207.2 312017 g76051 i0 34.5 0.929889298892989 84 50 88.6 2 1 240 120 202 XP_001010207.2 eukaryotic aspartyl protease [Tetrahymena thermophila SB210] diamond 252 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29104823 29104823 PRJNA716463_P_NODE_44228_length_295_cov_4.157658_g43811_i0 PRJNA716463 44228 295 4.157658 12.2650911 Phytophthora nicotianae CJ 4792 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0468   NR ETP13120.1 1317063 g43811 i0 36.2 0.589830508474576 58 32 59 2 74 247 61 113 ETP13120.1 hypothetical protein F441_11617 [Phytophthora nicotianae CJ01A1] diamond 174 42.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
29483319 29483319 PRJNA716463_P_NODE_25810_length_310_cov_2.907173_g25393_i0 PRJNA716463 25810 310 2.907173 9.0122363 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 99.4 4.03e-24   NR KAJ1440811.1 483371 g25393 i0 56.7 0.938709677419355 97 28 80.3 1 60 308 1 97 KAJ1440811.1 Mss4-like protein [Ochromonadaceae sp. CCMP2298] diamond 291 99.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30093930 30093930 PRJNA716463_P_NODE_106072_length_246_cov_2.208092_g105654_i0 PRJNA716463 106072 246 2.208092 5.43190632 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 82.4 4.22e-16   NR XP_001431029.1 5888 g105654 i0 52.6 2.85365853658537 78 35 95.1 1 244 11 1888 1963 XP_001431029.1 uncharacterized protein GSPATT00033484001 [Paramecium tetraurelia] diamond 702 82.8 0.995169082125604 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30115117 30115117 PRJNA716463_P_NODE_49052_length_291_cov_2.559633_g48635_i0 PRJNA716463 49052 291 2.559633 7.44853203 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 68.9 4.09e-11   NR KAL4479034.1 5901 g48635 i0 64 3.08247422680412 50 18 51.5 0 290 141 915 964 KAL4479034.1 hypothetical protein ABPG73_022152 [Tetrahymena malaccensis] diamond 897 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30378865 30378865 PRJNA716463_P_NODE_89252_length_261_cov_1.638298_g88835_i0 PRJNA716463 89252 261 1.638298 4.27595778 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 92.8 1.14e-19   NR OEH77646.1 88456 g88835 i0 46 14.5747126436782 100 39 97.7 1 256 2 831 930 OEH77646.1 valyl-tRNA synthetase [Cyclospora cayetanensis] diamond 3804 93.6 0.991452991452991 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
30410438 30410438 PRJNA716463_P_NODE_38993_length_298_cov_7.924444_g38576_i0 PRJNA716463 38993 298 7.924444 23.61484312 Symbiodinium 2949 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.42e-12   NR CAE7694761.1 631055 g38576 i0 28.6 7.3993288590604 147 56 98.7 2 296 3 494 640 CAE7694761.1 unnamed protein product [Symbiodinium sp. CCMP2592] diamond 2205 73.2 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2592
30694404 30694404 PRJNA716463_P_NODE_67773_length_278_cov_1.682927_g67356_i0 PRJNA716463 67773 278 1.682927 4.67853706 Chrysophaeum 2483199 SAR_Eukaryotes SAR_Eukaryotes 93.6 3.64e-21   NR KAJ1462834.1 483370 g67356 i0 50 4.25179856115108 98 41 98.2 3 2 274 118 214 KAJ1462834.1 RlpA-like double-psi beta-barrel-protein domain-containing protein-containing protein, partial [Pelagophyceae sp. CCMP2097] diamond 1182 94 0.995744680851064 Eukaryota Sar     Pelagophyceae       Pelagophyceae sp. CCMP2097
31125907 31125907 PRJNA716463_P_NODE_88655_length_261_cov_2.973404_g88238_i0 PRJNA716463 88655 261 2.973404 7.76058444 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0352   NR CAK0828905.1 89957 g88238 i0 35.3 0.781609195402299 68 33 65.5 2 246 76 110 177 CAK0828905.1 unnamed protein product, partial [Polarella glacialis] diamond 204 43.1 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
31600761 31600761 PRJNA716463_P_NODE_101276_length_250_cov_2.276836_g100859_i0 PRJNA716463 101276 250 2.276836 5.69209 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 59.7 3.94e-8   NR KAJ1414914.1 483371 g100859 i0 84.4 0.384 32 5 38.4 0 249 154 311 342 KAJ1414914.1 hypothetical protein B484DRAFT_454707, partial [Ochromonadaceae sp. CCMP2298] diamond 96 59.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31600804 31600804 PRJNA716463_P_NODE_92756_length_258_cov_1.664865_g92339_i0 PRJNA716463 92756 258 1.664865 4.2953517 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.95e-20   NR CAD8165381.1 43137 g92339 i0 63.6 0.767441860465116 66 24 76.7 0 256 59 94 159 CAD8165381.1 unnamed protein product [Paramecium octaurelia] diamond 198 89.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31726993 31726993 PRJNA716463_P_NODE_101757_length_250_cov_0.870056_g101340_i0 PRJNA716463 101757 250 0.870056 2.17514 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 70.5 3.66e-12   NR KAL4469075.1 2486642 g101340 i0 37.2 2.064 86 51 99.6 1 250 2 95 180 KAL4469075.1 hypothetical protein ABPG72_007754 [Tetrahymena utriculariae] diamond 516 70.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
32328594 32328594 PRJNA716463_P_NODE_10679_length_361_cov_2.600694_g10265_i0 PRJNA716463 10679 361 2.600694 9.38850534 Chrysophaeum taylorii 2483200 SAR_Eukaryotes SAR_Eukaryotes 163 3.0799999999999996e-48   NR KAJ8601062.1 2483200 g10265 i0 72.6 10.3047091412742 113 31 93.9 0 21 359 1 113 KAJ8601062.1 hypothetical protein CTAYLR_004495 [Chrysophaeum taylorii] diamond 3720 163 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Chrysophaeum Chrysophaeum taylorii
32360200 32360200 PRJNA716463_P_NODE_64739_length_280_cov_2.333333_g64322_i0 PRJNA716463 64739 280 2.333333 6.5333324 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 86.7 2.93e-19   NR CAD8050189.1 65129 g64322 i0 77.6 1.08214285714286 49 11 52.5 0 279 133 97 145 CAD8050189.1 unnamed protein product [Paramecium sonneborni] diamond 303 86.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni

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