RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA929924" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA929924 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2184214 2184214 PRJNA929924_P_NODE_13842_length_181_cov_1.181818_g13679_i0 PRJNA929924 13842 181 1.181818 2.13909058 Skokie dicistro-like virus 2789443 Viruses Viruses 324 2.95e-84   NTclustered gi|1940198090|gb|MT757477.1| 2789443 g13679 i0 98.895 2.9171270718232 181 2 100 0 1 181 187 367 Skokie dicistro-like virus strain CHNdf-3 polyprotein gene, partial cds blastn 528 324 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
11112555 11112555 PRJNA929924_P_NODE_17869_length_163_cov_0.912281_g17706_i0 PRJNA929924 17869 163 0.912281 1.48701803 Skokie dicistro-like virus 2789443 Viruses Viruses 285 1.23e-72   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g17706 i0 98.16 1 163 3 100 0 1 163 1612 1774 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 163 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
15282064 15282064 PRJNA929924_P_NODE_10912_length_224_cov_1.782857_g10749_i0 PRJNA929924 10912 224 1.782857 3.99359968 Viruses 10239 Viruses Viruses 414 2.1999999999999996e-111   NTclustered gi|2806502719|gb|PQ054859.1| 2789443 g10749 i0 100 3.125 224 0 100 0 1 224 3333 3556 MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence blastn 700 414 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
21311145 21311145 PRJNA929924_P_NODE_9897_length_248_cov_1.432161_g9734_i0 PRJNA929924 9897 248 1.432161 3.55175928 Skokie dicistro-like virus 2789443 Viruses Viruses 411 3.2099999999999995e-110   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g9734 i0 96.414 1.01209677419355 251 6 100 1 1 248 3121 3371 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 251 411 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
22585873 22585873 PRJNA929924_P_NODE_14738_length_171_cov_1.278689_g14575_i0 PRJNA929924 14738 171 1.278689 2.18655819 Skokie dicistro-like virus 2789443 Viruses Viruses 294 2.16e-75   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g14575 i0 97.661 1 171 4 100 0 1 171 1920 1750 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 171 294 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
22585879 22585879 PRJNA929924_P_NODE_16158_length_166_cov_1.777778_g15995_i0 PRJNA929924 16158 166 1.777778 2.95111148 Skokie dicistro-like virus 2789443 Viruses Viruses 285 1.26e-72   NTclustered gi|1935607033|gb|MT747992.1| 2789443 g15995 i0 97.59 1 166 4 100 0 1 166 1134 1299 Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds blastn 166 285 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
25135017 25135017 PRJNA929924_P_NODE_11980_length_204_cov_1.341935_g11817_i0 PRJNA929924 11980 204 1.341935 2.7375474 Skokie dicistro-like virus 2789443 Viruses Viruses 355 1.21e-93   NTclustered gi|2806502719|gb|PQ054859.1| 2789443 g11817 i0 98.039 1.98039215686275 204 4 100 0 1 204 4825 5028 MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence blastn 404 355 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Skokie dicistro-like virus
25135020 25135020 PRJNA929924_P_NODE_12100_length_202_cov_1.359477_g11937_i0 PRJNA929924 12100 202 1.359477 2.74614354 Betacoronavirus pandemicum 3418604 Viruses Viruses 374 3.3e-99   NTclustered gi|2028980905|gb|MZ002360.1| 2697049 g11937 i0 100 100 202 0 100 0 1 202 29499 29700 Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome blastn 20200 374 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);;