RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA603943", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 23 ✖

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA603943 · 23 ✖

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
1853306 1853306 PRJNA603943_P_NODE_50782_length_257_cov_0.994565_g50590_i0 PRJNA603943 50782 257 0.994565 2.5560320500000002 root 1 Root_unresolved Root_unresolved 83.2 2.61e-16   NR KAI2510798.1 210448 g50590 i0 54.4 3.57198443579767 79 32 92.2 1 21 257 500 574 KAI2510798.1 tRNA methyltransferase [Fragilaria crotonensis] diamond 918 83.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
6955172 6955172 PRJNA603943_P_NODE_27746_length_339_cov_1.101504_g27554_i0 PRJNA603943 27746 339 1.101504 3.73409856 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 152 1.56e-42   NR CAJ1937478.1 2856 g27554 i0 65.2 0.991150442477876 112 39 99.1 0 2 337 154 265 CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] diamond 336 152 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
8230905 8230905 PRJNA603943_P_NODE_5527_length_646_cov_2.038394_g5344_i0 PRJNA603943 5527 646 2.038394 13.16802524 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 263 4.31e-86   NR CAJ1953473.1 2856 g5344 i0 91.5 2.9953560371517 129 11 59.9 0 646 260 88 216 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 1935 263 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
25369350 25369350 PRJNA603943_P_NODE_2240_length_939_cov_2.670901_g2097_i0 PRJNA603943 2240 939 2.670901 25.07976039 root 1 Root_unresolved Root_unresolved 343 6.509999999999998e-116   NR XP_002181180.1 556484 g2097 i0 79.2 4.96485623003195 207 43 66.1 0 2 622 11 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 4662 345 0.994202898550725 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26808511 26808511 PRJNA603943_P_NODE_59121_length_247_cov_2.080460_g58929_i0 PRJNA603943 59121 247 2.08046 5.1387362 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.39e-6   NR CAJ1946332.1 2856 g58929 i0 44.6 2.33198380566802 65 28 69.2 1 77 247 60 124 CAJ1946332.1 unnamed protein product [Cylindrotheca closterium] diamond 576 55.1 0.992740471869329 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27598916 27598916 PRJNA603943_P_NODE_42824_length_282_cov_2.038278_g42632_i0 PRJNA603943 42824 282 2.038278 5.74794396 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 113 7.93e-27   NR KAL3768840.1 259834 g42632 i0 65.1 3.58510638297872 86 30 91.5 0 1 258 884 969 KAL3768840.1 hypothetical protein ACHAWU_006941 [Discostella pseudostelligera] diamond 1011 113 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27662049 27662049 PRJNA603943_P_NODE_64304_length_244_cov_1.292398_g64112_i0 PRJNA603943 64304 244 1.292398 3.15345112 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.52e-8   NR KAL3786977.1 29204 g64112 i0 69.8 3.54098360655738 43 13 52.9 0 114 242 41 83 KAL3786977.1 hypothetical protein HJC23_005488 [Cyclotella cryptica] diamond 864 61.2 0.993464052287582 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28279926 28279926 PRJNA603943_P_NODE_57486_length_248_cov_1.565714_g57294_i0 PRJNA603943 57486 248 1.565714 3.88297072 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 101 7.449999999999999e-23   NR GFH55025.1 426638 g57294 i0 60.5 0.979838709677419 81 32 98 0 2 244 776 856 GFH55025.1 aminopeptidase with a membrane alanine aminopeptidase domain [Chaetoceros tenuissimus] diamond 243 101 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28577552 28577552 PRJNA603943_P_NODE_8947_length_529_cov_1.436404_g8759_i0 PRJNA603943 8947 529 1.436404 7.59857716 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 115 1.03e-28   NR KAI2494838.1 210448 g8759 i0 47.4 2.43289224952741 152 79 86.2 1 63 518 10 160 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 1287 115 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28627657 28627657 PRJNA603943_P_NODE_23987_length_358_cov_1.021053_g23795_i0 PRJNA603943 23987 358 1.021053 3.65536974 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.45e-5   NR KAK1735154.1 267567 g23795 i0 44.6 0.46927374301676 56 30 46.1 1 293 129 500 555 KAK1735154.1 hypothetical protein QTG54_014220 [Skeletonema marinoi] diamond 168 52.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
29164400 29164400 PRJNA603943_P_NODE_35889_length_306_cov_1.347639_g35697_i0 PRJNA603943 35889 306 1.347639 4.12377534 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00408   NR KAL3906002.1 3061772 g35697 i0 53.7 1.46078431372549 41 19 40.2 0 302 180 241 281 KAL3906002.1 MAG: hypothetical protein SGILL_009454 [Bacillariaceae sp.] diamond 447 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29650617 29650617 PRJNA603943_P_NODE_31070_length_325_cov_0.916667_g30878_i0 PRJNA603943 31070 325 0.916667 2.97916775 root 1 Root_unresolved Root_unresolved 96.7 6.81e-21   NR KAL3791379.1 382360 g30878 i0 45 8.79692307692308 111 53 95.1 1 320 12 250 360 KAL3791379.1 hypothetical protein ACHAWO_005003 [Cyclotella atomus] diamond 2859 97.4 0.992813141683778 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29682282 29682282 PRJNA603943_P_NODE_20630_length_378_cov_2.206557_g20438_i0 PRJNA603943 20630 378 2.206557 8.34078546 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 122 1.97e-29   NR KAI2498713.1 210448 g20438 i0 60.2 3.9047619047619 98 39 77.8 0 3 296 602 699 KAI2498713.1 glutamine synthetase [Fragilaria crotonensis] diamond 1476 122 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29985233 29985233 PRJNA603943_P_NODE_63111_length_245_cov_0.895349_g62919_i0 PRJNA603943 63111 245 0.895349 2.19360505 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 72 1.72e-14   NR GFH45849.1 426638 g62919 i0 40.8 1.73877551020408 71 42 86.9 0 222 10 1 71 GFH45849.1 hypothetical protein CTEN210_02323 [Chaetoceros tenuissimus] diamond 426 72 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30093034 30093034 PRJNA603943_P_NODE_33392_length_316_cov_0.950617_g33200_i0 PRJNA603943 33392 316 0.950617 3.00394972 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 165 4.31e-45   NR CAJ1962677.1 2856 g33200 i0 71.4 5.98101265822785 105 30 99.7 0 315 1 423 527 CAJ1962677.1 unnamed protein product [Cylindrotheca closterium] diamond 1890 165 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30364747 30364747 PRJNA603943_P_NODE_45332_length_275_cov_0.900990_g45140_i0 PRJNA603943 45332 275 0.90099 2.4777225 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 131 3e-34   NR KAL3812105.1 382380 g45140 i0 65.6 4.73454545454545 90 31 98.2 0 271 2 35 124 KAL3812105.1 hypothetical protein ACHAXA_009440, partial [Cyclostephanos tholiformis] diamond 1302 131 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30598612 30598612 PRJNA603943_P_NODE_64313_length_244_cov_1.245614_g64121_i0 PRJNA603943 64313 244 1.245614 3.03929816 root 1 Root_unresolved Root_unresolved 75.5 1.11e-13   NR XP_002183861.1 556484 g64121 i0 54.3 3 81 36 99.6 1 244 2 305 384 XP_002183861.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 732 75.9 0.994729907773386 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30978043 30978043 PRJNA603943_P_NODE_48714_length_263_cov_2.026316_g48522_i0 PRJNA603943 48714 263 2.026316 5.32921108 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 155 2.0599999999999996e-43   NR KAL3778461.1 29204 g48522 i0 79.3 6.9467680608365 87 18 99.2 0 262 2 354 440 KAL3778461.1 hypothetical protein HJC23_004401 [Cyclotella cryptica] diamond 1827 155 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31691842 31691842 PRJNA603943_P_NODE_42317_length_284_cov_1.094787_g42125_i0 PRJNA603943 42317 284 1.094787 3.10919508 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 75.9 1.38e-13   NR KAL3783915.1 2934178 g42125 i0 58.8 0.538732394366197 51 21 53.9 0 239 87 808 858 KAL3783915.1 hypothetical protein ACHAW5_011038 [Stephanodiscus triporus] diamond 153 75.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
31831431 31831431 PRJNA603943_P_NODE_28277_length_336_cov_1.581749_g28085_i0 PRJNA603943 28277 336 1.581749 5.31467664 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 164 9.39e-49   NR KAL3796763.1 29204 g28085 i0 78.4 1.98214285714286 111 24 99.1 0 335 3 23 133 KAL3796763.1 hypothetical protein HJC23_010910 [Cyclotella cryptica] diamond 666 165 0.993939393939394 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31863086 31863086 PRJNA603943_P_NODE_62517_length_245_cov_1.697674_g62325_i0 PRJNA603943 62517 245 1.697674 4.1593013 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.6e-6   NR XP_002285943.1 296543 g62325 i0 68.4 3.0734693877551 38 12 46.5 0 127 240 127 164 XP_002285943.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 753 53.9 0.992578849721707 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32039903 32039903 PRJNA603943_P_NODE_68798_length_242_cov_0.911243_g68606_i0 PRJNA603943 68798 242 0.911243 2.20520806 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.09e-11   NR CAB9519450.1 568900 g68606 i0 44 2.77685950413223 75 40 93 1 241 17 525 597 CAB9519450.1 acid type B receptor subunit 2 [Seminavis robusta] diamond 672 68.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32071480 32071480 PRJNA603943_P_NODE_67998_length_242_cov_0.911243_g67806_i0 PRJNA603943 67998 242 0.911243 2.20520806 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.13e-5   NR GKY92860.1 2872254 g67806 i0 48.3 1.43801652892562 58 26 71.9 1 177 4 445 498 GKY92860.1 hypothetical protein MPSEU_000255400 [Mayamaea pseudoterrestris] diamond 348 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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