RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 29 ✖

tax_clade 1

bioproject 1

  • PRJNA928559 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
3454571 3454571 PRJNA928559_P_NODE_224923_length_220_cov_5.734694_g223354_i0 PRJNA928559 224923 220 5.734694 12.6163268 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 90.9 2.02e-19   NR CAB9515933.1 568900 g223354 i0 71.2 2.74090909090909 59 17 80.5 0 220 44 59 117 CAB9515933.1 DnaJ protein homolog 1 (Fragment) [Seminavis robusta] diamond 603 90.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
8905763 8905763 PRJNA928559_P_NODE_210287_length_244_cov_0.912281_g208718_i0 PRJNA928559 210287 244 0.912281 2.22596564 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 132 2.56e-37   NR KAL3772193.1 259834 g208718 i0 74.1 5.97540983606557 81 21 99.6 0 2 244 61 141 KAL3772193.1 hypothetical protein ACHAWU_000541 [Discostella pseudostelligera] diamond 1458 133 0.992481203007519 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
12382853 12382853 PRJNA928559_P_NODE_226810_length_205_cov_4.045455_g225241_i0 PRJNA928559 226810 205 4.045455 8.29318275 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 96.3 2.49e-24   NR EJK59273.1 159749 g225241 i0 65.6 1.87317073170732 64 22 93.7 0 194 3 9 72 EJK59273.1 hypothetical protein THAOC_20528, partial [Thalassiosira oceanica] diamond 384 96.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
26739436 26739436 PRJNA928559_P_NODE_107041_length_345_cov_1.128676_g105472_i0 PRJNA928559 107041 345 1.128676 3.8939322 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 61.6 1.96e-8   NR CAB9527390.1 568900 g105472 i0 38.6 0.991304347826087 114 59 99.1 2 1 342 71 173 CAB9527390.1 expressed unknown protein [Seminavis robusta] diamond 342 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
26936944 26936944 PRJNA928559_P_NODE_81342_length_393_cov_2.590625_g79773_i0 PRJNA928559 81342 393 2.590625 10.18115625 root 1 Root_unresolved Root_unresolved 47.4 0.0045   NR KAG7337659.1 303405 g79773 i0 41.9 1.95419847328244 62 20 42.7 3 49 216 143 194 KAG7337659.1 hypothetical protein IV203_036999 [Nitzschia inconspicua] diamond 768 47.8 0.99163179916318 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27245996 27245996 PRJNA928559_P_NODE_138223_length_301_cov_1.754386_g136654_i0 PRJNA928559 138223 301 1.754386 5.28070186 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 68.2 8.28e-11   NR KAL3935157.1 3061772 g136654 i0 41.7 3.59800664451827 72 42 71.8 0 56 271 290 361 KAL3935157.1 MAG: hypothetical protein SGBAC_009264, partial [Bacillariaceae sp.] diamond 1083 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27284817 27284817 PRJNA928559_P_NODE_37303_length_545_cov_1.777542_g35751_i0 PRJNA928559 37303 545 1.777542 9.6876039 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 121 4.02e-29   NR KAI2497013.1 210448 g35751 i0 42.5 1.88807339449541 174 95 93.6 4 25 534 123 295 KAI2497013.1 Telomere recombination [Fragilaria crotonensis] diamond 1029 121 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27908957 27908957 PRJNA928559_P_NODE_134045_length_306_cov_2.180258_g132476_i0 PRJNA928559 134045 306 2.180258 6.67158948 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 87 2.11e-17   NR XP_002287436.1 296543 g132476 i0 45.6 2.2843137254902 79 43 77.5 0 238 2 132 210 XP_002287436.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 699 87 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28484790 28484790 PRJNA928559_P_NODE_208266_length_244_cov_2.280702_g206697_i0 PRJNA928559 208266 244 2.280702 5.56491288 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 56.6 4.92e-7   NR CAJ1955833.1 2856 g206697 i0 43.6 1.93032786885246 78 40 92.2 3 10 234 549 625 CAJ1955833.1 unnamed protein product [Cylindrotheca closterium] diamond 471 56.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29021842 29021842 PRJNA928559_P_NODE_182488_length_257_cov_1.532609_g180919_i0 PRJNA928559 182488 257 1.532609 3.93880513 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 132 5.5e-37   NR CAJ1911013.1 2856 g180919 i0 74.1 7.76264591439689 85 22 99.2 0 2 256 69 153 CAJ1911013.1 unnamed protein product [Cylindrotheca closterium] diamond 1995 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29456028 29456028 PRJNA928559_P_NODE_157250_length_280_cov_1.995169_g155681_i0 PRJNA928559 157250 280 1.995169 5.5864732 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 112 3e-28   NR EJK65157.1 159749 g155681 i0 68.8 3.83571428571429 93 20 99.6 1 1 279 46 129 EJK65157.1 hypothetical protein THAOC_14024 [Thalassiosira oceanica] diamond 1074 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29519489 29519489 PRJNA928559_P_NODE_179690_length_259_cov_2.215054_g178121_i0 PRJNA928559 179690 259 2.215054 5.73698986 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 90.1 3.18e-19   NR VEU33732.1 183589 g178121 i0 60 0.752895752895753 65 26 75.3 0 5 199 264 328 VEU33732.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 195 90.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29519491 29519491 PRJNA928559_P_NODE_181490_length_258_cov_1.264865_g179921_i0 PRJNA928559 181490 258 1.264865 3.2633517 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 65.5 4.37e-10   NR KAL3799810.1 29204 g179921 i0 54.7 1.23255813953488 53 24 61.6 0 256 98 439 491 KAL3799810.1 hypothetical protein HJC23_010460 [Cyclotella cryptica] diamond 318 65.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29558114 29558114 PRJNA928559_P_NODE_106910_length_345_cov_1.617647_g105341_i0 PRJNA928559 106910 345 1.617647 5.58088215 root 1 Root_unresolved Root_unresolved 115 2.3400000000000003e-27   NR KAL3808183.1 382380 g105341 i0 61 2.99130434782609 82 32 71.3 0 8 253 289 370 KAL3808183.1 hypothetical protein ACHAXA_011782 [Cyclostephanos tholiformis] diamond 1032 115 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
29740256 29740256 PRJNA928559_P_NODE_146270_length_292_cov_1.091324_g144701_i0 PRJNA928559 146270 292 1.091324 3.18666608 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.7e-7   NR GAX27702.1 1519565 g144701 i0 40.3 0.73972602739726 72 37 69.9 2 252 49 17 86 GAX27702.1 hypothetical protein FisN_13Hu201 [Fistulifera solaris] diamond 216 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29771942 29771942 PRJNA928559_P_NODE_195831_length_249_cov_5.568182_g194262_i0 PRJNA928559 195831 249 5.568182 13.86477318 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 69.3 7.42e-13   NR GKY99081.1 2872254 g194262 i0 97.1 43.4819277108434 34 1 41 0 3 104 94 127 GKY99081.1 alpha-glucosides permease mph3 [Mayamaea pseudoterrestris] diamond 10827 69.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29835177 29835177 PRJNA928559_P_NODE_133371_length_307_cov_1.752137_g131802_i0 PRJNA928559 133371 307 1.752137 5.37906059 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 112 1.6700000000000002e-26   NR KAG7371210.1 303405 g131802 i0 48.5 5.92182410423453 101 52 98.7 0 305 3 291 391 KAG7371210.1 DEAD/DEAH box helicase domain protein [Nitzschia inconspicua] diamond 1818 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29866908 29866908 PRJNA928559_P_NODE_153391_length_284_cov_1.985782_g151822_i0 PRJNA928559 153391 284 1.985782 5.63962088 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 74.7 3.38e-13   NR KAG7375037.1 303405 g151822 i0 40.2 0.866197183098592 82 49 86.6 0 282 37 330 411 KAG7375037.1 pyridoxal phosphate-dependent transferase [Nitzschia inconspicua] diamond 246 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29898560 29898560 PRJNA928559_P_NODE_208291_length_244_cov_2.210526_g206722_i0 PRJNA928559 208291 244 2.210526 5.39368344 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00589   NR KAL3913961.1 3061772 g206722 i0 39.4 0.872950819672131 71 35 77.5 2 244 56 537 607 KAL3913961.1 MAG: hypothetical protein SGILL_006285 [Bacillariaceae sp.] diamond 213 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30309646 30309646 PRJNA928559_P_NODE_138412_length_301_cov_1.368421_g136843_i0 PRJNA928559 138412 301 1.368421 4.11894721 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 52 4.34e-5   NR XP_002180388.1 556484 g136843 i0 31 0.867109634551495 87 49 86.7 1 28 288 558 633 XP_002180388.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 261 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30467464 30467464 PRJNA928559_P_NODE_156213_length_281_cov_2.163462_g154644_i0 PRJNA928559 156213 281 2.163462 6.07932822 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0163   NR KAL3913991.1 3061772 g154644 i0 59 0.864768683274021 39 15 40.6 1 253 140 251 289 KAL3913991.1 MAG: hypothetical protein SGILL_006275 [Bacillariaceae sp.] diamond 243 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30783100 30783100 PRJNA928559_P_NODE_180854_length_258_cov_2.232432_g179285_i0 PRJNA928559 180854 258 2.232432 5.75967456 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 109 6.44e-26   NR KAI2490905.1 210448 g179285 i0 57.6 0.988372093023256 85 36 98.8 0 3 257 206 290 KAI2490905.1 peptidase [Fragilaria crotonensis] diamond 255 109 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30790234 30790234 PRJNA928559_P_NODE_14174_length_828_cov_4.925828_g12840_i0 PRJNA928559 14174 828 4.925828 40.78585584 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 136 2.88e-36   NR KAG7373989.1 303405 g12840 i0 48.4 4.20652173913043 126 65 45.7 0 54 431 7 132 KAG7373989.1 50S ribosomal protein L14e [Nitzschia inconspicua] diamond 3483 136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31288633 31288633 PRJNA928559_P_NODE_213615_length_242_cov_1.952663_g212046_i0 PRJNA928559 213615 242 1.952663 4.72544446 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 108 1.02e-25   NR KAL3765899.1 382360 g212046 i0 62.5 1.95867768595041 80 30 99.2 0 1 240 185 264 KAL3765899.1 hypothetical protein ACHAWO_007586 [Cyclotella atomus] diamond 474 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31517439 31517439 PRJNA928559_P_NODE_64896_length_434_cov_4.000000_g63327_i0 PRJNA928559 64896 434 4 17.36 root 1 Root_unresolved Root_unresolved 103 1.56e-22   NR YP_010248457.1 265552 g63327 i0 54.9 11.5161290322581 82 37 56.7 0 25 270 401 482 YP_010248457.1 cytochrome c oxidase subunit 1 [Coscinodiscus granii] diamond 4998 103 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
31605133 31605133 PRJNA928559_P_NODE_42956_length_515_cov_1.712670_g41398_i0 PRJNA928559 42956 515 1.71267 8.8202505 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.52e-4   NR GAX13939.1 1519565 g41398 i0 24.4 1.78252427184466 172 120 96.7 3 1 498 737 904 GAX13939.1 hypothetical protein FisN_5Lh157 [Fistulifera solaris] diamond 918 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31612226 31612226 PRJNA928559_P_NODE_213916_length_242_cov_1.662722_g212347_i0 PRJNA928559 213916 242 1.662722 4.02378724 root 1 Root_unresolved Root_unresolved 67.8 4.43e-11   NR EJK67845.1 159749 g212347 i0 43 8.15702479338843 79 45 97.9 0 238 2 262 340 EJK67845.1 hypothetical protein THAOC_11060 [Thalassiosira oceanica] diamond 1974 67.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31643620 31643620 PRJNA928559_P_NODE_186956_length_253_cov_2.194444_g185387_i0 PRJNA928559 186956 253 2.194444 5.55194332 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 6.72e-14   NR KAL3780735.1 29204 g185387 i0 42.7 11.6561264822134 82 46 96 1 252 10 9 90 KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica] diamond 2949 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32522831 32522831 PRJNA928559_P_NODE_210099_length_244_cov_0.912281_g208530_i0 PRJNA928559 210099 244 0.912281 2.22596564 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 59.3 5.45e-8   NR CAJ1961699.1 2856 g208530 i0 39.5 2.84016393442623 76 43 89.8 1 230 12 1494 1569 CAJ1961699.1 unnamed protein product [Cylindrotheca closterium] diamond 693 59.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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