RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA602115 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
1851414 1851414 PRJNA602115_P_NODE_182_length_1372_cov_6.029748_g171_i0 PRJNA602115 182 1372 6.029748 82.72814256 Pavo cristatus CRESS-DNA-virus sp. 2815049 Viruses Viruses 171 2.06e-46   NR QTE03529.1 2815049 g171 i0 38.9 0.533527696793003 244 146 52.7 2 913 191 10 253 QTE03529.1 MAG: capsid protein [Pavo cristatus CRESS-DNA-virus sp.] diamond 732 171 1 Viruses   Shotokuvirae Cressdnaviricota         Pavo cristatus CRESS-DNA-virus sp.
10779952 10779952 PRJNA602115_P_NODE_1549_length_478_cov_1.688249_g1524_i0 PRJNA602115 1549 478 1.6882490000000001 8.06983022 Genomoviridae sp. 2202565 Viruses Viruses 258 4.999999999999999e-84   NR QJB18631.1 2202565 g1524 i0 82.6 1.01046025104603 161 26 99.8 1 478 2 41 201 QJB18631.1 MAG: capsid protein [Genomoviridae sp.] diamond 483 258 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Genomoviridae sp.
26921772 26921772 PRJNA602115_P_NODE_8582_length_212_cov_1.125828_g8557_i0 PRJNA602115 8582 212 1.125828 2.38675536 Cressdnaviricota sp. 2748378 Viruses Viruses 50.8 3.01e-5   NR UOF80144.1 2748378 g8557 i0 44.9 0.976415094339623 69 37 96.2 1 3 206 53 121 UOF80144.1 capsid protein [Cressdnaviricota sp.] diamond 207 50.8 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
27680495 27680495 PRJNA602115_P_NODE_7804_length_225_cov_1.560976_g7779_i0 PRJNA602115 7804 225 1.560976 3.512196 Cressdnaviricota sp. 2748378 Viruses Viruses 53.5 3.57e-6   NR WAE42348.1 2748378 g7779 i0 48.8 2.33333333333333 43 22 57.3 0 5 133 217 259 WAE42348.1 MAG: capsid protein [Cressdnaviricota sp.] diamond 525 53.5 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
28248318 28248318 PRJNA602115_P_NODE_3866_length_313_cov_1.519841_g3841_i0 PRJNA602115 3866 313 1.519841 4.75710233 Cressdnaviricota sp. 2748378 Viruses Viruses 60.1 3.37e-8   NR UOF81913.1 2748378 g3841 i0 38.1 1.08306709265176 113 57 99.7 5 312 1 34 142 UOF81913.1 hypothetical protein [Cressdnaviricota sp.] diamond 339 60.1 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29353745 29353745 PRJNA602115_P_NODE_11669_length_201_cov_0.914286_g11644_i0 PRJNA602115 11669 201 0.914286 1.83771486 Smacoviridae sp. 2715094 Viruses Viruses 42.4 0.0285   NR XNT20915.1 2715094 g11644 i0 44.8 1 67 27 88.1 2 2 178 299 363 XNT20915.1 MAG: capsid protein [Smacoviridae sp.] diamond 201 42.4 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cremevirales Smacoviridae   Smacoviridae sp.
30079770 30079770 PRJNA602115_P_NODE_5972_length_260_cov_1.567839_g5947_i0 PRJNA602115 5972 260 1.567839 4.0763814 Cressdnaviricota sp. 2748378 Viruses Viruses 47 0.00126   NR AXH73954.1 2748378 g5947 i0 40.7 0.680769230769231 59 33 65.8 2 10 180 200 258 AXH73954.1 MAG: hypothetical protein [Cressdnaviricota sp.] diamond 177 47 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
32053078 32053078 PRJNA602115_P_NODE_1538_length_480_cov_1.589499_g1513_i0 PRJNA602115 1538 480 1.589499 7.6295952 Galvornvirus 2948715 Viruses Viruses 55.5 6.15e-6   NR AXQ66182.1 1954248 g1513 i0 42.3 0.71875 78 43 47.5 2 244 17 23 100 AXQ66182.1 MAG: helicase [Circoviridae sp.] diamond 345 55.5 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
32514733 32514733 PRJNA602115_P_NODE_10219_length_205_cov_0.888889_g10194_i0 PRJNA602115 10219 205 0.888889 1.82222245 Bovine faeces associated smacovirus 5 1843753 Viruses Viruses 56.2 3.58e-7   NR YP_009252317.1 1843753 g10194 i0 58.3 0.702439024390244 48 19 70.2 1 60 203 212 258 YP_009252317.1 putative capsid protein [Bovine faeces associated smacovirus 5] diamond 144 56.2 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cremevirales Smacoviridae Drosmacovirus Drosmacovirus bovas1
32703486 32703486 PRJNA602115_P_NODE_4840_length_286_cov_1.133333_g4815_i0 PRJNA602115 4840 286 1.133333 3.24133238 Cressdnaviricota sp. 2748378 Viruses Viruses 56.2 7.56e-7   NR AXQ65663.1 2748378 g4815 i0 34.1 0.923076923076923 88 57 91.3 1 263 3 58 145 AXQ65663.1 MAG: capsid protein [Cressdnaviricota sp.] diamond 264 56.2 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota 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);;