RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA691918" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA691918 · 6 ✖

analysis 1

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
1179216 1179216 PRJNA691918_S_NODE_81_length_233_cov_15269.574257_g80_i0 PRJNA691918 81 233 15269.574257 35578.10801881 Streptophyta 35493 Plants Plants 298 2.43e-76   NTclustered gi|2750943029|gb|PP944824.1| 3252 g80 i0 96.154 78.1115879828326 182 7 78 0 49 230 1687 1506 Lycopodium clavatum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 18200 298 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Lycopodium Lycopodium clavatum
11382746 11382746 PRJNA691918_S_NODE_89_length_227_cov_15651.239796_g88_i0 PRJNA691918 89 227 15651.239796 35528.31433692 Eukaryota 2759 Plants Plants 283 6.589999999999999e-72   NTclustered gi|2463220|emb|X89872.1| 3207 g88 i0 95.977 76.6519823788546 174 7 77 0 4 177 805 978 L.heterophylla DNA for 18S ribosomal RNA blastn 17400 283 1 Eukaryota Embryophyta Viridiplantae Streptophyta Jungermanniopsida Jungermanniales Lophocoleaceae Lophocolea Lophocolea heterophylla
17757069 17757069 PRJNA691918_S_NODE_214_length_193_cov_253.530864_g213_i0 PRJNA691918 214 193 253.530864 489.31456752 Streptophyta 35493 Plants Plants 311 2.49e-80   NTclustered gi|2750943029|gb|PP944824.1| 3252 g213 i0 98.851 90.1554404145078 174 2 90 0 4 177 1506 1679 Lycopodium clavatum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 17400 311 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Lycopodium Lycopodium clavatum
19030907 19030907 PRJNA691918_S_NODE_215_length_193_cov_250.382716_g214_i0 PRJNA691918 215 193 250.382716 483.23864188 Eukaryota 2759 Plants Plants 289 1.1599999999999998e-73   NTclustered gi|2750943029|gb|PP944824.1| 3252 g214 i0 96.571 90.4248704663212 175 4 90 2 17 190 1679 1506 Lycopodium clavatum small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence blastn 17452 289 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Lycopodium Lycopodium clavatum
20305616 20305616 PRJNA691918_S_NODE_216_length_193_cov_229.382716_g215_i0 PRJNA691918 216 193 229.382716 442.70864188 Eukaryota 2759 Plants Plants 305 1.16e-78   NTclustered gi|2463220|emb|X89872.1| 3207 g215 i0 98.276 90.1554404145078 174 3 90 0 4 177 805 978 L.heterophylla DNA for 18S ribosomal RNA blastn 17400 305 1 Eukaryota Embryophyta Viridiplantae Streptophyta Jungermanniopsida Jungermanniales Lophocoleaceae Lophocolea Lophocolea heterophylla
25405680 25405680 PRJNA691918_S_NODE_160_length_204_cov_17359.300578_g159_i0 PRJNA691918 160 204 17359.300578 35412.97317912 Closterium 34145 Plants Plants 213 7.71e-51   NTclustered gi|23393859|gb|AF419990.1| 157566 g159 i0 96.154 64.2205882352941 130 5 64 0 48 177 330 201 Closterium spinosporum var. spinosporum 26S ribosomal RNA gene, partial sequence blastn 13101 213 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium spinosporum

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