RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA546018" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA546018 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
511184 511184 PRJNA546018_S_NODE_48681_length_217_cov_435.961538_g48356_i0 PRJNA546018 48681 217 435.961538 946.03653746 Betacoronavirus pandemicum 3418604 Viruses Viruses 78.7 3.16e-10   NTclustered gi|2523416575|emb|OX996782.1| 2697049 g48356 i0 100 0.345622119815668 42 0 19 0 156 197 17654 17695 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 75 78.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1119142 1119142 PRJNA546018_S_NODE_40721_length_241_cov_23.955556_g40396_i0 PRJNA546018 40721 241 23.955556 57.73288996 Alphainfluenzavirus 197911 Viruses Viruses 270 5.499999999999999e-68   NTclustered gi|546235387|gb|KF609511.1| 1395980 g40396 i0 100 85.0622406639004 146 0 80 0 49 194 579 434 Influenza A virus (A/Shanghai/JS01/2013(H7N9)) segment 4 hemagglutinin (HA) gene, complete cds blastn 20500 270 1 Viruses   Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae Alphainfluenzavirus Alphainfluenzavirus influenzae
1786672 1786672 PRJNA546018_S_NODE_48682_length_217_cov_385.083333_g48357_i0 PRJNA546018 48682 217 385.083333 835.63083261 Betacoronavirus pandemicum 3418604 Viruses Viruses 78.7 3.16e-10   NTclustered gi|2523416575|emb|OX996782.1| 2697049 g48357 i0 100 0.345622119815668 42 0 19 0 21 62 17695 17654 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 75 78.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
1786852 1786852 PRJNA546018_S_NODE_60062_length_191_cov_4.476923_g59737_i0 PRJNA546018 60062 191 4.476923 8.55092293 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g59737 i0 100 0.151832460732984 29 0 15 0 163 191 44 16 Carnation latent virus isolate KL, complete genome blastn 29 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
3062088 3062088 PRJNA546018_S_NODE_47923_length_219_cov_114.544304_g47598_i0 PRJNA546018 47923 219 114.544304 250.85202576 Betacoronavirus pandemicum 3418604 Viruses Viruses 78.7 3.2e-10   NTclustered gi|2523416575|emb|OX996782.1| 2697049 g47598 i0 100 0.342465753424658 42 0 19 0 158 199 17654 17695 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 75 78.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
4338193 4338193 PRJNA546018_S_NODE_47704_length_220_cov_2.018868_g47379_i0 PRJNA546018 47704 220 2.018868 4.4415096 Tobamovirus tabaci 3432891 Viruses Viruses 348 2.2200000000000005e-91   NTclustered gi|2647550519|gb|OR843964.1| 12242 g47379 i0 98.485 89.4181818181818 198 2 90 1 1 197 742 545 Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds blastn 19672 348 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus tabaci
5614606 5614606 PRJNA546018_S_NODE_22505_length_338_cov_6.541516_g22180_i0 PRJNA546018 22505 338 6.541516 22.11032408 Wuhan aphid virus 1 1746067 Viruses Viruses 313 1.33e-80   NTclustered gi|943496544|gb|KR902723.1| 1746067 g22180 i0 84.543 1.87573964497041 317 47 93 2 1 316 1507 1192 Wuhan aphid virus 1 strain WHYC-1 segment 3, complete sequence blastn 634 313 1 Viruses Jingmenvirus group Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae   Wuhan aphid virus 1
5614920 5614920 PRJNA546018_S_NODE_41865_length_237_cov_61.045455_g41540_i0 PRJNA546018 41865 237 61.045455 144.67772835 Betacoronavirus pandemicum 3418604 Viruses Viruses 87.9 5.83e-13   NTclustered gi|2174999023|emb|OV377758.1| 2697049 g41540 i0 100 0.426160337552743 47 0 20 0 22 68 38 84 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 101 87.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
10714830 10714830 PRJNA546018_S_NODE_16029_length_412_cov_11.438746_g15704_i0 PRJNA546018 16029 412 11.438746 47.12763352 Betacoronavirus pandemicum 3418604 Viruses Viruses 87.9 1.09e-12   NTclustered gi|2174999023|emb|OV377758.1| 2697049 g15704 i0 100 0.114077669902913 47 0 11 0 345 391 84 38 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 47 87.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11322320 11322320 PRJNA546018_S_NODE_38009_length_250_cov_6.211640_g37684_i0 PRJNA546018 38009 250 6.21164 15.5291 Tobamovirus 12234 Viruses Viruses 425 1.16e-114   NTclustered gi|1821461776|gb|MN267897.1| 12239 g37684 i0 99.571 86.024 233 1 93 0 1 233 3830 3598 Pepper mild mottle virus isolate PMMoV_WW17-E1-Nben-pos, complete genome blastn 21506 425 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae Tobamovirus Tobamovirus capsici
11989605 11989605 PRJNA546018_S_NODE_23450_length_330_cov_6.427509_g23125_i0 PRJNA546018 23450 330 6.427509 21.2107797 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 484 2.5799999999999996e-132   NTclustered gi|2196304039|gb|MZ679032.1| 3003959 g23125 i0 94.888 5.91212121212121 313 11 94 5 11 320 4924 5234 MAG: Picornavirales sp. isolate 377R-k141_737244 putative polyprotein gene, partial cds blastn 1951 484 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
13264681 13264681 PRJNA546018_S_NODE_27231_length_303_cov_84.607438_g26906_i0 PRJNA546018 27231 303 84.607438 256.36053714 Betacoronavirus pandemicum 3418604 Viruses Viruses 78.7 4.66e-10   NTclustered gi|2523416575|emb|OX996782.1| 2697049 g26906 i0 100 1.65676567656766 42 0 14 0 21 62 17695 17654 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 502 78.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
18362821 18362821 PRJNA546018_S_NODE_51375_length_211_cov_1.300000_g51050_i0 PRJNA546018 51375 211 1.3 2.743 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 54.7 0.005   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g51050 i0 100 0.137440758293839 29 0 14 0 1 29 58 86 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
18363043 18363043 PRJNA546018_S_NODE_9435_length_565_cov_8.882937_g9116_i0 PRJNA546018 9435 565 8.882937 50.18859405 Botourmiaviridae sp. 2808997 Viruses Viruses 449 1.6899999999999998e-121   NTclustered gi|2320142628|gb|ON585088.1| 2808997 g9116 i0 82.084 0.968141592920354 547 79 95 18 30 565 2001 2539 MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds blastn 547 449 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
24736975 24736975 PRJNA546018_S_NODE_35060_length_262_cov_2.099502_g34735_i0 PRJNA546018 35060 262 2.099502 5.50069524 Wuhan aphid virus 1 1746067 Viruses Viruses 272 1.69e-68   NTclustered gi|1817956135|dbj|LC516841.1| 1746067 g34735 i0 87.654 2.75954198473282 243 19 90 8 24 258 2314 2553 Wuhan aphid virus 1 06BaA3 gene for non-structural protein 2, complete cds blastn 723 272 1 Viruses Jingmenvirus group Orthornavirae Kitrinoviricota Flasuviricetes Amarillovirales Flaviviridae   Wuhan aphid virus 1

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