RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA404067" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA404067 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
26726877 26726877 PRJNA404067_P_NODE_40101_length_196_cov_56.125926_g39714_i0 PRJNA404067 40101 196 56.125926 110.00681496 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 47.8 9.47e-5   NR CAJ1967821.1 2856 g39714 i0 90.5 0.321428571428571 21 2 32.1 0 2 64 104 124 CAJ1967821.1 unnamed protein product [Cylindrotheca closterium] diamond 63 47.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26822430 26822430 PRJNA404067_P_NODE_44061_length_173_cov_6.375000_g43674_i0 PRJNA404067 44061 173 6.375 11.02875 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00785   NR KAI2489036.1 210448 g43674 i0 73.9 0.398843930635838 23 6 39.9 0 148 80 715 737 KAI2489036.1 hypothetical protein MHU86_25559 [Fragilaria crotonensis] diamond 69 43.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26917251 26917251 PRJNA404067_P_NODE_14082_length_277_cov_4.453704_g13695_i0 PRJNA404067 14082 277 4.453704 12.33676008 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 57 4.99e-7   NR KAI2497571.1 210448 g13695 i0 81.5 0.584837545126354 27 5 29.2 0 276 196 323 349 KAI2497571.1 serine-type endopeptidase [Fragilaria crotonensis] diamond 162 57 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26917258 26917258 PRJNA404067_P_NODE_30842_length_209_cov_5.216216_g30455_i0 PRJNA404067 30842 209 5.216216 10.90189144 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00357   NR GKY95571.1 2872254 g30455 i0 45.2 0.889952153110048 62 31 84.7 1 199 23 321 382 GKY95571.1 hypothetical protein MPSEU_000518500 [Mayamaea pseudoterrestris] diamond 186 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
27360039 27360039 PRJNA404067_P_NODE_20723_length_234_cov_18.011561_g20336_i0 PRJNA404067 20723 234 18.011561 42.14705274 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 71.6 2.19e-12   NR CAB9510492.1 568900 g20336 i0 58.2 0.705128205128205 55 22 69.2 1 232 71 1123 1177 CAB9510492.1 expressed unknown protein [Seminavis robusta] diamond 165 71.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27534529 27534529 PRJNA404067_P_NODE_13483_length_284_cov_11.179372_g13096_i0 PRJNA404067 13483 284 11.179372 31.74941648 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 65.9 4.61e-10   NR KAG7370377.1 303405 g13096 i0 61.7 1.97535211267606 47 18 49.6 0 230 90 1078 1124 KAG7370377.1 adenylate/guanylate cyclase [Nitzschia inconspicua] diamond 561 66.2 0.995468277945619 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27991548 27991548 PRJNA404067_P_NODE_16705_length_254_cov_8.549223_g16318_i0 PRJNA404067 16705 254 8.549223 21.71502642 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.84e-9   NR KAL3915404.1 3061772 g16318 i0 78.4 0.437007874015748 37 8 43.7 0 32 142 369 405 KAL3915404.1 MAG: hypothetical protein SGILL_005671 [Bacillariaceae sp.] diamond 111 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28338774 28338774 PRJNA404067_P_NODE_44866_length_168_cov_8.345794_g44479_i0 PRJNA404067 44866 168 8.345794 14.02093392 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.1 7.82e-4   NR CAB9496760.1 568900 g44479 i0 76.9 0.464285714285714 26 6 46.4 0 154 77 108 133 CAB9496760.1 expressed unknown protein [Seminavis robusta] diamond 78 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28401871 28401871 PRJNA404067_P_NODE_6006_length_524_cov_10.330454_g5636_i0 PRJNA404067 6006 524 10.330454 54.13157896 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 95.1 1.87e-19   NR CAB9516091.1 568900 g5636 i0 90.2 0.291984732824427 51 5 29.2 0 316 164 347 397 CAB9516091.1 U2AF 65 kDa subunit [Seminavis robusta] diamond 153 95.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28433516 28433516 PRJNA404067_P_NODE_28966_length_213_cov_2.855263_g28579_i0 PRJNA404067 28966 213 2.855263 6.08171019 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.54e-6   NR KAI2507979.1 210448 g28579 i0 88.5 0.366197183098592 26 3 36.6 0 213 136 409 434 KAI2507979.1 Oxidoreductase family [Fragilaria crotonensis] diamond 78 54.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28623028 28623028 PRJNA404067_P_NODE_17827_length_246_cov_57.275676_g17440_i0 PRJNA404067 17827 246 57.275676 140.89816296 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.33e-15   NR CAB9502849.1 568900 g17440 i0 76.2 0.51219512195122 42 10 51.2 0 245 120 174 215 CAB9502849.1 expressed unknown protein [Seminavis robusta] diamond 126 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28734378 28734378 PRJNA404067_P_NODE_41767_length_189_cov_4.914062_g41380_i0 PRJNA404067 41767 189 4.914062 9.28757718 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 58.5 6.56e-9   NR CAJ1945317.1 2856 g41380 i0 67.5 1.58730158730159 40 7 63.5 1 188 69 102 135 CAJ1945317.1 unnamed protein product [Cylindrotheca closterium] diamond 300 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28970240 28970240 PRJNA404067_P_NODE_19808_length_237_cov_15.323864_g19421_i0 PRJNA404067 19808 237 15.323864 36.31755768 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 82.4 3.68e-16   NR XP_002295230.1 296543 g19421 i0 61.3 0.784810126582278 62 19 78.5 1 237 52 477 533 XP_002295230.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 186 82.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28987179 28987179 PRJNA404067_P_NODE_17388_length_249_cov_26.500000_g17001_i0 PRJNA404067 17388 249 26.5 65.985 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 113 6.67e-27   NR VEU40489.1 183589 g17001 i0 91.5 4.97590361445783 59 5 71.1 0 12 188 1352 1410 VEU40489.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1239 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29096623 29096623 PRJNA404067_P_NODE_43508_length_177_cov_4.112069_g43121_i0 PRJNA404067 43508 177 4.112069 7.27836213 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.82e-5   NR KAI2507698.1 210448 g43121 i0 43.4 1.6271186440678 53 30 89.8 0 5 163 275 327 KAI2507698.1 hypothetical protein MHU86_6697 [Fragilaria crotonensis] diamond 288 50.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30454918 30454918 PRJNA404067_P_NODE_25913_length_220_cov_2.622642_g25526_i0 PRJNA404067 25913 220 2.622642 5.7698124 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 61.6 6.03e-9   NR KAI2500092.1 210448 g25526 i0 54.2 0.654545454545455 48 22 65.5 0 32 175 376 423 KAI2500092.1 protein tyrosine kinase [Fragilaria crotonensis] diamond 144 61.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31307691 31307691 PRJNA404067_P_NODE_42795_length_183_cov_7.885246_g42408_i0 PRJNA404067 42795 183 7.885246 14.43000018 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.29e-5   NR KAI2500383.1 210448 g42408 i0 62.5 0.655737704918033 40 15 65.6 0 183 64 282 321 KAI2500383.1 hypothetical protein MHU86_14126 [Fragilaria crotonensis] diamond 120 50.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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