RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

  • Kitrinoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA870096 · 6 ✖

analysis 1

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
3789272 3789272 PRJNA870096_S_NODE_78603_length_198_cov_1.109677_g76939_i0 PRJNA870096 78603 198 1.109677 2.19716046 Pestivirus 11095 Viruses Viruses 326 9.16e-85   NTclustered gi|530291193|gb|KC963967.1| 11099 g76939 i0 96.907 96.7323232323232 194 6 98 0 5 198 61 254 Bovine viral diarrhea virus 1 isolate 12F004, complete genome blastn 19153 327 0.996941896024465 Viruses   Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae Pestivirus Pestivirus bovis
9778248 9778248 PRJNA870096_S_NODE_61288_length_224_cov_1.303867_g59624_i0 PRJNA870096 61288 224 1.303867 2.92066208 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.006   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g59624 i0 100 0.254464285714286 29 0 13 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
11053539 11053539 PRJNA870096_S_NODE_15309_length_467_cov_3.457547_g13670_i0 PRJNA870096 15309 467 3.457547 16.14674449 Jujube closterovirus 1 3043313 Viruses Viruses 56.5 0.004   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g13670 i0 100 0.124197002141328 30 0 6 0 1 30 6 35 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
13603874 13603874 PRJNA870096_S_NODE_49031_length_252_cov_0.684211_g47367_i0 PRJNA870096 49031 252 0.684211 1.72421172 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.006   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g47367 i0 100 0.226190476190476 29 0 12 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
17427959 17427959 PRJNA870096_S_NODE_14334_length_484_cov_3.764172_g12698_i0 PRJNA870096 14334 484 3.764172 18.21859248 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.013   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g12698 i0 100 0.117768595041322 29 0 6 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
18701565 18701565 PRJNA870096_S_NODE_47435_length_256_cov_2.028169_g45771_i0 PRJNA870096 47435 256 2.028169 5.19211264 Carlavirus latensdianthi 3427766 Viruses Viruses 58.4 5e-4   NTclustered gi|1995060321|gb|MN450069.1| 12164 g45771 i0 94.737 0.71484375 38 1 14 1 220 256 50 13 Carnation latent virus isolate KL, complete genome blastn 183 58.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi

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