RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1241156" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1241156 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
349814 349814 PRJNA1241156_S_NODE_39801_length_303_cov_1.711538_g39341_i0 PRJNA1241156 39801 303 1.711538 5.18596014 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 56.5 0.002   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g39341 i0 86.275 0.448844884488449 51 7 17 0 1 51 56 106 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 136 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
1624409 1624409 PRJNA1241156_S_NODE_23782_length_351_cov_3.850649_g23322_i0 PRJNA1241156 23782 351 3.850649 13.51577799 Murine astrovirus 1141625 Viruses Viruses 590 5.6799999999999996e-164   NTclustered gi|407179895|gb|JX544745.1| 1141625 g23322 i0 97.143 38.6666666666667 350 9 99 1 3 351 2210 2559 Murine astrovirus strain STL 3, partial genome blastn 13572 590 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Murine astrovirus
2326072 2326072 PRJNA1241156_S_NODE_48502_length_279_cov_3081.097458_g48042_i0 PRJNA1241156 48502 279 3081.097458 8596.26190782 Viruses 10239 Viruses Viruses 56.5 0.002   NTclustered gi|1609530247|gb|MK291481.1| 515176 g48042 i0 100 0.326164874551971 30 0 11 0 216 245 7436 7465 Sapovirus GI isolate 17W1096 ORF1 and ORF2 genes, complete cds blastn 91 56.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Caliciviridae Sapovirus Sapovirus sapporoense
2901062 2901062 PRJNA1241156_S_NODE_60183_length_253_cov_3.333333_g59723_i0 PRJNA1241156 60183 253 3.333333 8.43333249 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 58.4 4.93e-4   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g59723 i0 97.059 0.470355731225296 34 1 13 0 1 34 56 89 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 119 58.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
5453864 5453864 PRJNA1241156_S_NODE_73665_length_210_cov_10.844311_g73205_i0 PRJNA1241156 73665 210 10.844311 22.7730531 Betacoronavirus pandemicum 3418604 Viruses Viruses 73.1 1.41e-8   NTclustered gi|2557646933|emb|OY676332.1| 2697049 g73205 i0 100 21.7 39 0 19 0 3 41 17645 17607 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4557 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
6728033 6728033 PRJNA1241156_S_NODE_57466_length_259_cov_1.486111_g57006_i0 PRJNA1241156 57466 259 1.486111 3.84902749 Dolerus tritici iflavirus 1 3350209 Viruses Viruses 54.7 0.007   NTclustered gi|2833733277|gb|PQ323359.2| 3350209 g57006 i0 96.875 0.231660231660232 32 1 12 0 1 32 57 88 Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds blastn 60 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Dolerus tritici iflavirus 1
8003703 8003703 PRJNA1241156_S_NODE_75187_length_205_cov_4.555556_g74727_i0 PRJNA1241156 75187 205 4.555556 9.3388898 Porcine bastrovirus 2588662 Viruses Viruses 58.4 3.85e-4   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g74727 i0 100 0.28780487804878 31 0 15 0 175 205 43 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 59 58.4 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
9278629 9278629 PRJNA1241156_S_NODE_72908_length_214_cov_5.081871_g72448_i0 PRJNA1241156 72908 214 5.081871 10.87520394 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.001   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g72448 i0 100 0.271028037383178 30 0 14 0 185 214 42 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
11828808 11828808 PRJNA1241156_S_NODE_54250_length_266_cov_1.439462_g53790_i0 PRJNA1241156 54250 266 1.439462 3.82896892 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.007   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g53790 i0 100 0.214285714285714 29 0 11 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
13104271 13104271 PRJNA1241156_S_NODE_71631_length_222_cov_8.614525_g71171_i0 PRJNA1241156 71631 222 8.614525 19.1242455 Betacoronavirus pandemicum 3418604 Viruses Viruses 73.1 1.51e-8   NTclustered gi|2557646933|emb|OY676332.1| 2697049 g71171 i0 100 20.527027027027 39 0 18 0 182 220 17607 17645 Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite blastn 4557 73.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
14379108 14379108 PRJNA1241156_S_NODE_44692_length_289_cov_4871.182927_g44232_i0 PRJNA1241156 44692 289 4871.182927 14077.71865903 Betacoronavirus pandemicum 3418604 Viruses Viruses 113 1.21e-20   NTclustered gi|2165837646|emb|OV197539.1| 2697049 g44232 i0 93.59 42.2283737024221 78 2 27 3 1 78 29948 29874 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 12204 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
14379443 14379443 PRJNA1241156_S_NODE_68272_length_235_cov_2.348958_g67812_i0 PRJNA1241156 68272 235 2.348958 5.5200513 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g67812 i0 100 0.242553191489362 29 0 12 0 207 235 41 13 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
20751829 20751829 PRJNA1241156_S_NODE_66317_length_241_cov_1.080808_g65857_i0 PRJNA1241156 66317 241 1.080808 2.60474728 Porcine bastrovirus 2588662 Viruses Viruses 54.7 0.006   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g65857 i0 100 0.236514522821577 29 0 12 0 1 29 13 41 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
22026795 22026795 PRJNA1241156_S_NODE_46998_length_283_cov_609.904167_g46538_i0 PRJNA1241156 46998 283 609.904167 1726.02879261 Betacoronavirus pandemicum 3418604 Viruses Viruses 115 3.2800000000000003e-21   NTclustered gi|2165835422|emb|OV196488.1| 2697049 g46538 i0 93.59 22.8233215547703 78 3 28 2 206 283 29913 29988 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 6459 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
23301972 23301972 PRJNA1241156_S_NODE_13679_length_397_cov_1.757062_g13219_i0 PRJNA1241156 13679 397 1.757062 6.97553614 Porcine bastrovirus 2588662 Viruses Viruses 56.5 0.003   NTclustered gi|1682068313|gb|MK387176.1| 2588662 g13219 i0 100 0.146095717884131 30 0 8 0 1 30 13 42 Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome blastn 58 56.5 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Stellavirales Astroviridae   Porcine bastrovirus
23302828 23302828 PRJNA1241156_S_NODE_8959_length_433_cov_13.700000_g8503_i0 PRJNA1241156 8959 433 13.7 59.321 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 586 9.269999999999997e-163   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8503 i0 91.686 0.972286374133949 421 34 97 1 3 423 6689 7108 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 421 586 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 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);;