RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB41113" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 21 ✖

bioproject 1

  • PRJEB41113 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26589975 26589975 PRJEB41113_S_NODE_9721_length_161_cov_1.250000_g9712_i0 PRJEB41113 9721 161 1.25 2.0125 Klebsiella phage vB_KppS-Pokey 2762811 Viruses Viruses 105 9.72e-26   NR CAD5235807.1 2762811 g9712 i0 83 0.987577639751553 53 9 98.8 0 160 2 237 289 CAD5235807.1 BcepGomrgp43 [Klebsiella phage vB_KppS-Pokey] diamond 159 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Klebsiella phage vB_KppS-Pokey
27001590 27001590 PRJEB41113_S_NODE_5682_length_183_cov_1.821918_g5673_i0 PRJEB41113 5682 183 1.821918 3.33410994 Caudoviricetes sp. 2832643 Viruses Viruses 93.6 4.73e-22   NR DAP77734.1 2832643 g5673 i0 74.1 0.885245901639344 54 14 88.5 0 163 2 1 54 DAP77734.1 MAG TPA: peptidase [Caudoviricetes sp.] diamond 162 93.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27728834 27728834 PRJEB41113_S_NODE_5484_length_184_cov_2.775510_g5475_i0 PRJEB41113 5484 184 2.77551 5.1069384 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.00676   NR DAU24060.1 2832643 g5475 i0 42.6 0.880434782608696 54 31 88 0 23 184 322 375 DAU24060.1 MAG TPA: baseplate wedge protein [Caudoviricetes sp.] diamond 162 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28044183 28044183 PRJEB41113_S_NODE_1905_length_229_cov_1.989583_g1896_i0 PRJEB41113 1905 229 1.989583 4.55614507 Staphylococcus phage vB-SscS-F1 2812861 Viruses Viruses 67 1.28e-12   NR QSJ04085.1 2812861 g1896 i0 48.5 0.890829694323144 68 34 87.8 1 16 216 1 68 QSJ04085.1 hypothetical protein vBSscSF1_14 [Staphylococcus phage vB-SscS-F1] diamond 204 67 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Sextaecvirus Staphylococcus phage vB-SscS-F1
28132397 28132397 PRJEB41113_S_NODE_5165_length_186_cov_5.348993_g5156_i0 PRJEB41113 5165 186 5.348993 9.94912698 Gammaretrovirus 153135 Viruses Viruses 125 1.7699999999999996e-31   NR ABU54795.1 11786 g5156 i0 100 13.741935483871 61 0 98.4 0 184 2 678 738 ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus] diamond 2556 125 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
28454837 28454837 PRJEB41113_S_NODE_446_length_312_cov_5.200000_g437_i0 PRJEB41113 446 312 5.2 16.224 Caudoviricetes sp. 2832643 Viruses Viruses 49.3 5.82e-5   NR DAV36809.1 2832643 g437 i0 48.8 0.394230769230769 41 21 39.4 0 128 6 5 45 DAV36809.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 123 49.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28770331 28770331 PRJEB41113_S_NODE_10887_length_157_cov_5.883333_g10878_i0 PRJEB41113 10887 157 5.883333 9.23683281 Synechococcus phage S-B 2484637 Viruses Viruses 41.6 0.029   NR AYR01737.1 2484637 g10878 i0 58.1 0.592356687898089 31 13 59.2 0 63 155 71 101 AYR01737.1 baseplate wedge subunit [Synechococcus phage S-B05] diamond 93 41.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae   Synechococcus phage S-B05
28921464 28921464 PRJEB41113_S_NODE_2788_length_211_cov_1.821839_g2779_i0 PRJEB41113 2788 211 1.821839 3.84408029 Viruses 10239 Viruses Viruses 59.7 2.54e-8   NR QFP93530.1 2651067 g2779 i0 55.8 1.47867298578199 52 20 73.9 1 207 52 375 423 QFP93530.1 hypothetical protein [Edwardsiella phage vB_EtaM_ET-ABTNL-9] diamond 312 59.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Edwardsiella phage vB_EtaM_ET-ABTNL-9
28928253 28928253 PRJEB41113_S_NODE_1768_length_232_cov_13.528205_g1759_i0 PRJEB41113 1768 232 13.528205 31.3854356 Acinetobacter phage vB_AbaM_B9 2163899 Viruses Viruses 101 4.2999999999999996e-24   NR AWD93217.1 2163899 g1759 i0 57.7 1.00862068965517 78 28 94.4 1 225 7 65 142 AWD93217.1 hypothetical protein AB9_137 [Acinetobacter phage vB_AbaM_B9] diamond 234 101 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage vB_AbaM_B9
29117909 29117909 PRJEB41113_S_NODE_369_length_326_cov_1.799308_g360_i0 PRJEB41113 369 326 1.799308 5.86574408 Caudoviricetes sp. 2832643 Viruses Viruses 160 2.85e-45   NR DAV36681.1 2832643 g360 i0 86 0.791411042944785 86 12 79.1 0 325 68 322 407 DAV36681.1 MAG TPA: endonuclease [Caudoviricetes sp.] diamond 258 160 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30191314 30191314 PRJEB41113_S_NODE_2312_length_220_cov_1.420765_g2303_i0 PRJEB41113 2312 220 1.420765 3.125683 Caudoviricetes sp. 2832643 Viruses Viruses 132 7.739999999999998e-35   NR DAV36681.1 2832643 g2303 i0 86.3 0.995454545454545 73 10 99.5 0 1 219 311 383 DAV36681.1 MAG TPA: endonuclease [Caudoviricetes sp.] diamond 219 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30696844 30696844 PRJEB41113_S_NODE_7554_length_171_cov_2.111940_g7545_i0 PRJEB41113 7554 171 2.11194 3.6114174 Caudoviricetes sp. 2832643 Viruses Viruses 62 2.21e-9   NR DAV36788.1 2832643 g7545 i0 60 0.964912280701754 55 22 96.5 0 170 6 387 441 DAV36788.1 MAG TPA: POLBc polymerase type-B family catalytic domain [Caudoviricetes sp.] diamond 165 62 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30823328 30823328 PRJEB41113_S_NODE_12434_length_154_cov_1.213675_g12425_i0 PRJEB41113 12434 154 1.213675 1.8690595 Caudoviricetes sp. 2832643 Viruses Viruses 63.2 2.27e-10   NR DAV36756.1 2832643 g12425 i0 72.5 0.779220779220779 40 11 77.9 0 154 35 166 205 DAV36756.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 120 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31480816 31480816 PRJEB41113_S_NODE_7936_length_169_cov_1.750000_g7927_i0 PRJEB41113 7936 169 1.75 2.9575 root 1 Root_unresolved Root_unresolved 57 2.37e-8   NR UVY39131.1 38018 g7927 i0 96.4 2.48520710059172 28 1 49.7 0 86 3 1 28 UVY39131.1 MAG: Pyruvate ferredoxin/flavodoxin oxidoreductase, partial [Bacteriophage sp.] diamond 420 57.4 0.993031358885017 Viruses               Bacteriophage sp.
31834908 31834908 PRJEB41113_S_NODE_8037_length_168_cov_3.664122_g8028_i0 PRJEB41113 8037 168 3.664122 6.15572496 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 2.24e-9   NR DAL31100.1 2832643 g8028 i0 73.8 0.75 42 11 75 0 41 166 1 42 DAL31100.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] diamond 126 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32404688 32404688 PRJEB41113_S_NODE_12279_length_154_cov_2.923077_g12270_i0 PRJEB41113 12279 154 2.923077 4.50153858 Caudoviricetes sp. 2832643 Viruses Viruses 52 1.94e-6   NR DAV36744.1 2832643 g12270 i0 44 0.974025974025974 50 28 97.4 0 152 3 18 67 DAV36744.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 150 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32429661 32429661 PRJEB41113_S_NODE_2899_length_209_cov_2.761628_g2890_i0 PRJEB41113 2899 209 2.761628 5.77180252 Viruses 10239 Viruses Viruses 77 2e-14   NR DAF55207.1 2827891 g2890 i0 72.9 2.06698564593301 48 13 68.9 0 7 150 1064 1111 DAF55207.1 MAG TPA: hypothetical protein [Siphoviridae sp. ctZHD14] diamond 432 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctZHD14
32625683 32625683 PRJEB41113_S_NODE_11340_length_156_cov_2.268908_g11331_i0 PRJEB41113 11340 156 2.268908 3.53949648 Caudoviricetes sp. 2832643 Viruses Viruses 67.4 2.34e-11   NR DAU35738.1 2832643 g11331 i0 71.1 0.865384615384615 45 13 86.5 0 7 141 161 205 DAU35738.1 MAG TPA: minor tail protein [Caudoviricetes sp.] diamond 135 67.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32650347 32650347 PRJEB41113_S_NODE_6460_length_178_cov_1.276596_g6451_i0 PRJEB41113 6460 178 1.276596 2.27234088 root 1 Root_unresolved Root_unresolved 43.5 0.00844   NR YP_009595841.1 1837876 g6451 i0 41.7 2.59550561797753 48 28 80.9 0 10 153 88 135 YP_009595841.1 RNA (guanine-N1-)-methyltransferase [Acinetobacter phage vB_AbaM_ME3] diamond 462 43.9 0.990888382687927 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Metrivirus Metrivirus ME3
32713575 32713575 PRJEB41113_S_NODE_3680_length_198_cov_5.608696_g3671_i0 PRJEB41113 3680 198 5.608696 11.10521808 Sextaecvirus 1922243 Viruses Viruses 68.6 2.12e-12   NR AWY02927.1 2234082 g3671 i0 53 3 66 31 100 0 1 198 80 145 AWY02927.1 terminase small subunit [Staphylococcus phage VB-SauS-SA2] diamond 594 68.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Sextaecvirus Staphylococcus phage VB-SauS-SA2
32783054 32783054 PRJEB41113_S_NODE_5980_length_181_cov_2.659722_g5971_i0 PRJEB41113 5980 181 2.659722 4.81409682 Caudoviricetes sp. 2832643 Viruses Viruses 64.7 1.36e-11   NR DAV82012.1 2832643 g5971 i0 61.7 0.779005524861878 47 18 77.9 0 179 39 60 106 DAV82012.1 MAG TPA: anaerobic ribonucleoside triphosphate reductase [Caudoviricetes sp.] diamond 141 64.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;