RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA348537" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 14 ✖

bioproject 1

  • PRJNA348537 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
27611966 27611966 PRJNA348537_S_NODE_2384_length_196_cov_4.335404_g2338_i0 PRJNA348537 2384 196 4.335404 8.49739184 Caudoviricetes sp. 2832643 Viruses Viruses 98.6 4.38e-22   NR DAM41230.1 2832643 g2338 i0 79 0.948979591836735 62 13 94.9 0 187 2 78 139 DAM41230.1 MAG TPA: DNA polymerase B, partial [Caudoviricetes sp.] diamond 186 98.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27832814 27832814 PRJNA348537_S_NODE_2244_length_201_cov_1.777108_g2198_i0 PRJNA348537 2244 201 1.777108 3.57198708 Qianjiang marna-like virus 92 3347743 Viruses Viruses 48.9 1.5e-4   NR XHA88211.1 3347743 g2198 i0 37.5 0.835820895522388 56 35 83.6 0 28 195 2287 2342 XHA88211.1 MAG: polyprotein [Qianjiang marna-like virus 92] diamond 168 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 92
28116929 28116929 PRJNA348537_S_NODE_505_length_384_cov_3.816619_g459_i0 PRJNA348537 505 384 3.816619 14.65581696 Caudoviricetes sp. 2832643 Viruses Viruses 127 9.29e-34   NR DAM41232.1 2832643 g459 i0 55.2 0.9765625 125 56 97.7 0 378 4 62 186 DAM41232.1 MAG TPA: head to tail adaptor [Caudoviricetes sp.] diamond 375 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28274799 28274799 PRJNA348537_S_NODE_3226_length_173_cov_3.275362_g3180_i0 PRJNA348537 3226 173 3.275362 5.66637626 Picornaviridae sp. 1530251 Viruses Viruses 48.9 9.7e-5   NR URG14992.1 1530251 g3180 i0 47.4 0.988439306358382 57 29 97.1 1 172 5 86 142 URG14992.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 171 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28306489 28306489 PRJNA348537_S_NODE_2126_length_205_cov_1.141176_g2080_i0 PRJNA348537 2126 205 1.141176 2.3394108 Changjiang picorna-like virus 2 1922791 Viruses Viruses 73.6 3.18e-13   NR YP_009336608.1 1922791 g2080 i0 50.8 0.951219512195122 65 32 95.1 0 10 204 944 1008 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 195 73.6 1 Viruses               Changjiang picorna-like virus 2
28874769 28874769 PRJNA348537_S_NODE_848_length_308_cov_2.677656_g802_i0 PRJNA348537 848 308 2.677656 8.24718048 Picornaviridae sp. 1530251 Viruses Viruses 43.9 0.0316   NR URG14784.1 1530251 g802 i0 30.1 0.905844155844156 93 64 89.6 1 20 295 737 829 URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 279 43.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
30485550 30485550 PRJNA348537_S_NODE_3093_length_176_cov_2.709220_g3047_i0 PRJNA348537 3093 176 2.70922 4.7682272 Marnaviridae sp. 2715102 Viruses Viruses 86.7 5.12e-18   NR ULG00022.1 2715102 g3047 i0 74.1 3.95454545454545 58 15 98.9 0 175 2 1394 1451 ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.] diamond 696 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31117146 31117146 PRJNA348537_S_NODE_3815_length_162_cov_1.708661_g3769_i0 PRJNA348537 3815 162 1.708661 2.76803082 Marnaviridae sp. 2715102 Viruses Viruses 64.3 2.98e-10   NR ULG00022.1 2715102 g3769 i0 50.9 1.01851851851852 55 25 98.1 1 2 160 448 502 ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.] diamond 165 64.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31844683 31844683 PRJNA348537_S_NODE_2337_length_198_cov_1.368098_g2291_i0 PRJNA348537 2337 198 1.368098 2.70883404 Marnaviridae sp. 2715102 Viruses Viruses 42.4 0.0283   NR ULG00016.1 2715102 g2291 i0 37.7 0.924242424242424 61 33 84.8 1 29 196 152 212 ULG00016.1 MAG: hypothetical protein 2 [Marnaviridae sp.] diamond 183 42.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31971309 31971309 PRJNA348537_S_NODE_2478_length_193_cov_1.772152_g2432_i0 PRJNA348537 2478 193 1.772152 3.42025336 Changjiang picorna-like virus 2 1922791 Viruses Viruses 92.4 6.21e-20   NR YP_009336608.1 1922791 g2432 i0 67.7 1.01036269430052 65 18 97.9 2 2 190 49 112 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 195 92.4 1 Viruses               Changjiang picorna-like virus 2
32161391 32161391 PRJNA348537_S_NODE_1238_length_261_cov_5.977876_g1192_i0 PRJNA348537 1238 261 5.977876 15.60225636 Caudoviricetes sp. 2832643 Viruses Viruses 156 3.63e-44   NR DAM41229.1 2832643 g1192 i0 83.9 1 87 14 100 0 1 261 63 149 DAM41229.1 MAG TPA: DNA encapsidation protein, partial [Caudoviricetes sp.] diamond 261 156 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32526789 32526789 PRJNA348537_S_NODE_1459_length_241_cov_2.708738_g1413_i0 PRJNA348537 1459 241 2.708738 6.52805858 Viruses 10239 Viruses Viruses 118 1.08e-28   NR YP_009336608.1 1922791 g1413 i0 71.4 2.87551867219917 77 22 95.9 0 231 1 197 273 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 693 118 1 Viruses               Changjiang picorna-like virus 2
32572734 32572734 PRJNA348537_S_NODE_4379_length_154_cov_2.285714_g4333_i0 PRJNA348537 4379 154 2.285714 3.51999956 Pimephales minnow adintovirus 2609864 Viruses Viruses 60.1 4.57e-9   NR DAC81394.1 2609864 g4333 i0 68.4 0.74025974025974 38 12 74 0 114 1 7 44 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 114 60.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
32761388 32761388 PRJNA348537_S_NODE_1720_length_224_cov_2.153439_g1674_i0 PRJNA348537 1720 224 2.153439 4.82370336 Picornaviridae sp. 1530251 Viruses Viruses 134 2.37e-34   NR URG14784.1 1530251 g1674 i0 82.2 0.977678571428571 73 13 97.8 0 219 1 3 75 URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 219 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;