RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where bioproject = "PRJNA404067", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 34 ✖

tax_clade 1

  • Sar · 34 ✖

bioproject 1

  • PRJNA404067 · 34 ✖

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
1689644 1689644 PRJNA404067_P_NODE_38042_length_201_cov_6.692857_g37655_i0 PRJNA404067 38042 201 6.692857 13.45264257 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 257 3.45e-64   NTclustered gi|2088232805|ref|NC_056793.1| 138539 g37655 i0 98.621 92.2189054726368 145 2 100 0 1 145 22495 22351 Navicula veneta isolate SZCZR1826 mitochondrion, complete genome blastn 18536 257 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
3632356 3632356 PRJNA404067_P_NODE_45063_length_167_cov_6.396226_g44676_i0 PRJNA404067 45063 167 6.396226 10.68169742 Gomphonella 2494557 SAR_Eukaryotes SAR_Eukaryotes 279 5.9e-71   NTclustered gi|671389961|gb|KF417661.1| 1530229 g44676 i0 99.355 74.8323353293413 155 0 93 1 13 167 552 705 Cymbellales sp. TF-2014 clone 05DB3_5 18S ribosomal RNA gene, partial sequence blastn 12497 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales     Cymbellales sp. TF-2014
4241964 4241964 PRJNA404067_P_NODE_44364_length_171_cov_5.045455_g43977_i0 PRJNA404067 44364 171 5.045455 8.62772805 Navicula arenaria 355634 SAR_Eukaryotes SAR_Eukaryotes 239 1.02e-58   NTclustered gi|2301268953|ref|NC_066075.1| 355634 g43977 i0 91.908 8.38011695906433 173 10 100 3 1 171 35267 35437 Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome blastn 1433 239 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
5518351 5518351 PRJNA404067_P_NODE_25525_length_221_cov_6.312500_g25138_i0 PRJNA404067 25525 221 6.3125 13.950625 Navicula arenaria 355634 SAR_Eukaryotes SAR_Eukaryotes 283 6.379999999999999e-72   NTclustered gi|2301268953|ref|NC_066075.1| 355634 g25138 i0 93.651 36.1719457013575 189 12 86 0 12 200 30350 30538 Navicula arenaria isolate Jiaozhou Bay in China chloroplast, complete genome blastn 7994 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
5518503 5518503 PRJNA404067_P_NODE_34145_length_205_cov_6.319444_g33758_i0 PRJNA404067 34145 205 6.319444 12.9548602 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 182 2.19e-41   NTclustered gi|1111668563|ref|NC_032029.1| 210441 g33758 i0 97.196 70.8292682926829 107 3 80 0 94 200 28454 28348 Asterionella formosa strain BGM1 mitochondrion, complete genome blastn 14520 182 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
8068191 8068191 PRJNA404067_P_NODE_45367_length_165_cov_57.038462_g44980_i0 PRJNA404067 45367 165 57.038462 94.1134623 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 174 2.82e-39   NTclustered gi|74325165|ref|NC_007405.1| 35128 g44980 i0 85.714 59.5212121212121 168 20 100 4 1 165 12577 12411 Thalassiosira pseudonana mitochondrion, complete genome blastn 9821 174 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
9342591 9342591 PRJNA404067_P_NODE_14428_length_273_cov_7.122642_g14041_i0 PRJNA404067 14428 273 7.122642 19.44481266 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 359 1.32e-94   NTclustered gi|2288719593|gb|OL415007.1| 2018706 g14041 i0 94.421 12.8901098901099 233 13 85 0 1 233 130701 130469 Haslea tsukamotoi isolate Jiaozhou Bay in China chloroplast, complete genome blastn 3519 359 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
10009593 10009593 PRJNA404067_P_NODE_44688_length_169_cov_6.398148_g44301_i0 PRJNA404067 44688 169 6.398148 10.81287012 Encyonema 216746 SAR_Eukaryotes SAR_Eukaryotes 307 2.73e-79   NTclustered gi|725655029|gb|KJ011639.1| 431330 g44301 i0 100 98.4852071005917 166 0 98 0 1 166 281 446 Encyonema minutum strain CH409 18S ribosomal RNA gene, partial sequence blastn 16644 307 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
12560019 12560019 PRJNA404067_P_NODE_26690_length_218_cov_7.509554_g26303_i0 PRJNA404067 26690 218 7.509554 16.37082772 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 296 8.06e-76   NTclustered gi|662012377|ref|NC_024080.1| 33640 g26303 i0 99.39 187.963302752294 164 0 92 1 56 218 80210 80047 Asterionellopsis glacialis chloroplast, complete genome blastn 40976 296 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
13168652 13168652 PRJNA404067_P_NODE_44731_length_169_cov_4.120370_g44344_i0 PRJNA404067 44731 169 4.12037 6.9634253 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 233 4.7e-57   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g44344 i0 91.716 6.88165680473373 169 12 100 1 1 169 15333 15167 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 1163 233 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
15717101 15717101 PRJNA404067_P_NODE_13633_length_282_cov_32.072398_g13246_i0 PRJNA404067 13633 282 32.072398 90.444162360000007 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 379 1.05e-100   NTclustered gi|2088232805|ref|NC_056793.1| 138539 g13246 i0 92.776 101.872340425532 263 17 93 1 1 263 21004 20744 Navicula veneta isolate SZCZR1826 mitochondrion, complete genome blastn 28728 379 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
15717220 15717220 PRJNA404067_P_NODE_22453_length_229_cov_11.577381_g22066_i0 PRJNA404067 22453 229 11.577381 26.51220249 Berkeleya fennica 1577906 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.31e-16   NTclustered gi|746001744|ref|NC_026126.1| 1577906 g22066 i0 88.75 0.349344978165939 80 8 34 1 141 219 4537 4616 Berkeleya fennica mitochondrion, complete genome blastn 80 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Berkeleya Berkeleya fennica
17659060 17659060 PRJNA404067_P_NODE_43494_length_177_cov_5.155172_g43107_i0 PRJNA404067 43494 177 5.155172 9.12465444 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 267 4.9099999999999996e-67   NTclustered gi|166204036|gb|EU260466.1| 426639 g43107 i0 93.82 100.338983050847 178 10 100 1 1 177 696 519 Diatoma tenue strain HYNP006 18S ribosomal RNA gene, partial sequence blastn 17760 267 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Diatoma Diatoma tenuis
18266530 18266530 PRJNA404067_P_NODE_9515_length_359_cov_8.268456_g9130_i0 PRJNA404067 9515 359 8.268456 29.68375704 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 497 3.63e-136   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g9130 i0 96.358 183.292479108635 302 11 85 0 4 305 68077 67776 Asterionella formosa chloroplast, complete genome blastn 65802 497 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
18932629 18932629 PRJNA404067_P_NODE_11835_length_307_cov_3.361789_g11449_i0 PRJNA404067 11835 307 3.361789 10.32069223 Fragilaria 33644 SAR_Eukaryotes SAR_Eukaryotes 468 2.4e-127   NTclustered gi|18698483|gb|AF417684.1| 185980 g11449 i0 97.112 73.5048859934853 277 8 90 0 1 277 324 48 Fragilaria capucina strain M1767 large subunit ribosomal RNA gene, partial sequence blastn 22566 468 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
21483157 21483157 PRJNA404067_P_NODE_39457_length_199_cov_69.630435_g39070_i0 PRJNA404067 39457 199 69.630435 138.56456565 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 333 5.509999999999998e-87   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g39070 i0 97.927 190.959798994975 193 2 96 2 9 199 70988 70796 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 38001 335 0.994029850746269 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
23366506 23366506 PRJNA404067_P_NODE_15139_length_266_cov_5.697561_g14752_i0 PRJNA404067 15139 266 5.697561 15.15551226 Pantocsekiella ocellata 2893599 SAR_Eukaryotes SAR_Eukaryotes 425 1.24e-114   NTclustered gi|98978941|gb|DQ512460.1| 2893599 g14752 i0 97.967 88.6616541353384 246 3 92 2 3 246 147 392 Cyclotella ocellata strain LB8 large subunit ribosomal RNA gene, partial sequence blastn 23584 425 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Pantocsekiella Pantocsekiella ocellata
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);;