RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA994052" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA994052 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28132112 28132112 PRJNA994052_P_NODE_43445_length_252_cov_26.586592_g42197_i0 PRJNA994052 43445 252 26.586592 66.99821184 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.82e-4   NR KAI2513306.1 210448 g42197 i0 42 1.19047619047619 50 29 59.5 0 2 151 617 666 KAI2513306.1 ubiquitin-specific protease [Fragilaria crotonensis] diamond 300 48.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28731912 28731912 PRJNA994052_P_NODE_29467_length_283_cov_29.914286_g28225_i0 PRJNA994052 29467 283 29.914286 84.65742938 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 52 1.32e-5   NR KAL3770480.1 2934178 g28225 i0 74.2 0.328621908127208 31 8 32.9 0 201 109 28 58 KAL3770480.1 hypothetical protein ACHAW5_001493 [Stephanodiscus triporus] diamond 93 52 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
29274330 29274330 PRJNA994052_P_NODE_56489_length_231_cov_27.449367_g55234_i0 PRJNA994052 56489 231 27.449367 63.40803777 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 48.1 3.77e-4   NR KAL3790979.1 382360 g55234 i0 45.2 2.18181818181818 62 21 80.5 2 191 6 41 89 KAL3790979.1 hypothetical protein ACHAWO_000139 [Cyclotella atomus] diamond 504 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29305975 29305975 PRJNA994052_P_NODE_58189_length_228_cov_273.703226_g56933_i0 PRJNA994052 58189 228 273.703226 624.04335528 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.1 8.35e-4   NR EJK58441.1 159749 g56933 i0 73.1 0.697368421052632 26 7 34.2 0 2 79 7 32 EJK58441.1 hypothetical protein THAOC_21443 [Thalassiosira oceanica] diamond 159 45.4 0.993392070484582 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29647121 29647121 PRJNA994052_P_NODE_40650_length_257_cov_56.989130_g39403_i0 PRJNA994052 40650 257 56.98913 146.4620641 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 96.7 4.77e-21   NR GFH43592.1 426638 g39403 i0 88.7 0.618677042801556 53 6 61.9 0 255 97 658 710 GFH43592.1 transketolase [Chaetoceros tenuissimus] diamond 159 96.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31258781 31258781 PRJNA994052_P_NODE_61135_length_224_cov_40.986755_g59879_i0 PRJNA994052 61135 224 40.986755 91.8103312 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 62.8 7.64e-10   NR GAX14273.1 1519565 g59879 i0 73.5 1.3125 49 13 65.6 0 221 75 153 201 GAX14273.1 large subunit ribosomal protein L13Ae [Fistulifera solaris] diamond 294 62.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31512017 31512017 PRJNA994052_P_NODE_67936_length_215_cov_21.471831_g66680_i0 PRJNA994052 67936 215 21.471831 46.16443665 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 59.3 3.33e-8   NR KAL3794969.1 382360 g66680 i0 90 0.418604651162791 30 3 41.9 0 213 124 303 332 KAL3794969.1 hypothetical protein ACHAWO_009928 [Cyclotella atomus] diamond 90 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus

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