RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1111077" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1111077 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
215166 215166 PRJNA1111077_P_NODE_9861_length_375_cov_1.698675_g9640_i0 PRJNA1111077 9861 375 1.698675 6.37003125 Pseudomonas phage PMBT14 2059855 Viruses Viruses 182 4.419999999999999e-54   NR YP_009836225.1 2059855 g9640 i0 65.9 1.08 135 34 99.2 2 3 374 43 176 YP_009836225.1 exonuclease [Pseudomonas phage PMBT14] diamond 405 182 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Knuthellervirus Knuthellervirus PMBT14
21891672 21891672 PRJNA1111077_P_NODE_30698_length_250_cov_1.378531_g30477_i0 PRJNA1111077 30698 250 1.378531 3.4463275 Pseudomonas phage PMBT14 2059855 Viruses Viruses 137 1.8299999999999997e-35   NR YP_009836232.1 2059855 g30477 i0 75.9 1.884 79 19 94.8 0 12 248 411 489 YP_009836232.1 DNA recombinase [Pseudomonas phage PMBT14] diamond 471 137 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Knuthellervirus Knuthellervirus PMBT14
26941085 26941085 PRJNA1111077_P_NODE_24722_length_271_cov_1.393939_g24501_i0 PRJNA1111077 24722 271 1.393939 3.77757469 Edwardsiella phage vB_EtaM_ET-ABTNL-9 2651067 Viruses Viruses 97.8 3.71e-22   NR QFP93498.1 2651067 g24501 i0 56.5 0.940959409594096 85 37 94.1 0 15 269 212 296 QFP93498.1 coil containing protein [Edwardsiella phage vB_EtaM_ET-ABTNL-9] diamond 255 97.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Edwardsiella phage vB_EtaM_ET-ABTNL-9
27289015 27289015 PRJNA1111077_P_NODE_37603_length_232_cov_4.477987_g37382_i0 PRJNA1111077 37603 232 4.477987 10.38892984 Achromobacter phage JWF 1589748 Viruses Viruses 98.6 1.2699999999999999e-24   NR YP_009224048.1 1589748 g37382 i0 80.7 0.737068965517241 57 11 73.7 0 230 60 58 114 YP_009224048.1 hypothetical protein AXJ13_gp042 [Achromobacter phage JWF] diamond 171 98.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
27352483 27352483 PRJNA1111077_P_NODE_30143_length_251_cov_0.865169_g29922_i0 PRJNA1111077 30143 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 49.7 7.45e-5   NR DAH47923.1 2832643 g29922 i0 66.7 0.394422310756972 33 11 39.4 0 249 151 144 176 DAH47923.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 99 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27478559 27478559 PRJNA1111077_P_NODE_32403_length_248_cov_0.880000_g32182_i0 PRJNA1111077 32403 248 0.88 2.1824 Pseudomonas phage PMBT14 2059855 Viruses Viruses 85.5 1.27e-17   NR YP_009836227.1 2059855 g32182 i0 56 0.907258064516129 75 29 85.9 1 219 7 155 229 YP_009836227.1 dCMP deaminase [Pseudomonas phage PMBT14] diamond 225 85.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Knuthellervirus Knuthellervirus PMBT14
27668154 27668154 PRJNA1111077_P_NODE_33644_length_246_cov_0.890173_g33423_i0 PRJNA1111077 33644 246 0.890173 2.18982558 Pseudomonas phage PMBT14 2059855 Viruses Viruses 93.6 4.36e-20   NR YP_009836183.1 2059855 g33423 i0 71.8 0.951219512195122 78 22 95.1 0 1 234 327 404 YP_009836183.1 portal protein [Pseudomonas phage PMBT14] diamond 234 93.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Knuthellervirus Knuthellervirus PMBT14
27825985 27825985 PRJNA1111077_P_NODE_28784_length_256_cov_1.349727_g28563_i0 PRJNA1111077 28784 256 1.349727 3.45530112 Pseudomonas phage PMBT14 2059855 Viruses Viruses 90.5 2.64e-21   NR YP_009836252.1 2059855 g28563 i0 57.3 0.9609375 82 34 94.9 1 254 12 29 110 YP_009836252.1 hypothetical protein HWB42_gp71 [Pseudomonas phage PMBT14] diamond 246 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Knuthellervirus Knuthellervirus PMBT14
28204576 28204576 PRJNA1111077_P_NODE_33606_length_246_cov_0.890173_g33385_i0 PRJNA1111077 33606 246 0.890173 2.18982558 Achromobacter phage JWF 1589748 Viruses Viruses 153 5.14e-46   NR YP_009224039.1 1589748 g33385 i0 90.1 0.98780487804878 81 8 98.8 0 2 244 4 84 YP_009224039.1 hypothetical protein AXJ13_gp033 [Achromobacter phage JWF] diamond 243 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
28362517 28362517 PRJNA1111077_P_NODE_9326_length_384_cov_2.967846_g9105_i0 PRJNA1111077 9326 384 2.967846 11.39652864 Achromobacter phage JWF 1589748 Viruses Viruses 112 3.71e-28   NR YP_009224047.1 1589748 g9105 i0 70.1 0.6796875 87 23 68 1 6 266 121 204 YP_009224047.1 MazG-like pyrophosphatase [Achromobacter phage JWF] diamond 261 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
28425915 28425915 PRJNA1111077_P_NODE_30106_length_251_cov_0.865169_g29885_i0 PRJNA1111077 30106 251 0.865169 2.17157419 uncultured Caudovirales phage 2100421 Viruses Viruses 91.7 2.43e-19   NR CAB4176047.1 2100421 g29885 i0 69.6 2.0199203187251 56 17 66.9 0 250 83 11 66 CAB4176047.1 HNHc domain containing protein [uncultured Caudovirales phage] diamond 507 91.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28646924 28646924 PRJNA1111077_P_NODE_35547_length_243_cov_0.905882_g35326_i0 PRJNA1111077 35547 243 0.905882 2.20129326 Achromobacter phage 2-1 3061295 Viruses Viruses 58.9 1.11e-8   NR WKV22084.1 3061295 g35326 i0 45.3 0.925925925925926 75 37 90.1 2 13 231 6 78 WKV22084.1 hypothetical protein Phage2-1_00084 [Achromobacter phage 2-1] diamond 225 58.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage 2-1
29530939 29530939 PRJNA1111077_P_NODE_26130_length_266_cov_1.321244_g25909_i0 PRJNA1111077 26130 266 1.321244 3.51450904 Pseudomonas phage ZQG1 3032261 Viruses Viruses 82 7.44e-16   NR WID42052.1 3032261 g25909 i0 54.9 0.924812030075188 82 37 92.5 0 5 250 407 488 WID42052.1 tail tape-measure protein [Pseudomonas phage ZQG1] diamond 246 82 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae   Pseudomonas phage ZQG1
30004677 30004677 PRJNA1111077_P_NODE_33711_length_246_cov_0.890173_g33490_i0 PRJNA1111077 33711 246 0.890173 2.18982558 Vibrio phage 5 2963209 Viruses Viruses 128 2.97e-33   NR CAH9012541.1 2963209 g33490 i0 69.1 0.98780487804878 81 25 98.8 0 244 2 284 364 CAH9012541.1 conserved hypothetical protein [Vibrio phage 501E54-1] diamond 243 128 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 501E54-1
30067692 30067692 PRJNA1111077_P_NODE_19252_length_289_cov_1.981481_g19031_i0 PRJNA1111077 19252 289 1.981481 5.72648009 Pseudoalteromonas phage H1 2845949 Viruses Viruses 65.9 4.89e-10   NR YP_009225460.1 1654919 g19031 i0 51.8 0.581314878892734 56 27 58.1 0 285 118 138 193 YP_009225460.1 hypothetical protein AXI76_gp026 [Pseudoalteromonas phage H101] diamond 168 65.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Shandongvirus Shandongvirus H101
30162323 30162323 PRJNA1111077_P_NODE_34972_length_244_cov_0.900585_g34751_i0 PRJNA1111077 34972 244 0.900585 2.1974274 Myoviridae environmental samples 336724 Viruses Viruses 51.2 9.02e-6   NR AGC37616.1 336724 g34751 i0 46.7 0.922131147540984 75 31 89.8 3 15 233 68 135 AGC37616.1 DNA polymerase, partial [Myoviridae environmental samples] diamond 225 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae environmental samples
30321078 30321078 PRJNA1111077_P_NODE_28652_length_256_cov_2.103825_g28431_i0 PRJNA1111077 28652 256 2.103825 5.385792 Erythrobactor phage vB_EliS-R16L 3368494 Viruses Viruses 90.5 5.86e-19   NR XMP32157.1 3368494 g28431 i0 72.4 1.21875 58 16 68 0 175 2 14 71 XMP32157.1 DUF2800 domain-containing protein [Erythrobactor phage vB_EliS-R16L] diamond 312 90.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Erythrobactor phage vB_EliS-R16L
30478603 30478603 PRJNA1111077_P_NODE_19033_length_290_cov_1.354839_g18812_i0 PRJNA1111077 19033 290 1.354839 3.9290331 Caudoviricetes sp. 2832643 Viruses Viruses 62 5.86e-9   NR XOR05763.1 2832643 g18812 i0 48.5 0.682758620689655 66 34 68.3 0 198 1 1 66 XOR05763.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 198 62 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30478606 30478606 PRJNA1111077_P_NODE_21453_length_282_cov_1.473684_g21232_i0 PRJNA1111077 21453 282 1.473684 4.15578888 Caudoviricetes sp. 2832643 Viruses Viruses 146 2.02e-41   NR XOS26557.1 2832643 g21232 i0 71 0.98936170212766 93 27 98.9 0 3 281 137 229 XOS26557.1 MAG: neck protein [Caudoviricetes sp.] diamond 279 146 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30668046 30668046 PRJNA1111077_P_NODE_30773_length_250_cov_0.870056_g30552_i0 PRJNA1111077 30773 250 0.870056 2.17514 Achromobacter phage JWF 1589748 Viruses Viruses 58.5 1.11e-7   NR YP_009224049.1 1589748 g30552 i0 45.1 0.984 82 45 98.4 0 246 1 226 307 YP_009224049.1 chromosome segregation protein [Achromobacter phage JWF] diamond 246 58.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF
30857562 30857562 PRJNA1111077_P_NODE_34994_length_244_cov_0.900585_g34773_i0 PRJNA1111077 34994 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 153 2.01e-43   NR XOR08214.1 2832643 g34773 i0 88.9 0.995901639344262 81 9 99.6 0 1 243 67 147 XOR08214.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 243 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31196055 31196055 PRJNA1111077_P_NODE_10115_length_371_cov_1.852349_g9894_i0 PRJNA1111077 10115 371 1.852349 6.87221479 root 1 Root_unresolved Root_unresolved 180 1.24e-53   NR YP_009996962.1 1852622 g9894 i0 70.8 7.35040431266846 130 31 99.5 1 369 1 4 133 YP_009996962.1 minor tail protein [Xanthomonas phage Xoo-sp2] diamond 2727 180 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae Xooduovirus Xooduovirus Xoosp2
31300068 31300068 PRJNA1111077_P_NODE_21135_length_283_cov_1.466667_g20914_i0 PRJNA1111077 21135 283 1.466667 4.15066761 Caudoviricetes sp. 2832643 Viruses Viruses 155 1.14e-41   NR XOQ87974.1 2832643 g20914 i0 75.3 2.95759717314488 93 23 98.6 0 5 283 311 403 XOQ87974.1 MAG: tail fiber protein [Caudoviricetes sp.] diamond 837 155 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31647810 31647810 PRJNA1111077_P_NODE_36577_length_241_cov_0.916667_g36356_i0 PRJNA1111077 36577 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 70.5 6.25e-13   NR XOR11136.1 2832643 g36356 i0 59.5 1.9792531120332 79 31 98.3 1 3 239 29 106 XOR11136.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 477 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32534078 32534078 PRJNA1111077_P_NODE_25759_length_267_cov_1.587629_g25538_i0 PRJNA1111077 25759 267 1.587629 4.23896943 Caudoviricetes sp. 2832643 Viruses Viruses 62 8.23e-9   NR XOR83182.1 2832643 g25538 i0 39 0.921348314606742 82 48 92.1 1 20 265 853 932 XOR83182.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] diamond 246 62 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32659728 32659728 PRJNA1111077_P_NODE_20580_length_285_cov_1.316038_g20359_i0 PRJNA1111077 20580 285 1.316038 3.7507083 uncultured Caudovirales phage 2100421 Viruses Viruses 53.9 5.93e-7   NR CAB4163101.1 2100421 g20359 i0 56.1 0.431578947368421 41 17 42.1 1 120 1 13 53 CAB4163101.1 HNHc domain containing protein [uncultured Caudovirales phage] diamond 123 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32754444 32754444 PRJNA1111077_P_NODE_32440_length_248_cov_0.880000_g32219_i0 PRJNA1111077 32440 248 0.88 2.1824 Vibrio phage vB_VpS_PG 2733996 Viruses Viruses 102 5.49e-23   NR YP_009808543.1 2301664 g32219 i0 55.6 2.93951612903226 81 36 98 0 5 247 652 732 YP_009808543.1 ribonucleotide reductase of class Ia (aerobic), alpha subunit [Vibrio phage vB_VpS_PG07] diamond 729 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Demerecviridae Pogseptimavirus Pogseptimavirus PG07

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