RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA591127 · 23 ✖

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
1840536 1840536 PRJNA591127_P_NODE_1402_length_567_cov_5.649057_g533_i2 PRJNA591127 1402 567 5.649057 32.03015319 Stephanodiscus hantzschii 29207 SAR_Eukaryotes SAR_Eukaryotes 645 2.0199999999999995e-180   NTclustered gi|66571076|emb|AJ878502.1| 29207 g533 i2 90.06 72.689594356261 503 43 88 6 3 501 603 104 Stephanodiscus hantzschii partial 28S rRNA gene, strain AT-N2 blastn 41215 645 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
1840600 1840600 PRJNA591127_P_NODE_22482_length_184_cov_13.482993_g22313_i0 PRJNA591127 22482 184 13.482993 24.80870712 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 244 2.41e-60   NTclustered gi|1169296927|gb|KY364697.1| 29204 g22313 i0 90.761 87.3423913043478 184 15 100 2 1 184 5638 5819 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 16071 244 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
2414297 2414297 PRJNA591127_P_NODE_5102_length_323_cov_13.430070_g4934_i0 PRJNA591127 5102 323 13.43007 43.3791261 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 562 1.1299999999999997e-155   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g4934 i0 98.137 99.71826625387 322 6 99 0 2 323 3911 3590 Thalassiosira bioculata isolate AGSB0307 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 32209 562 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
3116086 3116086 PRJNA591127_P_NODE_3763_length_372_cov_4.220896_g3595_i0 PRJNA591127 3763 372 4.220896 15.70173312 Cyclotella costei 1752160 SAR_Eukaryotes SAR_Eukaryotes 473 6.369999999999999e-129   NTclustered gi|952988045|gb|KT072952.1| 1752160 g3595 i0 96.503 93.7284946236559 286 10 97 0 1 286 578 863 Cyclotella costei isolate TCC353 18S ribosomal RNA gene, partial sequence blastn 34867 473 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella costei
5668880 5668880 PRJNA591127_P_NODE_30465_length_151_cov_2.833333_g30296_i0 PRJNA591127 30465 151 2.833333 4.27833283 Navicula avium 2018708 SAR_Eukaryotes SAR_Eukaryotes 219 1.15e-52   NTclustered gi|2202538973|gb|OM891879.1| 2018708 g30296 i0 92.763 14.112582781457 152 10 100 1 1 151 5519 5368 Haslea avium 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 2131 219 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula avium
6242524 6242524 PRJNA591127_P_NODE_5165_length_322_cov_1.607018_g4997_i0 PRJNA591127 5165 322 1.607018 5.17459796 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 590 5.18e-164   NTclustered gi|817090761|gb|KM009440.1| 1003040 g4997 i0 99.689 142.934782608696 322 1 100 0 1 322 548 869 Cyclostephanos dubius isolate Waco5 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 46025 590 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos dubius
6943136 6943136 PRJNA591127_P_NODE_11346_length_218_cov_15.883978_g11177_i0 PRJNA591127 11346 218 15.883978 34.62707204 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 399 5.969999999999999e-107   NTclustered gi|1891520230|gb|MN696734.1| 303405 g11177 i0 99.541 98.3532110091743 218 1 100 0 1 218 290 73 Nitzschia inconspicua culture TCC:487 large subunit ribosomal RNA gene, partial sequence blastn 21441 399 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
7516707 7516707 PRJNA591127_P_NODE_28166_length_153_cov_1.715517_g27997_i0 PRJNA591127 28166 153 1.715517 2.62474101 Stephanodiscus 29206 SAR_Eukaryotes SAR_Eukaryotes 272 8.84e-69   NTclustered gi|1992615797|gb|MW648622.1| 222884 g27997 i0 98.693 143.921568627451 153 2 100 0 1 153 44 196 Stephanodiscus minutulus strain TCC828-sq1 large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 22020 272 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus minutulus
8791696 8791696 PRJNA591127_P_NODE_3847_length_368_cov_3.725076_g3679_i0 PRJNA591127 3847 368 3.725076 13.70827968 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 678 0   NTclustered gi|1779750555|gb|MN750463.1| 303405 g3679 i0 100 98.625 367 0 99 0 2 368 4 370 Nitzschia inconspicua strain G3_3 [L61] small subunit ribosomal RNA gene, partial sequence blastn 36294 678 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
10769439 10769439 PRJNA591127_P_NODE_629_length_783_cov_6.965147_g533_i0 PRJNA591127 629 783 6.965147 54.53710101 Stephanodiscus hantzschii 29207 SAR_Eukaryotes SAR_Eukaryotes 638 4.7399999999999994e-178   NTclustered gi|66571076|emb|AJ878502.1| 29207 g533 i0 96.85 59.6130268199234 381 12 77 0 401 781 223 603 Stephanodiscus hantzschii partial 28S rRNA gene, strain AT-N2 blastn 46677 638 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
13318952 13318952 PRJNA591127_P_NODE_13171_length_202_cov_5.612121_g13002_i0 PRJNA591127 13171 202 5.612121 11.33648442 Nitzschia amphibia 304200 SAR_Eukaryotes SAR_Eukaryotes 359 9.25e-95   NTclustered gi|1777455344|gb|MN725796.1| 304200 g13002 i0 99.005 99.6237623762376 201 1 99 1 2 202 550 749 Nitzschia amphibia strain BC0503 large subunit ribosomal RNA gene, partial sequence blastn 20124 359 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia amphibia
13892804 13892804 PRJNA591127_P_NODE_23751_length_176_cov_2.755396_g23582_i0 PRJNA591127 23751 176 2.755396 4.84949696 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 231 1.78e-56   NTclustered gi|2839792213|gb|PQ512811.1| 37318 g23582 i0 90.449 65.4090909090909 178 14 100 2 1 176 5478 5654 Pseudo-nitzschia pungens isolate CNS00141 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 11512 231 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia pungens
15867877 15867877 PRJNA591127_P_NODE_713_length_745_cov_4.598870_g533_i1 PRJNA591127 713 745 4.59887 34.2615815 Stephanodiscus hantzschii 29207 SAR_Eukaryotes SAR_Eukaryotes 686 0   NTclustered gi|66571076|emb|AJ878502.1| 29207 g533 i1 91.519 96.9489932885906 507 27 95 13 253 743 97 603 Stephanodiscus hantzschii partial 28S rRNA gene, strain AT-N2 blastn 72227 686 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
17142621 17142621 PRJNA591127_P_NODE_12334_length_209_cov_5.267442_g12165_i0 PRJNA591127 12334 209 5.267442 11.00895378 Licmophora juergensii 210598 SAR_Eukaryotes SAR_Eukaryotes 375 9.57e-100   NTclustered gi|2862228907|gb|PQ645541.1| 210598 g12165 i0 99.043 99.933014354067 209 2 100 0 1 209 3261 3053 Licmophora juergensii isolate AGSB0420 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 20886 375 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Licmophoraceae Licmophora Licmophora juergensii
18416908 18416908 PRJNA591127_P_NODE_21215_length_193_cov_4.705128_g21046_i0 PRJNA591127 21215 193 4.705128 9.08089704 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 357 3.1499999999999996e-94   NTclustered gi|459936773|gb|KC736636.1| 303405 g21046 i0 100 100.129533678756 193 0 100 0 1 193 1559 1367 Nitzschia inconspicua clone TCC487 18S ribosomal RNA gene, partial sequence blastn 19325 357 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
18990021 18990021 PRJNA591127_P_NODE_11315_length_219_cov_1.868132_g11146_i0 PRJNA591127 11315 219 1.868132 4.09120908 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 394 2.79e-105   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g11146 i0 99.087 196.150684931507 219 2 100 0 1 219 86322 86104 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 42957 394 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
20265274 20265274 PRJNA591127_P_NODE_22316_length_186_cov_1.442953_g22147_i0 PRJNA591127 22316 186 1.442953 2.68389258 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 333 5.069999999999999e-87   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g22147 i0 98.925 198.215053763441 186 2 100 0 1 186 71029 71214 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 36868 333 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
20967280 20967280 PRJNA591127_P_NODE_25937_length_163_cov_3.888889_g25768_i0 PRJNA591127 25937 163 3.888889 6.33888907 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 176 7.73e-40   NTclustered gi|1549146932|gb|MH810167.1| 1487565 g25768 i0 87.117 54.4723926380368 163 12 100 5 1 163 7208 7055 Halamphora coffeaeformis voucher JPK7977-AMPH101 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 8879 176 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
20967343 20967343 PRJNA591127_P_NODE_4037_length_360_cov_2.126935_g3869_i0 PRJNA591127 4037 360 2.126935 7.656966 root 1 Root_unresolved Root_unresolved 191 1.91e-58   NR CAJ1931814.1 2856 g3869 i0 73.1 11.8666666666667 119 32 99.2 0 358 2 10 128 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 4272 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
24090799 24090799 PRJNA591127_P_NODE_3299_length_394_cov_5.235294_g3131_i0 PRJNA591127 3299 394 5.235294 20.62705836 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 701 0   NTclustered gi|1419234739|dbj|AP018511.1| 303400 g3131 i0 98.731 199.918781725888 394 5 100 0 1 394 2409 2802 Nitzschia palea NIES-2729 chloroplast DNA complet genome blastn 78768 701 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
25365041 25365041 PRJNA591127_P_NODE_21960_length_188_cov_3.920530_g21791_i0 PRJNA591127 21960 188 3.92053 7.3705964 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 331 1.85e-86   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g21791 i0 98.404 198.877659574468 188 3 100 0 1 188 70435 70248 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 37389 331 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
25365216 25365216 PRJNA591127_P_NODE_8260_length_256_cov_16.031963_g8092_i0 PRJNA591127 8260 256 16.031963 41.04182528 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 405 1.55e-108   NTclustered gi|2862228894|gb|PQ645528.1| 44447 g8092 i0 95.312 100.64453125 256 11 100 1 1 256 3768 3514 Pseudo-nitzschia delicatissima isolate AGSB0398 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 25765 405 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia delicatissima
32039626 32039626 PRJNA591127_P_NODE_17398_length_197_cov_2.500000_g17229_i0 PRJNA591127 17398 197 2.5 4.925 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0107   NR XP_002288256.1 296543 g17229 i0 75 1.76649746192893 24 6 36.5 0 2 73 270 293 XP_002288256.1 myristoyl-CoA:protein N-myristoyltransferase [Thalassiosira pseudonana CCMP1335] diamond 348 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana

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