RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1226487", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1226487 · 12 ✖

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
335111 335111 PRJNA1226487_P_NODE_8481_length_470_cov_2.831234_g8382_i0 PRJNA1226487 8481 470 2.831234 13.3067998 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 105 1.37e-25   NR EJK65532.1 159749 g8382 i0 69.6 1.71702127659574 69 21 44 0 469 263 82 150 EJK65532.1 hypothetical protein THAOC_13596 [Thalassiosira oceanica] diamond 807 105 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
13088537 13088537 PRJNA1226487_P_NODE_1431_length_844_cov_5.699092_g1353_i0 PRJNA1226487 1431 844 5.699092 48.10033648 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 357 1.36e-121   NR KAL3780735.1 29204 g1353 i0 69.6 5.18957345971564 247 66 85 3 12 728 3 248 KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica] diamond 4380 357 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
26933336 26933336 PRJNA1226487_P_NODE_6802_length_504_cov_4.204176_g6706_i0 PRJNA1226487 6802 504 4.204176 21.18904704 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 248 5.3399999999999997e-76   NR GFH45451.1 426638 g6706 i0 68.7 5.92857142857143 166 52 98.8 0 500 3 429 594 GFH45451.1 PLP-dependent transferase [Chaetoceros tenuissimus] diamond 2988 248 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28904139 28904139 PRJNA1226487_P_NODE_13748_length_404_cov_4.770393_g13647_i0 PRJNA1226487 13748 404 4.770393 19.27238772 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.00267   NR XP_002290483.1 296543 g13647 i0 45.5 0.787128712871287 55 30 40.8 0 397 233 573 627 XP_002290483.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 318 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29238972 29238972 PRJNA1226487_P_NODE_70509_length_246_cov_3.052023_g70407_i0 PRJNA1226487 70509 246 3.052023 7.50797658 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.47e-20   NR KAG7349794.1 303405 g70407 i0 56.3 10.7317073170732 80 34 97.6 1 242 3 59 137 KAG7349794.1 50S ribosomal protein L14e [Nitzschia inconspicua] diamond 2640 90.1 0.995560488346282 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29598733 29598733 PRJNA1226487_P_NODE_35130_length_301_cov_2.276316_g35028_i0 PRJNA1226487 35130 301 2.276316 6.85171116 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 114 7.16e-28   NR CAJ1937664.1 2856 g35028 i0 55.9 1.01661129568106 102 40 96.7 4 299 9 120 221 CAJ1937664.1 unnamed protein product [Cylindrotheca closterium] diamond 306 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30546669 30546669 PRJNA1226487_P_NODE_1913_length_761_cov_4.013081_g1828_i0 PRJNA1226487 1913 761 4.013081 30.53954641 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 173 9.95e-47   NR KAL3798039.1 29204 g1828 i0 58.5 1.72667542706965 147 60 58 1 321 761 312 457 KAL3798039.1 hypothetical protein HJC23_012330 [Cyclotella cryptica] diamond 1314 173 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30704583 30704583 PRJNA1226487_P_NODE_68254_length_248_cov_1.320000_g68152_i0 PRJNA1226487 68254 248 1.32 3.2736 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.63e-14   NR KAI2497300.1 210448 g68152 i0 54.1 0.895161290322581 74 33 88.3 1 221 3 541 614 KAI2497300.1 hydroxymethylglutaryl-CoA synthase [Fragilaria crotonensis] diamond 222 76.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31558328 31558328 PRJNA1226487_P_NODE_1836_length_772_cov_2.628040_g1752_i0 PRJNA1226487 1836 772 2.62804 20.2884688 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.0211   NR KAG7367597.1 303405 g1752 i0 32.8 0.532383419689119 137 75 47.4 4 613 248 80 214 KAG7367597.1 CUE domain containing protein [Nitzschia inconspicua] diamond 411 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32095840 32095840 PRJNA1226487_P_NODE_1018_length_952_cov_5.240046_g947_i0 PRJNA1226487 1018 952 5.240046 49.88523792 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 78.6 5.62e-13   NR KAL3777356.1 2934178 g947 i0 43.4 0.885504201680672 99 53 30.9 2 8 301 97 193 KAL3777356.1 hypothetical protein ACHAW5_002633 [Stephanodiscus triporus] diamond 843 78.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
32664768 32664768 PRJNA1226487_P_NODE_55040_length_265_cov_1.052083_g54938_i0 PRJNA1226487 55040 265 1.052083 2.78801995 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 129 1.36e-33   NR CAJ1937664.1 2856 g54938 i0 65.5 0.950943396226415 84 29 95.1 0 4 255 213 296 CAJ1937664.1 unnamed protein product [Cylindrotheca closterium] diamond 252 129 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32683503 32683503 PRJNA1226487_P_NODE_2700_length_687_cov_1.820847_g2609_i0 PRJNA1226487 2700 687 1.820847 12.50921889 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 164 1.3199999999999999e-42   NR KAL3796886.1 29204 g2609 i0 38.5 4.99126637554585 226 129 98.7 3 685 8 701 916 KAL3796886.1 hypothetical protein HJC23_008839 [Cyclotella cryptica] diamond 3429 164 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);;