RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1095825 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
2750259 2750259 PRJNA1095825_P_NODE_108583_length_366_cov_1.720137_g105520_i0 PRJNA1095825 108583 366 1.720137 6.29570142 Picornaviridae sp. 1530251 Viruses Viruses 263 1.47e-65   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g105520 i0 79.945 0.994535519125683 364 67 99 5 5 366 6769 6410 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 364 263 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
4026644 4026644 PRJNA1095825_P_NODE_171124_length_298_cov_2.395556_g168061_i0 PRJNA1095825 171124 298 2.395556 7.13875688 Picornaviridae sp. 1530251 Viruses Viruses 285 2.51e-72   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g168061 i0 83.893 1 298 48 100 0 1 298 3280 3577 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 298 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
6577676 6577676 PRJNA1095825_P_NODE_135406_length_332_cov_1.710425_g132343_i0 PRJNA1095825 135406 332 1.710425 5.678611 brine shrimp iflavirus 3 2900464 Viruses Viruses 592 1.49e-164   NTclustered gi|2209094754|gb|OL472449.1| 2900464 g132343 i0 98.795 11 332 4 100 0 1 332 8991 8660 MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds blastn 3652 592 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
7852678 7852678 PRJNA1095825_P_NODE_160307_length_308_cov_1.310638_g157244_i0 PRJNA1095825 160307 308 1.310638 4.03676504 Picornaviridae sp. 1530251 Viruses Viruses 547 3.0099999999999987e-151   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g157244 i0 99.338 0.980519480519481 302 2 98 0 6 307 1872 1571 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 302 547 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
9127391 9127391 PRJNA1095825_P_NODE_130688_length_337_cov_2.272727_g127625_i0 PRJNA1095825 130688 337 2.272727 7.65908999 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.009   NTclustered gi|2557392663|emb|OY660716.1| 2697049 g127625 i0 100 0.086053412462908 29 0 9 0 309 337 25724 25752 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
11679930 11679930 PRJNA1095825_P_NODE_30750_length_716_cov_1.945568_g27783_i0 PRJNA1095825 30750 716 1.945568 13.93026688 Picornaviridae sp. 1530251 Viruses Viruses 394 1.0299999999999999e-104   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g27783 i0 77.04 1.00977653631285 723 142 99 22 3 714 7695 6986 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 723 394 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
16776813 16776813 PRJNA1095825_P_NODE_133254_length_335_cov_1.000000_g130191_i0 PRJNA1095825 133254 335 1 3.35 Betacoronavirus pandemicum 3418604 Viruses Viruses 56.5 0.002   NTclustered gi|2557634435|emb|OY691424.1| 2697049 g130191 i0 96.97 0.0985074626865672 33 1 10 0 1 33 7580 7548 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 33 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
18051711 18051711 PRJNA1095825_P_NODE_171455_length_298_cov_1.368889_g168392_i0 PRJNA1095825 171455 298 1.368889 4.07928922 brine shrimp iflavirus 3 2900464 Viruses Viruses 529 1.0499999999999996e-145   NTclustered gi|2209094746|gb|OL472445.1| 2900464 g168392 i0 98.658 11 298 4 100 0 1 298 7350 7053 MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds blastn 3278 529 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus brine shrimp iflavirus 3
23152218 23152218 PRJNA1095825_P_NODE_158839_length_309_cov_1.953390_g155776_i0 PRJNA1095825 158839 309 1.95339 6.0359751 Picornaviridae sp. 1530251 Viruses Viruses 532 8.45e-147   NTclustered gi|2780183578|gb|PP818844.1| 1530251 g155776 i0 97.735 1 309 7 100 0 1 309 1254 946 Picornaviridae sp. polyprotein and capsid protein genes, complete cds blastn 309 532 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;