RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA1095825", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 22 ✖

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA1095825 · 22 ✖

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
5303826 5303826 PRJNA1095825_P_NODE_267145_length_246_cov_0.890173_g264082_i0 PRJNA1095825 267145 246 0.890173 2.18982558 Halamphora calidilacuna 2133758 SAR_Eukaryotes SAR_Eukaryotes 276 1.21e-69   NTclustered gi|1735236539|ref|NC_044464.1| 2133758 g264082 i0 89.189 10.1707317073171 222 22 90 2 1 221 49984 49764 Halamphora calidilacuna chloroplast, complete genome blastn 2502 276 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
14229145 14229145 PRJNA1095825_P_NODE_216892_length_264_cov_1.774869_g213829_i0 PRJNA1095825 216892 264 1.774869 4.68565416 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 127 6.4e-33   NR KAI2514036.1 210448 g213829 i0 68.6 2.95454545454545 86 26 96.6 1 257 3 41 126 KAI2514036.1 Calreticulin family [Fragilaria crotonensis] diamond 780 128 0.9921875 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26909481 26909481 PRJNA1095825_P_NODE_295062_length_241_cov_0.916667_g291999_i0 PRJNA1095825 295062 241 0.916667 2.20916747 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 103 1.79e-23   NR KAL3923636.1 3061772 g291999 i0 68.4 0.946058091286307 76 24 94.6 0 6 233 522 597 KAL3923636.1 MAG: hypothetical protein SGILL_001547 [Bacillariaceae sp.] diamond 228 103 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26972633 26972633 PRJNA1095825_P_NODE_255062_length_248_cov_0.880000_g251999_i0 PRJNA1095825 255062 248 0.88 2.1824 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 124 1.1000000000000001e-30   NR KAI2496366.1 210448 g251999 i0 73.7 9.12096774193548 76 20 91.9 0 243 16 189 264 KAI2496366.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 2262 124 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27320592 27320592 PRJNA1095825_P_NODE_292523_length_241_cov_1.797619_g289460_i0 PRJNA1095825 292523 241 1.797619 4.33226179 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 66.2 1.55e-11   NR CAB9517803.1 568900 g289460 i0 68.9 0.560165975103734 45 14 56 0 3 137 100 144 CAB9517803.1 expressed unknown protein [Seminavis robusta] diamond 135 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27974931 27974931 PRJNA1095825_P_NODE_272705_length_245_cov_0.895349_g269642_i0 PRJNA1095825 272705 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 53.1 8.42e-6   NR EJK63267.1 159749 g269642 i0 43.4 2.05714285714286 53 30 64.9 0 66 224 684 736 EJK63267.1 hypothetical protein THAOC_16087 [Thalassiosira oceanica] diamond 504 53.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28235930 28235930 PRJNA1095825_P_NODE_279046_length_244_cov_0.900585_g275983_i0 PRJNA1095825 279046 244 0.900585 2.1974274 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.16e-6   NR KAI2488787.1 210448 g275983 i0 44.3 2.15163934426229 88 37 97.1 4 238 2 41 125 KAI2488787.1 hypothetical protein MHU86_25841 [Fragilaria crotonensis] diamond 525 54.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28615177 28615177 PRJNA1095825_P_NODE_284347_length_243_cov_0.905882_g281284_i0 PRJNA1095825 284347 243 0.905882 2.20129326 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.2 7.4e-4   NR KAI2489564.1 210448 g281284 i0 68 0.308641975308642 25 8 30.9 0 77 3 18 42 KAI2489564.1 hypothetical protein MHU86_25033 [Fragilaria crotonensis] diamond 75 46.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28678404 28678404 PRJNA1095825_P_NODE_234007_length_252_cov_1.513966_g230944_i0 PRJNA1095825 234007 252 1.513966 3.81519432 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.27e-8   NR XP_002185010.1 556484 g230944 i0 57.1 1.4047619047619 49 21 58.3 0 147 1 296 344 XP_002185010.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 354 61.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28678405 28678405 PRJNA1095825_P_NODE_243987_length_250_cov_0.870056_g240924_i0 PRJNA1095825 243987 250 0.870056 2.17514 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.49e-12   NR KAL3801059.1 29204 g240924 i0 47.7 0.78 65 33 78 1 198 4 283 346 KAL3801059.1 hypothetical protein HJC23_002352 [Cyclotella cryptica] diamond 195 72.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29435713 29435713 PRJNA1095825_P_NODE_292630_length_241_cov_1.636905_g289567_i0 PRJNA1095825 292630 241 1.636905 3.94494105 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 147 1.5499999999999998e-42   NR GAX28646.1 1519565 g289567 i0 81.3 0.995850622406639 80 14 99.6 1 240 1 121 199 GAX28646.1 hypothetical protein FisN_1Hu561 [Fistulifera solaris] diamond 240 147 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29656641 29656641 PRJNA1095825_P_NODE_299270_length_232_cov_2.811321_g296207_i0 PRJNA1095825 299270 232 2.811321 6.52226472 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.37e-16   NR GKY94061.1 2872254 g296207 i0 53.9 8.63793103448276 76 35 98.3 0 4 231 192 267 GKY94061.1 hypothetical protein MPSEU_000372700 [Mayamaea pseudoterrestris] diamond 2004 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29837729 29837729 PRJNA1095825_P_NODE_173111_length_297_cov_1.031250_g170048_i0 PRJNA1095825 173111 297 1.03125 3.0628125 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 152 7.06e-41   NR KAI2497020.1 210448 g170048 i0 66.3 6.97979797979798 101 30 98 1 291 1 280 380 KAI2497020.1 Electron transfer flavoprotein-ubiquinone oxidoreductase [Fragilaria crotonensis] diamond 2073 152 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29909839 29909839 PRJNA1095825_P_NODE_293591_length_241_cov_0.916667_g290528_i0 PRJNA1095825 293591 241 0.916667 2.20916747 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 70.9 4.05e-12   NR CAB9524638.1 568900 g290528 i0 45.1 1.0207468879668 82 35 89.6 1 219 4 164 245 CAB9524638.1 unknown protein [Seminavis robusta] diamond 246 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30636139 30636139 PRJNA1095825_P_NODE_271073_length_245_cov_0.895349_g268010_i0 PRJNA1095825 271073 245 0.895349 2.19360505 Pseudictyota dubia 2749911 SAR_Eukaryotes SAR_Eukaryotes 99 6.300000000000001e-22   NR YP_009496750.1 2749911 g268010 i0 75.8 0.759183673469388 62 15 75.9 0 242 57 782 843 YP_009496750.1 RNA polymerase beta [Pseudictyota dubia] diamond 186 99 1 Eukaryota Sar   Bacillariophyta Mediophyceae Eupodiscales Odontellaceae Pseudictyota Pseudictyota dubia
31047383 31047383 PRJNA1095825_P_NODE_242295_length_250_cov_0.870056_g239232_i0 PRJNA1095825 242295 250 0.870056 2.17514 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 71.6 2.82e-12   NR KAL3922402.1 3061772 g239232 i0 59.7 0.744 62 25 74.4 0 247 62 1577 1638 KAL3922402.1 MAG: hypothetical protein SGILL_002225 [Bacillariaceae sp.] diamond 186 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
31070213 31070213 PRJNA1095825_P_NODE_217195_length_264_cov_1.612565_g214132_i0 PRJNA1095825 217195 264 1.612565 4.2571716 root 1 Root_unresolved Root_unresolved 75.5 1.46e-13   NR KAL3810038.1 382380 g214132 i0 53.9 3.46590909090909 76 33 86.4 1 35 262 628 701 KAL3810038.1 hypothetical protein ACHAXA_000207 [Cyclostephanos tholiformis] diamond 915 75.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
31101484 31101484 PRJNA1095825_P_NODE_279915_length_244_cov_0.900585_g276852_i0 PRJNA1095825 279915 244 0.900585 2.1974274 root 1 Root_unresolved Root_unresolved 92.4 1.22e-19   NR ACA60879.1 2850 g276852 i0 49.4 14.5204918032787 79 40 97.1 0 242 6 931 1009 ACA60879.1 gag-pol polyprotein [Phaeodactylum tricornutum] diamond 3543 92.8 0.995689655172414 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31426435 31426435 PRJNA1095825_P_NODE_274996_length_244_cov_1.801170_g271933_i0 PRJNA1095825 274996 244 1.80117 4.3948548 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 111 2.98e-26   NR KAL3944996.1 3061772 g271933 i0 74 0.94672131147541 77 18 92.2 1 2 226 100 176 KAL3944996.1 MAG: hypothetical protein SGBAC_000916 [Bacillariaceae sp.] diamond 231 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32090829 32090829 PRJNA1095825_P_NODE_278978_length_244_cov_0.900585_g275915_i0 PRJNA1095825 278978 244 0.900585 2.1974274 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 60.1 2.5e-8   NR KAI2490541.1 210448 g275915 i0 43.8 0.786885245901639 64 35 77.5 1 219 31 157 220 KAI2490541.1 hypothetical protein MHU86_24019 [Fragilaria crotonensis] diamond 192 60.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32185782 32185782 PRJNA1095825_P_NODE_243538_length_250_cov_0.870056_g240475_i0 PRJNA1095825 243538 250 0.870056 2.17514 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.58e-6   NR KAL3779935.1 29204 g240475 i0 62.7 0.612 51 15 58.8 2 148 2 171 219 KAL3779935.1 hypothetical protein HJC23_005432 [Cyclotella cryptica] diamond 153 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32502350 32502350 PRJNA1095825_P_NODE_285979_length_243_cov_0.905882_g282916_i0 PRJNA1095825 285979 243 0.905882 2.20129326 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 148 7.05e-42   NR KAG7366995.1 303405 g282916 i0 98.6 0.91358024691358 74 1 91.4 0 21 242 1 74 KAG7366995.1 methyltransferase [Nitzschia inconspicua] diamond 222 148 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);;