RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA193544" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA193544 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
27042350 27042350 PRJNA193544_S_NODE_2122_length_187_cov_4.455696_g2107_i0 PRJNA193544 2122 187 4.455696 8.33215152 Forni cryoconite toluca-like virus 2 3367771 Viruses Viruses 64.7 1.2e-10   NR XHY08966.1 3367771 g2107 i0 53.2 0.994652406417112 62 29 99.5 0 187 2 144 205 XHY08966.1 MAG: RNA-dependent RNA polymerase [Forni cryoconite toluca-like virus 2] diamond 186 64.7 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes       Forni cryoconite toluca-like virus 2
27231962 27231962 PRJNA193544_S_NODE_563_length_305_cov_8.478261_g548_i0 PRJNA193544 563 305 8.478261 25.85869605 Nodamuvirales sp. 2809606 Viruses Viruses 110 1.73e-25   NR XKB76550.1 2809606 g548 i0 58.4 1.98688524590164 101 42 99.3 0 1 303 606 706 XKB76550.1 MAG: methyltransferase, partial [Nodamuvirales sp.] diamond 606 110 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Nodamuvirales sp.
29000669 29000669 PRJNA193544_S_NODE_988_length_252_cov_6.627803_g973_i0 PRJNA193544 988 252 6.627803 16.70206356 Nodamuvirales sp. 2809606 Viruses Viruses 157 1.9999999999999998e-42   NR XKB76554.1 2809606 g973 i0 92.5 0.952380952380952 80 6 95.2 0 250 11 74 153 XKB76554.1 MAG: methyltransferase, partial [Nodamuvirales sp.] diamond 240 157 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Nodamuvirales sp.
29207692 29207692 PRJNA193544_S_NODE_1449_length_216_cov_8.834225_g1434_i0 PRJNA193544 1449 216 8.834225 19.081926 Viruses 10239 Viruses Viruses 105 2.1e-24   NR UHS72097.1 2583950 g1434 i0 77.8 1.75 63 14 87.5 0 9 197 611 673 UHS72097.1 MAG: hypothetical protein 1 [Tombusviridae sp.] diamond 378 106 0.990566037735849 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Tombusviridae sp.
29284252 29284252 PRJNA193544_S_NODE_1509_length_213_cov_6.277174_g1494_i0 PRJNA193544 1509 213 6.277174 13.37038062 Tombusviridae sp. 2583950 Viruses Viruses 113 4e-27   NR UHS72097.1 2583950 g1494 i0 77.6 0.943661971830986 67 15 94.4 0 3 203 79 145 UHS72097.1 MAG: hypothetical protein 1 [Tombusviridae sp.] diamond 201 113 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Tombusviridae sp.
29599946 29599946 PRJNA193544_S_NODE_3270_length_154_cov_18.720000_g3255_i0 PRJNA193544 3270 154 18.72 28.8288 Tolivirales sp. 2809914 Viruses Viruses 65.5 1.07e-10   NR WRQ64994.1 2809914 g3255 i0 69.4 0.954545454545455 49 14 95.5 1 154 8 869 916 WRQ64994.1 polyprotein, partial [Tolivirales sp.] diamond 147 65.5 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
29884559 29884559 PRJNA193544_S_NODE_3491_length_150_cov_5.000000_g3476_i0 PRJNA193544 3491 150 5 7.5 Sopoziv virus 3131673 Viruses Viruses 45.1 0.00127   NR WZH61775.1 3131673 g3476 i0 55.6 1.72 36 16 72 0 15 122 139 174 WZH61775.1 MAG: RNA-dependent RNA polymerase, partial [Sopoziv virus] diamond 258 45.1 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Sopoziv virus
30105434 30105434 PRJNA193544_S_NODE_252_length_372_cov_10278.935860_g237_i0 PRJNA193544 252 372 10278.93586 38237.6413992 Flumine noda-like virus 16 2941167 Viruses Viruses 141 1.98e-36   NR UQB76287.1 2941167 g237 i0 58.9 0.903225806451613 112 45 90.3 1 3 338 84 194 UQB76287.1 RNA-dependent RNA polymerase, partial [Flumine noda-like virus 16] diamond 336 141 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales Nodaviridae   Flumine noda-like virus 16
30154665 30154665 PRJNA193544_S_NODE_1132_length_240_cov_8.578199_g1117_i0 PRJNA193544 1132 240 8.578199 20.5876776 Viruses 10239 Viruses Viruses 88.6 2.56e-18   NR WRQ65819.1 2809914 g1117 i0 55.6 1.9 72 31 88.8 1 25 237 446 517 WRQ65819.1 RNA-dependent RNA polymerase, partial [Tolivirales sp.] diamond 456 88.6 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
32128935 32128935 PRJNA193544_S_NODE_998_length_251_cov_11.189189_g983_i0 PRJNA193544 998 251 11.189189 28.08486439 Nodamuvirales sp. 2809606 Viruses Viruses 111 3.27e-26   NR XKB76550.1 2809606 g983 i0 61 0.9800796812749 82 32 98 0 3 248 239 320 XKB76550.1 MAG: methyltransferase, partial [Nodamuvirales sp.] diamond 246 111 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Nodamuvirales sp.
32666063 32666063 PRJNA193544_S_NODE_1740_length_202_cov_11.907514_g1725_i0 PRJNA193544 1740 202 11.907514 24.05317828 Tombusviridae sp. 2583950 Viruses Viruses 125 1.1799999999999999e-31   NR UHS72097.1 2583950 g1725 i0 89.4 0.98019801980198 66 7 98 0 3 200 296 361 UHS72097.1 MAG: hypothetical protein 1 [Tombusviridae sp.] diamond 198 125 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Tombusviridae sp.
32886357 32886357 PRJNA193544_S_NODE_240_length_380_cov_5.299145_g225_i0 PRJNA193544 240 380 5.299145 20.136751 Tolivirales sp. gcode 6 3108923 Viruses Viruses 99.8 6.09e-23   NR WRQ65068.1 3108923 g225 i0 49.2 1.01052631578947 128 55 93.2 1 376 23 31 158 WRQ65068.1 hypothetical protein, partial [Tolivirales sp. gcode 6] diamond 384 99.8 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp. gcode 6

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