RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", 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

  • blastn · 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
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

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