RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1227535" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 20 ✖

bioproject 1

  • PRJNA1227535 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
13088869 13088869 PRJNA1227535_P_NODE_15651_length_273_cov_1.370000_g15528_i0 PRJNA1227535 15651 273 1.37 3.7401 Caudoviricetes sp. 2832643 Viruses Viruses 94.7 8.66e-21   NR DAP49561.1 2832643 g15528 i0 54 0.956043956043956 87 40 95.6 0 263 3 34 120 DAP49561.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 261 94.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26629589 26629589 PRJNA1227535_P_NODE_4261_length_352_cov_1.326165_g4138_i0 PRJNA1227535 4261 352 1.326165 4.6681008 Pimephales minnow adintovirus 2609864 Viruses Viruses 47.8 0.00183   NR DAC81404.1 2609864 g4138 i0 34.1 1.39772727272727 82 53 69 1 294 52 116 197 DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] diamond 492 47.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
26788054 26788054 PRJNA1227535_P_NODE_28421_length_245_cov_0.906977_g28297_i0 PRJNA1227535 28421 245 0.906977 2.22209365 Caudoviricetes sp. 2832643 Viruses Viruses 89.4 1.51e-18   NR DAJ88735.1 2832643 g28297 i0 51.9 0.942857142857143 77 36 94.3 1 243 13 91 166 DAJ88735.1 MAG TPA: DNA polymerase III subunit alpha [Caudoviricetes sp.] diamond 231 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27641655 27641655 PRJNA1227535_P_NODE_31024_length_242_cov_0.923077_g30900_i0 PRJNA1227535 31024 242 0.923077 2.23384634 Caudoviricetes sp. 2832643 Viruses Viruses 75.9 1.67e-14   NR XOR18194.1 2832643 g30900 i0 48.1 0.979338842975207 79 39 95.5 1 242 12 64 142 XOR18194.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 237 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27849439 27849439 PRJNA1227535_P_NODE_25724_length_248_cov_0.891429_g25600_i0 PRJNA1227535 25724 248 0.891429 2.21074392 Viruses 10239 Viruses Viruses 44.3 0.00159   NR AFH22266.1 1168823 g25600 i0 51.4 0.991935483870968 37 18 44.8 0 136 246 1 37 AFH22266.1 hypothetical protein OSG_eHP20_00155 [environmental Halophage eHP-20] diamond 246 44.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Kirjokansivirales Haloferuviridae   environmental Halophage eHP-20
28020464 28020464 PRJNA1227535_P_NODE_15605_length_273_cov_1.560000_g15482_i0 PRJNA1227535 15605 273 1.56 4.2588 Erwinia phage vB_EamP_Frozen 1852641 Viruses Viruses 46.2 3.3e-4   NR YP_009286170.1 1852641 g15482 i0 33.3 0.692307692307692 63 39 69.2 1 70 258 1 60 YP_009286170.1 hypothetical protein FROZEN_41 [Erwinia phage vB_EamP_Frozen] diamond 189 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Johnsonvirus Johnsonvirus frozen
28020465 28020465 PRJNA1227535_P_NODE_21945_length_253_cov_0.866667_g21821_i0 PRJNA1227535 21945 253 0.866667 2.19266751 Caudoviricetes sp. 2832643 Viruses Viruses 49.7 1.43e-4   NR XOS72756.1 2832643 g21821 i0 71.4 0.41501976284585 35 10 41.5 0 107 3 11 45 XOS72756.1 MAG: hypothetical protein MSP0458_47 [Caudoviricetes sp.] diamond 105 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28449692 28449692 PRJNA1227535_P_NODE_19826_length_259_cov_1.677419_g19702_i0 PRJNA1227535 19826 259 1.677419 4.34451521 root 1 Root_unresolved Root_unresolved 43.5 0.0117   NR ASR85967.1 2015848 g19702 i0 42.9 3.48648648648649 35 20 40.5 0 247 143 115 149 ASR85967.1 hypothetical protein SEA_PEANAM_85 [Mycobacterium phage Peanam] diamond 903 43.9 0.990888382687927 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Anayavirus Mycobacterium phage Peanam
28588829 28588829 PRJNA1227535_P_NODE_29647_length_243_cov_1.658824_g29523_i0 PRJNA1227535 29647 243 1.658824 4.03094232 Xanthomonas phage XacN1 2042251 Viruses Viruses 99.4 1.35e-24   NR BBA65224.1 2042251 g29523 i0 64.9 1.88888888888889 77 27 95.1 0 231 1 5 81 BBA65224.1 predicted ORF [Xanthomonas phage XacN1] diamond 459 99.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage XacN1
29428046 29428046 PRJNA1227535_P_NODE_14329_length_277_cov_2.093137_g14206_i0 PRJNA1227535 14329 277 2.093137 5.79798949 Bixzunavirus 680114 Viruses Viruses 54.3 4.49e-6   NR NP_818298.1 205877 g14206 i0 53.8 1.68953068592058 52 24 56.3 0 116 271 13 64 NP_818298.1 gp248 [Mycobacterium phage Bxz1] diamond 468 54.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Bixzunavirus Bixzunavirus Bxz1
29661731 29661731 PRJNA1227535_P_NODE_30570_length_242_cov_1.461538_g30446_i0 PRJNA1227535 30570 242 1.461538 3.53692196 Caudoviricetes sp. 2832643 Viruses Viruses 92 2.25e-21   NR XOR46446.1 2832643 g30446 i0 61.8 1.88429752066116 76 29 94.2 0 240 13 55 130 XOR46446.1 MAG: putative S-adenosylmethionine synthetase [Caudoviricetes sp.] diamond 456 92 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30357627 30357627 PRJNA1227535_P_NODE_3872_length_365_cov_2.602740_g3749_i0 PRJNA1227535 3872 365 2.60274 9.500001 Acinetobacter phage vB_AbaM_ME3 1837876 Viruses Viruses 64.7 2.94e-9   NR YP_009595852.1 1837876 g3749 i0 32.4 0.887671232876712 108 62 88.8 2 327 4 16 112 YP_009595852.1 hypothetical protein FDH01_gp020 [Acinetobacter phage vB_AbaM_ME3] diamond 324 64.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Metrivirus Metrivirus ME3
30420660 30420660 PRJNA1227535_P_NODE_21013_length_255_cov_2.225275_g20889_i0 PRJNA1227535 21013 255 2.225275 5.67445125 Siphoviridae sp. ctHip2 2827830 Viruses Viruses 80.9 1.65e-15   NR DAF42606.1 2827830 g20889 i0 50 0.847058823529412 72 35 83.5 1 43 255 197 268 DAF42606.1 MAG TPA: DNA TRANSLOCASE FTSK [Siphoviridae sp. ctHip2] diamond 216 80.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctHip2
30515078 30515078 PRJNA1227535_P_NODE_7533_length_312_cov_2.728033_g7410_i0 PRJNA1227535 7533 312 2.728033 8.51146296 Caudoviricetes sp. 2832643 Viruses Viruses 81.3 2.49e-17   NR XOR53497.1 2832643 g7410 i0 70 0.480769230769231 50 15 48.1 0 311 162 38 87 XOR53497.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 150 81.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31209697 31209697 PRJNA1227535_P_NODE_23035_length_251_cov_3.196629_g22911_i0 PRJNA1227535 23035 251 3.196629 8.02353879 uncultured Caudovirales phage 2100421 Viruses Viruses 103 1.5799999999999998e-23   NR CAB4142848.1 2100421 g22911 i0 64.6 1.94820717131474 82 29 98 0 2 247 494 575 CAB4142848.1 hypothetical protein UFOVP451_55 [uncultured Caudovirales phage] diamond 489 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31495010 31495010 PRJNA1227535_P_NODE_9376_length_295_cov_4.301802_g9253_i0 PRJNA1227535 9376 295 4.301802 12.6903159 Caudoviricetes sp. 2832643 Viruses Viruses 45.1 0.0109   NR DAS48803.1 2832643 g9253 i0 52.1 1.74915254237288 48 22 48.8 1 3 146 1998 2044 DAS48803.1 MAG TPA: Muramidase (flagellum-specific) [Caudoviricetes sp.] diamond 516 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31874361 31874361 PRJNA1227535_P_NODE_25577_length_248_cov_1.468571_g25453_i0 PRJNA1227535 25577 248 1.468571 3.64205608 Streptomyces phage KimJongPhill 2848886 Viruses Viruses 75.1 1.56e-13   NR YP_010655614.1 2848886 g25453 i0 53 2.41935483870968 66 31 79.8 0 8 205 458 523 YP_010655614.1 terminase large subunit [Streptomyces phage KimJongPhill] diamond 600 75.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Zukovirus Zukovirus phill
32000981 32000981 PRJNA1227535_P_NODE_13058_length_282_cov_1.205742_g12935_i0 PRJNA1227535 13058 282 1.205742 3.40019244 Caudoviricetes sp. 2832643 Viruses Viruses 73.6 8.21e-13   NR XOR60091.1 2832643 g12935 i0 37.9 0.925531914893617 87 54 92.6 0 2 262 185 271 XOR60091.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 261 73.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32190944 32190944 PRJNA1227535_P_NODE_24078_length_250_cov_1.322034_g23954_i0 PRJNA1227535 24078 250 1.322034 3.305085 Sphingobium phage Lacusarx 1980139 Viruses Viruses 42.7 0.0421   NR YP_009600753.1 1980139 g23954 i0 76 0.3 25 6 30 0 88 162 275 299 YP_009600753.1 tail protein [Sphingobium phage Lacusarx] diamond 75 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Lacusarxvirus Lacusarxvirus lacusarx
32412445 32412445 PRJNA1227535_P_NODE_25419_length_248_cov_1.782857_g25295_i0 PRJNA1227535 25419 248 1.782857 4.42148536 Corynebacterium phage P12 3427939 Viruses Viruses 66.6 1.53e-10   NR YP_001468976.1 384848 g25295 i0 67.4 0.556451612903226 46 15 55.6 0 82 219 516 561 YP_001468976.1 ribonucleotide reductase large subunit [Corynebacterium phage P1201] diamond 138 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Zierdtviridae Chunghsingvirus Chunghsingvirus P1201

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