RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA900028 · 19 ✖

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
875902 875902 PRJNA900028_P_NODE_68421_length_190_cov_1.297872_g67672_i0 PRJNA900028 68421 190 1.297872 2.4659568 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 255 1.16e-63   NTclustered gi|2862228862|gb|PQ645496.1| 1923966 g67672 i0 91.053 53.8105263157895 190 16 100 1 1 190 3785 3597 Navicula sp. isolate AGSB0345 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 10224 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
8528182 8528182 PRJNA900028_P_NODE_28807_length_242_cov_7.455959_g28058_i0 PRJNA900028 28807 242 7.455959 18.04342078 Eucampia zodiacus 444606 SAR_Eukaryotes SAR_Eukaryotes 442 1.1099999999999995e-119   NTclustered gi|2091535207|ref|NC_057645.1| 444606 g28058 i0 99.587 196 242 1 100 0 1 242 16545 16786 Eucampia zodiacus strain CNS00061 chloroplast, complete genome blastn 47432 442 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
10173164 10173164 PRJNA900028_P_NODE_115008_length_168_cov_3.092437_g114259_i0 PRJNA900028 115008 168 3.092437 5.19529416 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 311 2.11e-80   NTclustered gi|2199203925|ref|NC_061049.1| 3003 g114259 i0 100 200 168 0 100 0 1 168 56842 57009 Bacillaria paxillifer chloroplast, complete genome blastn 33600 311 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
10173763 10173763 PRJNA900028_P_NODE_32528_length_234_cov_1.102703_g31779_i0 PRJNA900028 32528 234 1.102703 2.58032502 root 1 Root_unresolved Root_unresolved 130 9.41e-26   NTclustered gi|1418588907|ref|NC_038009.1| 451788 g31779 i0 82.119 114.534188034188 151 27 65 0 84 234 71471 71321 Acanthoceras zachariasii chloroplast, complete genome blastn 26801 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Acanthocerataceae Acanthoceras Acanthoceras zachariasii
11449450 11449450 PRJNA900028_P_NODE_87289_length_182_cov_0.969925_g86540_i0 PRJNA900028 87289 182 0.969925 1.7652635 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 298 1.8e-76   NTclustered gi|1829658085|gb|MN319637.1| 1089216 g86540 i0 96.154 100.038461538462 182 7 100 0 1 182 540 721 Caloneis silicula voucher Cal 890 TM 28S ribosomal RNA gene, partial sequence blastn 18207 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Caloneis Caloneis silicula
17452524 17452524 PRJNA900028_P_NODE_10614_length_342_cov_1.614334_g9866_i0 PRJNA900028 10614 342 1.614334 5.52102228 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 588 1.9899999999999998e-163   NTclustered gi|146762526|gb|EF553458.1| 2850 g9866 i0 97.661 100.163742690058 342 8 100 0 1 342 3872 3531 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 34256 588 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23826508 23826508 PRJNA900028_P_NODE_108979_length_171_cov_1.696721_g108230_i0 PRJNA900028 108979 171 1.696721 2.90139291 Nitzschia sp. pyKryTriq1 3034176 SAR_Eukaryotes SAR_Eukaryotes 303 3.58e-78   NTclustered gi|2524387100|emb|OY101133.1| 3034176 g108230 i0 98.824 196.947368421053 170 2 99 0 2 171 33532 33363 Nitzschia sp. pyKryTriq1 genome assembly, organelle: plastid:chloroplast blastn 33678 303 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1
25101728 25101728 PRJNA900028_P_NODE_5600_length_453_cov_1.801980_g4859_i0 PRJNA900028 5600 453 1.80198 8.1629694 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 787 0   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g4859 i0 98.013 100.483443708609 453 9 100 0 1 453 3959 3507 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 45519 787 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
26866219 26866219 PRJNA900028_P_NODE_166761_length_163_cov_0.894737_g166012_i0 PRJNA900028 166761 163 0.894737 1.45842131 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89 6.59e-19   NR GKY97666.1 2872254 g166012 i0 79.6 1.98773006134969 54 11 99.4 0 162 1 496 549 GKY97666.1 hypothetical protein MPSEU_000724900 [Mayamaea pseudoterrestris] diamond 324 89 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28224134 28224134 PRJNA900028_P_NODE_101026_length_175_cov_1.619048_g100277_i0 PRJNA900028 101026 175 1.619048 2.833334 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 45.8 5.37e-4   NR GFH43726.1 426638 g100277 i0 54.2 3.48 48 18 75.4 2 157 26 39 86 GFH43726.1 hypothetical protein CTEN210_00199 [Chaetoceros tenuissimus] diamond 609 45.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28887309 28887309 PRJNA900028_P_NODE_23268_length_259_cov_0.971429_g22519_i0 PRJNA900028 23268 259 0.971429 2.51600111 Actinocyclus sp. mgcode 4 2914904 SAR_Eukaryotes SAR_Eukaryotes 50.1 9.35e-5   NR QYC61840.1 2914904 g22519 i0 40.6 1.54054054054054 69 39 77.6 1 212 12 115 183 QYC61840.1 ribosomal protein L2 [Actinocyclus sp. mgcode 4] diamond 399 50.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Hemidiscaceae Actinocyclus Actinocyclus sp. mgcode 4
29077009 29077009 PRJNA900028_P_NODE_138868_length_166_cov_0.871795_g138119_i0 PRJNA900028 138868 166 0.871795 1.4471797 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 95.9 1.21e-21   NR GKY92867.1 2872254 g138119 i0 74.1 0.975903614457831 54 14 97.6 0 5 166 186 239 GKY92867.1 hypothetical protein MPSEU_000255900 [Mayamaea pseudoterrestris] diamond 162 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29739674 29739674 PRJNA900028_P_NODE_7770_length_389_cov_2.026471_g7024_i0 PRJNA900028 7770 389 2.026471 7.88297219 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0462   NR KAL3800710.1 382360 g7024 i0 41.1 0.431876606683805 56 33 43.2 0 267 100 52 107 KAL3800710.1 hypothetical protein ACHAWO_013252 [Cyclotella atomus] diamond 168 44.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30094870 30094870 PRJNA900028_P_NODE_65772_length_191_cov_2.514085_g65023_i0 PRJNA900028 65772 191 2.514085 4.80190235 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.06e-7   NR YP_010133813.1 880757 g65023 i0 49.2 4.96335078534031 63 31 99 1 1 189 27 88 YP_010133813.1 ribosomal protein L14 [Fistulifera saprophila] diamond 948 53.9 0.992578849721707 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
30403780 30403780 PRJNA900028_P_NODE_194193_length_161_cov_0.910714_g193444_i0 PRJNA900028 194193 161 0.910714 1.46624954 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.52e-4   NR EJK48984.1 159749 g193444 i0 67.9 0.521739130434783 28 9 52.2 0 86 3 369 396 EJK48984.1 hypothetical protein THAOC_32180 [Thalassiosira oceanica] diamond 84 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31414615 31414615 PRJNA900028_P_NODE_135796_length_166_cov_0.871795_g135047_i0 PRJNA900028 135796 166 0.871795 1.4471797 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 74.7 7.06e-14   NR CAB9519463.1 568900 g135047 i0 61.8 0.993975903614458 55 21 99.4 0 166 2 155 209 CAB9519463.1 3beta-hydroxysteroid-dehydrogenase/decarboxylase isoform 2 [Seminavis robusta] diamond 165 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32142252 32142252 PRJNA900028_P_NODE_51978_length_205_cov_2.320513_g51229_i0 PRJNA900028 51978 205 2.320513 4.75705165 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.62e-13   NR KAL3787509.1 382360 g51229 i0 66.7 2.79512195121951 48 16 70.2 0 204 61 118 165 KAL3787509.1 hypothetical protein ACHAWO_003499 [Cyclotella atomus] diamond 573 74.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32174075 32174075 PRJNA900028_P_NODE_182498_length_162_cov_0.902655_g181749_i0 PRJNA900028 182498 162 0.902655 1.4623011 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 83.2 7.08e-17   NR GKY99551.1 2872254 g181749 i0 72.1 1.12962962962963 61 10 100 3 1 162 985 1045 GKY99551.1 hypothetical protein MPSEU_000909400 [Mayamaea pseudoterrestris] diamond 183 83.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32300774 32300774 PRJNA900028_P_NODE_3619_length_566_cov_2.166344_g2900_i0 PRJNA900028 3619 566 2.166344 12.26150704 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 148 2.2199999999999996e-37   NR KAI2490608.1 210448 g2900 i0 40.6 2.95229681978799 192 106 99.6 5 2 565 634 821 KAI2490608.1 Reverse transcriptase (RNA-dependent DNA polymerase) [Fragilaria crotonensis] diamond 1671 148 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);;