RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA857143" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 7 ✖

bioproject 1

  • PRJNA857143 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
11047158 11047158 PRJNA857143_S_NODE_169_length_2281_cov_5.031703_g115_i0 PRJNA857143 169 2281 5.031703 114.77314543 Sopawar virus 3131855 Viruses Viruses 91.3 8.85e-15   NR WZH62023.1 3131855 g115 i0 27.8 1.00613765892153 291 197 38.1 5 897 1766 260 538 WZH62023.1 MAG: RNA-dependent RNA polymerase [Sopawar virus] diamond 2295 91.3 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Sopawar virus
27023413 27023413 PRJNA857143_S_NODE_132422_length_281_cov_1.442308_g131329_i0 PRJNA857143 132422 281 1.442308 4.05288548 Pseudomonas phage phi12 161736 Viruses Viruses 79 8.39e-16   NR NP_690826.1 161736 g131329 i0 65.5 0.587188612099644 55 19 58.7 0 3 167 138 192 NP_690826.1 nucleocapsid protein P8 [Pseudomonas phage phi12] diamond 165 79 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27497530 27497530 PRJNA857143_S_NODE_199063_length_232_cov_2.201258_g197970_i0 PRJNA857143 199063 232 2.201258 5.10691856 Pseudomonas phage phi12 161736 Viruses Viruses 122 4.549999999999999e-34   NR NP_690821.1 161736 g197970 i0 67.1 0.982758620689655 76 25 98.3 0 4 231 17 92 NP_690821.1 P15 protein [Pseudomonas phage phi12] diamond 228 122 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
27876273 27876273 PRJNA857143_S_NODE_161465_length_258_cov_1.264865_g160372_i0 PRJNA857143 161465 258 1.264865 3.2633517 Pseudomonas phage phi12 161736 Viruses Viruses 163 4.4e-45   NR NP_690823.1 161736 g160372 i0 89.4 0.988372093023256 85 9 98.8 0 3 257 425 509 NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] diamond 255 163 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
29391999 29391999 PRJNA857143_S_NODE_44969_length_409_cov_3.997024_g43876_i0 PRJNA857143 44969 409 3.997024 16.34782816 Pseudomonas phage phi12 161736 Viruses Viruses 150 3.48e-44   NR NP_690820.1 161736 g43876 i0 72.5 0.667481662591687 91 25 66.7 0 397 125 9 99 NP_690820.1 P14 protein [Pseudomonas phage phi12] diamond 273 150 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
31192128 31192128 PRJNA857143_S_NODE_46615_length_405_cov_1.599398_g45522_i0 PRJNA857143 46615 405 1.599398 6.4775619 Pseudomonas phage phi12 161736 Viruses Viruses 156 2.08e-45   NR NP_690826.1 161736 g45522 i0 56.5 0.97037037037037 131 57 97 0 403 11 1 131 NP_690826.1 nucleocapsid protein P8 [Pseudomonas phage phi12] diamond 393 156 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
32867683 32867683 PRJNA857143_S_NODE_13820_length_604_cov_2.167608_g12782_i0 PRJNA857143 13820 604 2.167608 13.09235232 Pseudomonas phage phi12 161736 Viruses Viruses 158 3.6e-41   NR NP_690823.1 161736 g12782 i0 67 0.571192052980132 115 38 57.1 0 259 603 12 126 NP_690823.1 RNA-dependent RNA polymerase P2 [Pseudomonas phage phi12] diamond 345 158 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12

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