RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA385073 · 13 ✖

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
2351611 2351611 PRJNA385073_P_NODE_37202_length_260_cov_2.112299_g37040_i0 PRJNA385073 37202 260 2.112299 5.4919774 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 58.4 5.09e-4   NTclustered gi|1169296927|gb|KY364697.1| 29204 g37040 i0 97.059 0.384615384615385 34 1 13 0 214 247 4127 4094 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 100 58.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
5509605 5509605 PRJNA385073_P_NODE_32825_length_271_cov_1.555556_g32663_i0 PRJNA385073 32825 271 1.555556 4.21555676 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 412 9.899999999999997e-111   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g32663 i0 94.096 95.6420664206642 271 16 100 0 1 271 4249 3979 Odontella aurita var. minima 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 25919 412 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima
5509711 5509711 PRJNA385073_P_NODE_37685_length_259_cov_1.655914_g37523_i0 PRJNA385073 37685 259 1.655914 4.28881726 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 342 1.25e-89   NTclustered gi|146762526|gb|EF553458.1| 2850 g37523 i0 90.458 57.4054054054054 262 22 100 2 1 259 4234 4495 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 14868 342 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6179029 6179029 PRJNA385073_P_NODE_20185_length_317_cov_4.073770_g20023_i0 PRJNA385073 20185 317 4.07377 12.9138509 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 553 6.679999999999998e-153   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g20023 i0 98.107 198.854889589905 317 6 100 0 1 317 70564 70248 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 63037 558 0.991039426523297 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
10004500 10004500 PRJNA385073_P_NODE_52908_length_244_cov_1.625731_g52746_i0 PRJNA385073 52908 244 1.625731 3.96678364 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 446 8.639999999999999e-121   NTclustered gi|18698478|gb|AF417679.1| 186032 g52746 i0 100 94.3688524590164 241 0 99 0 4 244 1 241 Navicula cf. erifuga strain Navicula large subunit ribosomal RNA gene, partial sequence blastn 23026 446 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula cf. erifuga
10610022 10610022 PRJNA385073_P_NODE_50329_length_246_cov_0.890173_g50167_i0 PRJNA385073 50329 246 0.890173 2.18982558 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 127 7.32e-33   NR EJK57351.1 159749 g50167 i0 66.7 0.98780487804878 81 27 98.8 0 3 245 34 114 EJK57351.1 hypothetical protein THAOC_22614 [Thalassiosira oceanica] diamond 243 127 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
11279606 11279606 PRJNA385073_P_NODE_56469_length_242_cov_1.035503_g56307_i0 PRJNA385073 56469 242 1.035503 2.50591726 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 431 2.4e-116   NTclustered gi|2862228862|gb|PQ645496.1| 1923966 g56307 i0 98.76 99.8140495867769 242 3 100 0 1 242 3825 3584 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 24155 431 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
11885044 11885044 PRJNA385073_P_NODE_5370_length_521_cov_2.620536_g5211_i0 PRJNA385073 5370 521 2.620536 13.65299256 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 841 0   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g5211 i0 95.793 98.0921305182342 523 18 100 3 1 521 4948 4428 Odontella aurita var. minima 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 51106 841 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima
12555093 12555093 PRJNA385073_P_NODE_6030_length_498_cov_9.842353_g5870_i0 PRJNA385073 6030 498 9.842353 49.01491794 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 826 0   NTclustered gi|2733059045|gb|PP801224.1| 195935 g5870 i0 96.586 82.5823293172691 498 17 100 0 1 498 134 631 Pseudo-nitzschia brasiliana strain MC7496 large subunit ribosomal RNA gene, partial sequence blastn 41126 826 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia brasiliana
14435060 14435060 PRJNA385073_P_NODE_5212_length_526_cov_1.551876_g5053_i0 PRJNA385073 5212 526 1.551876 8.16286776 Stephanodiscus suzukii 1353228 SAR_Eukaryotes SAR_Eukaryotes 582 1.4799999999999999e-161   NTclustered gi|972803793|dbj|AB829519.1| 1353228 g5053 i0 94.01 72.0342205323194 384 23 73 0 143 526 2404 2787 Stephanodiscus suzukii genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, specimen_voucher: TNS:AL:57776 blastn 37890 582 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus suzukii
18927951 18927951 PRJNA385073_P_NODE_60395_length_236_cov_8.337423_g60233_i0 PRJNA385073 60395 236 8.337423 19.67631828 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 431 2.33e-116   NTclustered gi|2127884451|ref|NC_058876.1| 49265 g60233 i0 99.576 198.008474576271 236 1 100 0 1 236 15385 15150 Thalassiosira rotula isolate CNS00051 chloroplast, complete genome blastn 46730 431 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira rotula
23358339 23358339 PRJNA385073_P_NODE_50899_length_245_cov_3.581395_g50737_i0 PRJNA385073 50899 245 3.581395 8.77441775 Ralfsiella minima 1334967 SAR_Eukaryotes SAR_Eukaryotes 401 1.9099999999999994e-107   NTclustered gi|2202538981|gb|OM891887.1| 1334967 g50737 i0 95.984 96.9265306122449 249 6 100 3 1 245 3923 3675 Odontella aurita var. minima 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 23747 401 1 Eukaryota Sar   Bacillariophyta       Ralfsiella Ralfsiella minima
24632727 24632727 PRJNA385073_P_NODE_54240_length_244_cov_0.883041_g54078_i0 PRJNA385073 54240 244 0.883041 2.15462004 Amphora sp. PP-2011 1052887 SAR_Eukaryotes SAR_Eukaryotes 407 4.08e-109   NTclustered gi|339717241|gb|JF834543.1| 1052887 g54078 i0 96.721 92.5204918032787 244 8 100 0 1 244 2068 2311 Amphora sp. PP-2011 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 22575 407 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Thalassiophysales Catenulaceae Amphora Amphora sp. PP-2011

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