RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 20 ✖

bioproject 1

  • PRJNA546018 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
13264873 13264873 PRJNA546018_S_NODE_36831_length_255_cov_2.216495_g36506_i0 PRJNA546018 36831 255 2.216495 5.65206225 Moloney murine leukemia virus 11801 Viruses Viruses 125 4.95e-31   NR NP_057933.2 11801 g36506 i0 96.7 2.14117647058824 61 2 71.8 0 64 246 658 718 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 546 125 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
26793129 26793129 PRJNA546018_S_NODE_21521_length_347_cov_3.073427_g21196_i0 PRJNA546018 21521 347 3.073427 10.66479169 Gordonia phage Cafasso 2851095 Viruses Viruses 130 1.27e-36   NR QXN74272.1 2851095 g21196 i0 85.7 0.605187319884726 70 10 60.5 0 118 327 53 122 QXN74272.1 lipoprotein [Gordonia phage Cafasso] diamond 210 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Kruegerviridae Cafassovirus Cafassovirus cafasso
27488756 27488756 PRJNA546018_S_NODE_27163_length_304_cov_1.983539_g26838_i0 PRJNA546018 27163 304 1.983539 6.02995856 Thermus phage TH115 3079687 Viruses Viruses 70.9 1.01e-11   NR WQZ00057.1 3079687 g26838 i0 54.9 0.503289473684211 51 23 50.3 0 28 180 234 284 WQZ00057.1 hypothetical protein [Thermus phage TH115] diamond 153 70.9 1 Viruses               Thermus phage TH115
27930749 27930749 PRJNA546018_S_NODE_55465_length_205_cov_1.000000_g55140_i0 PRJNA546018 55465 205 1 2.05 Caudoviricetes sp. 2832643 Viruses Viruses 80.9 2.89e-16   NR DAR29773.1 2832643 g55140 i0 57.1 2.01951219512195 70 28 99.5 1 204 1 32 101 DAR29773.1 MAG TPA: adenylation DNA ligase-like protein [Caudoviricetes sp.] diamond 414 80.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27962316 27962316 PRJNA546018_S_NODE_42385_length_236_cov_1.291429_g42060_i0 PRJNA546018 42385 236 1.291429 3.04777244 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 112 1.03e-26   NR CAI9858973.1 3048756 g42060 i0 69.9 0.927966101694915 73 22 92.8 0 219 1 136 208 CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] diamond 219 112 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
28688753 28688753 PRJNA546018_S_NODE_59767_length_193_cov_2.583333_g59442_i0 PRJNA546018 59767 193 2.583333 4.98583269 uncultured Caudovirales phage 2100421 Viruses Viruses 96.3 1.41e-21   NR CAB5223320.1 2100421 g59442 i0 66.7 0.979274611398964 63 21 97.9 0 5 193 127 189 CAB5223320.1 hypothetical protein UFOVP383_23 [uncultured Caudovirales phage] diamond 189 96.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28941345 28941345 PRJNA546018_S_NODE_46828_length_222_cov_7.633540_g46503_i0 PRJNA546018 46828 222 7.63354 16.9464588 uncultured Caudovirales phage 2100421 Viruses Viruses 66.2 1.2e-11   NR CAB4168149.1 2100421 g46503 i0 50.8 1.67567567567568 63 31 85.1 0 190 2 36 98 CAB4168149.1 small terminase protein [uncultured Caudovirales phage] diamond 372 66.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29193901 29193901 PRJNA546018_S_NODE_29349_length_290_cov_4.524017_g29024_i0 PRJNA546018 29349 290 4.524017 13.1196493 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 153 3.989999999999999e-41   NR CAI9858974.1 3048756 g29024 i0 76.1 0.910344827586207 88 21 91 0 23 286 516 603 CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] diamond 264 153 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
29888517 29888517 PRJNA546018_S_NODE_53331_length_208_cov_1.326531_g53006_i0 PRJNA546018 53331 208 1.326531 2.75918448 Thermus phage TH115 3079687 Viruses Viruses 45.4 0.00244   NR WQZ00040.1 3079687 g53006 i0 46.7 0.649038461538462 45 23 63.5 1 167 36 187 231 WQZ00040.1 hypothetical protein [Thermus phage TH115] diamond 135 45.4 1 Viruses               Thermus phage TH115
30804616 30804616 PRJNA546018_S_NODE_4994_length_818_cov_9.836196_g4747_i0 PRJNA546018 4994 818 9.836196 80.46008328 Thermus phage MN1 3018631 Viruses Viruses 474 1.8699999999999998e-165   NR BDX35497.1 3018631 g4747 i0 89.8 0.968215158924205 264 27 96.8 0 796 5 94 357 BDX35497.1 hypothetical protein MN1_300 [Thermus phage MN1] diamond 792 474 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage MN1
30836207 30836207 PRJNA546018_S_NODE_55494_length_205_cov_0.902778_g55169_i0 PRJNA546018 55494 205 0.902778 1.8506949 Caudoviricetes sp. 2832643 Viruses Viruses 73.2 4.05e-13   NR DAL08021.1 2832643 g55169 i0 50.7 0.980487804878049 67 33 98 0 203 3 147 213 DAL08021.1 MAG TPA: Chromatin remodeling complex ATPase [Caudoviricetes sp.] diamond 201 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31025884 31025884 PRJNA546018_S_NODE_57795_length_201_cov_4.078571_g57470_i0 PRJNA546018 57795 201 4.078571 8.19792771 Totiviridae sp. 1955172 Viruses Viruses 60.5 1.18e-8   NR WAK77569.1 1955172 g57470 i0 61.4 0.656716417910448 44 17 65.7 0 56 187 1 44 WAK77569.1 MAG: capsid protein [Totiviridae sp.] diamond 132 60.5 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Totiviridae sp.
31183483 31183483 PRJNA546018_S_NODE_52495_length_209_cov_2.250000_g52170_i0 PRJNA546018 52495 209 2.25 4.7025 Caudoviricetes sp. 2832643 Viruses Viruses 79.7 1.79e-15   NR XOS27214.1 2832643 g52170 i0 62.3 0.875598086124402 61 23 87.6 0 186 4 28 88 XOS27214.1 MAG: hypothetical protein MSP0001_22 [Caudoviricetes sp.] diamond 183 79.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31246939 31246939 PRJNA546018_S_NODE_58455_length_198_cov_2.116788_g58130_i0 PRJNA546018 58455 198 2.116788 4.19124024 Thermus phage TH115 3079687 Viruses Viruses 63.2 1.2e-9   NR WQZ00051.1 3079687 g58130 i0 52.8 0.803030303030303 53 25 80.3 0 196 38 71 123 WQZ00051.1 hypothetical protein [Thermus phage TH115] diamond 159 63.2 1 Viruses               Thermus phage TH115
31436719 31436719 PRJNA546018_S_NODE_56036_length_204_cov_1.363636_g55711_i0 PRJNA546018 56036 204 1.363636 2.78181744 Thermus phage phiKo 2301535 Viruses Viruses 102 8.310000000000001e-27   NR AYJ74693.1 2301535 g55711 i0 83.1 0.867647058823529 59 10 86.8 0 26 202 1 59 AYJ74693.1 hypothetical protein phiKo_18 [Thermus phage phiKo] diamond 177 102 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo
31500183 31500183 PRJNA546018_S_NODE_34176_length_266_cov_1.448780_g33851_i0 PRJNA546018 34176 266 1.44878 3.8537548 Moloney murine leukemia virus 11801 Viruses Viruses 167 8.12e-46   NR NP_057933.2 11801 g33851 i0 100 6.39473684210526 81 0 91.4 0 266 24 1083 1163 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 1701 167 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
31752985 31752985 PRJNA546018_S_NODE_53737_length_207_cov_3.835616_g53412_i0 PRJNA546018 53737 207 3.835616 7.93972512 uncultured virus 340016 Viruses Viruses 93.6 3.04e-22   NR QGA72440.1 340016 g53412 i0 71.4 0.91304347826087 63 18 91.3 0 205 17 27 89 QGA72440.1 hypothetical protein [uncultured virus] diamond 189 93.6 1 Viruses               uncultured virus
32480946 32480946 PRJNA546018_S_NODE_6139_length_730_cov_8.167414_g5865_i0 PRJNA546018 6139 730 8.167414 59.6221222 Panax cryptic virus 4 2809267 Viruses Viruses 264 2.7e-82   NR QRG29207.1 2809267 g5865 i0 78.2 0.698630136986301 170 37 69.9 0 25 534 321 490 QRG29207.1 putative CP [Panax cryptic virus 4] diamond 510 264 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Panax cryptic virus 4
32575838 32575838 PRJNA546018_S_NODE_17179_length_396_cov_4.059701_g16854_i0 PRJNA546018 17179 396 4.059701 16.07641596 uncultured Caudovirales phage 2100421 Viruses Viruses 121 2.79e-32   NR CAB4172094.1 2100421 g16854 i0 55.7 0.871212121212121 115 48 87.1 1 359 15 23 134 CAB4172094.1 hypothetical protein UFOVP933_46 [uncultured Caudovirales phage] diamond 345 121 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
32890341 32890341 PRJNA546018_S_NODE_25900_length_312_cov_4.055777_g25575_i0 PRJNA546018 25900 312 4.055777 12.65402424 Caudoviricetes sp. 2832643 Viruses Viruses 55.5 2.93e-6   NR DAK07703.1 2832643 g25575 i0 42.3 0.682692307692308 71 29 59.6 2 62 247 1148 1215 DAK07703.1 MAG TPA: tail protein [Caudoviricetes sp.] diamond 213 55.5 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);;