RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA495391" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA495391 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
27123817 27123817 PRJNA495391_S_NODE_64222_length_157_cov_1.114754_g63170_i0 PRJNA495391 64222 157 1.114754 1.75016378 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.33e-12   NR KAI2503052.1 210448 g63170 i0 78.9 2.92356687898089 38 8 72.6 0 3 116 454 491 KAI2503052.1 NADH dehydrogenase flavoprotein [Fragilaria crotonensis] diamond 459 71.2 0.995786516853933 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27361684 27361684 PRJNA495391_S_NODE_22483_length_253_cov_2.509174_g21431_i0 PRJNA495391 22483 253 2.509174 6.34821022 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 148 2.01e-42   NR KAL3785988.1 2934178 g21431 i0 98.6 1.69565217391304 72 1 85.4 0 251 36 33 104 KAL3785988.1 hypothetical protein ACHAW5_005367 [Stephanodiscus triporus] diamond 429 148 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
27834965 27834965 PRJNA495391_S_NODE_50004_length_175_cov_1.400000_g48952_i0 PRJNA495391 50004 175 1.4 2.45 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 70.5 2.05e-12   NR CAJ1924624.1 2856 g48952 i0 65.3 1.68 49 16 84 1 3 149 320 367 CAJ1924624.1 unnamed protein product [Cylindrotheca closterium] diamond 294 70.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28182153 28182153 PRJNA495391_S_NODE_41766_length_190_cov_1.561290_g40714_i0 PRJNA495391 41766 190 1.56129 2.966451 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00111   NR GAX24279.1 1519565 g40714 i0 56.7 0.473684210526316 30 13 47.4 0 2 91 492 521 GAX24279.1 hypothetical protein FisN_4Lh018 [Fistulifera solaris] diamond 90 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28276980 28276980 PRJNA495391_S_NODE_63766_length_157_cov_1.819672_g62714_i0 PRJNA495391 63766 157 1.819672 2.85688504 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.82e-6   NR XP_002183882.1 556484 g62714 i0 74.2 1.77707006369427 31 8 59.2 0 1 93 211 241 XP_002183882.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 279 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28450711 28450711 PRJNA495391_S_NODE_32206_length_214_cov_2.016760_g31154_i0 PRJNA495391 32206 214 2.01676 4.3158664 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.78e-5   NR KAL3756442.1 259834 g31154 i0 86.2 1.2196261682243 29 4 40.7 0 176 90 945 973 KAL3756442.1 hypothetical protein ACHAWU_001348 [Discostella pseudostelligera] diamond 261 50.8 0.992125984251969 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28466705 28466705 PRJNA495391_S_NODE_17486_length_286_cov_4.314741_g16434_i0 PRJNA495391 17486 286 4.314741 12.34015926 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 109 6e-28   NR KAL3810767.1 382380 g16434 i0 100 1.08041958041958 52 0 54.5 0 1 156 125 176 KAL3810767.1 hypothetical protein ACHAXA_001592 [Cyclostephanos tholiformis] diamond 309 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28466720 28466720 PRJNA495391_S_NODE_52766_length_171_cov_1.147059_g51714_i0 PRJNA495391 52766 171 1.147059 1.96147089 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 106 3.46e-25   NR KAL3816450.1 382380 g51714 i0 96 0.87719298245614 50 2 87.7 0 169 20 426 475 KAL3816450.1 hypothetical protein ACHAXA_001032, partial [Cyclostephanos tholiformis] diamond 150 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28656093 28656093 PRJNA495391_S_NODE_35167_length_205_cov_3.464706_g34115_i0 PRJNA495391 35167 205 3.464706 7.1026473 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 57 5.8e-9   NR KAK1739605.1 267567 g34115 i0 75 0.936585365853659 32 8 46.8 0 200 105 26 57 KAK1739605.1 hypothetical protein QTG54_009364 [Skeletonema marinoi] diamond 192 57 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28671680 28671680 PRJNA495391_S_NODE_63987_length_157_cov_1.483607_g62935_i0 PRJNA495391 63987 157 1.483607 2.32926299 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.03e-15   NR KAL3811474.1 382380 g62935 i0 85.4 1.56687898089172 41 6 78.3 0 3 125 1169 1209 KAL3811474.1 hypothetical protein ACHAXA_010726 [Cyclostephanos tholiformis] diamond 246 79.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28782123 28782123 PRJNA495391_S_NODE_39207_length_195_cov_3.043750_g38155_i0 PRJNA495391 39207 195 3.04375 5.9353125 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.63e-10   NR GKY99352.1 2872254 g38155 i0 61 0.630769230769231 41 16 63.1 0 195 73 750 790 GKY99352.1 hypothetical protein MPSEU_000890300 [Mayamaea pseudoterrestris] diamond 123 64.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28845282 28845282 PRJNA495391_S_NODE_51248_length_173_cov_1.427536_g50196_i0 PRJNA495391 51248 173 1.427536 2.46963728 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00118   NR CAB9504874.1 568900 g50196 i0 46 0.867052023121387 50 27 86.7 0 173 24 7 56 CAB9504874.1 receptor kinase [Seminavis robusta] diamond 150 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30487740 30487740 PRJNA495391_S_NODE_28193_length_227_cov_2.692708_g27141_i0 PRJNA495391 28193 227 2.692708 6.11244716 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 74.3 4.19e-14   NR XP_002179786.1 556484 g27141 i0 51.4 0.977973568281938 74 31 97.8 1 222 1 64 132 XP_002179786.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 222 74.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31119350 31119350 PRJNA495391_S_NODE_55115_length_167_cov_2.113636_g54063_i0 PRJNA495391 55115 167 2.113636 3.52977212 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 96.3 1.84e-22   NR KAL3792277.1 2934178 g54063 i0 83.6 0.988023952095808 55 9 98.8 0 166 2 209 263 KAL3792277.1 hypothetical protein ACHAW5_001103 [Stephanodiscus triporus] diamond 165 96.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
31499253 31499253 PRJNA495391_S_NODE_46116_length_181_cov_2.623288_g45064_i0 PRJNA495391 46116 181 2.623288 4.74815128 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 85.5 2.28e-19   NR KAL3762944.1 259834 g45064 i0 93.2 0.729281767955801 44 3 72.9 0 178 47 104 147 KAL3762944.1 hypothetical protein ACHAWU_001091 [Discostella pseudostelligera] diamond 132 85.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32258696 32258696 PRJNA495391_S_NODE_42318_length_189_cov_1.285714_g41266_i0 PRJNA495391 42318 189 1.285714 2.42999946 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 73.2 8.07e-15   NR UXN44176.1 1923966 g41266 i0 80.5 1.93650793650794 41 8 65.1 0 1 123 75 115 UXN44176.1 ribosomal protein S13 [Navicula sp.] diamond 366 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
32400611 32400611 PRJNA495391_S_NODE_15499_length_304_cov_2.405204_g14447_i0 PRJNA495391 15499 304 2.405204 7.31182016 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0086   NR CAJ1967358.1 2856 g14447 i0 31.5 1.51973684210526 89 58 86.8 2 275 12 685 771 CAJ1967358.1 unnamed protein product [Cylindrotheca closterium] diamond 462 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32448414 32448414 PRJNA495391_S_NODE_22139_length_255_cov_2.227273_g21087_i0 PRJNA495391 22139 255 2.227273 5.67954615 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 86.3 7.77e-18   NR KAL3808307.1 382380 g21087 i0 86 0.588235294117647 50 6 58.8 1 255 106 276 324 KAL3808307.1 hypothetical protein ACHAXA_001924 [Cyclostephanos tholiformis] diamond 150 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32794860 32794860 PRJNA495391_S_NODE_45480_length_182_cov_3.666667_g44428_i0 PRJNA495391 45480 182 3.666667 6.67333394 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0119   NR KAL3826492.1 382380 g44428 i0 91.3 0.741758241758242 23 2 37.9 0 181 113 311 333 KAL3826492.1 hypothetical protein ACHAXA_004329 [Cyclostephanos tholiformis] diamond 135 43.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis

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