RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 10 ✖

bioproject 1

  • PRJNA784298 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
24991925 24991925 PRJNA784298_P_NODE_80_length_4000_cov_4.950089_g64_i0 PRJNA784298 80 4000 4.950089 198.00356 Tolivirales sp. 2809914 Viruses Viruses 1074 0   NR WRQ65448.1 2809914 g64 i0 72 0.546 728 201 54.5 3 3661 1481 73 798 WRQ65448.1 polyprotein, partial [Tolivirales sp.] diamond 2184 1074 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
27306619 27306619 PRJNA784298_P_NODE_18623_length_287_cov_1.079439_g18422_i0 PRJNA784298 18623 287 1.079439 3.09798993 Grapevine wood holobiome associated deltaflexivirus 2 3384488 Viruses Viruses 50.4 1.14e-4   NR XLE34831.1 3384488 g18422 i0 41.1 0.585365853658537 56 33 58.5 0 7 174 196 251 XLE34831.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] diamond 168 50.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Deltaflexiviridae Deltaflexivirus Grapevine wood holobiome associated deltaflexivirus 2
27496103 27496103 PRJNA784298_P_NODE_24003_length_250_cov_0.870056_g23802_i0 PRJNA784298 24003 250 0.870056 2.17514 Hangzhou nephotettix cincticeps narnavirus 1 2905330 Viruses Viruses 59.3 6.01e-8   NR UHK03296.1 2905330 g23802 i0 40.2 1.044 87 47 99.6 3 2 250 262 347 UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] diamond 261 59.3 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Hangzhou nephotettix cincticeps narnavirus 1
27811956 27811956 PRJNA784298_P_NODE_10324_length_391_cov_1.389937_g10123_i0 PRJNA784298 10324 391 1.389937 5.43465367 Soybean thrips narna-like virus 1 2800851 Viruses Viruses 134 1.24e-33   NR QQP18719.1 2800851 g10123 i0 56.9 0.943734015345269 123 50 92.8 2 2 364 337 458 QQP18719.1 RNA-dependent RNA polymerase, partial [Soybean thrips narna-like virus 1] diamond 369 134 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Soybean thrips narna-like virus 1
27969590 27969590 PRJNA784298_P_NODE_21665_length_264_cov_1.209424_g21464_i0 PRJNA784298 21665 264 1.209424 3.19287936 Sand whiting narna-like virus 2903073 Viruses Viruses 54.7 3.1e-6   NR UHS16731.1 2903073 g21464 i0 42.9 0.875 77 41 86.4 3 261 34 113 187 UHS16731.1 MAG: RNA-dependent RNA polymerase, partial [Sand whiting narna-like virus] diamond 231 54.7 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sand whiting narna-like virus
27978885 27978885 PRJNA784298_P_NODE_17285_length_298_cov_2.395556_g17084_i0 PRJNA784298 17285 298 2.395556 7.13875688 Viruses 10239 Viruses Viruses 54.7 4.05e-6   NR UYL94510.1 2985704 g17084 i0 35.5 1.87248322147651 93 56 93.6 2 9 287 227 315 UYL94510.1 MAG: nucleocapsid protein [Leptosphaeria biglobosa negative single-stranded RNA virus 9] diamond 558 54.7 1 Viruses   Orthornavirae Negarnaviricota         Leptosphaeria biglobosa negative single-stranded RNA virus 9
28001400 28001400 PRJNA784298_P_NODE_25185_length_246_cov_0.890173_g24984_i0 PRJNA784298 25185 246 0.890173 2.18982558 Sichuan sediment alphaendornavirus 23 2824212 Viruses Viruses 68.2 4.32e-11   NR QYF50107.1 2824212 g24984 i0 45 0.975609756097561 80 43 96.3 1 240 4 467 546 QYF50107.1 MAG: polyprotein, partial [Sichuan sediment alphaendornavirus 23] diamond 240 68.2 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Endornaviridae Alphaendornavirus Sichuan sediment alphaendornavirus 23
28285143 28285143 PRJNA784298_P_NODE_24066_length_250_cov_0.870056_g23865_i0 PRJNA784298 24066 250 0.870056 2.17514 Plasmopara viticola lesion associated narnavirus 37 2719522 Viruses Viruses 67.4 8.59e-11   NR QIR30316.1 2719522 g23865 i0 40.5 0.948 79 46 94.8 1 2 238 972 1049 QIR30316.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated narnavirus 37] diamond 237 67.4 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae Narnavirus Plasmopara viticola lesion associated narnavirus 37
30527509 30527509 PRJNA784298_P_NODE_24013_length_250_cov_0.870056_g23812_i0 PRJNA784298 24013 250 0.870056 2.17514 Sand whiting narna-like virus 2903073 Viruses Viruses 87 1.07e-17   NR UHS16731.1 2903073 g23812 i0 48.8 0.96 80 41 96 0 246 7 690 769 UHS16731.1 MAG: RNA-dependent RNA polymerase, partial [Sand whiting narna-like virus] diamond 240 87 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Sand whiting narna-like virus
31127512 31127512 PRJNA784298_P_NODE_26175_length_243_cov_0.905882_g25974_i0 PRJNA784298 26175 243 0.905882 2.20129326 Dicistroviridae sp. 1955144 Viruses Viruses 133 5.87e-34   NR WVT45126.1 1955144 g25974 i0 81.3 0.987654320987654 80 15 98.8 0 2 241 1538 1617 WVT45126.1 MAG: RNA helicase [Dicistroviridae sp.] diamond 240 133 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.

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