RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 29 ✖

tax_clade 1

bioproject 1

  • PRJNA558770 · 29 ✖

analysis 1

  • blastn · 29 ✖

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
1814802 1814802 PRJNA558770_P_NODE_19782_length_446_cov_11.571776_g17915_i0 PRJNA558770 19782 446 11.571776 51.61012096 Nitzschia dissipata 303402 SAR_Eukaryotes SAR_Eukaryotes 726 0   NTclustered gi|2248495830|ref|NC_063456.1| 303402 g17915 i0 96.197 96.8026905829596 447 12 100 3 1 446 20477 20919 Nitzschia dissipata isolate Qingdao in China mitochondrion, complete genome blastn 43174 726 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
1815758 1815758 PRJNA558770_P_NODE_25482_length_413_cov_11.211640_g23544_i0 PRJNA558770 25482 413 11.21164 46.3040732 Nitzschia supralitorea 303403 SAR_Eukaryotes SAR_Eukaryotes 411 5.689999999999999e-110   NTclustered gi|2088232260|ref|NC_056787.1| 303403 g23544 i0 98.707 164.515738498789 232 2 96 1 1 231 93581 93812 Nitzschia supralitorea isolate SZCZR1828 chloroplast, complete genome blastn 67945 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia supralitorea
2405251 2405251 PRJNA558770_P_NODE_382842_length_205_cov_8.476471_g380837_i0 PRJNA558770 382842 205 8.476471 17.37676555 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 224 3.579999999999999e-54   NTclustered gi|2862228899|gb|PQ645533.1| 265540 g380837 i0 86.364 106.80487804878 220 12 100 12 1 205 3472 3688 Minidiscus trioculatus isolate AGSB0407 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 21895 224 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Minidiscus Minidiscus trioculatus
3680904 3680904 PRJNA558770_P_NODE_30643_length_388_cov_74.937677_g28672_i0 PRJNA558770 30643 388 74.937677 290.75818676 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 351 3.26e-92   NTclustered gi|1182659454|emb|LT795034.1| 376602 g28672 i0 98.492 61.3814432989691 199 3 61 0 3 201 15 213 Uncultured Bacillariophyceae partial 18S rRNA gene, isolate 128092 blastn 23816 351 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae       uncultured Bacillariophyceae
3681242 3681242 PRJNA558770_P_NODE_395323_length_159_cov_4.056452_g393318_i0 PRJNA558770 395323 159 4.056452 6.44975868 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 294 1.98e-75   NTclustered gi|98978879|gb|DQ512398.1| 29204 g393318 i0 100 100.006289308176 159 0 100 0 1 159 91 249 Cyclotella sp. CCMP331 large subunit ribosomal RNA gene, partial sequence blastn 15901 294 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
4367934 4367934 PRJNA558770_P_NODE_28604_length_398_cov_9.661157_g26640_i0 PRJNA558770 28604 398 9.661157 38.45140486 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 477 5.31e-130   NTclustered gi|2632235312|gb|OR922694.1| 2856 g26640 i0 99.242 86.3442211055276 264 2 99 0 3 266 2996 3259 Cylindrotheca closterium strain AGSB0066 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 34365 477 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
4957998 4957998 PRJNA558770_P_NODE_396604_length_154_cov_6.285714_g394599_i0 PRJNA558770 396604 154 6.285714 9.67999956 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 283 4.12e-72   NTclustered gi|1209554698|gb|KX889107.1| 2014924 g394599 i0 100 99.3701298701299 153 0 99 0 2 154 578 730 Nitzschia dissipata var. media 28S ribosomal RNA gene, partial sequence blastn 15303 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
6233464 6233464 PRJNA558770_P_NODE_389745_length_177_cov_21.436620_g387740_i0 PRJNA558770 389745 177 21.43662 37.9428174 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 268 1.3599999999999999e-67   NTclustered gi|2202538972|gb|OM891878.1| 33640 g387740 i0 95.266 95.0338983050847 169 8 95 0 9 177 4229 4397 Asterionellopsis glacialis 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 16821 270 0.992592592592593 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis
6915726 6915726 PRJNA558770_P_NODE_132046_length_234_cov_7.914573_g130041_i0 PRJNA558770 132046 234 7.914573 18.52010082 Skeletonema grevillei 371681 SAR_Eukaryotes SAR_Eukaryotes 65.8 2.69e-6   NTclustered gi|2739942915|dbj|LC814775.1| 371681 g130041 i0 82.432 0.632478632478632 74 13 32 0 2 75 718 791 Skeletonema grevillei NIES-2840 mitochondrial DNA, complete genome blastn 148 65.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei
6918062 6918062 PRJNA558770_P_NODE_250446_length_234_cov_2.301508_g248441_i0 PRJNA558770 250446 234 2.301508 5.38552872 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 121 5.66e-23   NTclustered gi|2125740378|gb|MZ520768.1| 2770866 g248441 i0 97.183 9.57692307692308 71 2 30 0 4 74 95279 95349 Schizostauron trachyderma strain SZCZE1420 plastid, complete genome blastn 2241 121 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
6919160 6919160 PRJNA558770_P_NODE_331826_length_233_cov_5.787879_g329821_i0 PRJNA558770 331826 233 5.787879 13.48575807 Cocconeiopsis kantsiensis 3082010 SAR_Eukaryotes SAR_Eukaryotes 124 4.36e-24   NTclustered gi|2692958369|ref|NC_086887.1| 3082010 g329821 i0 96.053 37.2145922746781 76 3 33 0 1 76 17108 17183 Cocconeiopsis kantsiensis isolate Huiquan Bay in China mitochondrion, complete genome blastn 8671 124 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeiopsis Cocconeiopsis kantsiensis
8782513 8782513 PRJNA558770_P_NODE_30007_length_391_cov_33.755618_g28037_i0 PRJNA558770 30007 391 33.755618 131.98446638 root 1 Root_unresolved Root_unresolved 682 0   NTclustered gi|2239963886|gb|MW561351.1| 67476 g28037 i0 98.21 110 391 6 100 1 1 391 66994 67383 Haslea ostrearia strain SZCZP1883 chloroplast, complete genome blastn 43010 688 0.991279069767442 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
8782750 8782750 PRJNA558770_P_NODE_379967_length_218_cov_2.890710_g377962_i0 PRJNA558770 379967 218 2.89071 6.3017478 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 398 2.1499999999999996e-106   NTclustered gi|2199203581|ref|NC_061047.1| 1881117 g377962 i0 99.541 198.98623853211 218 1 100 0 1 218 56650 56433 Nitzschia traheaformis chloroplast, complete genome blastn 43379 398 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia traheaformis
8783039 8783039 PRJNA558770_P_NODE_62287_length_264_cov_13.288210_g60282_i0 PRJNA558770 62287 264 13.28821 35.0808744 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 364 2.729999999999999e-96   NTclustered gi|1735236539|ref|NC_044464.1| 2133758 g60282 i0 91.635 104.753787878788 263 22 99 0 1 263 3040 3302 Halamphora calidilacuna chloroplast, complete genome blastn 27655 364 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
10058387 10058387 PRJNA558770_P_NODE_380448_length_215_cov_75.544444_g378443_i0 PRJNA558770 380448 215 75.544444 162.4205546 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 374 3.5599999999999993e-99   NTclustered gi|1027926513|gb|KU561204.1| 2856 g378443 i0 98.131 100.274418604651 214 4 99 0 1 214 1098 885 Cylindrotheca closterium isolate Xmm18W1 18S ribosomal RNA gene, partial sequence blastn 21559 374 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
10058420 10058420 PRJNA558770_P_NODE_385428_length_194_cov_2.314465_g383423_i0 PRJNA558770 385428 194 2.314465 4.4900621 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 213 7.26e-51   NTclustered gi|2202538958|gb|OM891864.1| 216750 g383423 i0 86.911 82.2113402061856 191 23 98 2 5 194 3883 4072 Entomoneis cf. alata 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 15949 213 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
11333037 11333037 PRJNA558770_P_NODE_387569_length_185_cov_9.673333_g385564_i0 PRJNA558770 387569 185 9.673333 17.89566605 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 292 8.55e-75   NTclustered gi|1803023461|gb|MN937452.1| 2850 g385564 i0 96.111 181.481081081081 180 5 97 1 6 185 67109 67286 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 33574 294 0.993197278911565 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
12019079 12019079 PRJNA558770_P_NODE_251290_length_234_cov_2.281407_g249285_i0 PRJNA558770 251290 234 2.281407 5.33849238 Diatoma tenuis 426639 SAR_Eukaryotes SAR_Eukaryotes 124 4.38e-24   NTclustered gi|329342883|gb|HQ912286.1| 426639 g249285 i0 96.053 32.6068376068376 76 3 32 0 159 234 628 703 Diatoma tenue strain UTEX FD106 PsbC (psbC) gene, partial cds; chloroplast blastn 7630 124 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Diatoma Diatoma tenuis
13292723 13292723 PRJNA558770_P_NODE_17431_length_469_cov_6.361751_g15609_i0 PRJNA558770 17431 469 6.361751 29.83661219 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 344 6.72e-90   NTclustered gi|2862228889|gb|PQ645523.1| 1884248 g15609 i0 94.222 52.7803837953092 225 13 65 0 1 225 4021 3797 Nitzschia sp. (in: diatoms) isolate AGSB0393 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 24754 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
14569940 14569940 PRJNA558770_P_NODE_313832_length_233_cov_10.833333_g311827_i0 PRJNA558770 313832 233 10.833333 25.24166589 Cyclophora castracanei 1158071 SAR_Eukaryotes SAR_Eukaryotes 121 5.64e-23   NTclustered gi|817091727|gb|KM009923.1| 1158071 g311827 i0 95.946 7.25751072961373 74 3 32 0 2 75 1631 1704 Cyclophora castracanei isolate GU44AB-6 Hustedtiella PSI P700 apoprotein A2 (psaB) gene, partial cds; chloroplast blastn 1691 121 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Cyclophorales Cyclophoraceae Cyclophora Cyclophora castracanei
17707842 17707842 PRJNA558770_P_NODE_387574_length_185_cov_9.286667_g385569_i0 PRJNA558770 387574 185 9.286667 17.18033395 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 309 8.49e-80   NTclustered gi|1293315594|gb|KY650805.1| 431340 g385569 i0 96.774 99.227027027027 186 5 100 1 1 185 796 611 Cocconeis pediculus strain D36_020 18S ribosomal RNA gene, partial sequence blastn 18357 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis pediculus
19668597 19668597 PRJNA558770_P_NODE_49396_length_305_cov_33.077778_g47394_i0 PRJNA558770 49396 305 33.077778 100.8872229 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 503 6.53e-138   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g47394 i0 96.393 198.645901639344 305 11 100 0 1 305 69692 69996 Asterionella formosa chloroplast, complete genome blastn 60587 503 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
20941897 20941897 PRJNA558770_P_NODE_234477_length_234_cov_2.683417_g232472_i0 PRJNA558770 234477 234 2.683417 6.27919578 Nitzschia anomala 3068543 SAR_Eukaryotes SAR_Eukaryotes 62.1 3.48e-5   NTclustered gi|2721954263|gb|OR464348.1| 3068543 g232472 i0 89.796 0.209401709401709 49 3 21 2 158 205 118261 118308 Nitzschia anomala plastid, complete genome blastn 49 62.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anomala
20943742 20943742 PRJNA558770_P_NODE_384477_length_198_cov_3.644172_g382472_i0 PRJNA558770 384477 198 3.644172 7.21546056 Bacillaria paxillifer 3003 SAR_Eukaryotes SAR_Eukaryotes 283 5.589999999999999e-72   NTclustered gi|2202538966|gb|OM891872.1| 3003 g382472 i0 97.041 27.0606060606061 169 4 85 1 1 169 5687 5854 Bacillaria paxillifer 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 5358 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
21531686 21531686 PRJNA558770_P_NODE_315497_length_233_cov_10.292929_g313492_i0 PRJNA558770 315497 233 10.292929 23.98252457 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 139 1.56e-28   NTclustered gi|1891520340|gb|MN696773.1| 303402 g313492 i0 100 46.0944206008584 75 0 64 0 159 233 356 430 Nitzschia dissipata culture TCC:707 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 10740 139 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
22219047 22219047 PRJNA558770_P_NODE_42398_length_326_cov_11.271478_g40400_i0 PRJNA558770 42398 326 11.271478 36.74501828 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 569 6.839999999999998e-158   NTclustered gi|662012663|ref|NC_024082.1| 2856 g40400 i0 98.16 196.711656441718 326 6 100 0 1 326 94467 94142 Cylindrotheca closterium chloroplast, complete genome blastn 64128 569 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23494083 23494083 PRJNA558770_P_NODE_388359_length_182_cov_16.306122_g386354_i0 PRJNA558770 388359 182 16.306122 29.67714204 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 193 8.739999999999999e-45   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g386354 i0 97.345 124.186813186813 113 3 62 0 70 182 68345 68233 Asterionella formosa chloroplast, complete genome blastn 22602 193 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
24082084 24082084 PRJNA558770_P_NODE_66439_length_255_cov_14.295455_g64434_i0 PRJNA558770 66439 255 14.295455 36.45341025 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 172 1.6999999999999996e-38   NTclustered gi|27262952|emb|X77702.2| 33649 g64434 i0 98.958 54.3372549019608 96 1 38 0 1 96 1564 1469 T.nitzschioides (CCAP 1084/1) 18S rRNA gene blastn 13856 172 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Thalassionemales Thalassionemataceae Thalassionema Thalassionema nitzschioides
24766222 24766222 PRJNA558770_P_NODE_246740_length_234_cov_2.381910_g244735_i0 PRJNA558770 246740 234 2.38191 5.5736694 Extubocellulus spinifer 265572 SAR_Eukaryotes SAR_Eukaryotes 126 1.22e-24   NTclustered gi|2632235321|gb|OR922703.1| 265572 g244735 i0 97.297 10.5811965811966 74 2 32 0 2 75 4145 4218 Extubocellulus spinifer strain AGSB0090 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 2476 126 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Extubocellulus Extubocellulus spinifer

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