RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA691918" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA691918 · 9 ✖

analysis 1

  • blastn · 9 ✖
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
1948489 1948489 PRJNA691918_S_NODE_42_length_262_cov_15141.411255_g41_i0 PRJNA691918 42 262 15141.411255 39670.4974881 Betacoronavirus pandemicum 3418604 Viruses Viruses 150 8.24e-32   NTclustered gi|2165836883|emb|OV197187.1| 2697049 g41 i0 89.256 16.530534351145 121 7 44 2 148 262 221 101 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4331 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
3731047 3731047 PRJNA691918_S_NODE_343_length_171_cov_5.778571_g342_i0 PRJNA691918 343 171 5.778571 9.88135641 Viruses 10239 Viruses Viruses 305 9.96e-79   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g342 i0 99.408 2.98245614035088 169 0 98 1 4 171 2385 2217 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 510 305 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
8325607 8325607 PRJNA691918_S_NODE_247_length_187_cov_19168.929487_g246_i0 PRJNA691918 247 187 19168.929487 35845.89814069 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 241 3.18e-59   NTclustered gi|2754692002|gb|PP872741.1| 3003959 g246 i0 98.529 22.0748663101604 136 2 73 0 1 136 8496 8631 MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence blastn 4128 241 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8325608 8325608 PRJNA691918_S_NODE_27_length_282_cov_13736.418327_g26_i0 PRJNA691918 27 282 13736.418327 38736.69968214 Betacoronavirus pandemicum 3418604 Viruses Viruses 152 2.49e-32   NTclustered gi|2165836883|emb|OV197187.1| 2697049 g26 i0 89.256 17.4326241134752 121 7 41 2 1 115 101 221 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4916 152 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
8832180 8832180 PRJNA691918_S_NODE_107_length_222_cov_16011.392670_g106_i0 PRJNA691918 107 222 16011.39267 35545.2917274 Viruses 10239 Viruses Viruses 313 8.18e-81   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g106 i0 99.422 20.481981981982 173 0 78 1 2 174 1850 2021 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 4547 313 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
14701476 14701476 PRJNA691918_S_NODE_32_length_275_cov_14338.286885_g31_i0 PRJNA691918 32 275 14338.286885 39430.28893375 Betacoronavirus pandemicum 3418604 Viruses Viruses 150 8.709999999999998e-32   NTclustered gi|2165836883|emb|OV197187.1| 2697049 g31 i0 89.256 15 121 7 42 2 1 115 101 221 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4125 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
17757070 17757070 PRJNA691918_S_NODE_234_length_189_cov_19008.487342_g233_i0 PRJNA691918 234 189 19008.487342 35926.04107638 Viruses 10239 Viruses Viruses 267 5.32e-67   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g233 i0 98.667 23.2698412698413 150 2 79 0 38 187 2524 2375 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 4398 267 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
18524468 18524468 PRJNA691918_S_NODE_15_length_308_cov_12626.458484_g14_i0 PRJNA691918 15 308 12626.458484 38889.49213072 Betacoronavirus pandemicum 3418604 Viruses Viruses 150 9.91e-32   NTclustered gi|2165836883|emb|OV197187.1| 2697049 g14 i0 89.256 13.3928571428571 121 7 37 2 1 115 101 221 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4125 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23625185 23625185 PRJNA691918_S_NODE_19_length_293_cov_13372.465649_g18_i0 PRJNA691918 19 293 13372.465649 39181.32435157 Betacoronavirus pandemicum 3418604 Viruses Viruses 150 9.37e-32   NTclustered gi|2165836883|emb|OV197187.1| 2697049 g18 i0 89.256 16.9215017064846 121 7 39 2 1 115 101 221 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 4958 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum

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