RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA505329", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Kitrinoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA505329 · 6 ✖

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
2385881 2385881 PRJNA505329_P_NODE_37302_length_176_cov_1.629921_g36831_i0 PRJNA505329 37302 176 1.629921 2.86866096 Tobamovirus 12234 Viruses Viruses 307 2.87e-79   NTclustered gi|139866184|dbj|AB276030.1| 12239 g36831 i0 98.844 92.5909090909091 173 1 98 1 4 175 4990 5162 Pepper mild mottle virus genomic RNA, complete genome, strain: L4BV blastn 16296 307 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus capsici
3034725 3034725 PRJNA505329_P_NODE_52663_length_151_cov_5.480392_g52192_i0 PRJNA505329 52663 151 5.480392 8.27539192 Alphanodavirus flockense 3426214 Viruses Viruses 279 5.19e-71   NTclustered gi|2775959247|dbj|LC831259.1| 12287 g52192 i0 100 4.98675496688742 151 0 100 0 1 151 891 741 Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds blastn 753 279 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Alphanodavirus Alphanodavirus flockense
13237000 13237000 PRJNA505329_P_NODE_111_length_3140_cov_101.013911_g87_i0 PRJNA505329 111 3140 101.013911 3171.8368054 Alphanodavirus flockense 3426214 Viruses Viruses 5655 0   NTclustered gi|2775959219|dbj|LC831249.1| 12287 g87 i0 99.518 45.5630573248408 3109 12 99 3 5 3112 1 3107 Flock House virus TNCL gene for Protein A and Protein B2, segment RNA1, complete cds blastn 143068 5655 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Alphanodavirus Alphanodavirus flockense
15786336 15786336 PRJNA505329_P_NODE_5273_length_334_cov_3.210526_g4803_i0 PRJNA505329 5273 334 3.210526 10.72315684 Alphanodavirus flockense 3426214 Viruses Viruses 603 6.929999999999998e-168   NTclustered gi|2775959247|dbj|LC831259.1| 12287 g4803 i0 100 6.82035928143713 326 0 98 0 3 328 887 1212 Flock House virus TNCL gene for capsid precursor protein alpha, segment RNA2, complete cds blastn 2278 603 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Alphanodavirus Alphanodavirus flockense
19609378 19609378 PRJNA505329_P_NODE_2996_length_524_cov_48.745263_g2559_i0 PRJNA505329 2996 524 48.745263 255.42517812 Alphanodavirus flockense 3426214 Viruses Viruses 387 1.24e-102   NTclustered gi|152143030|gb|EF690538.1| 12287 g2559 i0 99.528 6.66221374045802 212 1 94 0 4 215 42 253 Flock house virus isolate TNCL segment RNA2 protein alpha mRNA, complete cds blastn 3491 387 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae Alphanodavirus Alphanodavirus flockense
29334644 29334644 PRJNA505329_P_NODE_1949_length_746_cov_5.152080_g1573_i0 PRJNA505329 1949 746 5.15208 38.4345168 Viruses 10239 Viruses Viruses 130 5.28e-33   NR QKN84405.1 2735226 g1573 i0 43.1 2.83109919571046 181 94 71.6 3 211 744 39 213 QKN84405.1 hypothetical protein [Rice Tombus-like virus 3] diamond 2112 130 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Rice Tombus-like virus 3

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