RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJNA293022" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJNA293022 · 34 ✖

analysis 1

  • diamond · 34 ✖

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
26884531 26884531 PRJNA293022_P_NODE_77561_length_163_cov_0.912281_g76824_i0 PRJNA293022 77561 163 0.912281 1.48701803 Caudoviricetes sp. 2832643 Viruses Viruses 50.4 1.66e-5   NR DAZ18155.1 2832643 g76824 i0 41.2 0.938650306748466 51 25 84.7 1 138 1 64 114 DAZ18155.1 MAG TPA: protein of unknown function (DUF5565) [Caudoviricetes sp.] diamond 153 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27074171 27074171 PRJNA293022_P_NODE_14142_length_380_cov_3.108761_g13405_i0 PRJNA293022 14142 380 3.108761 11.8132918 Burkholderia phage FLC9 2906467 Viruses Viruses 139 4.31e-39   NR BDD79844.1 2906467 g13405 i0 60 0.907894736842105 115 46 90.8 0 3 347 59 173 BDD79844.1 hypothetical protein [Burkholderia phage FLC9] diamond 345 139 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
27074174 27074174 PRJNA293022_P_NODE_45882_length_206_cov_1.318471_g45145_i0 PRJNA293022 45882 206 1.318471 2.71605026 Burkholderia phage FLC9 2906467 Viruses Viruses 87 5.7e-18   NR BDD79548.1 2906467 g45145 i0 63.1 0.946601941747573 65 24 94.7 0 8 202 383 447 BDD79548.1 hypothetical protein [Burkholderia phage FLC9] diamond 195 87 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
27136969 27136969 PRJNA293022_P_NODE_65042_length_172_cov_1.268293_g64305_i0 PRJNA293022 65042 172 1.268293 2.18146396 Caudoviricetes sp. 2832643 Viruses Viruses 50.8 1.85e-5   NR DAL46637.1 2832643 g64305 i0 60 0.697674418604651 40 16 69.8 0 171 52 82 121 DAL46637.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] diamond 120 50.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27643061 27643061 PRJNA293022_P_NODE_51424_length_194_cov_2.124138_g50687_i0 PRJNA293022 51424 194 2.124138 4.12082772 Vibrio phage pTD1 1938577 Viruses Viruses 129 1.48e-33   NR YP_009599400.1 1938577 g50687 i0 95.3 1.97938144329897 64 3 99 0 2 193 274 337 YP_009599400.1 DNA helicase [Vibrio phage pTD1] diamond 384 129 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Tidunavirus Tidunavirus pTD1
27674643 27674643 PRJNA293022_P_NODE_53844_length_190_cov_1.099291_g53107_i0 PRJNA293022 53844 190 1.099291 2.0886529 Caudoviricetes sp. 2832643 Viruses Viruses 42.7 0.0189   NR DAI06949.1 2832643 g53107 i0 26.7 0.947368421052632 60 44 94.7 0 1 180 442 501 DAI06949.1 MAG TPA: ribonucleotide-diphosphate reductase subunit beta [Caudoviricetes sp.] diamond 180 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27706384 27706384 PRJNA293022_P_NODE_45704_length_206_cov_2.611465_g44967_i0 PRJNA293022 45704 206 2.611465 5.3796179 Ralstonia phage RSF1 1689679 Viruses Viruses 69.3 9.57e-12   NR YP_009207861.2 1689679 g44967 i0 60.9 1.44174757281553 46 18 67 0 203 66 449 494 YP_009207861.2 ribonuclease [Ralstonia phage RSF1] diamond 297 69.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Chiangmaivirus Chiangmaivirus RSF1
27990293 27990293 PRJNA293022_P_NODE_69085_length_168_cov_0.873950_g68348_i0 PRJNA293022 69085 168 0.87395 1.468236 Burkholderia phage FLC9 2906467 Viruses Viruses 78.6 3.04e-15   NR BDD79900.1 2906467 g68348 i0 65.5 0.982142857142857 55 19 98.2 0 166 2 307 361 BDD79900.1 hypothetical protein [Burkholderia phage FLC9] diamond 165 78.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
28211012 28211012 PRJNA293022_P_NODE_69626_length_168_cov_0.873950_g68889_i0 PRJNA293022 69626 168 0.87395 1.468236 Vibrio phage USC-1 2592615 Viruses Viruses 90.1 1.3e-19   NR YP_009847865.1 2592615 g68889 i0 74.5 2.94642857142857 55 14 98.2 0 2 166 37 91 YP_009847865.1 virion structural protein [Vibrio phage USC-1] diamond 495 90.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Aphroditevirus Aphroditevirus USC1
28779390 28779390 PRJNA293022_P_NODE_74047_length_165_cov_0.896552_g73310_i0 PRJNA293022 74047 165 0.896552 1.4793108 Burkholderia phage FLC9 2906467 Viruses Viruses 75.1 4.94e-14   NR BDD79546.1 2906467 g73310 i0 53.8 0.945454545454545 52 24 94.5 0 3 158 559 610 BDD79546.1 hypothetical protein [Burkholderia phage FLC9] diamond 156 75.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
28969066 28969066 PRJNA293022_P_NODE_75868_length_164_cov_0.904348_g75131_i0 PRJNA293022 75868 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 80.1 1.35e-16   NR DAR17196.1 2832643 g75131 i0 77.4 0.969512195121951 53 12 97 0 4 162 120 172 DAR17196.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 159 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29252899 29252899 PRJNA293022_P_NODE_75169_length_164_cov_1.356522_g74432_i0 PRJNA293022 75169 164 1.356522 2.22469608 Photobacterium phage PDCC-1 2664246 Viruses Viruses 63.2 7.96e-10   NR YP_009853500.1 2664246 g74432 i0 73.9 0.841463414634146 46 12 84.1 0 26 163 2307 2352 YP_009853500.1 tail fiber protein [Photobacterium phage PDCC-1] diamond 138 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Aphroditevirus Aphroditevirus PDCC1
29347931 29347931 PRJNA293022_P_NODE_35949_length_233_cov_1.576087_g35212_i0 PRJNA293022 35949 233 1.576087 3.67228271 Burkholderia phage FLC9 2906467 Viruses Viruses 96.7 3.44e-21   NR BDD79521.1 2906467 g35212 i0 59.2 0.978540772532189 76 31 97.9 0 231 4 481 556 BDD79521.1 hypothetical protein [Burkholderia phage FLC9] diamond 228 96.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30042568 30042568 PRJNA293022_P_NODE_56751_length_185_cov_1.117647_g56014_i0 PRJNA293022 56751 185 1.117647 2.06764695 Burkholderia phage FLC9 2906467 Viruses Viruses 71.2 1.51e-12   NR BDD79548.1 2906467 g56014 i0 51.7 0.972972972972973 60 28 97.3 1 180 1 305 363 BDD79548.1 hypothetical protein [Burkholderia phage FLC9] diamond 180 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30232159 30232159 PRJNA293022_P_NODE_7552_length_520_cov_3.142251_g6832_i0 PRJNA293022 7552 520 3.142251 16.3397052 Burkholderia phage FLC9 2906467 Viruses Viruses 116 1.2e-26   NR BDD79611.1 2906467 g6832 i0 38.1 1.01538461538462 176 104 99.2 2 517 2 258 432 BDD79611.1 hypothetical protein [Burkholderia phage FLC9] diamond 528 116 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30359063 30359063 PRJNA293022_P_NODE_39632_length_222_cov_0.976879_g38895_i0 PRJNA293022 39632 222 0.976879 2.16867138 Caudoviricetes sp. 2832643 Viruses Viruses 83.6 1.21e-16   NR XOR35162.1 2832643 g38895 i0 58.9 1.97297297297297 73 30 98.6 0 4 222 364 436 XOR35162.1 MAG: virion structural protein [Caudoviricetes sp.] diamond 438 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30408080 30408080 PRJNA293022_P_NODE_79613_length_162_cov_0.920354_g78876_i0 PRJNA293022 79613 162 0.920354 1.49097348 Viruses 10239 Viruses Viruses 63.2 7.07e-10   NR SBV38404.1 1857647 g78876 i0 73.2 1.55555555555556 41 11 75.9 0 145 23 320 360 SBV38404.1 Phage protein [Phage NCTB] diamond 252 63.5 0.995275590551181 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Phage NCTB
30422145 30422145 PRJNA293022_P_NODE_79353_length_162_cov_0.920354_g78616_i0 PRJNA293022 79353 162 0.920354 1.49097348 Burkholderia phage FLC9 2906467 Viruses Viruses 42.7 0.0128   NR BDD79610.1 2906467 g78616 i0 39.6 0.888888888888889 48 29 88.9 0 159 16 147 194 BDD79610.1 hypothetical protein [Burkholderia phage FLC9] diamond 144 42.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30484993 30484993 PRJNA293022_P_NODE_35953_length_233_cov_1.538043_g35216_i0 PRJNA293022 35953 233 1.538043 3.58364019 Burkholderia phage FLC9 2906467 Viruses Viruses 84.7 5.38e-17   NR BDD79544.1 2906467 g35216 i0 52 2.79399141630901 75 35 95.3 1 226 5 336 410 BDD79544.1 hypothetical protein [Burkholderia phage FLC9] diamond 651 84.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30800763 30800763 PRJNA293022_P_NODE_11294_length_426_cov_2.546419_g10557_i0 PRJNA293022 11294 426 2.546419 10.84774494 Burkholderia phage FLC9 2906467 Viruses Viruses 148 2.6999999999999995e-38   NR BDD79611.1 2906467 g10557 i0 58.7 0.767605633802817 109 45 76.8 0 417 91 623 731 BDD79611.1 hypothetical protein [Burkholderia phage FLC9] diamond 327 148 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
30944999 30944999 PRJNA293022_P_NODE_34014_length_240_cov_1.078534_g33277_i0 PRJNA293022 34014 240 1.078534 2.5884816 Aphroditevirus 2560092 Viruses Viruses 120 1.59e-29   NR YP_009847828.1 2592615 g33277 i0 77.1 2.8125 70 16 87.5 0 26 235 488 557 YP_009847828.1 hypothetical protein HWC35_gp092 [Vibrio phage USC-1] diamond 675 121 0.991735537190083 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Aphroditevirus Aphroditevirus USC1
31022095 31022095 PRJNA293022_P_NODE_50635_length_196_cov_1.047619_g49898_i0 PRJNA293022 50635 196 1.047619 2.05333324 Burkholderia phage FLC9 2906467 Viruses Viruses 49.7 2.53e-5   NR BDD79881.1 2906467 g49898 i0 43.8 0.979591836734694 64 34 98 1 195 4 51 112 BDD79881.1 hypothetical protein [Burkholderia phage FLC9] diamond 192 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
31085277 31085277 PRJNA293022_P_NODE_33375_length_242_cov_2.077720_g32638_i0 PRJNA293022 33375 242 2.07772 5.0280824 Caudoviricetes sp. 2832643 Viruses Viruses 59.3 5.45e-8   NR XOR33695.1 2832643 g32638 i0 55.2 0.71900826446281 58 24 71.9 1 237 64 2039 2094 XOR33695.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 174 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31496507 31496507 PRJNA293022_P_NODE_43376_length_212_cov_1.263804_g42639_i0 PRJNA293022 43376 212 1.263804 2.67926448 Caudoviricetes sp. 2832643 Viruses Viruses 76.3 3.79e-14   NR XOR96103.1 2832643 g42639 i0 48.6 1.0188679245283 72 35 99.1 1 2 211 91 162 XOR96103.1 MAG: virion structural protein [Caudoviricetes sp.] diamond 216 76.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31654263 31654263 PRJNA293022_P_NODE_65037_length_172_cov_1.268293_g64300_i0 PRJNA293022 65037 172 1.268293 2.18146396 Burkholderia phage FLC9 2906467 Viruses Viruses 60.8 5.65e-9   NR BDD79599.1 2906467 g64300 i0 64.3 0.732558139534884 42 15 73.3 0 143 18 733 774 BDD79599.1 hypothetical protein [Burkholderia phage FLC9] diamond 126 60.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
31717705 31717705 PRJNA293022_P_NODE_45017_length_208_cov_1.295597_g44280_i0 PRJNA293022 45017 208 1.295597 2.69484176 Caudoviricetes sp. 2832643 Viruses Viruses 75.9 4.54e-14   NR XOR60093.1 2832643 g44280 i0 48.5 2.89903846153846 68 35 98.1 0 3 206 368 435 XOR60093.1 MAG: virion structural protein [Caudoviricetes sp.] diamond 603 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31812583 31812583 PRJNA293022_P_NODE_33457_length_242_cov_1.072539_g32720_i0 PRJNA293022 33457 242 1.072539 2.59554438 Ralstonia phage RSL2 1585840 Viruses Viruses 65.5 2.32e-10   NR YP_009212877.1 1585840 g32720 i0 46 2.23140495867769 63 34 78.1 0 241 53 225 287 YP_009212877.1 virion structural protein [Ralstonia phage RSL2] diamond 540 65.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Chiangmaivirus Chiangmaivirus RSL2
31893453 31893453 PRJNA293022_P_NODE_50577_length_196_cov_1.353741_g49840_i0 PRJNA293022 50577 196 1.353741 2.65333236 Viruses 10239 Viruses Viruses 87 5.02e-18   NR XOR35087.1 2832643 g49840 i0 58.5 3.97959183673469 65 27 99.5 0 195 1 159 223 XOR35087.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 780 87.4 0.995423340961098 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32129181 32129181 PRJNA293022_P_NODE_75298_length_164_cov_0.982609_g74561_i0 PRJNA293022 75298 164 0.982609 1.61147876 Caudoviricetes sp. 2832643 Viruses Viruses 90.1 2.59e-19   NR DAF07819.1 2832643 g74561 i0 72.2 0.98780487804878 54 15 98.8 0 3 164 100 153 DAF07819.1 MAG TPA: large terminase [Caudoviricetes sp.] diamond 162 90.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32255955 32255955 PRJNA293022_P_NODE_47778_length_202_cov_1.006536_g47041_i0 PRJNA293022 47778 202 1.006536 2.03320272 Caudoviricetes sp. 2832643 Viruses Viruses 60.8 9.14e-9   NR XOR33695.1 2832643 g47041 i0 58.7 0.683168316831683 46 19 68.3 0 7 144 1771 1816 XOR33695.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 138 60.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32540557 32540557 PRJNA293022_P_NODE_17879_length_338_cov_1.252595_g17142_i0 PRJNA293022 17879 338 1.252595 4.2337711 Serratia phage vB_SmaM_ 2 2846179 Viruses Viruses 105 1.2999999999999998e-24   NR YP_009833781.1 2024252 g17142 i0 45.5 0.976331360946746 110 60 97.6 0 8 337 2 111 YP_009833781.1 putative endonuclease [Serratia phage vB_SmaM_ 2050HW] diamond 330 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Moabitevirus Moabitevirus mv2050HW
32603461 32603461 PRJNA293022_P_NODE_75680_length_164_cov_0.904348_g74943_i0 PRJNA293022 75680 164 0.904348 1.48313072 Vibrio phage pTD1 1938577 Viruses Viruses 45.4 0.00138   NR YP_009599382.1 1938577 g74943 i0 50.9 1.9390243902439 53 19 97 1 160 2 34 79 YP_009599382.1 phage capsid and scaffold [Vibrio phage pTD1] diamond 318 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Tidunavirus Tidunavirus pTD1
32634646 32634646 PRJNA293022_P_NODE_34560_length_238_cov_1.089947_g33823_i0 PRJNA293022 34560 238 1.089947 2.59407386 Burkholderia phage FLC9 2906467 Viruses Viruses 110 3.77e-26   NR BDD79599.1 2906467 g33823 i0 64.6 0.995798319327731 79 28 99.6 0 1 237 308 386 BDD79599.1 hypothetical protein [Burkholderia phage FLC9] diamond 237 110 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
32792124 32792124 PRJNA293022_P_NODE_41280_length_217_cov_2.113095_g40543_i0 PRJNA293022 41280 217 2.113095 4.58541615 Microbacterium phage Endor 2944952 Viruses Viruses 40 0.0451   NR URC17906.1 2944952 g40543 i0 37.8 0.622119815668203 45 25 58.1 1 166 41 22 66 URC17906.1 hypothetical protein SEA_ENDOR_50 [Microbacterium phage Endor] diamond 135 40 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ilzatvirus Microbacterium phage Endor

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