RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA835051" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 16 ✖

bioproject 1

  • PRJNA835051 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
12305045 12305045 PRJNA835051_S_NODE_290_length_1108_cov_12.571831_g182_i0 PRJNA835051 290 1108 12.571831 139.29588748 Gammaretrovirus murleu 3428959 Viruses Viruses 653 4.0099999999999987e-233   NR 8WUS_E 11801 g182 i0 98.4 6.97472924187726 322 5 87.2 0 142 1107 19 340 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] diamond 7728 653 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
27559985 27559985 PRJNA835051_S_NODE_37424_length_236_cov_1.233161_g37128_i0 PRJNA835051 37424 236 1.233161 2.91025996 Caudoviricetes sp. 2832643 Viruses Viruses 78.2 1.98e-16   NR XOS05622.1 2832643 g37128 i0 54.2 1.89406779661017 72 30 87.7 1 28 234 2 73 XOS05622.1 MAG: gp71 protein [Caudoviricetes sp.] diamond 447 78.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27749872 27749872 PRJNA835051_S_NODE_82364_length_183_cov_0.792857_g82068_i0 PRJNA835051 82364 183 0.792857 1.45092831 Multiple sclerosis associated retrovirus 62805 Viruses Viruses 59.3 2.44e-8   NR AAB66528.1 62805 g82068 i0 59.6 0.852459016393443 52 21 85.2 0 25 180 81 132 AAB66528.1 polyprotein, partial [Multiple sclerosis associated retrovirus] diamond 156 59.3 1 Viruses Human endogenous retroviruses Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Human endogenous retrovirus W
27852758 27852758 PRJNA835051_S_NODE_664_length_798_cov_12.870199_g473_i0 PRJNA835051 664 798 12.870199 102.70418802 Gammaretrovirus 153135 Viruses Viruses 511 4.2699999999999996e-170   NR NP_040333.1 11795 g473 i0 95.9 4.98872180451128 266 11 100 0 798 1 495 760 NP_040333.1 RNA-dependent DNA polymerase, partial [Friend murine leukemia virus] diamond 3981 516 0.99031007751938 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
28223039 28223039 PRJNA835051_S_NODE_5146_length_386_cov_3.338192_g4851_i0 PRJNA835051 5146 386 3.338192 12.88542112 Caudoviricetes sp. 2832643 Viruses Viruses 72 2.9e-12   NR XOR80200.1 2832643 g4851 i0 40.8 0.800518134715026 103 59 78.5 2 4 306 132 234 XOR80200.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 309 72 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28515968 28515968 PRJNA835051_S_NODE_24467_length_263_cov_2.372727_g24171_i0 PRJNA835051 24467 263 2.372727 6.24027201 root 1 Root_unresolved Root_unresolved 70.9 6.04e-12   NR CAA76882.1 45617 g24171 i0 39.1 5.97718631178707 87 53 99.2 0 261 1 329 415 CAA76882.1 pol protein [Human endogenous retrovirus K] diamond 1572 70.9 1 Viruses Human endogenous retroviruses Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Human endogenous retrovirus K
29044306 29044306 PRJNA835051_S_NODE_81528_length_183_cov_2.357143_g81232_i0 PRJNA835051 81528 183 2.357143 4.31357169 Caudoviricetes sp. 2832643 Viruses Viruses 47.8 1.43e-5   NR DAM60462.1 2832643 g81232 i0 65.6 0.524590163934426 32 11 52.5 0 110 15 1 32 DAM60462.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 96 47.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29075891 29075891 PRJNA835051_S_NODE_50028_length_217_cov_1.086207_g49732_i0 PRJNA835051 50028 217 1.086207 2.35706919 Abalone asfa-like virus 2839893 Viruses Viruses 45.8 0.00205   NR BCY04678.1 2839893 g49732 i0 33.3 0.663594470046083 48 32 66.4 0 64 207 97 144 BCY04678.1 hypothetical protein [Abalone asfa-like virus] diamond 144 45.8 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Asfuvirales Asfarviridae   Abalone asfa-like virus
29643672 29643672 PRJNA835051_S_NODE_52770_length_213_cov_1.717647_g52474_i0 PRJNA835051 52770 213 1.717647 3.65858811 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 1.42e-8   NR DAZ11227.1 2832643 g52474 i0 51.1 0.661971830985915 47 23 66.2 0 34 174 248 294 DAZ11227.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 141 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29675273 29675273 PRJNA835051_S_NODE_28990_length_252_cov_2.258373_g28694_i0 PRJNA835051 28990 252 2.258373 5.69109996 Mytilus Mediterranean mussel adintovirus 2609860 Viruses Viruses 48.1 5.47e-4   NR DAC81352.1 2609860 g28694 i0 47.7 0.523809523809524 44 16 44 1 126 16 421 464 DAC81352.1 TPA_asm: PolB [Mytilus Mediterranean mussel adintovirus] diamond 132 48.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Mytilus Mediterranean mussel adintovirus
29738508 29738508 PRJNA835051_S_NODE_80750_length_184_cov_1.517730_g80454_i0 PRJNA835051 80750 184 1.51773 2.7926232 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 43.1 0.0124   NR YP_010840939.1 2951531 g80454 i0 55.3 0.766304347826087 47 20 75 1 164 27 14 60 YP_010840939.1 L protein [Hardyhead chuvirus] diamond 141 43.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
30907886 30907886 PRJNA835051_S_NODE_24094_length_264_cov_2.257919_g23798_i0 PRJNA835051 24094 264 2.257919 5.96090616 Gordonia phage Ghobes 1887647 Viruses Viruses 43.1 0.019   NR YP_009281156.1 1887647 g23798 i0 39 0.670454545454545 59 36 67 0 84 260 10 68 YP_009281156.1 deoxyuridine triphosphatase [Gordonia phage Ghobes] diamond 177 43.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Ghobesvirus Ghobesvirus ghobes
31318516 31318516 PRJNA835051_S_NODE_70795_length_193_cov_1.586667_g70499_i0 PRJNA835051 70795 193 1.586667 3.06226731 Podoviridae sp. ctLUJ1 2656710 Viruses Viruses 43.1 0.00505   NR QGH72803.1 2656710 g70499 i0 44.4 0.839378238341969 54 27 83.9 2 27 188 1 51 QGH72803.1 MAG: protein of unknown function DUF4326 [Podoviridae sp. ctLUJ1] diamond 162 43.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Schitoviridae   Podoviridae sp. ctLUJ1
32339617 32339617 PRJNA835051_S_NODE_88459_length_178_cov_1.059259_g88163_i0 PRJNA835051 88459 178 1.059259 1.88548102 Viruses 10239 Viruses Viruses 59.3 7.1e-9   NR WPJ72093.1 3079598 g88163 i0 47.4 1.93820224719101 57 30 96.1 0 173 3 53 109 WPJ72093.1 hypothetical protein DEEACLCL_00076 [Salmonella phage CRW-SP2] diamond 345 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Ackermannviridae   Salmonella phage CRW-SP2
32584119 32584119 PRJNA835051_S_NODE_87719_length_178_cov_2.414815_g87423_i0 PRJNA835051 87719 178 2.414815 4.2983707 Bacteriophage sp. 38018 Viruses Viruses 100 3.23e-23   NR UWG86828.1 38018 g87423 i0 80 1.85393258426966 55 11 92.7 0 178 14 294 348 UWG86828.1 MAG: hypothetical protein [Bacteriophage sp.] diamond 330 100 1 Viruses               Bacteriophage sp.
32898642 32898642 PRJNA835051_S_NODE_65360_length_198_cov_8.470968_g65064_i0 PRJNA835051 65360 198 8.470968 16.77251664 Pimephales minnow adintovirus 2609864 Viruses Viruses 67.4 1.52e-11   NR DAC81394.1 2609864 g65064 i0 62.5 0.727272727272727 48 18 72.7 0 55 198 7 54 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 144 67.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus

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