RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA685607" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 24 ✖

bioproject 1

  • PRJNA685607 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
3217296 3217296 PRJNA685607_P_NODE_69823_length_250_cov_0.870056_g69464_i0 PRJNA685607 69823 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 80.1 2.94e-15   NR XOR18014.1 2832643 g69464 i0 71.2 0.624 52 15 62.4 0 2 157 933 984 XOR18014.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 156 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3217411 3217411 PRJNA685607_P_NODE_96883_length_241_cov_0.916667_g96524_i0 PRJNA685607 96883 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 72 3.69e-14   NR XOQ96255.1 2832643 g96524 i0 62.5 0.697095435684647 56 20 68.5 1 1 165 44 99 XOQ96255.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 168 72 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
9594883 9594883 PRJNA685607_P_NODE_30988_length_326_cov_2.280632_g30629_i0 PRJNA685607 30988 326 2.280632 7.43486032 Dishui Lake large algae virus 1 2704073 Viruses Viruses 174 3.38e-51   NR QIG60113.1 2704073 g30629 i0 80.2 20.4570552147239 106 21 97.5 0 3 320 76 181 QIG60113.1 hypothetical protein [Dishui Lake large algae virus 1] diamond 6669 174 1 Viruses               Dishui Lake large algae virus 1
26607222 26607222 PRJNA685607_P_NODE_45021_length_288_cov_1.432558_g44662_i0 PRJNA685607 45021 288 1.432558 4.12576704 uncultured virus 340016 Viruses Viruses 79.3 8.61e-15   NR CAH6421308.1 340016 g44662 i0 40 0.9375 90 54 93.8 0 285 16 191 280 CAH6421308.1 PQQ-binding beta-propeller repeat protein [uncultured virus] diamond 270 79.3 1 Viruses               uncultured virus
27240179 27240179 PRJNA685607_P_NODE_6503_length_603_cov_1.452830_g6155_i0 PRJNA685607 6503 603 1.45283 8.7605649 Qianjiang picorna-like virus 1 3348691 Viruses Viruses 177 1.28e-47   NR XHA88608.1 3348697 g6155 i0 52.9 0.930348258706468 187 87 92.5 1 46 603 10 196 XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104] diamond 561 177 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 104
27303623 27303623 PRJNA685607_P_NODE_68363_length_250_cov_0.870056_g68004_i0 PRJNA685607 68363 250 0.870056 2.17514 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 112 9.1e-27   NR XCM68232.1 3003959 g68004 i0 60 0.96 80 32 96 0 248 9 698 777 XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 240 112 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28092898 28092898 PRJNA685607_P_NODE_85845_length_244_cov_0.900585_g85486_i0 PRJNA685607 85845 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 142 6.42e-39   NR DAI86612.1 2832643 g85486 i0 88.9 0.885245901639344 72 8 88.5 0 29 244 107 178 DAI86612.1 MAG TPA: large terminase [Caudoviricetes sp.] diamond 216 142 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28535154 28535154 PRJNA685607_P_NODE_60227_length_259_cov_1.241935_g59868_i0 PRJNA685607 60227 259 1.241935 3.21661165 Cycas necrotic stunt virus 173976 Viruses Viruses 86.7 1.61e-17   NR AEN25475.1 173976 g59868 i0 68.7 3.03474903474903 67 16 75.3 2 3 197 1847 1910 AEN25475.1 polyprotein 1, partial [Cycas necrotic stunt virus] diamond 786 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus cycas
28598245 28598245 PRJNA685607_P_NODE_15207_length_416_cov_1.571429_g14849_i0 PRJNA685607 15207 416 1.571429 6.53714464 Dicistroviridae sp. 1955144 Viruses Viruses 77.4 2.03e-13   NR XCO49049.1 1955144 g14849 i0 82.6 0.331730769230769 46 8 33.2 0 3 140 1404 1449 XCO49049.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 138 77.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28787359 28787359 PRJNA685607_P_NODE_3927_length_786_cov_1.701262_g3615_i0 PRJNA685607 3927 786 1.701262 13.37191932 Qianjiang picorna-like virus 1 3348691 Viruses Viruses 152 4.65e-38   NR XHA88608.1 3348697 g3615 i0 37.6 0.984732824427481 258 147 95.4 6 4 753 538 789 XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104] diamond 774 152 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 104
29166643 29166643 PRJNA685607_P_NODE_23829_length_354_cov_2.092527_g23470_i0 PRJNA685607 23829 354 2.092527 7.40754558 Sphingomonas phage vB_StuS_MMDA13 2686378 Viruses Viruses 56.2 8.42e-7   NR YP_010719905.1 2686378 g23470 i0 73.3 0.254237288135593 30 8 25.4 0 90 1 90 119 YP_010719905.1 hypothetical protein P6F35_gp37 [Sphingomonas phage vB_StuS_MMDA13] diamond 90 56.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Torvergatavirus Torvergatavirus MMDA13
29198179 29198179 PRJNA685607_P_NODE_80089_length_246_cov_0.890173_g79730_i0 PRJNA685607 80089 246 0.890173 2.18982558 uncultured Caudovirales phage 2100421 Viruses Viruses 85.1 3.48e-17   NR CAB4170548.1 2100421 g79730 i0 48.1 3.82926829268293 81 42 98.8 0 243 1 11 91 CAB4170548.1 C-methyltransferase [uncultured Caudovirales phage] diamond 942 85.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29671252 29671252 PRJNA685607_P_NODE_79450_length_246_cov_0.890173_g79091_i0 PRJNA685607 79450 246 0.890173 2.18982558 Shigella phage 2 2736192 Viruses Viruses 43.5 0.0187   NR YP_009901425.1 2848074 g79091 i0 42.9 0.51219512195122 42 24 51.2 0 7 132 145 186 YP_009901425.1 DNA methyltransferase [Shigella phage 2019SD1] diamond 126 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Hanrivervirus Hanrivervirus hv2019SD1
30145109 30145109 PRJNA685607_P_NODE_69792_length_250_cov_0.870056_g69433_i0 PRJNA685607 69792 250 0.870056 2.17514 Tupanvirus deep ocean 2126984 Viruses Viruses 64.7 7.74e-10   NR YP_010781233.1 2126984 g69433 i0 48.1 0.924 77 38 90 1 1 225 1667 1743 YP_010781233.1 hypothetical protein QJ856_gp0132 [Tupanvirus deep ocean] diamond 231 64.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus altamarinense
30145110 30145110 PRJNA685607_P_NODE_70472_length_249_cov_0.875000_g70113_i0 PRJNA685607 70472 249 0.875 2.17875 Simiispumavirus caljac 3432450 Viruses Viruses 55.5 1.31e-6   NR 7O0G_A 2170205 g70113 i0 42.3 2.56626506024096 71 39 85.5 1 247 35 377 445 7O0G_A Chain A, Pr125Pol [White-tufted-ear marmoset simian foamy virus] diamond 639 55.5 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Simiispumavirus Simiispumavirus caljac
30367005 30367005 PRJNA685607_P_NODE_61832_length_256_cov_1.311475_g61473_i0 PRJNA685607 61832 256 1.311475 3.357376 Shewanella sp. phage 1/4 1458859 Viruses Viruses 60.1 8.6e-10   NR YP_009100474.1 1458859 g61473 i0 55.2 0.78515625 67 30 78.5 0 204 4 1 67 YP_009100474.1 hypothetical protein S14_170 [Shewanella sp. phage 1/4] diamond 201 60.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Shewanella sp. phage 1/4
30430146 30430146 PRJNA685607_P_NODE_1913_length_1172_cov_2.252047_g1697_i0 PRJNA685607 1913 1172 2.252047 26.39399084 Sanya dicistrovirus 2 2905416 Viruses Viruses 392 3.2599999999999995e-125   NR UHK03102.1 2905416 g1697 i0 51.6 1.01621160409556 397 178 99.8 5 1170 1 296 685 UHK03102.1 MAG: capsid protein [Sanya dicistrovirus 2] diamond 1191 392 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Sanya dicistrovirus 2
31725660 31725660 PRJNA685607_P_NODE_3777_length_802_cov_6.434842_g3471_i0 PRJNA685607 3777 802 6.434842 51.60743284 African cichlid piscichuvirus 3065075 Viruses Viruses 124 4.23e-28   NR WLN26256.1 3065075 g3471 i0 45.3 0.512468827930175 137 75 51.2 0 20 430 98 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 411 124 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
31757363 31757363 PRJNA685607_P_NODE_88257_length_243_cov_1.358824_g87898_i0 PRJNA685607 88257 243 1.358824 3.30194232 Terrestrivirus sp. 2487775 Viruses Viruses 47.4 8.02e-4   NR AYV75785.1 2487775 g87898 i0 36.8 0.938271604938272 76 47 93.8 1 15 242 126 200 AYV75785.1 MAG: hypothetical protein Terrestrivirus3_54 [Terrestrivirus sp.] diamond 228 47.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
31788793 31788793 PRJNA685607_P_NODE_8637_length_526_cov_2.909492_g8282_i0 PRJNA685607 8637 526 2.909492 15.30392792 Sanya dicistrovirus 2 2905416 Viruses Viruses 100 7.890000000000001e-21   NR UHK03102.1 2905416 g8282 i0 42 1.23764258555133 131 74 73.6 1 4 390 737 867 UHK03102.1 MAG: capsid protein [Sanya dicistrovirus 2] diamond 651 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Sanya dicistrovirus 2
31883805 31883805 PRJNA685607_P_NODE_10077_length_491_cov_1.287081_g9721_i0 PRJNA685607 10077 491 1.287081 6.31956771 rice curl dwarf-associated dicistro-like virus 1 3377419 Viruses Viruses 233 1.7899999999999999e-68   NR XFO60888.1 3377419 g9721 i0 75.9 0.989816700610998 162 38 98.4 1 2 484 74 235 XFO60888.1 structural polyprotein [rice curl dwarf-associated dicistro-like virus 1] diamond 486 233 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   rice curl dwarf-associated dicistro-like virus 1
32137131 32137131 PRJNA685607_P_NODE_3718_length_810_cov_1.392130_g3413_i0 PRJNA685607 3718 810 1.39213 11.276253 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 187 8.35e-50   NR AVM87455.1 3063761 g3413 i0 40.4 1.97037037037037 267 146 94.4 4 765 1 761 1026 AVM87455.1 polyprotein [Wenling hoplichthys picornavirus] diamond 1596 187 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
32243887 32243887 PRJNA685607_P_NODE_16098_length_407_cov_1.377246_g15740_i0 PRJNA685607 16098 407 1.377246 5.60539122 Pandoravirus 2060084 Viruses Viruses 82.8 2.1e-15   NR YP_009481523.1 2107707 g15740 i0 39.7 4.00982800982801 136 75 99.5 3 3 407 104 233 YP_009481523.1 hypothetical protein pmac_cds_839 [Pandoravirus macleodensis] diamond 1632 83.6 0.990430622009569 Viruses             Pandoravirus Pandoravirus macleodensis
32831835 32831835 PRJNA685607_P_NODE_32620_length_321_cov_1.241935_g32261_i0 PRJNA685607 32620 321 1.241935 3.98661135 Corynebacterium phage HS 3056390 Viruses Viruses 123 2.8199999999999997e-30   NR WLJ25596.1 3056390 g32261 i0 54.2 1 107 49 100 0 1 321 244 350 WLJ25596.1 MAG: tail fiber [Corynebacterium phage HS03] diamond 321 123 1 Viruses               Corynebacterium phage HS03

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