RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1012699 · 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
27730202 27730202 PRJNA1012699_P_NODE_344_length_576_cov_1.079523_g314_i0 PRJNA1012699 344 576 1.079523 6.21805248 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 244 6.38e-71   NR WWZ85593.1 3132542 g314 i0 62.7 1.00520833333333 193 62 99.5 3 2 574 2404 2588 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 579 244 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
28108577 28108577 PRJNA1012699_P_NODE_1345_length_324_cov_2.342629_g1313_i0 PRJNA1012699 1345 324 2.342629 7.59011796 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 115 2.14e-27   NR WWZ85593.1 3132542 g1313 i0 73.6 0.666666666666667 72 19 66.7 0 3 218 2910 2981 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 216 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
28234804 28234804 PRJNA1012699_P_NODE_1746_length_293_cov_1.054545_g1714_i0 PRJNA1012699 1746 293 1.054545 3.08981685 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 110 8.11e-26   NR WWZ85593.1 3132542 g1714 i0 71.8 0.870307167235495 85 24 87 0 255 1 4 88 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 255 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
28266400 28266400 PRJNA1012699_P_NODE_2326_length_265_cov_1.432292_g2294_i0 PRJNA1012699 2326 265 1.432292 3.7955738 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 147 8.07e-39   NR WWZ85593.1 3132542 g2294 i0 79.3 0.984905660377358 87 18 98.5 0 263 3 1602 1688 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 261 147 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
28866493 28866493 PRJNA1012699_P_NODE_1088_length_354_cov_1.106762_g1056_i0 PRJNA1012699 1088 354 1.106762 3.91793748 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 110 1.81e-25   NR WWZ85593.1 3132542 g1056 i0 50.4 0.991525423728814 117 46 89 3 352 38 797 913 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 351 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
28961504 28961504 PRJNA1012699_P_NODE_528_length_475_cov_2.238806_g496_i0 PRJNA1012699 528 475 2.238806 10.6343285 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 240 4.97e-70   NR WWZ85593.1 3132542 g496 i0 69.8 1.00421052631579 159 46 99.2 1 3 473 2592 2750 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 477 240 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
29655472 29655472 PRJNA1012699_P_NODE_3550_length_245_cov_1.354651_g3518_i0 PRJNA1012699 3550 245 1.354651 3.31889495 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 134 2.42e-34   NR WWZ85593.1 3132542 g3518 i0 79 0.991836734693878 81 17 99.2 0 3 245 2316 2396 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 243 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
30603461 30603461 PRJNA1012699_P_NODE_3033_length_250_cov_0.881356_g3001_i0 PRJNA1012699 3033 250 0.881356 2.20339 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 70.9 5.29e-12   NR WWZ85593.1 3132542 g3001 i0 47.9 0.852 71 37 85.2 0 213 1 475 545 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 213 70.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
30698307 30698307 PRJNA1012699_P_NODE_1394_length_319_cov_1.231707_g1362_i0 PRJNA1012699 1394 319 1.231707 3.92914533 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 142 7.409999999999999e-37   NR WWZ85593.1 3132542 g1362 i0 67.3 0.978056426332288 104 34 97.8 0 7 318 1034 1137 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 312 142 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
30698310 30698310 PRJNA1012699_P_NODE_794_length_403_cov_1.684848_g762_i0 PRJNA1012699 794 403 1.684848 6.78993744 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 122 4.3e-29   NR WWZ85593.1 3132542 g762 i0 41.3 1.40694789081886 189 55 99 5 400 2 1798 1986 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 567 122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
31709998 31709998 PRJNA1012699_P_NODE_1977_length_281_cov_1.471154_g1945_i0 PRJNA1012699 1977 281 1.471154 4.13394274 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 127 1.08e-31   NR WWZ85593.1 3132542 g1945 i0 59.8 0.98220640569395 92 37 98.2 0 278 3 2739 2830 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 276 127 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
32501171 32501171 PRJNA1012699_P_NODE_2539_length_256_cov_1.699454_g2507_i0 PRJNA1012699 2539 256 1.699454 4.35060224 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 100 2.87e-22   NR WWZ85593.1 3132542 g2507 i0 63.1 0.984375 84 30 97.3 1 254 6 1377 1460 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 252 100 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4

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