RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA312107" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 33 ✖

bioproject 1

  • PRJNA312107 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
1652438 1652438 PRJNA312107_P_NODE_25942_length_162_cov_0.920354_g25776_i0 PRJNA312107 25942 162 0.920354 1.49097348 Terrestrivirus sp. 2487775 Viruses Viruses 71.6 7.83e-13   NR AYV76614.1 2487775 g25776 i0 66.7 0.888888888888889 48 16 88.9 0 17 160 330 377 AYV76614.1 MAG: AAA family ATPase [Terrestrivirus sp.] diamond 144 71.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
27010883 27010883 PRJNA312107_P_NODE_21922_length_166_cov_0.888889_g21756_i0 PRJNA312107 21922 166 0.888889 1.47555574 uncultured marine virus 186617 Viruses Viruses 45.4 0.00142   NR AKH46995.1 186617 g21756 i0 75 0.506024096385542 28 5 50.6 1 81 164 17 42 AKH46995.1 phage terminase, large subunit [uncultured marine virus] diamond 84 45.4 1 Viruses               uncultured marine virus
27264017 27264017 PRJNA312107_P_NODE_25023_length_163_cov_0.912281_g24857_i0 PRJNA312107 25023 163 0.912281 1.48701803 uncultured Caudovirales phage 2100421 Viruses Viruses 77.8 5.52e-15   NR CAB4242046.1 2100421 g24857 i0 77.8 0.993865030674847 54 12 99.4 0 2 163 367 420 CAB4242046.1 hypothetical protein UFOVP86_29 [uncultured Caudovirales phage] diamond 162 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27327188 27327188 PRJNA312107_P_NODE_19203_length_169_cov_0.866667_g19037_i0 PRJNA312107 19203 169 0.866667 1.46466723 uncultured Caudovirales phage 2100421 Viruses Viruses 62.8 1.13e-9   NR CAB5220804.1 2100421 g19037 i0 51.9 0.923076923076923 52 24 90.5 1 167 15 620 671 CAB5220804.1 hypothetical protein UFOVP247_40 [uncultured Caudovirales phage] diamond 156 62.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27485072 27485072 PRJNA312107_P_NODE_14923_length_189_cov_1.485714_g14757_i0 PRJNA312107 14923 189 1.485714 2.80799946 uncultured Caudovirales phage 2100421 Viruses Viruses 85.5 1.54e-17   NR CAB4219439.1 2100421 g14757 i0 61.7 0.952380952380952 60 23 95.2 0 5 184 6 65 CAB4219439.1 hypothetical protein UFOVP1619_40 [uncultured Caudovirales phage] diamond 180 85.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
27769471 27769471 PRJNA312107_P_NODE_22204_length_166_cov_0.888889_g22038_i0 PRJNA312107 22204 166 0.888889 1.47555574 Arthrobacter phage Shrooms 2015868 Viruses Viruses 62.4 1.73e-10   NR ASR83943.1 2015868 g22038 i0 60 1.80722891566265 50 20 90.4 0 161 12 93 142 ASR83943.1 hypothetical protein SEA_SHROOMS_63 [Arthrobacter phage Shrooms] diamond 300 62.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Laroyevirus Arthrobacter phage Shrooms
28211073 28211073 PRJNA312107_P_NODE_23666_length_164_cov_0.904348_g23500_i0 PRJNA312107 23666 164 0.904348 1.48313072 Caudoviricetes sp. 2832643 Viruses Viruses 62.8 1.08e-9   NR XOF01930.1 2832643 g23500 i0 70.9 1.00609756097561 55 14 97 1 2 160 553 607 XOF01930.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 165 62.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28211074 28211074 PRJNA312107_P_NODE_25706_length_162_cov_0.920354_g25540_i0 PRJNA312107 25706 162 0.920354 1.49097348 Caudoviricetes sp. 2832643 Viruses Viruses 40.8 0.0249   NR XOE95991.1 2832643 g25540 i0 53.5 0.796296296296296 43 20 79.6 0 3 131 77 119 XOE95991.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 129 40.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28274291 28274291 PRJNA312107_P_NODE_22866_length_165_cov_0.896552_g22700_i0 PRJNA312107 22866 165 0.896552 1.4793108 Caudoviricetes sp. 2832643 Viruses Viruses 50.4 2.53e-5   NR XOF03077.1 2832643 g22700 i0 50 3.83636363636364 48 24 87.3 0 147 4 470 517 XOF03077.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 633 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28369047 28369047 PRJNA312107_P_NODE_12946_length_203_cov_0.967532_g12780_i0 PRJNA312107 12946 203 0.967532 1.96408996 Microbacterium phage SBlackberry 2810527 Viruses Viruses 43.9 0.00138   NR UAW08782.1 2810527 g12780 i0 40.4 0.768472906403941 52 30 75.4 1 38 190 7 58 UAW08782.1 membrane protein [Microbacterium phage SBlackberry] diamond 156 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Goodmanvirus Microbacterium phage SBlackberry
28400706 28400706 PRJNA312107_P_NODE_19726_length_168_cov_0.873950_g19560_i0 PRJNA312107 19726 168 0.87395 1.468236 Aminobacter phage Erebus 2686310 Viruses Viruses 42 0.0265   NR QJD54377.1 2686310 g19560 i0 43.6 0.696428571428571 39 22 69.6 0 117 1 445 483 QJD54377.1 DNA primase/helicase [Aminobacter phage Erebus] diamond 117 42 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aminobacter phage Erebus
28463985 28463985 PRJNA312107_P_NODE_21926_length_166_cov_0.888889_g21760_i0 PRJNA312107 21926 166 0.888889 1.47555574 Phage 59_13 2718476 Viruses Viruses 53.5 2.06e-6   NR QOR55584.1 2718476 g21760 i0 68.6 0.632530120481928 35 9 63.3 1 166 62 621 653 QOR55584.1 MAG: hypothetical protein UMS36scaffold28_74 [Phage 59_13] diamond 105 53.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Phage 59_13
28621853 28621853 PRJNA312107_P_NODE_18707_length_169_cov_0.866667_g18541_i0 PRJNA312107 18707 169 0.866667 1.46466723 Sylvanvirus sp. 2487774 Viruses Viruses 53.9 1.3e-6   NR AYV87073.1 2487774 g18541 i0 57.9 0.674556213017751 38 16 67.5 0 136 23 57 94 AYV87073.1 MAG: IS5/IS1182 family transposase [Sylvanvirus sp.] diamond 114 53.9 1 Viruses               Sylvanvirus sp.
28716536 28716536 PRJNA312107_P_NODE_24547_length_163_cov_0.912281_g24381_i0 PRJNA312107 24547 163 0.912281 1.48701803 uncultured Caudovirales phage 2100421 Viruses Viruses 82.8 9.65e-17   NR CAB4164942.1 2100421 g24381 i0 78 0.920245398773006 50 11 92 0 150 1 259 308 CAB4164942.1 hypothetical protein UFOVP833_4 [uncultured Caudovirales phage] diamond 150 82.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29063886 29063886 PRJNA312107_P_NODE_21588_length_166_cov_0.888889_g21422_i0 PRJNA312107 21588 166 0.888889 1.47555574 uncultured Caudovirales phage 2100421 Viruses Viruses 77.8 5.71e-15   NR CAB4130890.1 2100421 g21422 i0 70.9 2.98192771084337 55 14 99.4 1 165 1 190 242 CAB4130890.1 Archaeophage PsiM2, terminase large subunit [uncultured Caudovirales phage] diamond 495 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29190189 29190189 PRJNA312107_P_NODE_17249_length_176_cov_1.070866_g17083_i0 PRJNA312107 17249 176 1.070866 1.88472416 Enterobacteria phage SP 12027 Viruses Viruses 44.7 0.00318   NR ACY07241.1 12027 g17083 i0 44.4 1.84090909090909 54 30 92 0 2 163 85 138 ACY07241.1 replicase [Enterobacteria phage SP] diamond 324 44.7 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Qubevirus Qubevirus faecium
29284595 29284595 PRJNA312107_P_NODE_25549_length_162_cov_0.920354_g25383_i0 PRJNA312107 25549 162 0.920354 1.49097348 Pantoea phage PdC23 2894356 Viruses Viruses 75.9 1.41e-14   NR YP_010676022.1 2894356 g25383 i0 60.4 1.96296296296296 53 21 98.1 0 160 2 84 136 YP_010676022.1 hypothetical protein PQD17_gp18 [Pantoea phage PdC23] diamond 318 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Felixviridae Certevirus Certevirus C23
29347994 29347994 PRJNA312107_P_NODE_22369_length_165_cov_1.732759_g22203_i0 PRJNA312107 22369 165 1.732759 2.85905235 Aeromonas phage PhAER-3 3378350 Viruses Viruses 43.5 0.00683   NR XKC23269.1 3378350 g22203 i0 41.5 0.963636363636364 53 31 96.4 0 2 160 142 194 XKC23269.1 hypothetical protein IHJGLLLJ_00090 [Aeromonas phage PhAER-3] diamond 159 43.5 1 Viruses               Aeromonas phage PhAER-3
29821271 29821271 PRJNA312107_P_NODE_18951_length_169_cov_0.866667_g18785_i0 PRJNA312107 18951 169 0.866667 1.46466723 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 45.1 0.0021   NR QTZ83196.1 3003968 g18785 i0 64.5 0.550295857988166 31 11 55 0 1 93 299 329 QTZ83196.1 MAG: capsid protein [Grus japonensis parvo-like hybrid virus] diamond 93 45.1 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Lineavirales Oomyviridae Nicoomyvirus Fish-associated parvo-like hybrid virus
29821275 29821275 PRJNA312107_P_NODE_26131_length_162_cov_0.920354_g25965_i0 PRJNA312107 26131 162 0.920354 1.49097348 uncultured Caudovirales phage 2100421 Viruses Viruses 56.6 1.62e-7   NR CAB4131609.1 2100421 g25965 i0 69 0.777777777777778 42 12 77.8 1 37 162 792 832 CAB4131609.1 hypothetical protein UFOVP127_178 [uncultured Caudovirales phage] diamond 126 56.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
30200412 30200412 PRJNA312107_P_NODE_25052_length_163_cov_0.912281_g24886_i0 PRJNA312107 25052 163 0.912281 1.48701803 Microvirus sp. 2202559 Viruses Viruses 53.1 7.61e-7   NR WNK14860.1 2202559 g24886 i0 52.9 1.84049079754601 51 18 93.9 1 5 157 82 126 WNK14860.1 MAG: internal scaffolding protein [Microvirus sp.] diamond 300 53.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30295845 30295845 PRJNA312107_P_NODE_21852_length_166_cov_0.888889_g21686_i0 PRJNA312107 21852 166 0.888889 1.47555574 Synechococcus phage S-MS29 3038209 Viruses Viruses 45.4 6.16e-4   NR WLW37028.1 3038209 g21686 i0 51.4 1.19277108433735 35 17 63.3 0 106 2 52 86 WLW37028.1 baseplate wedge subunit [Synechococcus phage S-MS29] diamond 198 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Kyanoviridae   Synechococcus phage S-MS29
30471160 30471160 PRJNA312107_P_NODE_19193_length_169_cov_0.866667_g19027_i0 PRJNA312107 19193 169 0.866667 1.46466723 Moovirus 3044769 Viruses Viruses 68.6 1.04e-11   NR YP_010657804.1 2886042 g19027 i0 68.8 1.70414201183432 48 15 85.2 0 167 24 307 354 YP_010657804.1 tail spike protein [Shigella virus Moo19] diamond 288 68.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Moovirus Moovirus moo
30945026 30945026 PRJNA312107_P_NODE_15614_length_185_cov_1.477941_g15448_i0 PRJNA312107 15614 185 1.477941 2.73419085 root 1 Root_unresolved Root_unresolved 92.4 5.39e-20   NR CAB4132060.1 2100421 g15448 i0 63.8 1.88108108108108 58 21 94.1 0 184 11 509 566 CAB4132060.1 DNA-directed DNA polymerase, family A, palm domain containing protein [uncultured Caudovirales phage] diamond 348 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
31211232 31211232 PRJNA312107_P_NODE_23175_length_165_cov_0.896552_g23009_i0 PRJNA312107 23175 165 0.896552 1.4793108 Zebrafish jaw poxvirus RQ14 Viruses Viruses 42 0.0244   NR BCT22717.1 RQ14 g23009 i0 40 0.818181818181818 45 26 80 1 2 133 873 917 BCT22717.1 B22R family protein [Carp edema virus] diamond 135 42 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
31528098 31528098 PRJNA312107_P_NODE_6076_length_288_cov_1.305439_g5910_i0 PRJNA312107 6076 288 1.305439 3.75966432 Zebrafish jaw poxvirus RQ14 Viruses Viruses 50.8 8.59e-5   NR BCT22628.1 RQ14 g5910 i0 36.2 0.71875 69 43 71.9 1 287 81 197 264 BCT22628.1 hypothetical protein [Carp edema virus] diamond 207 50.8 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae   Zebrafish jaw poxvirus
32002500 32002500 PRJNA312107_P_NODE_20838_length_167_cov_0.881356_g20672_i0 PRJNA312107 20838 167 0.881356 1.47186452 uncultured Caudovirales phage 2100421 Viruses Viruses 83.2 4.08e-17   NR CAB5220989.1 2100421 g20672 i0 65.5 1.97604790419162 55 19 98.8 0 166 2 255 309 CAB5220989.1 WbuX, N-acetyl sugar amidotransferase [uncultured Caudovirales phage] diamond 330 83.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32083287 32083287 PRJNA312107_P_NODE_19878_length_168_cov_0.873950_g19712_i0 PRJNA312107 19878 168 0.87395 1.468236 Schitoviridae 2842329 Viruses Viruses 80.1 8.95e-16   NR YP_009889590.1 2178928 g19712 i0 66 1.91071428571429 53 18 94.6 0 9 167 504 556 YP_009889590.1 DNA polymerase [Erwinia phage phiEaP8] diamond 321 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae Yonginvirus Yonginvirus EaP8
32666397 32666397 PRJNA312107_P_NODE_22160_length_166_cov_0.888889_g21994_i0 PRJNA312107 22160 166 0.888889 1.47555574 Caudoviricetes sp. 2832643 Viruses Viruses 57 1.21e-7   NR UOF80514.1 2832643 g21994 i0 65.2 0.831325301204819 46 14 79.5 1 136 5 68 113 UOF80514.1 hypothetical protein [Caudoviricetes sp.] diamond 138 57 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32666399 32666399 PRJNA312107_P_NODE_24660_length_163_cov_0.912281_g24494_i0 PRJNA312107 24660 163 0.912281 1.48701803 Pseudomonas phage M6 2911432 Viruses Viruses 81.6 2.46e-16   NR YP_001294554.1 2911432 g24494 i0 75.5 0.901840490797546 49 12 90.2 0 1 147 515 563 YP_001294554.1 ribonucleotide reductase [Pseudomonas phage M6] diamond 147 81.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae Yuavirus Yuavirus M6
32729454 32729454 PRJNA312107_P_NODE_11120_length_217_cov_1.547619_g10954_i0 PRJNA312107 11120 217 1.547619 3.35833323 Beihai levi-like virus 19 1922404 Viruses Viruses 49.7 9.53e-5   NR APG76985.1 1922404 g10954 i0 42.6 0.84331797235023 61 32 84.3 1 216 34 21 78 APG76985.1 hypothetical protein [Beihai levi-like virus 19] diamond 183 49.7 1 Viruses               Beihai levi-like virus 19
32760889 32760889 PRJNA312107_P_NODE_25980_length_162_cov_0.920354_g25814_i0 PRJNA312107 25980 162 0.920354 1.49097348 Psittacidae aveparvovirus 2794556 Viruses Viruses 43.9 0.00498   NR WGL41068.1 2794556 g25814 i0 37 1 54 26 94.4 2 156 4 9 57 WGL41068.1 replication protein [Psittaciform aveparvovirus] diamond 162 43.9 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae Aveparvovirus Psittacidae aveparvovirus
32855290 32855290 PRJNA312107_P_NODE_24840_length_163_cov_0.912281_g24674_i0 PRJNA312107 24840 163 0.912281 1.48701803 uncultured Caudovirales phage 2100421 Viruses Viruses 48.5 1.11e-4   NR CAB4197866.1 2100421 g24674 i0 62.2 0.680981595092024 37 14 68.1 0 3 113 207 243 CAB4197866.1 DEXDc domain containing protein [uncultured Caudovirales phage] diamond 111 48.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch

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