RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB12296" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJEB12296 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
32925110 32925110 PRJEB12296_S_NODE_12985_length_163_cov_3.164062_g12953_i0 PRJEB12296 12985 163 3.164062 5.15742106 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.23e-14   NR CDW79704.1 5949 g12953 i0 60.4 1.95092024539877 53 21 97.5 0 163 5 188 240 CDW79704.1 60s ribosomal protein l7 [Stylonychia lemnae] diamond 318 75.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32956669 32956669 PRJEB12296_S_NODE_9730_length_174_cov_2.424460_g9698_i0 PRJEB12296 9730 174 2.42446 4.2185604 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 47 4.85e-4   NR VEU38490.1 183589 g9698 i0 64.5 2.13793103448276 31 11 53.4 0 1 93 725 755 VEU38490.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 372 47.4 0.991561181434599 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
33024903 33024903 PRJEB12296_S_NODE_13852_length_161_cov_1.587302_g13820_i0 PRJEB12296 13852 161 1.587302 2.55555622 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00546   NR CAD8161077.1 43137 g13820 i0 50 1.93788819875776 52 26 96.9 0 1 156 63 114 CAD8161077.1 unnamed protein product [Paramecium octaurelia] diamond 312 42.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
33044751 33044751 PRJEB12296_S_NODE_5165_length_209_cov_3.419540_g5133_i0 PRJEB12296 5165 209 3.41954 7.1468386 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 70.9 9.88e-14   NR CAG9313846.1 1481888 g5133 i0 63 0.77511961722488 54 20 77.5 0 1 162 68 121 CAG9313846.1 unnamed protein product [Blepharisma stoltei] diamond 162 70.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
33061747 33061747 PRJEB12296_S_NODE_16773_length_154_cov_2.336134_g16741_i0 PRJEB12296 16773 154 2.336134 3.59764636 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.75e-7   NR CAD8150344.1 43138 g16741 i0 68.3 2.3961038961039 41 13 79.9 0 154 32 95 135 CAD8150344.1 unnamed protein product [Paramecium pentaurelia] diamond 369 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
33095953 33095953 PRJEB12296_S_NODE_12294_length_165_cov_1.846154_g12262_i0 PRJEB12296 12294 165 1.846154 3.0461541 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.97e-7   NR KAG9399323.1 112091 g12262 i0 68.2 0.8 44 12 76.4 1 1 126 127 170 KAG9399323.1 hypothetical protein AC1031_011670 [Aphanomyces cochlioides] diamond 132 55.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
33110081 33110081 PRJEB12296_S_NODE_10670_length_170_cov_3.970370_g10638_i0 PRJEB12296 10670 170 3.97037 6.749629 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.64e-8   NR XP_024573891.1 4781 g10638 i0 65.7 8.04705882352941 35 12 61.8 0 169 65 113 147 XP_024573891.1 60s ribosomal protein l27a [Plasmopara halstedii] diamond 1368 58.9 0.99320882852292 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
33130099 33130099 PRJEB12296_S_NODE_3927_length_231_cov_1.586735_g3895_i0 PRJEB12296 3927 231 1.586735 3.66535785 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.66e-6   NR EJK58442.1 159749 g3895 i0 70 0.519480519480519 40 12 51.9 0 86 205 24 63 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 120 51.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
33130135 33130135 PRJEB12296_S_NODE_8647_length_179_cov_2.090278_g8615_i0 PRJEB12296 8647 179 2.090278 3.74159762 Parmales sp. scaly parma 2962637 SAR_Eukaryotes SAR_Eukaryotes 74.3 2.34e-15   NR GMI63211.1 2962637 g8615 i0 54.7 2.79888268156425 53 24 88.8 0 179 21 60 112 GMI63211.1 hypothetical protein ScalyP_jg5217 [Parmales sp. scaly parma] diamond 501 74.3 1 Eukaryota Sar     Bolidophyceae Parmales     Parmales sp. scaly parma
33164114 33164114 PRJEB12296_S_NODE_4984_length_212_cov_2.412429_g4952_i0 PRJEB12296 4984 212 2.412429 5.11434948 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 58.5 6.44e-9   NR 2XZN_5 5911 g4952 i0 65.3 0.693396226415094 49 16 67.9 1 10 153 66 114 2XZN_5 Chain 5, Ribosomal Protein S26e Containing Protein [Tetrahymena thermophila] diamond 147 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33164132 33164132 PRJEB12296_S_NODE_7240_length_188_cov_3.490196_g7208_i0 PRJEB12296 7240 188 3.490196 6.56156848 Amphidinium carterae 2961 SAR_Eukaryotes SAR_Eukaryotes 45.4 9.76e-4   NR ADV03058.1 2961 g7208 i0 43.4 2.74468085106383 53 30 84.6 0 29 187 33 85 ADV03058.1 ribosomal protein S27a [Amphidinium carterae] diamond 516 45.4 1 Eukaryota Sar     Dinophyceae Amphidiniales Amphidiniaceae Amphidinium Amphidinium carterae
33178471 33178471 PRJEB12296_S_NODE_5488_length_205_cov_1.923529_g5456_i0 PRJEB12296 5488 205 1.923529 3.94323445 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 62.8 7.29e-10   NR XP_001009414.2 312017 g5456 i0 51.7 2.54634146341463 58 28 84.9 0 204 31 156 213 XP_001009414.2 50S ribosomal protein L1P [Tetrahymena thermophila SB210] diamond 522 62.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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