RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA722925" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA722925 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26608665 26608665 PRJNA722925_S_NODE_5861_length_190_cov_1.248366_g5798_i0 PRJNA722925 5861 190 1.248366 2.3718954 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 97.8 9.82e-23   NR XP_001011598.2 312017 g5798 i0 71 1.95789473684211 62 17 96.3 1 185 3 141 202 XP_001011598.2 60S ribosomal protein L5 [Tetrahymena thermophila SB210] diamond 372 97.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26608666 26608666 PRJNA722925_S_NODE_8801_length_164_cov_0.921260_g8738_i0 PRJNA722925 8801 164 0.92126 1.5108664 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.75e-17   NR KRX06793.1 266149 g8738 i0 87.2 0.859756097560976 47 6 86 0 153 13 401 447 KRX06793.1 SCP2 sterol-binding domain [Pseudocohnilembus persalinus] diamond 141 84.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
26640531 26640531 PRJNA722925_S_NODE_241_length_789_cov_3.357713_g205_i0 PRJNA722925 241 789 3.357713 26.49235557 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.22e-6   NR CDW86772.1 5949 g205 i0 41.7 0.319391634980989 84 46 30.8 1 16 258 56 139 CDW86772.1 UNKNOWN [Stylonychia lemnae] diamond 252 58.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27557399 27557399 PRJNA722925_S_NODE_1404_length_360_cov_2.325077_g1341_i0 PRJNA722925 1404 360 2.325077 8.3702772 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 122 6.66e-32   NR CAD8051385.1 5886 g1341 i0 56.4 4.75 110 45 91.7 1 2 331 86 192 CAD8051385.1 unnamed protein product [Paramecium primaurelia] diamond 1710 122 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27841644 27841644 PRJNA722925_S_NODE_1364_length_364_cov_1.874618_g1301_i0 PRJNA722925 1364 364 1.874618 6.82360952 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 97.8 7.28e-21   NR CAE8599108.1 89957 g1301 i0 42.4 8.75274725274725 118 57 97.3 1 3 356 579 685 CAE8599108.1 unnamed protein product [Polarella glacialis] diamond 3186 97.8 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
28104672 28104672 PRJNA722925_S_NODE_7625_length_172_cov_1.733333_g7562_i0 PRJNA722925 7625 172 1.733333 2.98133276 Symbiodiniaceae 252141 SAR_Eukaryotes SAR_Eukaryotes 75.9 3.09e-16   NR CAE7595067.1 1519616 g7562 i0 60 17.2674418604651 55 22 95.9 0 2 166 11 65 CAE7595067.1 RPL31 [Symbiodinium sp. CCMP2456] diamond 2970 76.3 0.99475753604194 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2456
28294158 28294158 PRJNA722925_S_NODE_5686_length_192_cov_2.193548_g5623_i0 PRJNA722925 5686 192 2.193548 4.21161216 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 49.3 9.03e-5   NR KRX06822.1 266149 g5623 i0 43.2 1.390625 44 25 68.8 0 192 61 190 233 KRX06822.1 hypothetical protein PPERSA_11467 [Pseudocohnilembus persalinus] diamond 267 49.7 0.991951710261569 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28473356 28473356 PRJNA722925_S_NODE_10886_length_153_cov_1.008621_g10823_i0 PRJNA722925 10886 153 1.008621 1.54319013 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 82 7.35e-17   NR XP_001435272.1 5888 g10823 i0 62.7 2 51 19 100 0 1 153 142 192 XP_001435272.1 uncharacterized protein GSPATT00036656001 [Paramecium tetraurelia] diamond 306 82 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28862470 28862470 PRJNA722925_S_NODE_9768_length_158_cov_1.611570_g9705_i0 PRJNA722925 9768 158 1.61157 2.5462806 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 54.3 1.89e-7   NR KAL4453409.1 5901 g9705 i0 92 0.949367088607595 25 2 47.5 0 156 82 95 119 KAL4453409.1 hypothetical protein ABPG74_017616 [Tetrahymena malaccensis] diamond 150 54.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29083736 29083736 PRJNA722925_S_NODE_7748_length_171_cov_1.791045_g7685_i0 PRJNA722925 7748 171 1.791045 3.06268695 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 55.8 3.06e-7   NR TMW60079.1 41045 g7685 i0 49.1 4.70175438596491 53 27 93 0 164 6 94 146 TMW60079.1 hypothetical protein Poli38472_000121 [Pythium oligandrum] diamond 804 55.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
29619933 29619933 PRJNA722925_S_NODE_4750_length_207_cov_2.294118_g4687_i0 PRJNA722925 4750 207 2.294118 4.74882426 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00411   NR CAB1103442.1 867726 g4687 i0 32.8 2.66666666666667 64 43 92.8 0 199 8 123 186 CAB1103442.1 unnamed protein product [Ectocarpus sp. CCAP 1310/34] diamond 552 45.1 0.991130820399113 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus sp. CCAP 1310/34
30062377 30062377 PRJNA722925_S_NODE_11551_length_150_cov_1.035398_g11488_i0 PRJNA722925 11551 150 1.035398 1.553097 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 86.3 3.55e-18   NR KRW98198.1 266149 g11488 i0 70 2 50 15 100 0 150 1 80 129 KRW98198.1 hypothetical protein PPERSA_03400 [Pseudocohnilembus persalinus] diamond 300 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30504950 30504950 PRJNA722925_S_NODE_6673_length_181_cov_1.083333_g6610_i0 PRJNA722925 6673 181 1.083333 1.96083273 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.12e-7   NR KAL4449249.1 5901 g6610 i0 74.2 1.02762430939227 31 8 51.4 0 180 88 726 756 KAL4449249.1 hypothetical protein ABPG74_015631 [Tetrahymena malaccensis] diamond 186 57.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30525949 30525949 PRJNA722925_S_NODE_1213_length_381_cov_2.997093_g1150_i0 PRJNA722925 1213 381 2.997093 11.41892433 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 133 7.09e-36   NR XP_001031587.2 312017 g1150 i0 58.2 1.91338582677165 122 51 96.1 0 5 370 84 205 XP_001031587.2 60S ribosomal L7Ae-like protein [Tetrahymena thermophila SB210] diamond 729 133 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30557360 30557360 PRJNA722925_S_NODE_11053_length_152_cov_1.356522_g10990_i0 PRJNA722925 11053 152 1.356522 2.06191344 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 47 6.91e-5   NR KAL4472608.1 5901 g10990 i0 74.2 0.611842105263158 31 8 61.2 0 2 94 69 99 KAL4472608.1 hypothetical protein ABPG74_018557 [Tetrahymena malaccensis] diamond 93 47 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30873561 30873561 PRJNA722925_S_NODE_7774_length_171_cov_1.455224_g7711_i0 PRJNA722925 7774 171 1.455224 2.48843304 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.87e-10   NR XP_004027231.1 5932 g7711 i0 53.6 6.94736842105263 56 26 98.2 0 171 4 61 116 XP_004027231.1 hypothetical protein IMG5_187300 [Ichthyophthirius multifiliis] diamond 1188 62.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31000022 31000022 PRJNA722925_S_NODE_9314_length_161_cov_0.943548_g9251_i0 PRJNA722925 9314 161 0.943548 1.51911228 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.27e-20   NR XP_001009414.2 312017 g9251 i0 86.8 1.97515527950311 53 7 98.8 0 161 3 123 175 XP_001009414.2 50S ribosomal protein L1P [Tetrahymena thermophila SB210] diamond 318 90.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31895790 31895790 PRJNA722925_S_NODE_3457_length_238_cov_1.447761_g3394_i0 PRJNA722925 3457 238 1.447761 3.44567118 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.5 1.58e-8   NR CAE7775170.1 2951 g3394 i0 45 4.8781512605042 60 33 75.6 0 186 7 27 86 CAE7775170.1 SAG39, partial [Symbiodinium microadriaticum] diamond 1161 60.8 0.995065789473684 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32201817 32201817 PRJNA722925_S_NODE_8458_length_166_cov_1.511628_g8395_i0 PRJNA722925 8458 166 1.511628 2.50930248 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 61.2 3.05e-9   NR AIE77190.1 151077 g8395 i0 51.9 1.87951807228916 52 25 94 0 156 1 53 104 AIE77190.1 leishmanolysin family protein, partial [Chilodonella uncinata] diamond 312 61.2 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
32391620 32391620 PRJNA722925_S_NODE_3999_length_223_cov_1.048387_g3936_i0 PRJNA722925 3999 223 1.048387 2.33790301 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 108 9.999999999999999e-29   NR XP_001021691.3 312017 g3936 i0 64.9 0.995515695067265 74 26 99.6 0 2 223 28 101 XP_001021691.3 hypothetical protein TTHERM_00151580 [Tetrahymena thermophila SB210] diamond 222 108 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32550090 32550090 PRJNA722925_S_NODE_10479_length_155_cov_0.983051_g10416_i0 PRJNA722925 10479 155 0.983051 1.52372905 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.84e-12   NR XP_001018996.2 312017 g10416 i0 80.8 1.00645161290323 52 9 98.7 1 2 154 1548 1599 XP_001018996.2 amine-terminal domain guanylate-binding protein [Tetrahymena thermophila SB210] diamond 156 70.5 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);;