RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA436017 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
430617 430617 PRJNA436017_P_NODE_12501_length_239_cov_1.316832_g12203_i0 PRJNA436017 12501 239 1.316832 3.14722848 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 99 2.72e-16   NTclustered gi|2310598807|gb|OK729582.1| 1923966 g12203 i0 76.168 32.0292887029289 214 35 87 12 1 208 33043 33246 Navicula sp. strain SZCZR1831 mitochondrion, complete genome blastn 7655 99 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
1705837 1705837 PRJNA436017_P_NODE_5682_length_378_cov_1.733138_g5386_i0 PRJNA436017 5682 378 1.733138 6.55126164 Lithodesmioides sp. mgcode 4 2914905 SAR_Eukaryotes SAR_Eukaryotes 233 1.1999999999999998e-56   NTclustered gi|2073953334|gb|MW849271.1| 2914905 g5386 i0 78.01 54.2328042328042 382 76 100 8 1 378 21382 21759 Lithodesmioides sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 20500 233 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmioides Lithodesmioides sp. mgcode 4
6192127 6192127 PRJNA436017_P_NODE_26865_length_157_cov_2.025000_g26567_i0 PRJNA436017 26865 157 2.025 3.17925 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 246 5.54e-61   NTclustered gi|2739942923|dbj|LC814783.1| 41457 g26567 i0 94.904 168.012738853503 157 8 100 0 1 157 4542 4386 Skeletonema pseudocostatum NIES-2843 chloroplast DNA, complete genome blastn 26378 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
8742010 8742010 PRJNA436017_P_NODE_8947_length_292_cov_1.654902_g8649_i0 PRJNA436017 8947 292 1.654902 4.83231384 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.59e-14   NTclustered gi|2852238112|gb|PQ498355.1| 2938944 g8649 i0 80.142 14.9554794520548 141 14 47 10 157 292 33865 33996 Pseudo-nitzschia sp. CNS00097 mitochondrion, complete genome blastn 4367 93.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia sp. CNS00097
10634720 10634720 PRJNA436017_P_NODE_25229_length_162_cov_1.672000_g24931_i0 PRJNA436017 25229 162 1.672 2.70864 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 87.9 3.7e-13   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g24931 i0 84.27 0.882716049382716 89 14 55 0 1 89 337 425 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 143 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11909526 11909526 PRJNA436017_P_NODE_19010_length_188_cov_1.033113_g18712_i0 PRJNA436017 19010 188 1.033113 1.94225244 Lithodesmium undulatum 59812 SAR_Eukaryotes SAR_Eukaryotes 309 8.66e-80   NTclustered gi|2316016826|gb|OL855988.1| 59812 g18712 i0 96.757 107.707446808511 185 6 98 0 1 185 78187 78371 Lithodesmium undulatum chloroplast, complete genome blastn 20249 309 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
13842504 13842504 PRJNA436017_P_NODE_1451_length_783_cov_2.407507_g512_i1 PRJNA436017 1451 783 2.407507 18.85077981 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 595 2.889999999999999e-165   NTclustered gi|1803023461|gb|MN937452.1| 2850 g512 i1 96.648 90.8939974457216 358 12 46 0 426 783 68727 68370 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 71170 601 0.990016638935108 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
13842521 13842521 PRJNA436017_P_NODE_17171_length_198_cov_1.925466_g16873_i0 PRJNA436017 17171 198 1.925466 3.81242268 Pinnularia 216736 SAR_Eukaryotes SAR_Eukaryotes 350 5.44e-92   NTclustered gi|354806246|gb|JN418720.1| 592728 g16873 i0 98.485 100.888888888889 198 3 100 0 1 198 497 694 Pinnularia neomajor strain Corsea 2 photosystem II reaction center protein D1 (psbA) gene, partial cds; chloroplast blastn 19976 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia neomajor
13842538 13842538 PRJNA436017_P_NODE_19131_length_187_cov_1.386667_g18833_i0 PRJNA436017 19131 187 1.386667 2.59306729 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 340 3.0499999999999998e-89   NTclustered gi|2194766164|gb|OK505009.1| 2856 g18833 i0 99.465 197.807486631016 187 1 100 0 1 187 19282 19468 Cylindrotheca closterium chloroplast, complete genome blastn 36990 340 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
15116793 15116793 PRJNA436017_P_NODE_12292_length_241_cov_2.465686_g11994_i0 PRJNA436017 12292 241 2.465686 5.94230326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.1 2.14e-12   NTclustered gi|9885790|gb|AF289048.1|AF289048 3005 g11994 i0 81.905 5.10373443983402 105 16 43 3 131 233 2687 2584 Rhizosolenia setigera internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 1230 86.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
19556749 19556749 PRJNA436017_P_NODE_26176_length_159_cov_1.598361_g25878_i0 PRJNA436017 26176 159 1.598361 2.54139399 Petrodictyon sp. 1951593 SAR_Eukaryotes SAR_Eukaryotes 89.8 1e-13   NTclustered gi|1143637875|gb|KX120301.1| 1951593 g25878 i0 85.714 46.4654088050314 84 12 53 0 76 159 128 211 Petrodictyon sp. isolate 3615.3 apocytochrome B (cob) gene, partial cds; mitochondrial blastn 7388 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Surirellales Surirellaceae Petrodictyon Petrodictyon sp.
22107591 22107591 PRJNA436017_P_NODE_6318_length_356_cov_2.156740_g6022_i0 PRJNA436017 6318 356 2.15674 7.6779944 Actinocyclus sp. mgcode 4 2914904 SAR_Eukaryotes SAR_Eukaryotes 169 3.2099999999999997e-37   NTclustered gi|2074156125|gb|MW413902.1| 2914904 g6022 i0 76.899 60.8820224719101 316 61 86 11 26 331 12257 11944 Actinocyclus sp. mgcode 4 mitochondrion, complete genome blastn 21674 169 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. mgcode 4

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