RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 3

tax_superkingdom 1

  • Viruses · 32 ✖

bioproject 1

  • PRJNA1174207 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
10518941 10518941 PRJNA1174207_P_NODE_10549_length_467_cov_1.172589_g10023_i0 PRJNA1174207 10549 467 1.172589 5.47599063 Caudoviricetes sp. 2832643 Viruses Viruses 159 1.12e-41   NR XOS58798.1 2832643 g10023 i0 59.4 0.995717344753747 155 60 99.6 1 2 466 616 767 XOS58798.1 MAG: tape measure protein [Caudoviricetes sp.] diamond 465 159 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
11794284 11794284 PRJNA1174207_P_NODE_29950_length_265_cov_1.270833_g29421_i0 PRJNA1174207 29950 265 1.270833 3.36770745 Caudoviricetes sp. 2832643 Viruses Viruses 82.4 2.72e-17   NR XOS01517.1 2832643 g29421 i0 51.1 0.99622641509434 88 43 99.6 0 264 1 1 88 XOS01517.1 MAG: hypothetical protein MSP1228_70 [Caudoviricetes sp.] diamond 264 82.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
18167604 18167604 PRJNA1174207_P_NODE_8215_length_551_cov_2.110879_g7691_i0 PRJNA1174207 8215 551 2.110879 11.63094329 Marnaviridae sp. 2715102 Viruses Viruses 291 2.05e-94   NR QRI44260.1 2715102 g7691 i0 78.1 0.996370235934664 183 40 99.6 0 551 3 181 363 QRI44260.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] diamond 549 291 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
21992048 21992048 PRJNA1174207_P_NODE_178_length_3993_cov_402.771429_g129_i0 PRJNA1174207 178 3993 402.771429 16082.66315997 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 2459 0   NR ULP78342.1 2697049 g129 i0 98.3 9.5717505634861 1277 15 95.4 1 3945 136 1 1277 ULP78342.1 surface glycoprotein [Severe acute respiratory syndrome coronavirus 2] diamond 38220 2459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26692226 26692226 PRJNA1174207_P_NODE_31861_length_257_cov_1.298913_g31332_i0 PRJNA1174207 31861 257 1.298913 3.33820641 Microbacterium phage Aesir 2767554 Viruses Viruses 123 2.31e-30   NR QNN98612.1 2767554 g31332 i0 66.7 0.980544747081712 84 28 98.1 0 252 1 707 790 QNN98612.1 DNA primase/helicase [Microbacterium phage Aesir] diamond 252 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Krampusvirus Microbacterium phage Aesir
26692230 26692230 PRJNA1174207_P_NODE_9241_length_508_cov_2.604598_g8716_i0 PRJNA1174207 9241 508 2.604598 13.23135784 Picornaviridae sp. 1530251 Viruses Viruses 266 5.39e-79   NR URG14835.1 1530251 g8716 i0 78.6 0.992125984251969 168 36 99.2 0 506 3 1448 1615 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 504 266 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
26723466 26723466 PRJNA1174207_P_NODE_24141_length_289_cov_2.393519_g23612_i0 PRJNA1174207 24141 289 2.393519 6.91726991 Stenotrophomonas phage B2 2936871 Viruses Viruses 130 6.539999999999999e-37   NR URG13003.1 2936871 g23612 i0 85.2 0.84083044982699 81 12 84.1 0 42 284 1 81 URG13003.1 hypothetical protein B2_10 [Stenotrophomonas phage B2] diamond 243 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage B2
27261887 27261887 PRJNA1174207_P_NODE_42043_length_238_cov_2.593939_g41514_i0 PRJNA1174207 42043 238 2.593939 6.17357482 Caudoviricetes sp. 2832643 Viruses Viruses 108 1.79e-25   NR XOR99870.1 2832643 g41514 i0 75.6 0.983193277310924 78 19 98.3 0 2 235 756 833 XOR99870.1 MAG: putative tail fiber protein H [Caudoviricetes sp.] diamond 234 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27420009 27420009 PRJNA1174207_P_NODE_17203_length_344_cov_2.162362_g16674_i0 PRJNA1174207 17203 344 2.162362 7.43852528 uncultured Caudovirales phage 2100421 Viruses Viruses 71.2 1.11e-11   NR CAB4139992.1 2100421 g16674 i0 37.8 0.968023255813954 111 61 96.8 2 337 5 53 155 CAB4139992.1 HELICc domain containing protein [uncultured Caudovirales phage] diamond 333 71.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27956597 27956597 PRJNA1174207_P_NODE_43425_length_220_cov_4.585034_g42896_i0 PRJNA1174207 43425 220 4.585034 10.0870748 Thermus phage MN1 3018631 Viruses Viruses 83.6 2.15e-17   NR BDX35518.1 3018631 g42896 i0 89.1 1.2 46 5 62.7 0 3 140 217 262 BDX35518.1 hypothetical protein MN1_510 [Thermus phage MN1] diamond 264 83.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage MN1
28019847 28019847 PRJNA1174207_P_NODE_6365_length_656_cov_1.814751_g5850_i0 PRJNA1174207 6365 656 1.814751 11.90476656 Picornaviridae sp. 1530251 Viruses Viruses 301 1.66e-90   NR URG14835.1 1530251 g5850 i0 67 0.996951219512195 218 71 99.7 1 655 2 1188 1404 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 654 301 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28146186 28146186 PRJNA1174207_P_NODE_8605_length_534_cov_1.845987_g8081_i0 PRJNA1174207 8605 534 1.845987 9.85757058 Picornaviridae sp. 1530251 Viruses Viruses 265 2.67e-78   NR URG14835.1 1530251 g8081 i0 65.7 0.98314606741573 175 59 97.8 1 530 9 324 498 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 525 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28240511 28240511 PRJNA1174207_P_NODE_26366_length_280_cov_1.227053_g25837_i0 PRJNA1174207 26366 280 1.227053 3.4357484 uncultured Caudovirales phage 2100421 Viruses Viruses 97.4 1.35e-23   NR CAB4143479.1 2100421 g25837 i0 54.8 3.19285714285714 73 33 78.2 0 4 222 56 128 CAB4143479.1 GIY-YIG_SegABCDEFG domain containing protein [uncultured Caudovirales phage] diamond 894 97.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28588215 28588215 PRJNA1174207_P_NODE_38967_length_244_cov_0.900585_g38438_i0 PRJNA1174207 38967 244 0.900585 2.1974274 Pseudomonas phage PaMx74 1175663 Viruses Viruses 52.4 1.5e-5   NR YP_009199510.1 1175663 g38438 i0 41.9 1.56147540983607 62 36 76.2 0 196 11 262 323 YP_009199510.1 exonuclease [Pseudomonas phage PaMx74] diamond 381 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae Cinvestavvirus Cinvestavvirus PaMx74
28840508 28840508 PRJNA1174207_P_NODE_40128_length_243_cov_0.905882_g39599_i0 PRJNA1174207 40128 243 0.905882 2.20129326 uncultured Caudovirales phage 2100421 Viruses Viruses 79 2.22e-15   NR CAB4125162.1 2100421 g39599 i0 46.8 0.975308641975309 79 42 97.5 0 3 239 130 208 CAB4125162.1 hypothetical protein UFOVP54_72 [uncultured Caudovirales phage] diamond 237 79 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28872105 28872105 PRJNA1174207_P_NODE_41168_length_241_cov_1.636905_g40639_i0 PRJNA1174207 41168 241 1.636905 3.94494105 Shenzhen dicistro-like virus 2789378 Viruses Viruses 75.1 1.51e-13   NR QPG92982.1 2789378 g40639 i0 49.5 2.2655601659751 91 32 95.9 1 11 241 991 1081 QPG92982.1 polyprotein [Shenzhen dicistro-like virus] diamond 546 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
29030281 29030281 PRJNA1174207_P_NODE_35588_length_248_cov_1.554286_g35059_i0 PRJNA1174207 35588 248 1.554286 3.85462928 Erysiphe necator associated virga-like virus 13 2743128 Viruses Viruses 57.4 2.78e-7   NR QKN22650.1 2743128 g35059 i0 48.3 0.725806451612903 60 31 72.6 0 3 182 1103 1162 QKN22650.1 RNA-dependent RNA polymerase [Erysiphe necator associated virga-like virus 13] diamond 180 57.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae   Erysiphe necator associated virga-like virus 13
29219624 29219624 PRJNA1174207_P_NODE_26109_length_281_cov_1.355769_g25580_i0 PRJNA1174207 26109 281 1.355769 3.80971089 Arthrobacter phage Ranunculus 3374963 Viruses Viruses 102 1.36e-23   NR XIJ71100.1 3374963 g25580 i0 65.2 0.950177935943061 89 31 95 0 2 268 214 302 XIJ71100.1 minor tail protein [Arthrobacter phage Ranunculus] diamond 267 102 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Arthrobacter phage Ranunculus
29219626 29219626 PRJNA1174207_P_NODE_30589_length_262_cov_1.629630_g30060_i0 PRJNA1174207 30589 262 1.62963 4.2696306 Erysiphe necator associated ssRNA virus 6 2743182 Viruses Viruses 95.5 1.34e-20   NR QKN22649.1 2743182 g30060 i0 51.2 0.984732824427481 86 42 98.5 0 5 262 153 238 QKN22649.1 replicase [Erysiphe necator associated ssRNA virus 6] diamond 258 95.5 1 Viruses               Erysiphe necator associated ssRNA virus 6
29566713 29566713 PRJNA1174207_P_NODE_41870_length_240_cov_2.371257_g41341_i0 PRJNA1174207 41870 240 2.371257 5.6910168 Leviviridae sp. 2027243 Viruses Viruses 131 4.14e-35   NR UJQ85386.1 2027243 g41341 i0 77.9 0.9625 77 17 96.3 0 5 235 203 279 UJQ85386.1 MAG: hypothetical protein 1, partial [Leviviridae sp.] diamond 231 131 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
29629581 29629581 PRJNA1174207_P_NODE_710_length_2258_cov_6.094737_g560_i0 PRJNA1174207 710 2258 6.094737 137.61916146 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 810 1.94e-282   NR XCM67754.1 3003959 g560 i0 60.3 0.919397697077059 692 257 90.6 5 2 2047 215 898 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2076 810 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29945855 29945855 PRJNA1174207_P_NODE_35471_length_248_cov_2.142857_g34942_i0 PRJNA1174207 35471 248 2.142857 5.31428536 Caudoviricetes sp. 2832643 Viruses Viruses 120 3.02e-30   NR XOS13866.1 2832643 g34942 i0 79.3 0.991935483870968 82 17 99.2 0 248 3 111 192 XOS13866.1 MAG: hypothetical protein MSP0123_122 [Caudoviricetes sp.] diamond 246 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29977318 29977318 PRJNA1174207_P_NODE_5351_length_732_cov_3.444613_g4849_i0 PRJNA1174207 5351 732 3.444613 25.21456716 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 156 1.98e-39   NR XCM67754.1 3003959 g4849 i0 55.8 0.565573770491803 138 57 56.6 1 292 705 71 204 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 414 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30893769 30893769 PRJNA1174207_P_NODE_24674_length_287_cov_1.439252_g24145_i0 PRJNA1174207 24674 287 1.439252 4.13065324 Aeromonas phage HJ 3035942 Viruses Viruses 74.7 3.44e-13   NR WEV89374.1 3035942 g24145 i0 39.6 0.951219512195122 91 55 95.1 0 286 14 323 413 WEV89374.1 hypothetical protein H10PHJ05_73 [Aeromonas phage HJ05] diamond 273 74.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage HJ05
30956976 30956976 PRJNA1174207_P_NODE_28694_length_270_cov_1.411168_g28165_i0 PRJNA1174207 28694 270 1.411168 3.8101536 Caudoviricetes sp. 2832643 Viruses Viruses 100 3.2899999999999996e-23   NR XOR07016.1 2832643 g28165 i0 52.8 0.988888888888889 89 41 97.8 1 266 3 236 324 XOR07016.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 267 100 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30956978 30956978 PRJNA1174207_P_NODE_39314_length_244_cov_0.900585_g38785_i0 PRJNA1174207 39314 244 0.900585 2.1974274 Inoviridae sp. 2219103 Viruses Viruses 52.4 7.67e-7   NR XOE96175.1 2219103 g38785 i0 56 1.22950819672131 50 22 61.5 0 4 153 5 54 XOE96175.1 MAG: hypothetical protein [Inoviridae sp.] diamond 300 52.4 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
31430898 31430898 PRJNA1174207_P_NODE_31456_length_258_cov_2.729730_g30927_i0 PRJNA1174207 31456 258 2.72973 7.0427034 Picornaviridae sp. 1530251 Viruses Viruses 65.1 6.14e-10   NR URG14835.1 1530251 g30927 i0 42.1 0.883720930232558 76 43 87.2 1 244 20 844 919 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 228 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31494364 31494364 PRJNA1174207_P_NODE_21256_length_310_cov_0.974684_g20727_i0 PRJNA1174207 21256 310 0.974684 3.0215204 Caudoviricetes sp. 2832643 Viruses Viruses 178 1.88e-49   NR XOS58798.1 2832643 g20727 i0 86.7 0.948387096774194 98 9 94.8 1 294 1 1270 1363 XOS58798.1 MAG: tape measure protein [Caudoviricetes sp.] diamond 294 178 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31747173 31747173 PRJNA1174207_P_NODE_32037_length_256_cov_1.683060_g31508_i0 PRJNA1174207 32037 256 1.68306 4.3086336 uncultured Caudovirales phage 2100421 Viruses Viruses 63.2 2.8e-9   NR CAB4180388.1 2100421 g31508 i0 32.5 0.97265625 83 56 97.3 0 5 253 274 356 CAB4180388.1 hypothetical protein UFOVP1043_28 [uncultured Caudovirales phage] diamond 249 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32000349 32000349 PRJNA1174207_P_NODE_37118_length_246_cov_1.780347_g36589_i0 PRJNA1174207 37118 246 1.780347 4.37965362 Rhodococcus phage Grayson 2182359 Viruses Viruses 60.1 3.65e-9   NR AWN04428.1 2182359 g36589 i0 46.6 0.707317073170732 58 31 70.7 0 2 175 75 132 AWN04428.1 hypothetical protein PBI_GRAYSON_84 [Rhodococcus phage Grayson] diamond 174 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Weaselvirus Rhodococcus phage Grayson
32095247 32095247 PRJNA1174207_P_NODE_20938_length_310_cov_2.957806_g20409_i0 PRJNA1174207 20938 310 2.957806 9.1691986 Caudoviricetes sp. 2832643 Viruses Viruses 58.2 3.43e-8   NR XOR33920.1 2832643 g20409 i0 44.8 1.0258064516129 58 32 56.1 0 134 307 19 76 XOR33920.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 318 58.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32601388 32601388 PRJNA1174207_P_NODE_29000_length_269_cov_1.178571_g28471_i0 PRJNA1174207 29000 269 1.178571 3.17035599 Caudoviricetes sp. 2832643 Viruses Viruses 91.7 1.19e-21   NR DAF83753.1 2832643 g28471 i0 77.4 1.182156133829 53 12 59.1 0 109 267 1 53 DAF83753.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 318 91.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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