RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA946307 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
927910 927910 PRJNA946307_P_NODE_77321_length_196_cov_3.142857_g76447_i0 PRJNA946307 77321 196 3.142857 6.15999972 Pleurosigma inscriptura 2819025 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|2172612263|ref|NC_059753.1| 2819025 g76447 i0 92.683 0.209183673469388 41 0 20 2 22 60 5435 5396 Pleurosigma inscriptura isolate MEG005 mitochondrion, complete genome blastn 41 56.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma inscriptura
1260788 1260788 PRJNA946307_P_NODE_69281_length_199_cov_3.353333_g68407_i0 PRJNA946307 69281 199 3.353333 6.67313267 Luticola 431369 SAR_Eukaryotes SAR_Eukaryotes 287 4.35e-73   NTclustered gi|694880116|gb|KM116125.1| 1561720 g68407 i0 97.059 88.4522613065327 170 5 85 0 28 197 1 170 Luticola permuticopsis clone A04 18S ribosomal RNA gene, partial sequence blastn 17602 287 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola permuticopsis
3477978 3477978 PRJNA946307_P_NODE_40703_length_212_cov_3.570552_g39829_i0 PRJNA946307 40703 212 3.570552 7.56957024 Psammodictyon constrictum 515483 SAR_Eukaryotes SAR_Eukaryotes 287 4.69e-73   NTclustered gi|2202538965|gb|OM891871.1| 515483 g39829 i0 92.308 92.9669811320755 208 7 95 5 12 212 4780 4985 Psammodictyon constrictum 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 19709 287 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
4755237 4755237 PRJNA946307_P_NODE_20504_length_282_cov_8.210300_g19631_i0 PRJNA946307 20504 282 8.2103 23.153046 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 348 2.9600000000000004e-91   NTclustered gi|1803023461|gb|MN937452.1| 2850 g19631 i0 88.693 197.989361702128 283 15 95 12 1 267 68837 68556 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 55833 348 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4755394 4755394 PRJNA946307_P_NODE_28544_length_242_cov_3.564767_g27670_i0 PRJNA946307 28544 242 3.564767 8.62673614 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 340 4.15e-89   NTclustered gi|370991436|dbj|AB430595.1| 210441 g27670 i0 92.174 95.4504132231405 230 14 93 3 15 240 1331 1560 Asterionella formosa gene for 18S rRNA, partial sequence, strain: s0339 blastn 23099 340 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
5088281 5088281 PRJNA946307_P_NODE_135524_length_168_cov_13.890756_g134650_i0 PRJNA946307 135524 168 13.890756 23.33647008 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 244 2.1699999999999999e-60   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g134650 i0 97.872 170.708333333333 141 3 84 0 16 156 68473 68613 Asterionella formosa chloroplast, complete genome blastn 28679 246 0.991869918699187 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
7305957 7305957 PRJNA946307_P_NODE_76746_length_196_cov_3.802721_g75872_i0 PRJNA946307 76746 196 3.802721 7.45333316 Navicula sp. OTU-19Z-93_132-05-24 3049173 SAR_Eukaryotes SAR_Eukaryotes 191 3.44e-44   NTclustered gi|2509257401|gb|OR037279.1| 3049173 g75872 i0 87.006 48.8724489795918 177 14 90 5 15 191 194 361 Navicula sp. OTU-19Z-93_132-05-24 small subunit ribosomal RNA gene, partial sequence blastn 9579 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp. OTU-19Z-93_132-05-24
9856110 9856110 PRJNA946307_P_NODE_89748_length_189_cov_1.321429_g88874_i0 PRJNA946307 89748 189 1.321429 2.49750081 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 326 8.650000000000001e-85   NTclustered gi|2749492174|gb|PP727123.1| 1951536 g88874 i0 100 184.809523809524 176 0 93 0 14 189 71028 71203 Halamphora sp. strain SZCZEY 2167 chloroplast, complete genome blastn 34929 326 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
11464196 11464196 PRJNA946307_P_NODE_26389_length_251_cov_2.747525_g25515_i0 PRJNA946307 26389 251 2.747525 6.89628775 Guinardia 216800 SAR_Eukaryotes SAR_Eukaryotes 65.8 2.92e-6   NTclustered gi|2202538978|gb|OM891884.1| 216802 g25515 i0 100 13.7490039840637 35 0 14 0 57 91 4094 4128 Guinardia delicatula 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 3451 65.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
12404902 12404902 PRJNA946307_P_NODE_115570_length_177_cov_1.875000_g114696_i0 PRJNA946307 115570 177 1.875 3.31875 Fistulifera saprophila 880757 SAR_Eukaryotes SAR_Eukaryotes 292 8.09e-75   NTclustered gi|2088232490|ref|NC_056790.1| 880757 g114696 i0 98.214 187.480225988701 168 2 95 1 10 177 71376 71542 Fistulifera saprophila isolate SZCZR1829 chloroplast, complete genome blastn 33184 292 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
12739150 12739150 PRJNA946307_P_NODE_106550_length_181_cov_2.159091_g105676_i0 PRJNA946307 106550 181 2.159091 3.90795471 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 213 6.66e-51   NTclustered gi|2328365172|ref|NC_067848.1| 97227 g105676 i0 100 137.198895027624 115 0 64 0 53 167 71259 71145 Gomphonema parvulum voucher personal collection:A.Bruce Cahoon:diatom-2021-A chloroplast, complete genome blastn 24833 213 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
13679218 13679218 PRJNA946307_P_NODE_100131_length_184_cov_1.918519_g99257_i0 PRJNA946307 100131 184 1.918519 3.53007496 Porosira glacialis 49260 SAR_Eukaryotes SAR_Eukaryotes 78.7 2.59e-10   NTclustered gi|2862228854|gb|PQ645488.1| 49260 g99257 i0 94.118 26.5652173913043 51 3 28 0 131 181 3504 3554 Porosira glacialis isolate AGSB0326 small subunit ribosomal RNA gene, partial sequence blastn 4888 78.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Porosira Porosira glacialis
13679280 13679280 PRJNA946307_P_NODE_103531_length_182_cov_3.646617_g102657_i0 PRJNA946307 103531 182 3.646617 6.63684294 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 152 1.4799999999999998e-32   NTclustered gi|224002558|ref|XM_002290915.1| 296543 g102657 i0 84.516 38.9725274725275 155 22 85 2 23 176 233 386 Thalassiosira pseudonana CCMP1335 hypothetical protein (AHC3), mRNA blastn 7093 152 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
14955523 14955523 PRJNA946307_P_NODE_61732_length_204_cov_1.225806_g60858_i0 PRJNA946307 61732 204 1.225806 2.50064424 Pseudo-nitzschia hainanensis 2775602 SAR_Eukaryotes SAR_Eukaryotes 180 7.819999999999998e-41   NTclustered gi|2852238036|gb|PQ498353.1| 2775602 g60858 i0 83.838 103.558823529412 198 22 93 6 15 204 33019 32824 Pseudo-nitzschia hainanensis isolate CNS00090 mitochondrion, complete genome blastn 21126 180 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia hainanensis
16228419 16228419 PRJNA946307_P_NODE_10133_length_422_cov_3.565684_g9284_i0 PRJNA946307 10133 422 3.565684 15.04718648 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 577 5.419999999999999e-160   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g9284 i0 92.233 97.9739336492891 412 25 96 6 14 419 3537 3947 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 41345 577 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
16230059 16230059 PRJNA946307_P_NODE_34793_length_223_cov_2.655172_g33919_i0 PRJNA946307 34793 223 2.655172 5.92103356 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 375 1.03e-99   NTclustered gi|2245330039|gb|OK502191.1| 210441 g33919 i0 98.585 94.9417040358744 212 3 95 0 11 222 355 566 Asterionella formosa voucher Poza4 28S ribosomal RNA gene, partial sequence blastn 21172 375 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
17504250 17504250 PRJNA946307_P_NODE_128374_length_171_cov_2.959016_g127500_i0 PRJNA946307 128374 171 2.959016 5.05991736 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 257 2.83e-64   NTclustered gi|146762526|gb|EF553458.1| 2850 g127500 i0 96.178 91.9941520467836 157 6 92 0 1 157 4065 3909 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 15731 257 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17837406 17837406 PRJNA946307_P_NODE_132534_length_169_cov_6.183333_g131660_i0 PRJNA946307 132534 169 6.183333 10.44983277 Halamphora 1242273 SAR_Eukaryotes SAR_Eukaryotes 71.3 3.9e-8   NTclustered gi|1549146930|gb|MH810165.1| 2133758 g131660 i0 82.558 1.52662721893491 86 10 50 5 71 155 6480 6399 Halamphora calidilacuna voucher JPK8506-AMPH118 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 258 71.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora calidilacuna
18779858 18779858 PRJNA946307_P_NODE_88475_length_189_cov_2.507143_g87601_i0 PRJNA946307 88475 189 2.507143 4.73850027 Tabularia cf. tabulata 555752 SAR_Eukaryotes SAR_Eukaryotes 110 9.49e-20   NTclustered gi|215400919|gb|EU883364.1| 555752 g87601 i0 100 30.7777777777778 59 0 31 0 117 175 174 116 Tabularia cf. tabulata strain CCMP846 5.8S ribosomal RNA gene and internal transcribed spacer 2, partial sequence blastn 5817 110 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia cf. tabulata
22938015 22938015 PRJNA946307_P_NODE_173898_length_152_cov_2.922330_g173024_i0 PRJNA946307 173898 152 2.92233 4.4419416 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 265 1.47e-66   NTclustered gi|1419234739|dbj|AP018511.1| 303400 g173024 i0 98.039 196.815789473684 153 2 100 1 1 152 1189 1341 Nitzschia palea NIES-2729 chloroplast DNA complet genome blastn 29916 265 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
25152106 25152106 PRJNA946307_P_NODE_12600_length_370_cov_4.647975_g11734_i0 PRJNA946307 12600 370 4.647975 17.1975075 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 228 5.439999999999998e-55   NTclustered gi|657012566|gb|KF302620.1| 2850 g11734 i0 79.758 89.2459459459459 331 53 88 10 47 370 759 436 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 33021 228 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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