RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1036688" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA1036688 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
5272546 5272546 PRJNA1036688_P_NODE_9265_length_178_cov_1.361702_g8973_i0 PRJNA1036688 9265 178 1.361702 2.42382956 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.4 8.65e-22   NR SPQ94571.1 37360 g8973 i0 77.6 10.752808988764 58 13 97.8 0 174 1 221 278 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 1914 97.8 0.995910020449898 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
12923372 12923372 PRJNA1036688_P_NODE_451_length_1082_cov_2.927273_g289_i0 PRJNA1036688 451 1082 2.927273 31.67309386 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 542 3.22e-190   NR MES1909605.1 1215613 g289 i0 74.2 4.88817005545287 349 90 96.8 0 1082 36 85 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 5289 542 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
17585920 17585920 PRJNA1036688_P_NODE_6614_length_223_cov_0.838710_g6322_i0 PRJNA1036688 6614 223 0.83871 1.8703233 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 130 8.95e-34   NR CEO95191.1 37360 g6322 i0 87.8 1.99103139013453 74 9 99.6 0 222 1 242 315 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 444 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26615484 26615484 PRJNA1036688_P_NODE_11401_length_157_cov_1.216667_g11109_i0 PRJNA1036688 11401 157 1.216667 1.91016719 Suessiales 89954 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.89e-15   NR CAE7269494.1 2951 g11109 i0 67.3 7.94904458598726 52 17 99.4 0 1 156 22 73 CAE7269494.1 RPL27A [Symbiodinium microadriaticum] diamond 1248 75.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
26940121 26940121 PRJNA1036688_P_NODE_8342_length_190_cov_2.477124_g8050_i0 PRJNA1036688 8342 190 2.477124 4.7065356 Hepatocystis sp. ex Piliocolobus tephrosceles 2600580 SAR_Eukaryotes SAR_Eukaryotes 99 3.68e-25   NR VWU51230.1 2600580 g8050 i0 79 0.978947368421053 62 13 97.9 0 188 3 16 77 VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] diamond 186 99 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Hepatocystis Hepatocystis sp. ex Piliocolobus tephrosceles
27667233 27667233 PRJNA1036688_P_NODE_7964_length_196_cov_1.930818_g7672_i0 PRJNA1036688 7964 196 1.930818 3.78440328 Ectocarpus siliculosus 2880 SAR_Eukaryotes SAR_Eukaryotes 100 3.47e-24   NR CBJ34010.1 2880 g7672 i0 76.6 6.85714285714286 64 15 98 0 5 196 72 135 CBJ34010.1 conserved unknown protein [Ectocarpus siliculosus] diamond 1344 100 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
28077401 28077401 PRJNA1036688_P_NODE_11645_length_155_cov_1.313559_g11353_i0 PRJNA1036688 11645 155 1.313559 2.03601645 Chrysophaeum taylorii 2483200 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.34e-7   NR KAJ8614119.1 2483200 g11353 i0 59.6 1.78064516129032 47 19 91 0 2 142 73 119 KAJ8614119.1 hypothetical protein CTAYLR_004615 [Chrysophaeum taylorii] diamond 276 53.5 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Chrysophaeum Chrysophaeum taylorii
28077402 28077402 PRJNA1036688_P_NODE_7625_length_202_cov_1.375758_g7333_i0 PRJNA1036688 7625 202 1.375758 2.77903116 Cladocopium goreaui 2562237 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.15e-7   NR CAL1157362.1 2562237 g7333 i0 41.8 0.995049504950495 67 34 96.5 2 6 200 8 71 CAL1157362.1 unnamed protein product, partial [Cladocopium goreaui] diamond 201 55.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui
28709146 28709146 PRJNA1036688_P_NODE_12287_length_150_cov_1.380531_g11995_i0 PRJNA1036688 12287 150 1.380531 2.0707965 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 86.3 6.72e-19   NR CEP01968.1 37360 g11995 i0 81.6 0.98 49 9 98 0 4 150 76 124 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 147 86.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29088025 29088025 PRJNA1036688_P_NODE_8448_length_189_cov_0.953947_g8156_i0 PRJNA1036688 8448 189 0.953947 1.80295983 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 80.5 8.47e-16   NR CEO95191.1 37360 g8156 i0 59.7 1.96825396825397 62 25 98.4 0 188 3 413 474 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 372 80.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29434895 29434895 PRJNA1036688_P_NODE_9550_length_175_cov_1.369565_g9258_i0 PRJNA1036688 9550 175 1.369565 2.39673875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 89.7 3.71e-19   NR CEO95191.1 37360 g9258 i0 67.2 0.994285714285714 58 19 99.4 0 1 174 169 226 CEO95191.1 hypothetical protein PBRA_003957 [Plasmodiophora brassicae] diamond 174 89.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29561333 29561333 PRJNA1036688_P_NODE_11350_length_157_cov_1.933333_g11058_i0 PRJNA1036688 11350 157 1.933333 3.03533281 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 60.1 8.68e-10   NR KAG5186919.1 303371 g11058 i0 58.8 4.92993630573248 51 21 97.5 0 1 153 56 106 KAG5186919.1 ribosomal L29 protein-domain-containing protein [Tribonema minus] diamond 774 60.1 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
30153313 30153313 PRJNA1036688_P_NODE_8592_length_187_cov_1.020000_g8300_i0 PRJNA1036688 8592 187 1.02 1.9074 Perkinsus 28000 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.13e-24   NR KAF4747601.1 32597 g8300 i0 82.8 13.9411764705882 58 10 93 0 185 12 7 64 KAF4747601.1 40S ribosomal protein S17 [Perkinsus olseni] diamond 2607 97.8 1 Eukaryota Sar   Perkinsozoa   Perkinsida Perkinsidae Perkinsus Perkinsus olseni
30375192 30375192 PRJNA1036688_P_NODE_2612_length_421_cov_1.901042_g2322_i0 PRJNA1036688 2612 421 1.901042 8.00338682 Pythium 4797 SAR_Eukaryotes SAR_Eukaryotes 138 8.75e-35   NR TMW56563.1 41045 g2322 i0 80.5 2.47980997624703 87 17 62 0 41 301 567 653 TMW56563.1 hypothetical protein Poli38472_006573 [Pythium oligandrum] diamond 1044 139 0.992805755395683 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
30856636 30856636 PRJNA1036688_P_NODE_10194_length_168_cov_1.183206_g9902_i0 PRJNA1036688 10194 168 1.183206 1.98778608 Plasmopara halstedii 4781 SAR_Eukaryotes SAR_Eukaryotes 79 1.6e-15   NR XP_024575780.1 4781 g9902 i0 72.7 0.982142857142857 55 15 98.2 0 166 2 264 318 XP_024575780.1 methylthioribose-1-phosphate isomerase [Plasmopara halstedii] diamond 165 79 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
30983235 30983235 PRJNA1036688_P_NODE_4754_length_282_cov_1.575510_g4462_i0 PRJNA1036688 4754 282 1.57551 4.4429382 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0265   NR CEO99081.1 37360 g4462 i0 60 0.265957446808511 25 10 26.6 0 281 207 118 142 CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] diamond 75 42.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30983236 30983236 PRJNA1036688_P_NODE_5514_length_255_cov_2.385321_g5222_i0 PRJNA1036688 5514 255 2.385321 6.08256855 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 52 6.55e-6   NR KAH8098336.1 44056 g5222 i0 40.2 1.02352941176471 87 46 100 3 255 1 50 132 KAH8098336.1 hypothetical protein JL720_1275 [Aureococcus anophagefferens] diamond 261 52 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
30983237 30983237 PRJNA1036688_P_NODE_9034_length_181_cov_1.333333_g8742_i0 PRJNA1036688 9034 181 1.333333 2.41333273 Blastocystis sp. ATCC 5 46767 SAR_Eukaryotes SAR_Eukaryotes 72 4.96e-13   NR OAO17055.1 478820 g8742 i0 61.4 1.87292817679558 57 22 94.5 0 1 171 191 247 OAO17055.1 60S acidic ribosomal protein P0 [Blastocystis sp. ATCC 50177/Nand II] diamond 339 72 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis hominis
31386133 31386133 PRJNA1036688_P_NODE_10196_length_168_cov_1.183206_g9904_i0 PRJNA1036688 10196 168 1.183206 1.98778608 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.1 1.29e-22   NR ACU45020.1 71001 g9904 i0 89.6 6 48 5 85.7 0 25 168 1 48 ACU45020.1 60s ribosomal protein L15 [Pfiesteria piscicida] diamond 1008 95.1 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
31670607 31670607 PRJNA1036688_P_NODE_7197_length_210_cov_1.549133_g6905_i0 PRJNA1036688 7197 210 1.549133 3.2531793 Apicomplexa 5794 SAR_Eukaryotes SAR_Eukaryotes 103 1.11e-25   NR OEH76901.1 88456 g6905 i0 75.4 12.6571428571429 69 17 98.6 0 4 210 103 171 OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis] diamond 2658 103 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Cyclospora Cyclospora cayetanensis
31765478 31765478 PRJNA1036688_P_NODE_6417_length_228_cov_1.921466_g6125_i0 PRJNA1036688 6417 228 1.921466 4.38094248 Cryptosporidium 5806 SAR_Eukaryotes SAR_Eukaryotes 87.8 6.24e-19   NR XP_625504.1 353152 g6125 i0 60.5 2 76 30 100 0 228 1 183 258 XP_625504.1 60S ribosomal protein L7A, partial [Cryptosporidium parvum Iowa II] diamond 456 88.6 0.99097065462754 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium parvum
32501520 32501520 PRJNA1036688_P_NODE_8099_length_194_cov_2.210191_g7807_i0 PRJNA1036688 8099 194 2.210191 4.28777054 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 52 5.61e-6   NR KRX05597.1 266149 g7807 i0 60.9 1.31443298969072 46 16 68 1 61 192 49 94 KRX05597.1 Ribosomal protein L6, alpha-beta domain [Pseudocohnilembus persalinus] diamond 255 52 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32722045 32722045 PRJNA1036688_P_NODE_11540_length_156_cov_0.983193_g11248_i0 PRJNA1036688 11540 156 0.983193 1.53378108 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 66.2 5.95e-11   NR KAH8063768.1 44056 g11248 i0 63.8 6.03846153846154 47 15 90.4 1 16 156 471 515 KAH8063768.1 shikimate 3-dehydrogenase [Aureococcus anophagefferens] diamond 942 66.2 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);;