RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA756891", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 26 ✖

tax_clade 1

  • Sar · 26 ✖

bioproject 1

  • PRJNA756891 · 26 ✖

analysis 1

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
4560436 4560436 PRJNA756891_P_NODE_3784_length_431_cov_1.254190_g3715_i0 PRJNA756891 3784 431 1.25419 5.4055589 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 7.079999999999999e-37   NR EJK75259.1 159749 g3715 i0 63.1 0.716937354988399 103 37 71 1 338 33 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
8385266 8385266 PRJNA756891_P_NODE_12147_length_251_cov_0.865169_g12078_i0 PRJNA756891 12147 251 0.865169 2.17157419 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.74e-17   NR CAJ1969398.1 2856 g12078 i0 51.8 0.99203187250996006 83 35 99.2 2 2 250 189 266 CAJ1969398.1 unnamed protein product [Cylindrotheca closterium] diamond 249 84.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
12211567 12211567 PRJNA756891_P_NODE_6850_length_328_cov_1.207843_g6781_i0 PRJNA756891 6850 328 1.207843 3.96172504 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.3e-16   NR XP_002289699.1 296543 g6781 i0 49.4 2.96341463414634 83 40 74.1 1 248 6 473 555 XP_002289699.1 ribonuclease, partial [Thalassiosira pseudonana CCMP1335] diamond 972 85.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
17310139 17310139 PRJNA756891_P_NODE_2854_length_496_cov_1.092199_g2786_i0 PRJNA756891 2854 496 1.092199 5.41730704 root 1 Root_unresolved Root_unresolved 278 1.64e-88   NR KAL3770959.1 259834 g2786 i0 81 74.3709677419355 163 31 98.6 0 3 491 207 369 KAL3770959.1 hypothetical protein ACHAWU_005288 [Discostella pseudostelligera] diamond 36888 280 0.992857142857143 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27021310 27021310 PRJNA756891_P_NODE_12242_length_251_cov_0.865169_g12173_i0 PRJNA756891 12242 251 0.865169 2.17157419 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.24e-12   NR CAJ1962282.1 2856 g12173 i0 47.6 0.752988047808765 63 33 75.3 0 189 1 14 76 CAJ1962282.1 unnamed protein product [Cylindrotheca closterium] diamond 189 69.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27252338 27252338 PRJNA756891_P_NODE_7263_length_320_cov_1.574899_g7194_i0 PRJNA756891 7263 320 1.574899 5.0396768 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 136 2.64e-35   NR KAL3787999.1 29204 g7194 i0 58.1 19.715625 105 43 97.5 1 5 316 334 438 KAL3787999.1 hypothetical protein HJC23_004070 [Cyclotella cryptica] diamond 6309 137 0.992700729927007 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27558245 27558245 PRJNA756891_P_NODE_10804_length_266_cov_1.994819_g10735_i0 PRJNA756891 10804 266 1.994819 5.30621854 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 109 7.69e-26   NR XP_002289678.1 296543 g10735 i0 64.7 0.958646616541353 85 30 95.9 0 4 258 74 158 XP_002289678.1 mannosyl-oligosaccharide 1,2-alpha-mannosidase [Thalassiosira pseudonana CCMP1335] diamond 255 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27631556 27631556 PRJNA756891_P_NODE_12184_length_251_cov_0.865169_g12115_i0 PRJNA756891 12184 251 0.865169 2.17157419 root 1 Root_unresolved Root_unresolved 108 3.62e-25   NR KAL3762498.1 259834 g12115 i0 71.4 5.29482071713147 70 20 83.7 0 212 3 82 151 KAL3762498.1 hypothetical protein ACHAWU_008201 [Discostella pseudostelligera] diamond 1329 109 0.990825688073395 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28073392 28073392 PRJNA756891_P_NODE_9765_length_279_cov_1.495146_g9696_i0 PRJNA756891 9765 279 1.495146 4.17145734 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 134 2.89e-34   NR KAL3761451.1 259834 g9696 i0 67.7 7 93 30 100 0 279 1 451 543 KAL3761451.1 hypothetical protein ACHAWU_007410 [Discostella pseudostelligera] diamond 1953 135 0.992592592592593 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28189709 28189709 PRJNA756891_P_NODE_5986_length_348_cov_1.680000_g5917_i0 PRJNA756891 5986 348 1.68 5.8464 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.83e-8   NR KAL3790838.1 382360 g5917 i0 43.9 0.706896551724138 82 33 70.7 1 103 348 106 174 KAL3790838.1 hypothetical protein ACHAWO_007935 [Cyclotella atomus] diamond 246 60.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
28505672 28505672 PRJNA756891_P_NODE_14127_length_246_cov_0.890173_g14058_i0 PRJNA756891 14127 246 0.890173 2.18982558 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 68.6 3.02e-11   NR KAI2493455.1 210448 g14058 i0 45.9 1.80487804878049 74 36 85.4 1 245 36 134 207 KAI2493455.1 importin alpha [Fragilaria crotonensis] diamond 444 68.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28632204 28632204 PRJNA756891_P_NODE_16327_length_241_cov_0.916667_g16258_i0 PRJNA756891 16327 241 0.916667 2.20916747 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 79 6.53e-15   NR GFH53639.1 426638 g16258 i0 58.7 0.784232365145228 63 26 78.4 0 196 8 6 68 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 189 79 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28632207 28632207 PRJNA756891_P_NODE_3707_length_436_cov_1.936639_g3638_i0 PRJNA756891 3707 436 1.936639 8.44374604 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 167 9.74e-48   NR KAI2505881.1 210448 g3638 i0 50.3 1.98853211009174 147 71 99.8 1 435 1 131 277 KAI2505881.1 histone deacetylase domain containing protein [Fragilaria crotonensis] diamond 867 167 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28768028 28768028 PRJNA756891_P_NODE_10107_length_275_cov_1.108911_g10038_i0 PRJNA756891 10107 275 1.108911 3.04950525 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 77.4 1.01e-14   NR GFH51649.1 426638 g10038 i0 67.3 2.62909090909091 49 16 53.5 0 16 162 3 51 GFH51649.1 hypothetical protein CTEN210_08125 [Chaetoceros tenuissimus] diamond 723 77.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29484229 29484229 PRJNA756891_P_NODE_2910_length_491_cov_1.021531_g2842_i0 PRJNA756891 2910 491 1.021531 5.01571721 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 127 1.55e-30   NR XP_002297489.1 296543 g2842 i0 41.3 2.89613034623218 160 91 95.9 1 489 19 626 785 XP_002297489.1 hypothetical protein THAPSDRAFT_bd1542 [Thalassiosira pseudonana CCMP1335] diamond 1422 127 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29651776 29651776 PRJNA756891_P_NODE_12590_length_250_cov_0.870056_g12521_i0 PRJNA756891 12590 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 80.5 1.87e-15   NR KAI2488595.1 210448 g12521 i0 44.6 3.156 92 37 93.6 1 236 3 1 92 KAI2488595.1 hypothetical protein MHU86_25649 [Fragilaria crotonensis] diamond 789 80.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29831776 29831776 PRJNA756891_P_NODE_2631_length_515_cov_1.045249_g2563_i0 PRJNA756891 2631 515 1.045249 5.38303235 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 101 4.52e-22   NR GKY93929.1 2872254 g2563 i0 42.9 2.17281553398058 119 63 68.7 2 134 487 73 187 GKY93929.1 hypothetical protein MPSEU_000359800 [Mayamaea pseudoterrestris] diamond 1119 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30116019 30116019 PRJNA756891_P_NODE_6212_length_342_cov_2.631970_g6143_i0 PRJNA756891 6212 342 2.63197 9.0013374 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 76.3 2.99e-14   NR GFH56819.1 426638 g6143 i0 35.6 0.912280701754386 104 67 91.2 0 315 4 59 162 GFH56819.1 hypothetical protein CTEN210_13295 [Chaetoceros tenuissimus] diamond 312 76.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31253587 31253587 PRJNA756891_P_NODE_2155_length_566_cov_4.602434_g2087_i0 PRJNA756891 2155 566 4.602434 26.04977644 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.68e-4   NR KAL3921617.1 3061772 g2087 i0 27.1 0.567137809187279 107 74 54.6 3 446 138 200 306 KAL3921617.1 MAG: hypothetical protein SGILL_002655, partial [Bacillariaceae sp.] diamond 321 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31390128 31390128 PRJNA756891_P_NODE_3416_length_452_cov_3.612137_g3348_i0 PRJNA756891 3416 452 3.612137 16.32685924 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 127 7.559999999999998e-34   NR CAJ1957230.1 2856 g3348 i0 46.6 14.8141592920354 148 79 98.2 0 8 451 53 200 CAJ1957230.1 unnamed protein product [Cylindrotheca closterium] diamond 6696 128 0.9921875 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31696399 31696399 PRJNA756891_P_NODE_15797_length_243_cov_0.905882_g15728_i0 PRJNA756891 15797 243 0.905882 2.20129326 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.51e-6   NR CAB9522167.1 568900 g15728 i0 45.5 1.90123456790123 77 39 93.8 2 11 238 67 141 CAB9522167.1 leucine rich repeat [Seminavis robusta] diamond 462 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31854514 31854514 PRJNA756891_P_NODE_3997_length_420_cov_2.170029_g3928_i0 PRJNA756891 3997 420 2.170029 9.1141218 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.36e-13   NR KAG7341189.1 303405 g3928 i0 33.6 0.871428571428571 122 74 82.9 2 389 42 13 133 KAG7341189.1 mitochondrial ribosomal protein L51 / S25 / CI-B8 domain containing protein [Nitzschia inconspicua] diamond 366 73.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32044435 32044435 PRJNA756891_P_NODE_5998_length_348_cov_1.120000_g5929_i0 PRJNA756891 5998 348 1.12 3.8976 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 146 6.239999999999999e-38   NR KAL3799299.1 29204 g5929 i0 60.9 1.99137931034483 115 45 99.1 0 346 2 570 684 KAL3799299.1 hypothetical protein HJC23_013024 [Cyclotella cryptica] diamond 693 146 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32076072 32076072 PRJNA756891_P_NODE_2278_length_552_cov_3.102296_g2210_i0 PRJNA756891 2278 552 3.102296 17.12467392 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 108 1.04e-25   NR GFH56819.1 426638 g2210 i0 37.2 1.03804347826087 191 106 99.5 5 551 3 11 195 GFH56819.1 hypothetical protein CTEN210_13295 [Chaetoceros tenuissimus] diamond 573 108 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32149275 32149275 PRJNA756891_P_NODE_16498_length_241_cov_0.916667_g16429_i0 PRJNA756891 16498 241 0.916667 2.20916747 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 79.3 4.78e-15   NR BAT25228.1 1444690 g16429 i0 77.6 2.63900414937759 49 11 61 0 148 2 18 66 BAT25228.1 host cell division cycle protein [Nitzschia sp. IriIs04] diamond 636 80.1 0.990012484394507 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. IriIs04
32582405 32582405 PRJNA756891_P_NODE_7819_length_310_cov_0.995781_g7750_i0 PRJNA756891 7819 310 0.995781 3.0869211 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.51e-17   NR KAG7336725.1 303405 g7750 i0 49.5 0.97741935483871 101 46 97.7 1 6 308 101 196 KAG7336725.1 HORMA domain containing protein [Nitzschia inconspicua] diamond 303 84.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua

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