RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA315399 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
5488691 5488691 PRJNA315399_S_NODE_30645_length_246_cov_16.770335_g30444_i0 PRJNA315399 30645 246 16.770335 41.2550241 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 344 3.27e-90   NTclustered gi|1783488149|ref|NC_045244.1| 186039 g30444 i0 95.37 170.50406504065 216 10 88 0 15 230 4488 4703 Fragilariopsis cylindrus chloroplast, complete genome blastn 41944 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
5489018 5489018 PRJNA315399_S_NODE_56025_length_208_cov_4.467836_g55824_i0 PRJNA315399 56025 208 4.467836 9.29309888 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 69.4 1.81e-7   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g55824 i0 81.522 3.78365384615385 92 10 41 7 109 194 24555 24645 Coscinodiscus granii mitochondrion, complete sequence blastn 787 69.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
8035023 8035023 PRJNA315399_P_NODE_197227_length_185_cov_3.405405_g196779_i0 PRJNA315399 197227 185 3.405405 6.29999925 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.016   NTclustered gi|2633304288|gb|OR795085.1| 1923966 g196779 i0 100 0.302702702702703 28 0 15 0 152 179 15149 15176 Navicula sp. strain SZCZEY2262 plastid, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
8038027 8038027 PRJNA315399_S_NODE_182027_length_153_cov_4.120690_g181826_i0 PRJNA315399 182027 153 4.12069 6.3046557 Luticola goeppertiana 431370 SAR_Eukaryotes SAR_Eukaryotes 128 2.02e-25   NTclustered gi|167891911|emb|AM710522.1| 431370 g181826 i0 84.444 43.5294117647059 135 15 86 5 20 150 334 466 Luticola goeppertiana partial 28S rRNA gene, strain AT-104Gel12a blastn 6660 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola goeppertiana
15685462 15685462 PRJNA315399_P_NODE_367053_length_166_cov_2.782946_g366605_i0 PRJNA315399 367053 166 2.782946 4.61969036 Tryblionella apiculata 1003145 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.06e-13   NTclustered gi|2088232623|ref|NC_056791.1| 1003145 g366605 i0 88 2.49397590361446 75 9 45 0 76 150 4346 4272 Tryblionella apiculata isolate SZCZR1825 chloroplast, complete genome blastn 414 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Tryblionella Tryblionella apiculata
19511285 19511285 PRJNA315399_S_NODE_43636_length_223_cov_2.930108_g43435_i0 PRJNA315399 43636 223 2.930108 6.53414084 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.02   NTclustered gi|224013871|ref|XM_002296564.1| 296543 g43435 i0 100 0.125560538116592 28 0 13 0 126 153 217 190 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23333678 23333678 PRJNA315399_P_NODE_180839_length_186_cov_4.087248_g180391_i0 PRJNA315399 180839 186 4.087248 7.60228128 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.42e-4   NTclustered gi|2288719593|gb|OL415007.1| 2018706 g180391 i0 94.595 0.763440860215054 37 2 20 0 149 185 67203 67167 Haslea tsukamotoi isolate Jiaozhou Bay in China chloroplast, complete genome blastn 142 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi

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