RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 23 ✖

bioproject 1

  • PRJEB83711 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
2694114 2694114 PRJEB83711_P_NODE_42403_length_283_cov_1.485714_g42137_i0 PRJEB83711 42403 283 1.485714 4.20457062 Caudoviricetes sp. 2832643 Viruses Viruses 144 1.01e-39   NR XOS47079.1 2832643 g42137 i0 72.3 1.99293286219081 94 26 99.6 0 283 2 199 292 XOS47079.1 MAG: NrdB aerobic NDP reductase, small subunit [Caudoviricetes sp.] diamond 564 144 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
21821161 21821161 PRJEB83711_P_NODE_58998_length_252_cov_1.743017_g58732_i0 PRJEB83711 58998 252 1.743017 4.39240284 Caudoviricetes sp. 2832643 Viruses Viruses 69.3 9.91e-12   NR DAH77175.1 2832643 g58732 i0 48.6 0.857142857142857 72 36 85.7 1 37 252 8 78 DAH77175.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 216 69.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26590864 26590864 PRJEB83711_P_NODE_43741_length_280_cov_1.454106_g43475_i0 PRJEB83711 43741 280 1.454106 4.0714968 uncultured Caudovirales phage 2100421 Viruses Viruses 68.2 1.43e-12   NR CAB4139755.1 2100421 g43475 i0 38.9 1.62857142857143 72 44 77.1 0 6 221 24 95 CAB4139755.1 hypothetical protein UFOVP353_19 [uncultured Caudovirales phage] diamond 456 68.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27255526 27255526 PRJEB83711_P_NODE_29463_length_330_cov_1.128405_g29197_i0 PRJEB83711 29463 330 1.128405 3.7237365 Caudoviricetes sp. 2832643 Viruses Viruses 83.6 4.16e-16   NR DAJ88734.1 2832643 g29197 i0 39.6 0.827272727272727 91 55 82.7 0 27 299 280 370 DAJ88734.1 MAG TPA: DNA-directed DNA polymerase [Caudoviricetes sp.] diamond 273 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27469530 27469530 PRJEB83711_P_NODE_45923_length_275_cov_1.544554_g45657_i0 PRJEB83711 45923 275 1.544554 4.2475235 Viruses 10239 Viruses Viruses 56.2 3.38e-7   NR DAG77614.1 38018 g45657 i0 86.7 0.654545454545455 30 4 32.7 0 90 1 126 155 DAG77614.1 MAG TPA: activated protein kinase C receptor [Bacteriophage sp.] diamond 180 56.6 0.992932862190813 Viruses               Bacteriophage sp.
27666381 27666381 PRJEB83711_P_NODE_58464_length_253_cov_0.866667_g58198_i0 PRJEB83711 58464 253 0.866667 2.19266751 Caudoviricetes sp. 2832643 Viruses Viruses 57.8 2.16e-7   NR DAQ96360.1 2832643 g58198 i0 45 0.948616600790514 80 40 90.1 1 234 7 331 410 DAQ96360.1 MAG TPA: minor tail protein [Caudoviricetes sp.] diamond 240 57.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28424109 28424109 PRJEB83711_P_NODE_74526_length_244_cov_0.912281_g74260_i0 PRJEB83711 74526 244 0.912281 2.22596564 Caudoviricetes sp. 2832643 Viruses Viruses 56.6 2.4e-7   NR DAQ42194.1 2832643 g74260 i0 39.2 0.971311475409836 79 48 97.1 0 7 243 96 174 DAQ42194.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 237 56.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28550470 28550470 PRJEB83711_P_NODE_71407_length_246_cov_0.901734_g71141_i0 PRJEB83711 71407 246 0.901734 2.21826564 Caudoviricetes sp. 2832643 Viruses Viruses 47.8 6.51e-4   NR XOR07357.1 2832643 g71141 i0 57.5 0.48780487804878 40 17 48.8 0 246 127 346 385 XOR07357.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 120 47.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28763829 28763829 PRJEB83711_P_NODE_50507_length_266_cov_1.357513_g50241_i0 PRJEB83711 50507 266 1.357513 3.6109845800000002 Ilarvirus 12316 Viruses Viruses 84.3 1.36e-17   NR NP_620774.1 12317 g50241 i0 63.2 3.24812030075188 57 21 64.3 0 1 171 177 233 NP_620774.1 coat protein [Tobacco streak virus] diamond 864 84.3 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus TSV
28865967 28865967 PRJEB83711_P_NODE_57228_length_253_cov_1.733333_g56962_i0 PRJEB83711 57228 253 1.733333 4.38533249 Pseudomonas phage POR1 1718594 Viruses Viruses 64.7 2.02e-10   NR ALH46286.1 1718594 g56962 i0 40 1.00790513833992 85 49 98.4 1 3 251 4 88 ALH46286.1 hypothetical protein POR1_81 [Pseudomonas phage POR1] diamond 255 64.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Porunavirus Porunavirus POR1
28961003 28961003 PRJEB83711_P_NODE_61348_length_251_cov_0.876404_g61082_i0 PRJEB83711 61348 251 0.876404 2.19977404 Caudoviricetes sp. 2832643 Viruses Viruses 144 1.0899999999999998e-37   NR XOR83182.1 2832643 g61082 i0 79.5 1.9840637450199201 83 17 99.2 0 250 2 462 544 XOR83182.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] diamond 498 144 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29654950 29654950 PRJEB83711_P_NODE_68670_length_247_cov_0.896552_g68404_i0 PRJEB83711 68670 247 0.896552 2.21448344 Pseudomonas phage POR1 1718594 Viruses Viruses 45.1 0.00179   NR ALH46215.1 1718594 g68404 i0 61.3 0.376518218623482 31 12 37.7 0 247 155 91 121 ALH46215.1 hypothetical protein POR1_10 [Pseudomonas phage POR1] diamond 93 45.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Porunavirus Porunavirus POR1
29971135 29971135 PRJEB83711_P_NODE_35711_length_302_cov_3.030568_g35445_i0 PRJEB83711 35711 302 3.030568 9.15231536 Morogoro maize-associated virus 2497337 Viruses Viruses 204 2.03e-64   NR YP_010087199.1 2497337 g35445 i0 95 0.993377483443709 100 5 99.3 0 2 301 99 198 YP_010087199.1 matrix protein [Morogoro maize-associated virus] diamond 300 204 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Alphanucleorhabdovirus Alphanucleorhabdovirus morogoromaydis
30255825 30255825 PRJEB83711_P_NODE_68732_length_247_cov_0.896552_g68466_i0 PRJEB83711 68732 247 0.896552 2.21448344 Bacillus phage vB_BspM_AgentSmith 2836110 Viruses Viruses 79 7.09e-15   NR QXN70563.1 2836110 g68466 i0 43.8 0.88663967611336 73 41 88.7 0 13 231 81 153 QXN70563.1 putative virion structural protein [Bacillus phage vB_BspM_AgentSmith] diamond 219 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BspM_AgentSmith
30950806 30950806 PRJEB83711_P_NODE_63014_length_250_cov_0.881356_g62748_i0 PRJEB83711 63014 250 0.881356 2.20339 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 134 1.09e-38   NR QDP50231.1 2591644 g62748 i0 81.2 0.828 69 13 82.8 0 42 248 6 74 QDP50231.1 MAG: hypothetical protein Tp178MES00d2C33159851_21 [Prokaryotic dsDNA virus sp.] diamond 207 134 1 Viruses               Prokaryotic dsDNA virus sp.
31171529 31171529 PRJEB83711_P_NODE_76195_length_243_cov_0.929412_g75929_i0 PRJEB83711 76195 243 0.929412 2.25847116 Phage NCTB 1857647 Viruses Viruses 68.6 2.66e-11   NR SBV38259.1 1857647 g75929 i0 45.5 0.950617283950617 77 42 95.1 0 6 236 183 259 SBV38259.1 hypothetical protein BN7874_090 [Phage NCTB] diamond 231 68.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Phage NCTB
31322448 31322448 PRJEB83711_P_NODE_57335_length_253_cov_1.516667_g57069_i0 PRJEB83711 57335 253 1.516667 3.83716751 Pakpunavirus 1921407 Viruses Viruses 107 9.14e-26   NR AXY86885.1 2301646 g57069 i0 59 1.96837944664032 83 30 98.4 1 4 252 221 299 AXY86885.1 thymidylate synthase [Pseudomonas phage PaYy-2] diamond 498 108 0.990740740740741 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Vandenendeviridae Pakpunavirus Pseudomonas phage PaYy-2
31329854 31329854 PRJEB83711_P_NODE_58696_length_253_cov_0.866667_g58430_i0 PRJEB83711 58696 253 0.866667 2.19266751 Xanthomonas phage DES1 2894399 Viruses Viruses 147 1.91e-40   NR UFK09591.1 2894399 g58430 i0 77.1 0.984189723320158 83 19 98.4 0 5 253 45 127 UFK09591.1 large terminase protein [Xanthomonas phage DES1] diamond 249 147 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Xanthomonas phage DES1
31481007 31481007 PRJEB83711_P_NODE_81696_length_229_cov_2.006410_g81430_i0 PRJEB83711 81696 229 2.00641 4.5946789 Ilarvirus 12316 Viruses Viruses 99 1.47e-23   NR YP_009551517.1 2116599 g81430 i0 61 2.0174672489083 77 29 99.6 1 1 228 86 162 YP_009551517.1 coat protein [Cape gooseberry ilarvirus 1] diamond 462 99 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Cape gooseberry ilarvirus 1
31512505 31512505 PRJEB83711_P_NODE_63536_length_250_cov_0.881356_g63270_i0 PRJEB83711 63536 250 0.881356 2.20339 Rimavirus 2560214 Viruses Viruses 124 1.6599999999999998e-31   NR ASU04008.1 2024285 g63270 i0 74.4 5.856 82 21 98.4 0 3 248 320 401 ASU04008.1 portal protein [Streptomyces phage Spectropatronm] diamond 1464 124 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Rimavirus Rimavirus rima
31994179 31994179 PRJEB83711_P_NODE_70838_length_246_cov_0.901734_g70572_i0 PRJEB83711 70838 246 0.901734 2.21826564 Zebrafish jaw poxvirus RQ14 Viruses Viruses 50.4 7.55e-5   NR DBA51229.1 RQ14 g70572 i0 38.1 0.768292682926829 63 37 74.4 1 187 5 1787 1849 DBA51229.1 MAG TPA_asm: EnvelopeB22R [Poxvirus rattus41634] diamond 189 50.4 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
32342464 32342464 PRJEB83711_P_NODE_57739_length_253_cov_0.866667_g57473_i0 PRJEB83711 57739 253 0.866667 2.19266751 Caudoviricetes sp. 2832643 Viruses Viruses 147 4.87e-39   NR XOR83179.1 2832643 g57473 i0 78 0.972332015810277 82 18 97.2 0 248 3 325 406 XOR83179.1 MAG: hypothetical protein MSP1863_37 [Caudoviricetes sp.] diamond 246 147 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32405586 32405586 PRJEB83711_P_NODE_16099_length_442_cov_1.249322_g15833_i0 PRJEB83711 16099 442 1.249322 5.52200324 Tobacco streak virus 12317 Viruses Viruses 184 7.459999999999998e-55   NR NP_620773.1 12317 g15833 i0 78.9 1.54751131221719 114 24 77.4 0 345 4 1 114 NP_620773.1 movement protein [Tobacco streak virus] diamond 684 184 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus TSV

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