RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA896554", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA896554 · 21 ✖

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
12351039 12351039 PRJNA896554_P_NODE_70410_length_453_cov_1.178947_g62870_i0 PRJNA896554 70410 453 1.178947 5.34062991 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 127 6.77e-32   NR KAI2495031.1 210448 g62870 i0 76.3 3.06622516556291 76 18 50.3 0 444 217 291 366 KAI2495031.1 Transketolase [Fragilaria crotonensis] diamond 1389 127 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
16173072 16173072 PRJNA896554_P_NODE_143793_length_258_cov_1.248649_g136253_i0 PRJNA896554 143793 258 1.248649 3.22151442 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 158 3.4199999999999993e-46   NR GAX18642.1 1519565 g136253 i0 80 2.96511627906977 85 17 98.8 0 2 256 135 219 GAX18642.1 succinate dehydrogenase (ubiquinone) iron-sulfur subunit [Fistulifera solaris] diamond 765 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
17449872 17449872 PRJNA896554_P_NODE_54034_length_610_cov_1.441341_g46565_i0 PRJNA896554 54034 610 1.441341 8.7921801 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 3.67e-19   NR KAL3759828.1 259834 g46565 i0 61.4 5.21311475409836 70 27 34.4 0 608 399 209 278 KAL3759828.1 hypothetical protein ACHAWU_007572 [Discostella pseudostelligera] diamond 3180 94 0.995744680851064 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
19998037 19998037 PRJNA896554_P_NODE_36536_length_992_cov_2.140370_g29925_i0 PRJNA896554 36536 992 2.14037 21.2324704 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 272 5.18e-82   NR KAL3770097.1 382360 g29925 i0 61 6.29939516129032 210 81 63.2 1 990 364 479 688 KAL3770097.1 hypothetical protein ACHAWO_006078 [Cyclotella atomus] diamond 6249 274 0.992700729927007 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
21273450 21273450 PRJNA896554_P_NODE_44917_length_766_cov_1.290043_g37673_i0 PRJNA896554 44917 766 1.290043 9.88172938 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 258 1.68e-79   NR GFH54232.1 426638 g37673 i0 71.8 8.93733681462141 177 47 68.1 1 3 524 321 497 GFH54232.1 dihydrolipoyl dehydrogenase [Chaetoceros tenuissimus] diamond 6846 258 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
25095307 25095307 PRJNA896554_P_NODE_100400_length_331_cov_1.449612_g92860_i0 PRJNA896554 100400 331 1.449612 4.79821572 root 1 Root_unresolved Root_unresolved 186 1.3e-57   NR KAK1740673.1 267567 g92860 i0 80 25.9214501510574 110 22 99.7 0 331 2 49 158 KAK1740673.1 40S ribosomal protein SA [Skeletonema marinoi] diamond 8580 186 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26612323 26612323 PRJNA896554_P_NODE_163581_length_245_cov_2.238372_g156041_i0 PRJNA896554 163581 245 2.238372 5.4840114 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.3e-6   NR GAX09970.1 1519565 g156041 i0 41.6 0.942857142857143 77 30 91.8 2 16 240 190 253 GAX09970.1 CUG-BP- and ETR3-like factor [Fistulifera solaris] diamond 231 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27498160 27498160 PRJNA896554_P_NODE_54183_length_608_cov_1.671028_g46714_i0 PRJNA896554 54183 608 1.671028 10.15985024 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 59.7 1.4e-6   NR KAG7339997.1 303405 g46714 i0 40.2 0.453947368421053 92 52 45.4 2 2 277 440 528 KAG7339997.1 KH domain containing protein [Nitzschia inconspicua] diamond 276 59.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27884625 27884625 PRJNA896554_P_NODE_89105_length_364_cov_1.058419_g81565_i0 PRJNA896554 89105 364 1.058419 3.85264516 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 165 3.46e-45   NR GAX15574.1 1519565 g81565 i0 63.3 3.96428571428571 120 42 98.9 1 5 364 154 271 GAX15574.1 sulfite reductase [Fistulifera solaris] diamond 1443 165 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28003415 28003415 PRJNA896554_P_NODE_124565_length_284_cov_1.459716_g117025_i0 PRJNA896554 124565 284 1.459716 4.14559344 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 111 8.2e-27   NR GAX18045.1 1519565 g117025 i0 58.5 2.98943661971831 94 38 99.3 1 284 3 282 374 GAX18045.1 sterol 24-C-methyltransferase [Fistulifera solaris] diamond 849 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28097877 28097877 PRJNA896554_P_NODE_151525_length_250_cov_2.203390_g143985_i0 PRJNA896554 151525 250 2.20339 5.508475 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.97e-4   NR CAB9508808.1 568900 g143985 i0 40 1.992 85 40 99.6 3 249 1 101 176 CAB9508808.1 Phenylalanine--tRNA ligase alpha subunit [Seminavis robusta] diamond 498 49.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28287211 28287211 PRJNA896554_P_NODE_80066_length_400_cov_1.113150_g72526_i0 PRJNA896554 80066 400 1.11315 4.4526 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 126 9.479999999999998e-31   NR GAX28155.1 1519565 g72526 i0 48.3 0.9 120 61 90 1 23 382 784 902 GAX28155.1 glutamate--cysteine ligase catalytic subunit [Fistulifera solaris] diamond 360 126 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28350505 28350505 PRJNA896554_P_NODE_74086_length_430_cov_1.983193_g66546_i0 PRJNA896554 74086 430 1.983193 8.5277299 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 185 4.01e-52   NR GKY93161.1 2872254 g66546 i0 67.5 2.74186046511628 126 39 87.2 2 376 2 46 170 GKY93161.1 hypothetical protein MPSEU_000284100 [Mayamaea pseudoterrestris] diamond 1179 185 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29431545 29431545 PRJNA896554_P_NODE_77129_length_414_cov_1.123167_g69589_i0 PRJNA896554 77129 414 1.123167 4.64991138 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 117 2e-27   NR XP_002290351.1 296543 g69589 i0 39.4 8.78985507246377 137 81 98.6 2 408 1 344 479 XP_002290351.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 3639 117 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
30181960 30181960 PRJNA896554_P_NODE_31452_length_1179_cov_3.362568_g25466_i0 PRJNA896554 31452 1179 3.362568 39.64467672 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 146 1.98e-36   NR KAL3938366.1 3061772 g25466 i0 35.7 0.656488549618321 258 155 62.8 6 1087 347 67 324 KAL3938366.1 MAG: hypothetical protein SGBAC_006716 [Bacillariaceae sp.] diamond 774 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30624203 30624203 PRJNA896554_P_NODE_168353_length_244_cov_0.883041_g160813_i0 PRJNA896554 168353 244 0.883041 2.15462004 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 47.4 8.22e-4   NR GKY95537.1 2872254 g160813 i0 39.4 0.872950819672131 71 36 87.3 1 218 6 1 64 GKY95537.1 hypothetical protein MPSEU_000515300 [Mayamaea pseudoterrestris] diamond 213 47.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
31098161 31098161 PRJNA896554_P_NODE_78235_length_408_cov_2.026866_g70695_i0 PRJNA896554 78235 408 2.026866 8.26961328 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 48.9 0.00148   NR VEU33700.1 183589 g70695 i0 81.5 0.595588235294118 27 5 19.9 0 1 81 414 440 VEU33700.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 243 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31382982 31382982 PRJNA896554_P_NODE_88156_length_367_cov_1.571429_g80616_i0 PRJNA896554 88156 367 1.571429 5.76714443 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 106 6.44e-25   NR KAL3920899.1 3061772 g80616 i0 74.6 0.940054495912807 59 15 48.2 0 190 366 59 117 KAL3920899.1 MAG: hypothetical protein SGILL_003032 [Bacillariaceae sp.] diamond 345 106 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32173942 32173942 PRJNA896554_P_NODE_166338_length_244_cov_1.649123_g158798_i0 PRJNA896554 166338 244 1.649123 4.02386012 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.86e-18   NR KAL3788067.1 382360 g158798 i0 57.6 0.725409836065574 59 25 72.5 0 66 242 111 169 KAL3788067.1 hypothetical protein ACHAWO_005912 [Cyclotella atomus] diamond 177 85.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32624033 32624033 PRJNA896554_P_NODE_173660_length_241_cov_1.833333_g166120_i0 PRJNA896554 173660 241 1.833333 4.41833253 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 102 5.26e-25   NR KAK1746763.1 267567 g166120 i0 68.6 2.62655601659751 70 22 87.1 0 31 240 36 105 KAK1746763.1 NADH dehydrogenase [ubiquinone] iron-sulfur protein 8 [Skeletonema marinoi] diamond 633 103 0.990291262135922 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32875999 32875999 PRJNA896554_P_NODE_82300_length_390_cov_1.457413_g74760_i0 PRJNA896554 82300 390 1.457413 5.6839107 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 157 5.2e-45   NR KAL3797826.1 29204 g74760 i0 58.9 7.84615384615385 129 53 99.2 0 4 390 7 135 KAL3797826.1 hypothetical protein HJC23_006864 [Cyclotella cryptica] diamond 3060 157 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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