RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA870096", 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 · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA870096 · 18 ✖

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
14878078 14878078 PRJNA870096_S_NODE_39952_length_281_cov_1.789916_g38288_i0 PRJNA870096 39952 281 1.789916 5.02966396 Nitzschia putrida 2742595 SAR_Eukaryotes SAR_Eukaryotes 95.3 4.24e-15   NTclustered gi|1955898040|dbj|LC600866.1| 2742595 g38288 i0 91.304 6.93238434163701 69 6 25 0 25 93 19433 19365 Nitzschia putrida NIES-4239 mitochondrial DNA, nearly complete genome blastn 1948 95.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia putrida
22914999 22914999 PRJNA870096_S_NODE_51658_length_245_cov_1.400990_g49994_i0 PRJNA870096 51658 245 1.40099 3.4324255 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 67 6.35e-11   NR CAB9512736.1 568900 g49994 i0 49.2 1.59183673469388 65 28 79.6 1 33 227 223 282 CAB9512736.1 expressed unknown protein [Seminavis robusta] diamond 390 67 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
26865616 26865616 PRJNA870096_S_NODE_22581_length_380_cov_2.350148_g20920_i0 PRJNA870096 22581 380 2.350148 8.9305624 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 172 4.51e-50   NR CAJ1937478.1 2856 g20920 i0 66.9 1.86315789473684 118 39 93.2 0 25 378 166 283 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 708 172 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27497662 27497662 PRJNA870096_S_NODE_138563_length_152_cov_1.834862_g136899_i0 PRJNA870096 138563 152 1.834862 2.78899024 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 40.4 0.0451   NR KAG7361490.1 303405 g136899 i0 47.1 0.671052631578947 34 18 67.1 0 148 47 108 141 KAG7361490.1 hypothetical protein IV203_036591 [Nitzschia inconspicua] diamond 102 40.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28097428 28097428 PRJNA870096_S_NODE_46225_length_260_cov_1.327189_g44561_i0 PRJNA870096 46225 260 1.327189 3.4506914 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 79.3 6.03e-15   NR EJK76346.1 159749 g44561 i0 50.6 2.80384615384615 81 40 93.5 0 250 8 597 677 EJK76346.1 hypothetical protein THAOC_01894 [Thalassiosira oceanica] diamond 729 79.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28665942 28665942 PRJNA870096_S_NODE_42407_length_272_cov_1.676856_g40743_i0 PRJNA870096 42407 272 1.676856 4.56104832 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 111 3.25e-26   NR KAL3771149.1 259834 g40743 i0 56.3 0.882352941176471 80 34 88.2 1 2 241 2182 2260 KAL3771149.1 hypothetical protein ACHAWU_004772 [Discostella pseudostelligera] diamond 240 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29107931 29107931 PRJNA870096_S_NODE_116208_length_165_cov_1.180328_g114544_i0 PRJNA870096 116208 165 1.180328 1.9475412 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00109   NR OEU07784.1 635003 g114544 i0 34.5 2 55 36 100 0 1 165 420 474 OEU07784.1 hypothetical protein FRACYDRAFT_250810 [Fragilariopsis cylindrus CCMP1102] diamond 330 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29486486 29486486 PRJNA870096_S_NODE_28970_length_333_cov_2.137931_g27306_i0 PRJNA870096 28970 333 2.137931 7.11931023 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 84 1.38e-16   NR YP_010533567.1 97227 g27306 i0 78.7 0.846846846846847 47 10 42.3 0 331 191 274 320 YP_010533567.1 NADH dehydrogenase subunit 7 [Gomphonema parvulum] diamond 282 84 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
29549695 29549695 PRJNA870096_S_NODE_52650_length_242_cov_3.135678_g50986_i0 PRJNA870096 52650 242 3.135678 7.58834076 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.76e-20   NR GAX12276.1 1519565 g50986 i0 58.6 2.57851239669421 70 29 86.8 0 2 211 125 194 GAX12276.1 inosine triphosphate pyrophosphatase [Fistulifera solaris] diamond 624 90.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30118248 30118248 PRJNA870096_S_NODE_56772_length_233_cov_1.515789_g55108_i0 PRJNA870096 56772 233 1.515789 3.53178837 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.13e-10   NR KAL3801534.1 29204 g55108 i0 42 3.07725321888412 81 40 97.9 2 4 231 291 369 KAL3801534.1 hypothetical protein HJC23_000972, partial [Cyclotella cryptica] diamond 717 66.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30442563 30442563 PRJNA870096_S_NODE_82373_length_193_cov_2.880000_g80709_i0 PRJNA870096 82373 193 2.88 5.5584 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72 5.06e-13   NR CAJ1941722.1 2856 g80709 i0 51.6 1.94300518134715 64 29 96.4 1 7 192 218 281 CAJ1941722.1 unnamed protein product [Cylindrotheca closterium] diamond 375 72 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30781874 30781874 PRJNA870096_S_NODE_69374_length_210_cov_1.844311_g67710_i0 PRJNA870096 69374 210 1.844311 3.8730531 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00208   NR KAL3775636.1 382360 g67710 i0 65.4 0.371428571428571 26 9 37.1 0 4 81 1447 1472 KAL3775636.1 hypothetical protein ACHAWO_001903 [Cyclotella atomus] diamond 78 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
31477447 31477447 PRJNA870096_S_NODE_73416_length_204_cov_2.291925_g71752_i0 PRJNA870096 73416 204 2.291925 4.675527 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00316   NR KAI2510664.1 210448 g71752 i0 36.4 0.970588235294118 66 34 97.1 2 201 4 80 137 KAI2510664.1 Macro domain [Fragilaria crotonensis] diamond 198 44.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32363317 32363317 PRJNA870096_S_NODE_27719_length_341_cov_5.023490_g26055_i0 PRJNA870096 27719 341 5.02349 17.1301009 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 99.8 5.1999999999999985e-24   NR KAK1733291.1 267567 g26055 i0 46.6 0.906158357771261 103 55 90.6 0 339 31 48 150 KAK1733291.1 MAPEG family protein [Skeletonema marinoi] diamond 309 99.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32363319 32363319 PRJNA870096_S_NODE_59019_length_228_cov_3.464865_g57355_i0 PRJNA870096 59019 228 3.464865 7.8998922 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 52.4 3.64e-6   NR KAL3760658.1 259834 g57355 i0 46 1.46052631578947 63 31 78.9 2 2 181 92 154 KAL3760658.1 hypothetical protein ACHAWU_002168 [Discostella pseudostelligera] diamond 333 52.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32592641 32592641 PRJNA870096_S_NODE_49059_length_251_cov_4.177885_g47395_i0 PRJNA870096 49059 251 4.177885 10.48649135 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 152 4.64e-44   NR KAL3779933.1 29204 g47395 i0 82.9 7.8406374501992 82 14 98 0 6 251 83 164 KAL3779933.1 hypothetical protein HJC23_005430, partial [Cyclotella cryptica] diamond 1968 152 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32686874 32686874 PRJNA870096_S_NODE_78540_length_198_cov_1.238710_g76876_i0 PRJNA870096 78540 198 1.23871 2.4526458 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.3 6.32e-15   NR KAI2507554.1 210448 g76876 i0 61.8 4.12121212121212 55 21 83.3 0 180 16 89 143 KAI2507554.1 histone H3 [Fragilaria crotonensis] diamond 816 74.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32804831 32804831 PRJNA870096_S_NODE_35700_length_298_cov_4.423529_g34036_i0 PRJNA870096 35700 298 4.423529 13.18211642 Stephanopyxis turris 515487 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.93e-24   NR QYC61902.1 515487 g34036 i0 56.3 1.83221476510067 96 38 92.6 1 292 17 20 115 QYC61902.1 ribosomal protein L16 [Stephanopyxis turris] diamond 546 99.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Stephanopyxidaceae Stephanopyxis Stephanopyxis turris

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