RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_kingdom = "Viridiplantae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Viridiplantae · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA695140 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
2456774 2456774 PRJNA695140_S_NODE_3102_length_297_cov_2.519231_g2921_i0 PRJNA695140 3102 297 2.519231 7.48211607 Brassica 3705 Plants Plants 52.8 0.028   NTclustered gi|1516601317|emb|LR031880.1| 3712 g2921 i0 96.875 0.215488215488215 32 0 10 1 264 294 8564767 8564736 Brassica oleracea HDEM genome, scaffold: C6 blastn 64 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica oleracea
4504180 4504180 PRJNA695140_S_NODE_7224_length_196_cov_2.031447_g7043_i0 PRJNA695140 7224 196 2.031447 3.98163612 Ostreococcus sp. 'lucimarinus' 242159 Plants Plants 169 1.61e-37   NTclustered gi|1812772017|gb|MT117941.1| 242159 g7043 i0 91.129 73.5918367346939 124 11 63 0 26 149 3773 3650 Ostreococcus sp. 'lucimarinus' strain BCC118000 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 14424 169 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Bathycoccaceae Ostreococcus Ostreococcus sp. 'lucimarinus'
10880084 10880084 PRJNA695140_S_NODE_12149_length_155_cov_2.050847_g11968_i0 PRJNA695140 12149 155 2.050847 3.17881285 Lolium perenne 4522 Plants Plants 60.2 7.62e-5   NTclustered gi|2322634125|ref|XR_007879526.1| 4522 g11968 i0 92.857 26.7483870967742 42 1 26 2 1 40 2632 2591 PREDICTED: Lolium perenne 28S ribosomal RNA (LOC127346361), rRNA blastn 4146 60.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium perenne
19802914 19802914 PRJNA695140_S_NODE_12316_length_154_cov_2.709402_g12135_i0 PRJNA695140 12316 154 2.709402 4.17247908 Oryza sativa 4530 Plants Plants 268 1.15e-67   NTclustered gi|32994295|dbj|AK109086.1| 39947 g12135 i0 98.052 323.090909090909 154 3 100 0 1 154 1117 1270 Oryza sativa Japonica Group cDNA clone:002-154-H10, full insert sequence blastn 49756 268 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa

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