RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA473201 · 15 ✖

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
444027 444027 PRJNA473201_P_NODE_52001_length_287_cov_1.373832_g51259_i0 PRJNA473201 52001 287 1.373832 3.94289784 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 255 1.88e-63   NTclustered gi|657012369|gb|KF302532.1| 2850 g51259 i0 88.571 0.731707317073171 210 24 73 0 75 284 226 17 Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds blastn 210 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
1719328 1719328 PRJNA473201_P_NODE_75502_length_246_cov_0.890173_g74760_i0 PRJNA473201 75502 246 0.890173 2.18982558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 9.57e-25   NR CAJ1931814.1 2856 g74760 i0 66.7 22.7682926829268 69 23 84.1 0 39 245 9 77 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 5601 104 0.990384615384615 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
5547780 5547780 PRJNA473201_P_NODE_59485_length_267_cov_40.067010_g58743_i0 PRJNA473201 59485 267 40.06701 106.9789167 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 69.4 2.43e-7   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g58743 i0 76.154 0.973782771535581 130 31 49 0 1 130 8137 8266 Asterionella formosa chloroplast, complete genome blastn 260 69.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
15746695 15746695 PRJNA473201_P_NODE_52173_length_286_cov_20.446009_g51431_i0 PRJNA473201 52173 286 20.446009 58.47558574 Psammoneis obaidii 1706219 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.22e-5   NTclustered gi|1418588230|ref|NC_038004.1| 1706219 g51431 i0 95 0.947552447552448 40 2 14 0 1 40 59710 59749 Psammoneis obaidii chloroplast, complete genome blastn 271 63.9 1 Eukaryota Sar   Bacillariophyta Mediophyceae Triceratiales Plagiogrammaceae Psammoneis Psammoneis obaidii
20845999 20845999 PRJNA473201_P_NODE_70077_length_249_cov_0.875000_g69335_i0 PRJNA473201 70077 249 0.875 2.17875 Ulnaria acus 1436140 SAR_Eukaryotes SAR_Eukaryotes 92 1.61e-19   NR XBC19452.1 1436140 g69335 i0 57.8 1.87951807228916 83 33 100 1 1 249 346 426 XBC19452.1 glutathione synthase [Ulnaria acus] diamond 468 92 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria acus
22120127 22120127 PRJNA473201_P_NODE_29698_length_362_cov_2.162630_g28956_i0 PRJNA473201 29698 362 2.16263 7.8287206 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 118 1.26e-31   NR EJK75259.1 159749 g28956 i0 63.6 1.43370165745856 88 32 72.9 0 266 3 9 96 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 519 118 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
23396335 23396335 PRJNA473201_P_NODE_58539_length_270_cov_1.436548_g57797_i0 PRJNA473201 58539 270 1.436548 3.8786796 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 106 1.87e-18   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g57797 i0 84.762 29.8444444444444 105 16 39 0 36 140 9675 9571 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 8058 106 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
27170802 27170802 PRJNA473201_P_NODE_70802_length_249_cov_0.875000_g70060_i0 PRJNA473201 70802 249 0.875 2.17875 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.62e-5   NR KAG7344243.1 303405 g70060 i0 35.4 1.96385542168675 82 48 98.8 3 248 3 563 639 KAG7344243.1 hypothetical protein IV203_022251 [Nitzschia inconspicua] diamond 489 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27676665 27676665 PRJNA473201_P_NODE_52944_length_284_cov_30.933649_g52202_i0 PRJNA473201 52944 284 30.933649 87.85156316 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 53.5 1e-5   NR KAI2502745.1 210448 g52202 i0 53.1 0.517605633802817 49 23 51.8 0 2 148 116 164 KAI2502745.1 hypothetical protein MHU86_11730 [Fragilaria crotonensis] diamond 147 53.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28402624 28402624 PRJNA473201_P_NODE_77046_length_245_cov_0.895349_g76304_i0 PRJNA473201 77046 245 0.895349 2.19360505 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 100 3.76e-24   NR OEU08698.1 635003 g76304 i0 60.5 0.991836734693878 81 29 95.5 1 5 238 7 87 OEU08698.1 putative glutathione S-transferase [Fragilariopsis cylindrus CCMP1102] diamond 243 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29065809 29065809 PRJNA473201_P_NODE_81428_length_243_cov_0.905882_g80686_i0 PRJNA473201 81428 243 0.905882 2.20129326 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 62.8 3.23e-9   NR KAL3760706.1 259834 g80686 i0 41.8 3.33333333333333 67 37 82.7 1 243 43 328 392 KAL3760706.1 hypothetical protein ACHAWU_000026 [Discostella pseudostelligera] diamond 810 62.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31324598 31324598 PRJNA473201_P_NODE_37455_length_326_cov_1.217391_g36713_i0 PRJNA473201 37455 326 1.217391 3.96869466 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 161 5.01e-45   NR KAG7341965.1 303405 g36713 i0 73.6 7.82208588957055 106 27 97.5 1 325 8 300 404 KAG7341965.1 preprotein translocase subunit Sec& domain containing protein [Nitzschia inconspicua] diamond 2550 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31530091 31530091 PRJNA473201_P_NODE_86376_length_238_cov_2.436364_g85634_i0 PRJNA473201 86376 238 2.436364 5.79854632 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 62 1.19e-9   NR CAJ1966799.1 2856 g85634 i0 54.2 1.34873949579832 48 22 60.5 0 57 200 129 176 CAJ1966799.1 unnamed protein product [Cylindrotheca closterium] diamond 321 62 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32289572 32289572 PRJNA473201_P_NODE_52299_length_286_cov_1.600939_g51557_i0 PRJNA473201 52299 286 1.600939 4.57868554 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 88.2 8.29e-20   NR GKY91745.1 2872254 g51557 i0 51.6 1.65734265734266 93 31 96.5 3 7 282 14 93 GKY91745.1 hypothetical protein MPSEU_000146200 [Mayamaea pseudoterrestris] diamond 474 88.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32904802 32904802 PRJNA473201_P_NODE_10020_length_638_cov_22.814159_g9291_i0 PRJNA473201 10020 638 22.814159 145.55433442 root 1 Root_unresolved Root_unresolved 114 1.14e-26   NR AAX82959.1 2843 g9291 i0 45 7.27429467084639 140 77 65.8 0 150 569 68 207 AAX82959.1 photosystem II protein D2, partial [Skeletonema costatum] diamond 4641 115 0.991304347826087 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum

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