RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA1092581 · 11 ✖

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
2746756 2746756 PRJNA1092581_P_NODE_126163_length_203_cov_6.330769_g125630_i0 PRJNA1092581 126163 203 6.330769 12.85146107 Craticula sp. 2862135 SAR_Eukaryotes SAR_Eukaryotes 254 4.52e-63   NTclustered gi|2904096389|gb|PQ891886.1| 2862135 g125630 i0 93.567 80.3990147783251 171 10 84 1 21 191 240 71 Craticula sp. isolate SZCZEY2171 chloroplast, complete genome blastn 16321 254 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp.
10399461 10399461 PRJNA1092581_P_NODE_14409_length_726_cov_13.961715_g13918_i0 PRJNA1092581 14409 726 13.961715 101.3620509 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 295 4.659999999999998e-99   NR OEU09268.1 635003 g13918 i0 85.9 2.69421487603306 163 23 67.4 0 81 569 2 164 OEU09268.1 putative peptidylprolyl isomerase A [Fragilariopsis cylindrus CCMP1102] diamond 1956 295 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
16775367 16775367 PRJNA1092581_P_NODE_97534_length_256_cov_17.300546_g97001_i0 PRJNA1092581 97534 256 17.300546 44.28939776 Halamphora sp. 1951536 SAR_Eukaryotes SAR_Eukaryotes 411 3.329999999999999e-110   NTclustered gi|2749492174|gb|PP727123.1| 1951536 g97001 i0 100 170.86328125 222 0 87 0 21 242 71028 71249 Halamphora sp. strain SZCZEY 2167 chloroplast, complete genome blastn 43741 411 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora sp.
21420284 21420284 PRJNA1092581_P_NODE_40517_length_429_cov_5.789326_g39984_i0 PRJNA1092581 40517 429 5.789326 24.83620854 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 202 3.88e-47   NTclustered gi|1169296927|gb|KY364697.1| 29204 g39984 i0 97.458 36.6293706293706 118 3 39 0 1 118 4354 4471 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 15714 202 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
23971225 23971225 PRJNA1092581_P_NODE_98819_length_254_cov_13.635359_g98286_i0 PRJNA1092581 98819 254 13.635359 34.63381186 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 350 7.3e-92   NTclustered gi|1418587140|ref|NC_037996.1| 3005 g98286 i0 95.434 170.716535433071 219 10 86 0 15 233 66867 66649 Rhizosolenia setigera chloroplast, complete genome blastn 43362 350 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Sundstroemia Sundstroemia setigera
26900893 26900893 PRJNA1092581_P_NODE_42521_length_417_cov_7.866279_g41988_i0 PRJNA1092581 42521 417 7.866279 32.80238343 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.7 4.68e-10   NR EJK58599.1 159749 g41988 i0 72.1 0.956834532374101 43 12 30.9 0 397 269 102 144 EJK58599.1 hypothetical protein THAOC_21264 [Thalassiosira oceanica] diamond 399 64.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27162168 27162168 PRJNA1092581_P_NODE_63922_length_330_cov_2.591440_g63389_i0 PRJNA1092581 63922 330 2.59144 8.551752 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 169 1.41e-48   NR KAL3784922.1 382360 g63389 i0 67 3.93636363636364 109 36 99.1 0 329 3 200 308 KAL3784922.1 hypothetical protein ACHAWO_001209 [Cyclotella atomus] diamond 1299 169 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27762825 27762825 PRJNA1092581_P_NODE_64104_length_329_cov_5.878906_g63571_i0 PRJNA1092581 64104 329 5.878906 19.34160074 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00245   NR KAK1749274.1 267567 g63571 i0 35.7 0.765957446808511 84 52 74.8 1 267 22 916 999 KAK1749274.1 regulator of G-protein signaling [Skeletonema marinoi] diamond 252 47.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28299235 28299235 PRJNA1092581_P_NODE_56226_length_355_cov_5.329787_g55693_i0 PRJNA1092581 56226 355 5.329787 18.92074385 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.00163   NR KAL3784490.1 29204 g55693 i0 46 1.42816901408451 50 26 41.4 1 9 155 42 91 KAL3784490.1 hypothetical protein HJC23_013633 [Cyclotella cryptica] diamond 507 48.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
31426373 31426373 PRJNA1092581_P_NODE_53496_length_365_cov_10.667808_g52963_i0 PRJNA1092581 53496 365 10.667808 38.9374992 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 48.9 9.39e-4   NR XP_002178012.1 556484 g52963 i0 55.6 0.443835616438356 54 21 44.4 1 30 191 35 85 XP_002178012.1 RAD23 [Phaeodactylum tricornutum CCAP 1055/1] diamond 162 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31521440 31521440 PRJNA1092581_P_NODE_97796_length_256_cov_3.890710_g97263_i0 PRJNA1092581 97796 256 3.89071 9.9602176 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 113 3.68e-29   NR GKY97295.1 2872254 g97263 i0 95.3 0.75 64 3 75 0 22 213 138 201 GKY97295.1 hypothetical protein MPSEU_000687900 [Mayamaea pseudoterrestris] diamond 192 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris

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