RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA473201 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
1719328 1719328 PRJNA473201_P_NODE_75502_length_246_cov_0.890173_g74760_i0 PRJNA473201 75502 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 9.57e-25   NR CAJ1931814.1 2856 g74760 i0 66.7 22.7682926829268 69 23 84.1 0 39 245 9 77 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 5601 104 0.990384615384615 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
20845999 20845999 PRJNA473201_P_NODE_70077_length_249_cov_0.875000_g69335_i0 PRJNA473201 70077 249 0.875 2.17875 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 92 1.61e-19   NR XBC19452.1 1436140 g69335 i0 57.8 1.87951807228916 83 33 100 1 1 249 346 426 XBC19452.1 glutathione synthase [Ulnaria acus] diamond 468 92 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
22120127 22120127 PRJNA473201_P_NODE_29698_length_362_cov_2.162630_g28956_i0 PRJNA473201 29698 362 2.16263 7.8287206 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 118 1.26e-31   NR EJK75259.1 159749 g28956 i0 63.6 1.43370165745856 88 32 72.9 0 266 3 9 96 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 519 118 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27170802 27170802 PRJNA473201_P_NODE_70802_length_249_cov_0.875000_g70060_i0 PRJNA473201 70802 249 0.875 2.17875 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.62e-5   NR KAG7344243.1 303405 g70060 i0 35.4 1.96385542168675 82 48 98.8 3 248 3 563 639 KAG7344243.1 hypothetical protein IV203_022251 [Nitzschia inconspicua] diamond 489 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27676665 27676665 PRJNA473201_P_NODE_52944_length_284_cov_30.933649_g52202_i0 PRJNA473201 52944 284 30.933649 87.85156316 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 53.5 1e-5   NR KAI2502745.1 210448 g52202 i0 53.1 0.517605633802817 49 23 51.8 0 2 148 116 164 KAI2502745.1 hypothetical protein MHU86_11730 [Fragilaria crotonensis] diamond 147 53.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28402624 28402624 PRJNA473201_P_NODE_77046_length_245_cov_0.895349_g76304_i0 PRJNA473201 77046 245 0.895349 2.19360505 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 100 3.76e-24   NR OEU08698.1 635003 g76304 i0 60.5 0.991836734693878 81 29 95.5 1 5 238 7 87 OEU08698.1 putative glutathione S-transferase [Fragilariopsis cylindrus CCMP1102] diamond 243 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29065809 29065809 PRJNA473201_P_NODE_81428_length_243_cov_0.905882_g80686_i0 PRJNA473201 81428 243 0.905882 2.20129326 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 62.8 3.23e-9   NR KAL3760706.1 259834 g80686 i0 41.8 3.33333333333333 67 37 82.7 1 243 43 328 392 KAL3760706.1 hypothetical protein ACHAWU_000026 [Discostella pseudostelligera] diamond 810 62.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31324598 31324598 PRJNA473201_P_NODE_37455_length_326_cov_1.217391_g36713_i0 PRJNA473201 37455 326 1.217391 3.96869466 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 161 5.01e-45   NR KAG7341965.1 303405 g36713 i0 73.6 7.82208588957055 106 27 97.5 1 325 8 300 404 KAG7341965.1 preprotein translocase subunit Sec& domain containing protein [Nitzschia inconspicua] diamond 2550 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31530091 31530091 PRJNA473201_P_NODE_86376_length_238_cov_2.436364_g85634_i0 PRJNA473201 86376 238 2.436364 5.79854632 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 62 1.19e-9   NR CAJ1966799.1 2856 g85634 i0 54.2 1.34873949579832 48 22 60.5 0 57 200 129 176 CAJ1966799.1 unnamed protein product [Cylindrotheca closterium] diamond 321 62 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32289572 32289572 PRJNA473201_P_NODE_52299_length_286_cov_1.600939_g51557_i0 PRJNA473201 52299 286 1.600939 4.57868554 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 88.2 8.29e-20   NR GKY91745.1 2872254 g51557 i0 51.6 1.65734265734266 93 31 96.5 3 7 282 14 93 GKY91745.1 hypothetical protein MPSEU_000146200 [Mayamaea pseudoterrestris] diamond 474 88.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32904802 32904802 PRJNA473201_P_NODE_10020_length_638_cov_22.814159_g9291_i0 PRJNA473201 10020 638 22.814159 145.55433442 root 1 Root_unresolved Root_unresolved 114 1.14e-26   NR AAX82959.1 2843 g9291 i0 45 7.27429467084639 140 77 65.8 0 150 569 68 207 AAX82959.1 photosystem II protein D2, partial [Skeletonema costatum] diamond 4641 115 0.991304347826087 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum

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