RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA753112" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 9 ✖

bioproject 1

  • PRJNA753112 · 9 ✖

analysis 1

  • diamond · 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
27157211 27157211 PRJNA753112_P_NODE_382_length_2235_cov_4.640148_g286_i0 PRJNA753112 382 2235 4.640148 103.7073078 Cystovirus 10878 Viruses Viruses 126 4.47e-26   NR QYF49781.1 2824592 g286 i0 37.9 0.479194630872483 177 103 23.8 2 540 10 9 178 QYF49781.1 MAG: putative RNA-dependent RNA polymerase [Sichuan farmland cysto-like virus] diamond 1071 127 0.992125984251969 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Sichuan farmland cysto-like virus
27400673 27400673 PRJNA753112_P_NODE_19083_length_311_cov_1.638655_g18741_i0 PRJNA753112 19083 311 1.638655 5.09621705 Pseudomonas phage phiK7A1 2759194 Viruses Viruses 46.2 5.69e-4   NR QNR53890.1 2759194 g18741 i0 66.7 0.578778135048232 30 10 28.9 0 92 3 2 31 QNR53890.1 hypothetical protein phiK7A1_102 [Pseudomonas phage phiK7A1] diamond 180 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Torinovirus Torinovirus K7A1
27874137 27874137 PRJNA753112_P_NODE_21925_length_290_cov_2.129032_g21583_i0 PRJNA753112 21925 290 2.129032 6.1741928 Caudoviricetes sp. 2832643 Viruses Viruses 159 5.96e-43   NR XOR28482.1 2832643 g21583 i0 92.6 0.982758620689655 95 7 98.3 0 285 1 722 816 XOR28482.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 285 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29610382 29610382 PRJNA753112_P_NODE_25030_length_272_cov_1.884422_g24688_i0 PRJNA753112 25030 272 1.884422 5.12562784 Flyfo siphovirus Tbat1_6 2907287 Viruses Viruses 79.7 1.39e-16   NR YP_010685015.1 2907287 g24688 i0 67.3 1.76470588235294 52 17 57.4 0 234 79 95 146 YP_010685015.1 hypothetical protein PRB80_gp12 [Flyfo siphovirus Tbat1_6] diamond 480 79.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Flyfo siphovirus Tbat1_6
29705036 29705036 PRJNA753112_P_NODE_8710_length_461_cov_2.095361_g8368_i0 PRJNA753112 8710 461 2.095361 9.65961421 Red mite associated cystovirus 2936548 Viruses Viruses 156 3.15e-41   NR UQT02510.1 2936548 g8368 i0 49.7 0.995661605206074 153 72 98.9 2 3 458 210 358 UQT02510.1 P2 [Red mite associated cystovirus] diamond 459 156 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Cystovirus Red mite associated cystovirus
30811177 30811177 PRJNA753112_P_NODE_4194_length_665_cov_3.905405_g3861_i0 PRJNA753112 4194 665 3.905405 25.97094325 Pseudomonas phage phi12 161736 Viruses Viruses 91.7 1.83e-18   NR NP_690829.1 161736 g3861 i0 36.9 0.793984962406015 176 100 75.3 6 110 610 70 243 NP_690829.1 muramidase [Pseudomonas phage phi12] diamond 528 91.7 1 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae Betacystovirus Betacystovirus phi12
31126766 31126766 PRJNA753112_P_NODE_23015_length_284_cov_1.327014_g22673_i0 PRJNA753112 23015 284 1.327014 3.76871976 Megaderma lyra retrovirus 1200308 Viruses Viruses 105 7.32e-24   NR AFM52260.1 1200308 g22673 i0 72.3 0.686619718309859 65 18 68.7 0 89 283 608 672 AFM52260.1 Pol, partial [Megaderma lyra retrovirus] diamond 195 105 1 Viruses Mammalian gammaretrovirus group Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Bat gammaretrovirus
31485047 31485047 PRJNA753112_P_NODE_3256_length_758_cov_3.210219_g2940_i0 PRJNA753112 3256 758 3.210219 24.33346002 Cystovirus 10878 Viruses Viruses 148 2.32e-38   NR UNI73393.1 2917704 g2940 i0 35.6 1.70976253298153 216 134 85.5 3 13 660 191 401 UNI73393.1 RNA dependent RNA polymerase [Pseudomonas phage ER16] diamond 1296 149 0.993288590604027 Viruses   Orthornavirae Duplornaviricota Vidaverviricetes Mindivirales Cystoviridae   Pseudomonas phage ER16
31664621 31664621 PRJNA753112_P_NODE_22917_length_284_cov_2.218009_g22575_i0 PRJNA753112 22917 284 2.218009 6.29914556 Pseudomonas phage D3 2932880 Viruses Viruses 112 1.86e-28   NR NP_061578.1 2932880 g22575 i0 87.5 5.36619718309859 64 8 67.6 0 282 91 150 213 NP_061578.1 NinG/ Rap DNA junction specific endonuclease [Pseudomonas phage D3] diamond 1524 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Detrevirus Detrevirus D3

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