RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA348537" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA348537 · 7 ✖

analysis 1

  • diamond · 7 ✖

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