RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 30 ✖

tax_clade 1

bioproject 1

  • PRJNA745553 · 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
2000247 2000247 PRJNA745553_S_NODE_22342_length_262_cov_1.222222_g22147_i0 PRJNA745553 22342 262 1.222222 3.20222164 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 158 2.65e-44   NR CAJ1941492.1 2856 g22147 i0 89.7 5.96564885496183 87 9 99.6 0 2 262 355 441 CAJ1941492.1 unnamed protein product [Cylindrotheca closterium] diamond 1563 159 0.993710691823899 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
8377555 8377555 PRJNA745553_S_NODE_22247_length_262_cov_3.666667_g22052_i0 PRJNA745553 22247 262 3.666667 9.60666754 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 82 7.08e-16   NR GAX12058.1 1519565 g22052 i0 76.9 1.79770992366412 52 12 59.5 0 262 107 611 662 GAX12058.1 polyadenylate-binding protein [Fistulifera solaris] diamond 471 82.4 0.995145631067961 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
9652911 9652911 PRJNA745553_S_NODE_8068_length_421_cov_4.738506_g7873_i0 PRJNA745553 8068 421 4.738506 19.94911026 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 125 5.17e-31   NR GAX21451.1 1519565 g7873 i0 96.9 0.926365795724466 65 2 46.3 0 197 3 352 416 GAX21451.1 large subunit ribosomal protein L3e [Fistulifera solaris] diamond 390 125 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27210582 27210582 PRJNA745553_S_NODE_12262_length_350_cov_5.552347_g12067_i0 PRJNA745553 12262 350 5.552347 19.4332145 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 92.8 3.79e-19   NR GAX11510.1 1519565 g12067 i0 76.1 0.574285714285714 67 16 57.4 0 340 140 435 501 GAX11510.1 hypothetical protein FisN_22Lh201 [Fistulifera solaris] diamond 201 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27432230 27432230 PRJNA745553_S_NODE_23263_length_256_cov_3.879781_g23068_i0 PRJNA745553 23263 256 3.879781 9.93223936 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 49.3 2.23e-4   NR GKY98714.1 2872254 g23068 i0 78.6 0.328125 28 6 32.8 0 180 97 1537 1564 GKY98714.1 hypothetical protein MPSEU_000827700 [Mayamaea pseudoterrestris] diamond 84 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27874002 27874002 PRJNA745553_S_NODE_22265_length_262_cov_2.851852_g22070_i0 PRJNA745553 22265 262 2.851852 7.47185224 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 57.8 1.9e-7   NR GAX19781.1 1519565 g22070 i0 64.4 0.515267175572519 45 16 51.5 0 259 125 243 287 GAX19781.1 hypothetical protein FisN_3Hh010 [Fistulifera solaris] diamond 135 57.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27905336 27905336 PRJNA745553_S_NODE_15705_length_311_cov_2.457983_g15510_i0 PRJNA745553 15705 311 2.457983 7.64432713 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 94.4 5.48e-20   NR GKY99141.1 2872254 g15510 i0 64.1 0.617363344051447 64 23 61.7 0 18 209 72 135 GKY99141.1 hypothetical protein MPSEU_000869600 [Mayamaea pseudoterrestris] diamond 192 94.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28474019 28474019 PRJNA745553_S_NODE_9346_length_395_cov_8.515528_g9151_i0 PRJNA745553 9346 395 8.515528 33.6363356 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 148 2.2e-39   NR GAX22268.1 1519565 g9151 i0 70.5 0.721518987341772 95 28 72.2 0 372 88 422 516 GAX22268.1 oligosaccharide translocation protein RFT1 [Fistulifera solaris] diamond 285 148 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28632016 28632016 PRJNA745553_S_NODE_17947_length_291_cov_4.233945_g17752_i0 PRJNA745553 17947 291 4.233945 12.32077995 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 155 2.62e-45   NR GAX21181.1 1519565 g17752 i0 91.8 1.75257731958763 85 7 87.6 0 36 290 146 230 GAX21181.1 hypothetical protein FisN_14Hh394 [Fistulifera solaris] diamond 510 155 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28673395 28673395 PRJNA745553_S_NODE_17967_length_291_cov_3.325688_g17772_i0 PRJNA745553 17967 291 3.325688 9.67775208 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 154 8.74e-44   NR VEU38681.1 183589 g17772 i0 98.6 5.85567010309278 71 1 73.2 0 12 224 237 307 VEU38681.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1704 155 0.993548387096774 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
28852609 28852609 PRJNA745553_S_NODE_20808_length_271_cov_3.272727_g20613_i0 PRJNA745553 20808 271 3.272727 8.86909017 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 151 5.21e-44   NR GAX26623.1 1519565 g20613 i0 87.7 0.896678966789668 81 10 89.7 0 2 244 139 219 GAX26623.1 hypothetical protein FisN_21Lh093 [Fistulifera solaris] diamond 243 151 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29011068 29011068 PRJNA745553_S_NODE_14068_length_328_cov_3.156863_g13873_i0 PRJNA745553 14068 328 3.156863 10.35451064 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0261   NR KAI2503523.1 210448 g13873 i0 66.7 0.274390243902439 30 10 27.4 0 296 207 377 406 KAI2503523.1 enoyl-(acyl carrier protein) reductase [Fragilaria crotonensis] diamond 90 44.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29704878 29704878 PRJNA745553_S_NODE_2050_length_651_cov_4.821799_g1879_i0 PRJNA745553 2050 651 4.821799 31.38991149 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 394 3.75e-135   NR GAX24394.1 1519565 g1879 i0 95.5 0.91705069124424 199 9 91.7 0 2 598 185 383 GAX24394.1 S-(hydroxymethyl)glutathione dehydrogenase / alcohol dehydrogenase [Fistulifera solaris] diamond 597 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29831598 29831598 PRJNA745553_S_NODE_30051_length_208_cov_6.007407_g29856_i0 PRJNA745553 30051 208 6.007407 12.49540656 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 56.2 3.99e-7   NR GAX26512.1 1519565 g29856 i0 96.3 0.778846153846154 27 1 38.9 0 48 128 711 737 GAX26512.1 hypothetical protein FisN_23Lh036 [Fistulifera solaris] diamond 162 56.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29926532 29926532 PRJNA745553_S_NODE_22851_length_259_cov_1.241935_g22656_i0 PRJNA745553 22851 259 1.241935 3.21661165 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 83.6 4.34e-17   NR GAX26732.1 1519565 g22656 i0 79.2 0.555984555984556 48 9 54.4 1 250 110 224 271 GAX26732.1 hypothetical protein FisN_2Hh319 [Fistulifera solaris] diamond 144 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30526638 30526638 PRJNA745553_S_NODE_3333_length_571_cov_6.212851_g3150_i0 PRJNA745553 3333 571 6.212851 35.47537921 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 307 9.59e-94   NR GKY97526.1 2872254 g3150 i0 82.2 0.971978984238179 185 30 95.6 1 569 24 1103 1287 GKY97526.1 hypothetical protein MPSEU_000710800 [Mayamaea pseudoterrestris] diamond 555 307 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30558081 30558081 PRJNA745553_S_NODE_20953_length_270_cov_2.690355_g20758_i0 PRJNA745553 20953 270 2.690355 7.2639585 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 48.1 6.52e-4   NR GAX12353.1 1519565 g20758 i0 91.3 0.255555555555556 23 2 25.6 0 122 54 129 151 GAX12353.1 ATP-binding cassette, subfamily F, member 1 [Fistulifera solaris] diamond 69 48.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30652874 30652874 PRJNA745553_S_NODE_10673_length_372_cov_4.247492_g10478_i0 PRJNA745553 10673 372 4.247492 15.80067024 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 97.1 6.53e-23   NR GAX21754.1 1519565 g10478 i0 100 0.370967741935484 46 0 37.1 0 90 227 96 141 GAX21754.1 small subunit ribosomal protein S16e [Fistulifera solaris] diamond 138 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30716143 30716143 PRJNA745553_S_NODE_15214_length_316_cov_1.164609_g15019_i0 PRJNA745553 15214 316 1.164609 3.68016444 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.07e-8   NR XDU46076.1 2126271 g15019 i0 49.2 1.13924050632911 59 30 56 0 53 229 425 483 XDU46076.1 NADH dehydrogenase subunit 4 [Naviculales sp.] diamond 360 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
30969191 30969191 PRJNA745553_S_NODE_23654_length_254_cov_2.640884_g23459_i0 PRJNA745553 23654 254 2.640884 6.70784536 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.7e-9   NR GKY96869.1 2872254 g23459 i0 70.5 0.519685039370079 44 13 52 0 20 151 533 576 GKY96869.1 hypothetical protein MPSEU_000646000 [Mayamaea pseudoterrestris] diamond 132 63.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31032473 31032473 PRJNA745553_S_NODE_27115_length_239_cov_2.295181_g26920_i0 PRJNA745553 27115 239 2.295181 5.48548259 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 73.2 8.45e-15   NR CAB9509935.1 568900 g26920 i0 77.3 0.552301255230126 44 10 55.2 0 215 84 46 89 CAB9509935.1 expressed unknown protein [Seminavis robusta] diamond 132 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31189828 31189828 PRJNA745553_S_NODE_4675_length_515_cov_14.316742_g4484_i0 PRJNA745553 4675 515 14.316742 73.7312213 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 99 2.0099999999999994e-23   NR KAG7354278.1 303405 g4484 i0 59.8 0.955339805825243 82 33 47.8 0 249 494 19 100 KAG7354278.1 hypothetical protein IV203_003634 [Nitzschia inconspicua] diamond 492 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31579838 31579838 PRJNA745553_S_NODE_12256_length_350_cov_6.602888_g12061_i0 PRJNA745553 12256 350 6.602888 23.110108 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 86.3 6.42e-17   NR KAK1748085.1 267567 g12061 i0 57.1 2.33142857142857 70 30 60 0 18 227 418 487 KAK1748085.1 aspartate-ammonia ligase [Skeletonema marinoi] diamond 816 86.7 0.995386389850058 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31790959 31790959 PRJNA745553_S_NODE_17017_length_299_cov_3.845133_g16822_i0 PRJNA745553 17017 299 3.845133 11.49694767 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 151 7.11e-44   NR GAX11897.1 1519565 g16822 i0 93.5 0.77257525083612 77 5 77.3 0 24 254 141 217 GAX11897.1 large subunit ribosomal protein L10e [Fistulifera solaris] diamond 231 151 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31854339 31854339 PRJNA745553_S_NODE_29797_length_213_cov_4.500000_g29602_i0 PRJNA745553 29797 213 4.5 9.585 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 94 2.27e-20   NR GKY91960.1 2872254 g29602 i0 83.6 0.774647887323944 55 9 77.5 0 196 32 655 709 GKY91960.1 hypothetical protein MPSEU_000167600 [Mayamaea pseudoterrestris] diamond 165 94 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32423931 32423931 PRJNA745553_S_NODE_16659_length_302_cov_5.982533_g16464_i0 PRJNA745553 16659 302 5.982533 18.06724966 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.9599999999999994e-23   NR GKY96395.1 2872254 g16464 i0 73.3 0.596026490066225 60 15 59.6 1 1 180 70 128 GKY96395.1 hypothetical protein MPSEU_000599100 [Mayamaea pseudoterrestris] diamond 180 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32613518 32613518 PRJNA745553_S_NODE_24740_length_249_cov_2.522727_g24545_i0 PRJNA745553 24740 249 2.522727 6.28159023 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 123 1.21e-33   NR GAX10657.1 1519565 g24545 i0 91.8 0.879518072289157 73 3 84.3 1 233 24 90 162 GAX10657.1 large subunit ribosomal protein L21e [Fistulifera solaris] diamond 219 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32770861 32770861 PRJNA745553_S_NODE_12940_length_342_cov_1.750929_g12745_i0 PRJNA745553 12940 342 1.750929 5.98817718 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 136 1.0699999999999998e-37   NR GAX09802.1 1519565 g12745 i0 78.9 0.833333333333333 95 19 82.5 1 18 299 126 220 GAX09802.1 hypothetical protein FisN_11Lu225 [Fistulifera solaris] diamond 285 136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32865413 32865413 PRJNA745553_S_NODE_21400_length_267_cov_3.407216_g21205_i0 PRJNA745553 21400 267 3.407216 9.09726672 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 65.1 5.35e-10   NR GAX25915.1 1519565 g21205 i0 80 0.764044943820225 35 7 39.3 0 265 161 295 329 GAX25915.1 hypothetical protein FisN_6Hh047 [Fistulifera solaris] diamond 204 65.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32865421 32865421 PRJNA745553_S_NODE_6500_length_459_cov_3.632124_g6306_i0 PRJNA745553 6500 459 3.632124 16.67144916 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0181   NR GAX09949.1 1519565 g6306 i0 51 0.320261437908497 49 20 32 1 165 311 373 417 GAX09949.1 hypothetical protein FisN_11Lh063 [Fistulifera solaris] diamond 147 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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