RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA722925" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA722925 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_clade 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
1193691 1193691 PRJNA722925_S_NODE_601_length_532_cov_3.977778_g542_i0 PRJNA722925 601 532 3.977778 21.16177896 Tobamovirus 12234 Viruses Viruses 972 0   NTclustered gi|2463200702|gb|ON987477.1| 12253 g542 i0 99.624 99.7763157894737 532 2 100 0 1 532 3270 3801 Tomato mosaic virus isolate NPPO-NL 41833930 RdRp, small replicase subunit, MP, and CP genes, complete cds blastn 53081 972 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
10914274 10914274 PRJNA722925_S_NODE_10909_length_153_cov_1.008621_g10846_i0 PRJNA722925 10909 153 1.008621 1.54319013 Tobamovirus tomatotessellati 3432892 Viruses Viruses 283 4.0799999999999995e-72   NTclustered gi|924441762|emb|LN827938.1| 12253 g10846 i0 100 100 153 0 100 0 1 153 179 27 Tomato mosaic virus viral cRNA for coat and movement proteins (MP and CP genes), isolate AH9 blastn 15300 283 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
19045483 19045483 PRJNA722925_S_NODE_4995_length_203_cov_1.879518_g4932_i0 PRJNA722925 4995 203 1.879518 3.81542154 Tobamovirus 12234 Viruses Viruses 370 4.3e-98   NTclustered gi|1338641205|gb|KY967228.1| 12253 g4932 i0 99.507 100 203 1 100 0 1 203 4849 4647 Tomato mosaic virus isolate HHHT, complete genome blastn 20300 370 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tomatotessellati
21595871 21595871 PRJNA722925_S_NODE_5097_length_201_cov_1.664634_g5034_i0 PRJNA722925 5097 201 1.664634 3.34591434 Tobamovirus 12234 Viruses Viruses 366 5.5e-97   NTclustered gi|4377853|gb|AF062519.1|AF062519 12242 g5034 i0 99.502 100 201 1 100 0 1 201 165 365 Tobacco mosaic virus movement protein and coat protein genes, complete cds blastn 20100 366 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci

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