RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 23 ✖

bioproject 1

  • PRJNA608894 · 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
20987453 20987453 PRJNA608894_P_NODE_18317_length_488_cov_1.930120_g17821_i0 PRJNA608894 18317 488 1.93012 9.4189856 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 163 3.8399999999999985e-43   NR XCM68290.1 3003959 g17821 i0 59 4.62909836065574 134 47 77.5 1 486 109 723 856 XCM68290.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 2259 163 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26858970 26858970 PRJNA608894_P_NODE_41441_length_278_cov_1.502439_g40942_i0 PRJNA608894 41441 278 1.502439 4.17678042 Riboviria sp. 2585031 Viruses Viruses 82.8 4.8e-16   NR WXG23541.1 2585031 g40942 i0 49.4 0.830935251798561 77 39 83.1 0 11 241 517 593 WXG23541.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.] diamond 231 82.8 1 Viruses               Riboviria sp.
26890532 26890532 PRJNA608894_P_NODE_51701_length_249_cov_1.573864_g51202_i0 PRJNA608894 51701 249 1.573864 3.91892136 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 155 1.3e-41   NR XCM67774.1 3003959 g51202 i0 87.7 0.975903614457831 81 10 97.6 0 3 245 1017 1097 XCM67774.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 243 155 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26921932 26921932 PRJNA608894_P_NODE_35602_length_302_cov_2.585153_g35103_i0 PRJNA608894 35602 302 2.585153 7.80716206 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 2.94e-32   NR XCM67918.1 3003959 g35103 i0 58.3 3.90397350993377 96 39 95.4 1 300 13 442 536 XCM67918.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1179 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27016776 27016776 PRJNA608894_P_NODE_30142_length_334_cov_2.984674_g29643_i0 PRJNA608894 30142 334 2.984674 9.96881116 Vibrio phage 2 2859310 Viruses Viruses 46.2 0.00511   NR QZI90469.1 2859310 g29643 i0 40 0.763473053892216 85 37 63.8 1 293 81 125 209 QZI90469.1 hypothetical protein MYOV003v1_p0145 [Vibrio phage 207E48.1] diamond 255 46.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae   Vibrio phage 207E48.1
27585661 27585661 PRJNA608894_P_NODE_53244_length_248_cov_0.880000_g52745_i0 PRJNA608894 53244 248 0.88 2.1824 Rasavirus sp. 1930508 Viruses Viruses 51.2 4.21e-5   NR APQ44507.1 1930508 g52745 i0 38.8 0.810483870967742 67 41 81 0 232 32 1024 1090 APQ44507.1 polyprotein, partial [Rasavirus sp.] diamond 201 51.2 1 Viruses               Rasavirus sp.
27775267 27775267 PRJNA608894_P_NODE_23644_length_400_cov_0.941896_g23147_i0 PRJNA608894 23644 400 0.941896 3.767584 Yasminevirus sp. GU-2 3060817 Viruses Viruses 63.5 1.03e-8   NR VBB18358.1 2420051 g23147 i0 33.6 0.8025 107 60 80.3 4 48 368 210 305 VBB18358.1 hypothetical protein YASMINEVIRUS_821 [Yasminevirus sp. GU-2018] diamond 321 63.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Yasminevirus Yasminevirus saudimassiliense
28009417 28009417 PRJNA608894_P_NODE_49725_length_251_cov_1.724719_g49226_i0 PRJNA608894 49725 251 1.724719 4.32904469 Viruses 10239 Viruses Viruses 122 2.8799999999999997e-30   NR YP_009337169.1 1923131 g49226 i0 80.5 1.9601593625498 82 14 98 1 247 2 218 297 YP_009337169.1 hypothetical protein 2 [Hubei picorna-like virus 5] diamond 492 122 1 Viruses               Hubei picorna-like virus 5
28027752 28027752 PRJNA608894_P_NODE_15885_length_546_cov_2.257928_g15391_i0 PRJNA608894 15885 546 2.257928 12.32828688 Riboviria sp. 2585031 Viruses Viruses 229 1.05e-65   NR WXG23541.1 2585031 g15391 i0 58.5 0.967032967032967 176 73 96.7 0 528 1 2 177 WXG23541.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.] diamond 528 229 1 Viruses               Riboviria sp.
28514438 28514438 PRJNA608894_P_NODE_32967_length_315_cov_1.272727_g32468_i0 PRJNA608894 32967 315 1.272727 4.00909005 Viruses 10239 Viruses Viruses 154 6.32e-41   NR APG79016.1 1922902 g32468 i0 61.9 3 105 40 100 0 315 1 975 1079 APG79016.1 hypothetical protein 1 [Hubei leech virus 4] diamond 945 154 1 Viruses               Hubei leech virus 4
28848383 28848383 PRJNA608894_P_NODE_53528_length_247_cov_1.770115_g53029_i0 PRJNA608894 53528 247 1.770115 4.37218405 Stenotrophomonas phage Summit 2859661 Viruses Viruses 123 4.7399999999999996e-32   NR QZI85662.1 2859661 g53029 i0 73.2 0.995951417004049 82 22 99.6 0 246 1 146 227 QZI85662.1 major capsid protein [Stenotrophomonas phage Summit] diamond 246 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Delepquintavirus Stenotrophomonas phage Summit
29385456 29385456 PRJNA608894_P_NODE_15249_length_563_cov_3.036735_g14760_i0 PRJNA608894 15249 563 3.036735 17.09681805 Riboviria sp. 2585031 Viruses Viruses 115 7.480000000000001e-26   NR WXG23541.1 2585031 g14760 i0 38.8 1.00177619893428 188 110 99.6 3 561 1 213 396 WXG23541.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.] diamond 564 115 1 Viruses               Riboviria sp.
29543114 29543114 PRJNA608894_P_NODE_28250_length_350_cov_1.667870_g27751_i0 PRJNA608894 28250 350 1.66787 5.837545 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 144 2.29e-37   NR XCM68314.1 3003959 g27751 i0 56 2.97428571428571 116 51 99.4 0 349 2 135 250 XCM68314.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 1041 144 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29745554 29745554 PRJNA608894_P_NODE_42690_length_273_cov_5.875000_g42191_i0 PRJNA608894 42690 273 5.875 16.03875 Pandoravirus 2060084 Viruses Viruses 56.2 3.72e-7   NR YP_009481299.1 2107707 g42191 i0 50 2.9010989010989 52 26 57.1 0 161 6 84 135 YP_009481299.1 Histone H2B domain containing protein [Pandoravirus macleodensis] diamond 792 56.2 1 Viruses             Pandoravirus Pandoravirus macleodensis
30017063 30017063 PRJNA608894_P_NODE_57831_length_243_cov_0.905882_g57332_i0 PRJNA608894 57831 243 0.905882 2.20129326 Caudoviricetes sp. 2832643 Viruses Viruses 153 3.269999999999999e-42   NR XOQ87102.1 2832643 g57332 i0 88.8 0.987654320987654 80 9 98.8 0 241 2 251 330 XOQ87102.1 MAG: LysA [Caudoviricetes sp.] diamond 240 153 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30079938 30079938 PRJNA608894_P_NODE_27872_length_353_cov_2.389286_g27373_i0 PRJNA608894 27872 353 2.389286 8.43417958 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 184 4.599999999999998e-53   NR XCO49489.1 3003959 g27373 i0 73.3 0.985835694050991 116 31 98.6 0 4 351 381 496 XCO49489.1 MAG: putative ORF1 protein, partial [Picornavirales sp.] diamond 348 184 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30238094 30238094 PRJNA608894_P_NODE_18932_length_476_cov_2.096774_g18436_i0 PRJNA608894 18932 476 2.096774 9.98064424 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 216 1.29e-62   NR XCM68125.1 3003959 g18436 i0 68.2 0.989495798319328 157 48 98.9 2 471 1 597 751 XCM68125.1 MAG: structural polyprotein [Picornavirales sp.] diamond 471 216 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30553885 30553885 PRJNA608894_P_NODE_53873_length_247_cov_0.885057_g53374_i0 PRJNA608894 53873 247 0.885057 2.18609079 Aeromonas phage ZPAH34 2924888 Viruses Viruses 85.5 3.33e-17   NR YP_010675786.1 2924888 g53374 i0 56.6 2.00404858299595 83 32 98.4 3 3 245 50 130 YP_010675786.1 virion structural protein [Aeromonas phage ZPAH34] diamond 495 85.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Chaoshanvirus Chaoshanvirus ZPAH34
30964928 30964928 PRJNA608894_P_NODE_25294_length_379_cov_2.124183_g24797_i0 PRJNA608894 25294 379 2.124183 8.05065357 Qianjiang marna-like virus 61 3347709 Viruses Viruses 142 2.9e-36   NR XHA88155.1 3347709 g24797 i0 58.7 0.997361477572559 126 51 99.7 1 2 379 357 481 XHA88155.1 MAG: putative viral coat protein [Qianjiang marna-like virus 61] diamond 378 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 61
31153974 31153974 PRJNA608894_P_NODE_33575_length_311_cov_2.663866_g33076_i0 PRJNA608894 33575 311 2.663866 8.28462326 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 189 3.17e-53   NR XCM68009.1 3003959 g33076 i0 84.5 1.96784565916399 103 16 99.4 0 3 311 1355 1457 XCM68009.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 612 189 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31944907 31944907 PRJNA608894_P_NODE_8497_length_910_cov_2.497013_g8078_i0 PRJNA608894 8497 910 2.497013 22.7228183 Avian associated calicivirus 6 3067832 Viruses Viruses 96.7 4.28e-18   NR WPR16414.1 3067832 g8078 i0 25.3 0.807692307692308 245 170 79.1 4 180 899 23 259 WPR16414.1 MAG: non-structural polyprotein [Avian associated calicivirus 6] diamond 735 96.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae   Avian associated calicivirus 6
32388012 32388012 PRJNA608894_P_NODE_13519_length_622_cov_3.003643_g13041_i0 PRJNA608894 13519 622 3.003643 18.68265946 Riboviria sp. 2585031 Viruses Viruses 133 5.23e-32   NR WXG23541.1 2585031 g13041 i0 37.6 0.872990353697749 181 112 87.3 1 3 545 605 784 WXG23541.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.] diamond 543 133 1 Viruses               Riboviria sp.
32609342 32609342 PRJNA608894_P_NODE_2860_length_1893_cov_3.184066_g2683_i0 PRJNA608894 2860 1893 3.184066 60.27436938 Riboviria sp. 2585031 Viruses Viruses 497 3.78e-154   NR WXG23541.1 2585031 g2683 i0 43.6 1.00633914421553 635 339 99 8 1876 2 809 1434 WXG23541.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.] diamond 1905 497 1 Viruses               Riboviria 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);;