RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA429937", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 14 ✖

tax_phylum 1

  • Pisuviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 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
427264 427264 PRJNA429937_P_NODE_7001_length_1330_cov_7.739431_g4121_i0 PRJNA429937 7001 1330 7.739431 102.9344323 Soybean thrips picorna-like virus 7 2800859 Viruses Viruses 2152 0   NTclustered gi|1956563416|gb|MT293128.1| 2800859 g4121 i0 99.494 2.75488721804511 1185 3 89 3 125 1308 8960 7778 Soybean thrips picorna-like virus 7 strain STN1 polyprotein (STPLV7_gp1) gene, complete cds blastn 3664 2152 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Soybean thrips picorna-like virus 7
1702591 1702591 PRJNA429937_P_NODE_97702_length_309_cov_3.164286_g75096_i0 PRJNA429937 97702 309 3.164286 9.77764374 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.029   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g75096 i0 100 0.0906148867313916 28 0 9 0 1 28 16 43 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
5529758 5529758 PRJNA429937_P_NODE_155405_length_162_cov_1.924812_g132778_i0 PRJNA429937 155405 162 1.924812 3.11819544 Cripavirus drosophilae 3047809 Viruses Viruses 165 1.66e-36   NTclustered gi|2322367289|gb|OK188767.1| 64279 g132778 i0 97.895 8.25308641975309 95 2 100 0 1 95 4682 4588 Drosophila C virus isolate SMN, complete genome blastn 1337 165 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
8079256 8079256 PRJNA429937_P_NODE_144907_length_197_cov_3.130952_g122280_i0 PRJNA429937 144907 197 3.130952 6.16797544 Cripavirus drosophilae 3047809 Viruses Viruses 348 1.94e-91   NTclustered gi|2322367289|gb|OK188767.1| 64279 g122280 i0 98.477 8.9746192893401 197 3 100 0 1 197 3648 3844 Drosophila C virus isolate SMN, complete genome blastn 1768 348 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
10631001 10631001 PRJNA429937_P_NODE_63089_length_432_cov_6.910670_g42782_i0 PRJNA429937 63089 432 6.91067 29.8540944 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 54.7 0.012   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g42782 i0 100 0.0671296296296296 29 0 7 0 404 432 87 59 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
10631460 10631460 PRJNA429937_P_NODE_90149_length_333_cov_2.325658_g67574_i0 PRJNA429937 90149 333 2.325658 7.74444114 Cripavirus drosophilae 3047809 Viruses Viruses 496 1.21e-135   NTclustered gi|2322367289|gb|OK188767.1| 64279 g67574 i0 99.631 12.4894894894895 271 1 100 0 63 333 6023 6293 Drosophila C virus isolate SMN, complete genome blastn 4159 496 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
11906388 11906388 PRJNA429937_P_NODE_92430_length_325_cov_4.141892_g69844_i0 PRJNA429937 92430 325 4.141892 13.461149 Porcine bastrovirus 2588662 Viruses Viruses 52.8 0.031   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g69844 i0 100 0.0861538461538462 28 0 9 0 1 28 15 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
14454423 14454423 PRJNA429937_P_NODE_103312_length_293_cov_1.121212_g80697_i0 PRJNA429937 103312 293 1.121212 3.28515116 Cripavirus drosophilae 3047809 Viruses Viruses 191 5.52e-44   NTclustered gi|2714662726|gb|OR820583.1| 64279 g80697 i0 99.057 5.35153583617747 106 1 67 0 1 106 8172 8277 Drosophila C virus isolate Davidson2006, complete genome blastn 1568 191 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
14455978 14455978 PRJNA429937_P_NODE_61252_length_441_cov_3.536408_g41303_i0 PRJNA429937 61252 441 3.536408 15.59555928 Cripavirus drosophilae 3047809 Viruses Viruses 765 0   NTclustered gi|2322367289|gb|OK188767.1| 64279 g41303 i0 97.959 12.2199546485261 441 9 100 0 1 441 5445 5885 Drosophila C virus isolate SMN, complete genome blastn 5389 765 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
15728625 15728625 PRJNA429937_P_NODE_148833_length_187_cov_2.025316_g126206_i0 PRJNA429937 148833 187 2.025316 3.78734092 Cripavirus drosophilae 3047809 Viruses Viruses 268 1.46e-67   NTclustered gi|1743646610|gb|MK645239.1| 64279 g126206 i0 91.96 9.57754010695187 199 4 100 1 1 187 7747 7945 Drosophila C virus isolate EB, complete genome blastn 1791 268 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
18278760 18278760 PRJNA429937_P_NODE_63755_length_429_cov_7.600000_g43316_i0 PRJNA429937 63755 429 7.6 32.604 Varroa picorna-like virus 2873563 Viruses Viruses 486 9.569999999999999e-133   NTclustered gi|2111829811|gb|MZ822077.1| 2873563 g43316 i0 91.977 1.38228438228438 349 25 81 3 63 408 7924 7576 MAG: Varroa picorna-like virus isolate No11-Mi016-HLJ2018, complete genome blastn 593 486 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Varroa picorna-like virus
23378643 23378643 PRJNA429937_P_NODE_33699_length_625_cov_2.860738_g20783_i0 PRJNA429937 33699 625 2.860738 17.8796125 Cripavirus drosophilae 3047809 Viruses Viruses 987 0   NTclustered gi|2322367289|gb|OK188767.1| 64279 g20783 i0 94.488 9.1456 635 24 100 3 1 625 4281 3648 Drosophila C virus isolate SMN, complete genome blastn 5716 987 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus drosophilae
27518105 27518105 PRJNA429937_P_NODE_43443_length_544_cov_2.188350_g27761_i0 PRJNA429937 43443 544 2.18835 11.904624 Colletotrichum cliviicola partitivirus 1 3400824 Viruses Viruses 143 1.31e-36   NR XOT41440.1 3400824 g27761 i0 39.1 2.83455882352941 256 81 99.8 4 544 2 248 503 XOT41440.1 RNA-dependent RNA polymerase [Colletotrichum cliviicola partitivirus 1] diamond 1542 143 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Colletotrichum cliviicola partitivirus 1
30360553 30360553 PRJNA429937_P_NODE_63472_length_431_cov_2.199005_g43092_i0 PRJNA429937 63472 431 2.199005 9.47771155 Nigrospora oryzae partitivirus 2 3231912 Viruses Viruses 132 6.24e-33   NR XCK16958.1 3231912 g43092 i0 87 0.960556844547564 69 9 48 0 173 379 437 505 XCK16958.1 RNA-dependent RNA polymerase [Nigrospora oryzae partitivirus 2] diamond 414 132 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Nigrospora oryzae partitivirus 2

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