RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA942359" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 27 ✖

bioproject 1

  • PRJNA942359 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
26803619 26803619 PRJNA942359_P_NODE_17641_length_246_cov_0.901734_g17526_i0 PRJNA942359 17641 246 0.901734 2.21826564 Eimeria tenella 5802 SAR_Eukaryotes SAR_Eukaryotes 59.3 4.86e-8   NR XP_013233079.1 5802 g17526 i0 30.4 0.963414634146341 79 52 92.7 1 233 6 238 316 XP_013233079.1 vacuolar protein sorting-associated protein, putative [Eimeria tenella] diamond 237 59.3 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria tenella
26898805 26898805 PRJNA942359_P_NODE_9961_length_281_cov_1.259615_g9846_i0 PRJNA942359 9961 281 1.259615 3.53951815 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0168   NR GFH55746.1 426638 g9846 i0 57.6 0.704626334519573 33 14 35.2 0 281 183 663 695 GFH55746.1 hypothetical protein CTEN210_12222 [Chaetoceros tenuissimus] diamond 198 44.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27025234 27025234 PRJNA942359_P_NODE_18862_length_244_cov_0.912281_g18747_i0 PRJNA942359 18862 244 0.912281 2.22596564 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 48.1 4.63e-4   NR CAB9525870.1 568900 g18747 i0 82.1 0.344262295081967 28 5 34.4 0 179 96 736 763 CAB9525870.1 regulated potassium-efflux system protein [Seminavis robusta] diamond 84 48.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27309924 27309924 PRJNA942359_P_NODE_14743_length_250_cov_0.881356_g14628_i0 PRJNA942359 14743 250 0.881356 2.20339 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.22e-18   NR GKY93773.1 2872254 g14628 i0 54.9 0.852 71 32 85.2 0 249 37 739 809 GKY93773.1 hypothetical protein MPSEU_000344500 [Mayamaea pseudoterrestris] diamond 213 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27436317 27436317 PRJNA942359_P_NODE_13883_length_252_cov_0.871508_g13768_i0 PRJNA942359 13883 252 0.871508 2.19620016 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.1e-13   NR KAK1739455.1 267567 g13768 i0 44.3 0.94047619047619 79 42 92.9 2 237 4 84 161 KAK1739455.1 hypothetical protein QTG54_009998 [Skeletonema marinoi] diamond 237 73.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27499356 27499356 PRJNA942359_P_NODE_20263_length_242_cov_0.923077_g20148_i0 PRJNA942359 20263 242 0.923077 2.23384634 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0022   NR GKY99342.1 2872254 g20148 i0 36.9 2.18181818181818 65 40 80.6 1 197 3 162 225 GKY99342.1 hypothetical protein MPSEU_000889200 [Mayamaea pseudoterrestris] diamond 528 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27752033 27752033 PRJNA942359_P_NODE_15244_length_249_cov_2.534091_g15129_i0 PRJNA942359 15244 249 2.534091 6.30988659 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 67.4 7.9e-11   NR GAX15647.1 1519565 g15129 i0 41.5 2.98795180722892 82 48 98.8 0 4 249 217 298 GAX15647.1 solute carrier family 10 (sodium/bile acid cotransporter), member 7 [Fistulifera solaris] diamond 744 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28320134 28320134 PRJNA942359_P_NODE_6826_length_325_cov_2.186508_g6711_i0 PRJNA942359 6826 325 2.186508 7.106151 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 86.7 3.58e-19   NR GKZ00679.1 2872254 g6711 i0 47.5 0.738461538461539 80 42 73.8 0 243 4 24 103 GKZ00679.1 hypothetical protein MPSEU_001020000 [Mayamaea pseudoterrestris] diamond 240 86.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29330503 29330503 PRJNA942359_P_NODE_9009_length_291_cov_1.041284_g8894_i0 PRJNA942359 9009 291 1.041284 3.03013644 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 60.8 2.77e-8   NR XP_002185452.1 556484 g8894 i0 29.5 0.979381443298969 95 66 97.9 1 2 286 469 562 XP_002185452.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 285 60.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29488210 29488210 PRJNA942359_P_NODE_14830_length_250_cov_0.881356_g14715_i0 PRJNA942359 14830 250 0.881356 2.20339 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 157 1.8199999999999998e-43   NR GKY91038.1 2872254 g14715 i0 94 2.964 83 5 99.6 0 1 249 413 495 GKY91038.1 hypothetical protein MPSEU_000076600 [Mayamaea pseudoterrestris] diamond 741 157 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29551362 29551362 PRJNA942359_P_NODE_10730_length_273_cov_1.560000_g10615_i0 PRJNA942359 10730 273 1.56 4.2588 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 47 0.00171   NR EJK62937.1 159749 g10615 i0 50 0.89010989010989 38 19 41.8 0 264 151 333 370 EJK62937.1 hypothetical protein THAOC_16433 [Thalassiosira oceanica] diamond 243 47 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29804050 29804050 PRJNA942359_P_NODE_12231_length_259_cov_1.349462_g12116_i0 PRJNA942359 12231 259 1.349462 3.49510658 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 100 1.45e-22   NR CAJ1392667.1 2562239 g12116 i0 79.5 2.64092664092664 78 16 90.3 0 257 24 399 476 CAJ1392667.1 unnamed protein product [Effrenium voratum] diamond 684 100 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
30183220 30183220 PRJNA942359_P_NODE_13712_length_252_cov_0.871508_g13597_i0 PRJNA942359 13712 252 0.871508 2.19620016 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.68e-11   NR CAB9525936.1 568900 g13597 i0 51.7 0.69047619047619 58 28 69 0 1 174 508 565 CAB9525936.1 Protein PNS1 [Seminavis robusta] diamond 174 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30189958 30189958 PRJNA942359_P_NODE_13472_length_252_cov_1.536313_g13357_i0 PRJNA942359 13472 252 1.536313 3.87150876 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 68.6 3.26e-11   NR POM61381.1 4796 g13357 i0 43.8 9.20238095238095 80 45 95.2 0 247 8 75 154 POM61381.1 Lysophospholipid acyltransferase, partial [Phytophthora palmivora] diamond 2319 68.9 0.995645863570392 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
30246638 30246638 PRJNA942359_P_NODE_17612_length_246_cov_0.901734_g17497_i0 PRJNA942359 17612 246 0.901734 2.21826564 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 64.3 9.63e-10   NR GKY90494.1 2872254 g17497 i0 45.2 1.02439024390244 84 41 98.8 3 244 2 951 1032 GKY90494.1 hypothetical protein MPSEU_000023200 [Mayamaea pseudoterrestris] diamond 252 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30278388 30278388 PRJNA942359_P_NODE_20672_length_228_cov_2.174194_g20557_i0 PRJNA942359 20672 228 2.174194 4.95716232 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 112 7.17e-27   NR KAK1739260.1 267567 g20557 i0 73.1 1.02631578947368 78 16 96.1 1 10 228 305 382 KAK1739260.1 hypothetical protein QTG54_009803, partial [Skeletonema marinoi] diamond 234 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30846754 30846754 PRJNA942359_P_NODE_10774_length_273_cov_1.195000_g10659_i0 PRJNA942359 10774 273 1.195 3.26235 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 85.5 4.42e-18   NR KAK1739074.1 267567 g10659 i0 73.6 0.791208791208791 72 13 79.1 4 56 271 1 66 KAK1739074.1 hypothetical protein QTG54_010390 [Skeletonema marinoi] diamond 216 85.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31004766 31004766 PRJNA942359_P_NODE_11154_length_269_cov_1.198980_g11039_i0 PRJNA942359 11154 269 1.19898 3.2252562 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 61.6 4.33e-10   NR GAX12737.1 1519565 g11039 i0 43 0.8810408921933092 79 36 88.1 2 5 241 22 91 GAX12737.1 hypothetical protein FisN_15Hh216 [Fistulifera solaris] diamond 237 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31130832 31130832 PRJNA942359_P_NODE_11315_length_267_cov_1.742268_g11200_i0 PRJNA942359 11315 267 1.742268 4.6518555599999996 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 108 3.98e-26   NR CDW82305.1 5949 g11200 i0 59.1 0.98876404494382 88 34 98.9 1 266 3 104 189 CDW82305.1 UNKNOWN [Stylonychia lemnae] diamond 264 108 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31193911 31193911 PRJNA942359_P_NODE_9555_length_285_cov_1.471698_g9440_i0 PRJNA942359 9555 285 1.471698 4.1943393 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 79.7 3.25e-17   NR GAX17416.1 1519565 g9440 i0 58.6 1.44210526315789 70 26 71.6 2 254 51 13 81 GAX17416.1 hypothetical protein FisN_5Hu061 [Fistulifera solaris] diamond 411 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31257525 31257525 PRJNA942359_P_NODE_9335_length_287_cov_1.855140_g9220_i0 PRJNA942359 9335 287 1.85514 5.3242518 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.26e-10   NR GAX23854.1 1519565 g9220 i0 53.2 0.64808362369338 62 28 63.8 1 195 13 5 66 GAX23854.1 hypothetical protein FisN_20Hh059 [Fistulifera solaris] diamond 186 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31352511 31352511 PRJNA942359_P_NODE_9556_length_285_cov_1.471698_g9441_i0 PRJNA942359 9556 285 1.471698 4.1943393 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 116 6.43e-28   NR KAL3945259.1 3061772 g9441 i0 64.5 2.93684210526316 93 33 97.9 0 3 281 548 640 KAL3945259.1 MAG: hypothetical protein SGBAC_000670 [Bacillariaceae sp.] diamond 837 116 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31479146 31479146 PRJNA942359_P_NODE_17916_length_245_cov_1.604651_g17801_i0 PRJNA942359 17916 245 1.604651 3.93139495 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.47e-9   NR VEU39905.1 183589 g17801 i0 56.6 1.29795918367347 53 23 64.9 0 2 160 683 735 VEU39905.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 318 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
32206607 32206607 PRJNA942359_P_NODE_15178_length_250_cov_0.881356_g15063_i0 PRJNA942359 15178 250 0.881356 2.20339 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0361   NR GKY99453.1 2872254 g15063 i0 64.7 0.408 34 7 34.8 1 84 170 62 95 GKY99453.1 putative kinase [Mayamaea pseudoterrestris] diamond 102 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32333464 32333464 PRJNA942359_P_NODE_9939_length_281_cov_1.495192_g9824_i0 PRJNA942359 9939 281 1.495192 4.20148952 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.78e-18   NR GKY99009.1 2872254 g9824 i0 56.6 0.811387900355872 76 33 81.1 0 279 52 206 281 GKY99009.1 hypothetical protein MPSEU_000856600 [Mayamaea pseudoterrestris] diamond 228 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32428130 32428130 PRJNA942359_P_NODE_12099_length_260_cov_1.443850_g11984_i0 PRJNA942359 12099 260 1.44385 3.75401 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 172 1.3e-48   NR KAG7342314.1 303405 g11984 i0 91.9 0.992307692307692 86 7 99.2 0 2 259 145 230 KAG7342314.1 flavin containing amine oxidoreductase [Nitzschia inconspicua] diamond 258 172 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32648797 32648797 PRJNA942359_P_NODE_20440_length_237_cov_2.878049_g20325_i0 PRJNA942359 20440 237 2.878049 6.82097613 Cladocopium goreaui 2562237 SAR_Eukaryotes SAR_Eukaryotes 158 7e-43   NR CAL1150585.1 2562237 g20325 i0 98.7 1 79 1 100 0 1 237 1032 1110 CAL1150585.1 unnamed protein product [Cladocopium goreaui] diamond 237 158 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui

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