RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA909412", 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 · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA909412 · 14 ✖

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
1249249 1249249 PRJNA909412_P_NODE_4401_length_249_cov_3.752381_g4260_i0 PRJNA909412 4401 249 3.752381 9.34342869 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 424 4.15e-114   NTclustered gi|952988067|gb|KT072974.1| 85094 g4260 i0 97.959 98.4136546184739 245 4 98 1 5 249 84 327 Nitzschia frustulum isolate TCC551 18S ribosomal RNA gene, partial sequence blastn 24505 424 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia frustulum
2165974 2165974 PRJNA909412_P_NODE_11482_length_169_cov_1.115385_g11341_i0 PRJNA909412 11482 169 1.115385 1.88500065 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 200 4.76e-47   NTclustered gi|146762526|gb|EF553458.1| 2850 g11341 i0 88.166 91.8520710059172 169 19 99 1 1 168 4196 4364 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 15523 200 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2524860 2524860 PRJNA909412_P_NODE_6982_length_199_cov_3.162500_g6841_i0 PRJNA909412 6982 199 3.1625 6.293375 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 363 7.019999999999998e-96   NTclustered gi|168145900|emb|AM710546.1| 431399 g6841 i0 99.497 96.5778894472362 199 1 100 0 1 199 465 267 Navicula cari partial 28S rRNA gene, strain AT-82.04c blastn 19219 363 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cari
3801218 3801218 PRJNA909412_P_NODE_15323_length_154_cov_2.173913_g15182_i0 PRJNA909412 15323 154 2.173913 3.34782602 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 279 5.33e-71   NTclustered gi|2072316588|gb|MT742551.1| 2862141 g15182 i0 99.351 198.987012987013 154 1 100 0 1 154 67271 67424 Nitzschia anatoliensis chloroplast clone SZCZ E372, complete genome blastn 30644 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
5077462 5077462 PRJNA909412_P_NODE_8324_length_184_cov_2.882759_g8183_i0 PRJNA909412 8324 184 2.882759 5.30427656 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 305 1.09e-78   NTclustered gi|1209554701|gb|KX889110.1| 303399 g8183 i0 97.222 90.2010869565217 180 5 98 0 5 184 307 128 Nitzschia acicularis 28S ribosomal RNA gene, partial sequence blastn 16597 305 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia acicularis
10177814 10177814 PRJNA909412_P_NODE_2348_length_347_cov_6.672078_g2208_i0 PRJNA909412 2348 347 6.672078 23.15211066 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 580 3.3899999999999998e-161   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g2208 i0 96.83 100.613832853026 347 11 100 0 1 347 3930 3584 Nitzschia reversa isolate AGSB0348 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 34913 580 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
17826702 17826702 PRJNA909412_P_NODE_15094_length_154_cov_5.843478_g14953_i0 PRJNA909412 15094 154 5.843478 8.99895612 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 274 2.48e-69   NTclustered gi|662012523|ref|NC_024081.1| 33642 g14953 i0 98.701 194.987012987013 154 2 100 0 1 154 69384 69231 Coscinodiscus radiatus chloroplast, complete genome blastn 30028 274 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus radiatus
25116708 25116708 PRJNA909412_P_NODE_16880_length_151_cov_2.116071_g16739_i0 PRJNA909412 16880 151 2.116071 3.19526721 Cocconeis euglypta 1752161 SAR_Eukaryotes SAR_Eukaryotes 185 1.1599999999999999e-42   NTclustered gi|2162236514|gb|OL780369.1| 1752161 g16739 i0 88.889 64.7814569536424 153 14 100 3 1 151 451 602 Cocconeis euglypta strain CBac2019019 large subunit ribosomal RNA gene, partial sequence blastn 9782 185 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis euglypta
28698437 28698437 PRJNA909412_P_NODE_16627_length_151_cov_3.750000_g16486_i0 PRJNA909412 16627 151 3.75 5.6625 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 79 1.75e-15   NR GAX11153.1 1519565 g16486 i0 69.4 0.973509933774834 49 15 97.4 0 3 149 504 552 GAX11153.1 arginyl-tRNA synthetase [Fistulifera solaris] diamond 147 79 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30245821 30245821 PRJNA909412_P_NODE_17892_length_150_cov_1.513514_g17751_i0 PRJNA909412 17892 150 1.513514 2.270271 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.66e-6   NR GFH60747.1 426638 g17751 i0 50 1.98 48 24 96 0 7 150 142 189 GFH60747.1 hypothetical protein CTEN210_17223 [Chaetoceros tenuissimus] diamond 297 53.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30435462 30435462 PRJNA909412_P_NODE_9693_length_173_cov_1.238806_g9552_i0 PRJNA909412 9693 173 1.238806 2.14313438 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.81e-8   NR KAI2504394.1 210448 g9552 i0 57.5 2.04624277456647 40 17 69.4 0 122 3 370 409 KAI2504394.1 FACT complex subunit ctc-1 [Fragilaria crotonensis] diamond 354 58.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31509933 31509933 PRJNA909412_P_NODE_11836_length_166_cov_1.543307_g11695_i0 PRJNA909412 11836 166 1.543307 2.56188962 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.58e-11   NR CAB9514815.1 568900 g11695 i0 56.4 10.210843373494 55 24 99.4 0 166 2 58 112 CAB9514815.1 Pepsin A [Seminavis robusta] diamond 1695 67.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32308419 32308419 PRJNA909412_P_NODE_13759_length_159_cov_3.300000_g13618_i0 PRJNA909412 13759 159 3.3 5.247 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 83.6 4.74e-17   NR CAB9516067.1 568900 g13618 i0 61.1 12.2264150943396 72 8 98.1 1 3 158 307 378 CAB9516067.1 Sulfite reductase [NADPH] hemoprotein beta-component [Seminavis robusta] diamond 1944 83.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32711216 32711216 PRJNA909412_P_NODE_17260_length_151_cov_1.482143_g17119_i0 PRJNA909412 17260 151 1.482143 2.23803593 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.03e-14   NR CAB9497662.1 568900 g17119 i0 64 2.98013245033113 50 18 99.3 0 151 2 526 575 CAB9497662.1 Lon protease [Seminavis robusta] diamond 450 75.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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