RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA800053" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA800053 · 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
1219851 1219851 PRJNA800053_P_NODE_12381_length_284_cov_1.639810_g12217_i0 PRJNA800053 12381 284 1.63981 4.6570604 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 508 1.29e-139   NTclustered gi|1803023461|gb|MN937452.1| 2850 g12217 i0 99.288 194.542253521127 281 2 99 0 4 284 67870 68150 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 55250 508 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
2495456 2495456 PRJNA800053_P_NODE_1702_length_637_cov_9.404255_g1549_i0 PRJNA800053 1702 637 9.404255 59.90510435 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 1136 0   NTclustered gi|2202538974|gb|OM891880.1| 355634 g1549 i0 99.052 96.5447409733124 633 6 99 0 2 634 4385 3753 Navicula arenaria 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 61499 1136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
3771630 3771630 PRJNA800053_P_NODE_6083_length_374_cov_4.129568_g5920_i0 PRJNA800053 6083 374 4.129568 15.44458432 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 671 0   NTclustered gi|359385103|emb|FR865514.1| 29204 g5920 i0 99.727 97.8689839572193 366 1 98 0 7 372 398 33 Cyclotella cryptica genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 1070/2 blastn 36603 671 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
6323863 6323863 PRJNA800053_P_NODE_10465_length_302_cov_2.986900_g10301_i0 PRJNA800053 10465 302 2.9869 9.020438 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 514 2.98e-141   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g10301 i0 97.667 195.062913907285 300 5 99 2 4 302 69280 69578 Asterionella formosa chloroplast, complete genome blastn 58909 514 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
6323866 6323866 PRJNA800053_P_NODE_12585_length_282_cov_6.143541_g12421_i0 PRJNA800053 12585 282 6.143541 17.32478562 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 516 7.67e-142   NTclustered gi|952988067|gb|KT072974.1| 85094 g12421 i0 99.645 100 282 1 100 0 1 282 87 368 Nitzschia frustulum isolate TCC551 18S ribosomal RNA gene, partial sequence blastn 28200 516 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia frustulum
9724357 9724357 PRJNA800053_P_NODE_24468_length_234_cov_2.248447_g24304_i0 PRJNA800053 24468 234 2.248447 5.26136598 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 361 3.0699999999999996e-95   NTclustered gi|2862228875|gb|PQ645509.1| 1884248 g24304 i0 94.805 97.8760683760684 231 12 99 0 3 233 3985 3755 Nitzschia sp. (in: diatoms) isolate AGSB0363 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 22903 361 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
10148398 10148398 PRJNA800053_P_NODE_25148_length_210_cov_18.386861_g24984_i0 PRJNA800053 25148 210 18.386861 38.6124081 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 379 7.439999999999998e-101   NTclustered gi|2202538974|gb|OM891880.1| 355634 g24984 i0 100 97.9142857142857 205 0 98 0 6 210 3535 3331 Navicula arenaria 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 20562 379 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
10148412 10148412 PRJNA800053_P_NODE_8208_length_333_cov_1.165385_g8044_i0 PRJNA800053 8208 333 1.165385 3.88073205 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 67.6 1.12e-6   NTclustered gi|2248495830|ref|NC_063456.1| 303402 g8044 i0 93.478 3.57357357357357 46 2 14 1 143 188 18096 18140 Nitzschia dissipata isolate Qingdao in China mitochondrion, complete genome blastn 1190 67.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
12275615 12275615 PRJNA800053_P_NODE_13990_length_272_cov_3.195980_g13826_i0 PRJNA800053 13990 272 3.19598 8.6930656 Brebissonia lanceolata 487518 SAR_Eukaryotes SAR_Eukaryotes 488 1.6099999999999996e-133   NTclustered gi|168145745|emb|AM502026.1| 487518 g13826 i0 100 97.3713235294118 264 0 97 0 4 267 350 87 Cymbella lanceolata 18S rRNA gene, strain AT-194Gel07 blastn 26485 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Brebissonia Brebissonia lanceolata
13549867 13549867 PRJNA800053_P_NODE_5751_length_383_cov_3.522581_g5588_i0 PRJNA800053 5751 383 3.522581 13.49148523 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|757957156|gb|KM981439.1| 29205 g5588 i0 97.889 98.7937336814621 379 6 98 2 4 380 492 114 Cyclotella meneghiniana strain CCAC 3539 B 28S ribosomal RNA gene, partial sequence blastn 37838 654 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
15248142 15248142 PRJNA800053_P_NODE_24692_length_230_cov_2.649682_g24528_i0 PRJNA800053 24692 230 2.649682 6.0942686 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 403 4.92e-108   NTclustered gi|1169296927|gb|KY364697.1| 29204 g24528 i0 98.678 102.2 227 3 99 0 1 227 4610 4384 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 23506 403 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
17797503 17797503 PRJNA800053_P_NODE_24934_length_226_cov_2.379085_g24770_i0 PRJNA800053 24934 226 2.379085 5.3767321 Thalassiosiraceae 29202 SAR_Eukaryotes SAR_Eukaryotes 274 3.9399999999999997e-69   NTclustered gi|2862228885|gb|PQ645519.1| 340024 g24770 i0 88.789 98.9336283185841 223 25 99 0 4 226 3491 3713 Thalassiosira aestivalis isolate AGSB0379 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 22359 274 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira aestivalis
19071646 19071646 PRJNA800053_P_NODE_24975_length_224_cov_11.205298_g24811_i0 PRJNA800053 24975 224 11.205298 25.09986752 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 375 1.04e-99   NTclustered gi|407179826|gb|JX437396.1| 29204 g24811 i0 100 90.6026785714286 203 0 91 0 4 206 56 258 Cyclotella cryptica strain CCMP331 18S ribosomal RNA gene, partial sequence blastn 20295 375 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
21198585 21198585 PRJNA800053_P_NODE_1397_length_686_cov_4.536705_g1250_i0 PRJNA800053 1397 686 4.536705 31.1217963 Navicula radiosa 431563 SAR_Eukaryotes SAR_Eukaryotes 1201 0   NTclustered gi|2162236523|gb|OL780378.1| 431563 g1250 i0 98.392 98.1690962099125 684 10 99 1 1 683 726 43 Navicula radiosa strain CBac2019040 large subunit ribosomal RNA gene, partial sequence blastn 67344 1201 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula radiosa
22897453 22897453 PRJNA800053_P_NODE_25158_length_210_cov_4.145985_g24994_i0 PRJNA800053 25158 210 4.145985 8.7065685 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 156 1.37e-33   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g24994 i0 80.597 44.0666666666667 201 39 96 0 7 207 3730 3930 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 9254 156 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
23748971 23748971 PRJNA800053_P_NODE_6319_length_369_cov_8.915541_g6155_i0 PRJNA800053 6319 369 8.915541 32.89834629 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 682 0   NTclustered gi|1169296926|gb|KY364696.1| 29205 g6155 i0 100 100.368563685637 369 0 100 0 1 369 4390 4022 Cyclotella meneghiniana 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 37036 682 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
27243688 27243688 PRJNA800053_P_NODE_19643_length_247_cov_2.643678_g19479_i0 PRJNA800053 19643 247 2.643678 6.52988466 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.36e-15   NR KAG7352363.1 303405 g19479 i0 54.5 2.80566801619433 77 35 93.5 0 235 5 112 188 KAG7352363.1 hypothetical protein IV203_008411 [Nitzschia inconspicua] diamond 693 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
28348919 28348919 PRJNA800053_P_NODE_14066_length_272_cov_1.356784_g13902_i0 PRJNA800053 14066 272 1.356784 3.69045248 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 112 1.64e-26   NR KAL3795670.1 29204 g13902 i0 87.7 0.716911764705882 65 8 71.7 0 197 3 355 419 KAL3795670.1 hypothetical protein HJC23_002077 [Cyclotella cryptica] diamond 195 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30307338 30307338 PRJNA800053_P_NODE_17972_length_250_cov_0.870056_g17808_i0 PRJNA800053 17972 250 0.870056 2.17514 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 72 1.36e-12   NR KAI2497134.1 210448 g17808 i0 48.7 2.376 76 38 90 1 21 245 132 207 KAI2497134.1 hypothetical protein MHU86_17395 [Fragilaria crotonensis] diamond 594 72 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30402085 30402085 PRJNA800053_P_NODE_21913_length_244_cov_0.900585_g21749_i0 PRJNA800053 21913 244 0.900585 2.1974274 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 79.3 5.04e-15   NR GAX12872.1 1519565 g21749 i0 47.4 0.934426229508197 76 34 93.4 1 241 14 360 429 GAX12872.1 hypothetical protein FisN_32Lu084, partial [Fistulifera solaris] diamond 228 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31127956 31127956 PRJNA800053_P_NODE_10195_length_305_cov_6.435345_g10031_i0 PRJNA800053 10195 305 6.435345 19.62780225 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0145   NR CAB9509116.1 568900 g10031 i0 30.9 0.924590163934426 94 57 89.5 2 4 276 41 129 CAB9509116.1 hypothetical protein SEMRO_376_G129600.1 [Seminavis robusta] diamond 282 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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