RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1046144" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1046144 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
14200664 14200664 PRJNA1046144_P_NODE_24392_length_334_cov_2.588679_g24097_i0 PRJNA1046144 24392 334 2.588679 8.64618786 Caudoviricetes sp. 2832643 Viruses Viruses 159 1.44e-44   NR QHJ79729.1 2832643 g24097 i0 74.5 0.952095808383233 106 27 95.2 0 7 324 291 396 QHJ79729.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 318 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27003409 27003409 PRJNA1046144_P_NODE_13682_length_433_cov_3.043956_g13387_i0 PRJNA1046144 13682 433 3.043956 13.18032948 Caudoviricetes sp. 2832643 Viruses Viruses 55.8 3.25e-7   NR DAJ98501.1 2832643 g13387 i0 36.3 0.554272517321016 80 39 47.8 2 342 136 2 80 DAJ98501.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 240 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27035208 27035208 PRJNA1046144_P_NODE_41582_length_267_cov_2.060606_g41287_i0 PRJNA1046144 41582 267 2.060606 5.50181802 Shigella virus Moo19 2886042 Viruses Viruses 128 2.34e-36   NR YP_010657728.1 2886042 g41287 i0 76 0.842696629213483 75 18 84.3 0 261 37 20 94 YP_010657728.1 gp6 [Shigella virus Moo19] diamond 225 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
27288089 27288089 PRJNA1046144_P_NODE_70763_length_220_cov_3.536424_g70468_i0 PRJNA1046144 70763 220 3.536424 7.7801328 Salmonella phage SSBI34 2861009 Viruses Viruses 50.8 2.69e-6   NR QYC52643.1 2861009 g70468 i0 56.8 0.6 44 19 60 0 134 3 1 44 QYC52643.1 hypothetical protein [Salmonella phage SSBI34] diamond 132 50.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Salmonella phage SSBI34
29111598 29111598 PRJNA1046144_P_NODE_70288_length_224_cov_3.193548_g69993_i0 PRJNA1046144 70288 224 3.193548 7.15354752 Viruses 10239 Viruses Viruses 97.4 5.22e-24   NR URC22378.1 2943832 g69993 i0 54.8 1.95535714285714 73 33 97.8 0 224 6 4 76 URC22378.1 hypothetical protein CHUUTOTORO_02930 [Serratia phage vB_SmaM-ChuuTotoro] diamond 438 97.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Serratia phage vB_SmaM-ChuuTotoro
29119733 29119733 PRJNA1046144_P_NODE_52329_length_242_cov_6.485549_g52034_i0 PRJNA1046144 52329 242 6.485549 15.69502858 Acinetobacter phage ABPH49 2282400 Viruses Viruses 46.6 1.16e-4   NR AXN57951.1 2282400 g52034 i0 64.5 0.384297520661157 31 11 38.4 0 104 12 1 31 AXN57951.1 hypothetical protein [Acinetobacter phage ABPH49] diamond 93 46.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage ABPH49
29277202 29277202 PRJNA1046144_P_NODE_57169_length_234_cov_1.745455_g56874_i0 PRJNA1046144 57169 234 1.745455 4.0843647 Stenotrophomonas phage vB_SmaS-DLP_6 1651816 Viruses Viruses 79.3 2.11e-16   NR AMQ65998.1 1651816 g56874 i0 52.8 1.8974358974359 72 34 92.3 0 227 12 50 121 AMQ65998.1 small terminase subunit [Stenotrophomonas phage vB_SmaS-DLP_6] diamond 444 79.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage vB_SmaS-DLP_6
29814018 29814018 PRJNA1046144_P_NODE_37051_length_280_cov_3.374408_g36756_i0 PRJNA1046144 37051 280 3.374408 9.4483424 Klebsiella phage 37P2 2930331 Viruses Viruses 128 3.91e-32   NR UOX38092.1 2930331 g36756 i0 70.7 4.92857142857143 92 27 98.6 0 279 4 168 259 UOX38092.1 tail tape measure protein [Klebsiella phage 37P2] diamond 1380 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Klebsiella phage 37P2
30003775 30003775 PRJNA1046144_P_NODE_70011_length_226_cov_0.917197_g69716_i0 PRJNA1046144 70011 226 0.917197 2.07286522 uncultured Caudovirales phage 2100421 Viruses Viruses 102 6.179999999999999e-24   NR CAB4190390.1 2100421 g69716 i0 73 1.9646017699115 74 19 98.2 1 224 3 41 113 CAB4190390.1 hypothetical protein UFOVP1193_57 [uncultured Caudovirales phage] diamond 444 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30003778 30003778 PRJNA1046144_P_NODE_9591_length_510_cov_2.836735_g9298_i0 PRJNA1046144 9591 510 2.836735 14.4673485 Serratia phage Eta 1282995 Viruses Viruses 43.9 0.0238   NR YP_008130345.1 1282995 g9298 i0 47.9 0.282352941176471 48 25 28.2 0 504 361 14 61 YP_008130345.1 hypothetical protein Eta_0052 [Serratia phage Eta] diamond 144 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
31172370 31172370 PRJNA1046144_P_NODE_17035_length_392_cov_2.235294_g16740_i0 PRJNA1046144 17035 392 2.235294 8.76235248 Serratia phage Eta 1282995 Viruses Viruses 238 1.08e-75   NR YP_008130344.1 1282995 g16740 i0 93.1 0.994897959183674 130 9 99.5 0 390 1 53 182 YP_008130344.1 major head protein [Serratia phage Eta] diamond 390 238 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Seretavirus Seretavirus eta
31425634 31425634 PRJNA1046144_P_NODE_22456_length_346_cov_2.122744_g22161_i0 PRJNA1046144 22456 346 2.122744 7.34469424 Acinetobacter phage ABPH49 2282400 Viruses Viruses 89.4 5.91e-21   NR AXN57863.1 2282400 g22161 i0 65.6 0.528901734104046 61 21 52.9 0 35 217 1 61 AXN57863.1 hypothetical protein [Acinetobacter phage ABPH49] diamond 183 89.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage ABPH49
32311796 32311796 PRJNA1046144_P_NODE_6079_length_639_cov_1.745614_g5792_i0 PRJNA1046144 6079 639 1.745614 11.15447346 Shigella virus Moo19 2886042 Viruses Viruses 340 1.16e-106   NR YP_010657804.1 2886042 g5792 i0 77.1 0.985915492957746 210 48 98.6 0 1 630 152 361 YP_010657804.1 tail spike protein [Shigella virus Moo19] diamond 630 340 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
32343394 32343394 PRJNA1046144_P_NODE_70219_length_225_cov_2.397436_g69924_i0 PRJNA1046144 70219 225 2.397436 5.3942310000000004 uncultured Caudovirales phage 2100421 Viruses Viruses 132 7.34e-36   NR CAB4139388.1 2100421 g69924 i0 85.1 0.986666666666667 74 11 98.7 0 3 224 195 268 CAB4139388.1 Family of unknown function (DUF5309) [uncultured Caudovirales phage] diamond 222 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32658770 32658770 PRJNA1046144_P_NODE_25900_length_326_cov_1.642023_g25605_i0 PRJNA1046144 25900 326 1.642023 5.35299498 Escherichia phage vB_EcoS-Ro145c2YLVW 2144178 Viruses Viruses 119 1.22e-28   NR YP_010749480.1 2144178 g25605 i0 90.5 6.95705521472393 63 6 58 0 136 324 1 63 YP_010749480.1 hypothetical protein QCF77_gp51 [Escherichia phage vB_EcoS-Ro145c2YLVW] diamond 2268 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae Kagunavirus Escherichia phage vB_EcoS-Ro145c2YLVW
32658771 32658771 PRJNA1046144_P_NODE_3520_length_825_cov_3.067460_g3281_i0 PRJNA1046144 3520 825 3.06746 25.306545 Hafnia phage TS33 3110108 Viruses Viruses 508 1.08e-172   NR WQY91225.1 3110108 g3281 i0 93.5 1 275 18 100 0 825 1 354 628 WQY91225.1 hypothetical protein [Hafnia phage TS33] diamond 825 508 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Sarkviridae   Hafnia phage TS33

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