RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA315399" 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

  • PRJNA315399 · 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
6760520 6760520 PRJNA315399_P_NODE_371886_length_165_cov_3.945312_g371438_i0 PRJNA315399 371886 165 3.945312 6.5097648 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.5e-12   NR QXE46253.1 303405 g371438 i0 73.1 1.89090909090909 52 8 83.6 1 14 151 42 93 QXE46253.1 50S ribosomal protein L5 [Nitzschia inconspicua] diamond 312 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
12545114 12545114 PRJNA315399_S_NODE_148870_length_161_cov_3.346774_g148669_i0 PRJNA315399 148870 161 3.346774 5.38830614 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 85.5 4.1e-18   NR KAG7367615.1 303405 g148669 i0 87 1.75155279503106 46 6 85.7 0 153 16 233 278 KAG7367615.1 acidic ribosomal protein P0 RplPO [Nitzschia inconspicua] diamond 282 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27169022 27169022 PRJNA315399_P_NODE_456562_length_155_cov_6.449153_g456114_i0 PRJNA315399 456562 155 6.449153 9.99618715 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0155   NR CAB9502967.1 568900 g456114 i0 57.7 1.50967741935484 26 11 50.3 0 155 78 291 316 CAB9502967.1 expressed unknown protein [Seminavis robusta] diamond 234 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28653465 28653465 PRJNA315399_P_NODE_221507_length_183_cov_7.691781_g221059_i0 PRJNA315399 221507 183 7.691781 14.07595923 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0129   NR KAL3920403.1 3061772 g221059 i0 81.8 0.360655737704918 22 4 36.1 0 75 10 49 70 KAL3920403.1 MAG: hypothetical protein SGILL_003281 [Bacillariaceae sp.] diamond 66 43.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30579684 30579684 PRJNA315399_P_NODE_446993_length_156_cov_7.436975_g446545_i0 PRJNA315399 446993 156 7.436975 11.601681 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.2 6.74e-4   NR KAI2510797.1 210448 g446545 i0 48.8 0.788461538461538 41 21 78.8 0 148 26 1311 1351 KAI2510797.1 AMP-binding enzyme [Fragilaria crotonensis] diamond 123 46.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30786985 30786985 PRJNA315399_S_NODE_189254_length_152_cov_1.573913_g189053_i0 PRJNA315399 189254 152 1.573913 2.39234776 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.31e-19   NR KAK1741393.1 267567 g189053 i0 87 1.81578947368421 46 6 90.8 0 140 3 258 303 KAK1741393.1 soluble NSF attachment protein [Skeletonema marinoi] diamond 276 90.1 0.992230854605993 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30801033 30801033 PRJNA315399_S_NODE_121274_length_170_cov_1.736842_g121073_i0 PRJNA315399 121274 170 1.736842 2.9526314 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.58e-6   NR GAX27613.1 1519565 g121073 i0 51 1.8 51 25 90 0 158 6 601 651 GAX27613.1 hypothetical protein FisN_13Hh298 [Fistulifera solaris] diamond 306 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31179936 31179936 PRJNA315399_P_NODE_44655_length_245_cov_3.331731_g44207_i0 PRJNA315399 44655 245 3.331731 8.16274095 Craticula sp. 2862135 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.1499999999999999e-23   NR XOB89985.1 2862135 g44207 i0 79.3 2.13061224489796 58 12 71 0 11 184 105 162 XOB89985.1 hypothetical chloroplast RF88 [Craticula sp.] diamond 522 97.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp.
31243451 31243451 PRJNA315399_P_NODE_495255_length_151_cov_10.052632_g494807_i0 PRJNA315399 495255 151 10.052632 15.17947432 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 48.9 6.79e-5   NR KAL3938584.1 3061772 g494807 i0 87.5 0.47682119205298 24 3 47.7 0 146 75 285 308 KAL3938584.1 MAG: hypothetical protein SGARI_001684 [Bacillariaceae sp.] diamond 72 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32097544 32097544 PRJNA315399_S_NODE_133118_length_166_cov_1.728682_g132917_i0 PRJNA315399 133118 166 1.728682 2.86961212 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52.8 3.58e-6   NR KAL3906936.1 3061772 g132917 i0 49 5.53012048192771 51 26 92.2 0 153 1 234 284 KAL3906936.1 MAG: hypothetical protein SGILL_009075, partial [Bacillariaceae sp.] diamond 918 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32855451 32855451 PRJNA315399_P_NODE_496440_length_151_cov_6.719298_g495992_i0 PRJNA315399 496440 151 6.719298 10.14613998 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 68.6 8.1e-12   NR YP_009028828.1 33640 g495992 i0 72.1 1.70860927152318 43 12 85.4 0 13 141 206 248 YP_009028828.1 c-type cytochrome biogenesis protein [Asterionellopsis glacialis] diamond 258 68.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis

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