RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA407368", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA407368 · 8 ✖

analysis 1

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
414944 414944 PRJNA407368_S_NODE_10381_length_152_cov_4.731707_g10279_i0 PRJNA407368 10381 152 4.731707 7.19219464 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 158 2.56e-34   NTclustered gi|2632235302|gb|OR922684.1| 1884248 g10279 i0 87.234 20.5328947368421 141 15 91 3 1 139 3985 4124 Nitzschia sp. (in: diatoms) strain AGSB0041 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 3121 158 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
9343258 9343258 PRJNA407368_S_NODE_4348_length_274_cov_6.146939_g4246_i0 PRJNA407368 4348 274 6.146939 16.84261286 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 429 9.949999999999999e-116   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g4246 i0 96.525 73.6386861313869 259 9 95 0 4 262 3927 3669 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 20177 429 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
10619002 10619002 PRJNA407368_S_NODE_3469_length_315_cov_115.024476_g3367_i0 PRJNA407368 3469 315 115.024476 362.3270994 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 351 2.6e-92   NTclustered gi|2632235312|gb|OR922694.1| 2856 g3367 i0 99.482 61.2507936507937 193 1 61 0 123 315 3268 3076 Cylindrotheca closterium strain AGSB0066 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 19294 351 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
15109432 15109432 PRJNA407368_S_NODE_3712_length_303_cov_57.208029_g3610_i0 PRJNA407368 3712 303 57.208029 173.34032787 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 276 1.5399999999999999e-69   NTclustered gi|1779750581|gb|MN750489.1| 303399 g3610 i0 99.342 82.9042904290429 152 1 83 0 127 278 539 690 Nitzschia acicularis strain Nit56 small subunit ribosomal RNA gene, partial sequence blastn 25120 276 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia acicularis
19540947 19540947 PRJNA407368_S_NODE_8456_length_175_cov_2.294521_g8354_i0 PRJNA407368 8456 175 2.294521 4.01541175 Pleurosigma sp. mgcode 4 2914906 SAR_Eukaryotes SAR_Eukaryotes 93.5 8.69e-15   NTclustered gi|2076000669|gb|MW861541.1| 2914906 g8354 i0 92.308 33.6857142857143 65 5 37 0 22 86 24731 24667 Pleurosigma sp. mgcode 4 isolate Qingdao in China mitochondrion, complete genome blastn 5895 93.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp. mgcode 4
20816638 20816638 PRJNA407368_S_NODE_10077_length_155_cov_5.619048_g9975_i0 PRJNA407368 10077 155 5.619048 8.7095244 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 209 7.15e-50   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g9975 i0 94.203 26.0709677419355 138 7 89 1 4 141 7070 7206 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 4041 209 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
23367232 23367232 PRJNA407368_S_NODE_7859_length_183_cov_7.337662_g7757_i0 PRJNA407368 7859 183 7.337662 13.42792146 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 296 6.52e-76   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g7757 i0 98.225 93.6284153005465 169 3 92 0 15 183 5641 5473 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 17134 296 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
25307851 25307851 PRJNA407368_S_NODE_4720_length_259_cov_7.843478_g4618_i0 PRJNA407368 4720 259 7.843478 20.31460802 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 446 9.26e-121   NTclustered gi|1209554701|gb|KX889110.1| 303399 g4618 i0 100 94.1003861003861 241 0 93 0 1 241 316 556 Nitzschia acicularis 28S ribosomal RNA gene, partial sequence blastn 24372 446 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia acicularis

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