RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA235310", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA235310 · 13 ✖

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
5470767 5470767 PRJNA235310_P_NODE_665_length_476_cov_10.426230_g639_i0 PRJNA235310 665 476 10.42623 49.6288548 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 1.73e-36   NR EJK75259.1 159749 g639 i0 63.1 0.649159663865546 103 37 64.3 1 353 48 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
14396406 14396406 PRJNA235310_P_NODE_3252_length_210_cov_1.658385_g3226_i0 PRJNA235310 3252 210 1.658385 3.4826085 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 125 3.91e-34   NR KAG7338300.1 303405 g3226 i0 89.9 17.9142857142857 69 7 98.6 0 210 4 85 153 KAG7338300.1 small GTP-binding domain protein [Nitzschia inconspicua] diamond 3762 125 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27060146 27060146 PRJNA235310_P_NODE_4062_length_187_cov_1.130435_g4036_i0 PRJNA235310 4062 187 1.130435 2.11391345 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 105 1.44e-27   NR CAJ1958730.1 2856 g4036 i0 75 2.90374331550802 60 15 96.3 0 181 2 1 60 CAJ1958730.1 unnamed protein product [Cylindrotheca closterium] diamond 543 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27453410 27453410 PRJNA235310_P_NODE_2563_length_240_cov_1.507853_g2537_i0 PRJNA235310 2563 240 1.507853 3.6188472 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.63e-17   NR KAL3910396.1 3061772 g2537 i0 60.5 5.75 76 27 91.3 1 219 1 89 164 KAL3910396.1 MAG: hypothetical protein SGARI_002141, partial [Bacillariaceae sp.] diamond 1380 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27611208 27611208 PRJNA235310_P_NODE_4924_length_169_cov_0.866667_g4898_i0 PRJNA235310 4924 169 0.866667 1.46466723 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 60.1 7.51e-10   NR GKY97253.1 2872254 g4898 i0 65.1 0.763313609467456 43 15 76.3 0 129 1 40 82 GKY97253.1 60S ribosomal protein L38 [Mayamaea pseudoterrestris] diamond 129 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27737703 27737703 PRJNA235310_P_NODE_5024_length_168_cov_1.310924_g4998_i0 PRJNA235310 5024 168 1.310924 2.20235232 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.15e-9   NR KAL3771631.1 259834 g4998 i0 68.8 3.46428571428571 48 15 85.7 0 21 164 136 183 KAL3771631.1 hypothetical protein ACHAWU_007748 [Discostella pseudostelligera] diamond 582 60.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28526938 28526938 PRJNA235310_P_NODE_4127_length_185_cov_1.382353_g4101_i0 PRJNA235310 4127 185 1.382353 2.55735305 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 45.8 1.36e-4   NR KAK1736342.1 267567 g4101 i0 41.3 2.22162162162162 46 26 73 1 6 140 7 52 KAK1736342.1 hypothetical protein QTG54_012942 [Skeletonema marinoi] diamond 411 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28905377 28905377 PRJNA235310_P_NODE_3368_length_206_cov_2.611465_g3342_i0 PRJNA235310 3368 206 2.611465 5.3796179 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 49.7 7.53e-5   NR KAL3794756.1 29204 g3342 i0 40.3 0.975728155339806 67 36 97.6 1 5 205 171 233 KAL3794756.1 hypothetical protein HJC23_012766 [Cyclotella cryptica] diamond 201 49.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29049809 29049809 PRJNA235310_P_NODE_2128_length_269_cov_0.886364_g2102_i0 PRJNA235310 2128 269 0.886364 2.38431916 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 112 2.16e-26   NR CAJ1949795.1 2856 g2102 i0 56.6 1.85130111524164 83 36 92.6 0 1 249 571 653 CAJ1949795.1 unnamed protein product [Cylindrotheca closterium] diamond 498 112 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31053745 31053745 PRJNA235310_P_NODE_4655_length_172_cov_1.308943_g4629_i0 PRJNA235310 4655 172 1.308943 2.25138196 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0365   NR CAB9514358.1 568900 g4629 i0 52.5 0.697674418604651 40 18 69.8 1 143 24 647 685 CAB9514358.1 expressed unknown protein [Seminavis robusta] diamond 120 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31432785 31432785 PRJNA235310_P_NODE_6336_length_162_cov_0.920354_g6310_i0 PRJNA235310 6336 162 0.920354 1.49097348 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 77.8 5.3e-15   NR KAL3782935.1 382360 g6310 i0 64.2 3.92592592592593 53 19 98.1 0 3 161 299 351 KAL3782935.1 hypothetical protein ACHAWO_011384 [Cyclotella atomus] diamond 636 77.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32526591 32526591 PRJNA235310_P_NODE_3099_length_216_cov_0.934132_g3073_i0 PRJNA235310 3099 216 0.934132 2.01772512 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 74.7 2.15e-14   NR KAI2494838.1 210448 g3073 i0 52.1 3.58333333333333 71 34 98.6 0 3 215 19 89 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 774 74.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32571951 32571951 PRJNA235310_P_NODE_1019_length_396_cov_2.443804_g993_i0 PRJNA235310 1019 396 2.443804 9.67746384 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 167 1.78e-50   NR KAK1745333.1 267567 g993 i0 64.5 5.48484848484848 121 43 91.7 0 393 31 14 134 KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi] diamond 2172 167 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi

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