RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA674048" 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

bioproject 1

  • PRJNA674048 · 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
643004 643004 PRJNA674048_P_NODE_21301_length_190_cov_3.113475_g21098_i0 PRJNA674048 21301 190 3.113475 5.9156025 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 351 1.4399999999999997e-92   NTclustered gi|168145881|emb|AM710515.1| 431330 g21098 i0 100 61.6736842105263 190 0 100 0 1 190 336 525 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 11718 351 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
643053 643053 PRJNA674048_P_NODE_27461_length_168_cov_1.747899_g27258_i0 PRJNA674048 27461 168 1.747899 2.93647032 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 305 9.81e-79   NTclustered gi|1803023461|gb|MN937452.1| 2850 g27258 i0 99.405 98.7142857142857 168 1 100 0 1 168 57830 57663 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 16584 305 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
1919234 1919234 PRJNA674048_P_NODE_21302_length_190_cov_3.106383_g21099_i0 PRJNA674048 21302 190 3.106383 5.9021277 Stephanopyxis turris 515487 SAR_Eukaryotes SAR_Eukaryotes 263 6.93e-66   NTclustered gi|2429802910|ref|NC_069609.1| 515487 g21099 i0 93.407 188.263157894737 182 4 94 7 13 190 13745 13922 Stephanopyxis turris chloroplast, complete genome blastn 35770 263 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Stephanopyxidaceae Stephanopyxis Stephanopyxis turris
4471057 4471057 PRJNA674048_P_NODE_24224_length_178_cov_5.844961_g24021_i0 PRJNA674048 24224 178 5.844961 10.40403058 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 169 1.4299999999999998e-37   NTclustered gi|1549146932|gb|MH810167.1| 1487565 g24021 i0 87.755 17.7696629213483 147 14 81 4 8 152 7256 7112 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 3163 169 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
5746556 5746556 PRJNA674048_P_NODE_21265_length_190_cov_8.723404_g21062_i0 PRJNA674048 21265 190 8.723404 16.5744676 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 324 3.13e-84   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g21062 i0 97.368 30.9736842105263 190 5 100 0 1 190 7093 7282 Nitzschia anatoliensis clone SZCZ E372 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 5885 324 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
7543795 7543795 PRJNA674048_P_NODE_16666_length_218_cov_1.715976_g16463_i0 PRJNA674048 16666 218 1.715976 3.74082768 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 231 2.3099999999999997e-56   NTclustered gi|2202538977|gb|OM891883.1| 1960768 g16463 i0 85.845 10.7247706422018 219 29 100 2 1 218 3942 4159 Pleurosigma sp. 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 2338 231 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp.
15945878 15945878 PRJNA674048_P_NODE_6653_length_389_cov_1.070588_g6450_i0 PRJNA674048 6653 389 1.070588 4.16458732 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 327 5.51e-85   NTclustered gi|657012566|gb|KF302620.1| 2850 g6450 i0 86.842 91 304 27 75 8 1 291 567 870 Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds blastn 35399 327 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19769883 19769883 PRJNA674048_P_NODE_10556_length_288_cov_2.615063_g10353_i0 PRJNA674048 10556 288 2.615063 7.53138144 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 488 1.7099999999999998e-133   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g10353 i0 97.222 99.9305555555556 288 8 100 0 1 288 3578 3865 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 28780 488 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
19769959 19769959 PRJNA674048_P_NODE_22736_length_184_cov_2.155556_g22533_i0 PRJNA674048 22736 184 2.155556 3.96622304 Halamphora acutiuscula 650507 SAR_Eukaryotes SAR_Eukaryotes 134 5.45e-27   NTclustered gi|674277762|gb|KJ751530.1| 650507 g22533 i0 83.226 0.842391304347826 155 17 81 6 32 180 661 812 Amphora acutiuscula clone Aacutmar3.2 transposon mariner-like, complete sequence blastn 155 134 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora acutiuscula
27492630 27492630 PRJNA674048_P_NODE_23023_length_183_cov_1.940299_g22820_i0 PRJNA674048 23023 183 1.940299 3.55074717 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 57.8 8.1e-8   NR KAI2489933.1 210448 g22820 i0 53.4 9.42622950819672 58 25 91.8 1 14 181 176 233 KAI2489933.1 ABC-2 type transporter [Fragilaria crotonensis] diamond 1725 57.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29229347 29229347 PRJNA674048_P_NODE_30749_length_164_cov_1.200000_g30546_i0 PRJNA674048 30749 164 1.2 1.968 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0329   NR GAX14402.1 1519565 g30546 i0 47.1 0.621951219512195 34 18 62.2 0 108 7 339 372 GAX14402.1 pre-rRNA-processing protein TSR4 [Fistulifera solaris] diamond 102 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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